Hello Gordon,
I'm trying to switch from your Pythonfilter 1.5 and PostgreSQL storage
to Pythonfilter 1.6 and MySQL storage. Unfortunately it doesn't work
for me :(
Firsty, when I start Pythonfilter, then it displays me the following
warning messages:
Jun 29 15:57:15 apollo4 courierfilter: Starting pythonfilter
Jun 29 15:57:15 apollo4 courierfilter:
/var/lib/python-support/python2.6/courier/config.py:48:
DeprecationWarning: os.popen4 is deprecated. Use the subprocess module.
Jun 29 15:57:15 apollo4 courierfilter: (chIn, chOut) =
os.popen4('courier-config')
Jun 29 15:57:15 apollo4 courierfilter:
/var/lib/python-support/python2.6/courier/config.py:68:
DeprecationWarning: os.popen4 is deprecated. Use the subprocess module.
Jun 29 15:57:15 apollo4 courierfilter: (chIn, chOut) =
os.popen4('%s/courier --version' % sbindir)
Jun 29 15:57:15 apollo4 courierfilter: Initialized the "whitelist_auth"
python filter
Jun 29 15:57:15 apollo4 courierfilter: Initialized the "whitelist_block"
python filter
Jun 29 15:57:15 apollo4 courierfilter:
/var/lib/python-support/python2.6/pythonfilter/greylist.py:21:
DeprecationWarning: the md5 module is deprecated; use hashlib instead
Jun 29 15:57:15 apollo4 courierfilter: import md5
Jun 29 15:57:15 apollo4 courierfilter:
/var/lib/python-support/python2.6/MySQLdb/__init__.py:34:
DeprecationWarning: the sets module is deprecated
Jun 29 15:57:15 apollo4 courierfilter: from sets import ImmutableSet
Jun 29 15:57:15 apollo4 courierfilter: Initialized the "greylist" python
filter
Secondly, the latest version of Pythonfilter can't create automagically
tables "greylist_passed" and "greylist_notpassed" in my "pythonfilter"
database:
Jun 29 16:03:19 apollo4 courierfilter: Uncaught exception in "greylist"
doFilter function: <class '_mysql_exceptions.ProgrammingError'>:(1146,
"Table 'pythonfilter.greylist_Passed' doesn't exist")
Jun 29 16:03:19 apollo4 courierfilter: File
"/etc/courier/filters/active/pythonfilter", line 200, in processMessage
Jun 29 16:03:19 apollo4 courierfilter: replyCode = i_filter[1](bodyFile,
controlFileList)
Jun 29 16:03:19 apollo4 courierfilter: File
"/var/lib/python-support/python2.6/pythonfilter/greylist.py", line 104,
in doFilter
Jun 29 16:03:19 apollo4 courierfilter: _sendersPassed.purge()
Jun 29 16:03:19 apollo4 courierfilter: File
"/var/lib/python-support/python2.6/pythonfilter/TtlDb.py", line 159, in
purge
Jun 29 16:03:19 apollo4 courierfilter: (('value', minVal),))
Jun 29 16:03:19 apollo4 courierfilter: File
"/var/lib/python-support/python2.6/pythonfilter/TtlDb.py", line 134, in
_dbWrite
Jun 29 16:03:19 apollo4 courierfilter: c = self._dbExec(query, params)
Jun 29 16:03:19 apollo4 courierfilter: File
"/var/lib/python-support/python2.6/pythonfilter/TtlDb.py", line 113, in
_dbExec
Jun 29 16:03:19 apollo4 courierfilter: c.execute(query, exec_params)
Jun 29 16:03:19 apollo4 courierfilter: File
"/var/lib/python-support/python2.6/MySQLdb/cursors.py", line 166, in execute
Jun 29 16:03:19 apollo4 courierfilter: self.errorhandler(self, exc, value)
Jun 29 16:03:19 apollo4 courierfilter: File
"/var/lib/python-support/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
Jun 29 16:03:19 apollo4 courierfilter: raise errorclass, errorvalue
I remember that Pythonfilter created them for PostgreSQL without my
help. Do I need to create these tables for MySQL manually?
I have Ubuntu Jaunty box with the following Python packages:
python 2.6.2-0ubuntu1
python-apt 0.7.9~exp2ubuntu10
python-central 0.6.11ubuntu7
python-egenix-mxdatetime 3.1.1-1ubuntu1
python-egenix-mxtools 3.1.1-1ubuntu1
python-gdbm 2.6.2-0ubuntu1
python-gnupginterface 0.3.2-9ubuntu2
python-minimal 2.6.2-0ubuntu1
python-mysqldb 1.2.2-7ubuntu1
python-psycopg2 2.0.8-0ubuntu2
python-support 0.8.7ubuntu4
python2.4 2.4.6-1ubuntu3
python2.4-minimal 2.4.6-1ubuntu3
python2.6 2.6.2-0ubuntu1
python2.6-minimal 2.6.2-0ubuntu1
My best regards,
Pawel
------------------------------------------------------------------------------
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
