View Full Version : Adding a new database server.
Sroek
12-08-2010, 02:55 AM
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?
slava
12-08-2010, 04:22 AM
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.
Sroek
12-08-2010, 05:04 AM
Thanks. I realized that it was disabled, however it won't enable for some reason. It's installed. The version is outdated though.
GakcaT
12-09-2010, 02:41 AM
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.
Sroek
12-09-2010, 03:54 AM
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.
GakcaT
12-09-2010, 04:56 AM
It won't enable. It'll show the little icon that it's enabling
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.
Sroek
12-14-2010, 01:50 PM
Dec 14 03:43:57 [ 0] [1;32mINFO Lookup log level for '/usr/local/ispmgr/var/pkgctl.log' in 'etc/pkgctl.debug'[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:612 [1mTRACE pkgctl started[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:613 [1;33mDEBUG LogLevel 9[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:662 [1mTRACE Init pkgmgr[0m
Dec 14 03:43:57 [ 1906] [1;32mINFO Using package manager 'Yum'[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:664 [1mTRACE Init way[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:666 [1mTRACE Init client[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:672 [1mTRACE Done[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgctl.cpp:510 [1mTRACE LoadModule lib/pkgisp-mysql.so[0m
Dec 14 03:43:57 [ 1906] ../../src/mgr/install/pkgmgr.cpp:445 [1;33mDEBUG Load package list[0m
Dec 14 03:44:13 [ 1906] [1;36mEXTINFO Execute (/usr/bin/yum -C list all | /bin/egrep '^[^ ]+ +[0-9]') return=0 exited[0m
Dec 14 03:44:13 [ 1906] ../../src/mgr/install/pkgmgr.cpp:455 [1;33mDEBUG 2749 packages found[0m
Dec 14 03:44:13 [ 1906] ../../src/mgr/install/pkgmgr.cpp:56 [1mTRACE List 'mysql-server' found 1[0m
Dec 14 03:44:17 [ 1906] [1;36mEXTINFO Execute (/usr/bin/yum -C list installed | /bin/egrep '^[^ ]+ +[0-9]') return=0 exited[0m
Dec 14 03:44:18 [ 1906] [1;36mEXTINFO Execute (/usr/bin/yum list installed | /bin/egrep -v '[[:space:]]') return=1 exited[0m
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmgr.cpp:78 [1mTRACE Has 'mysql-server-5.0.77-4.el5_5.4'[0m
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:93 [1mTRACE Cache done[0m
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:150 [1mTRACE trace0[0m
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:152 [1mTRACE trace0.5[0m
Dec 14 03:44:18 [ 1906] [1;36mEXTINFO Execute (bin/ispmgr -I) return=0 exited[0m
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:154 [1mTRACE trace1[0m
Dec 14 03:44:18 [ 1906] [1;36mEXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/init.d/mysql$') return=1 exited[0m
Dec 14 03:44:18 [ 1906] [1;36mEXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/init.d/mysqld$') return=0 exited[0m
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 [1mTRACE startcmd = '/etc/rc.d/init.d/mysqld'[0m
Dec 14 03:44:18 [ 1906] ../../src/mgr/install/pkgmysql.cpp:175 [1mTRACE trace2[0m
Dec 14 03:44:19 [ 1906] ../../src/mgr/install/pkgmysql.cpp:178 [1mTRACE trace3[0m
Dec 14 03:44:19 [ 1906] [1;36mEXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/my-small.cnf$') return=0 exited[0m
Dec 14 03:44:20 [ 1906] [1;36mEXTINFO Execute (/bin/cp -f /usr/share/mysql/my-small.cnf /etc/my.cnf) return=0 exited[0m
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgmysql.cpp:198 [1mTRACE trace4[0m
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgctl.cpp:1105 [1;33mDEBUG Not found 'skip-innodb ' in file /etc/my.cnf[0m
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgctl.cpp:1105 [1;33mDEBUG Not found 'bind-address = ' in file /etc/my.cnf[0m
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgmysql.cpp:212 [1mTRACE trace5[0m
Dec 14 03:44:20 [ 1906] ../../src/mgr/install/pkgctl.cpp:1102 [1;33mDEBUG Found 'Option NoMysqlQuota ' in line 'Option NoMysqlQuota
' from file etc/ispmgr.conf[0m
Dec 14 03:44:37 [ 1906] ../../src/mgr/install/pkgmgr.cpp:83 [1mTRACE Has 'mysql-client' not found[0m
Dec 14 03:44:37 [ 1906] ../../src/mgr/install/pkgmgr.cpp:78 [1mTRACE Has 'mysql-5.0.77-4.el5_5.4'[0m
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (/usr/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo | /usr/bin/mysql -u root mysql) return=1 exited[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmysql.cpp:262 [1;33mDEBUG cpkg: mysql-5.0.77-4.el5_5.4[0m
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (rpm -q --filesbypkg 'mysql'| grep -E '/mysqladmin$') return=0 exited[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 [1mTRACE mysqladmin = '/usr/bin/mysqladmin'[0m
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (/usr/bin/mysqladmin -u root password "qywHi3Rf") return=1 exited[0m
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (rpm -q --filesbypkg 'mysql-server'| grep -E '/libexec/mysqld$') return=0 exited[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 [1mTRACE mysqld = '/usr/libexec/mysqld'[0m
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (/usr/libexec/mysqld --print-defaults) return=0 exited[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmysql.cpp:302 [1;33mDEBUG server registration result = 'ERROR 1 : Can't connect to database
'[0m
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (rpm -q --filesbypkg 'mysql'| grep -E '/bin/mysql$') return=0 exited[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:347 [1mTRACE mysql = '/usr/bin/mysql'[0m
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (/usr/bin/mysql -u root -p"qywHi3Rf" < /usr/local/ispmgr/var/support.sql) return=1 exited[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgctl.cpp:1102 [1;33mDEBUG Found 'SupportCenterServer ' in line 'SupportCenterServer MySQL
' from file etc/ispmgr.conf[0m
Dec 14 03:44:41 [ 1906] [1;35mWARNING Can't connect to mysql as root@localhost MySQLError('Access denied for user 'root'@'localhost' (using password: YES)'). autocreate=1[0m
Dec 14 03:44:41 [ 1906] [1;35mWARNING Can't connect to MySQL[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmgr.cpp:56 [1mTRACE List 'mysql-server' found 1[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmgr.cpp:78 [1mTRACE Has 'mysql-server-5.0.77-4.el5_5.4'[0m
Dec 14 03:44:41 [ 1906] ../../src/mgr/install/pkgmysql.cpp:93 [1mTRACE Cache done[0m
GakcaT
12-15-2010, 02:46 AM
Dec 14 03:44:41 [ 1906] [1;36mEXTINFO Execute (/usr/bin/mysqladmin -u root password "qywHi3Rf") return=1 exited[0m
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?
Sroek
12-15-2010, 03:19 AM
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.
GakcaT
12-15-2010, 10:02 AM
There is a manual to reset MySQL root password http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix . When you do that you will be able to add the new password to /usr/local/ispmgr/etc/ispmgr.conf.
Sroek
12-16-2010, 05:49 AM
Thanks, finally got it working. Although, I ran into another problem when trying to install vBulletin. Apparently, it's related to MySQL and PHP. Here's the thread I posted at the vBulletin forum: http://www.vbulletin.com/forum/showthread.php?369011-install.php-Fatal-error
Any idea what the problem might be?
Edit: I fixed the problem, I had to add the mysql extension to PHP.
One more question: How do I make it so my domain website.com redirects to www.website.com instead of both being separate? Thanks.
Edit: Nevermind, got it.
vBulletin® v3.8.9, Copyright ©2000-2024, vBulletin Solutions, Inc.