Dizkus

I tried to upgrade to .723 from .721. When I went through the upgrade process, I get a upgrade finish prompt. When I go to the PostNuke site, I get this message.

mysql://®`-:@localhost/Phoenix failed to connectAccess denied for user: \@localhost' to database 'Phoenix'

I tried copying fresh files and renamed my old config.php file to pn7config.php.

I wold really hate to dump all of my previous table information.

Thanks,
Cliff

I checked the name of my username, password, database name, path.. Everything is entered correctly, as much as I can determine. But this pops up when I try to bring the page up:

mysql://®`-:@localhost/Phoenix failed to connectAccess denied for user: \@localhost' to database 'Phoenix'

Easiest I can suggest is dump the contents of your DB. You did make one first before running the installer right?
Dump the DB contents, clear your cookies and go back to the installer and try again to go at it. Add the fields this way, it sounds like you may not have.

localhost
mydbname_mydbname
mypassword
myname_myname

*do not create DB
*not for intranet use.

Good luck.

--
Friends rock, bullshit walks

Thanks for the suggestions. However, I am trying to do an upgrade and not a new install if possible. I have lots of usernames and data that I would like to retain if possible.

I can create a new database and do a fresh install with no problems. But, for some reason, I am having problems with this upgrade process.

Any help is appreciated.

Cliff

I am having exactly the same situation... hope to see the solution to it.

I wanted to add... I do get to the screen prompt that says the upgrade is finished, but when I go to the site. I still get the error:

mysql://®`-:@localhost/Phoenix failed to connectAccess denied for user: \@localhost' to database 'Phoenix'

How many other people are getting this during the install, and are you installing a new installation, or upgrade? I created a new database and did a new install ok. I would prefer to retain the data for an upgrade. Otherwise it's like starting all over.

Any help is appreciated.

Cliff

Check the value of $pconfig['encoded'] in config.php. 1 means that the DB username and password are base 64 encoded; 0 means these fields are plain text.

-Mark

I am getting the same error message. I looked in config.php and the info is NOT copied in there from pn7config.php like the documentation says. It still has the default info. Another thing I noticed is that when you click the PN version right before the upgrade step, it immediately goes to the next screen that says the installation is finished. It seems like it isn't doing anything. Just skipping to the next screen. I am not even going to bother changing the username/dbname/pass in config.php because I don't think the rest of the process was completed successfully either.

The reply and info from Besheer, is exactly my status as well. I looked at the config.php file, but do not know what to do to fix it.



Should I edit the config files for the correct dbusername, dbpass, dbname? When I look at the pn7config.php file, the dbuname and the dbpass has coded characters instead of straight text.

I hope someone can help us.


Thanks,
Cliff

Cliff, there are tools out there on some websites that will convert the text to coded strings. You can use one of those if you don't want to use regular text. I can't remember the URLs. It's definitely safer that way. I actually ended up changing the info in the config file and got some more errors from the custom theme I was running so I just had to work on the theme files for a while until I got it running. What a pain in the ass :(

Besheer,

Did you change the oldconfig.php file also? It doesn't matter if I use the text or coded. My site has been down for two weeks trying to figure this out.

Cliff

change the coded to 0, and then fill them in plain text, i suggest you change both files. Then to re-encode the username and password, you can use the PostNuke Swiss Army Knife (link in my signature).


hope this helps

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

Cliff, I didn't mess with oldconfig at all.

A big THANK YOU! to everyone that made comments on this thread. Changing the coded to "0", and reentering the username and pass in the config, oldconfig, pn7config files did the trick. I don' know if just the main config file, or all three were required, but this did the trick.

I appreciate the help and support, again THANK YOU!

Cliff