I'm seeing these errors multiple times a day in epylog. Can someone with some accounts-system-fu take a look?
Oct 28 12:33:53 db1 postgres[11033]: [2-1] ERROR: relation "valid" does not exist Oct 28 12:33:53 db1 postgres[11033]: [2-2] STATEMENT: SELECT id FROM valid WHERE name = 'valid' Oct 28 12:33:53 db1 postgres[11033]: [3-1] ERROR: syntax error at or near ")" at character 179 Oct 28 12:33:53 db1 postgres[11033]: [3-2] STATEMENT: SELECT username , username,human_name, email FROM person WHERE Oct 28 12:33:53 db1 postgres[11033]: [3-3] LOWER(mail) LIKE LOWER('mjergg@arkansas-realestate.com') AND id in ( ) LIMIT 250
thanks,
luke
On 10/29/06, Luke Macken lmacken@redhat.com wrote:
I'm seeing these errors multiple times a day in epylog. Can someone with some accounts-system-fu take a look?
Oct 28 12:33:53 db1 postgres[11033]: [2-1] ERROR: relation "valid" does not exist Oct 28 12:33:53 db1 postgres[11033]: [2-2] STATEMENT: SELECT id FROM valid WHERE name = 'valid' Oct 28 12:33:53 db1 postgres[11033]: [3-1] ERROR: syntax error at or near ")" at character 179 Oct 28 12:33:53 db1 postgres[11033]: [3-2] STATEMENT: SELECT username , username,human_name, email FROM person WHERE Oct 28 12:33:53 db1 postgres[11033]: [3-3] LOWER(mail) LIKE LOWER('mjergg@arkansas-realestate.com') AND id in ( ) LIMIT 250
I tried to check, but it seems the code generating these queries isn't in fedora-accounts cvs. Might be some restricted codes, nah?
On Mon, 2006-10-30 at 19:49 +0330, Farshad Khoshkhui wrote:
On 10/29/06, Luke Macken lmacken@redhat.com wrote:
I'm seeing these errors multiple times a day in epylog. Can someone with some accounts-system-fu take a look?
Oct 28 12:33:53 db1 postgres[11033]: [2-1] ERROR: relation "valid" does not exist Oct 28 12:33:53 db1 postgres[11033]: [2-2] STATEMENT: SELECT id FROM valid WHERE name = 'valid' Oct 28 12:33:53 db1 postgres[11033]: [3-1] ERROR: syntax error at or near ")" at character 179 Oct 28 12:33:53 db1 postgres[11033]: [3-2] STATEMENT: SELECT username , username,human_name, email FROM person WHERE Oct 28 12:33:53 db1 postgres[11033]: [3-3] LOWER(mail) LIKE LOWER('mjergg@arkansas-realestate.com') AND id in ( ) LIMIT 250
I tried to check, but it seems the code generating these queries isn't in fedora-accounts cvs. Might be some restricted codes, nah?
A brief grep doesn't show these calls in the code on our custom web apps deployed on admin.fedoraproject.org. Where else are we calling the account system?
-Toshio
On 10/31/06, Toshio Kuratomi a.badger@gmail.com wrote:
On Mon, 2006-10-30 at 19:49 +0330, Farshad Khoshkhui wrote:
On 10/29/06, Luke Macken lmacken@redhat.com wrote:
I'm seeing these errors multiple times a day in epylog. Can someone with some accounts-system-fu take a look?
Oct 28 12:33:53 db1 postgres[11033]: [2-1] ERROR: relation "valid" does not exist Oct 28 12:33:53 db1 postgres[11033]: [2-2] STATEMENT: SELECT id FROM valid WHERE name = 'valid' Oct 28 12:33:53 db1 postgres[11033]: [3-1] ERROR: syntax error at or near ")" at character 179 Oct 28 12:33:53 db1 postgres[11033]: [3-2] STATEMENT: SELECT username , username,human_name, email FROM person WHERE Oct 28 12:33:53 db1 postgres[11033]: [3-3] LOWER(mail) LIKE LOWER('mjergg@arkansas-realestate.com') AND id in ( ) LIMIT 250
I tried to check, but it seems the code generating these queries isn't in fedora-accounts cvs. Might be some restricted codes, nah?
A brief grep doesn't show these calls in the code on our custom web apps deployed on admin.fedoraproject.org. Where else are we calling the account system?
-Toshio
OTRS comes to mind, it does searches and things when a new ticket comes in via email to try to figure out who sent it.
-Mike
infrastructure@lists.fedoraproject.org