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

2005-04-06 Thread Joshua Coucke



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

2005-04-06 Thread Joshua Coucke



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

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

		
		
		  




 

  


  


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 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
connection info for postgres is stored in the vpgsql.h file?

I did get an error about vpopmail not being able to create the vlog
table in postgres, but I solved that by just importing it from mysql.

Josh

Nick Harring wrote:

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

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

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

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

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

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

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

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

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

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