Adding a new database server.
 

I'm trying to create a MySQL server, but I get the following message:

"Error: Internal error Can't connect to database"

What could be the issue?

MySQL is down - check this in the Services menu and restart service, or mysql password or other data for connections are wrong - check it in the Database servers menu.

Thanks. I realized that it was disabled, however it won't enable for some reason. It's installed. The version is outdated though.

Is MySQL enabled in the "Applications" menu?

1. Add the line "LogLevel 9" to the /usr/local/ispmgr/etc/ispmgr.conf file.
2. Execute the command "killall ispmgr".
3. Click on any menu.
4. Provide the part of the /usr/local/ispmgr/var/ispmgr.log file which will be created.

It won't enable. It'll show the little icon that it's enabling, then the page refreshes and the MySQL application will still show up as disabled. Though, I'm going to follow those steps and post the results.

In this case:
1. Click on the "Activate" button.
2. Provide the part of the /usr/local/ispmgr/var/pkgctl.log file which will be created.

Dec 14 03:43:57 [ 0] INFO Lookup log level for '/usr/local/ispmgr/var/pkgctl.log' in 'etc/pkgctl.debug'
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:612 TRACE pkgctl started
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:613 DEBUG LogLevel 9
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:662 TRACE Init pkgmgr
Dec 14 03:43:57 [ 1906] INFO Using package manager 'Yum'
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:664 TRACE Init way
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:666 TRACE Init client
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:672 TRACE Done
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:510 TRACE LoadModule lib/pkgisp-mysql.so
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgmgr.cpp:445 DEBUG Load package list
Dec 14 03:44:13 [ 1906] EXTINFO Execute (/usr/bin/yum -C list all | /bin/egrep '^[^ ]+ +[0-9]') return=0 exited
Dec 14 03:44:13 [ 1906] ../../src/mgr/install/pkgmgr.cpp:455 DEBUG 2749 packages found
Dec 14 03:44:13 [ 1906] ../../src/mgr/install/pkgmgr.cpp:56 TRACE List 'mysql-server' found 1
Dec 14 03:44:17 [ 1906] EXTINFO Execute (/usr/bin/yum -C list installed | /bin/egrep '^[^ ]+ +[0-9]') return=0 exited
Dec 14 03:44:18 [ 1906] EXTINFO Execute (/usr/bin/yum list installed | /bin/egrep -v '[[:space:]]') return=1 exited
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmgr.cpp:78 TRACE Has 'mysql-server-5.0.77-4.el5_5.4'
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:93 TRACE Cache done
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:150 TRACE trace0
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:152 TRACE trace0.5
Dec 14 03:44:18 [ 1906] EXTINFO Execute (bin/ispmgr -I) return=0 exited
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:154 TRACE trace1
Dec 14 03:44:18 [ 1906] EXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/init.d/mysql$') return=1 exited
Dec 14 03:44:18 [ 1906] EXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/init.d/mysqld$') return=0 exited
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 TRACE startcmd = '/etc/rc.d/init.d/mysqld'
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:175 TRACE trace2
Dec 14 03:44:19 [ 1906] ../../src/mgr/install/pkgmysql.cpp:178 TRACE trace3
Dec 14 03:44:19 [ 1906] EXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/my-small.cnf$') return=0 exited
Dec 14 03:44:20 [ 1906] EXTINFO Execute (/bin/cp -f /usr/share/mysql/my-small.cnf /etc/my.cnf) return=0 exited
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgmysql.cpp:198 TRACE trace4
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgctl.cpp:1105 DEBUG Not found 'skip-innodb ' in file /etc/my.cnf
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgctl.cpp:1105 DEBUG Not found 'bind-address = ' in file /etc/my.cnf
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgmysql.cpp:212 TRACE trace5
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgctl.cpp:1102 DEBUG Found 'Option NoMysqlQuota ' in line 'Option NoMysqlQuota
' from file etc/ispmgr.conf
Dec 14 03:44:37 [ 1906] ../../src/mgr/install/pkgmgr.cpp:83 TRACE Has 'mysql-client' not found
Dec 14 03:44:37 [ 1906] ../../src/mgr/install/pkgmgr.cpp:78 TRACE Has 'mysql-5.0.77-4.el5_5.4'
Dec 14 03:44:41 [ 1906] EXTINFO Execute (/usr/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo | /usr/bin/mysql -u root mysql) return=1 exited
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmysql.cpp:262 DEBUG cpkg: mysql-5.0.77-4.el5_5.4
Dec 14 03:44:41 [ 1906] EXTINFO Execute (rpm -q --filesbypkg 'mysql'| grep -E '/mysqladmin$') return=0 exited
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 TRACE mysqladmin = '/usr/bin/mysqladmin'
Dec 14 03:44:41 [ 1906] EXTINFO Execute (/usr/bin/mysqladmin -u root password "qywHi3Rf") return=1 exited
Dec 14 03:44:41 [ 1906] EXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/libexec/mysqld$') return=0 exited
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 TRACE mysqld = '/usr/libexec/mysqld'
Dec 14 03:44:41 [ 1906] EXTINFO Execute (/usr/libexec/mysqld --print-defaults) return=0 exited
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmysql.cpp:302 DEBUG server registration result = 'ERROR 1 : Can't connect to database
'
Dec 14 03:44:41 [ 1906] EXTINFO Execute (rpm -q --filesbypkg 'mysql'| grep -E '/bin/mysql$') return=0 exited
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 TRACE mysql = '/usr/bin/mysql'
Dec 14 03:44:41 [ 1906] EXTINFO Execute (/usr/bin/mysql -u root -p"qywHi3Rf" < /usr/local/ispmgr/var/support.sql) return=1 exited
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:1102 DEBUG Found 'SupportCenterServer ' in line 'SupportCenterServer MySQL
' from file etc/ispmgr.conf
Dec 14 03:44:41 [ 1906] WARNING Can't connect to mysql as root@localhost MySQLError('Access denied for user 'root'@'localhost' (using password: YES)'). autocreate=1
Dec 14 03:44:41 [ 1906] WARNING Can't connect to MySQL
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmgr.cpp:56 TRACE List 'mysql-server' found 1
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmgr.cpp:78 TRACE Has 'mysql-server-5.0.77-4.el5_5.4'
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmysql.cpp:93 TRACE Cache done

ISPmanager can't connect to MySQL because of the password is wrong. Did you install MySQL with ISPmanager or by hands? Are you able to connect to MySQL with shell?

I think it was created automatically by my VPS host with CentOS 5.5 x64 LAMP

Edit: Any instructions on how to set the password for MySQL and make sure ISPmanager has it right? I would greatly appreciate it, thanks.

There is a manual to reset MySQL root password http://dev.mysql.com/doc/refman/5.0/...rmissions-unix . When you do that you will be able to add the new password to /usr/local/ispmgr/etc/ispmgr.conf.