Access denied for user 'wwwrun'@'localhost' (using password:

All about webserver configurations, PHP and databases.

Moderator: Thorsten

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Access denied for user 'wwwrun'@'localhost' (using password:

Post by brainray » Sun Mar 09, 2008 1:44 am

Hello,

while trying to install phpmyfaq I got the follow error message:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (28000/1045): Access denied for user 'wwwrun'@'localhost' (using password: NO) in /www/htdocs/w009a6b8/faq/inc/PMF_DB/Mysqli.php on line 66

The connection to the database server could not be established.

The error message of the database server:
Access denied for user 'wwwrun'@'localhost' (using password: NO)
It looks like the database was not setup porperly, but it's there. I tried to change things a few times, but now I'm puzzled.

Thanks in advance for any help

Ray

Thorsten
Posts: 14792
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Mar 09, 2008 9:49 am

Hi,

did you ran the installation script?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Post by brainray » Sun Mar 09, 2008 11:23 am

Hi,

yes I ran the installer script and inserted the database data etc. into the fields. Any ideas?
Many thanks

Ray

Thorsten
Posts: 14792
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Mar 09, 2008 11:28 am

Hi,

is everything correct in inc/data.php?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Post by brainray » Sun Mar 09, 2008 11:40 am

Hi,

yes, the same data that I entered into the installer script.

Well, I was not 100% sure if the SQL sever host address is correct the way I entered it. Might that have caused the next step to proceed?

Thanks again

Ray

Thorsten
Posts: 14792
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Mar 09, 2008 11:42 am

Hi,

is inc/data.php readable for the webserver? The database class uses the default values and that causes your problems.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Post by brainray » Sun Mar 09, 2008 11:54 am

Hi,

permissions are 644, so reading should work, right?

Thanks

Ray

Thorsten
Posts: 14792
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Mar 09, 2008 11:57 am

Hi,

I think you need 755... the webserver has to execute the PHP files. :)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Post by brainray » Sun Mar 09, 2008 12:31 pm

Hi,

okay, brilliant! I then did an update - I hope it was right.

At the end of the update on step 5 the script says:
Warning: Invalid argument supplied for foreach() in /www/htdocs/w009a6b8/faq/install/update.php on line 1613

The index.php shows a white page. After turning debugging on it says:
Fatal error: Call to a member function fetch_object() on a non-object in /www/htdocs/w009a6b8/faq/inc/PMF_DB/Mysqli.php on line 124
Might that result from wrong database setup? Which is the best way to continue?

Many thanks again for your valued help!

Ray

Thorsten
Posts: 14792
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Mar 09, 2008 12:38 pm

Hi,

why did you an update? You don't need one after a fresh installation.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Post by brainray » Sun Mar 09, 2008 12:52 pm

Hi,

hmmm, sorry. I think it was the my best guess how to proceed. Should I go for a new installation? I wouldn't matter to do so.

Thanks again

Ray

Thorsten
Posts: 14792
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Mar 09, 2008 12:53 pm

Hi,

yes, please try a fresh installation.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Post by brainray » Sun Mar 09, 2008 5:00 pm

Hello again,

I did a fresh installation and also got a response from my provider regarding the SQL server host, which is localhost btw :-/

Okay, I also got the same error message while installing, then set the permissions for inc/data.php to 755. Where should I go now? The tables in the database have not yet been created, so I think there must be a way to continue the installation :-)
Thanks again

Ray

Thorsten
Posts: 14792
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Mar 09, 2008 7:11 pm

Hi,

please try 777 for inc/data.php during the installation.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

brainray
Posts: 10
Joined: Sun Mar 09, 2008 12:13 am

Post by brainray » Mon Mar 10, 2008 11:22 am

Hi,

I tried 777 for data.php.original before installation. But when I install, the script seems to create a data.php file that has 644 and the installation stops.

How can I continue the installation? If I call the installer script, I get the message
It seems you're already running a version of phpMyFAQ.
Please use the update script.
Since updating is not the right choice, what would be the right one?

Many thanks again

Ray

Post Reply