Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Jan Skovsgaard on May 23, 2002, 10:17:37 PM

Title: Postnuke db access denied
Post by: Jan Skovsgaard on May 23, 2002, 10:17:37 PM

I am running a 5.1.2 blade1. When I'm doing the PostNuke install.php I get this message:

Error connecting to db
Program: /home/e-smith/files/primary/html/pn_714/install/db.php - Line N.: 45
Database: rogue
Error (1044) : Access denied for user: 'jan@localhost' to database 'rogue'

I've manually setup the rogue database and followed Jean-Louis Boers' how to. No problem accessing mysql when I verify the new user account: # mysql --user=jan --password='password_for_jan'. When I use root as user and the password in install.php I still get this message. And yes, I modified the config.php in every step. I haven't tried 'service mysql stop' and doing the "skip-grant-tables" thing, as I see it everything is OK in mysql. Any ideas???

Title: Re: Postnuke db access denied
Post by: Des Dougan on May 24, 2002, 06:55:30 AM

Don't use root as the user - use "jan" and its password. In install.php, use the same name/password you set up per the HowTo:

dbuname <-- in our example this is user nuke
dbpassword <-- the password you made for user nuke
dbname <-- in our example, the database name is Rogue

Des Dougan

Title: Re: Postnuke db access denied
Post by: Jan Skovsgaard on May 24, 2002, 11:18:30 AM

I don't use root as user, just tried it in frustration. I've modified config.php according to the mysgl user jan

dbuname <-- in my example this is user jan
dbpassword <-- the password I made for user jan
dbname <-- in my example, the database name is Rogue

Title: Re: Postnuke db access denied
Post by: Micke on May 26, 2002, 02:33:07 AM

Hi!

Try this:

Log in as root on your server and type this

mysqladmin create rogue   (hit enter)

mysql (hit enter)
type this --> grant all privileges on rogue to rogueuser@localhost identified by 'roguepassword';  (hit enter)
Then type exit or quit (hit enter)

Now u have make your DB

now u must edit config.php -->

dbuname: rogueuser
dbpassword: roguepassword
dbname: rogue

--------------------------------------------------------
I don't use root as user, just tried it in frustration. I've modified config.php according to the mysgl user jan

dbuname <-- in my example this is user jan
dbpassword <-- the password I made for user jan
dbname <-- in my example, the database name is Rogue

Title: Re: Postnuke db access denied
Post by: Dan Brown on May 26, 2002, 07:04:20 AM

I'm not 100% positive, but I think that should be "grant all [privileges] on rogue.* ..."  I know "privileges" is optional.

Title: Re: Postnuke db access denied
Post by: Jan Skovsgaard on May 26, 2002, 01:29:21 PM

Yesterday I installed phpBB2 and followed Dan Browns how to. No problem at all.
I went back to the postnuke installation and used the syntax from phpBB2:

mysql> grant all privileges on rogue.* to nukeuser@localhost identified by 'xxxxx';
Query OK, 0 rows affected (0.04 sec)
mysql> flush privileges;

And now everything is OK, so Dan and everybody - thanks!

It seems like my Box have some fairly long responsetimes when I'm using these php/mysql applications. Could it be a hardware issue?