On 10/31/06, Toshio Kuratomi <a.badger@xxxxxxxxx> wrote:
On Mon, 2006-10-30 at 19:49 +0330, Farshad Khoshkhui wrote:
> On 10/29/06, Luke Macken <lmacken@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxx') 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
