Re: [vchkpw] vpopmail with mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/14/2010 05:42 AM, Anil Euclid wrote: > Dear All,* > * > i want to add few fields like pw_popenable , pw_imapenable > > use of these fields will be > like for some user i want to disable pop3 > and for few user disable imap > > please suggest me how to start, i will have to modify These features already exist in vpopmail. Run the vmoduser binary to see a list of user flags. - -- /* Matt BrookingsGnuPG Key FAE0672C Software developer Systems technician Inter7 Internet Technologies, Inc. (815)776-9465 */ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAky3FekACgkQIwet2/rgZyyL3QCgk5o7NAg/l3Btbli6Dfhtb/0t wSYAoIQE7nd0853Xf6GRG//e963tFn11 =E2Yk -END PGP SIGNATURE-
[vchkpw] vpopmail with mysql
Dear All,* * i want to add few fields like pw_popenable , pw_imapenable use of these fields will be like for some user i want to disable pop3 and for few user disable imap please suggest me how to start, i will have to modify vusersinfo adduser cheking password qmailadmin field etc Regards Anil !DSPAM:4cb6de9932711336593494!
Re: [vchkpw] vpopmail with mysql authentication of installer specified database
If an FTP server gives a user open access to their directory, couldn't you have a potential security problem? Since the .qmail file is processed by the vpopmail user, any program I add to my .qmail will run as vpopmail. As a user with ftp access to my .qmail file, I could create a .qmail file that emailed a copy of ~vpopmail/etc/vpopmail.mysql to myself. I'm sure we can think of even worse scenarios, but won't share them on the list (we don't need script kiddies picking up the idea and running with it). This is the main reason we've had to be careful with qmailadmin to make sure users can't create new program delivery lines when adding forwards. Unfortunately, we end up removing program delivery lines that weren't qmailadmin generated (like tmda (tdma?) stuff). -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] vpopmail with mysql authentication of installer specified database
> I remember reading from the proftpd forum > that a vpopmail+proftpd enthusiast was using > his own defined mysql table to authenticate > both vpopmail and proftpd users. Is it > possible to do this without changing the > source code? (I am not overly happy about > changing source since the vpopmail > installation will be updated with time). In proftpd.conf: (example on proftpd 1.2.9) SQLAuthenticate users SQLAuthTypesPlaintext SQLConnectInfo [EMAIL PROTECTED] dbuser dbpasswd SQLUserInfo domain_tld pw_name pw_clear_passwd NULL NULL pw_home NULL or SQLAuthenticate users SQLAuthTypesCrypt SQLConnectInfo [EMAIL PROTECTED] dbuser dbpasswd SQLUserInfo domain_tld pw_name pw_passwd NULL NULL pw_home NULL Solt
Re: [vchkpw] vpopmail with mysql authentication of installer specified database
On Fri, 2004-03-05 at 01:12, [EMAIL PROTECTED] wrote: > Hi to vpopmail users, > > I remember reading from the proftpd forum > that a vpopmail+proftpd enthusiast was using > his own defined mysql table to authenticate > both vpopmail and proftpd users. Is it > possible to do this without changing the > source code? (I am not overly happy about > changing source since the vpopmail > installation will be updated with time). pure-ftpd has support for vpopmail authentication, and it also doesn't have the security record of proftpd. You might give it a shot. -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
[vchkpw] vpopmail with mysql authentication of installer specified database
Hi to vpopmail users, I remember reading from the proftpd forum that a vpopmail+proftpd enthusiast was using his own defined mysql table to authenticate both vpopmail and proftpd users. Is it possible to do this without changing the source code? (I am not overly happy about changing source since the vpopmail installation will be updated with time). Regards, Phillip Lucs
[vchkpw] vpopmail with mysql documentation
Is there some documentation on how vpopmail works with mysql? I have it set-up succesfully, but I'm curious as to how exactly I can take advantage of the 'valias' table and also the relay table information etc. ron == Ron Dyck Webbtech www.webbtech.net ==
[vchkpw] vpopmail (with MySQL & courier imap hack)
Hi there, I'm running qmail with vpopmail, courier imap/bla. It works nice under FreeBSD 4.8 But i have one problem i have compiled vpopmail WITHOUT mysql, and WITH a courier-imap hack see here: THE HACK >> http://www.pofo.de/HOWTO/qmail/files/open_relay.c env VPOPMAILDIR=`pw usershow vpopmail | cut -f9 -d':'`/etc \ /bin/sh -c 'gcc -o open_relay open_relay.c `cat $VPOPMAILDIR/inc_deps $VPOPMAILDIR/lib_deps` -lcrypt' install -o root -g wheel -m 755 open_relay /usr/local/bin/ its a smtp after imap/pop3 "hack" but now i will deinstall vpopmail and install with MySQL support, but that its not the problem 1. How can i delete the hack? 2. How can i setup the hack to work with vpopmail AND MySQL? thanks in advance! eLgino PS: sorry for my poor english
Re: [vchkpw] vpopmail (with MySQL & courier imap hack)
would you prefer to use smtp auth? which is actually better than using these hacks? (at least from my point of view) then there is some instructions hmm I use on FreeBSD too with mysql, I made my installation in a log format. I can just give it to you On Wed, 13 Aug 2003, eLgino wrote: > Hi there, > > I'm running qmail with vpopmail, courier imap/bla. > It works nice under FreeBSD 4.8 > > But i have one problem i have compiled vpopmail WITHOUT mysql, and WITH a > courier-imap hack see here: > > THE HACK >> http://www.pofo.de/HOWTO/qmail/files/open_relay.c > env VPOPMAILDIR=`pw usershow vpopmail | cut -f9 -d':'`/etc \ > /bin/sh -c 'gcc -o open_relay open_relay.c `cat $VPOPMAILDIR/inc_deps > $VPOPMAILDIR/lib_deps` -lcrypt' > install -o root -g wheel -m 755 open_relay /usr/local/bin/ > > its a smtp after imap/pop3 "hack" > > but now i will deinstall vpopmail and install with MySQL support, but that > its not the problem > > 1. How can i delete the hack? > 2. How can i setup the hack to work with vpopmail AND MySQL? > > thanks in advance! > > eLgino > > PS: sorry for my poor english > > >
Re: [vchkpw] vpopmail (with MySQL & courier imap hack)
yea, please send it to me i hope i become not an open relay - Original Message - From: "Evren Yurtesen" <[EMAIL PROTECTED]> To: "eLgino" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 7:13 PM Subject: Re: [vchkpw] vpopmail (with MySQL & courier imap hack) > would you prefer to use smtp auth? which is actually better than using > these hacks? (at least from my point of view) > then there is some instructions hmm I use on FreeBSD too with mysql, I > made my installation in a log format. I can just give it to you > > On Wed, 13 Aug 2003, eLgino wrote: > > > Hi there, > > > > I'm running qmail with vpopmail, courier imap/bla. > > It works nice under FreeBSD 4.8 > > > > But i have one problem i have compiled vpopmail WITHOUT mysql, and WITH a > > courier-imap hack see here: > > > > THE HACK >> http://www.pofo.de/HOWTO/qmail/files/open_relay.c > > env VPOPMAILDIR=`pw usershow vpopmail | cut -f9 -d':'`/etc \ > > /bin/sh -c 'gcc -o open_relay open_relay.c `cat $VPOPMAILDIR/inc_deps > > $VPOPMAILDIR/lib_deps` -lcrypt' > > install -o root -g wheel -m 755 open_relay /usr/local/bin/ > > > > its a smtp after imap/pop3 "hack" > > > > but now i will deinstall vpopmail and install with MySQL support, but that > > its not the problem > > > > 1. How can i delete the hack? > > 2. How can i setup the hack to work with vpopmail AND MySQL? > > > > thanks in advance! > > > > eLgino > > > > PS: sorry for my poor english > > > > > > > >
Re: [vchkpw] vpopmail with mysql problem
zafar rizvi wrote: i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Error: Unable to chdir to vpopmail/users directory Is there anything wrong. A whole bunch of things could be wrong - you have to do some troubleshooting yourself to check these: 1. MySQL isn't running at the remote end. and/or 2. Your MySQL username or password is/are incorrect. and/or 3. You haven't given permission on the remote MySQL server to connect to it from your server (i.e. GRANT ALL PRIVILEGES ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY "password" etc etc etc). and/or 4. There is a firewall running on either or both machines preventing communication. Again, as I suggested in a previous email, you can test these things yourself easily enough using simple things like telnet, the mysql client, etc etc. -- Aj. Systems Administrator / Developer
Re: [vchkpw] vpopmail with mysql problem
Is Mysql started? -John - Original Message - From: "zafar rizvi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 12:20 AM Subject: [vchkpw] vpopmail with mysql problem > hi > i am installing vpopmail-5.2.1 with mysql centralized database ports, > I successfully compile everything but when adding the domain it give me > error like that > > [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com > Please enter password for postmaster: > enter password again: > could not connect to mysql update server Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) with database > could not connect to mysql update server Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > vmysql: sql error[c]: MySQL server has gone away > vmysql: sql error[b]: MySQL server has gone away > vmysql: sql error[3]: MySQL server has gone away > vmysql: sql error[c]: MySQL server has gone away > vmysql: sql error[c]: MySQL server has gone away > vmysql: sql error[b]: MySQL server has gone away > vmysql: sql error[3]: MySQL server has gone away > vmysql: sql error[2]: MySQL server has gone away > Error: Unable to chdir to vpopmail/users directory > > Is there anything wrong. > > Tx > ZaFAr > > >
Re: [vchkpw] vpopmail with mysql problem
hmmm you have not compiled vpopmail with user that can connect to mysql databases. I will suggest better to study FAQs and then create username and password in databases compile vpopmail with username that can create modify delete vpopmail database -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) - Original Message - From: "zafar rizvi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 12:20 PM Subject: [vchkpw] vpopmail with mysql problem | hi | i am installing vpopmail-5.2.1 with mysql centralized database ports, | I successfully compile everything but when adding the domain it give me | error like that | | [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com | Please enter password for postmaster: | enter password again: | could not connect to mysql update server Access denied for user: | '[EMAIL PROTECTED]' (Using password: YES) with database | could not connect to mysql update server Access denied for user: | '[EMAIL PROTECTED]' (Using password: YES) | vmysql: sql error[c]: MySQL server has gone away | vmysql: sql error[b]: MySQL server has gone away | vmysql: sql error[3]: MySQL server has gone away | vmysql: sql error[c]: MySQL server has gone away | vmysql: sql error[c]: MySQL server has gone away | vmysql: sql error[b]: MySQL server has gone away | vmysql: sql error[3]: MySQL server has gone away | vmysql: sql error[2]: MySQL server has gone away | Error: Unable to chdir to vpopmail/users directory | | Is there anything wrong. | | Tx | ZaFAr | | |
[vchkpw] vpopmail with mysql problem
hi i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Error: Unable to chdir to vpopmail/users directory Is there anything wrong. Tx ZaFAr
Re: [vchkpw] vpopmail with mysql support
Hi, Zafar. Try the latest development release of vpopmail. As you can see below, it's stating there is a syntax error in the header file. This could be a result of your system, or the older version of vpopmail. If you get the latest development release and this occurs, make sure you have the latest MySQL-devel, and latest MySQL installed, and that you're running the latest stable GNU compiler. Hope that helps! zafar rizvi wrote: hi here is the all output of make command * cdbmake_add.o make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1/cdb' make[2]: Entering directory `/usr/local/src/vpopmail-5.2.1' gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vpopmail.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c md5.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c bigdir.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vauth.c In file included from vauth.c:32: vmysql.h:26:29: warning: multi-line string literals are deprecated vmysql.h:27:35: warning: multi-line string literals are deprecated vmysql.h:29:39: warning: multi-line string literals are deprecated vmysql.h:30:35: warning: multi-line string literals are deprecated vmysql.h:31:35: warning: multi-line string literals are deprecated vmysql.h:36:38: warning: multi-line string literals are deprecated vmysql.h:37:33: warning: multi-line string literals are deprecated vmysql.h:39:39: warning: multi-line string literals are deprecated vmysql.h:51:35: warning: multi-line string literals are deprecated In file included from vauth.c:32: vmysql.h:55: syntax error before "char" vmysql.h:60:35: warning: multi-line string literals are deprecated vmysql.h:71:24: warning: multi-line string literals are deprecated vmysql.h:79:24: warning: multi-line string literals are deprecated vmysql.h:84:42: warning: multi-line string literals are deprecated vmysql.h:91:27: warning: multi-line string literals are deprecated vmysql.h:59: stray '\' in program vmysql.h:118:2: #else without #if vmysql.h:130:2: #endif without #if vmysql.h:243:2: #endif without #if vauth.c: In function `vauth_open_update': vauth.c:108: `mysql_update' undeclared (first use in this function) vauth.c:108: (Each undeclared identifier is reported only once vauth.c:108: for each function it appears in.) vauth.c:112: parse error before "rizvi" vauth.c:122: parse error before "rizvi" vauth.c: At top level: vauth.c:133: parse error before numeric constant vauth.c:134: warning: type defaults to `int' in declaration of `snprintf' vauth.c:134: warning: data definition has no type or storage class vauth.c:143: warning: type defaults to `int' in declaration of `res_update' vauth.c:143: conflicting types for `res_update' vauth.c:54: previous declaration of `res_update' vauth.c:143: `mysql_update' undeclared here (not in a function) vauth.c:143: warning: initialization makes integer from pointer without a cast vauth.c:143: initializer element is not constant vauth.c:143: warning: data definition has no type or storage class vauth.c:144: warning: type defaults to `int' in declaration of `mysql_free_result' vauth.c:144: warning: parameter names (without types) in function declaration vauth.c:144: conflicting types for `mysql_free_result' /usr/include/mysql/mysql.h:271: previous declaration of `mysql_free_result' vauth.c:144: warning: data definition has no type or storage class vauth.c:147: parse error before "if" vauth.c: In function `vauth_open_read_getall': vauth.c:199: `MYSQL_READ_SERVER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_USER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_PASSWD' undeclared (first use in this function) vauth.c:200: `MYSQL_DATABASE' undeclared (first use in this function) vauth.c:201: `MYSQL_VPORT' undeclared (first use in this function) vauth.c:205: parse error before "rizvi" vauth.c: At top level: vauth.c:214: parse error before "return" vauth.c: In function `vauth_adddomain': vauth.c:228: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:232: `TABLE_LAYOUT' undeclared (first use in this function) vauth.c:234: `mysql_update' undeclared (first use in this function) vauth.c:239: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_adduser': vauth.c:269: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:272: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:311: warning: int format, pointer arg (arg 7) vauth.c:311: warning: format argument is not a pointer (arg 8) vauth.c:311: warning: too many arguments for format vauth.c:313: `mysql_update' undeclared (first use in this function) vauth.c:317: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_getpw': vauth.c:351: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:355: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:365: `mysql_update' undeclared (first use in this
Re: [vchkpw] vpopmail with mysql support
zafar rizvi wrote: hi ppl i am using qmail on linux with vpopmail(5.3.14) support with mysql. But getting error like that when using with mysql support. Any body has idea about that error. vauth.c: In function `vget_lastauth': vauth.c:1132: `mysql_update' undeclared (first use in this function) vauth.c:1139: warning: assignment makes integer from pointer without a cast vauth.c:1141: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vget_lastauthip': vauth.c:1157: `mysql_update' undeclared (first use in this function) vauth.c:1164: warning: assignment makes integer from pointer without a cast vauth.c:1165: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vcreate_lastauth_table': vauth.c:1178: `LASTAUTH_TABLE_LAYOUT' undeclared (first use in this function) vauth.c:1179: `mysql_update' undeclared (first use in this function) vauth.c:1183: warning: assignment makes integer from pointer without a cast vauth.c: In function `logmysql': vauth.c:1352: `mysql_update' undeclared (first use in this function) vauth.c:1359: warning: assignment makes integer from pointer without a cast vauth.c: In function `vcreate_vlog_table': vauth.c:1372: `mysql_update' undeclared (first use in this function) vauth.c:1376: warning: assignment makes integer from pointer without a cast make[2]: *** [vauth.o] Error 1 make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make: *** [all-recursive-am] Error 2 ** Did you edit vmysql.h (as it says in README.mysql) ? Also, is MySQL installed from RPM? -- Aj. Systems Administrator / Developer
Re: [vchkpw] vpopmail with mysql support
hmmm it seems when u added you login name rizvi and password rizvi.. you had done something wrong with syntex of this file.. I will suggest better to untar again source and put username and password as it will... Always becareful for syntex when adding something to source sorry for spell mistake due to lake of time :) -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) "All I want is a few minutes alone with the source code for the universe and a quick recompile." - Original Message - From: "zafar rizvi" <[EMAIL PROTECTED]> To: "Ahmad Masood Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 12:27 PM Subject: Re: [vchkpw] vpopmail with mysql support | hi | here is the all output of make command | * | cdbmake_add.o | make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1/cdb' | make[2]: Entering directory `/usr/local/src/vpopmail-5.2.1' | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vpopmail.c | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c md5.c | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c bigdir.c | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vauth.c | In file included from vauth.c:32: | vmysql.h:26:29: warning: multi-line string literals are deprecated | vmysql.h:27:35: warning: multi-line string literals are deprecated | vmysql.h:29:39: warning: multi-line string literals are deprecated | vmysql.h:30:35: warning: multi-line string literals are deprecated | vmysql.h:31:35: warning: multi-line string literals are deprecated | vmysql.h:36:38: warning: multi-line string literals are deprecated | vmysql.h:37:33: warning: multi-line string literals are deprecated | vmysql.h:39:39: warning: multi-line string literals are deprecated | vmysql.h:51:35: warning: multi-line string literals are deprecated | In file included from vauth.c:32: | vmysql.h:55: syntax error before "char" | vmysql.h:60:35: warning: multi-line string literals are deprecated | vmysql.h:71:24: warning: multi-line string literals are deprecated | vmysql.h:79:24: warning: multi-line string literals are deprecated | vmysql.h:84:42: warning: multi-line string literals are deprecated | vmysql.h:91:27: warning: multi-line string literals are deprecated | vmysql.h:59: stray '\' in program | vmysql.h:118:2: #else without #if | vmysql.h:130:2: #endif without #if | vmysql.h:243:2: #endif without #if | vauth.c: In function `vauth_open_update': | vauth.c:108: `mysql_update' undeclared (first use in this function) | vauth.c:108: (Each undeclared identifier is reported only once | vauth.c:108: for each function it appears in.) | vauth.c:112: parse error before "rizvi" | vauth.c:122: parse error before "rizvi" | vauth.c: At top level: | vauth.c:133: parse error before numeric constant | vauth.c:134: warning: type defaults to `int' in declaration of `snprintf' | vauth.c:134: warning: data definition has no type or storage class | vauth.c:143: warning: type defaults to `int' in declaration of `res_update' | vauth.c:143: conflicting types for `res_update' | vauth.c:54: previous declaration of `res_update' | vauth.c:143: `mysql_update' undeclared here (not in a function) | vauth.c:143: warning: initialization makes integer from pointer without a | cast | vauth.c:143: initializer element is not constant | vauth.c:143: warning: data definition has no type or storage class | vauth.c:144: warning: type defaults to `int' in declaration of | `mysql_free_result' | vauth.c:144: warning: parameter names (without types) in function | declaration | vauth.c:144: conflicting types for `mysql_free_result' | /usr/include/mysql/mysql.h:271: previous declaration of `mysql_free_result' | vauth.c:144: warning: data definition has no type or storage class | vauth.c:147: parse error before "if" | vauth.c: In function `vauth_open_read_getall': | vauth.c:199: `MYSQL_READ_SERVER' undeclared (first use in this function) | vauth.c:200: `MYSQL_READ_USER' undeclared (first use in this function) | vauth.c:200: `MYSQL_READ_PASSWD' undeclared (first use in this function) | vauth.c:200: `MYSQL_DATABASE' undeclared (first use in this function) | vauth.c:201: `MYSQL_VPORT' undeclared (first use in this function) | vauth.c:205: parse error before "rizvi" | vauth.c: At top level: | vauth.c:214: parse error before "return" | vauth.c: In function `vauth_addd
Re: [vchkpw] vpopmail with mysql support
hi here is the all output of make command * cdbmake_add.o make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1/cdb' make[2]: Entering directory `/usr/local/src/vpopmail-5.2.1' gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vpopmail.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c md5.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c bigdir.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vauth.c In file included from vauth.c:32: vmysql.h:26:29: warning: multi-line string literals are deprecated vmysql.h:27:35: warning: multi-line string literals are deprecated vmysql.h:29:39: warning: multi-line string literals are deprecated vmysql.h:30:35: warning: multi-line string literals are deprecated vmysql.h:31:35: warning: multi-line string literals are deprecated vmysql.h:36:38: warning: multi-line string literals are deprecated vmysql.h:37:33: warning: multi-line string literals are deprecated vmysql.h:39:39: warning: multi-line string literals are deprecated vmysql.h:51:35: warning: multi-line string literals are deprecated In file included from vauth.c:32: vmysql.h:55: syntax error before "char" vmysql.h:60:35: warning: multi-line string literals are deprecated vmysql.h:71:24: warning: multi-line string literals are deprecated vmysql.h:79:24: warning: multi-line string literals are deprecated vmysql.h:84:42: warning: multi-line string literals are deprecated vmysql.h:91:27: warning: multi-line string literals are deprecated vmysql.h:59: stray '\' in program vmysql.h:118:2: #else without #if vmysql.h:130:2: #endif without #if vmysql.h:243:2: #endif without #if vauth.c: In function `vauth_open_update': vauth.c:108: `mysql_update' undeclared (first use in this function) vauth.c:108: (Each undeclared identifier is reported only once vauth.c:108: for each function it appears in.) vauth.c:112: parse error before "rizvi" vauth.c:122: parse error before "rizvi" vauth.c: At top level: vauth.c:133: parse error before numeric constant vauth.c:134: warning: type defaults to `int' in declaration of `snprintf' vauth.c:134: warning: data definition has no type or storage class vauth.c:143: warning: type defaults to `int' in declaration of `res_update' vauth.c:143: conflicting types for `res_update' vauth.c:54: previous declaration of `res_update' vauth.c:143: `mysql_update' undeclared here (not in a function) vauth.c:143: warning: initialization makes integer from pointer without a cast vauth.c:143: initializer element is not constant vauth.c:143: warning: data definition has no type or storage class vauth.c:144: warning: type defaults to `int' in declaration of `mysql_free_result' vauth.c:144: warning: parameter names (without types) in function declaration vauth.c:144: conflicting types for `mysql_free_result' /usr/include/mysql/mysql.h:271: previous declaration of `mysql_free_result' vauth.c:144: warning: data definition has no type or storage class vauth.c:147: parse error before "if" vauth.c: In function `vauth_open_read_getall': vauth.c:199: `MYSQL_READ_SERVER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_USER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_PASSWD' undeclared (first use in this function) vauth.c:200: `MYSQL_DATABASE' undeclared (first use in this function) vauth.c:201: `MYSQL_VPORT' undeclared (first use in this function) vauth.c:205: parse error before "rizvi" vauth.c: At top level: vauth.c:214: parse error before "return" vauth.c: In function `vauth_adddomain': vauth.c:228: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:232: `TABLE_LAYOUT' undeclared (first use in this function) vauth.c:234: `mysql_update' undeclared (first use in this function) vauth.c:239: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_adduser': vauth.c:269: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:272: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:311: warning: int format, pointer arg (arg 7) vauth.c:311: warning: format argument is not a pointer (arg 8) vauth.c:311: warning: too many arguments for format vauth.c:313: `mysql_update' undeclared (first use in this function) vauth.c:317: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_getpw': vauth.c:351: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:355: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:365: `mysql_update' undeclared (first use in this function) vauth.c:370: warning: assignment makes integer from pointer without a cast vauth.c:375: warning: passing arg 1 of `mysql_num_rows' makes pointer from integer without a cast vauth.c:394: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vauth_deldomain': vauth.c:425: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:430: `mysql_update' undeclared
Re: [vchkpw] vpopmail with mysql support
I think problem can be in mysql lib files better to check it via ldconfig or make sure password and username is okk for mysql database. Error message which you have attatched with mail is too low. Better to show us output above these lines... -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) "All I want is a few minutes alone with the source code for the universe and a quick recompile." - Original Message - From: "zafar rizvi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 11:23 AM Subject: [vchkpw] vpopmail with mysql support | hi ppl | i am using qmail on linux with vpopmail(5.3.14) support with mysql. But | getting error like that when using with mysql support. | Any body has idea about that error. | | vauth.c: In function `vget_lastauth': | vauth.c:1132: `mysql_update' undeclared (first use in this function) | vauth.c:1139: warning: assignment makes integer from pointer without a cast | vauth.c:1141: warning: passing arg 1 of `mysql_fetch_row' makes pointer from | integer without a cast | vauth.c: In function `vget_lastauthip': | vauth.c:1157: `mysql_update' undeclared (first use in this function) | vauth.c:1164: warning: assignment makes integer from pointer without a cast | vauth.c:1165: warning: passing arg 1 of `mysql_fetch_row' makes pointer from | integer without a cast | vauth.c: In function `vcreate_lastauth_table': | vauth.c:1178: `LASTAUTH_TABLE_LAYOUT' undeclared (first use in this | function) | vauth.c:1179: `mysql_update' undeclared (first use in this function) | vauth.c:1183: warning: assignment makes integer from pointer without a cast | vauth.c: In function `logmysql': | vauth.c:1352: `mysql_update' undeclared (first use in this function) | vauth.c:1359: warning: assignment makes integer from pointer without a cast | vauth.c: In function `vcreate_vlog_table': | vauth.c:1372: `mysql_update' undeclared (first use in this function) | vauth.c:1376: warning: assignment makes integer from pointer without a cast | make[2]: *** [vauth.o] Error 1 | make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1' | make[1]: *** [all-recursive] Error 1 | make[1]: Leaving directory `/usr/local/src/vpopmail-5.2.1' | make: *** [all-recursive-am] Error 2 | ** | | Waiting for a reply | Tx | Zafar | | |
[vchkpw] vpopmail with mysql support
hi ppl i am using qmail on linux with vpopmail(5.3.14) support with mysql. But getting error like that when using with mysql support. Any body has idea about that error. vauth.c: In function `vget_lastauth': vauth.c:1132: `mysql_update' undeclared (first use in this function) vauth.c:1139: warning: assignment makes integer from pointer without a cast vauth.c:1141: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vget_lastauthip': vauth.c:1157: `mysql_update' undeclared (first use in this function) vauth.c:1164: warning: assignment makes integer from pointer without a cast vauth.c:1165: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vcreate_lastauth_table': vauth.c:1178: `LASTAUTH_TABLE_LAYOUT' undeclared (first use in this function) vauth.c:1179: `mysql_update' undeclared (first use in this function) vauth.c:1183: warning: assignment makes integer from pointer without a cast vauth.c: In function `logmysql': vauth.c:1352: `mysql_update' undeclared (first use in this function) vauth.c:1359: warning: assignment makes integer from pointer without a cast vauth.c: In function `vcreate_vlog_table': vauth.c:1372: `mysql_update' undeclared (first use in this function) vauth.c:1376: warning: assignment makes integer from pointer without a cast make[2]: *** [vauth.o] Error 1 make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make: *** [all-recursive-am] Error 2 ** Waiting for a reply Tx Zafar
[vchkpw] Vpopmail with mysql and md5-apop/md5-cram auth
Hello, on an old server i've got a vpopmail-installation without mysql-support. On this system the auth with md5-apop/md5-cram worked well. Now I have a new system with mysql-support (./configure --enable-clear-passwords=y --enable-valias --enable-roaming-users=y --enable-logging=y --enable-defaultquota=1000M --enable-relay-clear-minutes=60 --enable-md5-passwords --enable-auth-logging --enable-log-name=/var/log/vpopmail.log --enable-qmail-ext --enable-mysql=y --enable-mysql-replication=y --enable-large-site=y --enable-libdir=/usr/lib --enable-mysql-logging=y --enable-vpopgroup=vchkpw --enable-apop=y --enable-learn-passwords=y) But md5-driven auth fails, because the auth-process log into the system with a md5-key, which is not the same as the normal password of the user. How can I solve this problem? - Mit freundlichen Grüssen Christian Michel webdesign-centre webdesign-centre Christian Michel Königsbrücker Str. 121b 01099 Dresden Tel.: +49 700 24764243* Fax.: +49 700 24764243* Mobil: +49 177 6762777 Email: [EMAIL PROTECTED] Website: www.w-d-c.net * Hauptzeit : 12 Cent/min Nebenzeit : 6 Cent/min