Re: [vchkpw] Big site setup.
* Brad Dameron [EMAIL PROTECTED] [020924 19:40]: Actually the big site setup is the mysql portion. It changes the table structure for sites that have large amounts of users, not large amounts of sites. It should start putting the sites into seperate inode style directories. So after the first 200 or so domains it should create a 0 directory then stick the next 200 or so, then create a 1 directory and do the same. That way there is not more than so many domains per directory. This is done because of the Linux FS starts to bottleneck when a certain directory/file tree get's to large. Thanks, I have not found any info about this feature in the docs. (maybee missed it, will check again) I'm running vpopmail v4.9 and want to enable this feature when I upgrade to v5.2.1. Will this be activated and used even if there is 10k+ domains already in /home/vpopmail/domains and/or is there any tool to convert the existing domains to big site setup? In the contrib/ directory there is a vreorg.c but is not compileable due to the missing safestring.h in the distribution. -- .Fredrik Steen - http://www.stone.nu/ -
Re: [vchkpw] Vpopmail + Mysql. Tables not created?
The ./configure options for vpopmail are as follow.. ./configure --enable-roaming-users=y --enable-logging=y \ --enable-defaultquota=150 --enable-ip-alias-domains=y \ --enable-mysql=y --enable-sqllibdir=/usr/local/lib/mysql/ \ --enable-sqlincdir=/usr/local/include/mysql/ - Original Message - From: Clayton Weise [EMAIL PROTECTED] To: Gerald [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:45 AM Subject: RE: [vchkpw] Vpopmail + Mysql. Tables not created? Please paste your ./configure line for vpopmail. -Original Message- From: Gerald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Vpopmail + Mysql. Tables not created? Hi there I've compiled support for mysql in qmail and vpopmail. I've read README.mysql and went thru the guide at (http://matt.simerson.net/computing/qmail.toaster.shtml) However, when I add a virtual domain, a mysql table wasn't created, and instead, a .cdb file was produced. Why is that so? Programs which are installed on my system: qmail-1.03 vpopmail-5.2.1 mysql-server-3.23.52_1 FreeBSD 4.7-RC Help would be greatly appreciated, Thanks Gerald
RE: [vchkpw] more roaming user problems
Thanks for the reply Dave, I don't have a problem with sqwebmail. I guess I did a lousy job of describing this problem. Sqwebmail log in's work fine. The problem is now I've got some people who want to use their mail clients rather than the web interface - and when they do they can pick up mail from the pop server ok - but when they try to send mail they get an error message that says recipient not in allowed recpts hosts. Which I believe means that their IP is not being written into the tcp.smtp.cdb file to allow them to relay. So I'm thinking I missed a step here, but I don't see it in the docs or archives. Meanwhile I'll keep trying to tweak the smtp/run file and hope I can find the right combination! Regis On Tue, 2002-09-24 at 19:57, Dave Ellsworth wrote: Personally I'd probably try to reconfigure and recompile sqwebmail. I'm not sure if that'll solve the problem though. -Original Message- From: rm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 6:10 PM To: vchkpw mailing list Subject: [vchkpw] more roaming user problems After several months of getting by with sqwebmail for remote users, we've decided to add the enable roaming users option. It seemed simple enough in reading the docs and the archive messages on this subject. But I seem to have missed something. My configure line is: ./configure --enable-roaming-user=y --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp --enable-relay-clear-minutes=60 --enable-mysql-logging=y --enable-clear-passwd=y --enable-incdir=/usr/include --enable-libdir=/usr/lib --enable-mysql=y --enable-mysql-replication=y --enable-valias=y I modified the smtp run file to use the correct path to /home/vpopmail/etc/tcp.smtp - originally I used the life with qmail example - so the modified file looks like this: #!/bin/sh QMAILDUID=`id -u qmaild` NOFILESGID=`id -g qmaild` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $QMAILDUID -o -z $NOFILESGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo QMAILDUID, NOFILESGID, MAXSMTPD, or LOCAL is unset in echo /var/qmail/supervise/qmail-smtpd/run exit 1 fi exec /usr/local/bin/softlimit -m 400 \ /usr/local/bin/tcpserver -v -R -l $LOCAL -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $QMAILDUID -g $NOFILESGID 0 smtp /var/qmail/bin/qmail-smtpd 21 I copied the tcp.smtp and the tcp.smtp.cdb file from /etc into /home/vpopmail/etc I also tried to add /dev/null at the end of the smtp run file, as shown in the FAQ example; but when I add that - the smtp server won't start. In any event - remote logins keep getting the error message recipient not in allowed rcpt hosts when they try to send mail. Any ideas on what I've missed here? Thanks, Regis
Re: [vchkpw] Vpopmail + Mysql. Tables not created?
Hi Gerald, Just a couple of observations - maybe it will help... Your configure line says --enable-sqllibdir=... and --enable-sqlincdir= I don't see those as available configure options when I do ./configure --help in vpopmail5.2.1. I see --enable-libdir; --enable-incdir; and --enable-libs. That may be part of the problem. Also, I've found when I've compiled it on Redhat7.1 I had to truncate the path to the mysql libraries prior to /mysql. I don't know if that would work the same way in BSD. What I mean is my mysql libraries are in /usr/lib/mysql - but when I configured with --enable-libdir=/usr/lib/mysql ; it didn't work - but when I configured with --enable-libdir=/usr/lib ; it worked like a charm. Hope that helps a bit, Regis On Wed, 2002-09-25 at 02:29, Gerald wrote: The ./configure options for vpopmail are as follow.. ./configure --enable-roaming-users=y --enable-logging=y \ --enable-defaultquota=150 --enable-ip-alias-domains=y \ --enable-mysql=y --enable-sqllibdir=/usr/local/lib/mysql/ \ --enable-sqlincdir=/usr/local/include/mysql/ - Original Message - From: Clayton Weise [EMAIL PROTECTED] To: Gerald [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:45 AM Subject: RE: [vchkpw] Vpopmail + Mysql. Tables not created? Please paste your ./configure line for vpopmail. -Original Message- From: Gerald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Vpopmail + Mysql. Tables not created? Hi there I've compiled support for mysql in qmail and vpopmail. I've read README.mysql and went thru the guide at (http://matt.simerson.net/computing/qmail.toaster.shtml) However, when I add a virtual domain, a mysql table wasn't created, and instead, a .cdb file was produced. Why is that so? Programs which are installed on my system: qmail-1.03 vpopmail-5.2.1 mysql-server-3.23.52_1 FreeBSD 4.7-RC Help would be greatly appreciated, Thanks Gerald
RE: [vchkpw] more roaming user problems
A couple things.. When you recompiled vpopmail with roaming user support, did you do it from fresh source code? e.g. source that you didn't alreay compile with different options. Hope that makes sense.. and two, did you try moving your /home/vpopmail/bin directory somehwere else before doing the make install-strip? Maybe some files didn't get overwritten. As far as the syntax in your smtpd/run file it looks fine. All you really need to do is start up tcpserver with -x /home/of/vpopmail/etc/tcp.smtp.cdb, which you've done. -Clayton -Original Message- From: rm [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 5:49 AM To: vchkpw mailing list Subject: RE: [vchkpw] more roaming user problems Thanks for the reply Dave, I don't have a problem with sqwebmail. I guess I did a lousy job of describing this problem. Sqwebmail log in's work fine. The problem is now I've got some people who want to use their mail clients rather than the web interface - and when they do they can pick up mail from the pop server ok - but when they try to send mail they get an error message that says recipient not in allowed recpts hosts. Which I believe means that their IP is not being written into the tcp.smtp.cdb file to allow them to relay. So I'm thinking I missed a step here, but I don't see it in the docs or archives. Meanwhile I'll keep trying to tweak the smtp/run file and hope I can find the right combination! Regis On Tue, 2002-09-24 at 19:57, Dave Ellsworth wrote: Personally I'd probably try to reconfigure and recompile sqwebmail. I'm not sure if that'll solve the problem though. -Original Message- From: rm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 6:10 PM To: vchkpw mailing list Subject: [vchkpw] more roaming user problems After several months of getting by with sqwebmail for remote users, we've decided to add the enable roaming users option. It seemed simple enough in reading the docs and the archive messages on this subject. But I seem to have missed something. My configure line is: ./configure --enable-roaming-user=y --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp --enable-relay-clear-minutes=60 --enable-mysql-logging=y --enable-clear-passwd=y --enable-incdir=/usr/include --enable-libdir=/usr/lib --enable-mysql=y --enable-mysql-replication=y --enable-valias=y I modified the smtp run file to use the correct path to /home/vpopmail/etc/tcp.smtp - originally I used the life with qmail example - so the modified file looks like this: #!/bin/sh QMAILDUID=`id -u qmaild` NOFILESGID=`id -g qmaild` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $QMAILDUID -o -z $NOFILESGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo QMAILDUID, NOFILESGID, MAXSMTPD, or LOCAL is unset in echo /var/qmail/supervise/qmail-smtpd/run exit 1 fi exec /usr/local/bin/softlimit -m 400 \ /usr/local/bin/tcpserver -v -R -l $LOCAL -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $QMAILDUID -g $NOFILESGID 0 smtp /var/qmail/bin/qmail-smtpd 21 I copied the tcp.smtp and the tcp.smtp.cdb file from /etc into /home/vpopmail/etc I also tried to add /dev/null at the end of the smtp run file, as shown in the FAQ example; but when I add that - the smtp server won't start. In any event - remote logins keep getting the error message recipient not in allowed rcpt hosts when they try to send mail. Any ideas on what I've missed here? Thanks, Regis
Re: [vchkpw] vpopmail vpasswd file difference(s) between 4.9.10 and 5.3.8
Hi Matt, On 2002.09.24_16:03:52_+, Matt Simerson wrote: Everything on the new system works just fine except the vconvert function. Can anyone verify that vconvert actually does work? Yes, it actually works. Below are the steps I have taken to come up with that statement: 1. Compile and install 5.3.8 with cdb. 2. Test create a domain (devel.dutnux.com) and some users. 3. Recompile with mysql support, install, using 5.3.8. 4. Invoke ./vconvert -c -m -v -d devel.dutnux.com version: 5.3.8 could not connect to mysql update server Unknown database 'vpopmail' with database converting devel.dutnux.com done 5. I checked mysql, it created vpopmail database and table for me. The vpopmail table contain exactly the user I created. Can you sanitize a copy of a newer vpasswd file and send it my way so I can compare it to my ancient system to see if the format is still the same? This is the first line of the vpasswd file I have. It was created using 5.3.8 with password learning support: postmaster:$1$R.O7J$cRKPnHXAkWuZ6epI94R.k/:1:0:Postmaster: /home/vpopmail/domains/devel.dutnux.com/postmaster:10M:dutnux Sorry for the wrapped line. Matt HTH -- H. D. Lee
RE: [vchkpw] more roaming user problems
Hi Clayton, Yeah, compiling from fresh source was one of the trouble shooting ideas I tried early on. Here's another observation. The mysql relay table does get updated with each new remote log in. But... it seems to be updating the table AFTER the new log in exits. I discovered this when suddenly all of the messages that had previously been refused by smtp - got sent immediately upon log in. That was because the remote log in was, by chance, issued the same IP as the previous log in. So... the IP was in the relay table from the previous login and the mail sent without a problem. Oddly, the IPs listed in my mysql relay table, which match the IP's in the smtp log files - do not match the IP's in the /tcp.smtp.cdb file. Not even the one IP that worked in the example above. Seems like something is fubar. Any other suggestions? Regis On Wed, 2002-09-25 at 09:56, Clayton Weise wrote: A couple things.. When you recompiled vpopmail with roaming user support, did you do it from fresh source code? e.g. source that you didn't alreay compile with different options. Hope that makes sense.. and two, did you try moving your /home/vpopmail/bin directory somehwere else before doing the make install-strip? Maybe some files didn't get overwritten. As far as the syntax in your smtpd/run file it looks fine. All you really need to do is start up tcpserver with -x /home/of/vpopmail/etc/tcp.smtp.cdb, which you've done. -Clayton -Original Message- From: rm [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 5:49 AM To: vchkpw mailing list Subject: RE: [vchkpw] more roaming user problems Thanks for the reply Dave, I don't have a problem with sqwebmail. I guess I did a lousy job of describing this problem. Sqwebmail log in's work fine. The problem is now I've got some people who want to use their mail clients rather than the web interface - and when they do they can pick up mail from the pop server ok - but when they try to send mail they get an error message that says recipient not in allowed recpts hosts. Which I believe means that their IP is not being written into the tcp.smtp.cdb file to allow them to relay. So I'm thinking I missed a step here, but I don't see it in the docs or archives. Meanwhile I'll keep trying to tweak the smtp/run file and hope I can find the right combination! Regis On Tue, 2002-09-24 at 19:57, Dave Ellsworth wrote: Personally I'd probably try to reconfigure and recompile sqwebmail. I'm not sure if that'll solve the problem though. -Original Message- From: rm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 6:10 PM To: vchkpw mailing list Subject: [vchkpw] more roaming user problems After several months of getting by with sqwebmail for remote users, we've decided to add the enable roaming users option. It seemed simple enough in reading the docs and the archive messages on this subject. But I seem to have missed something. My configure line is: ./configure --enable-roaming-user=y --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp --enable-relay-clear-minutes=60 --enable-mysql-logging=y --enable-clear-passwd=y --enable-incdir=/usr/include --enable-libdir=/usr/lib --enable-mysql=y --enable-mysql-replication=y --enable-valias=y I modified the smtp run file to use the correct path to /home/vpopmail/etc/tcp.smtp - originally I used the life with qmail example - so the modified file looks like this: #!/bin/sh QMAILDUID=`id -u qmaild` NOFILESGID=`id -g qmaild` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $QMAILDUID -o -z $NOFILESGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo QMAILDUID, NOFILESGID, MAXSMTPD, or LOCAL is unset in echo /var/qmail/supervise/qmail-smtpd/run exit 1 fi exec /usr/local/bin/softlimit -m 400 \ /usr/local/bin/tcpserver -v -R -l $LOCAL -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $QMAILDUID -g $NOFILESGID 0 smtp /var/qmail/bin/qmail-smtpd 21 I copied the tcp.smtp and the tcp.smtp.cdb file from /etc into /home/vpopmail/etc I also tried to add /dev/null at the end of the smtp run file, as shown in the FAQ example; but when I add that - the smtp server won't start. In any event - remote logins keep getting the error message recipient not in allowed rcpt hosts when they try to send mail. Any ideas on what I've missed here? Thanks, Regis
Re: [vchkpw] vpopmail vpasswd file difference(s) between 4.9.10 and 5.3.8
That was it, thanks HD. Upon comparing his vpasswd file and mine, there's an extra field in the vpasswd file for the clear text password. If I merely add another colon to the end of each line in the vpasswd file, vconvert works just fine. I'd suggest updating the vconvert program so that it does not require the clear text password field to be present in order to function properly. That will make legacy installs much easier to upgrade. Lastly, I'm not entirely certain *why* running vconvert against my older vpasswd file deleted all mysql entries in the vpopmail table but it's not a safe behavior. Maybe it just removes all entries that match the domain before importing and then does the import. It would be a really good idea to verify that there's some new data capable of being inserted before deleting the old entries. Matt On Wednesday, September 25, 2002, at 11:18 AM, H. D. Lee wrote: Hi Matt, On 2002.09.24_16:03:52_+, Matt Simerson wrote: Everything on the new system works just fine except the vconvert function. Can anyone verify that vconvert actually does work? Yes, it actually works. Below are the steps I have taken to come up with that statement: 1. Compile and install 5.3.8 with cdb. 2. Test create a domain (devel.dutnux.com) and some users. 3. Recompile with mysql support, install, using 5.3.8. 4. Invoke ./vconvert -c -m -v -d devel.dutnux.com version: 5.3.8 could not connect to mysql update server Unknown database 'vpopmail' with database converting devel.dutnux.com done 5. I checked mysql, it created vpopmail database and table for me. The vpopmail table contain exactly the user I created. Can you sanitize a copy of a newer vpasswd file and send it my way so I can compare it to my ancient system to see if the format is still the same? This is the first line of the vpasswd file I have. It was created using 5.3.8 with password learning support: postmaster:$1$R.O7J$cRKPnHXAkWuZ6epI94R.k/:1:0:Postmaster: /home/vpopmail/domains/devel.dutnux.com/postmaster:10M:dutnux Sorry for the wrapped line. Matt HTH -- H. D. Lee
[vchkpw] *cross post* qmail aliases and mailfiltering
Hi all,
sent this to the maildrop list as well, but thought the people here may
be a good source to ask too :)
What I am trying to do is get aliased accounts filtered, ie, mail sent
to an alias, which goes to the real user gets caught by maildrop, so
that it can be collated properly. The .qmail-alias_user only re-directs
the mail to the users Maildir, doesnt seem to allow it to be handled by
either vdeliver, or maildrop (cause it doesnt seem to be re-placed in
the queue.. just physically moved)
This one is puzzling me a bit, and is probably not too hard, but a
search of the archives on both the vpopmail list and the maildrop and
didnt seem to
show a solution for me.
Setup - qmail, vpopmail, maildrop (all working, individual .mailfilter
files, also working)
I have various aliases created, which create the appropriate
~vpopmail/domains/some.domain/.qmail-alias_user file, something like
this
content of .qmail-alias_user
/home/vpopmail/domains/some.domain/real_user/Maildir/
this works 'properly' in that it ends up placed in the 'real' users
Maildir.
However I also have an entry in the 'real' users mailfilter, that should
take mail being sent to this alias, and re-direct it to a folder for
easy collation... something like this
~vpopmail/domains/some.domain/real_user/.mailfilter looks something like
this:
###
#header - To:
#match - [EMAIL PROTECTED]
#delivery - to - alias_user (the folder I want it to end up in)
exception {
if (/^To: *alias_user@some\.domain$/)
{
to $VHOME/Maildir/.alias_user/
}
}
(should move any mail received that was sent to alias_user to the folder
I have to collect it all)
This file is included into a domain wide mailfilter (used for SPAM
stuff) and the format works.
However, this one, even though the To IS [EMAIL PROTECTED] still
ends up in the real_user INBOX.
I would guess (have been reading tho I am not sure bout this) that it
may be because the .qmail-alias_user hasnt got anything in it to allow
it to be handled by maildrop, and isn't placed back for vdeliver to
process, just moved to the Maildir/ of the real user.
I was wondering what I would need to do to the .qmail-alias (if that is
the right place), to re-process it perhaps so that the real users
.mailfilter catches it out of the queue, either that, or if anyone has
done this sort of thing, if you could give me a few pointers on how you
did it, it would be really appreciated.
Thanks heaps
David
(learnin more every day)
[vchkpw] Re: more roaming user problems
Regis; I am having the same problem as you, only that I use courier-imap's pop3-ssl... I included the following lines in my vpopmail configuration: --enable-roaming-user=y --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp --enable-relay-clear-minutes=60 I run qmail-smtpd with the following line (from lifewithqmail but with the path to tcp.smtp modified: exec /usr/local/bin/softlimit -m 400 /usr/local/bin/tcpserver -v -R -l 0 -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD -u $QMAILUID -g $NOFILESGID 0 smtp /home/qmail/bin/qmail-smtpd 21 I have the following files in /home/vpopmail/etc: -rw-rw-r--1 vpopmail vchkpw 83 Sep 25 19:13 tcp.smtp -rw-rw-r--1 vpopmail vchkpw 2179 Sep 25 22:40 tcp.smtp.cdb ...and I still only relay when I manually modify the tcp.smtp! I am lost, please... if anyone has ideas about this I will be very grateful =/ Thank you... Miguel rm escribió: After several months of getting by with sqwebmail for remote users, we've decided to add the enable roaming users option. It seemed simple enough in reading the docs and the archive messages on this subject. But I seem to have missed something. My configure line is: ./configure --enable-roaming-user=y --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp --enable-relay-clear-minutes=60 --enable-mysql-logging=y --enable-clear-passwd=y --enable-incdir=/usr/include --enable-libdir=/usr/lib --enable-mysql=y --enable-mysql-replication=y --enable-valias=y I modified the smtp run file to use the correct path to /home/vpopmail/etc/tcp.smtp - originally I used the life with qmail example - so the modified file looks like this: #!/bin/sh QMAILDUID=`id -u qmaild` NOFILESGID=`id -g qmaild` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $QMAILDUID -o -z $NOFILESGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo QMAILDUID, NOFILESGID, MAXSMTPD, or LOCAL is unset in echo /var/qmail/supervise/qmail-smtpd/run exit 1 fi exec /usr/local/bin/softlimit -m 400 \ /usr/local/bin/tcpserver -v -R -l $LOCAL -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $QMAILDUID -g $NOFILESGID 0 smtp /var/qmail/bin/qmail-smtpd 21 I copied the tcp.smtp and the tcp.smtp.cdb file from /etc into /home/vpopmail/etc I also tried to add /dev/null at the end of the smtp run file, as shown in the FAQ example; but when I add that - the smtp server won't start. In any event - remote logins keep getting the error message recipient not in allowed rcpt hosts when they try to send mail. Any ideas on what I've missed here? Thanks, Regis
