Error during Backup

[erlangga]

Hello,

I installed Blesta with latest version on DirectAdmin. During blesta backup, I got huge errors like below:

[2020-09-09 00:24:17] general.WARNING: E_WARNING: fread() expects parameter 1 to be resource, bool given {"code":2,"message":"fread() expects parameter 1 to be resource, bool given","file":"/home/user/domains/mydomain.com/public_html/clients/app/models/backup.php","line":217}

and make partition full.

Also, I tried to download backup manually, the same error occured.

 

OS: CentOS 8 64bit

PHP 7.3

Control Panel: DirectAdmin 1.61.3

 

How to fix it ?

 

Thank you

 

Regards,

 

Erlangga

[Jono]

Do you have a Temp Directory set under Settings > System > General?

[erlangga]

I am sorry for delayto response...

my current setting for temp directory is /tmp/ and is writeable.

 

I checked in /tmp and found 2 files (because I tried 2 times to backup it manually):

 

0 -rw-r--r--   1 mulia mulia    0 Sep  8 02:15 mydomain_billing_2020-09-08T091507Z.sql.gz
0 -rw-r--r--   1 mulia mulia    0 Sep  8 17:10 mydomain_billing_2020-09-09T001002Z.sql.gz

But somehow the files size is 0

[Jono]

Looking at past forum posts people commonly experienced 1 of 3 issues:

1. The exec() function is disabled

2. The escapeshellarg() function is disabled

3. The web server cannot run mysqldump, either because mysqldump is missing from the system or the web user doesn't have permissions.

I think based on your error it could be #3 since I believe the first two would cause a php error message of their own.

[erlangga]

Thank you for your help...I am using DirectAdmin as control panel. How do I make mysqldump could be use by web user ?

 

Thank you

[erlangga]

Hello,

if I can not make a backup of Blesta online through web interface, how do I make manual backup from command line as root ?

 

Thank you

[Paul]

On 10/10/2020 at 5:46 PM, erlangga said:

Hello,

if I can not make a backup of Blesta online through web interface, how do I make manual backup from command line as root ?

 

Thank you

If you have SSH access, you can check if mysqldump exists and where it is by running:

whereis mysqldump

To make a manual database backup you can run:

mysqldump -u USERNAME -p DATABASENAME -r DATABASENAME.sql

I agree with Jono, most likely your system is missing mysqldump or it's not executable by your user.

[erlangga]

Thank you for all of your help.

 

I will do it manually.

mysqldump actually exist in the system. I tried su - userid and then type mysqldump and can dump the database.

 

Thank you

 

Regards,

 

Erlangga