[vchkpw] delivery loop prevention inconsistency

2005-03-31 Thread Kurt Bigler
qmail + vpopmail 5.3.12 + qmailadmin 1.0.6

With the following pop accounts already set up:
[EMAIL PROTECTED]
[EMAIL PROTECTED]

I used QmailAdmin to create the following aliases in the domain
breathsense.com:

kurt = kurt, test
test = test

Since QmailAdmin does not permit creating a pop account with the same name
as an existing alias, I'm not sure whether doing the reverse like this is
well-advised, even though QmailAdmin permits it.  Any opinions?  Perhaps a
newer version of vpopmail or QmailAdmin even prevents this.

In any case I've found this very useful for testing some filtering in the
test account, by providing it a stream of real mail from the kurt account
(via the kurt = test alias).  The test alias provides the .qmail-test
file in which I can hack in the mail filtering scheme that I am testing.

In the course of doing this I discovered a problem caused by qmail's
loop-prevention rule.  Quoting from the qmail-local man page:

 If exactly the same Delivered-To: [EMAIL PROTECTED] already appears in the 
 header,
 qmail-local bounces the message, to prevent mail forwarding loops.

The problem is that if I resend a message from [EMAIL PROTECTED] to the
same account (an occasionally useful thing to do) it bounces due to the
looping rule:

 Hi. This is the qmail-send program at vps.breathsense.com.
 I'm afraid I wasn't able to deliver your message to the following addresses.
 This is a permanent error; I've given up. Sorry it didn't work out.
 
 [EMAIL PROTECTED]:
 This message is looping: it already has my Delivered-To line. (#5.4.6)
 
 --- Below this line is a copy of the message.
 
 Return-Path: [EMAIL PROTECTED]
 Received: (qmail 23011 invoked from network); 31 Mar 2005 07:41:30 -
 Received: from unknown (HELO ?192.168.1.67?) (24.5.192.77)
   by vps.breathsense.com with SMTP; 31 Mar 2005 07:41:30 -
 Return-Path: [EMAIL PROTECTED]
 Delivered-To: [EMAIL PROTECTED]
 Received: (qmail 94328 invoked from network); 30 Mar 2005 23:30:44 -
 Received: from unknown (HELO cnmat.berkeley.edu) (128.32.122.12)
   by vps.breathsense.com with SMTP; 30 Mar 2005 23:30:44 -

On the other hand I can do the same thing all day using the
[EMAIL PROTECTED] account, as the double-stacked Delivered-To:
[EMAIL PROTECTED] here confirms:

 Return-Path: [EMAIL PROTECTED]
 Delivered-To: [EMAIL PROTECTED]
 Received: (qmail 23869 invoked from network); 31 Mar 2005 07:52:10 -
 Received: from unknown (HELO ?192.168.1.67?) (24.5.192.77)
   by vps.breathsense.com with SMTP; 31 Mar 2005 07:52:10 -
 Return-Path: [EMAIL PROTECTED]
 Delivered-To: [EMAIL PROTECTED]
 Received: (qmail 23818 invoked from network); 31 Mar 2005 07:51:25 -
 Received: from unknown (HELO ?192.168.1.67?) (24.5.192.77)
   by vps.breathsense.com with SMTP; 31 Mar 2005 07:51:25 -

This suggests that the looping rule in the man page is described
incompletely.  It seems obvious that the difference between the behavior for
kurt and for kkb has to do with the alias structure I created.  I assume it
depends in some specific way on how the message hits what kind of dot-qmail
files.

Does anyone understand this?

The reason I care so much is that I am creating a spam filter that is
end-user-trainable via pop access, and the training interface depends on
being able to resend-to-self.  Meanwhile enabling the filter for account
blah will probably depend on having a .qmail-blah file in order to run the
filter, and I want to know now if I am in big trouble here because blah
resend to blah will be rejected due to the looping rule.

Thanks for any help.

-Kurt Bigler



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



[vchkpw] Error: Illegal username on change password

2005-03-31 Thread Alessio Cecchi
I have a domain in a box linux (with other domains that work well) that 
i cannot change the password for all users.

On this server is installed
netqmail + vpopmail 5.4.5 (mysql and clear text passwd) + qmailadmin and 
vqadmin.

The /var/qmail/user/assign is ok (i think..)
What i can check?
--
Alessio Cecchi ++ www.skye.it


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] authentication problem for qmail-smtp-auth

2005-03-31 Thread Bogdan Motoc - CRC
- Original Message - 
From: Erwin Hoffmann [EMAIL PROTECTED]
To: vchkpw@inter7.com
Sent: Wednesday, March 30, 2005 10:09 PM
Subject: Re: [vchkpw] authentication problem for qmail-smtp-auth


Why do you use /home/vpopmail/bin/vchkpw $LOCAL /bin/true 21 ?
Is $LOCAL required by vchkpw ?
I have removed the $LOCAL string, killed the tcpserver process, verified 
that it was restarted without the $LOCAL argument, and nothing happened. 
(nothing good, anyway)
I still see the message: vpopmail[]: vchkpw-smtp: vpopmail user not 
found [EMAIL PROTECTED]:ip




Re: [vchkpw] authentication problem for qmail-smtp-auth

2005-03-31 Thread Bogdan Motoc - CRC
- Original Message - 
From: Tom Collins [EMAIL PROTECTED]
To: vchkpw@inter7.com
Sent: Wednesday, March 30, 2005 9:59 PM
Subject: Re: [vchkpw] authentication problem for qmail-smtp-auth


On Mar 30, 2005, at 10:33 AM, Bogdan Motoc - CRC wrote:
So, what am I doing wrong? What have I missed? What else can I do to 
throw some light on this matter?
I apreciate any help you can give me.
One possibility:
If you don't have clear passwords enabled, and the user tries to use 
CRAM-MD5 for SMTP AUTH, their authentication will fail.

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

Hmm... what auth method it is actually using is a good question. I'll try 
and log the smtp conversation (only recordio comes in mind at this point), 
and see exactly what's going on. Thank you for this ideea, and all the help.




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
  
  
  
  

[vchkpw] My First Experience with vHostAdmin

2005-03-31 Thread Devendra Singh
Hi,
I was able to try out vHostAdmin on a Development environment.
I was delighted to see it working quite well even in the infancy stage.
I would note my experience below, but first let me jot down how I did (some 
others may get benefited and some others may be able to comment if I have 
done anything incorrectly):

cd /home/devendra
wget http://www.inter7.com/vhostadmin/vpopmail-5.5.3.tar.gz
tar xzfv vpopmail-5.5.3.tar.gz
cd vpopmail-5.5.3
./configure \
  --enable-roaming-users=n \
  --enable-logging=p \
  --enable-passwd=n \
  --enable-clear-passwd=y \
  --enable-auth-module=mysql \
  --enable-many-domains=y \
  --enable-auth-logging=y \
  --enable-mysql-logging=y \
  --enable-valias=y \
  --enable-mysql-limits=n \
  [EMAIL PROTECTED] \
  --enable-ip-alias-domains=n \
  --enable-incdir=/usr/local/mysql/include \
  --enable-libdir=/usr/local/mysql/lib
make
Note: I did not do make install-strip as I wanted to get vpopmaild binary 
only.

cp -P vpopmaild /home/vpopmail/bin
chown vpopmail:vchkpw /home/vpopmail/bin/vpopmaild
mkdir /var/log/qmail/vpopmaild
chown -R qmaill /var/log/qmail/vpopmaild
mkdir -p /var/qmail/supervise/vpopmaild/log
chmod +t /var/qmail/supervise/vpopmaild
vi /var/qmail/supervise/vpopmaild/run
#!/bin/sh
# Port: 89
/usr/local/bin/tcpserver -vHRD 0 89 /home/vpopmail/bin/vpopmaild 21
vi /var/qmail/supervise/vpopmaild/log/run
#!/bin/sh
# Keep 30 logs of max 10Mb each
#
# They will get rotated when they reach 10Mb in size,
exec /usr/local/bin/setuidgid qmaill /usr/local/bin/multilog t s1000 
n30 /var/log/qmail/vpopmaild

chmod 755 /var/qmail/supervise/vpopmaild/run
chmod 755 /var/qmail/supervise/vpopmaild/log/run
ln -s /var/qmail/supervise/vpopmaild /service
cd /home/devendra
wget http://www.inter7.com/vhostadmin/vhostadmin-cvs-1112134662.tar.gz
Notes from: INSTALL DOC
Unpackage into webserver document root
Copy include/global.inc-dist to include/global.inc
Edit include/global.inc, modify paths and hosts
  session_directory must be a directory readable and writable
  by the webserver
vpopmaild must be running to log in
cd /myserver/public_html/
tar xzfv /home/devendra/vhostadmin-cvs-1112134662.tar.gz
mv vhostadmin-cvs-1112134662 vhostadmin
chown -R intermsh:intermsh vhostadmin
cd vhostadmin
rm -rf BUGS CVS doc TODO
cp include/global.inc-dist include/global.inc
chown intermsh:intermsh include/global.inc
chmod 755 include/global.inc
vi include/global.inc
-- did change the required settings.
Note: I had to recompile my PHP for --enable-sockets, my php configure as:
./configure --with-mysql=/usr/local/mysql 
--with-apxs=/usr/local/apache/bin/apxs --enable-sockets

My experience with vHostAdmin:
I had to set the SA_ADMIN privileges manually for one account as even the 
new vmoduser did not support the -S switch:
mysql use vpopmail;
Database changed
mysql update vpopmail set pw_gid=65536 where pw_name='postmaster' and 
pw_domain='qmail2.intermesh.net';

I had to modify str_replace lines in following three files as [Warning: 
Wrong parameter count for str_replace()]:
modules/mail/users.php
//$str = str_replace(v|, , trim($data), 1);
$str = str_replace(v|, , trim($data));
modules/mail/domains.php
   //$str = str_replace(v|, , trim($data), 1);
  $str = str_replace(v|, , trim($data));
modules/mail/forwards.php
//$str = str_replace(v|, , trim($data), 1);
$str = str_replace(v|, , trim($data));

Go to Domain / Go to User / Go to Forwards does not support partial search.
All the Mailing Lists show up in Forwards.
Modify User is not having options to modify the Limits and Quota
Thanks.
Devendra Singh
__
Devendra Singh
IndiaMART InterMESH Limited
(Global Gateway to Indian Market Place)
B-1, Sector 8, Noida, UP - 201301, India
EPABX : +91-120-2424945, +91-120-3094634, +91-9810646342
Fax: +91-120-2424943
http://www.indiamart.com
http://www.indiangiftsportal.com
http://www.indiantravelportal.com
__