Re: [vchkpw] Aliases not working with maildrop & spamassassin?
On Thu, 5 Jun 2003 04:39:56 -0400 Jasper Metselaar <[EMAIL PROTECTED]> wrote: > Hi, > > I have a real [EMAIL PROTECTED] which is tagged for spam checking. The > .qmail-default contains > > | /usr/local/bin/maildrop > > 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 > > ___ > > > it is actually very simple, /mydomain/user/Maildir/ is a delivery statement, you are telling it to deliver to that mailbox, that's what is says. if you don't want the mail to be delivered to that box, don't put a delivery statement in the .qmail. if you put "| /path/to/maildrop ..." you'd be telling it to run maildrop if you put "&[EMAIL PROTECTED]" you'd be telling it to redeliver the message as though it was for user, at which point it would go through the process of reading .qmail files for user read http://www.qmail.org/man/man5/dot-qmail.html, it explains it all.
Re: [vchkpw] Aliases not working with maildrop & spamassassin?
Hi, You want to use forwards instead of aliases to get around that. Ie you want &[EMAIL PROTECTED] in the .qmail-test not /home/vpopmail/domains/domain.com/someguy/Maildir/ Doing it that way, it gets re-submitted and scanned by the .qmail-default Regards, Rick Alan Murrell wrote: Hi Jaspar, is sent to [EMAIL PROTECTED], qmail just dumps it directly into user's mailbox,completely out of the spam checking task. My understanding is that when delivering mail, vpopmail looks for these files in the following order: ~vpopmail/domains/domain.com/.qmail-user ~vpopmail/domains/domain.com/user/.qmail ~vpopmail/domains/domain.com/.qmail/default It will process according to the first one it comes across, then stop further checking. So what is happening in your situation, is the .qmail-test file is prcessed by delivering the mail to "user", and then no further processing is done (i.e., it does not then process the mail through the recipient's .qmail* files). As such, Aliases and Forwards will not be processed by spamd. I am not sure why this was done this way, but that the way it is. If I was a coder, I would prolly see if I could change that behaviour myself :-) HTH, Alan Murrell <[EMAIL PROTECTED]> __ Post your free ad now! http://personals.yahoo.ca
Re: [vchkpw] Aliases not working with maildrop & spamassassin?
Hi Jaspar, > is sent to [EMAIL PROTECTED], qmail just dumps it > directly into user's mailbox,completely out of the > spam checking task. My understanding is that when delivering mail, vpopmail looks for these files in the following order: ~vpopmail/domains/domain.com/.qmail-user ~vpopmail/domains/domain.com/user/.qmail ~vpopmail/domains/domain.com/.qmail/default It will process according to the first one it comes across, then stop further checking. So what is happening in your situation, is the .qmail-test file is prcessed by delivering the mail to "user", and then no further processing is done (i.e., it does not then process the mail through the recipient's .qmail* files). As such, Aliases and Forwards will not be processed by spamd. I am not sure why this was done this way, but that the way it is. If I was a coder, I would prolly see if I could change that behaviour myself :-) HTH, Alan Murrell <[EMAIL PROTECTED]> __ Post your free ad now! http://personals.yahoo.ca
Re: [vchkpw] imail users to qmail
I have done a migration from imail a year or so ago. I have created a script and I used the learn password feature worked like a charm -- 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: "Gerhard Just Olsen" <[EMAIL PROTECTED]> > Date: Thu, 5 Jun 2003 14:31:01 +0200 > To: <[EMAIL PROTECTED]> > Subject: [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] qmail-smtpd-chkusr Patch Problem
On Fri, 2003-06-06 at 01:39, 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. They need som changes, see below. > > I have managed to get it working by altering the -u and -g on the tcpserver > command line to be root. Don't! > When I do that it works flawlessly. It also works > if I set the uid to root and set the gid to qmaild. Don't! > My question (and I suppose directed at tonix): > > How can I get this to run with the proper user and group permissions of > qmaild? Read this carefully and you are set. http://www.interazioni.it/qmail/#Installation > 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 # Get rid of this four lines > ##QMAILUID=0 > ###NOFILESGID=0 > ##QMAILUID=`/usr/bin/id -u qmaild` > ##NOFILESGID=`/usr/bin/id -g qmaild` # Use these ones instead to be able to access the vopmail databases. # Run as the uid and gid of the vpopmail user. QMAILUID=`/usr/bin/id -u vpopmail` NOFILESGID=`/usr/bin/id -g vpopmail` > 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 2>&1 > > permissions on qmail-smtpd: > -rwxr-xr-x 1 rootqmail 128528 Jun 5 16:26 qmail-smtpd chown 6555 /var/qmail/bin/qmail-smtpd > I am assuming it has something to do with the setuid that the patch does, > but I am unsure. > > Any pointers? follow the comments above and you should be set. > Tom Walsh > Network Admin > http://www.ala.net/ > -- Lars Gustafson <[EMAIL PROTECTED]> i3 micro technology ab
Re: [vchkpw] Vpopmail/courier-imap with ldap
Zitat von Michel Gallant <[EMAIL PROTECTED]>: > I'm running vpopmail with a cdb backend and courier-imap with the > authvchkpw module. I was wondering if many people are using the ldap > backend. I was also wondering if it's possible to use ldap for certain > domains, and cdb for others. The reason I'm asking is that I have a > samba domain running for internal users, and right now their passwords > are not synced with vpopmails. I would like to run ldap for our domain, > and run cdb for domains that we host. Is this possible? If so, are > there any docs that could get me started? Thanks Hi, yes it should be possible, but I didnt test it. But let me show you my imaginations: Because when you configure vpopmail you will have to choose wether to use LDAP or mysql as an authe´mtification module which end up that vauth.[ch] is linked/renamed to vldap.[ch] bzw. vmysql.[ch] The advantage is that each authentification modules uses the same API, so only the backend is changed, the disadvantage is that you cannot use both. But it should work compiling 2 times vpopmail-mail, each with a different installation dir. See my example: /home/vpopmail-ldap/domains/xyz /home/vpopmail-mysql/domains/abc so adding a domain to ldap yould use: /home/vpopmail-ldap/bin/vaddomain 123.de and vice versa. I am not 100 % sure, but this seems possible to me. You may try ;-) Cheers Jens
[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] MySQL registration from vpopmail
Hello Eduardo. (B (B> only change de user and password, before make and makeinstall. (B> (B> attacch the file with dump vpopmail database. (B (BI understood your advice. (BI have already challenged your correct procesure. (BBut now(6/6/2003 14:24), vpopmail don't have still run properly. (BThank you for your advice. (B (B> P.D : where are you? in Korea or japon, or near there. i live in costa (B> rica, but a im colombian. (B (BI'm Japanese. (BI live in Tokyo. (BI think that your mail-server or client PC clock is out of true. (BI recommend NetworkTimeProtcol SERVER. (BSee you. (B (B (BEduardo Garcia wrote: (B> Hello Toyoda. (B> (B> (B> you are a one big problem. (B> (B> before made a comand make, do you have modify file vmysql.h. (B> (B> in this file chahge de user and pass of user, this is my vmysql.h. see (B> (B> * Edit to match your set up */ (B> #define MYSQL_UPDATE_SERVER "localhost" (B> #define MYSQL_UPDATE_USER "root" (B> #define MYSQL_UPDATE_PASSWD "cow" (B> (B> #define MYSQL_READ_SERVER "localhost" (B> #define MYSQL_READ_USER "root" (B> #define MYSQL_READ_PASSWD "cow" (B> (B> (B> only change de user and password, before make and makeinstall. (B> (B> attacch the file with dump vpopmail database. (B> (B> see you later. (B> (B> enzo (B> Eduardo Garcia. (B> (B> P.D : where are you? in Korea or japon, or near there. i live in costa (B> rica, but a im colombian. (B> (B> (B> (B> (B> Toyoda Yasuyuki wrote: (B> (B> (B>>Hi, (B>>I have a problem about (qmail + vpopmail + MySQL) system. (B>>My system is qmail + vpopmail + qmailadmin + MySQL. (B>> (B>>Q1.) (B>>I want to register MySQL tables of vpopmail database. (B>>I performed the following command. (B>> (B>>---command start (B>>groupadd mysql (B>>mkdir -p /usr/local/mysql/var (B>>useradd -g mysql -d /usr/local/mysql/var mysql (B>>cd /usr/local/src (B>>ftp (B>>http://www.softagency.co.jp/MySQL/Downloads/MySQL-4.0/mysql-4.0.13.tar.gz (B>>tar -xzf mysql-4.0.13.tar.gz (B>>rm -f mysql-4.0.13.tar.gz (B>>cd mysql-4.0.13 (B>>./configure --prefix=/usr/local/mysql --with-charset=ujis (B>>-with-extra-charsets=all --with-mysqld-user=mysql (B>>make (B>>make install (B>> (B>>/usr/local/mysql/bin/mysql_install_db --user=mysql (B>>chown -R mysql /usr/local/mysql/var (B>>chgrp -R mysql /usr/local/mysql/var (B>>/usr/local/mysql/bin/mysqld_safe --user=mysql & (B>>/usr/local/mysql/bin/mysqlshow (B>> (B>>+---+ (B>>| Databases | (B>>+---+ (B>>| mysql | (B>>| test | (B>>+---+ (B>> (B>>cd /usr/local/src/vpopmail-5.2.1 (B>>./configure --enable-roaming-users=y --enable-mysql=y (B>>--enable-incdir=/usr/local/mysql/include/mysql (B>>--enable-libdir=/usr/local/mysql/lib/mysql (B>>--enable-sqlincdir=/usr/local/mysql/include/mysql (B>>--enable-sqllibdir=/usr/local/mysql/lib/mysql (B>>make (B>>make install-strip (B>>/usr/local/mysql/bin/mysqladmin create vpopmail (B>>/usr/local/mysql/bin/mysql (B>>mysql > grant select,insert,update,delete,create on vpopmail.* to (B>>[EMAIL PROTECTED] identified by 'password'; (B>> (B>>Query OK, 0 rows affected (0.00 sec) (B>> (B>>mysql > exit (B>> (B>>/usr/local/mysql/bin/mysqlshow (B>> (B>>+---+ (B>>| Databases | (B>>+---+ (B>>| mysql | (B>>| test | (B>>| vpopmail | (B>>+---+ (B>> (B>>qmail starting. (B>> (B>>/home/vpopmail/bin/vadddomain good.for.com (B>> (B>>qmail restarting. (B>> (B>>setenv LD_LIBRARY_PATH /usr/local/mysql/lib/mysql (B>>/home/vpopmail/bin/vconvert -c -m (B>> (B>>Add user "[EMAIL PROTECTED]" through qmailadmin. (B>> (B>>/usr/local/mysql/bin/mysqlshow vpopmail (B>>Database: vpopmail (B>>++ (B>>| Tables | (B>>++ (B>>++ (B>> (B>>---command finish (B>>I created virtual domain(example. good.for.com) to vpopmail. (B>>At this time, I think that Automatically Something tables of vpopmail (B>>is created in the MySQL. (B>>Is my thinking mistake? (B>>Do I have to add manually tables of vpopmail to MySQL. (B>> (B>>Thank you in advance. (B>> (B>>Yasuyuki Toyoda. (B>> (B>> (B>> (B>> (B>> (B>> (B>> (B> (B> (B> (B> (B> (B> # MySQL dump 8.14 (B> # (B> # Host: localhostDatabase: vpopmail (B> # (B> # Server version 3.23.41 (B> (B> # (B> # Table structure for table 'dir_control' (B> # (B> (B> CREATE TABLE dir_control ( (B> domain char(64) NOT NULL default '', (B> cur_users int(11) default NULL, (B> level_cur int(11) default NULL, (B> level_max int(11) default NULL, (B> level_start0 int(11) default NULL, (B> level_start1 int(11) default NULL, (B> level_start2 int(11) default NULL, (B> level_end0 int(11) default NULL, (B> level_end1 int(11) default NULL, (B> le
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 2>&1 >> >> 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
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 2>&1 > > 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
Run it with the vpopmail user/group permissions instead of root. I use "-u vpopmail -g vchkpw". You need to change the permissions so it can poke around in the vpopmail domains, and qmaild doesn't have permissions to do that. --Doug - Original Message - From: "Tom Walsh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 4:39 PM 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 2>&1 > > 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/ > > > >
[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] 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]
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.
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
> 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.
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
> > 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.
[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 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 ? 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 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 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 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
> 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
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. > > > > >
[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.
[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] MySQL registration from vpopmail
Hi, (BI have a problem about (qmail + vpopmail + MySQL) system. (BMy system is qmail + vpopmail + qmailadmin + MySQL. (B (BQ1.) (BI want to register MySQL tables of vpopmail database. (BI performed the following command. (B (B---command start (Bgroupadd mysql (Bmkdir -p /usr/local/mysql/var (Buseradd -g mysql -d /usr/local/mysql/var mysql (Bcd /usr/local/src (Bftp (Bhttp://www.softagency.co.jp/MySQL/Downloads/MySQL-4.0/mysql-4.0.13.tar.gz (Btar -xzf mysql-4.0.13.tar.gz (Brm -f mysql-4.0.13.tar.gz (Bcd mysql-4.0.13 (B./configure --prefix=/usr/local/mysql --with-charset=ujis (B-with-extra-charsets=all --with-mysqld-user=mysql (Bmake (Bmake install (B (B/usr/local/mysql/bin/mysql_install_db --user=mysql (Bchown -R mysql /usr/local/mysql/var (Bchgrp -R mysql /usr/local/mysql/var (B/usr/local/mysql/bin/mysqld_safe --user=mysql & (B/usr/local/mysql/bin/mysqlshow (B (B+---+ (B| Databases | (B+---+ (B| mysql | (B| test | (B+---+ (B (Bcd /usr/local/src/vpopmail-5.2.1 (B./configure --enable-roaming-users=y --enable-mysql=y (B--enable-incdir=/usr/local/mysql/include/mysql (B--enable-libdir=/usr/local/mysql/lib/mysql (B--enable-sqlincdir=/usr/local/mysql/include/mysql (B--enable-sqllibdir=/usr/local/mysql/lib/mysql (Bmake (Bmake install-strip (B/usr/local/mysql/bin/mysqladmin create vpopmail (B/usr/local/mysql/bin/mysql (Bmysql > grant select,insert,update,delete,create on vpopmail.* to (B[EMAIL PROTECTED] identified by 'password'; (B (BQuery OK, 0 rows affected (0.00 sec) (B (Bmysql > exit (B (B/usr/local/mysql/bin/mysqlshow (B (B+---+ (B| Databases | (B+---+ (B| mysql | (B| test | (B| vpopmail | (B+---+ (B (Bqmail starting. (B (B/home/vpopmail/bin/vadddomain good.for.com (B (Bqmail restarting. (B (Bsetenv LD_LIBRARY_PATH /usr/local/mysql/lib/mysql (B/home/vpopmail/bin/vconvert -c -m (B (BAdd user "[EMAIL PROTECTED]" through qmailadmin. (B (B/usr/local/mysql/bin/mysqlshow vpopmail (BDatabase: vpopmail (B++ (B| Tables | (B++ (B++ (B (B---command finish (BI created virtual domain(example. good.for.com) to vpopmail. (BAt this time, I think that Automatically Something tables of vpopmail (Bis created in the MySQL. (BIs my thinking mistake? (BDo I have to add manually tables of vpopmail to MySQL. (B (BThank you in advance. (B (BYasuyuki Toyoda.
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]
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] 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
[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] 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 > > > >
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] 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] 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] 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] 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] 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] 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] 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 > > > > > > > > >
[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] 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.
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
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] 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] 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 > > >
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] 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
[vchkpw] this is a test
sorry but this test. but tha last email dont send. enzo.
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] 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
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
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 confess I'm in the same boat as Jeff. I actually had some trouble with 5.3-something version when I did my install, so I went with 5.2.1. I haven't made any customizations to any code other than what is described here: http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm Thanks, D. 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
RE: [vchkpw] Working towards vpopmail 5.4 stable
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 > >
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
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] Working towards vpopmail 5.4 stable
On Wednesday, June 4, 2003, at 06:46 AM, matthew berardi wrote: 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 That's a good option for non-cdb setups. Perhaps the maildir_to_email() function could be a part of the "backend" .c file that gets compiled in (e.g., cdb, mysql, etc.). -- Tom Collins [EMAIL PROTECTED]
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]
[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] 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
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 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