Error while backing up database

[sysdev]

For those who are still without sql backups:

You should check your default /etc/my.cnf for a section [mysqldump]
Either add the username/password there or simply remove the [mysqldump] section in /etc/my.cnf and add the [mysqldump] section to /usr/local/directadmin/conf/my.cnf.

This should fix your problem with the backups.

 

[DirectAdmin Support]

Hello,

Well the above mysqldump command using the [client] option works fine when being run by hand. I believe [client] covers both mysql and mysqldump calls. Other OS's with the same code works just fine.. so it seems to be something specific that just debian does. I'm looking into this now and am creating some debug binaries to dump some output to see what's going on.

John

 

[Tristan]

Hello,

Well the above mysqldump command using the [client] option works fine when being run by hand. I believe [client] covers both mysql and mysqldump calls. Other OS's with the same code works just fine.. so it seems to be something specific that just debian does. I'm looking into this now and am creating some debug binaries to dump some output to see what's going on.

John

Ok let me know when they're ready and I'll test right away for you.

 

[DirectAdmin Support]

Thanks, I've found the problem and am uploading a new binary set now (1.33.6) for debian. The others OSs will be updated later on, as they don't seem to be affected by the issue. The issue was that while writing the my.cnf, the UID was set to diradmin, but wasn't escalated back up so it threw a "permission denied" error on the sql dump. What's odd is how the other OS's are not affected (they should be), hence made it past my testing. Thanks for all of your quick reports. 1.33.6 will be out shortly. I won't be updating the 1.33.6 version number until the other OS's are done, but will post to this thread with manual update instructions as the debian binaries will be 1.33.6 shortly (just not set in the versions system yet)

John

 

[Tristan]

Wow that was quick, thanks John!

 

[DirectAdmin Support]

Ok, the debian binaries are ready for download (1.33.6). All other OS's are still 1.33.5 (until later today when I finish other work), as well as the version set for the "current version" of DA.

To get them now, use this manual update method:
http://help.directadmin.com/item.php?id=29

Please let me know via email to support@ if there are further issues with it.
I've tested it out and works as far as I can see: no errors, and sql files show up.

John

 

[sysdev]

Hello,

Well the above mysqldump command using the [client] option works fine when being run by hand. I believe [client] covers both mysql and mysqldump calls. Other OS's with the same code works just fine.. so it seems to be something specific that just debian does. I'm looking into this now and am creating some debug binaries to dump some output to see what's going on.

John

I'm using freebsd and debian where it occurs on both systems.
After reading through the mysqldump docs, this is what i came up with, as i really needed working database backups.

J.

 

[DirectAdmin Support]

Ok, I'm doing the same for freebsd now.
I'll post when their compiles/uploads are done. Same steps as above for manual update to 1.33.6 once I complete them.

John

 

[DirectAdmin Support]

Alright, freebsd is also ready to go.

John

 

[nomalab]

Thank you, John, for the fix. Works perfectly.

I manage two boxes: both Debian 5.0, MySQL 5.0.77 on one and MySQL 5.1.34 on the other.

Note to Debian users (because I know someone will post and say the manual update instructions didn't work):

Last line of the manual update instructions (http://help.directadmin.com/item.php?id=29): instead of

service directadmin restart

you need to type:

/etc/init.d/directadmin restart

 

[Tristan]

Nice one Nomalab, maybe time to update that help article John?

Also got a small error from update.sh:

./update.sh: line 28: /etc/init.d/da-popb4smtp: No such file or directory

 

[Meesterlijk]

ns1# wget -O update.tar.gz https://www.directadmin.com/cgi-bin/daupdate\?uid=****\&lid=****
--11:02:21-- https://www.directadmin.com/cgi-bin/daupdate?uid=****&lid=****
=> `update.tar.gz'
Resolving www.directadmin.com... 66.51.122.131
Connecting to www.directadmin.com|66.51.122.131|:443... connected.
ERROR: Certificate verification error for www.directadmin.com: unable to get local issuer certificate
To connect to www.directadmin.com insecurely, use `--no-check-certificate'.
Unable to establish SSL connection.

Any ideas?

A pitty that we can not update this nasty bug thru DA.

 

[sysdev]

ns1# wget -O update.tar.gz https://www.directadmin.com/cgi-bin/daupdate\?uid=****\&lid=****
--11:02:21-- https://www.directadmin.com/cgi-bin/daupdate?uid=****&lid=****
=> `update.tar.gz'
Resolving www.directadmin.com... 66.51.122.131
Connecting to www.directadmin.com|66.51.122.131|:443... connected.
ERROR: Certificate verification error for www.directadmin.com: unable to get local issuer certificate
To connect to www.directadmin.com insecurely, use `--no-check-certificate'.
Unable to establish SSL connection.

Any ideas?

A pitty that we can not update this nasty bug thru DA.

Try: wget --no-check-certificate https://www.directadmin.com/cgi-bin/daupdate?uid=****&lid=****
edit: forgot the 's' in https :$

 

[tillo]

./update.sh: line 28: /etc/init.d/da-popb4smtp: No such file or directory

Comment lines 27-31 of the update.sh script.

My da-popb4smtp script existed, but was giving a segfault when stopping... I guess it's because I have Debian 5.0. That solved my problem.

 

[Christophe1]

Everything OK again.
The update solved the problem.

Thanx for the fantastic support!

 

[iCafe]

Ok, the debian binaries are ready for download (1.33.6). All other OS's are still 1.33.5 (until later today when I finish other work), as well as the version set for the "current version" of DA.

To get them now, use this manual update method:
http://help.directadmin.com/item.php?id=29

Please let me know via email to support@ if there are further issues with it.
I've tested it out and works as far as I can see: no errors, and sql files show up.

John

thank you for support

 

[Richard G]

Thank you very mucht for the quick and great support!

 

[Scormen]

Thanks for the update & support, it's working now!

Kris

 

[zEitEr]

Hello!

Still got the problem on FreeBSD 5.3 with 5.1 binaries.

Error while backing up database cust100204_i4
Error while backing up database cust100204_i4: The sql file is 0 bytes in size: /home/admin/user_backups/cust100204/backup/cust100204_i4.sql
mysqldump error output: mysqldump: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect

The file /usr/local/directadmin/conf/my.cnf exists and seems to be fine.

DirectAdmin Values
Compiled on FreeBSD 5.1
Server Version 1.33.6
Current Available Version 1.336000
Last Updated Wed Apr 29 10:17:25 2009

 

[DirectAdmin Support]

That just says your da_admin password is wrong.
Use this guide:
http://help.directadmin.com/item.php?id=45

John