Opened 9 years ago

Closed 8 years ago

#13048 closed Bug Report - General (Invalid)

!!NoTrans: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]

Reported by: buisson_eric@… Owned by:
Priority: minor Milestone: 0.28.2
Component: MythTV - General Version: 0.28.1
Severity: medium Keywords:
Cc: Ticket locked: no

Description

I can't access to mythweb interface 

    datetime:  2017-05-29 10:02:16 (CEST)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]

Backtrace
Array
(
    [0] => Array
        (
            [file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
            [line] => 65
            [function] => error
            [class] => Database
            [object] => Database_mysqlicompat Object
                (
                    [dbh] => 
                    [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                    [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                    [errno] => 2002
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] => 
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] => 
                            [affected_rows] => 
                            [insert_id] => 
                            [db] => Database_mysqlicompat 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] => 263
            [function] => execute
            [class] => Database_Query_mysqlicompat
            [object] => Database_Query_mysqlicompat Object
                (
                    [dbh] => 
                    [query] => Array
                        (
                            [0] => SET SESSION sql_mode = "";
                        )

                    [last_query] => SET SESSION sql_mode = "";
                    [warnings] => Array ( )
                    [num_args_needed] => 0
                    [num_rows] => 
                    [affected_rows] => 
                    [insert_id] => 
                    [db] => Database_mysqlicompat Object
                        (
                            [dbh] => 
                            [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                            [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                            [errno] => 2002
                            [last_sh] => Database_Query_mysqlicompat 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_mysqlicompat Object
                (
                    [dbh] => 
                    [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                    [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                    [errno] => 2002
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] => 
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] => 
                            [affected_rows] => 
                            [insert_id] => 
                            [db] => Database_mysqlicompat Object
 *RECURSION*
                        )

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

            [type] => ->
            [args] => Array
                (
                    [0] => SET SESSION sql_mode = "";
                )

        )

    [3] => Array
        (
            [file] => /usr/share/mythtv/mythweb/includes/database.php
            [line] => 44
            [function] => connect
            [class] => Database
            [type] => ::
            [args] => Array
                (
                    [0] => mythconverg
                    [1] => mythtv
                    [2] => mythtv
                    [3] => localhost
                    [4] => 
                    [5] => mysqlicompat
                )

        )

    [4] => Array
        (
            [file] => /usr/share/mythtv/mythweb/includes/init.php
            [line] => 43
            [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/mysqlicompat.php
  error line:  66

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

Backtrace: 

    file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
    line:  66
   class:  
function:  trigger_error
    type:  
    args:  Array
(
    [0] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]

Backtrace
Array
(
    [0] => Array
        (
            [file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
            [line] => 65
            [function] => error
            [class] => Database
            [object] => Database_mysqlicompat Object
                (
                    [dbh] => 
                    [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                    [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                    [errno] => 2002
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] => 
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] => 
                            [affected_rows] => 
                            [insert_id] => 
                            [db] => Database_mysqlicompat 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] => 263
            [function] => execute
            [class] => Database_Query_mysqlicompat
            [object] => Database_Query_mysqlicompat Object
                (
                    [dbh] => 
                    [query] => Array
                        (
                            [0] => SET SESSION sql_mode = "";
                        )

                    [last_query] => SET SESSION sql_mode = "";
                    [warnings] => Array ( )
                    [num_args_needed] => 0
                    [num_rows] => 
                    [affected_rows] => 
                    [insert_id] => 
                    [db] => Database_mysqlicompat Object
                        (
                            [dbh] => 
                            [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                            [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                            [errno] => 2002
                            [last_sh] => Database_Query_mysqlicompat 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_mysqlicompat Object
                (
                    [dbh] => 
                    [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                    [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                    [errno] => 2002
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] => 
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] => 
                            [affected_rows] => 
                            [insert_id] => 
                            [db] => Database_mysqlicompat Object
 *RECURSION*
                        )

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

            [type] => ->
            [args] => Array
                (
                    [0] => SET SESSION sql_mode = "";
                )

        )

    [3] => Array
        (
            [file] => /usr/share/mythtv/mythweb/includes/database.php
            [line] => 44
            [function] => connect
            [class] => Database
            [type] => ::
            [args] => Array
                (
                    [0] => mythconverg
                    [1] => mythtv
                    [2] => mythtv
                    [3] => localhost
                    [4] => 
                    [5] => mysqlicompat
                )

        )

    [4] => Array
        (
            [file] => /usr/share/mythtv/mythweb/includes/init.php
            [line] => 43
            [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:  263
   class:  Database_Query_mysqlicompat
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 SESSION sql_mode = "";
)

    file:  /usr/share/mythtv/mythweb/includes/database.php
    line:  44
   class:  Database
function:  connect
    type:  ::
    args:  Array
(
    [0] => mythconverg
    [1] => mythtv
    [2] => mythtv
    [3] => localhost
    [4] => 
    [5] => mysqlicompat
)

    file:  /usr/share/mythtv/mythweb/includes/init.php
    line:  43
   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
    [date_statusbar] => %a %b %e, %Y, %I:%M %p
    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
    [date_scheduled_popup] => %a %b %e, %Y
    [date_recorded] => %a %b %e, %Y (%I:%M %p)
    [date_search] => %a %b %e, %Y, %I:%M %p
    [date_listing_key] => %a %b %e, %Y, %I:%M %p
    [date_listing_jump] => %a %b %e, %Y
    [date_channel_jump] => %a %b %e, %Y
    [date_job_status] => %a %b %e, %Y, %I:%M %p
    [time_format] => %I:%M %p
)

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

$_SERVER: Array
(
    [REDIRECT_STATUS] => 200
    [db_server] => localhost
    [db_name] => mythconverg
    [db_login] => mythtv
    [db_password] => mythtv
    [HTTP_HOST] => 192.168.1.200
    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:53.0) Gecko/20100101 Firefox/53.0
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
    [HTTP_ACCEPT_ENCODING] => gzip, deflate
    [HTTP_COOKIE] => mythweb_id=e7lmapsqk41v02mqotrmervr13; treemediatombUI=d0%7Copen%3Bf0%7Copen%3Bf2f6d65646961%7Copen%3Bf2f6d656469612f6d757369717565%7Copen%3Bd9%7Copen%3Bd12%7Copen%3Bd122731%7Cclosed%3B; lastNodeDb=d197377; TYPE=db; lastNodeFs=f2f6d656469612f6d757369717565; SID=be1b1c0c182f10600082e6165e0bbd83; viewItems=100
    [HTTP_CONNECTION] => keep-alive
    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    [SERVER_SIGNATURE] => <address>Apache/2.4.10 (Raspbian) Server at 192.168.1.200 Port 80</address>

    [SERVER_SOFTWARE] => Apache/2.4.10 (Raspbian)
    [SERVER_NAME] => 192.168.1.200
    [SERVER_ADDR] => 192.168.1.200
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 192.168.1.15
    [DOCUMENT_ROOT] => /var/www/html
    [REQUEST_SCHEME] => http
    [CONTEXT_PREFIX] => /mythweb
    [CONTEXT_DOCUMENT_ROOT] => /usr/share/mythtv/mythweb
    [SERVER_ADMIN] => webmaster@localhost
    [SCRIPT_FILENAME] => /usr/share/mythtv/mythweb/mythweb.php
    [REMOTE_PORT] => 49632
    [REDIRECT_URL] => /mythweb/tv/list
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /tv/list
    [SCRIPT_NAME] => /mythweb/mythweb.php
    [PATH_INFO] => /tv/list
    [PATH_TRANSLATED] => /var/www/html/tv/list
    [PHP_SELF] => /mythweb/mythweb.php/tv/list
    [REQUEST_TIME_FLOAT] => 1496044936.676
    [REQUEST_TIME] => 1496044936
    [STATUS] => 200
    [URL] => /mythweb/tv/list
    [HTTP_X_FORWARDED_PROTO] => 
    [HTTPS] => 
    [HTTP_PORT] => 80
)

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

$constant_list["user"]: Array
(
    [ERROR] => 512
    [E_ASSERT_ERROR] => 4096
    [FATAL] => 256
    [PHP_MIN_VERSION] => 5.3
    [WARNING] => 1024
    [error_email] => 
    [gb] => 1073741824
    [hostname] => raspberrypi
    [http_host] => 192.168.1.200
    [kb] => 1024
    [mb] => 1048576
    [module] => tv
    [modules_path] => /usr/share/mythtv/mythweb/modules
    [root] => /mythweb/
    [root_auth_url] => http://192.168.1.200/mythweb/
    [root_url] => http://192.168.1.200/mythweb/
    [stream_url] => http://192.168.1.200:80//mythweb/
    [tb] => 1099511627776
)

Attachments (1)

code​ (16.8 KB ) - added by anonymous 9 years ago.

Download all attachments as: .zip

Change History (4)

by anonymous, 9 years ago

Attachment: code​ added

comment:1 by Stuart Auchterlonie, 9 years ago

Severity: high → medium

This looks like a local configuration issue.

comment:2 by sphery, 9 years ago

Fix the location specified for the MySQL socket in your php.ini (or suhosin.ini or whatever is configuring your PHP setup). Also note that an incorrect SE Linux configuration can disallow httpd from using sockets for MySQL access.

comment:3 by Peter Bennett, 8 years ago

Resolution: → Invalid
Status: new → closed

Closing as this is not a MythTV bug

Note: See TracTickets for help on using tickets.