<html><head><meta name="Generator" content="PSI HTML/CSS Generator"/>
<style type="text/css"><!--
body{font-family:'Arial';font-size:10pt;font-color:'#000000';}
LI{display:list-item;margin:0.00in;}
p{display:block;margin:0.00in;}
--></style>
</head><BODY ><div><SPAN style="font-size:10pt;">Check the php settings.</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">The script may need globals on, and safe mode off. try those first, as it usually solves most php script problems.</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">if that does not work look at /var/log/httpd/error_log to get some idea as to why the script is not working.</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">I also will run the script from a shell prompt, php index.php and the screen output can help with alot of errors as well.</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">tony</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;"><br /><br /></span></div>
<div><SPAN style="font-size:10pt;color:navy;">> What</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> PHP script are you trying to install?</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> jimmy</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> -----Original Message-----</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> From: blueonyx-bounces@blueonyx.it</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> [<a href="mailto:blueonyx-bounces@blueonyx.it]On">mailto:blueonyx-bounces@blueonyx.it]On</a> Behalf Of Phil</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Hamer</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Sent: Wednesday, September 16, 2009 2:55 PM</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> To:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> blueonyx@blueonyx.it</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Subject: [BlueOnyx:02412] php script</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> problem</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Hi Guys.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> A site I host for a friend is trying to run a php based</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> website which uses a mysql database to store the information.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> It installed ok by running the /install.php script and</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> information was added to the mysql database (so the include works</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> to resolve the mysql username etc)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> It creates a few tables and installs the default username</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> as admin with a password of admin.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> When you try to log in through the website nothing</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> happens.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> This is the second script which we have tried to get to run with</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> similar problems.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> I don’t get involved with php but understand a bit about</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> mysql.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> I would imagine that I have a setting wrong</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> somewhere??</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> This is a sample from the login.php page;</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> $link = mysql_connect($dbhost, $dbuser,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> $dbpassword)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> or die("Could not connect: " .</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> mysql_error());</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> mysql_select_db($dbname);</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> $sSQL="select n_ID, s_Password, n_Rand, b_Activated</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> from t_Users where s_Username=\"".stripjunk($username)."\"";</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> $results=mysql_query($sSQL);</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> if(mysql_num_rows($results)>0)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> {</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> list($id, $pwd, $rand,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> $b_Activated)=mysql_fetch_row($results);</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> </SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> if($b_Activated<>1)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> </SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> {</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Does not seem to ever get to this stage when you click on</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> the login button the page just seems to re-load.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Could anyone offer any suggestions?</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Phil.</SPAN></div>
</body></html>