US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > Troubleshooting


Reply
 
Thread Tools
Old 12-08-2010, 02:55 AM   #1
Junior Member
 
Join Date: Dec 2010
Posts: 10
Sroek is on a distinguished road
Default 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?
Sroek is offline   Reply With Quote
Old 12-08-2010, 04:22 AM   #2
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

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.
slava is offline   Reply With Quote
Old 12-08-2010, 05:04 AM   #3
Junior Member
 
Join Date: Dec 2010
Posts: 10
Sroek is on a distinguished road
Default

Thanks. I realized that it was disabled, however it won't enable for some reason. It's installed. The version is outdated though.
Sroek is offline   Reply With Quote
Old 12-09-2010, 02:41 AM   #4
ISPsystem team
 
Join Date: Jan 2009
Posts: 111
GakcaT is on a distinguished road
Default

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.
GakcaT is offline   Reply With Quote
Old 12-09-2010, 03:54 AM   #5
Junior Member
 
Join Date: Dec 2010
Posts: 10
Sroek is on a distinguished road
Default

Quote:
Originally Posted by GakcaT View Post
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.
Sroek is offline   Reply With Quote
Old 12-09-2010, 04:56 AM   #6
ISPsystem team
 
Join Date: Jan 2009
Posts: 111
GakcaT is on a distinguished road
Default

Quote:
Originally Posted by Sroek
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.
GakcaT is offline   Reply With Quote
Old 12-14-2010, 01:50 PM   #7
Junior Member
 
Join Date: Dec 2010
Posts: 10
Sroek is on a distinguished road
Default

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
Sroek is offline   Reply With Quote
Old 12-15-2010, 02:46 AM   #8
ISPsystem team
 
Join Date: Jan 2009
Posts: 111
GakcaT is on a distinguished road
Default

Quote:
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?
GakcaT is offline   Reply With Quote
Old 12-15-2010, 03:19 AM   #9
Junior Member
 
Join Date: Dec 2010
Posts: 10
Sroek is on a distinguished road
Default

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.

Last edited by Sroek; 12-15-2010 at 09:31 AM.
Sroek is offline   Reply With Quote
Old 12-15-2010, 10:02 AM   #10
ISPsystem team
 
Join Date: Jan 2009
Posts: 111
GakcaT is on a distinguished road
Default

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.
GakcaT is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 05:54 PM.