* Lars Hedquist <[EMAIL PROTECTED]> [20031019 09:47]: wrote: > 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?)
All the daemons you are running on your server should (at the minimum for debugging) write log files, yes? So find the startup script for mysql and see the specification for the "logfile", then follow that path and take a look. > 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? :-) The step of doing mysql -u root -p < sql/mysql/create_tables.mysql is the one that creates the tables for you. What you need to do (in your current state) is: mysql -u root -p DROP DATABASE DBMAIL; After that you repeat the step of creating the tables. It also creates the database for you. Look at that file before running it. > > --------------------------------------------- > % 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 If I am not wrong, someone suggested that the file build.sh should be edited to change the [-f to have a space, like [ -f . See the archives. There are paths to executables which need to be changed also. Actually I don't know why the paths to chmod and chown are hard-coded. Since the install script is a shell script, I believe those hard-coded values should be replaced with `which chown` `which chmod` -Wash -- Odhiambo Washington <[EMAIL PROTECTED]> "The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD." GSM: +254 72 743223 +254 733 744121 This sig is McQ! :-) If all the Chinese simultaneously jumped into the Pacific off a 10 foot platform erected 10 feet off their coast, it would cause a tidal wave that would destroy everything in this country west of Nebraska.
smime.p7s
Description: S/MIME cryptographic signature
