Support Forum

I'm new at this so please forgive my ignorance. I'm trying to install some forums for work. I'm having problems with the installer. Every time I get past the 60% point I get this error message:

Quote

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root\@\localhost' (using password: YES) in /Library/WebServer/Documents/PostNuke/html/install/newinstall.php on line 37

Warning: mysql_query() [function.mysql-query]: Access denied for user 'root\@\localhost' (using password: NO) in /Library/WebServer/Documents/PostNuke/html/install/newinstall.php on line 38

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /Library/WebServer/Documents/PostNuke/html/install/newinstall.php on line 38
Unable to make database

I checked out the FAQs section, but all it said is that I have a problem with my PHP and to contact the Administrator. Unfortunately I am the administrator, the boss is too cheap to hire someone who knows what he's doing.

At the moment I'm running the site on a Power Book running OSX 10.3.9, Apache 1.3, the latest versions of PHP and MySQL.

Could someone please point me to what the problem could be in the PHP files? Any help would be greatly appreciated.

Your MySQL details are wrong in some way, and PostNuke can't connect to the database.

-----
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

In fact, the problem is simple and quite normal for a newbie (I'm one of them).

NOTE : My station is running on WiNDOWS.

Here's more explanation :
During the install of PostNuke, you have to fullfill these text fields :
- DB user
- DB password
- DB name
- DB prefix

DB user is the name of the person who is allowed to access to the database : by default, it is 'root'.

DB password is the password used for the access to the database, it might be something like ... nothing (blank).

DB name is the name of your database.

DB prefix is used for the sharing of the tables (lex. [DB name]_nuke).

In your 'local' configuration (testing site), you're the one who is allowed to access your MySQL tool entirely (to administrate your DB).

But when you decide to put your site on a distant server, it won't be you anymore but the administrator of the server.

So try to enter (local) :
- DB name : root
- DB password : (blank)
- DB name : (any)
and create the database.

GENERAL ADVISE : for security reasons (local or distant), you had to modify this password. Try to understand the tool who gives you the ability to administrate 'in clear' your SQL database ('phpMyAdmin' like...on OSX) or search for tutorials.

In the 'mysql' folder, you'll probably find the 'MySQLadmin.exe' file.

Lauch this and search for parameters commands to change your DB password.
You'd better choose the 'HTTP Authentication method' rather than the 'cookie or config Authentification method' to access your DB (depends on your tool to administrate 'in clear' your database).

You can also define a specific database (that can be used as DB name - in that case, don't create your DB when PN install ask for it !) and a specific user of the database by setting 'Specific privileges to a DB' in the tool above (it would be the same in a 'distant' configuration).

Maybe OSX users can give you more help... :?

Thanks for the suggestions. I do have a bit of experience with MySQL and PHP, but not with PostNuke. I guess I should have mentioned:

I'm using localhost for the location, root for the user and I changed MySQL's password back to none. I'll try pre-making a database to install to then I'll let you know.

When I check the error in the FAQ it says my PHP is configured incorrectly, but doesn't get into what specifically the problem is. Does this mean in my config.php file? What should it look like?

Any other suggestions or comments would be appreciated.

Ok, I just tried the instillation by creating a database first then leaving it empty, but I'm still getting an error:

Quote

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root\@\localhost' (using password: NO) in /Library/WebServer/Documents/PostNuke/html/includes/classes/adodb/drivers/adodb-mysql.inc.php on line 350
Error connecting to DB
Program: /Library/WebServer/Documents/PostNuke/html/install/db.php - Line N.: 45
Database: pn_test
Error (1045) : Access denied for user 'root\@\localhost' (using password: NO)