[Mailman-Users] startup error in mailman

[Sean Roe]

Figured it out.  The user connecting to the mysql database did not have 
create rights, so it was failing to create the default table.

Thanks,
Sean

Sean Roe wrote:

>Hi All,
>
>I am getting the following error whenever I start up mailman:
>
>mailman01:/var/lib/mailman/Mailman# ../bin/mailmanctl start
>Traceback (most recent call last):
>  File "../bin/mailmanctl", line 547, in ?
>    main()
>  File "../bin/mailmanctl", line 366, in main
>    check_for_site_list()
>  File "../bin/mailmanctl", line 276, in check_for_site_list
>    sitelist = MailList(sitelistname, lock=0)
>  File "/var/lib/mailman/Mailman/MailList.py", line 104, in __init__
>    self._memberadaptor = MysqlMemberships(self)
>  File "/var/lib/mailman/Mailman/MysqlMemberships.py", line 118, in __init__
>    self.cursor.execute ("""CREATE TABLE IF NOT EXISTS %s (
>  File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 137, 
>in execute
>    self.errorhandler(self, exc, value)
>  File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 
>33, in defaulterrorhandler
>    raise errorclass, errorvalue
>_mysql_exceptions.OperationalError: (1044, "Access denied for user 
>'web_site'@'192.168.%' to database 'mailman'")
>Exception exceptions.AttributeError: "MysqlMemberships instance has no 
>attribute 'conn'" in <bound method MysqlMemberships.__del__ of 
><Mailman.MysqlMemberships.MysqlMemberships instance at 0x404645ec>> ignored
>
>Mailman no longer starts at this point.
>
>Nothing has changed that I am aware of, I have connected from the 
>mailman server to the database server with the mysql client using the 
>same username and password and was successful, so I am at a loss.  Any 
>suggestions would be helpful.
>
>Thanks,
>Sean
>
>------------------------------------------------------
>Mailman-Users mailing list
>Mailman-Users at python.org
>http://mail.python.org/mailman/listinfo/mailman-users
>Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py
>Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
>Unsubscribe: http://mail.python.org/mailman/options/mailman-users/sean%40adoptionmedia.com
>
>Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=show&amp;file=faq01.027.htp
>  
>