Support

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:

Since updating Akeeba Backup Pro from version 4.6.1 to 5.0.3 on 18 May 2016 my cron job for scheduled backups to Dropbox v2 API have failed. I noticed this last week. Before the update my cron jobs worked flawlessly. Nothing else has changed. I updated to Akeeba Backup Pro 5.0.4 on 23 May 2016 but the problem continues.

My cron command is identical to what is shown in Akeeba's Schedule Automatic Backups section:
/home/userid/public_html/cli/akeeba-backup.php

The path to PHP is correct for Siteground. It was working before, and it's still working on 15+ other websites on my Siteground cloud server.

The cron email reports the failure --

Akeeba Backup CLI 5.0.4 (2016-05-23)
Copyright (c) 2006-2016 Akeeba Ltd / Nicholas K. Dionysopoulos
-------------------------------------------------------------------------------
Akeeba Backup is Free Software, distributed under the terms of the GNU General
Public License version 3 or, at your option, any later version.
This program comes with ABSOLUTELY NO WARRANTY as per sections 15 & 16 of the
license. See http://www.gnu.org/licenses/gpl-3.0.html for details.
-------------------------------------------------------------------------------

You are using Joomla! 3.4.8 on PHP 5.6.21 (cli)

Starting a new backup with the following parameters:
Profile ID  1
Description "Command-line backup"

Current memory usage: 1.57 Mb

Unsetting time limit restrictions.

Site paths determined by this script:
JPATH_BASE : /home/userid/public_html
JPATH_ADMINISTRATOR : /home/userid/public_html/administrator



********** ERROR! **********

Could not connect to MySQL

Technical information:

Code: 2
File: /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Driver/Mysqli.php
Line: 288

Stack Trace:

#0 /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Driver/Base.php(1049): Akeeba\Engine\Driver\Mysqli->query()
#1 /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Driver/Base.php(742): Akeeba\Engine\Driver\Base->execute()
#2 /home/userid/public_html/administrator/components/com_akeeba/BackupPlatform/Joomla3x/Driver/Joomla.php(126): Akeeba\Engine\Driver\Base->loadAssocList()
#3 /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Platform/Base.php(583): Akeeba\Engine\Driver\Joomla->__call('loadAssocList', Array)
#4 /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Platform/Base.php(583): Akeeba\Engine\Driver\Joomla->loadAssocList()
#5 /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Platform.php(272): Akeeba\Engine\Platform\Base->get_running_backups(NULL)
#6 /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Factory.php(436): Akeeba\Engine\Platform->__call('get_running_bac...', Array)
#7 /home/userid/public_html/administrator/components/com_akeeba/BackupEngine/Factory.php(436): Akeeba\Engine\Platform->get_running_backups(NULL)
#8 /home/userid/public_html/administrator/components/com_akeeba/Model/Backup.php(122): Akeeba\Engine\Factory::resetState(Array)
#9 /home/userid/public_html/cli/akeeba-backup.php(236): Akeeba\Backup\Admin\Model\Backup->startBackup(Array)
#10 /home/userid/public_html/cli/akeeba-backup.php(324): AkeebaBackupCLI->execute()
#11 {main}

Reading previous support tickets with similar issues of cron failing to connect to MySQL, I tried the following adjustments without success:

1. Switch cron command to akeeba-altbackup.php - failed same as akeeba-backup.php
2. Try wget command. Cron email says /bin/bash: -c: line 0: unexpected EOF while looking for matching `"'
/bin/bash: -c: line 1: syntax error: unexpected end of file
3. Try curl command. Cron email same as wget.
4. Change database user password. The original had punctuation, new password just upper and lowercase letters and numbers. This returned the same error as first reported above.

I have not move the configuration.php file from it's default location in public_html root. The database connection credentials are correct in the configuration.php file. The website loads and displays correctly, and manual backups from the backend and Watchful work. Only the cron job fails to connect to MySQL.

I have attached the log zip for command line backups, but it is empty. The cron job fails before it can begin a backup on the server.

The affected website is https://www.ostriches.org/

Thank you
Richard

By the way... forgot to mention, I have no additional databases in the backup profile. Only the main Joomla website database.

1. I have not moved the configuration.php file from it's default location in public_html root.
2. Global Configuration > Server Tab > Database Settings: Database type is MySQLi

Thank you. I look forward to it. I've had some delay in updating a few of my Joomla website to 3.5.x pending extension compatibility upgrades.

Richard

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.