12-09-2010, 02:41 AM | #4 |
ISPsystem team
Join Date: Jan 2009
Posts: 111
|
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. |
12-09-2010, 03:54 AM | #5 | |
Junior Member
Join Date: Dec 2010
Posts: 10
|
Quote:
|
|
12-09-2010, 04:56 AM | #6 | |
ISPsystem team
Join Date: Jan 2009
Posts: 111
|
Quote:
1. Click on the "Activate" button. 2. Provide the part of the /usr/local/ispmgr/var/pkgctl.log file which will be created. |
|
12-14-2010, 01:50 PM | #7 |
Junior Member
Join Date: Dec 2010
Posts: 10
|
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 |
12-15-2010, 02:46 AM | #8 | |
ISPsystem team
Join Date: Jan 2009
Posts: 111
|
Quote:
|
|
12-15-2010, 03:19 AM | #9 |
Junior Member
Join Date: Dec 2010
Posts: 10
|
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. |
12-15-2010, 10:02 AM | #10 |
ISPsystem team
Join Date: Jan 2009
Posts: 111
|
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.
|
|
|