Hello, i already work for month's with ispconfig. yesterday i did an update to 2.2.24 everything was fine, until today. I couldn't check my website anymore cause it gave me the error Database Error: Unable to connect to the database:Could not connect to MySQL. When i login as admin to the ispconfig pannel. And when i go to ISP site off gc-security.be when i click on options i can see that i cannot create anymore databases. it just disapeared and i dunno whats the problem??? So my databases are gone, i can't create them anymore in the option window. what happend? and how do i fix it? greetings from belgium tom
Maybe the update of the database structures failed. This may happen e.g. when the mysql user defined in /home/admispconfig/ispconfig/lib/config.inc.php does not has root permissions. Make sure that the user in this file has root permissions and is able to login to mysql and then run the update again.
Eumm Hey Till, That should do it again right? i mean will this solution bring back the create new database button in my option tab ? greetings
What's the output of Code: netstat -tap ? Is the MySQL user in /home/admispconfig/ispconfig/lib/config.inc.php root?
Reply Yes the user in the config file is ROOT. output off netstat -tap pluto:/home/admispconfig/ispconfig/lib# netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:mysql *:* LISTEN 8480/mysqld tcp 0 0 pluto.gc-security.:6666 *:* LISTEN 2668/ircd tcp 0 0 pluto.gc-security.:ircd *:* LISTEN 2668/ircd tcp 0 0 pluto.gc-security.:6668 *:* LISTEN 2668/ircd tcp 0 0 *:sunrpc *:* LISTEN 2099/portmap tcp 0 0 pluto.gc-security.:4400 *:* LISTEN 2668/ircd tcp 0 0 *:81 *:* LISTEN 10289/ispconfig_htt tcp 0 0 *:41970 *:* LISTEN 8214/rpc.statd tcp 0 0 *:ftp *:* LISTEN 9773/proftpd: (acce tcp 0 0 78-159-101-168.i:domain *:* LISTEN 11415/named tcp 0 0 78-159-101-167.i:domain *:* LISTEN 11415/named tcp 0 0 pluto.gc-securit:domain *:* LISTEN 11415/named tcp 0 0 localhost:domain *:* LISTEN 11415/named tcp 0 0 *:33333 *:* LISTEN 3124/psybnc tcp 0 0 *:smtp *:* LISTEN 9735/master tcp 0 0 localhost:953 *:* LISTEN 11415/named tcp 0 0 pluto.gc-security:35012 administrator.jolt:4400 ESTABLISHED2668/ircd tcp 0 0 78-159-101-167.in:59098 pluto.gc-security.:ircd ESTABLISHED3124/psybnc tcp 0 0 pluto.gc-security:33333 205.255-176-91.ad:46221 ESTABLISHED3124/psybnc tcp 0 0 pluto.gc-security.:ircd 78-159-101-167.in:59098 ESTABLISHED2668/ircd tcp6 0 0 *:imaps *:* LISTEN 28245/couriertcpd tcp6 0 0 *op3s *:* LISTEN 28194/couriertcpd tcp6 0 0 *op3 *:* LISTEN 12503/couriertcpd tcp6 0 0 *:imap2 *:* LISTEN 12593/couriertcpd tcp6 0 0 *:www *:* LISTEN 411/apache2 tcp6 0 0 *:ssh *:* LISTEN 747/sshd tcp6 0 0 *:smtp *:* LISTEN 9735/master tcp6 0 0 localhost:953 *:* LISTEN 11415/named tcp6 0 0 *:https *:* LISTEN 411/apache2 tcp6 0 2880 78-159-101-167.inte:ssh 205.255-176-91.ad:38135 ESTABLISHED20059/1 pluto:/home/admispconfig/ispconfig/lib#
Is the MySQL user in /home/admispconfig/ispconfig/lib/config.inc.php root? Are there any MySQL errors in your logs when you try to create a database?
