[Mailman-Users] mailman + mysql

[Klemen Humerca]

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

( klemen at humerca.com | 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.
>