Menu

#1 sql connect error on logon page

v1.0_(example)
open
nobody
None
5
2015-01-28
2002-11-27
Anonymous
No

The logon page has the following error:

'There has been an error!
Can't Connect To Local MySQL Server Through
Socket '/tmp/mysql.sock' (2)'

I dont think it is a username and password error in the
common.inc.php

Could it be something else?

common.inc.php is bellow:

/* ******* VV DO NOT TOUCH THESE VV
***************** */
session_start();
include_once("main.class.php");
$m = new MAIN;
/* ******** ^^ ****************** ^^ **************** */

/* ***********************************************
CONFIGURATION VARIABLES
****************************************** */
define("DBHOST", "localhost");
// Database hostname
define("DBNAME", "helpdesk");
// Database name
define("DBUSER", "mhelp");
// Database username
define("DBPASS", "mhelp");
// Database password

define("__BASE_DIR__", "/www/htdocs/mhelpdesk");
// Path to the main files. No Trailing Slash
define("__URL__", "http://10.0.1.10/mhelpdesk");
// URL to root
directory. No Trailing Slash
define("__TITLE__", "Mantis Help Desk");
// The title of your org.
define("__THRESHOLD_OPEN__", "10");
// How many open tickets before it
turns red
define("__THRESHOLD_PENDING__", "10");
// Same for pending
tickets

define
("__CUST_FILE_PENDING__", "customer_pending");
// File to send to client when there ticket is
set to pending
define("__CUST_FILE_UPDATE__", "customer_update");
// File to send to client when there
ticket is updated
define("__CUST_FILE_CLOSED__", "customer_closed");
// File to send to client when there
ticket is set to closed

define("__FROM_NAME__", "Support");
// Name that email will come from
define
("__FROM_EMAIL__", "support@changeme.com");
// Email address that email will come from
/*
******************************************************************
************************************************ */

/* *************************** END CONFIG -- DONT
TOUCH ANYTHING BELOW ********************** */
define("__VERSION__", "v1.1");

?>

Discussion

  • Mathias Klette

    Mathias Klette - 2003-01-22

    Logged In: YES
    user_id=541657

    Hi,

    just try to reload (I think stopping and restart the mysql-
    daemon from shell) the database. This should create the
    socket you are needing. Otherwise try to connect via TCP if
    possible.

     
  • Nobody/Anonymous

    Logged In: NO

    Normally that error is from a MySQL demon error.

    Meaning MySQL itself could not find the /tmp/mysql.sock or was
    unable to create it. Hence to me it looks like you have a problem with
    MySQL and not really the app.

    I would try to get to a command like and either stop and restart
    safe_mysqld.

    If you see the /tmp/mysql.sock error when you do this then you just
    found your issue. :)

    Regards
    Sean

     

Log in to post a comment.

MongoDB Logo MongoDB