Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-12 Thread Aaron Kreider
I found a solution! Mark Sapiro deserves all the credit for helping me out a TON =) Here is my documentation in the hope that it will help someone in the future. --- Mark writes: The basic problem is that the python library or at least the one containing the site-p

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Aaron Kreider
So it appears that the wrappers are using the correct Python, so maybe it is permissions. The qrunners are (or should be) running as the mailman user:group, and the web CGI's should run as the mailman group, but run as the web server user, so that's a difference. Look at the permissions on the /

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Mark Sapiro
Aaron Kreider wrote: >> >Hmm, there is no such directory. There is a >MySQL_python-1.2.3-py2.4-linux-x86_64.egg file in >/usr/lib/python2.4/site-packages, but no directory. I think that's the problem. Did you install MySQLdb from source or via some RPM or ? The fact that you have an egg and n

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Aaron Kreider
So it appears that the wrappers are using the correct Python, so maybe it is permissions. The qrunners are (or should be) running as the mailman user:group, and the web CGI's should run as the mailman group, but run as the web server user, so that's a difference. Look at the permissions on the /

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Dale Newfield
On 8/6/10 4:14 PM, Aaron Kreider wrote: "Incorrect table name 'dbtest8_energyjustice.net'" I could easily see that .'s could be invalid in table names. -Dale ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mai

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Mark Sapiro
Aaron Kreider wrote: >> >> What's in Mailman's error log. Do you see the same ImportError causing >> the message to be shunted? > >No. I see it has an error about the table not being created. So that >must mean it is correctly importing the module? Why does it work here >and not in other cases?

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Aaron Kreider
Mark, Is Mailman running? What happens if you send a 'help' command by email to the new list's -request address? Sending "help" does not work for the new list. It does work for old lists (non-mysql based ones). What's in Mailman's error log. Do you see the same ImportError causing the mess

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Mark Sapiro
Aaron Kreider wrote: > On 8/6/2010 1:34 AM, Mark Sapiro wrote: >> Aaron Kreider wrote: >> >Using cPanel's mailman. I modified the paths to fit the instructions. OK >> Is Mailman running? What happens if you send a 'help' command by email >> to the new list's -request address? >> >Sending "he

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-06 Thread Aaron Kreider
On 8/6/2010 1:34 AM, Mark Sapiro wrote: Aaron Kreider wrote: I'm trying to get the Mailman MySQL adaptor to work, while we're waiting for Mailman 3 to be finished. I'd love some help! I followed the instructions on: http://loeki.tv/log/archives/81-Setting-up-Mailman-to-store-members-in-a-M

Re: [Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-05 Thread Mark Sapiro
Aaron Kreider wrote: > I'm trying to get the Mailman MySQL adaptor to work, while we're >waiting for Mailman 3 to be finished. I'd love some help! > >I followed the instructions on: >http://loeki.tv/log/archives/81-Setting-up-Mailman-to-store-members-in-a-MySQL-database.html > >I have a VPS (vi

[Mailman-Developers] Mailman MySQL adaptor - MySQLdb module error

2010-08-05 Thread Aaron Kreider
I'm trying to get the Mailman MySQL adaptor to work, while we're waiting for Mailman 3 to be finished. I'd love some help! I followed the instructions on: http://loeki.tv/log/archives/81-Setting-up-Mailman-to-store-members-in-a-MySQL-database.html I have a VPS (virtual private server) running