Re: [courier-users] Log analyser for Courier mail logs

2009-01-23 Thread Frederik Dannemare 
On Friday 23 January 2009 04:57, Tim Lyth wrote:
 Hi all,

 Apart from courier-analog, can anyone recommend any log analyser
 programs that can read courier mail logs?

I use my own little analyzer to show me the things I care about. The 
code may not be as effective (speed-wise) as it could be, but it gets 
the job done and I'm happy with it. It's available at 
http://sentinel.dk/courier-mail-statistics.sh

I simply run it once a week from cron. A weekly report looks like this: 
http://sentinel.dk/courier-mail-statistics.txt

B/R,
Frederik Dannemare

--
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
___
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Re: [courier-users] pythonfilter and sql

2009-01-23 Thread Ricardo Kleemann 
Hi Gordon,

I've configured pythonfilter-modules.conf with the correct entries, and I 
double checked by logging intomysql with the same info. However pythonfilter 
is not able to login.

Error from pythonfilter:
Jan 23 10:43:05 email1 courierfilter: Could not open auto_whitelist TtlDb: 
Failed to open pythonfilter SQL db, check settings in 
pythonfilter-modules.conf

Config in pythonfilter-modules.conf:
[TtlDb]
# dbmType can be dbm (dbm file), psycopg2 (postgresql database),
# or mysql (mysql database)
type = 'mysql'
# The 'dbm' db type requires a dmbDir
#dir = '/var/lib/pythonfilter'
# SQL db types require host, port, database name, username, and password
host = 'mysql'
# port = '5432'
db = 'pythonfilter'
user = 'pythonfilter'
password = 'x'


Logging into mysql with same info:
$ mysql pythonfilter -hmysql -upythonfilter -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 484193
Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql

- Original Message - 
From: Gordon Messmer yiny...@eburg.com
To: courier-users@lists.sourceforge.net
Sent: Wednesday, January 21, 2009 5:54 PM
Subject: Re: [courier-users] pythonfilter and sql


 Ricardo Kleemann wrote:

 Where do I find the sql table definition for the pythonfilter db?

 You don't.  Create a database owned by the user indicated in
 pythonfilter-modules.conf and the tables will be created automatically.


 --
 This SF.net email is sponsored by:
 SourcForge Community
 SourceForge wants to tell your story.
 http://p.sf.net/sfu/sf-spreadtheword
 ___
 courier-users mailing list
 courier-users@lists.sourceforge.net
 Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
 


--
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
___
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Re: [courier-users] pythonfilter and sql

2009-01-23 Thread Gordon Messmer 
Ricardo Kleemann wrote:
 
 Error from pythonfilter:
 Jan 23 10:43:05 email1 courierfilter: Could not open auto_whitelist TtlDb: 
 Failed to open pythonfilter SQL db, check settings in 
 pythonfilter-modules.conf
 
 Config in pythonfilter-modules.conf:
 [TtlDb]
 # dbmType can be dbm (dbm file), psycopg2 (postgresql database),
 # or mysql (mysql database)
 type = 'mysql'
 # The 'dbm' db type requires a dmbDir
 #dir = '/var/lib/pythonfilter'
 # SQL db types require host, port, database name, username, and password
 host = 'mysql'
 # port = '5432'
 db = 'pythonfilter'
 user = 'pythonfilter'
 password = 'x'

port is not an optional setting with the SQL adapters.  You must 
specify a port.

--
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
___
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users