Re: [SM-STABLE] Squirrelmail database error

[ODHIAMBO W. <wa...@wa...>]

* Jason 'XenoPhage' Frisvold <fr...@go...> [20030619 15:46]: wrote:
> On Wed, 2003-06-18 at 22:36, p dont think 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)
>=20
> > have you read:
> >=20
> > http://www.squirrelmail.org/wiki/en_US/MySQL
>=20
> I did now...  :)
>=20
> > or the doc/db-backend.txt file?
>=20
> Yup.. been there, done that..
>=20
> > sample DSN - does yours look similar?
> >=20
> > mysql://squirreluser:sqpassword@localhost/squirrelmail
>=20
> I tried 2 different DSN's...  The first was identical to the one above
> (with different user/pass of course) and the second was something like
> this :
>=20
> mysql://squirreluser:sqp...@my.../squirrelmail
>=20
> Just a remote database machine...
>=20
> Neither worked, I got the same error...  I'm thinking it's a PHP thing,
> but I have no idea how to debug PHP...  Is there anything I can set to
> turn on debugging?


The error message is on the remote database machine - on the MySQL server
logs.
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
=66rom anywhere (%) or from some.machine.com.
I believe the command, to be executed on the my.database.com, as root user,
is

mysql -e 'update user set Host=3D'%' where User=3D'squirreluser'';=20

OR

mysql -e 'update user set Host=3D'some.domain.com' where User=3D'squirrelus=
er'';


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=3Dmysql --datadir=3D${DB_DIR} --pid-file=3D${PI=
DFILE} > /dev/null &

to

/PATH/TO/mysqld_safe --user=3Dmysql --log=3D/path/to/logfile --datadir=3D${=
DB_DIR} --pid-file=3D${PIDFILE} > /dev/null &
                                  ^^^^^^^^^^^^^^^^^^^^^^

chown mysql_user /path/to/logfile

then stop, start mysql server....


YMMV.






-Wash

--=20
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."  =20
GSM: +254 72 743223   +254 733 744121       This sig is McQ!  :-)


If a President doesn't do it to his wife, he'll do it to his country.