From: ODHIAMBO W. <wa...@wa...> - 2003-06-20 07:03:30
|
* p dont think <pdo...@an...> [20030620 09:59]: wrote: > > > > > > > Squirrelmail 1.4.0 > > > > > > > Apache 2.0.40 (RH 8.0 RPM) > > > > > > > PHP 4.2.2 (RH 8.0 RPM) > > > > > > > Courier IMAP 1.7.0 > > > > > > > Qmail 1.03 > > > > > > > VPopMail 5.3.20 > > > > > > > MySQL 4.0.13 (RPM's) > > > > > > > The error message is on the remote database machine - on the MySQL > > server > > > > logs. > > > > > > That's just it.. There *is* no message in the logs. It's never > getting > > > that far. I've tried turning on logging on the mysql server, logged > in > > > myself from the command line just to make sure that logging was > working > > > and would show what I needed, and then tried it with SQMail... I > get > > > absolutely no connection to mysql.. No error, nothing. It's like > the DB > > > calls are just failing. > > > > > > My only guess is that it's the DSN, but I've followed the directions > to > > > a T! > > > > > > > What I think you could be missing is the fact that you need to > tell > > the > > > > my.database.com that the user squirreluser is allowed to connect > > either > > > > from anywhere (%) or from some.machine.com. > > > > > > *nod* This is done... (BTW, % is not a good idea, security wise..) > > > > > > > I believe the command, to be executed on the my.database.com, as > root > > user, > > > > is > > > > > > > > mysql -e 'update user set Host='%' where User='squirreluser''; > > > > > > > > OR > > > > > > > > mysql -e 'update user set Host='some.domain.com' where > > User='squirreluser''; > > > > > > > > > > > > To turn on logging in mysql (on the remote MySQL server), look for > the > > > > startup script for mysql and change the line > > > > > > > > /PATH/TO/mysqld_safe --user=mysql --datadir=${DB_DIR} --pid- > > file=${PIDFILE} > /dev/null & > > > > > > > > to > > > > > > > > /PATH/TO/mysqld_safe --user=mysql --log=/path/to/logfile -- > > datadir=${DB_DIR} --pid-file=${PIDFILE} > /dev/null & > > > > ^^^^^^^^^^^^^^^^^^^^^^ > > > > > > > > chown mysql_user /path/to/logfile > > > > > > > > then stop, start mysql server.... > > > > > > I'm mySQL Core Certified (See signature below) ... I'm absolutely > > > positive I have mySQL set up correctly. I have other database stuff > > > running all over... > > > > > > I'm looking for debugging stuff in PHP so I can see what's going on > > > there. If the DB call is failing, there's gotta be an error > somewhere! > > > > > > The debugging stuff for php are in php.ini. The comments are self- > > explanatory. > > You could also add > > > > ErrorLog /path/to/some/file > > > > for the virtuslhost underwhich you are running squirrelmail (just in > case). > > specifically (sorry I didn't mention this): > > display_errors = on > error_reporting = E_ALL Now I am stumped ;) I haven't tried the DSN myself. -Wash -- Odhiambo Washington <wa...@wa...> "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! :-) Alden's Laws: (1) Giving away baby clothes and furniture is the major cause of pregnancy. (2) Always be backlit. (3) Sit down whenever possible. |