Hi,
Ive been trying to install qmail+mysql. My qmail is running just fine all by itself.
The databse is working, the very first checking step "qmail-getpw " works fine too.
But I have been unable to run checkpassword with qmail and mysql. Its compiled with
the changes, its installed and everything but the test... perl -e 'printf
"user1\0myPass\0Y123456\0"' | ./checkpassword `which id` 3<&0 ... doesnt work. If I
run the same test with a system user it works. I checked the mysql logs and they do
show a query being made with the above command, but nothing is shown or no output is
given with the command. I ran that query in mysql directly and it works and shows the
user, but the perl command doesnt.Here is the query in mysql's logs..
28 Quit
010826 8:29:31 29 Connect qmail@localhost on
29 Init DB qmail
29 Query SELECT id,crypt,uid,gid,home,shell FROM table1
WHERE id='user1' AND active=1
29 Quit
I have edited the Makefile, I added the username, database name and everything in
mysql.c too. Checkpassword is compiled and installed but it wont work. Below I am
pasting the top part of my Makefile for checkpassword.
# Don't edit Makefile! Use conf-* for configuration.
SHELL=/bin/sh
# for mysql...
MYSQL_TOP=/usr
MYSQL_INCLUDE=-I/usr/local/mysql-3.23.40-pc-linux-gnu-i686/include/
MYSQL_LIBS=/usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib/libmysqlclient.a -lm -
lz -lcrypt -lnsl -ldl
SQLSERVERFILE=-DSQLSERVERFILE
QMAILOBJ=auto_qmail.o
ADDCFLAGS=$(MYSQL_INCLUDE) $(SQLSERVERFILE) -DSQLSERVERFILE
ADDOBJS=mysql.o envread.o str_len.o str_diffn.o
#### ORIGINAL PART ######
I think this should be good enough if /var/qmail/control/sqlserver file is to be read.
Please tell me what can go wrong or what problem I may be facing.
Thanks in advance
Nauman
--
_______________________________________________
Talk More, Pay Less with Net2Phone Direct(R), up to 1500 minutes free!
http://www.net2phone.com/cgi-bin/link.cgi?143
