Re: [vchkpw] could not connect to mysql update server Access denied for user
check your permission and also check database and data base user or valid in vmysql.h -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) All I want is a few minutes alone with the source code for the universe and a quick recompile. - Original Message - From: System [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:15 PM Subject: [vchkpw] could not connect to mysql update server Access denied for user Hello All, I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail with SquirrelMail 1.0.4. I compiled vpopmail and used the following settings for mysql. /usr/sbin/groupadd -g 89 vchkpw /usr/sbin/useradd -g vchkpw -u 89 vpopmail GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; pico vmysql.h /* Edit to match your set up #define MYSQL_UPDATE_SERVER localhost #define MYSQL_UPDATE_USER vpopuser #define MYSQL_UPDATE_PASSWD vpoppass */ #define MYSQL_READ_SERVER localhost #define MYSQL_READ_USER vpopuser #define MYSQL_READ_PASSWD vpoppass /* End of setup section*/ /* defaults - no need to change */ #define MYSQL_VPORT 3306 #define MYSQL_DEFAULT_TABLE vpopmail #define MYSQL_DATABASE vpopmail #define MYSQL_DOT_CHAR '_' #define MYSQL_LARGE_USERS_TABLE users here are my Configure options ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l imits=n make make install-strip The above process works just fine. and even i have checked my mysql user and pass this is also fine. But after compiling my database vpopmail remains empty (without any table) Why ? when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass it gives an error : could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Why does it takes root if i am using vpopuser for the mysql connection. Please put on the correct path as i have googled a lot and also search but could not found any info that will help me in this context. Regards, Tina.
Re: [vchkpw] could not connect to mysql update server Access denied for user
check your permission and also check database and data base user or valid in vmysql.h GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; This is just fine and even connects to mysql from the prompt. I tried granting all privileges to [EMAIL PROTECTED] but still it gives me the same error!!! Regards, Tina. -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) All I want is a few minutes alone with the source code for the universe and a quick recompile. - Original Message - From: System [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:15 PM Subject: [vchkpw] could not connect to mysql update server Access denied for user Hello All, I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail with SquirrelMail 1.0.4. I compiled vpopmail and used the following settings for mysql. /usr/sbin/groupadd -g 89 vchkpw /usr/sbin/useradd -g vchkpw -u 89 vpopmail GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; pico vmysql.h /* Edit to match your set up #define MYSQL_UPDATE_SERVER localhost #define MYSQL_UPDATE_USER vpopuser #define MYSQL_UPDATE_PASSWD vpoppass */ #define MYSQL_READ_SERVER localhost #define MYSQL_READ_USER vpopuser #define MYSQL_READ_PASSWD vpoppass /* End of setup section*/ /* defaults - no need to change */ #define MYSQL_VPORT 3306 #define MYSQL_DEFAULT_TABLE vpopmail #define MYSQL_DATABASE vpopmail #define MYSQL_DOT_CHAR '_' #define MYSQL_LARGE_USERS_TABLE users here are my Configure options ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l imits=n make make install-strip The above process works just fine. and even i have checked my mysql user and pass this is also fine. But after compiling my database vpopmail remains empty (without any table) Why ? when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass it gives an error : could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Why does it takes root if i am using vpopuser for the mysql connection. Please put on the correct path as i have googled a lot and also search but could not found any info that will help me in this context. Regards, Tina.
Re: [vchkpw] could not connect to mysql update server Access denied for user
have u compiled vpopmail with vpopuser and vpoppass in vmysql.h. If no then please recompile your vpopmail with this username and password. If you have compiled vpopmail with this user name already then problem can be in database privileges. check again using console... -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) All I want is a few minutes alone with the source code for the universe and a quick recompile. - Original Message - From: System [EMAIL PROTECTED] To: Ahmad Masood Shah [EMAIL PROTECTED] Cc: vpopmail [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:26 PM Subject: Re: [vchkpw] could not connect to mysql update server Access denied for user check your permission and also check database and data base user or valid in vmysql.h GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; This is just fine and even connects to mysql from the prompt. I tried granting all privileges to [EMAIL PROTECTED] but still it gives me the same error!!! Regards, Tina. -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) All I want is a few minutes alone with the source code for the universe and a quick recompile. - Original Message - From: System [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:15 PM Subject: [vchkpw] could not connect to mysql update server Access denied for user Hello All, I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail with SquirrelMail 1.0.4. I compiled vpopmail and used the following settings for mysql. /usr/sbin/groupadd -g 89 vchkpw /usr/sbin/useradd -g vchkpw -u 89 vpopmail GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; pico vmysql.h /* Edit to match your set up #define MYSQL_UPDATE_SERVER localhost #define MYSQL_UPDATE_USER vpopuser #define MYSQL_UPDATE_PASSWD vpoppass */ #define MYSQL_READ_SERVER localhost #define MYSQL_READ_USER vpopuser #define MYSQL_READ_PASSWD vpoppass /* End of setup section*/ /* defaults - no need to change */ #define MYSQL_VPORT 3306 #define MYSQL_DEFAULT_TABLE vpopmail #define MYSQL_DATABASE vpopmail #define MYSQL_DOT_CHAR '_' #define MYSQL_LARGE_USERS_TABLE users here are my Configure options ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l imits=n make make install-strip The above process works just fine. and even i have checked my mysql user and pass this is also fine. But after compiling my database vpopmail remains empty (without any table) Why ? when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass it gives an error : could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Why does it takes root if i am using vpopuser for the mysql connection. Please put on the correct path as i have googled a lot and also search but could not found any info that will help me in this context. Regards, Tina.
Re: [vchkpw] could not connect to mysql update server Access denied for user
I would suggest you go back to your vpopmail source dir and run the following : make clean then run your configure again and then make install-strip Perhaps you did the original setup in the wrong sequence. You must make sure you modify the vmysql.h file 1st before you do all the other steps Michael. - Original Message - From: System [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 5:15 PM Subject: [vchkpw] could not connect to mysql update server Access denied for user Hello All, I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail with SquirrelMail 1.0.4. I compiled vpopmail and used the following settings for mysql. /usr/sbin/groupadd -g 89 vchkpw /usr/sbin/useradd -g vchkpw -u 89 vpopmail GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; pico vmysql.h /* Edit to match your set up #define MYSQL_UPDATE_SERVER localhost #define MYSQL_UPDATE_USER vpopuser #define MYSQL_UPDATE_PASSWD vpoppass */ #define MYSQL_READ_SERVER localhost #define MYSQL_READ_USER vpopuser #define MYSQL_READ_PASSWD vpoppass /* End of setup section*/ /* defaults - no need to change */ #define MYSQL_VPORT 3306 #define MYSQL_DEFAULT_TABLE vpopmail #define MYSQL_DATABASE vpopmail #define MYSQL_DOT_CHAR '_' #define MYSQL_LARGE_USERS_TABLE users here are my Configure options ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l imits=n make make install-strip The above process works just fine. and even i have checked my mysql user and pass this is also fine. But after compiling my database vpopmail remains empty (without any table) Why ? when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass it gives an error : could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Why does it takes root if i am using vpopuser for the mysql connection. Please put on the correct path as i have googled a lot and also search but could not found any info that will help me in this context. Regards, Tina.
Re: [vchkpw] could not connect to mysql update server Access deniedfor user
Hello I success to access MySQL. Please check the following contents. 1.MySQL configure option --with-mysqld-user= 2.MySQL start up /usr/local/mysql/bin/mysqld_safe --user= 3.Prepare database /usr/local/mysql/bin/mysqladmin create vpopmail /usr/local/mysql/bin/mysql mysql grant select,insert,update,delete,create,drop ON vpopmail.* \ TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; mysql exit 4.Show Database /usr/local/mysql/bin/mysqlshow +---+ | Databases | +---+ | mysql | | test | | vpopmail | +---+ 5.Vpopmail configure option --enable-incdir=/usr/include/mysql(This path OK?) I success the folloing five option. --enable-roaming-users=y --enable-mysql=y --enable-incdir=/usr/local/mysql/include/mysql --enable-libdir=/usr/local/mysql/lib/mysql --enable-sqlincdir=/usr/local/mysql/include/mysql --enable-sqllibdir=/usr/local/mysql/lib/mysql Regards, Yasuyuki Toyoda System wrote: Hello All, I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail with SquirrelMail 1.0.4. I compiled vpopmail and used the following settings for mysql. /usr/sbin/groupadd -g 89 vchkpw /usr/sbin/useradd -g vchkpw -u 89 vpopmail GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; pico vmysql.h /* Edit to match your set up #define MYSQL_UPDATE_SERVER localhost #define MYSQL_UPDATE_USER vpopuser #define MYSQL_UPDATE_PASSWD vpoppass */ #define MYSQL_READ_SERVER localhost #define MYSQL_READ_USER vpopuser #define MYSQL_READ_PASSWD vpoppass /* End of setup section*/ /* defaults - no need to change */ #define MYSQL_VPORT 3306 #define MYSQL_DEFAULT_TABLE vpopmail #define MYSQL_DATABASE vpopmail #define MYSQL_DOT_CHAR '_' #define MYSQL_LARGE_USERS_TABLE users here are my Configure options ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l imits=n make make install-strip The above process works just fine. and even i have checked my mysql user and pass this is also fine. But after compiling my database vpopmail remains empty (without any table) Why ? when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass it gives an error : could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Why does it takes root if i am using vpopuser for the mysql connection. Please put on the correct path as i have googled a lot and also search but could not found any info that will help me in this context. Regards, Tina. .
Re: [vchkpw] could not connect to mysql update server Access deniedfor user
Hello, I forget to add checking the following contests. 6.Initialize database in MySQL(please check username) /usr/local/mysql/bin/mysql_install_db --user=(username) chown -R (username) /usr/local/var chgrp -R (username) /usr/local/var Regards, Yasuyuki Toyoda System wrote: Hello All, I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail with SquirrelMail 1.0.4. I compiled vpopmail and used the following settings for mysql. /usr/sbin/groupadd -g 89 vchkpw /usr/sbin/useradd -g vchkpw -u 89 vpopmail GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; pico vmysql.h /* Edit to match your set up #define MYSQL_UPDATE_SERVER localhost #define MYSQL_UPDATE_USER vpopuser #define MYSQL_UPDATE_PASSWD vpoppass */ #define MYSQL_READ_SERVER localhost #define MYSQL_READ_USER vpopuser #define MYSQL_READ_PASSWD vpoppass /* End of setup section*/ /* defaults - no need to change */ #define MYSQL_VPORT 3306 #define MYSQL_DEFAULT_TABLE vpopmail #define MYSQL_DATABASE vpopmail #define MYSQL_DOT_CHAR '_' #define MYSQL_LARGE_USERS_TABLE users here are my Configure options ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l imits=n make make install-strip The above process works just fine. and even i have checked my mysql user and pass this is also fine. But after compiling my database vpopmail remains empty (without any table) Why ? when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass it gives an error : could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Why does it takes root if i am using vpopuser for the mysql connection. Please put on the correct path as i have googled a lot and also search but could not found any info that will help me in this context. Regards, Tina. .
Re: [vchkpw] could not connect to mysql update server Access denied for user
I would suggest you go back to your vpopmail source dir and run the following : make clean then run your configure again and then make install-strip Perhaps you did the original setup in the wrong sequence. You must make sure you modify the vmysql.h file 1st before you do all the other steps Thnaks Michael for Replying The Database settings are again done and updated in vmysql.h then i did make clean then ./configure with all options then here is what is says when i type make In file included from vauth.c:30: vmysql.h:51:22: warning: multi-line string literals are deprecated vauth.c: In function `vauth_open_update': vauth.c:108: `MYSQL_UPDATE_SERVER' undeclared (first use in this function) vauth.c:108: (Each undeclared identifier is reported only once vauth.c:108: for each function it appears in.) vauth.c:109: `MYSQL_UPDATE_USER' undeclared (first use in this function) vauth.c:109: `MYSQL_UPDATE_PASSWD' undeclared (first use in this function) vauth.c: In function `vauth_open_read_getall': vauth.c:201: `MYSQL_UPDATE_SERVER' undeclared (first use in this function) vauth.c:202: `MYSQL_UPDATE_USER' undeclared (first use in this function) vauth.c:202: `MYSQL_UPDATE_PASSWD' undeclared (first use in this function) make[2]: *** [vauth.o] Error 1 make[2]: Leaving directory `/usr/local/vpopmail' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/vpopmail' make: *** [all-recursive-am] Error 2 What have i made Wrong here now ? Regards, Tina
[vchkpw] Aliases not working with maildrop spamassassin?
Hi, I have a real [EMAIL PROTECTED] which is tagged for spam checking. The .qmail-default contains | /usr/local/bin/maildrop mailfilter file which calls maildrop and in mailfilter, runs through spamd to check for spam then pass it back to vdelivermail to deliver to the proper mailbox. Then I created a [EMAIL PROTECTED], which is an alias to [EMAIL PROTECTED] A .qmail-test is created which points to mydomain.com/user/Maildir. When an email is sent to [EMAIL PROTECTED], qmail just dumps it directly into user's mailbox,completely out of the spam checking task. Shouldn't the .qmail-test file's content be the same as the .qmail-default file? How do you enable alias to behave the same as the account that it's aliased to? Of course I can use a forwarder to [EMAIL PROTECTED] instead, but I don't think this is the best wayor? Thanks in advance for your suggestions! Jasper ___
Re: [vchkpw] could not connect to mysql update server Access denied for user
I would suggest you go back to your vpopmail source dir and run the following : make clean then run your configure again and then make install-strip Perhaps you did the original setup in the wrong sequence. You must make sure you modify the vmysql.h file 1st before you do all the other steps Thnaks Michael for Replying The Database settings are again done and updated in vmysql.h then i did make clean then ./configure with all options then here is what is says when i type make In file included from vauth.c:30: vmysql.h:51:22: warning: multi-line string literals are deprecated vauth.c: In function `vauth_open_update': vauth.c:108: `MYSQL_UPDATE_SERVER' undeclared (first use in this function) vauth.c:108: (Each undeclared identifier is reported only once vauth.c:108: for each function it appears in.) vauth.c:109: `MYSQL_UPDATE_USER' undeclared (first use in this function) vauth.c:109: `MYSQL_UPDATE_PASSWD' undeclared (first use in this function) vauth.c: In function `vauth_open_read_getall': vauth.c:201: `MYSQL_UPDATE_SERVER' undeclared (first use in this function) vauth.c:202: `MYSQL_UPDATE_USER' undeclared (first use in this function) vauth.c:202: `MYSQL_UPDATE_PASSWD' undeclared (first use in this function) make[2]: *** [vauth.o] Error 1 make[2]: Leaving directory `/usr/local/vpopmail' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/vpopmail' make: *** [all-recursive-am] Error 2 What have i made Wrong here now ? Sorry I know i have done a very stupid mistake for the above error and now the access denied error is no more but one last thing is mysql database vpopmail is still empty and hence it's not adding any users now. [EMAIL PROTECTED] bin]# ./vadduser [EMAIL PROTECTED] webmaster vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist vmysql: sql error[2]: Table 'vpopmail.mydomain_com' doesn't exist Error: Unable to chdir to vpopmail/users directory where can i get the table from ? Regards, Tina.
Re: [vchkpw] could not connect to mysql update server Access denied for user
Sounds to me like you are missing a quotation mark in vmysql.h from one of the #define lines that you modified to set the sql username/password Michael. - Original Message - From: System [EMAIL PROTECTED] To: vpopmail [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 7:29 PM Subject: Re: [vchkpw] could not connect to mysql update server Access denied for user I would suggest you go back to your vpopmail source dir and run the following : make clean then run your configure again and then make install-strip Perhaps you did the original setup in the wrong sequence. You must make sure you modify the vmysql.h file 1st before you do all the other steps Thnaks Michael for Replying The Database settings are again done and updated in vmysql.h then i did make clean then ./configure with all options then here is what is says when i type make In file included from vauth.c:30: vmysql.h:51:22: warning: multi-line string literals are deprecated vauth.c: In function `vauth_open_update': vauth.c:108: `MYSQL_UPDATE_SERVER' undeclared (first use in this function) vauth.c:108: (Each undeclared identifier is reported only once vauth.c:108: for each function it appears in.) vauth.c:109: `MYSQL_UPDATE_USER' undeclared (first use in this function) vauth.c:109: `MYSQL_UPDATE_PASSWD' undeclared (first use in this function) vauth.c: In function `vauth_open_read_getall': vauth.c:201: `MYSQL_UPDATE_SERVER' undeclared (first use in this function) vauth.c:202: `MYSQL_UPDATE_USER' undeclared (first use in this function) vauth.c:202: `MYSQL_UPDATE_PASSWD' undeclared (first use in this function) make[2]: *** [vauth.o] Error 1 make[2]: Leaving directory `/usr/local/vpopmail' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/vpopmail' make: *** [all-recursive-am] Error 2 What have i made Wrong here now ? Regards, Tina
Re: [vchkpw] could not connect to mysql update server Access denied for user
Sounds to me like you are missing a quotation mark in vmysql.h from one of the #define lines that you modified to set the sql username/password No Actually due to the MYSQL_UPADTE error which occured quite often when i was compiling vpopmail i commented those lines and i forgot to uncomment in in the next run. After doing that the problem got resolved and evey mysql started connecting to it but now it started giving me one more error. When i do this : /home/vpopmail/bin/vadduser [EMAIL PROTECTED] webmaster vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist The database vpopmail is still Empty and no tables are there. How do i fill up the datanbase with the required tables ? I am quite newbie to this and belive me i didn't find any thing on Google expect the old Archives from this mailing list but there was no post in the older archive which would have helped me, so i am posting so much on this list. Regards, Tina.
SV: [vchkpw] could not connect to mysql update server Access denied for user
Sounds to me like you are missing a quotation mark in vmysql.h from one of the #define lines that you modified to set the sql username/password No Actually due to the MYSQL_UPADTE error which occured quite often when i was compiling vpopmail i commented those lines and i forgot to uncomment in in the next run. After doing that the problem got resolved and evey mysql started connecting to it but now it started giving me one more error. When i do this : /home/vpopmail/bin/vadduser [EMAIL PROTECTED] webmaster vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist vmysql: sql error[3]: Table 'vpopmail.mydomain_com' doesn't exist The database vpopmail is still Empty and no tables are there. How do i fill up the datanbase with the required tables ? It sounds like you are missing a 'vadddomain mydomain.com postmaster_password' -- that will create the needed table. - Jonas
Re: [vchkpw] could not connect to mysql update server Access denied for user
I am quite newbie to this and belive me i didn't find any thing on Google expect the old Archives from this mailing list but there was no post in the older archive which would have helped me, so i am posting so much on this list. Tina, Perhaps take a look at my quick guide to vpopmail with mysql at http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm Also available is a more comprehensive mail server guide at http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm Michael.
[vchkpw] imail users to qmail
Hello I'm not shure that this is the right forum but I'm going to ask anyway. I need to migrate some users form another isp that is using imail. Hees user name format is user$domain So user$test = [EMAIL PROTECTED] (Notice that there is no .com in the username.) dose anyone have any idea on how I can make vpopmail use the user$domain user format? Should I change the vchkpw code? Gerhard Just Olsen Avio as Tlf:++47 73 20 00 00 Fax:++47 73 20 00 01
Re: [vchkpw] phantom vpopmail alias domain
On Thursday, June 5, 2003, at 07:04 PM, Kurt Bigler wrote: Does vpopmail maintain the domain list somewhere else? I'm aware that vpopmail is just a layer on top of qmail, and I admit that I don't know enough about qmail to really understand the underpinnings, so apologies. /var/qmail/users/assign has the mapping of alias domain to real domain/directory. -- Tom Collins [EMAIL PROTECTED]
[vchkpw] vpopmail 5.3.20 deliver_mail() problem
In v5.3.20, some mods were made to the deliver_mail() function in velivermail.c During these mods I think there has been a couple of lines debugging code left in by accident When a message is bounced due to insufficient space in mailbox (or insufficient quota in domain ?), the bounce now contains some inappropriate text : Hi. This is the qmail-send program at reef.pipeline.com.au. I tried to deliver a bounce message to this address, but the bounce bounced! [EMAIL PROTECTED]: address: /home/vpopmail/domains/1/XXX.com.au/XXX/Maildir/ quota: 20971520S Message rejected. Not enough storage space in user's mailbox to accept message. Note the address: and quota: lines (The Message rejected... stuff is what I have programmed via my .over-quota.msg file) I dont know if they are debugs that were accidently left in the code, but certainly the address: entry shouldnt be shown. I guess there is an argument to display the quota, but if you were going to do it then you would want to have it formatted in a human-readable layout. I have attached the patch to remove these lines Michael. vpopmail-5.3.20-vdelivermail-removedebug.diff Description: Binary data
Re: [vchkpw] qmail-smtpd-chkusr Patch Problem
You did not read the instruction carefully it needs to run as vpopmail users -- Remo Mattei --cell 801-209-8554 http://www.italy1.com Freelance Networking-Security/Consultant MCSE, MCP, MCP+I, MCT Linux Trainer Firewall Development [EMAIL PROTECTED] From: Tom Walsh [EMAIL PROTECTED] Date: Thu, 5 Jun 2003 18:39:12 -0500 To: [EMAIL PROTECTED] Subject: [vchkpw] qmail-smtpd-chkusr Patch Problem I have patched my qmail to use the qmail-smtpd-chkusr functionality (on rcpt to: check to see if a user exists on the mail server and if the user doesn't send a 550). I have tested the functionality of qmail-smtpd (compiled with this patch and a couple others) and it works when I run it from the command line. My problem is when I run it from the tcpserver/supervise script the functionality doesn't work. I have managed to get it working by altering the -u and -g on the tcpserver command line to be root. When I do that it works flawlessly. It also works if I set the uid to root and set the gid to qmaild. My question (and I suppose directed at tonix): How can I get this to run with the proper user and group permissions of qmaild? Here are some of the details of my installation. /usr/bin/id -g qmaild 81 cat /etc/group |grep 81 qnofiles:*:81: ./supervise/smtp/run #!/bin/sh PATH=/var/qmail/bin:/usr/local/bin:/usr/bin:/bin export PATH QMAILUID=0 #NOFILESGID=0 #QMAILUID=`/usr/bin/id -u qmaild` NOFILESGID=`/usr/bin/id -g qmaild` exec softlimit -m 800 tcpserver -v -c 384 -p -R -x /usr/home/vpopmail/etc/tcp.smtp.cdb -u $QMAILUID -g $NOFILESGID 0 25 rblsmtpd -b -r relays.osirusoft.com -r relays.ordb.org fixcrio qmail-smtpd mail.ala.net /usr/home/vpopmail/bin/vchkpw /usr/bin/true 21 permissions on qmail-smtpd: -rwxr-xr-x 1 rootqmail 128528 Jun 5 16:26 qmail-smtpd I am assuming it has something to do with the setuid that the patch does, but I am unsure. Any pointers? Tom Walsh Network Admin http://www.ala.net/
Re: [vchkpw] qmail-smtpd-chkusr Patch Problem
Here is mine: rwxr-xr-x1 root qmail 90680 May 9 01:21 qmail-smtpd -- Remo Mattei --cell 801-209-8554 http://www.italy1.com Freelance Networking-Security/Consultant MCSE, MCP, MCP+I, MCT Linux Trainer Firewall Development [EMAIL PROTECTED] From: Rick Macdougall [EMAIL PROTECTED] Organization: Nougen Canada Inc. Date: Thu, 05 Jun 2003 19:58:25 -0400 To: Tom Walsh [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [vchkpw] qmail-smtpd-chkusr Patch Problem Hi, I had the same problem, root.nofiles for for qmail-smtpd-chkusr with owner and group suid workd for me ls -l qmail-smtp* -rwxr-xr-x1 root qmail 37740 Mar 26 11:36 qmail-smtpd -r-sr-sr-x1 root nofiles224080 May 13 05:27 qmail-smtpd-chkusr Regards, Rick Tom Walsh wrote: I have patched my qmail to use the qmail-smtpd-chkusr functionality (on rcpt to: check to see if a user exists on the mail server and if the user doesn't send a 550). I have tested the functionality of qmail-smtpd (compiled with this patch and a couple others) and it works when I run it from the command line. My problem is when I run it from the tcpserver/supervise script the functionality doesn't work. I have managed to get it working by altering the -u and -g on the tcpserver command line to be root. When I do that it works flawlessly. It also works if I set the uid to root and set the gid to qmaild. My question (and I suppose directed at tonix): How can I get this to run with the proper user and group permissions of qmaild? Here are some of the details of my installation. /usr/bin/id -g qmaild 81 cat /etc/group |grep 81 qnofiles:*:81: ./supervise/smtp/run #!/bin/sh PATH=/var/qmail/bin:/usr/local/bin:/usr/bin:/bin export PATH QMAILUID=0 #NOFILESGID=0 #QMAILUID=`/usr/bin/id -u qmaild` NOFILESGID=`/usr/bin/id -g qmaild` exec softlimit -m 800 tcpserver -v -c 384 -p -R -x /usr/home/vpopmail/etc/tcp.smtp.cdb -u $QMAILUID -g $NOFILESGID 0 25 rblsmtpd -b -r relays.osirusoft.com -r relays.ordb.org fixcrio qmail-smtpd mail.ala.net /usr/home/vpopmail/bin/vchkpw /usr/bin/true 21 permissions on qmail-smtpd: -rwxr-xr-x 1 rootqmail 128528 Jun 5 16:26 qmail-smtpd I am assuming it has something to do with the setuid that the patch does, but I am unsure. Any pointers? Tom Walsh Network Admin http://www.ala.net/
Re: [vchkpw] MySQL registration from vpopmail
Hello Eduardo. only change de user and password, before make and makeinstall. attacch the file with dump vpopmail database. I understood your advice. I have already challenged your correct procesure. But now(6/6/2003 14:24), vpopmail don't have still run properly. Thank you for your advice. P.D : where are you? in Korea or japon, or near there. i live in costa rica, but a im colombian. I'm Japanese. I live in Tokyo. I think that your mail-server or client PC clock is out of true. I recommend NetworkTimeProtcol SERVER. See you. Eduardo Garcia wrote: Hello Toyoda. you are a one big problem. before made a comand make, do you have modify file vmysql.h. in this file chahge de user and pass of user, this is my vmysql.h. see * Edit to match your set up */ #define MYSQL_UPDATE_SERVER "localhost" #define MYSQL_UPDATE_USER "root" #define MYSQL_UPDATE_PASSWD "cow" #define MYSQL_READ_SERVER "localhost" #define MYSQL_READ_USER "root" #define MYSQL_READ_PASSWD "cow" only change de user and password, before make and makeinstall. attacch the file with dump vpopmail database. see you later. enzo Eduardo Garcia. P.D : where are you? in Korea or japon, or near there. i live in costa rica, but a im colombian. Toyoda Yasuyuki wrote: Hi, I have a problem about (qmail + vpopmail + MySQL) system. My system is qmail + vpopmail + qmailadmin + MySQL. Q1.) I want to register MySQL tables of vpopmail database. I performed the following command. ---command start groupadd mysql mkdir -p /usr/local/mysql/var useradd -g mysql -d /usr/local/mysql/var mysql cd /usr/local/src ftp http://www.softagency.co.jp/MySQL/Downloads/MySQL-4.0/mysql-4.0.13.tar.gz tar -xzf mysql-4.0.13.tar.gz rm -f mysql-4.0.13.tar.gz cd mysql-4.0.13 ./configure --prefix=/usr/local/mysql --with-charset=ujis -with-extra-charsets=all --with-mysqld-user=mysql make make install /usr/local/mysql/bin/mysql_install_db --user=mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql/var /usr/local/mysql/bin/mysqld_safe --user=mysql /usr/local/mysql/bin/mysqlshow +---+ | Databases | +---+ | mysql | | test | +---+ cd /usr/local/src/vpopmail-5.2.1 ./configure --enable-roaming-users=y --enable-mysql=y --enable-incdir=/usr/local/mysql/include/mysql --enable-libdir=/usr/local/mysql/lib/mysql --enable-sqlincdir=/usr/local/mysql/include/mysql --enable-sqllibdir=/usr/local/mysql/lib/mysql make make install-strip /usr/local/mysql/bin/mysqladmin create vpopmail /usr/local/mysql/bin/mysql mysql grant select,insert,update,delete,create on vpopmail.* to [EMAIL PROTECTED] identified by 'password'; Query OK, 0 rows affected (0.00 sec) mysql exit /usr/local/mysql/bin/mysqlshow +---+ | Databases | +---+ | mysql | | test | | vpopmail | +---+ qmail starting. /home/vpopmail/bin/vadddomain good.for.com qmail restarting. setenv LD_LIBRARY_PATH /usr/local/mysql/lib/mysql /home/vpopmail/bin/vconvert -c -m Add user "[EMAIL PROTECTED]" through qmailadmin. /usr/local/mysql/bin/mysqlshow vpopmail Database: vpopmail ++ | Tables | ++ ++ ---command finish I created virtual domain(example. good.for.com) to vpopmail. At this time, I think that Automatically Something tables of vpopmail is created in the MySQL. Is my thinking mistake? Do I have to add manually tables of vpopmail to MySQL. Thank you in advance. Yasuyuki Toyoda. # MySQL dump 8.14 # # Host: localhostDatabase: vpopmail # # Server version 3.23.41 # # Table structure for table 'dir_control' # CREATE TABLE dir_control ( domain char(64) NOT NULL default '', cur_users int(11) default NULL, level_cur int(11) default NULL, level_max int(11) default NULL, level_start0 int(11) default NULL, level_start1 int(11) default NULL, level_start2 int(11) default NULL, level_end0 int(11) default NULL, level_end1 int(11) default NULL, level_end2 int(11) default NULL, level_mod0 int(11) default NULL, level_mod1 int(11) default NULL, level_mod2 int(11) default NULL, level_index0 int(11) default NULL, level_index1 int(11) default NULL, level_index2 int(11) default
RE: [vchkpw] Toasters with POP-Before-SMTP
Ben, Just read the vpopmail directions on --enable-roaming-users=y as a ./configure option. It tells you what you need to do. You can use mysql or a flat file to store the files, it doesn't matter. As for the POP-before-imap I can't tell you off the top of my head. I have not tackled it yet. -Jeff -Original Message- From: Ben Ullian [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 10:05 PM To: [EMAIL PROTECTED] Subject: [vchkpw] Toasters with POP-Before-SMTP does anyone know of a qmail toaster setup guide (with or without mysql -- I dont care, cdb is fine) that describes how to implement POP/IMAP before SMTP with vpopmail? I'm not even sure if IMAP before SMTP is possible, but if so, it would be good (i'd be using Courier-IMAP). I had a toaster set up a while ago which required POP-before-SMTP, but I recompiled Qmail to use mysql and since then I have had open relay issues, yet i can't seem to find the original guide i used. I'd be willing to ditch mysql entirely and do the first installation again, as long as the solution has pop-before-smtp/imap-before-smtp. ben
RE: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes
Joe, Have you considered writing this out to SQL for SA? I'm not sure of the SA table format off the top of my head, but some people have given up on running SA locally out of .qmail files and run it for every domain and sometimes on a machine well before the system mail is eventually delivered too. Of course, I've given up on enabling/disabling it for individual users and just turn it on (with everything hidden in the headers so it isn't obvious it's even on) for entire domains. You may find more flexibility if you change options in the mysql backend for SA instead of poking changes into .qmail files. Just my personal opinion. -jeff -Original Message- From: Joe Young [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 8:23 PM To: [EMAIL PROTECTED] Subject: Re: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes Joseph Young Involved.com System Admin I am working on a patch for adding spamassassin into the QmailAdmin. I have beginner's experience at C++ and have some of the work done. It is difficult to say where I am at in the process. The patch is still beta and works for only qmailadmin-1.0.7.01132003. If anyone is interested in helping get the patch finished or working for another version, goto http://naos.involved.com/ I have qmailadmin to show a check box that is checked if there is the line,enable_spamassassin, to .qmailadmin-limits. So the next step is to have in user.c to add the line,|/var/qmail/bin/preline /usr/local/bin/maildrop /home/vpopmail/etc/mailfilter, in the user's .qmail when it when user selects it. I need help in writing the code to modusergo() in user.c to check .qmail and to write to .qmail. I have set up a anonymous cvs server for this project. cvs -d :pserver:[EMAIL PROTECTED]:/home/cvsroot login Use password: cvs cvs -d :pserver:[EMAIL PROTECTED]:/home/cvsroot checkout qmailadminspam joe - Original Message - From: Dave Weiner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 07, 2003 1:45 PM Subject: Re: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes Gabriel Ambuehl wrote: -BEGIN PGP SIGNED MESSAGE- Hello Dave, Hi Gabriel. No need to CC me, I get the list email just as fast :) Friday, March 7, 2003, 9:09:17 PM, you wrote: The lack of being able to turn it off per user is probably the only thing that holds me back from using it :) I suppose adding a new field into vpasswd is a nono as it would break a lot of existing code, right? So the flagfile is probably the best idea (easy to implement, too). Thoughts? Yes, I think some sort of dotfile would be the best. Then any number of tools could use it. Suggestion, for those of us that use sql user prefs. If the dotfile is present but empty, just make the connection to spamc/spamd, assuming that vpopmail support in spamassassin is being used. If there's text in the dotfile, use that for the -u option Best regards, Gabriel Dave
[vchkpw] vpasswd file is 0 size when hit quota limit
Hi, I had set the following for a domain as below:- vadddomain -u user1 user1.com password Then, I set the quota using the command:- edquota user1 With the following information inside edquota:- Disk quotas for user user1 (uid 519): Filesystem blocks soft hard inodes soft hard /dev/md0 80 83886 8388642400 Now the disk quotas grow, here is what I have:- Disk quotas for user user1 (uid 519): Filesystem blocks soft hard inodes soft hard /dev/md0 84810 83886 8388642400 And, I notice that all the users in the domain user1.com can't login via POP3 service to check email. Even can't received email via SMTP service. I notice that the vpasswd file is now 0 bytes. The vpasswd.cdb is 2048 bytes. When I try to view the vpasswd file, nothing is inside the file. How can I recover the vpasswd file from the vpasswd.cdb? Can it be recover? Is the way I do quota correct? Any suggestion? How can I use warnquota to help me on this? Thank you. Rgds, Yee __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
Re: [vchkpw] Working towards vpopmail 5.4 stable
On Tuesday 03 June 2003 6:51 pm, Steve Fulton wrote: Hmm ... the only additional feature I could use, is the ability to set user accounts to expire on a certain date, like system accounts. Look at Freeside, Optigold ISP or Billmax. Each has that ability (and more), the latter two are not free. Yes, they do more than you probably want, but the chances of expiring users making it into Vpopmail in the future are slim. The developers abandoned any illusions of making a complete ISP tool long ago, and decided to focus on the core usage. -- Steve I've never had the illusion of turning vpopmail into a complete ISP account management package. It is an virtual email management package and probably best left to that task. I think a complete ISP package is best contained in it's own project, and hooked up to vpopmail by calling command line programs. I've worked on several ISP projects were we did exactly that. The ISP programs called shell scripts to add/delete/update email accounts. It took about 1 hour to update these scripts to call the vpopmail programs. Ken Jones
Re: [vchkpw] Working towards vpopmail 5.4 stable
On Tue, 3 Jun 2003, Ken Jones wrote: Does anyone have any code changes they would like to get into the next release? I want to put together a new stable version 5.4. Hopefully release it in the next few weeks. There seems to be a problem in th maildir_to_email() function in vdelivermail.c. If the domain dir is not directly under the DOMAINS_DIR, e.g. /home/vpopmail/domains/1/example.com, then a user [EMAIL PROTECTED] will have a maildir of: /home/vpopmail/domains/1/example.com/joe/Maildir/ and maildir_to_email() returns an email address of [EMAIL PROTECTED] instead of [EMAIL PROTECTED] This should definitely be fixed as it is a simple and obvious bug. My (untested) fix is as follows. Change the following block located near the bottom of maildir_to_email(): for( pnt = last + (strlen(DOMAINS_DIR)+2); (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } to: pnt = last + strlen(DOMAINS_DIR) + 2; while( *(pnt+1) == '/' ) pnt+=2; for( ; (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } Moshe -- Moshe Jacobson http://runslinux.net AIM: Jehsom
Re: [vchkpw] Working towards vpopmail 5.4 stable
On Wed, 4 Jun 2003 10:37:41 -0400 (EDT) Moshe Jacobson [EMAIL PROTECTED] wrote: On Tue, 3 Jun 2003, Ken Jones wrote: Does anyone have any code changes they would like to get into the next release? I want to put together a new stable version 5.4. Hopefully release it in the next few weeks. There seems to be a problem in th maildir_to_email() function in vdelivermail.c. If the domain dir is not directly under the DOMAINS_DIR, e.g. /home/vpopmail/domains/1/example.com, then a user [EMAIL PROTECTED] will have a maildir of: /home/vpopmail/domains/1/example.com/joe/Maildir/ and maildir_to_email() returns an email address of [EMAIL PROTECTED] instead of [EMAIL PROTECTED] This should definitely be fixed as it is a simple and obvious bug. My (untested) fix is as follows. Change the following block located near the bottom of maildir_to_email(): for( pnt = last + (strlen(DOMAINS_DIR)+2); (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } to: pnt = last + strlen(DOMAINS_DIR) + 2; while( *(pnt+1) == '/' ) pnt+=2; for( ; (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } Moshe -- Moshe Jacobson http://runslinux.net AIM: Jehsom it seems to me a far more permanent and scalable solution would be to select pw_name, pw_domain where pw_dir=DIR in the database. it is conceivable that [EMAIL PROTECTED]'s maildir be located in /some/where/else/joe/Maildir
[vchkpw] AUTH_LOGGING and db failure tolarance.
I don't know how many people would desire this behaviour. but I think it should be considered. in vmysql.c I added the following lines to vauth_open_update() uint timeout = 1; mysql_options(mysql_update, MYSQL_OPT_CONNECT_TIMEOUT, (char*) timeout); this adds a timeout to the mysql_real_connect method. without this libmysqlclient uses the standard connect() to connect which, under heavy load, can take minutes to timeout, the effect is that if the update server was to become unavailable your pop concurency would max out very quickly, effectively a loss of service. also you would want to remove the error lines: fprintf(stderr, could not connect to mysql update server %s with database\n, mysql_error(mysql_update)); and fprintf(stderr, could not connect to mysql update server %s\n, mysql_error(mysql_update)); because some pop clients break if they receive anything other than the ok after auth.
Re: [vchkpw] SpamAssassin/vmodinfo changes
I have a sizable patch from Jeff Hedlund scheduled for the qmailadmin-1.0.21 release that adds very flexible, per-user spamassassin support. I'll (hopefully) announce the release later today, along with information on how it works. -- Tom Collins [EMAIL PROTECTED]
Re: [vchkpw] AUTH_LOGGING and db failure tolarance.
Done. I also added it to the other mysql connect calls (2 others). Is the timeout value in seconds? Maybe we should give it more than 1 second to connect. Perhaps 3? Ken Jones On Wednesday 04 June 2003 10:01 am, matthew berardi wrote: I don't know how many people would desire this behaviour. but I think it should be considered. in vmysql.c I added the following lines to vauth_open_update() uint timeout = 1; mysql_options(mysql_update, MYSQL_OPT_CONNECT_TIMEOUT, (char*) timeout); this adds a timeout to the mysql_real_connect method. without this libmysqlclient uses the standard connect() to connect which, under heavy load, can take minutes to timeout, the effect is that if the update server was to become unavailable your pop concurency would max out very quickly, effectively a loss of service. also you would want to remove the error lines: fprintf(stderr, could not connect to mysql update server %s with database\n, mysql_error(mysql_update)); and fprintf(stderr, could not connect to mysql update server %s\n, mysql_error(mysql_update)); because some pop clients break if they receive anything other than the ok after auth.
Re: [vchkpw] AUTH_LOGGING and db failure tolarance.
hmm, I had read that it was seconds however it is in fact less. I know setting it to 1 is long enough for it to make the connection even under moderate load on our 100mb/cisco lan, and I deleted the mysql source because I'm stressed for disk space on my laptop, when I get a chance I will investigate further, corporate programming has a tendancy to reduce the priority on cleanup once you have it working. I don't know if its desirable to set that on the other connections, are they for adds/deletes? if so its hardly service impacting for them not to timeout timely. matt btw, I apologise for our little problem a few months back on the qmail list. On Wed, 4 Jun 2003 10:50:29 -0500 Ken Jones [EMAIL PROTECTED] wrote: Done. I also added it to the other mysql connect calls (2 others). Is the timeout value in seconds? Maybe we should give it more than 1 second to connect. Perhaps 3? Ken Jones On Wednesday 04 June 2003 10:01 am, matthew berardi wrote: I don't know how many people would desire this behaviour. but I think it should be considered. in vmysql.c I added the following lines to vauth_open_update() uint timeout = 1; mysql_options(mysql_update, MYSQL_OPT_CONNECT_TIMEOUT, (char*) timeout); this adds a timeout to the mysql_real_connect method. without this libmysqlclient uses the standard connect() to connect which, under heavy load, can take minutes to timeout, the effect is that if the update server was to become unavailable your pop concurency would max out very quickly, effectively a loss of service. also you would want to remove the error lines: fprintf(stderr, could not connect to mysql update server %s with database\n, mysql_error(mysql_update)); and fprintf(stderr, could not connect to mysql update server %s\n, mysql_error(mysql_update)); because some pop clients break if they receive anything other than the ok after auth.
Re: [vchkpw] Working towards vpopmail 5.4 stable
I think we added a clear password field into the mysql vpopmail table. Ken Jones On Wednesday 04 June 2003 11:15 am, Jeff Garvas wrote: Pardon my ignorance, but will a 5.4 stable version require any major modifications to a working 5.2.1 installation? Has anything changed in terms of the sql table layout or anything else that would make upgrading more significant than simply running configure, make, make install? I put off installing for awhile because I feared this would happen, now I get to upgrade a 5.2.1 install soon. Can't wait to see the new features :) -Jeff -Original Message- From: Ken Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 11:54 AM To: Moshe Jacobson; [EMAIL PROTECTED] Subject: Re: [vchkpw] Working towards vpopmail 5.4 stable Seems like a reasonable change. I put it in. Needs testing! Looks like we will start a series of devel releases to test these changes. I'll package one up end of day tomorrow. Ken Jones On Wednesday 04 June 2003 9:37 am, Moshe Jacobson wrote: On Tue, 3 Jun 2003, Ken Jones wrote: Does anyone have any code changes they would like to get into the next release? I want to put together a new stable version 5.4. Hopefully release it in the next few weeks. There seems to be a problem in th maildir_to_email() function in vdelivermail.c. If the domain dir is not directly under the DOMAINS_DIR, e.g. /home/vpopmail/domains/1/example.com, then a user [EMAIL PROTECTED] will have a maildir of: /home/vpopmail/domains/1/example.com/joe/Maildir/ and maildir_to_email() returns an email address of [EMAIL PROTECTED] instead of [EMAIL PROTECTED] This should definitely be fixed as it is a simple and obvious bug. My (untested) fix is as follows. Change the following block located near the bottom of maildir_to_email(): for( pnt = last + (strlen(DOMAINS_DIR)+2); (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } to: pnt = last + strlen(DOMAINS_DIR) + 2; while( *(pnt+1) == '/' ) pnt+=2; for( ; (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } Moshe
[vchkpw] problem with vconvert to sql
Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia.
RE: [vchkpw] Working towards vpopmail 5.4 stable
Ken, I'm working on some changes to the PostgreSQL code. I'll have them hopefully by the end of the day or early tomorrow. I've fixed some things in configure.in so it will compile correct. I've also added the vauth_crypt() function to the pgsql.c code. Since this isn't an SQL specific function, shouldn't it be moved into one of the more common files? I could be wrong but it doesn't appear to be only used in the mySQL code. I've also added the code needed in configure.in so the PostgreSQL logging functions can be enabled. Charles -Original Message- From: Ken Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 9:52 AM To: Jeff Garvas; [EMAIL PROTECTED] Subject: Re: [vchkpw] Working towards vpopmail 5.4 stable I think we added a clear password field into the mysql vpopmail table. Ken Jones On Wednesday 04 June 2003 11:15 am, Jeff Garvas wrote: Pardon my ignorance, but will a 5.4 stable version require any major modifications to a working 5.2.1 installation? Has anything changed in terms of the sql table layout or anything else that would make upgrading more significant than simply running configure, make, make install? I put off installing for awhile because I feared this would happen, now I get to upgrade a 5.2.1 install soon. Can't wait to see the new features :) -Jeff -Original Message- From: Ken Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 11:54 AM To: Moshe Jacobson; [EMAIL PROTECTED] Subject: Re: [vchkpw] Working towards vpopmail 5.4 stable Seems like a reasonable change. I put it in. Needs testing! Looks like we will start a series of devel releases to test these changes. I'll package one up end of day tomorrow. Ken Jones On Wednesday 04 June 2003 9:37 am, Moshe Jacobson wrote: On Tue, 3 Jun 2003, Ken Jones wrote: Does anyone have any code changes they would like to get into the next release? I want to put together a new stable version 5.4. Hopefully release it in the next few weeks. There seems to be a problem in th maildir_to_email() function in vdelivermail.c. If the domain dir is not directly under the DOMAINS_DIR, e.g. /home/vpopmail/domains/1/example.com, then a user [EMAIL PROTECTED] will have a maildir of: /home/vpopmail/domains/1/example.com/joe/Maildir/ and maildir_to_email() returns an email address of [EMAIL PROTECTED] instead of [EMAIL PROTECTED] This should definitely be fixed as it is a simple and obvious bug. My (untested) fix is as follows. Change the following block located near the bottom of maildir_to_email(): for( pnt = last + (strlen(DOMAINS_DIR)+2); (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } to: pnt = last + strlen(DOMAINS_DIR) + 2; while( *(pnt+1) == '/' ) pnt+=2; for( ; (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } Moshe
[vchkpw] this is a test
sorry but this test. but tha last email dont send. enzo.
Re: [vchkpw] Working towards vpopmail 5.4 stable
Sounds great. I'd leave the vauth_crypt() function in the pgsql.c code. I want to minimize the amount of testing needed. On Wednesday 04 June 2003 1:02 pm, Charles J. Boening wrote: Ken, I'm working on some changes to the PostgreSQL code. I'll have them hopefully by the end of the day or early tomorrow. I've fixed some things in configure.in so it will compile correct. I've also added the vauth_crypt() function to the pgsql.c code. Since this isn't an SQL specific function, shouldn't it be moved into one of the more common files? I could be wrong but it doesn't appear to be only used in the mySQL code. I've also added the code needed in configure.in so the PostgreSQL logging functions can be enabled. Charles
Re: [vchkpw] Working towards vpopmail 5.4 stable
On Wed, 4 Jun 2003, Moshe Jacobson wrote: My (untested) fix is as follows. pnt = last + strlen(DOMAINS_DIR) + 2; while( *(pnt+1) == '/' ) pnt+=2; for( ; (*pnt *pnt != '/' j 255); ++pnt, ++j ) { email[j] = *pnt; } If we're not going to ever see cvs access for this project, I would think a good idea would be to have seperate user/devel lists for the major projects. At the very least we can keep the does SpamAssassin work with vpopmail messages seperate from the patches that may or may not be applied messages. Charles Moshe -- Moshe Jacobson http://runslinux.net AIM: Jehsom
Re: [vchkpw] Toasters with POP-Before-SMTP
http://www.shupp.org/toaster/ is the one I use, but the other answer you got is correct about the config arguement. POP-Before-IMAP is possible, but for some reason Courier has disabled the feature for unexplained security reasons. I don't have the information handy, but I'm sure someone else on the list can provide the file and line you have to edit to get it to work. Matthew Ben Ullian said: does anyone know of a qmail toaster setup guide (with or without mysql -- I dont care, cdb is fine) that describes how to implement POP/IMAP before SMTP with vpopmail? I'm not even sure if IMAP before SMTP is possible, but if so, it would be good (i'd be using Courier-IMAP). I had a toaster set up a while ago which required POP-before-SMTP, but I recompiled Qmail to use mysql and since then I have had open relay issues, yet i can't seem to find the original guide i used. I'd be willing to ditch mysql entirely and do the first installation again, as long as the solution has pop-before-smtp/imap-before-smtp. ben
[vchkpw] problem iwth vconvert to sql
Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia.
Re: [vchkpw] problem iwth vconvert to sql
Hi, Would you not want -c -m ? I do not see -s as an option anywhere. Oh, Ken, as long as you are patching today, maybe you could add a line feed to the help message so the -e = etc format starts on a new line :) Regards, Rick Eduardo Garcia wrote: Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia.
Re: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes
Joseph Young Involved.com System Admin I have spamassassin running through qmail-scanner. So when the email gets to vpopmail, it was scanned. I originally thought to modify the qmailadmin. But I found that I could use the white_to field in SA and dynamically change it through mySQL. Then all that I would need to do use maildrop within .qmail-default. The maildrop would detect the SPAM header and move the spam into the user's spam directory. However, the email still gets markup with spam code. Question- if I make a user whitelisted does the bayes_autolearn learn that the spam email is good. If this is so, I am back at modifing qmailadmin. joe - Original Message - From: Jeff Garvas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 6:43 AM Subject: RE: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes Joe, Have you considered writing this out to SQL for SA? I'm not sure of the SA table format off the top of my head, but some people have given up on running SA locally out of .qmail files and run it for every domain and sometimes on a machine well before the system mail is eventually delivered too. Of course, I've given up on enabling/disabling it for individual users and just turn it on (with everything hidden in the headers so it isn't obvious it's even on) for entire domains. You may find more flexibility if you change options in the mysql backend for SA instead of poking changes into .qmail files. Just my personal opinion. -jeff -Original Message- From: Joe Young [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 8:23 PM To: [EMAIL PROTECTED] Subject: Re: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes Joseph Young Involved.com System Admin I am working on a patch for adding spamassassin into the QmailAdmin. I have beginner's experience at C++ and have some of the work done. It is difficult to say where I am at in the process. The patch is still beta and works for only qmailadmin-1.0.7.01132003. If anyone is interested in helping get the patch finished or working for another version, goto http://naos.involved.com/ I have qmailadmin to show a check box that is checked if there is the line,enable_spamassassin, to .qmailadmin-limits. So the next step is to have in user.c to add the line,|/var/qmail/bin/preline /usr/local/bin/maildrop /home/vpopmail/etc/mailfilter, in the user's .qmail when it when user selects it. I need help in writing the code to modusergo() in user.c to check .qmail and to write to .qmail. I have set up a anonymous cvs server for this project. cvs -d :pserver:[EMAIL PROTECTED]:/home/cvsroot login Use password: cvs cvs -d :pserver:[EMAIL PROTECTED]:/home/cvsroot checkout qmailadminspam joe - Original Message - From: Dave Weiner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 07, 2003 1:45 PM Subject: Re: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes Gabriel Ambuehl wrote: -BEGIN PGP SIGNED MESSAGE- Hello Dave, Hi Gabriel. No need to CC me, I get the list email just as fast :) Friday, March 7, 2003, 9:09:17 PM, you wrote: The lack of being able to turn it off per user is probably the only thing that holds me back from using it :) I suppose adding a new field into vpasswd is a nono as it would break a lot of existing code, right? So the flagfile is probably the best idea (easy to implement, too). Thoughts? Yes, I think some sort of dotfile would be the best. Then any number of tools could use it. Suggestion, for those of us that use sql user prefs. If the dotfile is present but empty, just make the connection to spamc/spamd, assuming that vpopmail support in spamassassin is being used. If there's text in the dotfile, use that for the -u option Best regards, Gabriel Dave
Re: [vchkpw] problem iwth vconvert to sql
I'm not writing any new code. I'm only applying code changes that people send me. Ken On Wednesday 04 June 2003 2:16 pm, Rick Macdougall wrote: Hi, Would you not want -c -m ? I do not see -s as an option anywhere. Oh, Ken, as long as you are patching today, maybe you could add a line feed to the help message so the -e = etc format starts on a new line :) Regards, Rick Eduardo Garcia wrote: Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia.
[vchkpw] auth logging db tolorance
sorry for the new thread, ken, the uint is in fact supposed to be seconds, I don't understand everything going on in connect2() in libmysqlclient, however the comments say seconds and it is put in a timeval struct, defined as seconds in bits/time.h. further testing verifies this, however keep in mind when adjusting the value that the actuall lag experienced will be twice that as vmsql tries to connect twice (with and without specifying the database). thanks matt
Re: [vchkpw] Toasters with POP-Before-SMTP
On Wed, 4 Jun 2003, Matthew Walker wrote: POP-Before-IMAP is possible, but for some reason Courier has disabled the feature for unexplained security reasons. I don't have the information handy, but I'm sure someone else on the list can provide the file and line you have to edit to get it to work. I posted a query to the courier list (and also found another post asking the same thing) about the IMAP-before-SMTP problem, but did not get any answers. Charles Matthew Ben Ullian said: does anyone know of a qmail toaster setup guide (with or without mysql -- I dont care, cdb is fine) that describes how to implement POP/IMAP before SMTP with vpopmail? I'm not even sure if IMAP before SMTP is possible, but if so, it would be good (i'd be using Courier-IMAP). I had a toaster set up a while ago which required POP-before-SMTP, but I recompiled Qmail to use mysql and since then I have had open relay issues, yet i can't seem to find the original guide i used. I'd be willing to ditch mysql entirely and do the first installation again, as long as the solution has pop-before-smtp/imap-before-smtp. ben
Re: [vchkpw] Toasters with POP-Before-SMTP
Spork said: On Wed, 4 Jun 2003, Matthew Walker wrote: POP-Before-IMAP is possible, but for some reason Courier has disabled the feature for unexplained security reasons. I don't have the information handy, but I'm sure someone else on the list can provide the file and line you have to edit to get it to work. I posted a query to the courier list (and also found another post asking the same thing) about the IMAP-before-SMTP problem, but did not get any answers. Digging back through my mailbox, I found this: To be a little more precise... Remove the line #undef HAVE_OPEN_SMTP_RELAY from authlib/preauthvchkpw.c and recompile Courier-IMAP. in reference to the IMAP-Before-SMTP problem. From what I can tell, this /should/ be enough to get it going. Matthew
Re: [vchkpw] Vpopmail and Qconfirm Help
Let me know if you get this working! I've been looking for a good TMDA solution for vpopmail, and this looks very promising. Gerardo Arnaez said: hi all. I have read various google searches, have read the faqs and manuals and still have no luck, I am trying to setup qconfirm for the vpopmail virtual email. I have been unsuccessful At first The errors were that vpopmail could not create a lock here are the rcphosts as listed in [EMAIL PROTECTED]:/var/qmail/control$ cat rcpthosts tinkies.mung.net baffler.net baffler.org mung.net [EMAIL PROTECTED]:/var/qmail/control$ cat virtualdomains baffler.net:baffler.net baffler.org:baffler.org mung.net:mung.net [EMAIL PROTECTED]:/var/qmail/control$ cat locals tinkies.mung.net The vpopmail vdomain that am tring to set up and the virtual user is: tinkies:/home/vpopmail/domains/mung.net/dude the contents of that directory are drwx--4 vpopmail vchkpw 4096 Jun 3 18:07 . drwx--4 vpopmail vchkpw 4096 Jun 3 18:05 .. drwxr-x---6 vpopmail vchkpw 4096 Jun 3 17:56 .qconfirm -rw-r--r--1 vpopmail vchkpw183 Jun 3 17:52 .qmail drwx--5 vpopmail vchkpw 4096 Jun 3 17:00 Maildir -rw---1 vpopmail vchkpw 14 Jun 3 18:13 lastauth I have had no luck in getting mail delievered to the virutal email my .qmail currently looks like |setlock /home/vpopmail/domains/mung.net/dude/.qconfirm/lock envdir /home/vpopmail/domains/mung.net/dude/.qconfirm/conf qconfirm-check -m /home/vpopmail/domains/mung.net/dude/Maildir I have tried various .qmail configuratins but qconfirm also says that the [EMAIL PROTECTED] does not exit and never delievers. I would appreciate help in getting this set up as I am setting up a qmail-vpopmail-qmailadmin for a nonprofit Thank you. G __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
Re: [vchkpw] Vpopmail and Qconfirm Help
Acutally. I just found out about TMDA, and it has a section on vpopmail which I have been experimenting with, (I actually think i got it working once, but didnt document what I did and now have can recreate what I did) so If I get it working I will add it to my qmail-vpopmail howtoat http://mung.net G --- Matthew Walker [EMAIL PROTECTED] wrote: Let me know if you get this working! I've been looking for a good TMDA solution for vpopmail, and this looks very promising. Gerardo Arnaez said: hi all. I have read various google searches, have read the faqs and manuals and still have no luck, I am trying to setup qconfirm for the vpopmail virtual email. I have been unsuccessful At first The errors were that vpopmail could not create a lock here are the rcphosts as listed in [EMAIL PROTECTED]:/var/qmail/control$ cat rcpthosts tinkies.mung.net baffler.net baffler.org mung.net [EMAIL PROTECTED]:/var/qmail/control$ cat virtualdomains baffler.net:baffler.net baffler.org:baffler.org mung.net:mung.net [EMAIL PROTECTED]:/var/qmail/control$ cat locals tinkies.mung.net The vpopmail vdomain that am tring to set up and the virtual user is: tinkies:/home/vpopmail/domains/mung.net/dude the contents of that directory are drwx--4 vpopmail vchkpw 4096 Jun 3 18:07 . drwx--4 vpopmail vchkpw 4096 Jun 3 18:05 .. drwxr-x---6 vpopmail vchkpw 4096 Jun 3 17:56 .qconfirm -rw-r--r--1 vpopmail vchkpw183 Jun 3 17:52 .qmail drwx--5 vpopmail vchkpw 4096 Jun 3 17:00 Maildir -rw---1 vpopmail vchkpw 14 Jun 3 18:13 lastauth I have had no luck in getting mail delievered to the virutal email my .qmail currently looks like |setlock /home/vpopmail/domains/mung.net/dude/.qconfirm/lock envdir /home/vpopmail/domains/mung.net/dude/.qconfirm/conf qconfirm-check -m /home/vpopmail/domains/mung.net/dude/Maildir I have tried various .qmail configuratins but qconfirm also says that the [EMAIL PROTECTED] does not exit and never delievers. I would appreciate help in getting this set up as I am setting up a qmail-vpopmail-qmailadmin for a nonprofit Thank you. G __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
Re: [vchkpw] Toasters with POP-Before-SMTP
POP-Before-IMAP is possible, but for some reason Courier has disabled the feature for unexplained security reasons. I don't have the information handy, but I'm sure someone else on the list can provide the file and line you have to edit to get it to work. Yes, and it works just fine if you uncomment it. I am not sure what the security reason is either, perhaps with an older version of vpopmail or something the possibility of a buffer overflow? Regards, Andrew
Re: [vchkpw] problem iwth vconvert to sql
Please apply the following patch to vconvert: diff -u vpopmail-5.3.20/vconvert.c vpopmail-5.3.20-tc/vconvert.c --- vpopmail-5.3.20/vconvert.c 2003-03-24 13:54:37.0 -0700 +++ vpopmail-5.3.20-tc/vconvert.c 2003-06-04 14:32:54.0 -0700 @@ -312,8 +312,8 @@ void usage() { fprintf(stdout, vconvert: usage\n); - fprintf(stdout, The first option sets which format to convert FROM); - fprintf(stdout, the second option sets which format to convert TO); + fprintf(stdout, The first option sets which format to convert FROM,\n); + fprintf(stdout, the second option sets which format to convert TO.\n); fprintf(stdout, -e = etc format\n); fprintf(stdout, -c = cdb format\n); fprintf(stdout, -m = sql format\n); On Wednesday, June 4, 2003, at 12:41 PM, Ken Jones wrote: I'm not writing any new code. I'm only applying code changes that people send me. Ken On Wednesday 04 June 2003 2:16 pm, Rick Macdougall wrote: Hi, Would you not want -c -m ? I do not see -s as an option anywhere. Oh, Ken, as long as you are patching today, maybe you could add a line feed to the help message so the -e = etc format starts on a new line :) Regards, Rick Eduardo Garcia wrote: Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia. -- Tom Collins [EMAIL PROTECTED]
Re: [vchkpw] Vpopmail and Qconfirm Help
I have tmda working on my vpopmail accounts works very well. -- Remo Mattei --cell 801-209-8554 http://www.italy1.com Freelance Networking-Security/Consultant MCSE, MCP, MCP+I, MCT Linux Trainer Firewall Development [EMAIL PROTECTED] From: Gerardo Arnaez [EMAIL PROTECTED] Date: Wed, 4 Jun 2003 13:43:13 -0700 (PDT) To: Matthew Walker [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [vchkpw] Vpopmail and Qconfirm Help Acutally. I just found out about TMDA, and it has a section on vpopmail which I have been experimenting with, (I actually think i got it working once, but didnt document what I did and now have can recreate what I did) so If I get it working I will add it to my qmail-vpopmail howtoat http://mung.net G --- Matthew Walker [EMAIL PROTECTED] wrote: Let me know if you get this working! I've been looking for a good TMDA solution for vpopmail, and this looks very promising. Gerardo Arnaez said: hi all. I have read various google searches, have read the faqs and manuals and still have no luck, I am trying to setup qconfirm for the vpopmail virtual email. I have been unsuccessful At first The errors were that vpopmail could not create a lock here are the rcphosts as listed in [EMAIL PROTECTED]:/var/qmail/control$ cat rcpthosts tinkies.mung.net baffler.net baffler.org mung.net [EMAIL PROTECTED]:/var/qmail/control$ cat virtualdomains baffler.net:baffler.net baffler.org:baffler.org mung.net:mung.net [EMAIL PROTECTED]:/var/qmail/control$ cat locals tinkies.mung.net The vpopmail vdomain that am tring to set up and the virtual user is: tinkies:/home/vpopmail/domains/mung.net/dude the contents of that directory are drwx--4 vpopmail vchkpw 4096 Jun 3 18:07 . drwx--4 vpopmail vchkpw 4096 Jun 3 18:05 .. drwxr-x---6 vpopmail vchkpw 4096 Jun 3 17:56 .qconfirm -rw-r--r--1 vpopmail vchkpw183 Jun 3 17:52 .qmail drwx--5 vpopmail vchkpw 4096 Jun 3 17:00 Maildir -rw---1 vpopmail vchkpw 14 Jun 3 18:13 lastauth I have had no luck in getting mail delievered to the virutal email my .qmail currently looks like |setlock /home/vpopmail/domains/mung.net/dude/.qconfirm/lock envdir /home/vpopmail/domains/mung.net/dude/.qconfirm/conf qconfirm-check -m /home/vpopmail/domains/mung.net/dude/Maildir I have tried various .qmail configuratins but qconfirm also says that the [EMAIL PROTECTED] does not exit and never delievers. I would appreciate help in getting this set up as I am setting up a qmail-vpopmail-qmailadmin for a nonprofit Thank you. G __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
Re: [vchkpw] Toasters with POP-Before-SMTP
Matthew Walker wrote: Spork said: On Wed, 4 Jun 2003, Matthew Walker wrote: POP-Before-IMAP is possible, but for some reason Courier has disabled the feature for unexplained security reasons. I don't have the information handy, but I'm sure someone else on the list can provide the file and line you have to edit to get it to work. I posted a query to the courier list (and also found another post asking the same thing) about the IMAP-before-SMTP problem, but did not get any answers. Digging back through my mailbox, I found this: To be a little more precise... Remove the line #undef HAVE_OPEN_SMTP_RELAY from authlib/preauthvchkpw.c and recompile Courier-IMAP. I have the authlib/preauthvchkpw.c file the line is different it is #ifdef HAVE_OPEN_SMTP_RELAY Any comment? Should the line be removed or uncomment? I am hearing different stories for the action. David Kwok
Re: [vchkpw] Working towards vpopmail 5.4 stable
rename domains. If I use vdeldomain on a alias will it remove the domain or just the alias domain. If it deletes the domain you should add a feature to remove aliases /R - Original Message - From: Ken Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 6:52 PM Subject: [vchkpw] Working towards vpopmail 5.4 stable Hi Folks, Does anyone have any code changes they would like to get into the next release? I want to put together a new stable version 5.4. Hopefully release it in the next few weeks. Currenly the only change I have is to management of maildirsize files. There are some cases when the quota is changed, the maildirsize file is not rebuild, just deleted. This causes sqwebmail to not see a quota usage until email is delivered to the account, or they pop in. Ken Jones
[vchkpw] mysql connection file location for vpopmail
I have installed Vpopmail with mysql support and i would like to know where is the mysql config stored for establishing the link. I want to change the password for mysql (vpopmail database). Can anyone help me. Regards S Arun __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
RE: [vchkpw] mysql connection file location for vpopmail
Yes, i have edited the file. But i would like to know where it's installed at the time of compile and installation. Regards --- Ross Davis - DataAnywhere [EMAIL PROTECTED] wrote: vmysql.h You must have edited it when you were setting up vpopmail. -Original Message- From: Suba Arunkumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 6:27 PM To: [EMAIL PROTECTED] Subject: [vchkpw] mysql connection file location for vpopmail I have installed Vpopmail with mysql support and i would like to know where is the mysql config stored for establishing the link. I want to change the password for mysql (vpopmail database). Can anyone help me. Regards S Arun __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
Re: [vchkpw] mysql connection file location for vpopmail
The settings you enter into vmysql.h are compiled into the vpopmail binaries when you run the make If you have altered the user/pass in mysql, then you should update the vmysql.h ( Then to be safe I would do a make clean, and re-run ./configure ) Then run make, make install-strip again Also you will need to recompile any other add-on programs that use the vpopmail authentication features (eg qmailadmin, courier-imap) Michael. - Original Message - From: Suba Arunkumar [EMAIL PROTECTED] To: Ross Davis - DataAnywhere [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 2:44 PM Subject: RE: [vchkpw] mysql connection file location for vpopmail Yes, i have edited the file. But i would like to know where it's installed at the time of compile and installation. Regards --- Ross Davis - DataAnywhere [EMAIL PROTECTED] wrote: vmysql.h You must have edited it when you were setting up vpopmail. -Original Message- From: Suba Arunkumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 6:27 PM To: [EMAIL PROTECTED] Subject: [vchkpw] mysql connection file location for vpopmail I have installed Vpopmail with mysql support and i would like to know where is the mysql config stored for establishing the link. I want to change the password for mysql (vpopmail database). Can anyone help me. Regards S Arun __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
Re: [vchkpw] Working towards vpopmail 5.4 stable
On Wednesday, June 4, 2003, at 03:48 PM, Raboo wrote: rename domains. If I use vdeldomain on a alias will it remove the domain or just the alias domain. If it deletes the domain you should add a feature to remove aliases It just removes the alias. Renaming a domain in vpopmail is a little more difficult -- you'd have to update all the Maildir references in the .qmail files, and make sure you update all of the mailing list files. -- Tom Collins [EMAIL PROTECTED]
[vchkpw] MySQL registration from vpopmail
Hi, I have a problem about (qmail + vpopmail + MySQL) system. My system is qmail + vpopmail + qmailadmin + MySQL. Q1.) I want to register MySQL tables of vpopmail database. I performed the following command. ---command start groupadd mysql mkdir -p /usr/local/mysql/var useradd -g mysql -d /usr/local/mysql/var mysql cd /usr/local/src ftp http://www.softagency.co.jp/MySQL/Downloads/MySQL-4.0/mysql-4.0.13.tar.gz tar -xzf mysql-4.0.13.tar.gz rm -f mysql-4.0.13.tar.gz cd mysql-4.0.13 ./configure --prefix=/usr/local/mysql --with-charset=ujis -with-extra-charsets=all --with-mysqld-user=mysql make make install /usr/local/mysql/bin/mysql_install_db --user=mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql/var /usr/local/mysql/bin/mysqld_safe --user=mysql /usr/local/mysql/bin/mysqlshow +---+ | Databases | +---+ | mysql | | test | +---+ cd /usr/local/src/vpopmail-5.2.1 ./configure --enable-roaming-users=y --enable-mysql=y --enable-incdir=/usr/local/mysql/include/mysql --enable-libdir=/usr/local/mysql/lib/mysql --enable-sqlincdir=/usr/local/mysql/include/mysql --enable-sqllibdir=/usr/local/mysql/lib/mysql make make install-strip /usr/local/mysql/bin/mysqladmin create vpopmail /usr/local/mysql/bin/mysql mysql grant select,insert,update,delete,create on vpopmail.* to [EMAIL PROTECTED] identified by 'password'; Query OK, 0 rows affected (0.00 sec) mysql exit /usr/local/mysql/bin/mysqlshow +---+ | Databases | +---+ | mysql | | test | | vpopmail | +---+ qmail starting. /home/vpopmail/bin/vadddomain good.for.com qmail restarting. setenv LD_LIBRARY_PATH /usr/local/mysql/lib/mysql /home/vpopmail/bin/vconvert -c -m Add user "[EMAIL PROTECTED]" through qmailadmin. /usr/local/mysql/bin/mysqlshow vpopmail Database: vpopmail ++ | Tables | ++ ++ ---command finish I created virtual domain(example. good.for.com) to vpopmail. At this time, I think that Automatically Something tables of vpopmail is created in the MySQL. Is my thinking mistake? Do I have to add manually tables of vpopmail to MySQL. Thank you in advance. Yasuyuki Toyoda.
[vchkpw] Problems with various emailings showing hours late
Hello all,I am running Qmail+Vpopmail+QmailScanner w/FprotI have a few hundred domains on this server. A few people have complainedof receiving mail hours, and sometimes days after the mailing was sent.This problem is Internet--local as well as local--local. There doesn'tseem to be any consistency and its not due to large mailings as most that Ihave investigated are small mailings.Does anyone have any insight into this?Thank you,Bfons
[vchkpw] could not connect to mysql update server Access denied for user
Hello All, I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail with SquirrelMail 1.0.4. I compiled vpopmail and used the following settings for mysql. /usr/sbin/groupadd -g 89 vchkpw /usr/sbin/useradd -g vchkpw -u 89 vpopmail GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; pico vmysql.h /* Edit to match your set up #define MYSQL_UPDATE_SERVER localhost #define MYSQL_UPDATE_USER vpopuser #define MYSQL_UPDATE_PASSWD vpoppass */ #define MYSQL_READ_SERVER localhost #define MYSQL_READ_USER vpopuser #define MYSQL_READ_PASSWD vpoppass /* End of setup section*/ /* defaults - no need to change */ #define MYSQL_VPORT 3306 #define MYSQL_DEFAULT_TABLE vpopmail #define MYSQL_DATABASE vpopmail #define MYSQL_DOT_CHAR '_' #define MYSQL_LARGE_USERS_TABLE users here are my Configure options ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l imits=n make make install-strip The above process works just fine. and even i have checked my mysql user and pass this is also fine. But after compiling my database vpopmail remains empty (without any table) Why ? when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass it gives an error : could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Why does it takes root if i am using vpopuser for the mysql connection. Please put on the correct path as i have googled a lot and also search but could not found any info that will help me in this context. Regards, Tina.