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!
[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!
[vchkpw] imap before smtp
Dear All, would like to check if there is anyway to do imap before smtp relay ? I'm using courier-authlib-0.60.2 with courier-imap. Thanks. -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc !DSPAM:4ab1dc8f32717245867931!
Re: [vchkpw] vpopmail-5.5.0-1239053335 issues
I've recompiled the backend/mysql with --enable-libdir=/usr/local/mysql/lib/mysql --enable-incdir=/usr/local/mysql/include/mysql and it show the same error in backend/mysql/config.log. Matt Brookings wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 kengheng wrote: Hi Matt, I checked the in backend/mysql/config.log, I found this, look like the linkage to libmysqlclient got problems I was wondering why it didn't show up in ldd :) Anyhow, I've submitted a change to the branch in svn that will report the failure. In the mean time, recompile the backend with --enable-libdir=/path where path is the full path to the directory that libmysqlclient.so is located. - -- /* Matt Brookings m...@inter7.com GnuPG Key D9414F70 Software developer Systems technician Inter7 Internet Technologies, Inc. (815)776-9465 */ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkneESMACgkQ6QgvSNlBT3DEQwCfdvQNeonU2+1PwVKPmd0tewTy zoYAoKbrF3kTfMl+JgTYIc9HrIoYTviE =Dqcu -END PGP SIGNATURE- -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc !DSPAM:49de21fd32681469719179!
Re: [vchkpw] vpopmail-5.5.0-1239053335 issues
# cd backend/mysql/ # export LDFLAGS=-L/usr/local/mysql/lib/mysql/ # ./configure # make;make install and it is working :) Matt Brookings wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 kengheng wrote: Hi Matt, I checked the in backend/mysql/config.log, I found this, look like the linkage to libmysqlclient got problems I was wondering why it didn't show up in ldd :) Anyhow, I've submitted a change to the branch in svn that will report the failure. In the mean time, recompile the backend with --enable-libdir=/path where path is the full path to the directory that libmysqlclient.so is located. - -- /* Matt Brookings m...@inter7.com GnuPG Key D9414F70 Software developer Systems technician Inter7 Internet Technologies, Inc. (815)776-9465 */ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkneESMACgkQ6QgvSNlBT3DEQwCfdvQNeonU2+1PwVKPmd0tewTy zoYAoKbrF3kTfMl+JgTYIc9HrIoYTviE =Dqcu -END PGP SIGNATURE- -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc !DSPAM:49de24ee32681281720437!
Re: [vchkpw] vpopmail-5.5.0-1239053335 issues
Matt Brookings wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 kengheng wrote: here the output # ldd /var/qmail/vpopmail/lib/vmysql.so linux-gate.so.1 = (0xe000) libz.so.1 = /lib/libz.so.1 (0xb8018000) libm.so.6 = /lib/libm.so.6 (0xb7fef000) libc.so.6 = /lib/libc.so.6 (0xb7e93000) /lib/ld-linux.so.2 (0xb805)* Add /usr/local/mysql/lib/mysql to your ldconfig and try again. It is added before the compiling. # ldconfig -p | grep mysql libmysqlclient_r.so.16 (libc6) = /usr/local/mysql/lib/mysql/libmysqlclient_r.so.16 libmysqlclient_r.so (libc6) = /usr/local/mysql/lib/mysql/libmysqlclient_r.so libmysqlclient.so.16 (libc6) = /usr/local/mysql/lib/mysql/libmysqlclient.so.16 libmysqlclient.so (libc6) = /usr/local/mysql/lib/mysql/libmysqlclient.so - -- /* Matt Brookings m...@inter7.com GnuPG Key D9414F70 Software developer Systems technician Inter7 Internet Technologies, Inc. (815)776-9465 */ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkncsm4ACgkQ6QgvSNlBT3CqwwCeIEhbwdUpyZYN3Gw3H/B+PTcW 0HQAnAt1Uf28pAfD45V988LAt3bVAFWE =ysxv -END PGP SIGNATURE- -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc !DSPAM:49dd51cc32681314021405!
Re: [vchkpw] vpopmail-5.5.0-1239053335 issues
Hi Matt, I checked the in backend/mysql/config.log, I found this, look
like the linkage to libmysqlclient got problems
..
...
configure:3041: checking for mysql_real_connect in -lmysqlclient
configure:3076: gcc -o conftest -I../.. -fPIC conftest.c
-lmysqlclient -lz -lm 5
/usr/lib/gcc/i586-suse-linux/4.3/../../../../i586-suse-linux/bin/ld:
cannot find -lmysqlclient
collect2: ld returned 1 exit status
configure:3082: $? = 1
configure: failed program was:
| /* confdefs.h. */
| #define PACKAGE_NAME vmysql
| #define PACKAGE_TARNAME vmysql
| #define PACKAGE_VERSION 1.0.0
| #define PACKAGE_STRING vmysql 1.0.0
| #define PACKAGE_BUGREPORT
| #define HAVE_LIBM 1
| #define HAVE_LIBZ 1
| /* end confdefs.h. */
|
| /* Override any GCC internal prototype to avoid an error.
|Use char because int might match the return type of a GCC
|builtin and then its argument prototype would still apply. */
| #ifdef __cplusplus
| extern C
| #endif
| char mysql_real_connect ();
| int
| main ()
| {
| return mysql_real_connect ();
| ;
| return 0;
| }
configure:3100: result: no
...
...
...
Matt Brookings wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
kengheng wrote:
here the output
# ldd /var/qmail/vpopmail/lib/vmysql.so
linux-gate.so.1 = (0xe000)
libz.so.1 = /lib/libz.so.1 (0xb8018000)
libm.so.6 = /lib/libm.so.6 (0xb7fef000)
libc.so.6 = /lib/libc.so.6 (0xb7e93000)
/lib/ld-linux.so.2 (0xb805)*
Add /usr/local/mysql/lib/mysql to your ldconfig and try again.
- --
/*
Matt Brookings m...@inter7.com GnuPG Key D9414F70
Software developer Systems technician
Inter7 Internet Technologies, Inc. (815)776-9465
*/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkncsm4ACgkQ6QgvSNlBT3CqwwCeIEhbwdUpyZYN3Gw3H/B+PTcW
0HQAnAt1Uf28pAfD45V988LAt3bVAFWE
=ysxv
-END PGP SIGNATURE-
--
Best regards,
KengHeng. Chan
Mobile : +6-016-717-0273
SQL Technology Sdn Bhd
http://www.mysql.cc
c...@mysql.cc
!DSPAM:49dd85f532681852517504!
[vchkpw] vpopmail-5.5.0-1239053335 issues
Dear All, I've installed vpopmail-5.5.0-1239053335 and compiled mysql backend successfully. However, whenever I try to run a vpopmail bin, it will generate a error msg to me as below: vpopmail/bin/vadddomain abc.mydomain.com vauth_load_module: dlopen(/var/qmail/vpopmail/etc/vpopmail.authmodule) failed: 0 Error - no authentication module loaded. could not load authentication module Notes: I've configured the vpopmail.mysql accordingly and follow my older vpopmail 5.4.25 which run perfectly -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc !DSPAM:49db380d32682267419082!
Re: [vchkpw] vpopmail-5.5.0-1239053335 issues
here the output # ldd /var/qmail/vpopmail/lib/vmysql.so linux-gate.so.1 = (0xe000) libz.so.1 = /lib/libz.so.1 (0xb8018000) libm.so.6 = /lib/libm.so.6 (0xb7fef000) libc.so.6 = /lib/libc.so.6 (0xb7e93000) /lib/ld-linux.so.2 (0xb805)* * Matt Brookings wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 kengheng wrote: ln -s /var/qmail/vpopmail/lib/vmysql.so Please paste output of: ldd /var/qmail/vpopmail/lib/vmysql.so - -- /* Matt Brookings m...@inter7.com GnuPG Key D9414F70 Software developer Systems technician Inter7 Internet Technologies, Inc. (815)776-9465 */ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkncIPUACgkQ6QgvSNlBT3BxsQCfeo0lwo4vIctPAfnnRd1a5zR7 EV8AnR6H6JAuRHVTMCJrZVFGLb49YB0j =CsFs -END PGP SIGNATURE- -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc !DSPAM:49dc38b432683322216282!
[vchkpw] vadddomain -u issues
When I add a domain using vadddomain -u domain, I have to change the permission of /var/qmail/vpopmail/etc/vpopmail.mysql to o+r ? Thanks.
Re: [vchkpw] Domain Quota Features
Ken Jones wrote: kengheng wrote: Hi, when will the domain quota feature back to vpopmail? Thanks. Probably never. It is too resource intensive. I recommend using operating system user quotas. Place each domain under a different user and let the file system handle the quota. This is also helpful if you host the web site and email. Then you can impose an overall disk space quota per account. Ken Jones Hi, any doc or guidelines to do it? thanks.
[vchkpw] Domain Quota Features
Hi, when will the domain quota feature back to vpopmail? Thanks.
[vchkpw] relay table issue
Hi All, I've a qmail+vpopmail+mysql+roaming installation on a A server. I've up another B server (qmail smtp only) that wish to connect to A server to check for the relay table for validating users who send emails to B servers. What options I need to set at the B server? Thanks
[vchkpw] How do log the postmaster activities
Hi, I'm using vpopmail 5.4.3, qmailadmin 1.2.0 with 5 domains, around 500 account, running on dual CPU, raid-5 server, I'm recently found that some user account was suddelly disappeared from the server, although I've changed the postmaster password and login, the same case happended again, therefore I wish to know where can I log the postmaster activities.
[vchkpw] Compile Error With Mysql
Hello All, I'm compiling vpopmail-5.3.29 with mysql 4.0.16, and I gor this error message during make: gcc -I. -I/usr/local/mysql/include -I. -I. -I. -g -O2 -Wall -c `test -f 'vauth.c' || echo './'`vauth.c vauth.c:33:19: mysql.h: No such file or directory vauth.c:40: error: parse error before mysql_update vauth.c:40: warning: type defaults to `int' in declaration of `mysql_update' vauth.c:40: warning: data definition has no type or storage class vauth.c:41: error: parse error before mysql_read_getall .. .. .. Got Any Ideas? -- Best regards, kengheng SQL DotCOM http://www.mysql.cc mailto:[EMAIL PROTECTED]
[vchkpw] Retrive From Catch ALL Pop Account
Hi all, is they anyway I can retrive a catch all pop account from my ISP server to a local server and distribute it to the users. eg: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] (catch all pop acc in ISP) -- distribute to according user in qmail/vpopmail local server . . [EMAIL PROTECTED] Thanks, Keng Heng. Chan
Re: [vchkpw] Retrive From Catch ALL Pop Account
Hi, How do I need to configure the .fetechmailrc file? Thanks - Original Message - From: Simon Adlem [EMAIL PROTECTED] To: kengheng [EMAIL PROTECTED] Sent: Saturday, September 06, 2003 1:10 AM Subject: Re: [vchkpw] Retrive From Catch ALL Pop Account -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 05 Sep 2003 5:45 pm, kengheng may quite possibly have written: Hi all, is they anyway I can retrive a catch all pop account from my ISP server to a local server and distribute it to the users. Yes, use fectchmail: http://catb.org/~esr/fetchmail/ Simon -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/WMNwAEPeBJNaHh0RAsN0AJ9pVYIOpzoJiLzrH4dse+w+3SaCwwCfSxG/ oYELBYdl894X33BEMCiGfj8= =G7P8 -END PGP SIGNATURE-
