You're not getting it. Where do you have the login values in syslog, with trace_level=5 ?
There's no way to have that in syslog of other log file without raising the log level, and that yes, will kill dbmail performance. There's no way that you can convence (ok word bad written) me, if you don't want such feature, just don't enable it and stay with your syslog graph's! This is for login/logout records with some extra info. For the delivered emails log, it's crazy to be doing this with syslog when dbmail just can do it in an easy way. Dbmail is so easy to configure, why now to implement such feature that is very very important, do it with third party tools in an "crazy" way. I'm sure that having dbmail-lmtpd inserting there records in am *SQL table, is a lot easyer than having an perl script or other, checking the syslog file as it changes, cutting and rearranging the data and then inserting it in the database, this will be more expensive for the system, Aaron/Paul forgive me on this, but I put my hands on fire with the comparation of dbmail inserting directly in the database or having a script checking syslog and then inserting in the database, I'm sure dbmail doing is much faster. But for you Anne, and other who doesn't want this, just don't enable it. You guys that doesn't want, have to forgive me too, but you're just not getting the advantages of it. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anne Sent: quarta-feira, 12 de Setembro de 2007 12:44 To: DBMail mailinglist Subject: Re: [Dbmail] Log table ************************* *** The info is in the logfiles *** ************************* Did you actually check if there is such a tool like mailgraph which gives you the info you want? Alternatively, extract the info you need each day or whatever and store it into your own database. Please, don't turn this into our problem while it's only *your* problem. That's why this is important to be dbmail job. Nothing else will give you the login/logout and extra information I said. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anne Sent: quarta-feira, 12 de Setembro de 2007 12:19 To: DBMail mailinglist Subject: Re: [Dbmail] Log table I said *such a tool* is the only correct way to get the stats you want. If it doesn't exist (which would surprise me), I suggest you make one :-) That doesn't give me the information I want. Where's the login/logout information? Dates, times, etc? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anne Sent: quarta-feira, 12 de Setembro de 2007 11:58 To: DBMail mailinglist Subject: Re: [Dbmail] Log table We use "mailgraph" for mail statistics. This tool extracts data from the logfiles and keeps its own database. http://mailgraph.schweikert.ch/ IMHO such a tool is the only correct way to get the stats you want. dbmail should *not* be used for storing metadata! Anne The point is: For delivered messages, if you want to confirm something two weeks ago, with syslog you won't be able to get that information. My server has some high traffic during the day, and my syslog files get around 80MB a day, I delete them every Saturday night, there it goes the logging information. A syslog file with 80MB of data, will represent in a 10 or less in a MySAM table. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Dirix Sent: quarta-feira, 12 de Setembro de 2007 11:05 To: DBMail mailinglist Subject: Re: [Dbmail] Log table A server with that kind of simultaneous logins will not be a P4 3.0GHZ with HT and 1GB of RAM for sure. Please stop assuming that the key to add more scalability is to throw more (expensive) hardware at it. DBMail already is pretty generous in the harddisk space it takes, adding more to it will slow it down exponentially. Although I can see the point in having more database statistics in the sort of "last_login, total_bytes, total_messages", dissagree implementing this in a growing table fashion. But agree with Josh and Vladimir and Paul: we do *not* want to replace syslog, syslog is in general sufficient for admins to look into mailproblems. Marc _____ _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail _____ _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail _____ _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
