Reading Error: socket '/var/lib/mysql/mysql.sock'

"kvigor" <k3cheese@xxxxxxxxxxxxx> · Fri, 6 Jul 2007 12:38:03 -0500

Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (2)

FYI I did this to solved the problem but it didn't work: 
http://webyog.com/forums/lofiversion/index.php/t1367.html  the only thing is 
that I'm running MySQL 5.0 (I have a my.ini not my.cfg) and I put the var 
folder in the following dir C:\Program Files\MySQL\MySQL Server 
5.0\var\lib\mysql. I also modified my PHP.ini to reflect new socket 
location.

What really bothers me is that all was fine until yesterday and my AMP setup 
for localhost works fine.  Only when I upload to Webhost i get the socket 
error
The only thing I did was add the following include file @ the top of all my 
admin pages.
====================================
include file
<?php
session_start();
if($_SESSION['auth'] != "yes")
{
 header("Location: AdminForm.php");
 exit();
}
?>
//===========================================================
AdminForm looks like:
//===========================================================
<?php session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ADMIN LOGIN</title>
<style type="text/css">
<!--
.style3 {font-size: 11pt}
body {
 background-color: #F5F5F5;
}
-->
</style>
<link href="css/site.css" rel="stylesheet" type="text/css" />
</head>
<body>
<br />
<br />
<br />
<table width="611" height="310" border="1" align="center">
<tr>
 <td align="center" bordercolor="#000099" bgcolor="#FFFFFF">

     <div align="center"><br />
          <img src="../images/logoBig.jpg" width="218" height="208" /><br />
          <br />
<?php
if(@$_SESSION['sight'] == "error")
{echo "<div class='ermess3'>Username and/or Password are 
Incorrect</div>";}?>
<br />
          <br />
 </div>

 <div align="center">
  <form action="AdminFormVal.php" method="post" name="adminForm">
      <label for="uname">USERNAME</label>
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

      <input type="text" name="uname" maxlength="25" />
      <br />
      <br />
      <label for="uname">PASSWORD</label>
      &nbsp;&nbsp;&nbsp;&nbsp;

      <input type="password" name="pword" maxlength="25" />
      <br />
      <br />
      <input type="hidden" name="sight" value="" maxlength="25" />
      <br />
      <input name="submit"  type="submit" id="submit" value="Submit" />
  </form>
 </div> </td>
</tr>
</table>
</body>
</html>
END ADMIN FORM===========================================================

Also if I change the AdminFormVal.php beginning 'if' clause to $_SESSION 
instead of $_POST, I mysteriously don't get the mysql.sock error. But script 
does nothing when I do that of course.
===========================================================
AdminFormVal.php file looks like this:

<?php session_start();
if(isset($_POST['sight']))
{
 include("connex.php");
 $checkUnameQuery = "SELECT uname FROM admin WHERE uname ='$_POST[uname]'";
 $checkUnameQueryResult = mysql_query($checkUnameQuery) or die("Can't 
Connect to Admin" . mysql_error());
 $rowResults = mysql_num_rows($checkUnameQueryResult);

 if($rowResults == 1) //login name was found
 {
  $checkUnameQuery = "SELECT uname FROM admin WHERE uname ='$_POST[uname]' 
AND pword ='$_POST[pword]'";
  $checkUnameQueryResult2 = mysql_query($checkUnameQuery) or die("Can't 
Connect to Admin" . mysql_error());
  $rowResults2 = mysql_num_rows($checkUnameQueryResult2);

  if($rowResults2 > 0) //password was found
  {
   $_SESSION['auth'] = "yes";
   header("Location: Admin.php");
  }
 }
 else
 {
  $_SESSION['auth'] = "no";
  $_SESSION['sight'] = "error";
  header("Location: AdminForm.php");
 }
}
?>
===========================================================

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