[horde] Re: LOG_DEBUG [Correction] ?

[Frederic Trudeau]

Oh but wait up, I just noticed something interesting.
I log everything from mysqld : errors, queries, and updates

I just noticed that the Logout + Failed queris do not appear in the
updates.log file from mysqld,
but Login success do  :

insert into log_table
              values(1031258854, 'HORDE', 5, '[imp] Login success for ftrudo
[198.73.180.250] to {imap.cam.org:143} [on line 64 of
"/mnt/fileserver/data/home_camweb/dev.webmail.cam.org/horde/imp/redirect.php
"]');

Im puzzled.

---------------------------------------------------
Frederic Trudeau
PHP Coder, Colocation, Development
ftrudeau at cam.org
514.529.3000 ext. 246

----- Original Message -----
From: "Frederic Trudeau" <ftrudeau at cam.org>
To: "Chuck Hagenbuch" <chuck at horde.org>
Cc: <horde at lists.horde.org>
Sent: Thursday, September 05, 2002 4:53 PM
Subject: Re: [horde] Re: LOG_DEBUG [Correction] ?


> Yes, they are being made ...
>
> 020905 16:47:33     144 Connect     hordemgr at pegasus on
>                     144 Init DB     horde
>                     144 Query       select pref_scope, pref_name,
pref_value
> from horde_prefs where pref_uid = 'ftrudo' and (pref_scope = 'imp' or
> pref_scope = 'horde') order by pref_scope
> 020905 16:47:34     144 Statistics
>                     144 Query       insert into log_table
>               values(1031258854, 'HORDE', 5, '[imp] Login success for
ftrudo
> [198.73.180.250] to {imap.cam.org:143} [on line 64 of
>
"/mnt/fileserver/data/home_camweb/dev.webmail.cam.org/horde/imp/redirect.php
> "]')
>                     144 Query       select pref_value from horde_prefs
where
> pref_uid = 'ftrudo' and pref_name = 'last_login' and (pref_scope = 'imp'
or
> pref_scope = 'horde')
>                     144 Query       update horde_prefs set pref_value =
> 1031258854 where pref_uid = 'ftrudo' and pref_name = 'last_login' and
> pref_scope = 'imp'
>                     144 Quit
> 020905 16:47:50     145 Connect     hordemgr at pegasus on
>                     145 Query       insert into log_table
>               values(1031258870, 'HORDE', 5, '[imp] Logout for ftrudo
> [198.73.180.250] from {imap.cam.org:143} [on line 34 of
>
"/mnt/fileserver/data/home_camweb/dev.webmail.cam.org/horde/imp/login.php"]'
> )
>                     145 Quit
> 020905 16:48:15     146 Connect     hordemgr at pegasus on
>                     146 Query       insert into log_table
>               values(1031258895, 'HORDE', 3, '[imp] FAILED LOGIN
> 198.73.180.250 to imap.cam.org:143[imap] as ftrudo [on line 270 of
>
"/mnt/fileserver/data/home_camweb/dev.webmail.cam.org/horde/imp/lib/IMP.php"
> ]')
>                     146 Quit
>
> In the above queries, all that will be logged is the "Login success for
> ftrudo" entry.
>
> This is very scary.
>
>
>
> ---------------------------------------------------
> Frederic Trudeau
> PHP Coder, Colocation, Development
> ftrudeau at cam.org
> 514.529.3000 ext. 246
>
> ----- Original Message -----
> From: "Chuck Hagenbuch" <chuck at horde.org>
> To: "Frederic Trudeau" <ftrudeau at cam.org>
> Cc: <horde at lists.horde.org>
> Sent: Monday, August 26, 2002 1:47 AM
> Subject: Re: [horde] Re: LOG_DEBUG [Correction] ?
>
>
> > Quoting Frederic Trudeau <ftrudeau at cam.org>:
> >
> > > When I try to log LOG_DEBUG level messages in SQL, I end up only with
> > > Login success messages, that is piority 5 messages, which are notices
I
> > > think. However,  I get notices, info, errors and everything else if I
> use
> > > a file, instead of SQL.
> >
> > Did you check your SQL server's logs to see if any other queries were
> being
> > made, or otherwise trace anything to see what happens to the other
> messages
> > under SQL?
> >
> > -chuck
> >
> > --
> > Charles Hagenbuch, <chuck at horde.org>
> > "After a few minutes the most aromatic and nice smelling Italian coffee
> >  will come out of the exhaustpipe." - Our stove-top espresso pot
> >
> >
>