[Mailman-Users] mailman + mysql

[Mark Sapiro]

On 8/31/2011 12:15 PM, Klemen Humerca wrote:
> 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....


Lines 90 through 97 of the MysqlMemberships.py I think you are using say

        if mm_cfg.MYSQL_MEMBER_DB_VERBOSE:
            # Message to indicate successful init.
            message = "MysqlMemberships " \
                + "$Revision: 1.69 $ initialized with host: %s (%s)" % (
                mm_cfg.connection.get_host_info(),
                mm_cfg.connection.get_server_info() )
            syslog('error', message)
            syslog('mysql', message)

Lines 92 through 95 are one long statement. There is something wrong
with the mm_cfg.connection object. This should be a MySQL database
connection established earlier by the call to self._dbconnect() at line
67. This in turn did

        try:
            mm_cfg.connection = MySQLdb.connect(
                passwd=mm_cfg.MYSQL_MEMBER_DB_PASS,
                db=mm_cfg.MYSQL_MEMBER_DB_NAME,
                user=mm_cfg.MYSQL_MEMBER_DB_USER,
                host=mm_cfg.MYSQL_MEMBER_DB_HOST)
            mm_cfg.cursor = mm_cfg.connection.cursor()

There is probably some issue with your definitions of
MYSQL_MEMBER_DB_PASS, MYSQL_MEMBER_DB_NAME, MYSQL_MEMBER_DB_USER and/or
MYSQL_MEMBER_DB_HOST in mm_cfg.py

-- 
Mark Sapiro <mark at msapiro.net>        The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan