Support

Akeeba Backup for Joomla!

#13656 PostProcessing

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 Thursday, 27 September 2012 13:06 CDT

daniellevesque
Mandatory information about my setup:
PHP exécuté sur Linux box7.rapidenet.ca 2.6.18-308.13.1.el5 #1 SMP Tue Aug 21 17:10:18 EDT 2012 x86_64
Version de la base de données 5.5.22
Interclassement de la base de données utf8_general_ci
Version de PHP 5.3.13
Serveur web Apache/2
Serveur web pour interface PHP cgi-fcgi
Version de Joomla Joomla! 2.5.7 Stable [ Ember ] 13-September-2012 14:00 GMT
Version de la plateforme Joomla! Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
Navigateur Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:15.0) Gecko/20100101 Firefox/15.0.1

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.7
PHP version: 5.3.13
MySQL version: 5.5.22
Host: Rapidenet (localhost)
Akeeba Backup version: 3.6.5

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue:
I try to postprocess my backup file to my personalcloud (Goflex Home)
I test all my connections ftp an with Filezilla I can transfer anything and with my browser also. In Akeebabackup Pro, the message says that the connection is correct but after my backup, I have a message that transfer fail.
I try to manage the archive after I read the ticket about that but it does not work also. I try all the options in the ticket about fail to postprocess to DropBox. But I do not want to use DropBox, I want to use my 3 TO hard disk.
Where can I try to correct this problem? If I can correct that ...

nicholas
Akeeba Staff
Manager
When checking the FTP connection the following are not checked:
- Initial directory
- Writeable status of the directory
- If you can use passive mode or not

I would suggest checking those options manually, especially the passive mode. Most FTP servers require passive mode.

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!

daniellevesque
Ok thank you very much. The problem was in my selection of the initial directory on my personal cloud. I correct this initial directory and bingo all works well.
All works very fine and well.
Thank you very much for your fast and correct answer.

nicholas
Akeeba Staff
Manager
You're welcome :)

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!

daniellevesque
I had another problem with another site with the same configuration.
The size of backup is 659.7 meg on my local cloud but when the backup ends on the site backend, in the window the backup archive is marked obsolete and the size is 629.16 megs.
The backup file on my personal cloud seems to be correct but I do not know why contrary at other sites (3) the file is indicated as obsolete.
I try to adjust the time at the end of the configuration page at 5 and 7.5 also 180 seconds and 100% but I do not know what is the good recipe for this site.
Can you help me about where I can change the parameters for this site?
I have another site with a huge amount also!
In the log file (joined) I have these messages:
[120926 16:17:02] PHP WARNING on line 270 in file <root>/administrator/components/com_akeeba/akeeba/drivers/mysqli.php:
[120926 16:17:02] Error while sending QUERY packet. PID=16445

Excuse my english.

daniellevesque
I have the same problem with another site.
The size of the file on my personal cloud is 469.1 meg and on the site after the backup and without visible error, I had a file size of 450.61 with obsolete.

The line in the log file attached is:
[120926 16:39:33] PHP WARNING on line 270 in file <root>/administrator/components/com_akeeba/akeeba/drivers/mysqli.php:
[120926 16:39:33] Error while sending QUERY packet. PID=23873

nicholas
Akeeba Staff
Manager
According to your log file you do not have a problem:
DEBUG |120926 16:37:31|AEPostprocFtp:: Connecting to remote FTP

INFO |120926 16:39:33|Finished post-processing file /home/aeetee/domains/aeetee.ca/backup/site-aeetee.ca-20120926-163506.jpa

The FTP transfer took 122 seconds. For a 472497730 bytes archive that's normal. It's an average of 3.7Mb/s – indicating somewhere between 30 and 35 MBit/s connection between the two servers.

The next two lines in the log:
WARNING |120926 16:39:33|PHP WARNING on line 270 in file <root>/administrator/components/com_akeeba/akeeba/drivers/mysqli.php:

WARNING |120926 16:39:33|Error while sending QUERY packet. PID=23873

are irrelevant to the FTP transfer. What happens is this. The transfer takes too long to complete. During the transfer there is no database activity going on. It seems that after a while (which is definitely less than 2 minutes) the database server closes the connection. This causes the error message you see and also causes the backup to be listed as Obsolete instead of Remote. There are two ways to fix this:
- Ask your host to edit their my.cnf and change the wait_timeout to 180
- Use the Part Size for Split Archives option in Akeeba Backup Configuration to split your archives to smaller parts which get transferred faster. Something like 15-20Mb should work.

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!

daniellevesque
Ok thank you I use the part size to 99.98 and all works fine now.
Thank you again for your fast and efficient answer.

nicholas
Akeeba Staff
Manager
You're welcome!

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!