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

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:

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 help does not

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

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? I'm

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

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 not a

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

[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)

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 (virtual