Re: PHP5: Initial connection to the MySQL server is carried out using the apache webserver userid

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Feb 20, 2009, at 11:24 AM, Paul Will wrote:

Hi,

When I attempt to connect to a MySQL database I have noticed that the
initial connection is made using the "wwwrun" userid (this is the userid
that my Apache2 webserver is running under.)


This is the output I see from the Firefox "View Frame Info Function"

Notice: Undefined index:  db in /srv/www/htdocs/LMsummary.php5 on line
23
<br>

<snip>

Warning: mysql_connect(): Access denied for user 'wwwrun'@'localhost'
(using password: NO) in /srv/www/htdocs/LMsummary.php5 on line 28
<br>Unable to connect to MySQL server, check userid and password are correct.

However when I examine the values passed to the PHP script used in the mysql_connect() function I find that they are correct and as they should be, and it appears that for some reason details of the wwwrun userid is being passed to the mysql database prior
to the correct ones. Is this normal?

I should state that subsequent to this error the PHP connection to the MySQL server proceeds normally and the database is read OK and the pages are correctly compiled. The phpinfo() function also shows that the indexes apparently contain the correct values.

It would be helpful if you posted the actual connection code (with the credentials dummied out obviously). Otherwise, we all can only guess what's going on :)

The DB issue: If the values are not being properly passed to the connect function, php will use default values, but post the code if you need more support...

Index issue: index problem probably refers to using global variables e.g. $_GET. I googled "php list Notice: Undefined index:" and got http://www.dmxzone.com/go?13811 as my first hit. Check it out to see if that fits.

For faster, easier results next time, search your error on Google first - you may get an easy answer to a common question and avoid waiting for a response on the list.

Cheers!

Sean DeNigris
sean@xxxxxxxxxxxxxxxx

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux