View Single Post
  #7  
Old 21st April 2013, 20: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