Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
Ok, will do.   Josh - Original Message - From: Charles J. Boening To: vchkpw@inter7.com Sent: Wednesday, April 06, 2005 1:59 PM Subject: RE: [vchkpw] Switching from Mysql to Postgresql Thunderbird looks like it was trying to talk but didn't

RE: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Charles J. Boening
05 1:23 PM Subject: Re: [vchkpw] Switching from Mysql to Postgresql I just tried a tcpdump. I did tcpdump > tcp and then a grep 'smtp' > smtp.   Here are the contents of the smtp file.  Not exactly sure what all of that mean

Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
Boening To: vchkpw@inter7.com 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?  S

Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
121:121(0) ack 421 win 013:19: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]

Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
I don't think Thunderbird does TLS by default.  At least I have it turned off on mine.   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 Postg

RE: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Charles J. Boening
ff?     Charlie       From: Joshua Coucke [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 9:06 AMTo: vchkpw@inter7.comSubject: Re: [vchkpw] Switching from Mysql to Postgresql Well, oddly enough the problem with sending email seems to be Thunderbird itself.  I can

Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-06 Thread Joshua Coucke
though it fails before it even tries.  Funny thing is that it does not do this when Mysql is the backend instead of postgres.   Joshua - Original Message - From: Joshua Coucke To: vchkpw@inter7.com Sent: Wednesday, April 06, 2005 10:04 AM Subject: [vchkpw] Switching from

[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-05 Thread Joshua Coucke
To: vchkpw@inter7.com Subject: Re: [vchkpw] Switching from Mysql to Postgresql Charles J. Boening wrote: Did you try using the postgres user for the database instead of the one you made? I believe I did, but I will try it again, just to make sure. One of the t

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 Char

Re: [vchkpw] Switching from Mysql to Postgresql

2005-04-04 Thread Joshua Coucke
hua 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: Is there anything in the log files? /var/log/mail/info or /var/log/mail/errors ... how about i

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
of me 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 > >

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Joshua Coucke
still 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 su

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
: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 with PostgreSQL. How about permissions for your vpo

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Joshua Coucke
yadmin and imported using phppgadmin.  Would it make a difference if I used vconvert instead? Joshua. -Original Message- From: Joshua Coucke [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 31, 2005 7:08 AM To: vchkpw@inter7.com Subject: [vchkpw] Switching from Mysql to Postgresql Hey, I

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Tom Collins
On Mar 31, 2005, at 8:22 AM, Joshua Coucke 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

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
sday, March 31, 2005 7: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

RE: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Charles J. Boening
, March 31, 2005 7: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 t

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 was

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: 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 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 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

Re: [vchkpw] Switching from Mysql to Postgresql

2005-03-31 Thread Joshua Coucke
Ahh aha!  That makes sense... 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 connec

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 Harrin

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