Are 'Ashes' and 'localhost' the same machine? I mean, are your requests going to a MySQL server running on 'localhost' (the same machine as where PHP/Apache are running), and that one machine being known as 'Ashes' on the network? If so, I shouldn't see how the firewall is likely to be a problem.
If it's on a separate machine, the domain of your user is the domain of the machine making the request (i.e. the Apache webserver), not that of the database server, if that's any help. To configure firewall issues, MySQL uses Port 3306 as it's Port, by default, and so is very likely to be doing so in this case.
To find out which port it's using, you can enter:
mysqladmin -p variables
...at a commandline, telnet or (preferably) SSH session. This will tell you the port number (among other things) your DB serevr is using. (You'll need to enter your MySQL root-user password, of course).
Assuming it
is 3306, then you could permit requests to Ashes on port 3306 from your webserver, and put both servers behind a second fire wall that ony permits requests on Port 80. Remember to flush privileges to your users after every change, too, of course ;)
I'm not sure if any of that's been any help, biut let us know how you get on.
Dan
Quote:
quote:Originally posted by m3rajk
my php scripts keep having their connections to mysql refused. the passords come from a seperate file that's in the include.
the pws work, i know because i tested each one by copying and pasting from that file.
http://24.91.157.113/findyourdesire/join.showcode
that file has had a small amount of editing fromt he actual file, which is noted at the top.
this is a print out from mysql that shows the users (logins edited)
http://24.91.157.113/findyourdesire/SQLUserInfo
i've tried adjusting the user being used in that script to Ashes and to localhost, both to no avail
t's a LAMP development environtment, there;s a router providing firewall resticting connections to the machine to just ftp/ssh/htttp if you're not on the network. since there's a hardware firewall on my network i turned off the software firewall on my server to be sure that's not the issue.
can anyone help me get this running?
internships are for the inexperienced, yet corproations award them only to those with experience. then corporations complain about the lack of experience in the emerging workforce.
corporations need to get logical.
|
php/sql connection issue
