MySQL Error 111

[daveyboyc <davidcrawford83@…>]

Hi since upgrading to .25 everything worked at first - then it stopped working i can no longer connect to mythconverg via mythweb, or run myhtbackend or the setup. Mythweb gives me the following log: (please help - what can i do to fix this?)

datetime: 2012-04-19 12:35:39 (BST) errornum: 256

error type: User Error

error string: !NoTrans: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013

Backtrace Array (

[0] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php [line] => 63 [function] => error [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013 [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [errno] => 2013 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array ( )

)

[1] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 259 [function] => execute [class] => Database_Query_mysql [object] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

(

[dbh] => [error] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013 [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [errno] => 2013 [last_sh] => Database_Query_mysql Object

*RECURSION*

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

)

[type] => -> [args] => Array

(

[0] => Array ( )

)

)

[2] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 124 [function] => query [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013 [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [errno] => 2013 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array

(

[0] => SET NAMES utf8;

)

)

[3] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/database.php [line] => 49 [function] => connect [class] => Database

[type] =>

[args] => Array ( [0] => mythconverg [1] => mythtv [2] => My49MkBV [3] => 192.168.0.5 [4] => [5] => mysql )

)

[4] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/init.php [line] => 40 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/database.php

)

[function] => require_once

)

[5] => Array

(

[file] => /usr/share/mythtv/mythweb/mythweb.php [line] => 20 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/init.php

)

[function] => require_once

)

) !!

filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php

error line: 64

==========================================================================

Backtrace:

file: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php line: 64

class:

function: trigger_error

type: args: Array

(

[0] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013

Backtrace Array (

[0] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php [line] => 63 [function] => error [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013 [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [errno] => 2013 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array ( )

)

[1] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 259 [function] => execute [class] => Database_Query_mysql [object] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

(

[dbh] => [error] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013 [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [errno] => 2013 [last_sh] => Database_Query_mysql Object

*RECURSION*

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

)

[type] => -> [args] => Array

(

[0] => Array ( )

)

)

[2] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 124 [function] => query [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 #2013 [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [errno] => 2013 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array

(

[0] => SET NAMES utf8;

)

)

[3] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/database.php [line] => 49 [function] => connect [class] => Database

[type] =>

[args] => Array ( [0] => mythconverg [1] => mythtv [2] => My49MkBV [3] => 192.168.0.5 [4] => [5] => mysql )

)

[4] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/init.php [line] => 40 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/database.php

)

[function] => require_once

)

[5] => Array

(

[file] => /usr/share/mythtv/mythweb/mythweb.php [line] => 20 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/init.php

)

[function] => require_once

)

)

[1] => 256

)

file: /usr/share/mythtv/mythweb/classes/Database.php line: 259

class: Database_Query_mysql

function: execute

type: -> args: Array

(

[0] => Array ( )

)

file: /usr/share/mythtv/mythweb/classes/Database.php line: 124

class: Database

function: query

type: -> args: Array

(

[0] => SET NAMES utf8;

)

file: /usr/share/mythtv/mythweb/includes/database.php line: 49

class: Database

function: connect

type:

args: Array

(

[0] => mythconverg [1] => mythtv [2] => My49MkBV [3] => 192.168.0.5 [4] => [5] => mysql

)

file: /usr/share/mythtv/mythweb/includes/init.php line: 40

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/includes/database.php

)

file: /usr/share/mythtv/mythweb/mythweb.php line: 20

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/includes/init.php

)

==========================================================================

$_SESSION: Array (

[language] => English

)

==========================================================================

$_SERVER: Array (

[REDIRECT_STATUS] => 200 [db_server] => 192.168.0.5 [db_name] => mythconverg [db_login] => mythtv [db_password] => My49MkBV [HTTP_HOST] => 86.15.42.56 [HTTP_CONNECTION] => keep-alive [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1) AppleWebKit?/535.19 (KHTML, like Gecko) Chrome/18.0.1025.162 Safari/535.19 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_ACCEPT_ENCODING] => gzip,deflate,sdch [HTTP_ACCEPT_LANGUAGE] => en-GB,en-US;q=0.8,en;q=0.6 [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.3 [HTTP_COOKIE] => lastchannel=NaN; tlchgrp=Main; tlzoomx=360; tltfont=14; tlctips=true; mythweb_id=8382dm08d5756f1lcmd36dlvi1; lastpage=tasks.html%3Faktion%3Dtasks [PATH] => /usr/local/bin:/usr/bin:/bin [SERVER_SIGNATURE] => <address>Apache/2.2.20 (Ubuntu) Server at 86.15.42.56 Port 80</address>

[SERVER_SOFTWARE] => Apache/2.2.20 (Ubuntu) [SERVER_NAME] => 86.15.42.56 [SERVER_ADDR] => 192.168.0.5 [SERVER_PORT] => 80 [REMOTE_ADDR] => 190.2.109.14 [DOCUMENT_ROOT] => /var/www [SERVER_ADMIN] => webmaster@localhost [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php [REMOTE_PORT] => 49234 [REDIRECT_URL] => /mythweb/tv/detail/56603/1329332400 [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => [REQUEST_URI] => /mythweb/tv/detail/56603/1329332400 [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /tv/detail/56603/1329332400 [PATH_TRANSLATED] => /var/www/tv/detail/56603/1329332400 [PHP_SELF] => /mythweb/mythweb.php/tv/detail/56603/1329332400 [REQUEST_TIME] => 1334835318 [STATUS] => 200 [URL] => /mythweb/tv/detail/56603/1329332400

)

==========================================================================

$constant_listuser?: Array (

[ERROR] => 512 [E_ASSERT_ERROR] => 4096 [FATAL] => 256 [PHP_MIN_VERSION] => 5.3 [WARNING] => 1024

)