Re: [vchkpw] vpopmail 5 with mysql - vauth.c complaining

2003-02-04 Thread Michael Bowe
I think you might have edited the vmysql.h file incorrectly...

Check to make sure you dont have unmatched quotation symbols,
and also make sure you didnt remove the # symbol from the front of
the lines :

   #define MYSQL_UPDATE_USER=someuser
   #define MYSQL_UPDATE_PASSWD=somepass

   #define MYSQL_READ_USER=someuser
   #define MYSQL_READ_PASSWD=somepass

Michael.

- Original Message -
From: Matt Darcy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 7:00 AM
Subject: [vchkpw] vpopmail 5 with mysql - vauth.c complaining


Hi all,

not posted for a while as all has been going well with my mail server.
I have decided to build a new mail server for a friend and I am having a
small problem

I am using mysql 3.23.55 on a linux from scratch server with glibc2.2

I am using vpopmail 5.2.1

I have edited vmysql.h to contain the right username/pass/servername for the
root and read users, and tested them connecting with mysql

I run this VERY long configure option

./configure --enable-qmaildir=/var/qmail --enable-vpopuser=vpopmail --enable
-vpopgroup=vchkpw --enable-roaming-users=y --enable-tcpfules-prog=/usr/local
/bin/tcprules --enable-tcpserver-file=~vpopmail/etc/tcp.smtp --enable-relay-
clear-minutes=120 --enable-learn-passwords=n --enable-md5-passwords=y --enab
le-auth-logging=y --enable-mysql-logging=y --enable-clear-passwd=y --enable-
logging=e --enable-log-name=vpopmail --enable-mysql=y --enable-sqlincdir=/us
r/local/mysql/include/mysql --enable-sqllibdir=/usr/local/mysql/lib/mysql --
enable-incdir=/usr/include --enable-libdir=/usr/lib --enable-valias=y --enab
le-default-domain=mdlan.co.uk

which seems to go ok, but when I issue make it starts complaining about a
lot of mysql functions and some C files.

(sorry for the long error message but I think there are 2 problems here)

vauth.c:200: `MYSQL_READ_PASSWD' undeclared (first use in this function)
vauth.c:204: `MYSQL_UPDATE_SERVER' undeclared (first use in this function)
vauth.c:205: `MYSQL_UPDATE_USER' undeclared (first use in this function)
vauth.c:205: `MYSQL_UPDATE_PASSWD' undeclared (first use in this function)
vauth.c: In function `vauth_adddomain':
vauth.c:239: warning: assignment makes pointer from integer without a cast
vauth.c: In function `vauth_adduser':
vauth.c:314: warning: format argument is not a pointer (arg 2)
vauth.c:317: warning: assignment makes pointer from integer without a cast
vauth.c: In function `vauth_getpw':
vauth.c:366: warning: format argument is not a pointer (arg 2)
vauth.c:370: warning: assignment makes pointer from integer without a cast
vauth.c:375: warning: implicit declaration of function `mysql_num_rows'
vauth.c:394: warning: implicit declaration of function `mysql_fetch_row'
vauth.c:395: subscripted value is neither array nor pointer
vauth.c:395: subscripted value is neither array nor pointer
vauth.c:395: subscripted value is neither array nor pointer
vauth.c:395: subscripted value is neither array nor pointer
vauth.c:395: subscripted value is neither array nor pointer
vauth.c:396: subscripted value is neither array nor pointer
vauth.c:396: subscripted value is neither array nor pointer
vauth.c:396: subscripted value is neither array nor pointer
vauth.c:396: subscripted value is neither array nor pointer
vauth.c:396: subscripted value is neither array nor pointer
vauth.c:396: subscripted value is neither array nor pointer
vauth.c:397: subscripted value is neither array nor pointer
vauth.c:397: subscripted value is neither array nor pointer
vauth.c:398: subscripted value is neither array nor pointer
vauth.c:398: subscripted value is neither array nor pointer
vauth.c:399: subscripted value is neither array nor pointer
vauth.c:399: subscripted value is neither array nor pointer
vauth.c:399: subscripted value is neither array nor pointer
vauth.c:399: subscripted value is neither array nor pointer
vauth.c:399: subscripted value is neither array nor pointer
vauth.c:399: subscripted value is neither array nor pointer
vauth.c:400: subscripted value is neither array nor pointer
vauth.c:400: subscripted value is neither array nor pointer
vauth.c:400: subscripted value is neither array nor pointer
vauth.c:400: subscripted value is neither array nor pointer
vauth.c:400: subscripted value is neither array nor pointer
vauth.c:400: subscripted value is neither array nor pointer
vauth.c:401: subscripted value is neither array nor pointer
vauth.c:401: subscripted value is neither array nor pointer
vauth.c:401: subscripted value is neither array nor pointer
vauth.c:401: subscripted value is neither array nor pointer
vauth.c:401: subscripted value is neither array nor pointer
vauth.c:401: subscripted value is neither array nor pointer
vauth.c:403: subscripted value is neither array nor pointer
vauth.c:403: subscripted value is neither array nor pointer
vauth.c:403: subscripted value is neither array nor pointer
vauth.c:403: subscripted value is neither array nor pointer
vauth.c:403: subscripted value 

Re: [vchkpw] vpopmail 5 with mysql - vauth.c complaining

2003-02-04 Thread Matt Darcy
 nor pointer
 vauth.c: In function `vget_lastauthip':
 vauth.c:1160: warning: format argument is not a pointer (arg 2)
 vauth.c:1164: warning: assignment makes pointer from integer without a
cast
 vauth.c:1166: subscripted value is neither array nor pointer
 vauth.c:1166: subscripted value is neither array nor pointer
 vauth.c:1166: subscripted value is neither array nor pointer
 vauth.c:1166: subscripted value is neither array nor pointer
 vauth.c:1166: subscripted value is neither array nor pointer
 vauth.c: In function `vcreate_lastauth_table':
 vauth.c:1180: warning: format argument is not a pointer (arg 2)
 vauth.c:1183: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `valias_select':
 vauth.c:1205: warning: format argument is not a pointer (arg 2)
 vauth.c:1209: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `valias_select_next':
 vauth.c:1216: subscripted value is neither array nor pointer
 vauth.c: In function `valias_insert':
 vauth.c:1236: warning: format argument is not a pointer (arg 2)
 vauth.c:1240: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `valias_delete':
 vauth.c:1258: warning: format argument is not a pointer (arg 2)
 vauth.c:1262: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `valias_delete_domain':
 vauth.c:1280: warning: format argument is not a pointer (arg 2)
 vauth.c:1284: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `vcreate_valias_table':
 vauth.c:1296: warning: format argument is not a pointer (arg 2)
 vauth.c:1299: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `valias_select_all':
 vauth.c:1316: warning: format argument is not a pointer (arg 2)
 vauth.c:1320: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `valias_select_all_next':
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1327: subscripted value is neither array nor pointer
 vauth.c:1328: subscripted value is neither array nor pointer
 vauth.c: In function `logmysql':
 vauth.c:1359: warning: assignment makes pointer from integer without a
cast
 vauth.c: In function `vcreate_vlog_table':
 vauth.c:1376: warning: assignment makes pointer from integer without a
cast
 make[2]: *** [vauth.o] Error 1
 make[2]: Leaving directory `/usr/local/src/qmail/vpopmail-5.2.1'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/usr/local/src/qmail/vpopmail-5.2.1'
 make: *** [all-recursive-am] Error 2

 - Original Message -
 From: Michael Bowe [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, February 04, 2003 8:27 PM
 Subject: Re: [vchkpw] vpopmail 5 with mysql - vauth.c complaining


  I think you might have edited the vmysql.h file incorrectly...
 
  Check to make sure you dont have unmatched quotation symbols,
  and also make sure you didnt remove the # symbol from the front of
  the lines :
 
 #define MYSQL_UPDATE_USER=someuser
 #define MYSQL_UPDATE_PASSWD=somepass
 
 #define MYSQL_READ_USER=someuser
 #define MYSQL_READ_PASSWD=somepass
 
  Michael.
 
  - Original Message -
  From: Matt Darcy [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Wednesday, February 05, 2003 7:00 AM
  Subject: [vchkpw] vpopmail 5 with mysql - vauth.c complaining
 
 
  Hi all,
 
  not posted for a while as all has been going well with my mail server.
  I have decided to build a new mail server for a friend and I am having a
  small problem
 
  I am using mysql 3.23.55 on a linux from scratch server with glibc2.2
 
  I am using vpopmail 5.2.1
 
  I have edited vmysql.h to contain the right username/pass/servername for
 the
  root and read users, and tested them connecting with mysql
 
  I run this VERY long configure option

RE: [vchkpw] vpopmail 5 with mysql - vauth.c complaining

2003-02-04 Thread Michael Bowe
 -Original Message-
 From: Matt Darcy [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, 5 February 2003 7:46 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [vchkpw] vpopmail 5 with mysql - vauth.c complaining

 
  good advice on the # marksfixed the sql problem however still 
  getting the C problem
 
  Any more comments ?

Maybe compare your setup steps against my guide at
http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm

Michael.