[vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
Hey, this is Joshua Coucke (on my work account) I have been able to get the email server working on postgres like I said. However, I can not send messages. I get an error message telling me that Thunderbird can not connect to the SMTP server. When I check in the vlog table it has this

Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
:08.273044 IP firewall.softek.net.53711 host2.aanow.net.smtp: R 1848408743:1848408743(0) win 0 Josh - Original Message - From: Charles J. Boening To: vchkpw@inter7.com Sent: Wednesday, April 06, 2005 12:55 PM Subject: RE: [vchkpw] Switching from Mysql to Postgresql

Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
Sent: Wednesday, April 06, 2005 12:55 PM Subject: RE: [vchkpw] Switching from Mysql to Postgresql backend shouldn't matter. How about doing a packet capture (tcpdump) and seeing if Thunderbird is actually trying? Sometimes things can happen so fast it may seem like

RE: [vchkpw] Switching from Mysql to Postgresql

2005-04-04 Thread Charles J. Boening
Also, don't forget to check permissions on sequences. Had that bite me once. :) Charlie From: Joshua Coucke [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 6:35 AMTo: vchkpw@inter7.comSubject: Re: [vchkpw] Switching from Mysql to Postgresql Charles J. Boening

[vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Joshua Coucke
Hey, I used the QMR install with the MySQL option to install vpopmail. Now, however, I need to switch from MySQL to PostgreSQL as the backend for the whole thing. The problem I am having is that when I recompile vpopmail to use PostgreSQL and then procede to check my email I get an error

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Nick Harring
The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. You need to recompile them both, as they are statically linked to the vpopmail libraries from your previous version. Hope that helps, Nick Harring

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Nick Harring
Now I just have to figure out why vpopmail is not working with postgres like it should.  I found the install guild at http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-postgresql.htm.  However, this did not seem to help.  Am I correct in assuming that the connection info for postgres is

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Tom Collins
On Mar 31, 2005, at 7:08 AM, Joshua Coucke wrote: I used the QMR install with the MySQL option to install vpopmail. Now, however, I need to switch from MySQL to PostgreSQL as the backend for the whole thing. The problem I am having is that when I recompile vpopmail to use PostgreSQL and then

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Joshua Coucke
Tom Collins wrote: You'll need to recompile courier-imap (in addition to qmailadmin and vqadmin as others posted). Ok, thanks I will remember that. You can use the vuserinfo program to confirm that vpopmail is reading from PostgreSQL correctly. I assume that you used vconvert to move the users

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Tom Collins
On Mar 31, 2005, at 8:00 AM, Joshua Coucke wrote: Also, Nick, from what I could tell vpopmail does not use a vpopmail.pgsql file. Although, I do have one there just in case. I think there's a patch on SourceForge to accomplish that, but it was never added to the release version of vpopmail. No

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Joshua Coucke
Tom Collins wrote: I think there's a patch on SourceForge to accomplish that, but it was never added to the release version of vpopmail. No real reason that I recall -- just never got around to it. It might have to be hand-patched at this point, due to changes in vpgsql.c since the patch

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
@inter7.com Subject: [vchkpw] Switching from Mysql to Postgresql Hey, I used the QMR install with the MySQL option to install vpopmail. Now, however, I need to switch from MySQL to PostgreSQL as the backend for the whole thing. The problem I am having is that when I recompile vpopmail

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
:08 AM To: vchkpw@inter7.com Subject: [vchkpw] Switching from Mysql to Postgresql Hey, I used the QMR install with the MySQL option to install vpopmail. Now, however, I need to switch from MySQL to PostgreSQL as the backend for the whole thing. The problem I am having is that when I

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
@inter7.com Subject: Re: [vchkpw] Switching from Mysql to Postgresql Charles J. Boening wrote: I'm using vpopmail 5.4.10 successfully with PostgreSQL. How about permissions for your vpopmail sql user? Did you GRANT

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Joshua Coucke
failed Joshua From: Joshua Coucke [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 11:53 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] Switching from Mysql to Postgresql Charles J. Boening wrote: I'm using vpopmail 5.4.10 successfully

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
logging in to your system and checking things out. Charlie -Original Message- From: Joshua Coucke [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 1:26 PM To: vchkpw@inter7.com Subject: Re: [vchkpw] Switching from Mysql to Postgresql Charles J. Boening wrote