Re: [vchkpw] vchkpw auth remote database
Hi, the service run as below: --start-- #!/bin/sh # when QMAILQUEUE is set, all mail will be sent to the nominated script QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue.pl export QMAILQUEUE #QMAILDUID=`id -u qmaild` #NOFILESGID=`id -g qmaild` QMAILDUID=`id -u vpopmail` NOFILESGID=`id -g vckpw` exec /usr/local/bin/softlimit -m 104857600 \ /usr/local/bin/tcpserver \ -H -l localhost \ -v -x /etc/tcp.smtp.cdb \ -c 220 -R -u $QMAILDUID -g $NOFILESGID 0 587 \ /usr/local/bin/rblsmtpd -b -C \ -r 'list.dsbl.org:Your message was rejected because the message was sent from a server listed in DSBL - More information regarding this problem is available at http://dsbl.org/listing?%IP% - Please forward this error to your email server support staff for resolution.' \ -r 'sbl-xbl.spamhaus.org:Your message was rejected because the message was sent from a server listed in the Spamhaus RBL - More information regarding this problems is available at http://www.spamhaus.org/query/bl?ip=%IP% - Please forward this error to your email server support staff for resolution.' \ -t 5 \ /usr/local/bin/fixcrio \ /var/qmail/bin/qmail-smtpd /var/qmail/vpopmail/bin/vchkpw /bin/true 21 --end-- On 10/23/12 5:17 PM, Todor Petkov wrote: On 10/23/2012 05:44 AM, kengheng wrote: Yape, it got mysql client installed. As I could actually using it to connect to remote mysql db. Can you please show the content of the service run file? !DSPAM:5088e22134171855121384!
Re: [vchkpw] vchkpw auth remote database
Hi, I've grant the privilege to user@vpopmailhost, however the vpopmail behaviour as below: vuserinfo can query the user result however,when run vchkpw for smtp-auth, it return the err msg as below: vchkpw-submission: vpopmail user not found t...@abc.com:email_client_ip On 10/23/12 11:07 PM, Thibault Richard wrote: vuserinfo only make a SELECT, that why I asked for other rights -Original Message- From: Tom Collins [mailto:t...@tomlogic.com] Sent: mardi 23 octobre 2012 16:50 To: vchkpw@inter7.com Subject: Re: [vchkpw] vchkpw auth remote database He's said that vuserinfo works, so the database linkage is OK. Something else is preventing vchkpw from working. -Tom (Sent from my phone; forgive my brevity) On Oct 23, 2012, at 2:28 AM, Thibault Richard th...@thibs.com wrote: Hello Are your MySQL right well set on the MySQL server ? I usually set those rights GRANT select,insert,update,delete,create,drop ON vpopmail.* TO vpopmailuser@SRV1 IDENTIFIED BY 'VPOPMAIL_PASSWORD'; (modifications right to create new accounts + logging) Best Regards Thibault -Original Message- From: Todor Petkov [mailto:z...@online.bg] Sent: mardi 23 octobre 2012 11:17 To: vchkpw@inter7.com Subject: Re: [vchkpw] vchkpw auth remote database On 10/23/2012 05:44 AM, kengheng wrote: Yape, it got mysql client installed. As I could actually using it to connect to remote mysql db. Can you please show the content of the service run file? !DSPAM:5088e78534177245918239!
Re: [vchkpw] vchkpw auth remote database
On 10/25/2012 10:17 AM, kengheng wrote: Hi, I've grant the privilege to user@vpopmailhost, however the vpopmail behaviour as below: vuserinfo can query the user result however,when run vchkpw for smtp-auth, it return the err msg as below: vchkpw-submission: vpopmail user not found t...@abc.com:email_client_ip On 10/23/12 11:07 PM, Thibault Richard wrote: vuserinfo only make a SELECT, that why I asked for other rights Can you dump the traffic between the mail server and mysql? I guess it will be easier than to start mysql with logging and see queries from other clients. Otherwise the problem is quite strange.. !DSPAM:5088e89334171833546067!
RE: [vchkpw] vchkpw auth remote database
And if you cannot dump the traffic, on the server with MySQL server, you can indeed activate MySQL logging In my.cnf file (on Debian /etc/mysql/my.cnf), add the following lines general_log_file= /var/log/mysql/mysql.log general_log = 1 (in Debian just un-comment it) Then re-try and take a look into the log file /var/log/mysql/mysql.log -Original Message- From: Todor Petkov [mailto:z...@online.bg] Sent: jeudi 25 octobre 2012 09:22 To: vchkpw@inter7.com Subject: Re: [vchkpw] vchkpw auth remote database On 10/25/2012 10:17 AM, kengheng wrote: Hi, I've grant the privilege to user@vpopmailhost, however the vpopmail behaviour as below: vuserinfo can query the user result however,when run vchkpw for smtp-auth, it return the err msg as below: vchkpw-submission: vpopmail user not found t...@abc.com:email_client_ip On 10/23/12 11:07 PM, Thibault Richard wrote: vuserinfo only make a SELECT, that why I asked for other rights Can you dump the traffic between the mail server and mysql? I guess it will be easier than to start mysql with logging and see queries from other clients. Otherwise the problem is quite strange.. !DSPAM:5088edd434171808015294!
RE: [vchkpw] vchkpw auth remote database
Hello Are your MySQL right well set on the MySQL server ? I usually set those rights GRANT select,insert,update,delete,create,drop ON vpopmail.* TO vpopmailuser@SRV1 IDENTIFIED BY 'VPOPMAIL_PASSWORD'; (modifications right to create new accounts + logging) Best Regards Thibault -Original Message- From: Todor Petkov [mailto:z...@online.bg] Sent: mardi 23 octobre 2012 11:17 To: vchkpw@inter7.com Subject: Re: [vchkpw] vchkpw auth remote database On 10/23/2012 05:44 AM, kengheng wrote: Yape, it got mysql client installed. As I could actually using it to connect to remote mysql db. Can you please show the content of the service run file? !DSPAM:5086634734177422079863!
Re: [vchkpw] vchkpw auth remote database
He's said that vuserinfo works, so the database linkage is OK. Something else is preventing vchkpw from working. -Tom (Sent from my phone; forgive my brevity) On Oct 23, 2012, at 2:28 AM, Thibault Richard th...@thibs.com wrote: Hello Are your MySQL right well set on the MySQL server ? I usually set those rights GRANT select,insert,update,delete,create,drop ON vpopmail.* TO vpopmailuser@SRV1 IDENTIFIED BY 'VPOPMAIL_PASSWORD'; (modifications right to create new accounts + logging) Best Regards Thibault -Original Message- From: Todor Petkov [mailto:z...@online.bg] Sent: mardi 23 octobre 2012 11:17 To: vchkpw@inter7.com Subject: Re: [vchkpw] vchkpw auth remote database On 10/23/2012 05:44 AM, kengheng wrote: Yape, it got mysql client installed. As I could actually using it to connect to remote mysql db. Can you please show the content of the service run file? !DSPAM:5086aea834171685210279!
RE: [vchkpw] vchkpw auth remote database
vuserinfo only make a SELECT, that why I asked for other rights -Original Message- From: Tom Collins [mailto:t...@tomlogic.com] Sent: mardi 23 octobre 2012 16:50 To: vchkpw@inter7.com Subject: Re: [vchkpw] vchkpw auth remote database He's said that vuserinfo works, so the database linkage is OK. Something else is preventing vchkpw from working. -Tom (Sent from my phone; forgive my brevity) On Oct 23, 2012, at 2:28 AM, Thibault Richard th...@thibs.com wrote: Hello Are your MySQL right well set on the MySQL server ? I usually set those rights GRANT select,insert,update,delete,create,drop ON vpopmail.* TO vpopmailuser@SRV1 IDENTIFIED BY 'VPOPMAIL_PASSWORD'; (modifications right to create new accounts + logging) Best Regards Thibault -Original Message- From: Todor Petkov [mailto:z...@online.bg] Sent: mardi 23 octobre 2012 11:17 To: vchkpw@inter7.com Subject: Re: [vchkpw] vchkpw auth remote database On 10/23/2012 05:44 AM, kengheng wrote: Yape, it got mysql client installed. As I could actually using it to connect to remote mysql db. Can you please show the content of the service run file? !DSPAM:5086b2c434177653271624!
[vchkpw] vchkpw auth remote database
Hi All, I've setup a vpopmail at a svr and wish to perform smtp auth to another mysql svr at other host. I've changed the /home/vpopmail/etc/vpopmail.mysql as below: remote_ip|3306|vpopmail|vpoppass|vpopdb but I keep on receiving this err msg: vchkpw-submission: vpopmail user not found a...@test.com:127.0.0.1 However if I perform vuserinfo a...@test.com, I can retrieve the result. Note, the vpopmail svr has no mysql installed. Thanks. !DSPAM:5085116c34171790215256!
RE: [vchkpw] vchkpw auth remote database
Hello, Does your vpopmail svr have at least a MySQL CLIENT installed ? Best Regards Thibault -Original Message- From: kengheng [mailto:kengh...@mysql.cc] Sent: lundi 22 octobre 2012 11:27 To: vchkpw@inter7.com Subject: [vchkpw] vchkpw auth remote database Hi All, I've setup a vpopmail at a svr and wish to perform smtp auth to another mysql svr at other host. I've changed the /home/vpopmail/etc/vpopmail.mysql as below: remote_ip|3306|vpopmail|vpoppass|vpopdb but I keep on receiving this err msg: vchkpw-submission: vpopmail user not found a...@test.com:127.0.0.1 However if I perform vuserinfo a...@test.com, I can retrieve the result. Note, the vpopmail svr has no mysql installed. Thanks. !DSPAM:5085140e34171857320279!