Re: [SM-USERS] mysql setup problems

[Simon D. <si...@ir...>]

On Sun, 2002-06-30 at 21:47, Gerry Doris wrote:
> I'm having problems getting mysql to work correctly with SM and would like 
> a few hints!
> 
> I'm using Redhat 7.3 and have installed both SM 1.2.7 and mysql.  SM works
> great without mysql.  I created a database per the instructions called sm.  
> It has two tables called address and userprefs per the docs.
> 
> I'm confused about who the user should be for this.  I'm assuming it 
> should be apache?  In any case, I can access the database by running
> 
> mysql -p -u apache
> 
> and entering the password so I believe mysql is working properly.
> 
> I've cp'd the db_prefs.php over to prefs.php and gone into conf.pl and
> made the following changes for the two dns lines (options 1 & 3 of the
> database setup):

The copying of the file hasn't been necessary since before SM 1.2.6.

> mysql://apache:password@localhost/sm
> 
> where password is replaced by my actual password.
> 
> When I try and connect to SM there is an php error about not being able to
> access the db???  What am I doing wrong??

It's hard to tell from the details you've given, first I'd suggest
replacing your prefs.php with the proper version from your original
archive and if that doesn't help try sending the actual error messages
to the list so we have a bit more information to go on..

Best of luck!

-- 
Simon Dick					si...@ir...