Jump to content


Photo

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


  • Please log in to reply
No replies to this topic

#1 cameeob2003

cameeob2003
  • Members
  • PipPipPip
  • Advanced Member
  • 79 posts

Posted 03 July 2006 - 11:06 PM

Im not sure why I am getting this error but I only get it when trying to transfer sessions from 1 page to another i believe. Im not positive its the sessions but I think it could be. Im not the greatest at php yet so I am posting my scripts here to see what the experts say I should do to fix this problem.

Problem/error:

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

Scripts:

login.php

<?php
session_start();

header("Cache-control: private");

$user = $_POST['username'];
$pass = $_POST['password'];

include("db.php");

// Check to see if the user exists.

$sql_user_check = "SELECT username FROM users WHERE username='$user'";
$result_name_check = mysql_query($sql_user_check) or die(mysql_error());
$usersfound = mysql_num_rows($result_name_check) or die(mysql_error());

// If the user is not found note that and end.
if($usersfound < 1){
	$error = "User ".$user." was not found in the database.";

		$user = $_POST['username'];
		$pass = md5($_POST['password']);
		$sql = "select * from users where `username` = '$user'";
		$result = mysql_query($sql);
		while ($text = mysql_fetch_array($result)) {
			$id = $text['id'];
			$password = $text['encrytpass'];
			$access = $text['access'];
		}
		if ($pass == $password) {
			$error = "Wrong Username / Password <a href=\"?act=login\">Back</a>";
	
	// If the passwords do match, let in and go to the session variables.
	}else{
		$_SESSION['userid'] = $text['userid'];
		$_SESSION['first_name'] = $text['first_name'];
		$_SESSION['last_name'] = $text['last_name'];
		$_SESSION['username'] = $text['username'];
		$_SESSION['password'] = $text['password'];
		$_SESSION['encryptpass'] = $text['encryptpass'];
		$_SESSION['email'] = $text['email'];
		$_SESSION['location'] = $text['location'];
		$_SESSION['steamid'] = $text['steamid'];
		$_SESSION['handle'] = $text['handle'];
		$_SESSION['bio'] = $text['bio'];
		$_SESSION['photo'] = $text['photo'];
		$_SESSION['team_name'] = $text['team_name'];
		$_SESSION['team_tag'] = $text['team_tag'];
		$_SESSION['access'] = $text['access'];
		$_SESSION['webs'] = $text['webs'];
		$_SESSION['priv_message'] = $text['priv_message'];
	}
}

if(!$_SESSION['username']){
	if($error){
		echo $error;
		include("index.php");
	}else{
		header("Location: index2.php");
	  }
    }else{
		echo "<html><head><title>Welcome Back</title></head>Welcome back ". $_SESSION['username'] .".<a href=index2.php>Click here</a> to proceed."; 
	}
?>

index2.php

<?php session_start();
	header("Cache-control: private");
if($_SESSION['username']){
	echo "You are logged in as:". $_SESSION['username'] ."<br/><br/>";
}else{
	echo "<font id=UserPanelText />You are not logged in.<br/><br/>";
	}
	$newpms = $_SESSION['priv_messages'];
	if($newpms > "0"){
		echo "<a href=?page=newpmessage=$id>Unread Messages</a> (". $newpms .")<br/>";
	}else{
		echo "<font id=UserPanelText /><a href=?page=pmessages=$id>Mailbox</a><br/><font id=UserPanelText /><a href=?page=user_panel>User Panel</a><br/>";
	} 
?>





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users