Topic: Innitial Setup Errors
My apologies for asking questions which I am sure if I had more skills I could cover off on my own however after spending the best part of 4 hours trying and failing I thought i would come and ask for help.
Help will be incredibly appreciated!!!!!
I am receiving the following errors on the login page;
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /home/sites/gisjobsite.co.uk/public_html/_includes/class.Db.MySql.php on line 34
Fatal error: Uncaught exception 'Exception' with message 'Cannot connect' in /home/sites/gisjobsite.co.uk/public_html/_includes/class.Db.MySql.php:41 Stack trace: #0 /home/sites/gisjobsite.co.uk/public_html/config.php(138): Db->__construct('79.170.40.77', 'web177-jobberba...', 'typo23', 'jobberbase') #1 /home/sites/gisjobsite.co.uk/public_html/index.php(14): require_once('/home/sites/gis...') #2 {main} thrown in /home/sites/gisjobsite.co.uk/public_html/_includes/class.Db.MySql.php on line 41
Below you will see the config.php file as I have changed it
<?php
/**
* jobber job board platform
*
* @author Filip C.T.E. <http://www.filipcte.ro> <me@filipcte.ro>
* @license You are free to edit and use this work, but it would be nice if you always referenced the original author 
* (see license.txt).
*/
header('Content-Type: text/html; charset=UTF-8');
ini_set('display_errors', 'on');
error_reporting(E_ALL ^ E_STRICT);
date_default_timezone_set('Europe/Bucharest');
// MySQL + misc settings for local environment
if ($_SERVER['SERVER_NAME'] == 'localhost')
{
define('DB_HOST', '79.170.40.77');
define('DB_USER', 'web177-jobberbas');
define('DB_PASS', 'password');
define('DB_NAME', 'jobberbase');
define('LOCATION', 'local');
define('ENVIRONMENT', 'dev');
}
// MySQL + misc settings for production environment
else
{
define('DB_HOST', '79.170.40.77');
define('DB_USER', 'web177-jobberbas');
define('DB_PASS', 'password');
define('DB_NAME', 'jobberbase');
define('LOCATION', 'online');
define('ENVIRONMENT', 'prod');
}
// Global settings definitions
define('NOTIFY_EMAIL','support@gisjobsite.co.uk');
define('ADMIN_EMAIL','support@gisjobsite.co.uk');
define('SITE_NAME', 'GIS Jobsite');
define('MAX_CV_SIZE', 3000000); // approx. 3 mb
define('FILE_UPLOAD_DIR', 'uploads/');
define('JOBS_PER_PAGE', 50);
// Type of jobs. Values are the database ids.
define('JOBTYPE_FULLTIME', 1);
define('JOBTYPE_PARTTIME', 2);
define('JOBTYPE_FREELANCE', 3);
define('SIDEBAR_CATEGORIES', 'categories');
define('SIDEBAR_CITIES', 'cities');
/**
* Controls what will be displayed in the sidebar - categories or cities.
* By default, categories are shown.
*
* Possible values:
*
* - SIDEBAR_CATEGORIES - show categories in sidebar
* - SIDEBAR_CITIES - show cities in sidebar
*
*/
define('SIDEBAR_SHOW_WHAT', SIDEBAR_CATEGORIES);
/**
* Controls which cities to show in the sidebar - applies only
* if SIDEBAR_SHOW_WHAT is SIDEBAR_CITIES.
*
* By default, also cities where there are currently no active jobs are shown.
*
* Possible values:
*
* true - show only cities where there are currently active jobs
* false - show also cities where the are currently no active jobs
*
*/
define('SIDEBAR_ONLY_CITIES_WITH_JOBS', false);
define('APP_PATH',dirname(__FILE__).DIRECTORY_SEPARATOR);
if(isset($_SERVER['SCRIPT_NAME']))
{
# on Windows _APP_MAIN_DIR becomes \ and abs url would look something like HTTP_HOST\/restOfUrl, so \ should be trimed too
# @modified Chis Florinel <chis.florinel@candoo.ro>
$app_main_dir = rtrim(dirname($_SERVER['SCRIPT_NAME']),'/\\');
define('_APP_MAIN_DIR', $app_main_dir);
}
else
{
die('[config.php] Cannot determine APP_MAIN_DIR, please set manual and comment this line');
}
if(isset($_SERVER['HTTP_HOST']) && isset($_SERVER['SERVER_PORT']))
{
if($_SERVER['SERVER_PORT'] == 80)
{
define ('BASE_URL', 'http://' . $_SERVER['HTTP_HOST'] . _APP_MAIN_DIR . '/');
}
else
{
define ('BASE_URL', 'http://' . $_SERVER['HTTP_HOST'].':'.$_SERVER['SERVER_PORT'] . _APP_MAIN_DIR . '/');
}
}
else
{
die('[config.php] Cannot determine BASE_URL, please set manual and comment this line');
}
// Function and classes includes
require_once '_includes/function.validate_email.php';
require_once '_includes/function.redirect_to.php';
require_once '_includes/function.printr.php';
require_once '_includes/function.escape.php';
require_once '_includes/functions.php';
require_once '_includes/class.phpmailer.php';
require_once '_includes/class.Postman.php';
require_once '_includes/class.Textile.php';
require_once '_includes/class.Sanitizer.php';
require_once '_includes/class.Db.MySql.php';
require_once '_includes/class.Job.php';
require_once '_includes/class.JobRequest.php';
require_once '_includes/class.Paginator.php';
require_once '_includes/class.Feed.php';
require_once '_includes/class.SpamReport.php';
require_once '_includes/class.Api.php';
require_once '_includes/class.JobApplication.php';
require_once '_includes/class.SearchKeywords.php';
require_once '_includes/smarty/libs/Smarty.class.php';
// Setup database connection
try
{
$db = new Db(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$db->Execute('SET CHARSET UTF8');
}
catch(ConnectException $exception)
{
if (ENVIRONMENT == 'dev')
{
echo "Database Connection Error:<br />";
printr($exception->getMessage());
}
}
// Setup Smarty
$smarty = new Smarty();
$smarty->template_dir = APP_PATH . '_templates/';
$smarty->compile_dir = APP_PATH . '_templates/_cache/';
// Create Textile object
$textile = new Textile;
// Split URL - get parameters
$_app_info['params'] = array();
// if your server is IIS, use these lines and comment lines 135-137:
//$_url = $_SERVER["QUERY_STRING"];
// if server is Apache:
$newUrl = str_replace('/', '\/', _APP_MAIN_DIR);
$pattern = '/'.$newUrl.'/';
$_url = preg_replace($pattern, '', $_SERVER['REQUEST_URI'], 1);
$_tmp = explode('?', $_url);
$_url = $_tmp[0];
if ($_url = explode('/', $_url))
{
foreach ($_url as $tag)
{
if ($tag)
{
$_app_info['params'][] = $tag;
}
}
}
?>