Zikula Community

Ok .. Ive read the FAQ .. there vague to say the least. Im getting a error when i get about 60% through the install.

The error is

Warning: mysql_connect(): Access denied for user: "soandso@localhost' (Using password: YES) in C:\Inetpub\wwwroot\pnadodb\drivers\adodb-mysql.inc.php on line 237 Error connecting to DB Program:C:\Inetpub\wwwroot\install\db.php - Line N.: 45 Database phoenix Error (1045) : Access denied for user: "soandso@localhost" (Using password: YES)

I see a couple other threads about this, but no one has offered another solution but to read the FAQ, and that doesn't really tell you much either.
Can someone offer A real solution to this. Maybe something i can do to try to fix it, anything but sending me to the FAQ. Ive been there. Its not helping my situation.

I don't know what to do. I can access the install no prob, until i have to create a database. Its installing the folder in mysql, but.. Im lost. Is there anyway i can start over fresh .. something.. just to get through this somewhat difficult install?? Can someone please help. I would really appreciate it. Thanks.

Sorry if you feel the FAQ isn't detailed enough but it's a simple as what's stated there. If PHP reports that access is denied to that user, then that user doesn't have access. It's as plain as that. The solution is make sure you're using the right info.

Ive tried all i can .. I don't know what else to do. Im logged in with the only account on XP .. and its a admin account. Ive given the database a user name and pass, Ive set the exact same user name and pass in the config.php .. and i get the same thing over and over, and Ive even tried on 3 different machines. So .. what can you offer me to help figure out why i cant get it to install on any machine with full admin rights. Is there something with mysql i didn't setup? Is there some sort of settings in phpadmin that i need to deal with? I haven't touched any of them. Im just trying to get a clean install.

This makes you want to rip your hair out after trying to get it to work for over 7 hours.....

Ive used the psak.php file.. it says the same error. Ive tried to encrypt the password. Still does the same thing. Maybe you can explain how i can give access.

Did you give the user you created in MySQL the proper permissions to the database?

And how do i check that? And how do i set it if it isn't set right?

Its that something i read about he config.php needing 666 access or rw-rw-rw ?

Im still very confused and getting no where fast. Thanks for trying to help though I appreciate it.

Well .. Im still unable to create a database. On three different computers.

Actually .. its creates the folder, but it will no populate it with any information. Ive get the same spot on each computer (60%), and then i cant get any further. So .. its obvious im not doing something right. Can some one please help me out. I think im going insane. Ive tried everything i can do. I will even give some vnc access to help.

Its obvious there is a setting that i don't know about. Ive hard coded everything in each file, and it still doesn't work on three different machines.

Can someone please tell me what im not doing right, and possible give me a step by step checklist to ensure i have all the settings right. I feel like crying at this point. :(

Please help. Thanks

What kind of platform are you hosting on? Windows, Linux? Who's your host, is this on your local computer or a remote host?

All the machines Ive tried to install on are Windows XP Pro. These computers are at my house. This website will be on my own home network. I have IIS installed. I have php4 installed. I have Mysql Installed.

Sounds like your problem has nothing to do with PostNuke and everything to do with your installation of PHP with mysql support, IMHO.

If that sounds like it might be true, have a look at this thread:
http://forums.postnuke.com/index.php?name=PNphpBB2&file=viewtopic&t=26406

-=dave=-

p.s. A quick and dirty test would be to create a phpinfo.php file on your site, see this thread:
http://forums.postnuke.com/index.php?name=PNphpBB2&file=viewtopic&t=26868&highlight=phpinfo
If you cannot get that to run, chances are you don't have a proper php/mysql installation yet. Again, I am pretty certain your problems are deeper than just PostNuke...

I give up! Ive never had anything make me so freakin mental in my life. Good God. This install is ridiculous to say the least.

I've hard coded my user name and pass in the php.ini the config.php, my.ini, you name it. It will still not connect. Access denied for user@localhost.

The actual error when i DO try to create a database is....




The error in the first post is what i get when i try to create a database.
Ive read through those threads, and i don't see anything that helps me with this situation. I understand where your going with it, but im not sure what i haven't done right in the first place. Thanks though.

Can someone give me a hint of the files, and small directions on how to give access to the only ADMIN logged in? Or maybe how to configure PHP to work with mysql??

From what im reading it says that PHP 4.3.3 now comes with mysql support, so i shouldn't need to adjust anything.. but im clueless at this point. Im ready to throw in the towel. I shouldn't have to get this mental over a program that wont install after 3 days of hard work, and hard coding everything in all files.

Theres has got to be someone that has been through this exact same thing before, and figured out what it was that was causing the problem and be able to describe in detail what needs to be done to move on. How bout some directions or maybe a check list to go through. Something concrete.

PostNuke is not the problem, your understanding of MySQL is the problem. I suggest you visit a site like SitePoint.com and read up on some of their articles on MySQL & PHP. What you are needing help with is outside the scope of support these forums provides.

Ok, Thanks for your help.

I have finally fixed my problem and installed PostNuke. I would hate for anyone to go through what i have trying to install this. If you have had the exact problem i describe in this post, you need to do this.

When you get to 50-60% you need to set the user name as "root" and the password as "blank" even if its different in your configs, and ini files. I guess "root" and "blank" are the default passwords for mysql. Go figure. I hope this helps someone. You really don't want spend your whole weekend trying to figure a PostNuke install. It Blows.

Good Luck.

Again the problem is not PostNuke but your understanding of mysql. The way you have mysql setup is with this username and password. The mysql installation docs outline setting up a database user so you either chose these or the mysql installation package you used set these up for you. Read the mysql docs for how to change this.

By attempting not only to use PostNuke for the first time but (at a guess) use mysql and PHP for the first time you taken possible the hardest route to a PN site. With a working server setup installing PN is a 10 minute job. If you have no server setup and have no experience of creating one then you have a very steep learning curve before you can even get to install PN properly (as you've found).

Now you have your server setup running be sure to stay on top of all security patches for these products, make sure to upgrade each component on a regular basis as well as making good system backups. In short server administration is not a trivial job.....

-Mark

Actually, you should NEVER use the root account to install a script. You should create a user and give that user the proper access to the database.