michael.monnerie at is
Feb 17, 2009, 12:11 AM
Views: 255
Permalink
|
|
unneeded SELECT on dbmail-2.2.11
|
|
SELECT userid FROM dbmail_usermap WHERE 1 = 2
That SELECT should be removed I'd suggest. I just saw it in the logs in
this context:
2009-02-17 09:07:47 CET pid=23780 17/101776 idle: LOG: statement:
SELECT userid FROM dbmail_usermap WHERE 1 = 2
2009-02-17 09:07:47 CET pid=23780 17/101777 idle: LOG: statement:
SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE
login in ('zmi-intern[at]i.zmi.at','ANY') ORDER BY sock_allow, sock_deny
2009-02-17 09:07:47 CET pid=23780 17/101778 idle: LOG: statement:
SELECT user_idnr FROM dbmail_users WHERE lower(userid) =
lower('user1[at]mee.at')
2009-02-17 09:07:47 CET pid=23780 17/101779 idle: LOG: statement:
SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE
user_idnr = 152
2009-02-17 09:07:47 CET pid=23780 17/101780 idle: LOG: statement:
UPDATE dbmail_users SET last_login = '2009-02-17 09:07:47' WHERE
user_idnr = 152
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
unneeded SELECT on dbmail-2.2.11