I too am trying to leap over as little of this unix stuff as necessary to the emerald promised beyond of a functional MySQL database-driven webmail application. I have Janet Valade's "PHP & MySQL for Dummies" in one hand, DBMail's readme files in the other, and I'm lost, right here at the beginning.
I have followed the INSTALL file and this thread on OSX and I think I've got dbmail installed (step 3 of the INSTALL read me done!). My entire installation terminal session is included (below). On to step 4 - did a: ./dbmail-adduser a lars secret 0 25000000 [EMAIL PROTECTED] @hedquist.com ...and got: *** dbmail-adduser *** Opening connection to database... Failed. Could not connect to database (check log) (BTW, how do you check the log?) So I did a % mysql -u root -p mysql> SHOW DATABASES; +----------+ | Database | +----------+ | test | +----------+ 1 row in set (0.09 sec) ...so I guess there is no DBMAIL database. Back I go to step 1 of the "INSTALL" readme. Where it says: "First you'll need to create the DBMAIL database in MYSQL. This is easy. You'll need the mysql commandline program for this. Just do : mysql -u root -p < sql/mysql/create_tables.mysql" ... I did EXACTLY this, but I guess it means that you need to do: % mysql -u root -p mysql> CREATE DATABASE DBMAIL; Query OK, 1 row affected (0.11 sec) .. But then what do I do to CREATE TABLE? I would be most grateful if anyone can shed any light. Lars --------------------------------------------- % cd /dbmail-1.2 % ./build.sh This is the dbmail build script I will have to ask you some questions about your system What database do you wish to use? Choices are (m)ysql and (p)ostgresql > m You have selected MySQL as database The library directory for MySQL is now [/usr/local/lib/mysql/]. Enter new directory or press RETURN to keep this setting: /usr/local/mysql/lib/ The include directory for MySQL is now [/usr/include/mysql/]. Enter new directory or press RETURN to keep this setting: The libraries are currently set to [-lmysqlclient -lcrypto]. Enter new libraries (preceed each by -l) or press RETURN to keep this setting: -lmysqlclient -lcrypto -lz ./build.sh: [-f: command not found ./build.sh: [-f: command not found Creating makefile.. ./build.sh: Makefile: Permission denied ./build.sh: Makefile: Permission denied Done. You can now make dbmail by running 'make clean all'. Do you want this to be executed right now? y rm -f *.o core mysql/*.o cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o list.o list.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o debug.o debug.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o pipe.o pipe.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o mime.o mime.c cc -o mysql/dbmysql.o -c mysql/dbmysql.c -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o dbmd5.o dbmd5.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o md5.o md5.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o bounce.o bounce.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o forward.o forward.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o memblock.o memblock.c cc -o mysql/dbauthmysql.o -c mysql/dbauthmysql.c -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o config.o config.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o misc.o misc.c misc.c: In function `itoa': misc.c:50: warning: implicit declaration of function `malloc' cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE main.c -o dbmail-smtp list.o debug.o pipe.o mime.o mysql/dbmysql.o dbmd5.o md5.o bounce.o forward.o memblock.o mysql/dbauthmysql.o config.o misc.o -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. -lmysqlclient -lcrypto -lz cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o pop3.o pop3.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o serverchild.o serverchild.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o server.o server.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o proctitleutils.o proctitleutils.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE pop3d.c -o dbmail-pop3d pop3.o list.o debug.o mysql/dbmysql.o serverchild.o server.o dbmd5.o md5.o mime.o misc.o memblock.o mysql/dbauthmysql.o config.o proctitleutils.o -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. -lmysqlclient -lcrypto -lz cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE maintenance.c -o dbmail-maintenance debug.o list.o dbmd5.o md5.o mysql/dbmysql.o mime.o memblock.o mysql/dbauthmysql.o config.o -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. -lmysqlclient -lcrypto -lz cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o imap4.o imap4.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o imaputil.o imaputil.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o imapcommands.o imapcommands.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o rfcmsg.o rfcmsg.c cc -o mysql/dbmsgbufmysql.o -c mysql/dbmsgbufmysql.c -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. cc -o mysql/dbsearchmysql.o -c mysql/dbsearchmysql.c -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -c -o quota.o quota.c cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE imapd.c -o dbmail-imapd imap4.o debug.o mysql/dbmysql.o serverchild.o server.o config.o list.o dbmd5.o md5.o imaputil.o imapcommands.o mime.o misc.o memblock.o rfcmsg.o mysql/dbmsgbufmysql.o mysql/dbsearchmysql.o mysql/dbauthmysql.o quota.o proctitleutils.o -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. -lmysqlclient -lcrypto -lz cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE user.c -o dbmail-adduser debug.o list.o dbmd5.o md5.o mysql/dbmysql.o mime.o memblock.o mysql/dbauthmysql.o config.o -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -I. -lmysqlclient -lcrypto -lz Make succesfull. Do you want to install the binaries and man pages? y Target binary directory is now /usr/local/sbin. Enter new directory or press RETURN to keep this setting: ./build.sh: install-dbmail.sh: command not found install script failed. You can rerun this manually by running install-dbmail.sh % % sudo ./install-dbmail.sh Password: This script will install dbmail on your system. Before executing this script be sure to have read the INSTALL file. Although dbmail is very easy to install you'll need to know a few little things before you can start using it. If you have any problems, man files will also be installed so you can always check the manpage of a program. Next i'll be asking you as what user and group you want to be running DBMAIL. Best thing is to create a user called dbmail with a dbmail group. Don't forget to edit these users in the dbmail.conf file and run dbmail-config afterwards. The pop3 daemon and the imapd daemon have capabilities to drop their privileges! Use that capability! As what user are the dbmail daemons going to run? [default: dbmail] As what group are the dbmail daemons going to run? [default: dbmail] Ok installing dbmail executables as dbmail:dbmail.. ./install-dbmail.sh: /bin/chown: No such file or directory ./install-dbmail.sh: /bin/chown: No such file or directory ./install-dbmail.sh: /bin/chown: No such file or directory ./install-dbmail.sh: /bin/chown: No such file or directory ./install-dbmail.sh: /bin/chown: No such file or directory Ok installing manfiles in /usr/local/man/man1/.. Done %
