bblboy54
Verified User
I just updated my CustomBuild using ./build update and ./build update_versions and everythings seems to have gone ok except I'm having issues with MySQL. 
After running the update MySQL started without issue but the DirectAdmin web interface doesn't show that its running and clicking start returns an error. I can, however, stop and start the service using /etc/init.d/mysql [stop,start] and the result is as expected.....
..... but those issues I don't really care about.
The serious issue is that it doesnt seem like anything can connect to MySQL. All of my web applications that use a db are not working.... if I go to that application via the web I just get a "waiting for host x.xxxx.com" and it sits there forever without loading anything and the same result happens if I try to access phpMyAdmin. Despite those issues I can connect to mysql via the shell:
The port also appears to be open and no issues there:
System Information:
- Linux mojo.iad.ransomtech.com 2.6.18-6-686 #1 SMP Sat Dec 27 09:31:05 UTC 2008 i686 GNU/Linux
- Debian 4.0
- DirectAdmin 1.34.5 (just updated today from 1.34.4)
I'm continuing to dig into this issue as my services are currently down but if anyone has any advice I would greatly appreciate it.
Thanks!
After running the update MySQL started without issue but the DirectAdmin web interface doesn't show that its running and clicking start returns an error. I can, however, stop and start the service using /etc/init.d/mysql [stop,start] and the result is as expected.......... but those issues I don't really care about.
The serious issue is that it doesnt seem like anything can connect to MySQL. All of my web applications that use a db are not working.... if I go to that application via the web I just get a "waiting for host x.xxxx.com" and it sits there forever without loading anything and the same result happens if I try to access phpMyAdmin. Despite those issues I can connect to mysql via the shell:
Code:
mojo:/usr/local/directadmin/custombuild# mysql -u da_admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.89 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.89, for pc-linux-gnu (i686) using readline 5.1
Connection id: 8
Current database:
Current user: da_admin@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.89 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 15 min 2 sec
Threads: 1 Questions: 8 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.009
--------------
mysql>The port also appears to be open and no issues there:
Code:
mojo:/usr/local/directadmin/custombuild# telnet localhost mysql
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
4
5.0.89 l@60-1Nu,#J.CI%yTx~1u
Bad handshakeConnection closed by foreign host.
mojo:/usr/local/directadmin/custombuild#System Information:
- Linux mojo.iad.ransomtech.com 2.6.18-6-686 #1 SMP Sat Dec 27 09:31:05 UTC 2008 i686 GNU/Linux
- Debian 4.0
- DirectAdmin 1.34.5 (just updated today from 1.34.4)
I'm continuing to dig into this issue as my services are currently down but if anyone has any advice I would greatly appreciate it.
Thanks!