[vchkpw] Switching from Mysql to Postgresql
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 error "vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:x.x.x.x" Now the user is in the database, I can see it using phppgadmin and the vuserinfo command. So why is vchkpw-pop3 not finding the user? Thanks, Joshua Coucke
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 means. 13:19:08.180829 IP firewall.softek.net.53711 host2.aanow.net.smtp: S 1848408622:1848408622(0) win 65535 mss 1364,nop,nop,sackOK13:19:08.180963 IP host2.aanow.net.smtp firewall.softek.net.53711: S 783705716:783705716(0) ack 1848408623 win 5840 mss 1460,nop,nop,sackOK13:19:08.182335 IP firewall.softek.net.53711 host2.aanow.net.smtp: . ack 1 win 6553513:19:08.190878 IP host2.aanow.net.smtp firewall.softek.net.53711: P 1:32(31) ack 1 win 584013:19:08.192235 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 1:19(18) ack 32 win 6550413:19:08.192381 IP host2.aanow.net.smtp firewall.softek.net.53711: . ack 19 win 584013:19:08.192524 IP host2.aanow.net.smtp firewall.softek.net.53711: P 32:163(131) ack 19 win 584013:19:08.194750 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 19:34(15) ack 163 win 6537313:19:08.195155 IP host2.aanow.net.smtp firewall.softek.net.53711: P 163:221(58) ack 34 win 584013:19:08.196402 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 34:112(78) ack 221 win 6531513:19:08.232661 IP host2.aanow.net.smtp firewall.softek.net.53711: P 221:312(91) ack 112 win 584013:19:08.234324 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 112:115(3) ack 312 win 6522413:19:08.234526 IP host2.aanow.net.smtp firewall.softek.net.53711: P 312:421(109) ack 115 win 584013:19:08.272123 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 115:121(6) ack 421 win 6511513:19:08.272268 IP host2.aanow.net.smtp firewall.softek.net.53711: P 421:505(84) ack 121 win 584013:19:08.272348 IP firewall.softek.net.53711 host2.aanow.net.smtp: R 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] 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 it's not trying. Also, how about TLS. Doesn't Thunderbird try TLS by default? How about turning that off? 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 send email from Outlook Express just fine when I use the lebanon-tn.com account with it. However, Thunderbird has a knee-jerk reaction of not being able to connect to the smtp server. It seems as 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 Mysql to Postgresql 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 error "vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:x.x.x.x" Now the user is in the database, I can see it using phppgadmin and the vuserinfo command. So why is vchkpw-pop3 not finding the user? Thanks, Joshua Coucke
Re: [vchkpw] Switching from Mysql to Postgresql
I did a tcpdump while sending the last message with Outlook and the file is much larger than the try with Thunderbird. Josh - Original Message - From: Joshua Coucke To: vchkpw@inter7.com Sent: Wednesday, April 06, 2005 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 means. 13:19:08.180829 IP firewall.softek.net.53711 host2.aanow.net.smtp: S 1848408622:1848408622(0) win 65535 mss 1364,nop,nop,sackOK13:19:08.180963 IP host2.aanow.net.smtp firewall.softek.net.53711: S 783705716:783705716(0) ack 1848408623 win 5840 mss 1460,nop,nop,sackOK13:19:08.182335 IP firewall.softek.net.53711 host2.aanow.net.smtp: . ack 1 win 6553513:19:08.190878 IP host2.aanow.net.smtp firewall.softek.net.53711: P 1:32(31) ack 1 win 584013:19:08.192235 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 1:19(18) ack 32 win 6550413:19:08.192381 IP host2.aanow.net.smtp firewall.softek.net.53711: . ack 19 win 584013:19:08.192524 IP host2.aanow.net.smtp firewall.softek.net.53711: P 32:163(131) ack 19 win 584013:19:08.194750 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 19:34(15) ack 163 win 6537313:19:08.195155 IP host2.aanow.net.smtp firewall.softek.net.53711: P 163:221(58) ack 34 win 584013:19:08.196402 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 34:112(78) ack 221 win 6531513:19:08.232661 IP host2.aanow.net.smtp firewall.softek.net.53711: P 221:312(91) ack 112 win 584013:19:08.234324 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 112:115(3) ack 312 win 6522413:19:08.234526 IP host2.aanow.net.smtp firewall.softek.net.53711: P 312:421(109) ack 115 win 584013:19:08.272123 IP firewall.softek.net.53711 host2.aanow.net.smtp: P 115:121(6) ack 421 win 6511513:19:08.272268 IP host2.aanow.net.smtp firewall.softek.net.53711: P 421:505(84) ack 121 win 584013:19:08.272348 IP firewall.softek.net.53711 host2.aanow.net.smtp: R 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] 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 it's not trying. Also, how about TLS. Doesn't Thunderbird try TLS by default? How about turning that off? 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 send email from Outlook Express just fine when I use the lebanon-tn.com account with it. However, Thunderbird has a knee-jerk reaction of not being able to connect to the smtp server. It seems as 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 Mysql to Postgresql 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 error "vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:x.x.x.x" Now the user is in the database, I can see it using phppgadmin and the vuserinfo command. So why is vchkpw-pop3 not finding the user? Thanks, Joshua Coucke
RE: [vchkpw] Switching from Mysql to Postgresql
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 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 things that happens on login that wouldn't with vuserinfo would be an insertion or update to the vlog table or lastauth table. If you want, contact me off list and we can discuss the possibility of me logging in to your system and checking things out. I may take you up on that offer if I can't figure this out.Joshua Coucke 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: Is there anything in the log files? /var/log/mail/info or /var/log/mail/errors ... how about in /var/log/qmail/pop3d/current? Nothing in the logs that I could see. If vuserinfo is working, then your database hooks in vpopmail are all ok. How about doing a make clean and make and make install again? Then restart qmail. I have been doing make clean every time I recompile. How about if you telnet to the server on port 110 and try to auth by hand? You sure it's not a Thunderbird issue? Tried it and it failed just after I entered the password for the account. I had some issues at one point and I ended up deleting everything in ~vpopmail/etc ~vpopmail/include ~vpopmail/bin and ~vpopmail/lib then rebuilt vpopmail and rebuilt authdaemon. Then it all worked. I tried deleting everything out of those directories and then rebuilding vpopmail and it 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 successfully with PostgreSQL. How about permissions for your vpopmail sql user? Did you GRANT that user permissions to the database? Yes, the user does have permissions. How about running the commandline utilities? /home/vpopmail/bin/vuserinfo email addy I was able to get userinfo on an email address. And I was able to verify that the info was coming from the postgres db. (I changed some info in the db and ran the command again, the output was updated.) name: jdcoucke passwd: $1$39sHL0$r3PDZJzvwbTAKOxJD4HHq. clear passwd: ** comment/gecos: Joshua Coucke uid:0 gid:4096 flags: 4096 gecos: Joshua Coucke limits: has qmailadmin administrator access dir: /home/vpopmail/domains/lebanon-tn.com/jdcoucke quota: 4194304S usage: 0% NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lastauth_pkey" for table "lastauth" last auth: Never logged in Thunderbird still returns an auth error. All of user info was imported from a mysql db using phpmyadmin 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 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 telling me that authorazation failed. As far as I can tell I have provided the correct username and database for vpopmail in the vpgsql.h file. And I have imported into postgres the database from mysql. The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. Any ideas on the subject would be helpful. I tried to google for this but nothing came up. Joshua Coucke
[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 to use PostgreSQL and then procede to check my email I get an error telling me that authorazation failed. As far as I can tell I have provided the correct username and database for vpopmail in the vpgsql.h file. And I have imported into postgres the database from mysql. The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. Any ideas on the subject would be helpful. I tried to google for this but nothing came up. Joshua Coucke
RE: [vchkpw] Switching from Mysql to Postgresql
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
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 stored in the vpgsql.h file? Have you checked for a /path/to/vpopmail/etc/vpopmail.pgsql file? MySQL used to be controlled out of vmysql.h but moved to vpopmail.mysql. Not sure if pgsql did the same. Hope that helps, Nick
Re: [vchkpw] Switching from Mysql to Postgresql
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 procede to check my email I get an error telling me that authorazation failed. You'll need to recompile courier-imap (in addition to qmailadmin and vqadmin as others posted). 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 from MySQL to PostgreSQL (probably moving them temporarily to vpasswd files?) I'm fairly certain that PostgreSQL is working properly in 5.4.10. We did a lot of work on it, and I thought there were people using it in production environments. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ You don't need a laptop to troubleshoot high-speed Internet: sniffter.com
Re: [vchkpw] Switching from Mysql to Postgresql
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 from MySQL to PostgreSQL (probably moving them temporarily to vpasswd files?) No I didnt use vconvert. I had just done a db dump on mysql and imported it to postgres, but I will use vconvert the next time I attempt it. I'm fairly certain that PostgreSQL is working properly in 5.4.10. We did a lot of work on it, and I thought there were people using it in production environments. I am sure there are, I just have not figured it out yet. Also, Nick, from what I could tell vpopmail does not use a vpopmail.pgsql file. Although, I do have one there just in case. Joshua
Re: [vchkpw] Switching from Mysql to Postgresql
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 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 made. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ You don't need a laptop to troubleshoot high-speed Internet: sniffter.com
Re: [vchkpw] Switching from Mysql to Postgresql
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 made. I have been wondering why vpopmail does not use some sort of db abstraction layer so that recompiling for different db's is not necessary. Something like ADODB for php Josh
RE: [vchkpw] Switching from Mysql to Postgresql
I'm using vpopmail 5.4.10 successfully with PostgreSQL. How about permissions for your vpopmail sql user? Did you GRANT that user permissions to the database? How about trying to use the postgres user? Kind of like using root so I wouldn't leave it that way but at least it may indicate if it's a permissions issue? How about running the commandline utilities? /home/vpopmail/bin/vuserinfo email addy Does that yield a failed connection as well? Charlie -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 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 telling me that authorazation failed. As far as I can tell I have provided the correct username and database for vpopmail in the vpgsql.h file. And I have imported into postgres the database from mysql. The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. Any ideas on the subject would be helpful. I tried to google for this but nothing came up. Joshua Coucke
RE: [vchkpw] Switching from Mysql to Postgresql
Just for reference, here's how I configured my vpopmail ./configure --enable-qmail-ext --enable-auth-module=pgsql --enable-logging=p --enable-sql-logging --no-create --no-recursion -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 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 telling me that authorazation failed. As far as I can tell I have provided the correct username and database for vpopmail in the vpgsql.h file. And I have imported into postgres the database from mysql. The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. Any ideas on the subject would be helpful. I tried to google for this but nothing came up. Joshua Coucke
RE: [vchkpw] Switching from Mysql to Postgresql
Nah. You did it the right way. That's how I would have done it. I just moved everything to a new server and did it by exporting and importing the SQL data. I recall doing a mysql to PostgreSQL conversion once and just did an export and import. Is there anything in the log files? /var/log/mail/info or /var/log/mail/errors ... how about in /var/log/qmail/pop3d/current? If vuserinfo is working, then your database hooks in vpopmail are all ok. How about doing a make clean and make and make install again? Then restart qmail. If you're using daemontools svc -du /service/qmail-pop3d How about if you telnet to the server on port 110 and try to auth by hand? You sure it's not a Thunderbird issue? If you're doing IMAP, then try recompiling the authdaemon. I believe it's a separate package now from Courier. I had some issues at one point and I ended up deleting everything in ~vpopmail/etc ~vpopmail/include ~vpopmail/bin and ~vpopmail/lib then rebuilt vpopmail and rebuilt authdaemon. Then it all worked. Charlie 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 with PostgreSQL. How about permissions for your vpopmail sql user? Did you GRANT that user permissions to the database? Yes, the user does have permissions. How about running the commandline utilities? /home/vpopmail/bin/vuserinfo email addy I was able to get userinfo on an email address. And I was able to verify that the info was coming from the postgres db. (I changed some info in the db and ran the command again, the output was updated.) name: jdcoucke passwd: $1$39sHL0$r3PDZJzvwbTAKOxJD4HHq. clear passwd: ** comment/gecos: Joshua Coucke uid:0 gid:4096 flags: 4096 gecos: Joshua Coucke limits: has qmailadmin administrator access dir: /home/vpopmail/domains/lebanon-tn.com/jdcoucke quota: 4194304S usage: 0% NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index lastauth_pkey for table lastauth last auth: Never logged in Thunderbird still returns an auth error. All of user info was imported from a mysql db using phpmyadmin 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 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 telling me that authorazation failed. As far as I can tell I have provided the correct username and database for vpopmail in the vpgsql.h file. And I have imported into postgres the database from mysql. The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. Any ideas on the subject would be helpful. I tried to google for this but nothing came up. Joshua Coucke
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 in /var/log/qmail/pop3d/current? Nothing in the logs that I could see. If vuserinfo is working, then your database hooks in vpopmail are all ok. How about doing a make clean and make and make install again? Then restart qmail. I have been doing make clean every time I recompile. How about if you telnet to the server on port 110 and try to auth by hand? You sure it's not a Thunderbird issue? Tried it and it failed just after I entered the password for the account. I had some issues at one point and I ended up deleting everything in ~vpopmail/etc ~vpopmail/include ~vpopmail/bin and ~vpopmail/lib then rebuilt vpopmail and rebuilt authdaemon. Then it all worked. I tried deleting everything out of those directories and then rebuilding vpopmail and it 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 successfully with PostgreSQL. How about permissions for your vpopmail sql user? Did you GRANT that user permissions to the database? Yes, the user does have permissions. How about running the commandline utilities? /home/vpopmail/bin/vuserinfo email addy I was able to get userinfo on an email address. And I was able to verify that the info was coming from the postgres db. (I changed some info in the db and ran the command again, the output was updated.) name: jdcoucke passwd: $1$39sHL0$r3PDZJzvwbTAKOxJD4HHq. clear passwd: ** comment/gecos: Joshua Coucke uid:0 gid:4096 flags: 4096 gecos: Joshua Coucke limits: has qmailadmin administrator access dir: /home/vpopmail/domains/lebanon-tn.com/jdcoucke quota: 4194304S usage: 0% NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index lastauth_pkey for table lastauth last auth: Never logged in Thunderbird still returns an auth error. All of user info was imported from a mysql db using phpmyadmin 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 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 telling me that authorazation failed. As far as I can tell I have provided the correct username and database for vpopmail in the vpgsql.h file. And I have imported into postgres the database from mysql. The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. Any ideas on the subject would be helpful. I tried to google for this but nothing came up. Joshua Coucke
RE: [vchkpw] Switching from Mysql to Postgresql
Did you try using the postgres user for the database instead of the one you made? One of the things that happens on login that wouldn't with vuserinfo would be an insertion or update to the vlog table or lastauth table. If you want, contact me off list and we can discuss the possibility 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 Charles J. Boening wrote: Is there anything in the log files? /var/log/mail/info or /var/log/mail/errors ... how about in /var/log/qmail/pop3d/current? Nothing in the logs that I could see. If vuserinfo is working, then your database hooks in vpopmail are all ok. How about doing a make clean and make and make install again? Then restart qmail. I have been doing make clean every time I recompile. How about if you telnet to the server on port 110 and try to auth by hand? You sure it's not a Thunderbird issue? Tried it and it failed just after I entered the password for the account. I had some issues at one point and I ended up deleting everything in ~vpopmail/etc ~vpopmail/include ~vpopmail/bin and ~vpopmail/lib then rebuilt vpopmail and rebuilt authdaemon. Then it all worked. I tried deleting everything out of those directories and then rebuilding vpopmail and it 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 successfully with PostgreSQL. How about permissions for your vpopmail sql user? Did you GRANT that user permissions to the database? Yes, the user does have permissions. How about running the commandline utilities? /home/vpopmail/bin/vuserinfo email addy I was able to get userinfo on an email address. And I was able to verify that the info was coming from the postgres db. (I changed some info in the db and ran the command again, the output was updated.) name: jdcoucke passwd: $1$39sHL0$r3PDZJzvwbTAKOxJD4HHq. clear passwd: ** comment/gecos: Joshua Coucke uid:0 gid:4096 flags: 4096 gecos: Joshua Coucke limits: has qmailadmin administrator access dir: /home/vpopmail/domains/lebanon-tn.com/jdcoucke quota: 4194304S usage: 0% NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index lastauth_pkey for table lastauth last auth: Never logged in Thunderbird still returns an auth error. All of user info was imported from a mysql db using phpmyadmin 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 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 telling me that authorazation failed. As far as I can tell I have provided the correct username and database for vpopmail in the vpgsql.h file. And I have imported into postgres the database from mysql. The other odd thing is that vqadmin and qmailadmin still seem to be using the mysql database after recompiling vpopmail for use with postgres. I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. Any ideas on the subject would be helpful. I tried to google for this but nothing came up. Joshua Coucke