Daily Email Backups not working

[Tom Wilson]

Hi guys,

The daily database back up is not working - I have it set to email. 

The activity logs do not show it being processed, the Cron is set to run at 20:00, the log is below:

 

27/03/2019 20:00	Automated Task: Starting Credit Card Charges	System
27/03/2019 20:00	Cron Job: Late Invoice Fees added to 0 Invoices	System
27/03/2019 20:00	Automated Task: Starting Late Fees	System
27/03/2019 20:00	Automated Task: Starting Invoices	System
27/03/2019 20:00	Automated Task: Starting Product Pricing Updates	System
27/03/2019 20:00	Automated Task: Starting Currency Exchange Rates	System
27/03/2019 20:00	Cron Job: Starting Daily Automation Tasks

 

Automated Task: Starting Server Usage Stats	System
27/03/2019 20:00	Automated Task: Starting SSL Sync	System
27/03/2019 20:00	Automated Task: Starting Email Marketer Rules	System
27/03/2019 20:00	Automated Task: Starting Delayed Affiliate Commissions	System
27/03/2019 20:00	Email Sent to *** ([Ticket ID: 139374] Remove SIteLock) - User ID: 129	System
27/03/2019 20:00	Automated Task: Starting Inactive Tickets	System
27/03/2019 20:00	Automated Task: Starting Fixed Term Terminations	System
27/03/2019 20:00	Automated Task: Starting Overdue Terminations	System
27/03/2019 20:00	Automated Task: Starting Overdue Suspensions	System
27/03/2019 20:00	Automated Task: Starting Cancellation Requests	System
27/03/2019 20:00	Automated Task: Starting Domain Renewal Notices	System
27/03/2019 20:00	Automated Task: Starting Invoice & Overdue Reminders

Edited March 31, 2019 by WHMCS ChrisD
Removed URL

[WHMCS ChrisD]

@Tom Wilson It could be that your database is too big have you tried backing it up to an FTP instead to see what happens?

[Tom Wilson]

3 hours ago, WHMCS ChrisD said:

@Tom Wilson It could be that your database is too big have you tried backing it up to an FTP instead to see what happens?

I've tried doing that and it freezes on 'Testing Connection...'

I've tried the credentials on my end and it all works.

[steven99]

The server might be blocking outbound FTP connections, even if it just goes to it self.  Doing a telnet on the server's SSH would help to determine if that beyond checking the firewall rules.   Also if using ftpes, ensure you're using the proper address -- ftp.example.com and server1.example.com are different for certificates.  And lastly, check that you have openssl capath and other such items set in PHP's php.ini.  The last two items are more specific for PHP 7 and up as they default to verify peers.