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: 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" 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
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 2>&1 --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
Yape, it got mysql client installed. As I could actually using it to connect to remote mysql db. On 10/22/12 5:38 PM, Thibault Richard wrote: 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: |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:5086049a34179110913129!
[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: |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
# 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 BrookingsGnuPG 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
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 BrookingsGnuPG 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
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 BrookingsGnuPG 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!
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 BrookingsGnuPG 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
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 BrookingsGnuPG 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!
Re: [vchkpw] vpopmail-5.5.0-1239053335 issues
Matt Brookings wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 kengheng wrote: 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 Did you 'make install' in the backend directory? If so, please paste the commands the make install ran. Also, please provide 'uname -a' and also what configure options you used. Below are my configuration and output : # cd vpopmail-5.5.0/ # ./configure --enable-roaming-users=y --enable-logging=p --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-passwd=y --enable-domain-quotas=y --enable-many-domains=n --enable-sql-logging=y --disable-mysql-limits # make;make install # cd vpopmail-5.5.0/backends/mysql # ./configure --enable-valias --enable-auth-module=mysql --enable-auth-logging=y # make gcc -DVAUTH_MODULE -I../.. -fPIC -I/usr/local/mysql/include/mysql -o vmysql.o -c vmysql.c gcc -DVAUTH_MODULE -shared -nostartfiles -o vmysql.so vmysql.o -L/usr/local/mysql/lib/mysql -lz -lm # make install /usr/bin/install -c vmysql.so /var/qmail/vpopmail/lib/vmysql.so rm -f /var/qmail/vpopmail/etc/vpopmail.authmodule ln -s /var/qmail/vpopmail/lib/vmysql.so /var/qmail/vpopmail/etc/vpopmail.authmodule if ! test -r /var/qmail/vpopmail/etc/vpopmail.mysql; then \ /usr/bin/install -c -m 0640 vpopmail.mysql /var/qmail/vpopmail/etc/vpopmail.mysql; \ if test "`id -u`" = "0"; then \ chown vpopmail:vchkpw /var/qmail/vpopmail/etc/vpopmail.mysql; \ fi; \ fi # uname -a Linux web05 2.6.27.19-3.2-pae #1 SMP 2009-02-25 15:40:44 +0100 i686 i686 i386 GNU/Linux Thanks. - -- /* Matt BrookingsGnuPG 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 iEYEARECAAYFAknbStoACgkQ6QgvSNlBT3A4fACfdZukZ1r4jthi28fm5PCW0xqQ XhoAmgNnNF+kJ6WQmSqKaSnHI8H808Wr =d6KD -----END PGP SIGNATURE- -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc !DSPAM:49dc13b732681060811966!
[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] vadddomain -u issues
Tom Collins wrote: On Apr 14, 2006, at 9:57 AM, Ken Jones wrote: kengheng wrote: When I add a domain using vadddomain -u , I have to change the permission of /var/qmail/vpopmail/etc/vpopmail.mysql to o+r ? Thanks. Yes. By default, and for security reasons, the ~vpopmail/etc/vpopmail.mysql file is only readable by the vpopmail user. If you add any domain under a different user, that user will need access to that file. You could either grant access to all users, or you could make sure the vchkpw group has access and include the new user in the vchkpw group. Note that making it world-readable opens up a dangerous security hole. If someone can get access to the server, they can learn the username and password for the entire vpopmail database. If that server just does email, and only admins have access/accounts, then it's less of a risk. Doing it on a server that does web hosting and allows users to upload their own cgi scripts would be very dangerous. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ I agree with Tom, it will lead to more threats available. I'm using vadddomain -u option is for system based quota control, if the -u is not suitable in this scenario, what else can be used to control the mail quota since the vpopmail is not plan to add the domain quota function. Thanks.
[vchkpw] vadddomain -u issues
When I add a domain using vadddomain -u , 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]
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- > >
[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
