Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > ISPConfig 3 Priority Support

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th April 2013, 23:11
lmason674 lmason674 is offline
Junior Member
 
Join Date: Jul 2012
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default 3.0.5.2 update - Unable to connect to dbispconfig database after update

Using Centos 5.9 (x64)
I used the ispconfig_update script successfully, upgraded from 3.0.4.6.
All of the sites I host work fine.
I can access mysql with phpmyadmin without trouble.
But after the update, I can longer access ISPConfig interface on port 8080.
The error message at the browser is -

"Database Error: Unable to connect to the database:Could not connect to database"

I have no errors accessing databases using mysql, including dbispconfig using "mysql -h localhost -u ispconfig -p (using password from ../interface/lib/config.inc.php)"

I have searched all relevant log files, but find nothing.

Everything on the server works great, just no ISPConfig interface.

Any Ideas?

*******************************
Till said -

Please check that the php mysqli commands are available.
__________________
Till Brehm
********************************
I replied -
MySQLi is installed and available.
Here is the display for mysql & mysqli from PHP_INFO -

mysql

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.95
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli

MysqlI Support enabled
Client API library version 5.0.95
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Client API header version 5.0.77
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off


Any other suggestions?
*****************************

I could really use some help here.

Thanks.

Lonnie
Reply With Quote
Sponsored Links
  #2  
Old 19th April 2013, 08:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,788
Thanks: 840
Thanked 5,612 Times in 4,423 Posts
Default

Please post the output of:

netstat -tap | grep mysql

Quote:
But after the update, I can longer access ISPConfig interface on port 8080.
The error message at the browser is -
Do you get any additional php error messages in the global apache error.log?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.

Last edited by till; 19th April 2013 at 08:47.
Reply With Quote
  #3  
Old 20th April 2013, 02:00
lmason674 lmason674 is offline
Junior Member
 
Join Date: Jul 2012
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by till View Post
Please post the output of:

netstat -tap | grep mysql



Do you get any additional php error messages in the global apache error.log?
This is the only error that appears in apache error log when I access ispconfig on port :8080 -
"[Fri Apr 19 16:42:16 2013] [error] [client 192.168.0.44] File does not exist: /var/www/html/favicon.ico"

I did find this error in /var/log/ispconfig_install.log -
"Thu Apr 18 13:49:24 MDT 2013 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1489: WARNING: Failed to execute the command adduser apache ispapps"

I have searched system log files and that is all I found.

[root@cbsserv ~]# netstat -tap | grep mysql
tcp 0 0 *:mysql *:* LISTEN 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:36655 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:36723 localhost.localdomain:mysql ESTABLISHED 17512/amavisd (ch17
tcp 0 0 localhost.localdomain:36655 localhost.localdomain:mysql ESTABLISHED 17509/amavisd (ch19
tcp 0 0 localhost.localdomain:38032 localhost.localdomain:mysql ESTABLISHED 8322/smtpd
tcp 0 0 localhost.localdomain:38036 localhost.localdomain:mysql TIME_WAIT -
tcp 0 0 localhost.localdomain:38037 localhost.localdomain:mysql ESTABLISHED 8323/proxymap
tcp 0 0 localhost.localdomain:38026 localhost.localdomain:mysql ESTABLISHED 8323/proxymap
tcp 0 0 localhost.localdomain:38027 localhost.localdomain:mysql ESTABLISHED 8325/trivial-rewrit
tcp 0 0 localhost.localdomain:38025 localhost.localdomain:mysql ESTABLISHED 8323/proxymap
tcp 0 0 localhost.localdomain:38030 localhost.localdomain:mysql ESTABLISHED 8322/smtpd
tcp 0 0 localhost.localdomain:38031 localhost.localdomain:mysql ESTABLISHED 8323/proxymap
tcp 0 0 localhost.localdomain:38028 localhost.localdomain:mysql ESTABLISHED 8322/smtpd
tcp 0 0 localhost.localdomain:38029 localhost.localdomain:mysql ESTABLISHED 8322/smtpd
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:36723 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38028 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38029 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38030 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38031 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38025 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38026 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38027 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38037 ESTABLISHED 26983/mysqld
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:38032 ESTABLISHED 26983/mysqld
[root@cbsserv ~]#

Lonnie
Reply With Quote
  #4  
Old 20th April 2013, 10:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Can you enable the MySQL log in /etc/my.cnf so that MySQL logs all queries? That way you should be able to find out what queries are executed when you try to log into ISPConfig, and what query is causing the problem.

The options to enable logging in my.cnf should be something like this:
Code:
general_log_file        = /var/log/mysql/mysql.log
general_log             = 1
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 20th April 2013, 22:49
lmason674 lmason674 is offline
Junior Member
 
Join Date: Jul 2012
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

FYI: The syntax in my.cnf for MySQL 5.0.95 is "log={file location}"

Here is the query from the log file -
***********
/usr/libexec/mysqld, Version: 5.0.95-log (Source distribution). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
130420 13:27:51 1 Connect Access denied for user 'UNKNOWN_MYSQL_US'@'localhost' (using password: NO)
130420 13:27:57 2 Connect root@localhost on
2 Query SET NAMES 'utf8'
2 Quit
***********

Other query entries show that ispconfig@localhost on dbispconfig for mail transport works correctly.
Reply With Quote
  #6  
Old 21st April 2013, 12:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Can you post all the MySQL queries that are executed when you try to access ISPConfig?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 21st April 2013, 21:04
lmason674 lmason674 is offline
Junior Member
 
Join Date: Jul 2012
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by falko View Post
Can you post all the MySQL queries that are executed when you try to access ISPConfig?
This is a production server so there is a large number of entries in a query log.

Here is a log file capture I ran for a few seconds. I started the log, attempted to access ISPConfig, and stopped the log. The log shows a website being accessed and email being processed. In the middle is a highlighted entry. This is when I attempted to run the ISPConfig interface -
***************
/usr/libexec/mysqld, Version: 5.0.95-log (Source distribution). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
130421 11:38:20 1 Connect Access denied for user 'UNKNOWN_MYSQL_US'@'localhost' (using password: NO)
130421 11:38:27 2 Connect c1_db_user@localhost on
2 Query SET NAMES 'utf8'
2 Init DB c1_csbs
2 Query SET sql_mode = 'MYSQL40'
2 Query SELECT * FROM csbs_session WHERE session_id = 'hkt9fdlihd8fck9i3badaecqh1'
2 Query DELETE FROM csbs_session WHERE ( time < '1366565007' )
2 Query SELECT * FROM csbs_session WHERE session_id = 'hkt9fdlihd8fck9i3badaecqh1'
2 Query UPDATE `csbs_session` SET `time`='1366565907',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1',`client_id`='0',` data`='__default|a:7:{s:15:\"session.counter\";i:1 ;s:19:\"session.timer.start\";i:1366565882;s:18:\" session.timer.last\";i:1366565882;s:17:\"session.t imer.now\";i:1366565882;s:22:\"session.client.brow ser\";s:74:\"Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; Qwest 1.0)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17: \"_defaultNameSpace\";s:7:\"session\";s:9:\"_regis try\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\ "stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"use r\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\"; N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"passwor d\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usert ype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3: \"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvis itDate\";N;s:10:\"activation\";N;s:6:\"params\";N; s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\"; O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\ "_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementP ath\";a:1:{i:0;s:73:\"/var/www/clients/client1/web3/web/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_defau lt\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{ s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\ ";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{ }}}' WHERE session_id='hkt9fdlihd8fck9i3badaecqh1'
2 Query SELECT * FROM csbs_components WHERE parent = 0
2 Query SELECT folder AS type, element AS name, params FROM csbs_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
2 Query SELECT m.*, c.`option` as component FROM csbs_menu AS m LEFT JOIN csbs_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDER BY m.sublevel, m.parent, m.ordering
2 Query SELECT id FROM csbs_plugins WHERE element = 'joomsef' AND folder = 'system' AND published = 1
2 Query SELECT * FROM csbs_sefurls WHERE sefurl = '' OR sefurl = 'index.php' LIMIT 1
2 Query SELECT `file`, `params` FROM `csbs_sefexts`
2 Query SELECT template FROM csbs_templates_menu WHERE client_id = 0 AND (menuid = 0 OR menuid = 1) ORDER BY menuid DESC LIMIT 0, 1
2 Query SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email as author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering FROM csbs_content AS a INNER JOIN csbs_content_frontpage AS f ON f.content_id = a.id LEFT JOIN csbs_categories AS cc ON cc.id = a.catid LEFT JOIN csbs_sections AS s ON s.id = a.sectionid LEFT JOIN csbs_users AS u ON u.id = a.created_by LEFT JOIN csbs_groups AS g ON a.access = g.id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-04-21 17:38:27' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-04-21 17:38:27' ) ORDER BY f.ordering LIMIT 0, 9
2 Query SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email as author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering FROM csbs_content AS a INNER JOIN csbs_content_frontpage AS f ON f.content_id = a.id LEFT JOIN csbs_categories AS cc ON cc.id = a.catid LEFT JOIN csbs_sections AS s ON s.id = a.sectionid LEFT JOIN csbs_users AS u ON u.id = a.created_by LEFT JOIN csbs_groups AS g ON a.access = g.id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-04-21 17:38:27' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-04-21 17:38:27' ) ORDER BY f.ordering
2 Query SELECT `filters` FROM `csbs_sefexts` WHERE `file` = 'com_content.xml' LIMIT 1
2 Query SELECT `w`.`word`, `u`.`sefurl`, `u`.`metatitle` FROM `csbs_sefwords` AS `w` INNER JOIN `csbs_sefurlword_xref` AS `x` ON `w`.`id` = `x`.`word` INNER JOIN `csbs_sefurls` AS `u` ON `u`.`id` = `x`.`url`
2 Query SELECT id, title, module, position, content, showtitle, control, params FROM csbs_modules AS m LEFT JOIN csbs_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 1 OR mm.menuid = 0 ) ORDER BY position, ordering
2 Query SELECT * FROM `csbs_sefurls` WHERE `origurl` = 'index.php?option=com_content&id=1&layout=blog&vie w=category' LIMIT 2
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '7'
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '8'
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '9'
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '3'
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '4'
130421 11:38:28 2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '2'
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '5'
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '25'
2 Query SELECT `catid` FROM `csbs_content` WHERE `id` = '16'
2 Query SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM csbs_content AS a INNER JOIN csbs_categories AS cc ON cc.id = a.catid INNER JOIN csbs_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-04-21 17:38:27' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-04-21 17:38:27' ) AND s.id > 0 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (cc.id=5) AND s.published = 1 AND cc.published = 1 ORDER BY a.ordering ASC LIMIT 0, 5
2 Query SELECT * FROM csbs_banner WHERE showBanner = 1 AND (imptotal = 0 OR impmade < imptotal) AND cid = 1 AND catid = 8 ORDER BY sticky DESC, ordering LIMIT 0, 2
2 Query UPDATE csbs_banner SET impmade = impmade + 1 WHERE bid = 2
2 Query UPDATE csbs_banner SET impmade = impmade + 1 WHERE bid = 3
2 Query SELECT `filters` FROM `csbs_sefexts` WHERE `file` = 'com_banners.xml' LIMIT 1
2 Query SELECT * FROM `csbs_sefurls` WHERE `origurl` = 'index.php?option=com_banners&bid=2&task=click' LIMIT 2
2 Query SELECT * FROM `csbs_sefurls` WHERE `origurl` = 'index.php?option=com_banners&bid=3&task=click' LIMIT 2
2 Query SELECT * FROM csbs_session WHERE session_id = 'hkt9fdlihd8fck9i3badaecqh1'
2 Query UPDATE `csbs_session` SET `time`='1366565907',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1',`client_id`='0',` data`='__default|a:7:{s:15:\"session.counter\";i:2 ;s:19:\"session.timer.start\";i:1366565882;s:18:\" session.timer.last\";i:1366565882;s:17:\"session.t imer.now\";i:1366565907;s:22:\"session.client.brow ser\";s:74:\"Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; Qwest 1.0)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17: \"_defaultNameSpace\";s:7:\"session\";s:9:\"_regis try\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\ "stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"use r\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\"; N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"passwor d\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usert ype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3: \"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvis itDate\";N;s:10:\"activation\";N;s:6:\"params\";N; s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\"; O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\ "_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementP ath\";a:1:{i:0;s:73:\"/var/www/clients/client1/web3/web/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_defau lt\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{ s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\ ";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{ }}}' WHERE session_id='hkt9fdlihd8fck9i3badaecqh1'
2 Quit
130421 11:38:40 3 Connect root@localhost on
3 Query SET NAMES 'utf8'
3 Quit

130421 11:38:44 4 Connect ispconfig@localhost on dbispconfig
4 Query SELECT password FROM mail_user WHERE (login = 'mail1@coloradosbs.net' OR email = 'mail1@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = 'mail1@coloradosbs.net' OR email = 'mail1@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT password FROM mail_user WHERE (login = 'mail2@coloradosbs.net' OR email = 'mail2@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = 'mail2@coloradosbs.net' OR email = 'mail2@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT password FROM mail_user WHERE (login = 'mail3@coloradosbs.net' OR email = 'mail3@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = 'mail3@coloradosbs.net' OR email = 'mail3@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT password FROM mail_user WHERE (login = 'mail4@coloradosbs.net' OR email = 'mail4@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = 'mail4@coloradosbs.net' OR email = 'mail4@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT password FROM mail_user WHERE (login = 'mail5@coloradosbs.net' OR email = 'mail5@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = 'mail5@coloradosbs.net' OR email = 'mail5@coloradosbs.net') AND disablepop3 = 'n'
4 Query SELECT password FROM mail_user WHERE (login = 'admin@coloradocarsandtrucks.com' OR email = 'admin@coloradocarsandtrucks.com') AND disablepop3 = 'n'
4 Query SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = 'admin@coloradocarsandtrucks.com' OR email = 'admin@coloradocarsandtrucks.com') AND disablepop3 = 'n'

***************

I repeated this log capture several times to insure the results were the same.

Lonnie
Reply With Quote
  #8  
Old 21st April 2013, 21:13
lmason674 lmason674 is offline
Junior Member
 
Join Date: Jul 2012
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Here is another query log capture. I stopped all other process on the server that would write to the log. I started the log, tried to access ISPConfig 4 times and then stopped the log. -
***************
/usr/libexec/mysqld, Version: 5.0.95-log (Source distribution). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
130421 11:20:19 1 Connect Access denied for user 'UNKNOWN_MYSQL_US'@'localhost' (using password: NO)
130421 11:20:34 2 Connect root@localhost on
2 Query SET NAMES 'utf8'
2 Quit
130421 11:20:36 3 Connect root@localhost on
3 Query SET NAMES 'utf8'
3 Quit
130421 11:20:37 4 Connect root@localhost on
4 Query SET NAMES 'utf8'
4 Quit
130421 11:20:38 5 Connect root@localhost on
5 Query SET NAMES 'utf8'
5 Quit
*************

Hope this helps.

Lonnie
Reply With Quote
  #9  
Old 21st April 2013, 21:27
lmason674 lmason674 is offline
Junior Member
 
Join Date: Jul 2012
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

I don't assume to know the answers here, but it looks like there is no database name being passed during the "connect".
Won't it be "connect root@localhost on dbispconfig"?

Last edited by lmason674; 21st April 2013 at 21:53.
Reply With Quote
  #10  
Old 22nd April 2013, 12:24
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,788
Thanks: 840
Thanked 5,612 Times in 4,423 Posts
 
Default

In the ispconfig code, username, password, host and database name are passed in the __construct function of the mysqli object. Is the database name set in the file /usr/local/ispconfig/interface/lib/config.inc.php ?

What irritates me is that all your other sites are working with mysql db (or maybe they dont use mysqli and just mysql is working?) and on the other hand there are no known issues with the ispconfig mysqli library which is installed on thousands of servers already.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix on mac (snow leopard) / php mail() won't work (Operation timed out…) aebbeeri Server Operation 4 13th October 2010 19:33
Forbidden 403; Samba access; config of maildeamon fawkes Installation/Configuration 4 14th January 2010 19:16
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 06:19
Howto suggestion suse PhP ver 4 + Ver 5 wwparrish Suggest HOWTO 11 7th August 2006 14:29
Perfect Xen 3.0 setup for Debian gurneyzap HOWTO-Related Questions 4 26th March 2006 12:30


All times are GMT +2. The time now is 08:11.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.