MySQL

firejake · May 17, 2013

Hello!

I configured DirectAdmin to use remote MySQL-server:

HTML:

user=da_admin
passwd=******
host=remote_mysql_server
access_host=da_server_ip

But i have some problem - directadmin add user and value host as 'localhost', but no 'da_server_ip' or '%' in user privileges table, and error:

HTML:

Error inserting host: Field 'x509_issuer' doesn't have a default value
Error inserting host: Field 'x509_issuer' doesn't have a default value

DirectAdmin v 1.43.0, MySQL v5.5 (also tested on 5.6) - installed from FreeBSD 9 ports.

zEitEr · May 17, 2013

Hello,

Did you restart Directadmin?

firejake · May 17, 2013

zEitEr said:
Hello,

Did you restart Directadmin?

yes of course

zEitEr · May 17, 2013

Then you might need to run directadmin in a debug mode and see its output, which might give a clue.

Related: http://help.directadmin.com/item.php?id=293

firejake · May 18, 2013

debug directadmin (restoring database):

Code:

Sockets::handshake - begin
Sockets::handshake - end
/CMD_DB
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Content-Length: 1067
 6: Content-Type: multipart/form-data; boundary=---------------------------1454233304665661151820396647
 7: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 8: Host: da_server:2222
 9: Referer: [url]http://da_server:2222/CMD_DB?DOMAIN=domain.com[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Post string: action=restore&domain=domain%2Ecom&file%31=%2Fhome%2Ftmp%2Fda_user%5Ftest%2EgzFaH%32Xe&method=default&name=da_user%5Ftest%32
Command::doCommand(/CMD_DB)
Command::doCommand(/CMD_DB) : finished
Command::run: finished /CMD_DB
Sockets::handshake - begin
Sockets::handshake - end
/CSS_STYLE
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: text/css,*/*;q=0.1
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: Referer: [url]http://da_server:2222/CMD_DB[/url]
 9: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_HOME_OVER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:08:10 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_WEBMAIL_OVER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:22:47 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_PASSWORD_OVER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:08:11 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_FILEMAN_OVER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:21:23 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /IMG_SKIN_NAV_WEBMAIL_OVER
Command::run: finished /IMG_SKIN_NAV_HOME_OVER
Command::run: finished /IMG_SKIN_NAV_PASSWORD_OVER
Sockets::handshake - begin
Sockets::handshake - end
Command::run: finished /IMG_SKIN_NAV_FILEMAN_OVER
/IMG_SKIN_NAV_HELP_OVER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 14 May 2004 11:22:22 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /CSS_STYLE
Command::run: finished /IMG_SKIN_NAV_HELP_OVER
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_LOGOUT_OVER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:08:11 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_LOGOUT2_OVER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Tue, 11 May 2004 12:03:34 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /IMG_SKIN_NAV_LOGOUT_OVER
Command::run: finished /IMG_SKIN_NAV_LOGOUT2_OVER
Sockets::handshake - begin
Sockets::handshake - end
Sockets::handshake - begin
Sockets::handshake - end
Sockets::handshake - begin
Sockets::handshake - end
Sockets::handshake - begin
Sockets::handshake - end
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_LEFT_SHADOW
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Tue, 11 May 2004 10:40:05 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
/IMG_SKIN_HEADER
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Thu, 05 Feb 2004 02:24:37 EET
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
/IMG_SKIN_NAV_HOME
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:21:23 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
/IMG_SKIN_NAV_WEBMAIL
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:08:11 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
/IMG_SKIN_NAV_PASSWORD
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:08:11 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /IMG_SKIN_NAV_HOME
Command::run: finished /IMG_SKIN_NAV_PASSWORD
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_HELP
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 14 May 2004 11:22:00 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /IMG_SKIN_HEADER
Command::run: finished /IMG_SKIN_NAV_HELP
Command::run: finished /IMG_SKIN_LEFT_SHADOW
Command::run: finished /IMG_SKIN_NAV_WEBMAIL
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_NAV_FILEMAN
Sockets::handshake - begin
Sockets::handshake - end
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 16 Apr 2004 23:21:22 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
/IMG_SKIN_NAV_LOGOUT2
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Tue, 11 May 2004 12:04:01 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /IMG_SKIN_NAV_LOGOUT2
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_HEADER_NONAME
Sockets::handshake - begin
Sockets::handshake - end
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Fri, 23 Mar 2007 10:14:46 EET
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
/IMG_SKIN_NAV_BG
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Thu, 05 Feb 2004 02:24:37 EET
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Sockets::handshake - begin
Sockets::handshake - end
/IMG_FOOTER_WIDE
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Tue, 11 May 2004 11:41:20 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /IMG_SKIN_NAV_FILEMAN
Command::run: finished /IMG_SKIN_NAV_BG
Command::run: finished /IMG_FOOTER_WIDE
Sockets::handshake - begin
Sockets::handshake - end
/IMG_SKIN_RIGHT_SHADOW
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: image/png,image/*;q=0.8,*/*;q=0.5
 3: Cache-Control: max-age=0
 4: Connection: keep-alive
 5: Cookie: luci=20749634388b5d950b3c2c455596123cdd1a2f9b73368d89cc35902f34aa6aa48330c0fe; PHPSESSID=922283ed2ec54c9b0053796fc7928b67; auth_tkt="f138548b1371588e3b61fcb2196995e6a1d1055e33911c80f15ee0ce32d373ac51975b0froot!"; session=tkgtjNqRgjqX7TcGg34vQcvdiL4YAtF3btuLGkkvSaQZ12pi5tbVUV6AoBgy2vze
 6: DNT: 1
 7: Host: da_server:2222
 8: If-Modified-Since: Tue, 11 May 2004 10:54:42 EEST
 9: Referer: [url]http://da_server:2222/CMD_DB[/url]
10: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0
Command::run: finished /IMG_SKIN_HEADER_NONAME
Command::run: finished /IMG_SKIN_RIGHT_SHADOW

debug by restoring user backup:

Code:

Unable to restore database user&#95xxxxx.sql to user_UserTable: Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'user'@'da_server' (using password: YES)

After restoring in phpMyAdmin - see attach.

zEitEr · May 18, 2013

You should debug MySQL DB creating and a user account adding to a DB.

firejake · May 19, 2013

Code:

/CMD_DB
 0: Accept-Encoding: gzip, deflate
 1: Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
 2: Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 3: Connection: keep-alive
 4: Content-Length: 100
 5: Content-Type: application/x-www-form-urlencoded
 6: Cookie: session=Q11Mlkr1uINLNhcva3i98Q2I2s2ADBoeAo0vYruS7FlVxLQVN6eVUfnWXnflwTP6
 7: Host: DA_IP:2222
 8: Referer: http://DA_IP:2222/CMD_DB_CREATE?DOMAIN=testuser.com
 9: User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0
10: X-ClickOnceSupport: ( .NET CLR 3.5.30729; .NET4.0E)
Post string: action=create&domain=testuser.com&name=test&user=test&passwd=7FIPs5ke&passwd2=7FIPs5ke&create=Create
Command::doCommand(/CMD_DB)
Database::connect 0
Database::connect 0.5 - da_admin : xxx
Database::connect 1
Database::connect 5
Database::connect 0
Database::connect 0.5 - da_admin : xxx
Database::connect 1
Database::connect 5
Database::connect 0
Database::connect 0.5 - da_admin : xxx
Database::connect 1
Database::connect 5
Database::connect 0
Database::connect 0.5 - da_admin : xxx
Database::connect 1
Database::connect 5
Command::doCommand(/CMD_DB) : finished
Command::run: finished /CMD_DB
Sockets::handshake - begin
Sockets::handshake - end

Only this.

zEitEr · May 19, 2013

How did you check your created users? Did you check in Directadmin or directly in MySQL (phpMyAdmin)?

firejake · May 19, 2013

I checked in MySQL (phpmyadmin) see attach at top.

firejake · May 20, 2013

And, how forbidden to deleting my host from Access Hosts table in directadmin MySql manage?

zEitEr · May 20, 2013

how forbidden to deleting my host from Access Hosts table in directadmin MySql manage?

Why should Directadmin delete it? Are your sure it deletes? You might want to try POST/PRE scripts.

Anyway, make sure, that Directadmin sends a correct MySQL query to DB server, when creating a new user. For this you should enable logging in MySQL of all queries and see exact query from Directadmin. Please post it here.

firejake · May 20, 2013

I did not delete. I want to prohibit the removal of that host my users - that would not have any problems.

zEitEr · May 20, 2013

You users can not delete anything from that table.

Back to the initiate issue, make sure, that Directadmin sends a correct MySQL query to DB server, when creating a new user. For this you should enable logging in MySQL of all queries and see exact query from Directadmin. Please post it here.

firejake · May 20, 2013

zEitEr said:
You users can not delete anything from that table.

Really?

See attach.

zEitEr · May 20, 2013

Under "users" I mean exactly regular users which have unprivileged MySQL accounts, which has no "ALL PRIVILEGES".

firejake · May 20, 2013

zEitEr said:
Under "users" I mean exactly regular users which have unprivileged MySQL accounts, which has no "ALL PRIVILEGES".

The question is the same - how to prevent removal of the remote hostname?

zEitEr · May 20, 2013

Since you did not provide information on MySQL queries sent from Directadmin to MySQL server, so we could debug the issue; and you ask questions as they seem not to be related to Directadmin at all, then I have to say, you should check MySQL documentation. I have no answer, and hardly anyone here has it.

firejake · May 20, 2013

zEitEr said:
Since you did not provide information on MySQL queries sent from Directadmin to MySQL server, so we could debug the issue; and you ask questions as they seem not to be related to Directadmin at all, then I have to say, you should check MySQL documentation. I have no answer, and hardly anyone here has it.

You do not read the text attentively. I'm asking about the management of the MySQL panel Directadmin. At the same time provided a screenshot.

firejake · May 20, 2013

I have a problem arises with the panel itself, which does not quite work correctly with the remote hosts.
At presence of the source code, it can be easy to fix.

Questions and problems with the MySQL and I can solve without your help.

zEitEr · May 20, 2013

firejake said:
You do not read the text attentively. I'm asking about the management of the MySQL panel Directadmin. At the same time provided a screenshot.

You missed two requests of mine for more details. Note, as I don't work for JBMC Software, and if you don't like the way I use for troubleshooting, then you might need to write to official support by email or wait for somebody else's replies. The thread turns into a long guessing, and without a root access it's hard to help you here.

Debug output posted by you and attached screenshots unfortunately did not give any clue. So for further assistance you should provide requested MySQL queries, in order to see on which side the wrong host is set.

Anyway the thread takes too much time, so if somebody else is willing to participate, please do it.

MySQL

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Verified User

Super Moderator