odd Access denied for user problem

[PickledOnion]

New to the board but read a lot! So I have done a search on this and the only thing that came close was this thread which never got answered: here

I have a small garden pictures site where I can add pictures with descriptions, edit them, delete them, etc in the admin side and select and view them on the public side.

Everything was fine until yesterday when I tried it on another computer.

On the admin side, I can select a picture from the database and then click on it to go to the edit page.

Then I get the:

Warning: mysql_query(): Access denied for user: 'apache@localhost' (Using password: NO)
in /var/www/localhost/htdocs/mygardenpictures/4dm1n5/edit_picture.php on line 50

Now very important point here: it is not something wrong with my mysql_connect script or I wouldn't be able to select a picture to edit in the first place (make sense?)

In other words, it connects fine, selects fine, until I go to a second page with the same mysql_script (I require_once to get it). Then it refuses access to the db.

I'm not sure what else to put at the moment. I have done the usual check the sql, etc, it all works perfectly, and as I say it worked until I put it into the new computer.

The config files (php, apache, my.cnf, etc) are exactly the same on both machines. Usernames and permissions are exactly the same on both machines.

Any suggestions? Obviously I can post anything else you need or attach the script, although, as I say, it works perfectly on another machine...

[bastien]

localhost is the only computer that that account can use...you need to create a user that access the db from anywhere

have a look here

[PickledOnion]

Many thanks for the reply but that is not the problem.

The problem is that it does access the database...then stops.

It accesses it three times and displays the results perfectly in one page (in assessing the object_id, then selecting a list to define a drop down list and then again, showing the full row for the selected object).

Only then does the error occur. Using (an already used) simple SELECT command, using the same mysql_connect script that is used in the previous page that works perfectly well three seperate times (it is the same script as it acquired by using the require command).

See the twist to this one? It suddenly won't allow what is essentially the same script to access the database (the select command is a simple SELECT * from table, a command already used perfectly well).

I also did try changing the user details but to no avail. It still works perfectly well and then stops. Perhaps there is a mysql setting that limits the number of queries?

Any other suggestions gratefully recieved 🙂

[bastien]

what is your script like? can you post the code for the page that fails? What about the php ini file? and the mysql setup?

log into your mysql admin gui and run show variables is there something in there that limits the connections to a low number?

Maybe contact your host and ask if there is something they limited. ask tthem to check the apache log files to look for error messages there

[PickledOnion]

Thanks for the swift response.

It is on my computer at home, I am in the middle of designing the site.

Anyway, just this minute I changed the require_once commands to require and all is well.

The new error is

Cannot redeclare escape_data() (previously declared in....

I included the escape_data function in the mysql_connect.php file to save having it in every file.

I vaguely understand what is happening here: this setup doesn't like redeclaring anything more than once (I know that's not technically phrased!), but it is something to watch out for and learn from.

I don't know why it was ok before when all the versions of php/mysql/apache/mod_php, etc are all the same and the config files are exactly the same (physically diffed those for any differences).

Anyway, thanks for the help and it is something I will look into and I may find the answer to that one on the boards somewhere. This is an excellent forum for finding most answers to simply by searching.

Cheers

PickledOnion

edit:

Just for interest, I have sorted it out and simply have the escape_data function (it checks for magic_quotes_gpc in the php.ini and stripslashes, etc from the form data) as a seperate php script, which is called as necessary.

Probably better programming practice like that anyway,

[Roger_Ramjet]

I think you have missed the point of require_once from the sound of it. It is there to stop exactly the problem you now have. However, just because you have requied a file in one page does not mean that it is loaded for all other pages. Each page still needs the require_once coded within it.

[PickledOnion]

I think you are right!

I had the 'require_once mysql_connect.php' on each page, as I knew it was only for one page, but I made a newbie error and had it more than once for the same file in the same page (because I had seperate SELECTS of different tables, etc in each page).

I think I understand it a bit better now and am spending today going through my code to see what else I may or may not have done.

Many thanks 🙂