Yes, web admin interface works and extend.py is in the place
(/var/lib/mailman/lists/list-name). And I've been checking logs in
/var/log/mailman. I've added this line to mm_cfg.py:
MYSQL_MEMBER_DB_VERBOSE = "4"
and I've found this in error log:
Aug 31 13:03:14 2011 (16396) Uncaught runner exception: (1064, "You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'TYPE=MyISAM' at
line 24")
Aug 31 13:03:14 2011 (16396) Traceback (most recent call last):
File "/usr/lib/mailman/Mailman/Queue/Runner.py", line 113, in _oneloop
self._onefile(msg, msgdata)
File "/usr/lib/mailman/Mailman/Queue/Runner.py", line 151, in _onefile
mlist = self._open_list(listname)
File "/usr/lib/mailman/Mailman/Queue/Runner.py", line 196, in _open_list
mlist = MailList.MailList(listname, lock=False)
File "/usr/lib/mailman/Mailman/MailList.py", line 125, in __init__
func(self)
File "/var/lib/mailman/lists/clani/extend.py", line 6, in extend
list._memberadaptor = MysqlMemberships(list)
File "/usr/lib/mailman/Mailman/MysqlMemberships.py", line 92, in __init__
message = "MysqlMemberships " \
File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163,
in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line
35, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'TYPE=MyISAM' at line 24")
Aug 31 13:03:14 2011 (16396) SHUNTING:
1314788594.28422+2ce0db1b09dddbc0a14b8eaa0701fa568dcd9196
Aug 31 13:03:14 2011 qrunner(16396): Exception
exceptions.AttributeError : "MysqlMemberships instance has no attribute
'conn'" in <bound method MysqlMemberships.__del__ of
<Mailman.MysqlMemberships.MysqlMemberships instance at 0x9e07d0c>> ignored
It looks like there is something wrong in MysqlMemberships.py file? I've
checked the file but there is not 'TYPE=MyISAM' in it....
Klemen Humerca
( [email protected] | www.humerca.com)
Dne 31.8.2011 20:07, piše Mark Sapiro:
Klemen Humerca wrote:
But emails are not send to list members. If I change it back to "file
based db" (remove extend.py) mails are delivered.
I'm using Mailman version 2.1.9 on CentOS. There is nothing in the
Mailman logs. I can see that queries in mysql are executed and I also
tested connection to Mysql from python. Everything works, just mails are
not send to members.
Do you mean the web admin interface works and lists members with the
extend.py file in place?
If there is nothing in the logs, you aren't looking at the right logs.
If this is the RedHat RPM packaged Mailman, logs are in
/var/log/mailman.
------------------------------------------------------
Mailman-Users mailing list [email protected]
http://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3
Security Policy: http://wiki.list.org/x/QIA9
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe:
http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
