Could not download Databases from Directadmin?

T

Tommyhara

Verified User
Joined
Jul 25, 2014
Messages
182
Hello,

I don't know there was a wrong option so that made me can not download Mysql database from Directadmin control panel, it's showing 20 Bytes while real my database is 170 MB when I click on Download a database

Also, under my account statistics, it's showing "Databases 0 database unlimited" while I have 5 databases on this account.

This could happen because reasons as following? (since I made some changes)
I copied configs from /usr/share/mysql/my-large.cnf to /etc/my.cnf ?
I changed password for Mysql root and da_admin account?

which points in my.cnf is affecting to this error?

Has anyone faced this issues before? please share your suggestions and support.

Thanks in advance
 
Last edited:
Hello,

If you change da_admin's password you should put it into /usr/local/directadmin/conf/mysql.conf and /usr/local/directadmin/conf/my.cnf
 
zEitEr said:
Hello,

If you change da_admin's password you should put it into /usr/local/directadmin/conf/mysql.conf and /usr/local/directadmin/conf/my.cnf
Click to expand...

Hello Alex,

Both these files I have already updated new da_admin's password when I changed it.

Still getting the issue...
 
I remembered I made 1 change more
Added this to /etc/my.cnf under [mysqld] (as its using large config file that I copied from)

max_heap_table_size=128M
tmp_table_size=128M
Click to expand...

Installed memcached and store sessions with memcached (but i didn't get the problem with this setting in the past)

If I can not find which is affecting on this then I will need to roll back some old configs in some next days.
 
What if you try to run this:

Code: 
mysql --defaults-extra-file=/usr/local/directadmin/conf/my.cnf

What result do you get?
 
zEitEr said:
What if you try to run this:

Code: 
mysql --defaults-extra-file=/usr/local/directadmin/conf/my.cnf

What result do you get?
Click to expand...

Here's the result when ran your command from SSH

Code: 
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
 
If you have /root/.my.cnf with root's password make sure you've got there the following line:

Code: 
user=root

Otherwise mysql client tries to connect to mysql server as da_admin with root's password.

If /root/.my.cnf is not the case, then make sure you've correct password in /usr/local/directadmin/conf/mysql.conf and /usr/local/directadmin/conf/my.cnf
 
zEitEr said:
If you have /root/.my.cnf with root's password make sure you've got there the following line:

Code: 
user=root
Click to expand...

see in this folder /root, I don't see the file with name .my.cnf , it's not exist

zEitEr said:
Otherwise mysql client tries to connect to mysql server as da_admin with root's password.

If /root/.my.cnf is not the case, then make sure you've correct password in /usr/local/directadmin/conf/mysql.conf and /usr/local/directadmin/conf/my.cnf
Click to expand...


The content of file /usr/local/directadmin/conf/mysql.conf is

Code: 
[client]
user=da_admin
password=mypasswordchanged


and

The content of file /usr/local/directadmin/conf/my.cnf is

Code: 
user=da_admin
passwd=mypasswordchanged

I only updated the password, didn't change anything in these files
 
With the command

Code: 
mysql --defaults-extra-file=/usr/local/directadmin/conf/my.cnf

you should see something similar to:

Code: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 681
Server version: 5.5.46-MariaDB MariaDB Server


Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]>

if you still see the error, then try to use this code:

Code: 
mysql -uda_admin -p

you will be requested to enter password, try it and update us with results.
 
I am seeing this when tried mysql --defaults-extra-file=/usr/local/directadmin/conf/my.cnf

ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
Click to expand...



when tried mysql -uda_admin -p

I typed da_admin's password mypasswordchanged

and I could login and seeing this

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 61329
Server version: 5.5.41-MariaDB-log MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
Click to expand...
 
Last edited:
In your post #8 you posted content of the files, and they are wrong on your server or you mixed them when posting. Make sure you have it correct:

The content of file /usr/local/directadmin/conf/mysql.conf is

Code: 
[FONT=monospace]user=da_admin
[/FONT][FONT=monospace]passwd=mypasswordchanged

[/FONT]


and


The content of file /usr/local/directadmin/conf/my.cnf is

Code: 
[FONT=monospace][client]
[/FONT][FONT=monospace]user=da_admin
password=mypasswordchanged

[/FONT]




and they both might need an empty line at the bottom. Then try and check the things again.
 
I checked again and found that my password contained character @ or # so that in Linux, it could ignore this.

Changed password and solved the problem.


Thanks Alex for your support!
 
You must log in or register to reply here.
Back
Top