Support

Akeeba Backup for Joomla!

#11974 Kettenrad :: Attempting to load from database (cli)

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by nicholas on Friday, 13 April 2012 10:32 CDT

[email protected]
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? YEs
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? YEs
Joomla! version: 2.5.4
PHP version: 5.3.3-7+squeeze8
MySQL version: 5.1.61-0+squeeze1-log
Host: Apache/2.2.9
Akeeba Backup version: Akeeba Backup Professional 3.4.3 (2012-03-21)

Description of my issue:

We backup Joomla websites to an FTP with a cron (/usr/bin/php) (CLI version)
Under the same server, all Joomla 1.5 websites are OK, the status is OK at the end.
All Joomla websites 2.5.4 are failed with the same configuration.
2.5.4 websites havent pending status, all the files are copied to the FTP, but I don't now why, 8 minutes after the status is failed, see the date...
Same issue under Debian Lenny and Debian Squeeze.

DEBUG |120413 11:36:54|Closing SQL dump file.
DEBUG |120413 11:44:48|Kettenrad :: Attempting to load from database (cli)
DEBUG |120413 11:44:48| -- Stored Akeeba Factory (cli) not found - hard reset
DEBUG |120413 11:44:48|

Please help !!!

nicholas
Akeeba Staff
Manager
According to your log file, the backup is finished successfully:
DEBUG |120413 11:36:54|Kettenrad :: Just finished

The last two lines are generated when you visit Akeeba Backup's Control Panel. You don't need to know the reason, but you can ignore them. I also don't see any other errors in that log file. Do you see the backup attempts marked as failed in the Administer Backup Files page, or do you get non-working backups?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
I have made 2 tests, 2 sites in 2.5.4 :
First Site : 20 Mo - backup are working with kickstart, but it show failed in akeeba (see picture)
Second site : 200 Mo - Backup are not working kickstart say :
"En-tête invalide dans le fichier archive, partie 0, impression 8"
and the windows Akeeba eXtract Wizard stop at 33% when decompressiong a file.

But, why theses last 2 lines are in the command line log ?!
In 1.5 it's fine ! all sites are ok.

Notice that each file are jps (max 50Mo). The FTP is under the same VLAN.

Best regards

nicholas
Akeeba Staff
Manager
The last lines in the log file appear when you access Akeeba Backup's Control Panel page or start a new backup. When you do that, Akeeba Backup tries to detect "stuck" backups, mark them as failed and delete the (partial) backup files. It does so by iterating through all of your profiles, trying to load the engine state and check for a special flag. The log lines you receive have to do with the attempt to load the engine state. Since your backups are complete, the engine state information file is removed, hence the "hard reset" message; it is perfectly normal, expected and desirable. That's also why you see there is a huge time gap between the last log even and those messages.

As about the "Failed" message in the Administer Backup Files page, the only way I have been able to replicate is when the update of Akeeba Backup was partial and the backup.php file (or some of the engine files) were not overwritten with the new records. The easiest way to fix that is uninstalling Akeeba Backup and reinstalling it. The only drawback is that you will lose your current settings. It's also worth noting that I have never tested Akeeba Backup with PHP 5.3.3, because PHP versions 5.3.2 and 5.3.3 are considered buggy. My tests were conducted with 5.3.1, 5.3.5, 5.3.7, 5.3.9 and 5.3.10. I'd suggest also upgrading your PHP version, in case one of the numerous bugs is affecting Akeeba Backup (I have no way to check that, sorry).

Finally, regarding the extraction, in the case of Kickstart seem to be entering the wrong password. That's why it fails at offset 8 (offset 8 is right after the file header, where the encrypted data starts). Either that, or the target server doesn't have mcrypt installed or doesn't support the AES (Rijndael) encryption scheme in PHP's mcrypt extension. Regarding the Akeeba eXtract Wizard failing after 33% of extracting, I need to know if it has extracted any files, if they are properly named and if their contents are garbled or not. If the filenames or the file contents are garbled, you are entering an incorrect password. If not, you may be missing backup parts (you need the .jps as well as the .j01, .j02 and so on files created during the backup).

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
We have servers under Debien Lenny (old 5.0, will be updated to Squeeze soon) and Squeeze (6.0), so with the last package of php5.
But it's only in 2.5.4 that it's failed !

Now :
- I have uninstalling Akeeba Pro
- Reinstall Akeeba Pro
- Put my JPS secretpassword, 20Mo per file, FTP transfert.
And, it's failed.

The archive is also failed at the same PDF file, very strange ?!

I also try under last PHP version :
INFO |120413 14:00:02|PHP Version :5.3.3-7+squeeze8
INFO |120413 14:00:02|OS Version :Linux
INFO |120413 14:00:02|DB Version :5.1.61-0+squeeze1-log

DEBUG |120413 14:02:58|No need to sleep; execution time: 0.51093101501465 msec; min. exec. time: 0 msec
DEBUG |120413 14:02:58|
DEBUG |120413 14:02:58|
DEBUG |120413 14:02:58|Closing SQL dump file.
DEBUG |120413 14:49:30|Kettenrad :: Attempting to load from database (cli)
DEBUG |120413 14:49:30| -- Stored Akeeba Factory (cli) not found - hard reset
DEBUG |120413 14:49:30|
--- END OF RAW LOG ---

I've attached the log file

Failed also ?!!

nicholas
Akeeba Staff
Manager
The thing is, the log says a different story. According to the log, the backup hasn't failed. The backup is complete and all 10 backup parts (.jps, .j01, ..., .j09) have been transferred by FTP to the remote storage. I don't understand why that backup is listed as failed. I have the same setup on this very site: Joomla! 2.5.4, PHP 5.3.10 (that's our difference) and Akeeba Backup 3.4.3. I am backing up with CLI; it's been months since I last used the back-end backup on this site. My backups are correctly listed as "Remote".

Let's try two more things, if you don't mind:
1. Take a cli backup after disabling the transfer to remote FTP. Does it still list the backup as failed?
2. Try using JPA instead of JPS (and enable the transfer to FTP). Does that list the backup as failed?

This will help me try isolating the reason of the backups displaying as failed, despite having completed correctly.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
I have made a new test, same site under PHP 5.3.3, Joomla 2.5.4 with FTP transfert :
JPA, split at 20Mo : 'Remote' in backend (so ok), Backup also OK when extracting !
JPS, split at 20Mo : 'Failed' in backend and Backup files not OK (hang when extracting at 20% (a PDF), perhaps when Akeeba extract which to another file)

Notice that so for a small 2.5.4 site (only one JPS file ) : Backend OK (show 'Remote') and the backup's file is ok also (extraction)

I have attached a capture of the 2 configuration (JPA and JPS)

[email protected]
Also, something strange, when you disable FTP transfert, in CLI mode, Akeeba create the JPS archives, then, 8 minutes after, delete them all !!!! in /admin/component/com_akeeba/backup/.

=> so to correct this I add to uninstall akeeba and reinstall.

nicholas
Akeeba Staff
Manager
OK, this is getting somewhere. There is certainly a problem with JPS archives. I will take a look into it, but the fix will only make it to the next alpha release (3.5.a1), scheduled for mid- to late May.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
ok. I will look the alpha release so.
Best regards

nicholas
Akeeba Staff
Manager
OK, I just did some more testing.

The Failed status has to do with the way the CLI mode and the JPS format work in Akeeba Backup up to and including 3.4.3. Starting with 3.5.a1 we'll be using Joomla!'s native CLI mode (introduced in Joomla! 1.7) and the backup archives are no longer listed as Failed.

Regarding the JPS extraction, it turns out that the eXtract Wizard support for JPS archives is buggy and I can't fix it. You can, however, use the latest published version of Kickstart to extract those archives that eXtract reports as broken. It's very important to use the correct password. Ideally, the password should only contain lowercase and uppercase letters without accents (a..z, A..Z, but not ç, é and so on), numbers, spaces, dashes, dots and underscores. Anything else has the potential to be translated to UTF-8 by the browser and cause extraction issues.

I hope that helps a bit until I get to the point where I can release a new alpha release.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
Right !!!

kickstart.php work with the JPS created with CLI and multiples files.
Windows eXtract Wizard don't work with the same multiple JPS files :(

So it is just in backend that akeeba show 'failed' but it's not failed...

nicholas
Akeeba Staff
Manager
Yes, that's correct. I can (already have, actually, but the current state of the codebase is not stable enough) fix the "Failed" status for archives generated by the CLI. I just won't be able to fix eXtract Wizard's issues.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!