RE:(SOLUTION!!) Once again: vpopmail & relaying with mysql (HELP PLEASE!!!)
Hi all, only to let you know, that the problem came from tcprules (ucspi-tcp-0.88) and not from vpopmail!. Worked fine before! Compiling it again and again, resulting in a tcprules-file with 0 bytes! I don´t know why. After, at least, compiling the old tcpcontrol-0.50, and copying the resulting tcpmakectl to /usr/local/bin/tcprules, it is working fine! Thank you all for your help, special thanks to Chris for the links Have a nice day Bernardo -Ursprüngliche Nachricht- Von: Bernd Vetter [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 6. Juli 2001 13:20 An: Vchkpw-list Betreff: Once again: vpopmail & relaying with mysql (HELP PLEASE!!!) Hi all, after getting no response at all, this is my second try. I have up and running a supervised (daemontools, tcpserver) qmail-1.03 with MySQL, vpopmail-4.9.8-1, sqwebmail-2.0.0 and qmailadmin-0.45, followed exactly LWQ. I read all the FAQs and all List-archives, but my problem persists. Compiling vpopmail with "--enable-roaming-users=n", all is working fine, but, logically, without relaying. Compiling vpopmail with "--enable-roaming-users=y" leads to a stucking qmail-pop3d (CPU >80%), after a client has tried to access his account, while vchkpw logs success. This is my qmail-pop3d run script: #!/bin/sh exec /usr/local/bin/softlimit -m 200 \ /usr/local/bin/tcpserver -v -R -H -l 0 0 110 /var/qmail/bin/qmail-popup \ FQDN /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 2>&1 I think, this means, the two first of the three invoked modules, qmail-popup and vchkpw are working fine, but the third invoked process, qmail-pop3d, stucks. The reason for this, I suppose, is that there is no open-smtp.cdb created. /clearopensmtp also stucks. But I´ve noticed, that the client-IP appears in the "vpopmail" db in the table "relay", but never get pushed to "/home/vpopmail/etc/open-smtp.cdb". So parts of it seems to work. What is wrong, what am I missing, or better, what is the responsible part of this missing step above. May be, this is a database layout problem, too? Is there a link to a correct mysqldump.db for vpopmail? In the FAQ, i found a tcpserver-mysql-patch, which should let the tcpserver access the mysql-db directly, without compiling any *.cdb. Anyone can point me to the missing link for this patch? Greetings Bernardo Virengeprüft vom G DATA AntiVirenKit Virengeprüft vom G DATA AntiVirenKit
Re: Once again: vpopmail & relaying with mysql (HELP PLEASE!!!)
Hi Bernd, Bernd Vetter wrote: > > Hi all, > > after getting no response at all, this is my second try. > I have up and running a supervised (daemontools, tcpserver) qmail-1.03 with > MySQL, vpopmail-4.9.8-1, sqwebmail-2.0.0 and qmailadmin-0.45, followed > exactly LWQ. I read all the FAQs and all List-archives, but my problem > persists. > Compiling vpopmail with "--enable-roaming-users=n", all is working fine, > but, logically, without relaying. > Compiling vpopmail with "--enable-roaming-users=y" leads to a stucking > qmail-pop3d (CPU >80%), after a client has tried to access his account, > while vchkpw logs success. This is my qmail-pop3d run script: Could be vchkpw trying to compile the tcp.smtp.cdb file. Depends on how many ips are in the system. Are you runnin clearopensmtp in your crontab to clear out old IP's? > > #!/bin/sh > exec /usr/local/bin/softlimit -m 200 \ > /usr/local/bin/tcpserver -v -R -H -l 0 0 110 > /var/qmail/bin/qmail-popup \ > FQDN /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d > Maildir 2>&1 > > I think, this means, the two first of the three invoked modules, qmail-popup > and vchkpw are working fine, but the third invoked process, qmail-pop3d, > stucks. Maybe not. > The reason for this, I suppose, is that there is no open-smtp.cdb created. > ./clearopensmtp also stucks. Oh good, you are running it. If clearopensmtp takes a long time to run, it probably means you have alot of IPs. Check the relay_table in mysql and see how many entries you have there. > But I´ve noticed, that the client-IP appears in the "vpopmail" db in the > table "relay", but never get pushed to "/home/vpopmail/etc/open-smtp.cdb". There is no open-smtp.cdb file. You don't even need an open-smtp file. open-smtp file is used in the vcdb module, that's where vcdb module stores the IP's. If you are using the mysql module then there is no reason to use files, use a database table. So it uses the relay_table in the database. > So parts of it seems to work. > What is wrong, what am I missing, or better, what is the responsible part of > this missing step above. May be, this is a database layout problem, too? > Is there a link to a correct mysqldump.db for vpopmail? 1. Check your relay table, look at it's size 2. You can always drop the table, and vpopmail will create it again. you might need to authenticate twice. not sure if the first time will create it and add, but the second time should add the entry. 3. after you pop in, check the table to see if your IP shows up 4. If it shows up, check if the tcp.smtp.cdb file has been updated It should 5. Check the tcp.smtp file. This should only contain the list of your static IP's that are always allowed to relay. 6. Check your tcpserver startup line for smtp, make sure it has -x /home/vpopmail/etc/tcp.smtp.cdb because the tcp.smtp.cdb file is the one which gets updated. > In the FAQ, i found a tcpserver-mysql-patch, which should let the tcpserver > access the mysql-db directly, without compiling any *.cdb. Anyone can point > me to the missing link for this patch? Check the mailing list archives, it should be listed there. Ken Jones
Once again: vpopmail & relaying with mysql (HELP PLEASE!!!)
Hi all, after getting no response at all, this is my second try. I have up and running a supervised (daemontools, tcpserver) qmail-1.03 with MySQL, vpopmail-4.9.8-1, sqwebmail-2.0.0 and qmailadmin-0.45, followed exactly LWQ. I read all the FAQs and all List-archives, but my problem persists. Compiling vpopmail with "--enable-roaming-users=n", all is working fine, but, logically, without relaying. Compiling vpopmail with "--enable-roaming-users=y" leads to a stucking qmail-pop3d (CPU >80%), after a client has tried to access his account, while vchkpw logs success. This is my qmail-pop3d run script: #!/bin/sh exec /usr/local/bin/softlimit -m 200 \ /usr/local/bin/tcpserver -v -R -H -l 0 0 110 /var/qmail/bin/qmail-popup \ FQDN /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 2>&1 I think, this means, the two first of the three invoked modules, qmail-popup and vchkpw are working fine, but the third invoked process, qmail-pop3d, stucks. The reason for this, I suppose, is that there is no open-smtp.cdb created. ./clearopensmtp also stucks. But I´ve noticed, that the client-IP appears in the "vpopmail" db in the table "relay", but never get pushed to "/home/vpopmail/etc/open-smtp.cdb". So parts of it seems to work. What is wrong, what am I missing, or better, what is the responsible part of this missing step above. May be, this is a database layout problem, too? Is there a link to a correct mysqldump.db for vpopmail? In the FAQ, i found a tcpserver-mysql-patch, which should let the tcpserver access the mysql-db directly, without compiling any *.cdb. Anyone can point me to the missing link for this patch? Greetings Bernardo Virengeprüft vom G DATA AntiVirenKit
