Unfortunatley I am a complete novice when dealing with mysql. I definitely missed a step somewhere and am having a terrible time trying to fix my blunder. Any ideas?
config.xml (same in both /home and /etc/mythtv)
Code: Select all
<Configuration>
<Database>
<PingHost>1</PingHost>
<Host>localhost</Host>
<UserName>mythtv</UserName>
<Password>1qXilKkR</Password>
<DatabaseName>mythconverg</DatabaseName>
<Port>3306</Port>
</Database>
<WakeOnLAN>
<Enabled>0</Enabled>
<SQLReconnectWaitTime>0</SQLReconnectWaitTime>
<SQLConnectRetry>5</SQLConnectRetry>
<Command>echo 'WOLsqlServerCommand not set'</Command>
</WakeOnLAN>
</Configuration>
Code: Select all
datetime: 2017-01-31 21:05:24 (CST)
errornum: 256
error type: User Error
error string: !!NoTrans: No such file or directory [#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] => No such file or directory [#2002]
[err] => No such file or directory
[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] => No such file or directory [#2002]
[err] => No such file or directory
[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] => No such file or directory [#2002]
[err] => No such file or directory
[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] => 1qXilKkR
[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] => No such file or directory [#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] => No such file or directory [#2002]
[err] => No such file or directory
[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] => No such file or directory [#2002]
[err] => No such file or directory
[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] => No such file or directory [#2002]
[err] => No such file or directory
[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] => 1qXilKkR
[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] => 1qXilKkR
[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] => 1qXilKkR
[HTTP_HOST] => 192.168.1.146
[HTTP_CONNECTION] => keep-alive
[HTTP_CACHE_CONTROL] => max-age=0
[HTTP_UPGRADE_INSECURE_REQUESTS] => 1
[HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
[HTTP_DNT] => 1
[HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
[HTTP_COOKIE] => wanted_view2=list; manage_view2=list; snatched_view2=list; soon_view2=thumbs; late_view2=list; blu_ray_com_new_releases_view=thumb; imdb_top_dvd_rentals_view=thumb; redirect=0; file-manager-response=; file-manager-response_count=; _ga=GA1.1.716250577.1485569358; user="2|1:0|10:1485631578|4:user|44:ODI0ZDBmZDg2NWU2NDI0OGFkMmZhM2ZjZmEzODRhOGM=|bdb7bd605faa8bfff123eb1c2a79b4c80f9aa6e306db8b7325c2d73a9e0a9daf"; sickrage_user="2|1:0|10:1485725624|13:sickrage_user|44:NDk0MWYxZTA5ZjY5YWViYjVkN2FkMWI0MjlmYzMxOTM=|c5cd6e1d4e5c0e47ef90d9f1e7e0e4845db539124233cca2e9110a73c74d944b"; wanted_view=list; manage_view=list; advanced_toggle_checked=1; late_view=list; imdb_movies_in_theaters_view=thumb; imdb_box_office_view=thumb; imdb_top_250_movies_view=thumb; login_cookie=1b9770687acd11d57a8112e2eaa08cbfc9264a65; login_salt=72; snatched_view=list; soon_view=thumb; suggest_view=thumb
[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
[SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.1.146 Port 80</address>
[SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
[SERVER_NAME] => 192.168.1.146
[SERVER_ADDR] => 192.168.1.146
[SERVER_PORT] => 80
[REMOTE_ADDR] => 192.168.1.100
[DOCUMENT_ROOT] => /var/www/html
[REQUEST_SCHEME] => http
[CONTEXT_PREFIX] =>
[CONTEXT_DOCUMENT_ROOT] => /var/www/html
[SERVER_ADMIN] => webmaster@localhost
[SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
[REMOTE_PORT] => 53063
[REDIRECT_URL] => /mythweb/
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] =>
[REQUEST_URI] => /
[SCRIPT_NAME] => /mythweb/mythweb.php
[PHP_SELF] => /mythweb/mythweb.php
[REQUEST_TIME_FLOAT] => 1485918324.654
[REQUEST_TIME] => 1485918324
[STATUS] => 200
[URL] => /mythweb/
[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] => serve
[http_host] => 192.168.1.146
[kb] => 1024
[mb] => 1048576
[module] =>
[modules_path] => /usr/share/mythtv/mythweb/modules
[root] => /mythweb/
[root_auth_url] => http://192.168.1.146/mythweb/
[root_url] => http://192.168.1.146/mythweb/
[stream_url] => http://192.168.1.146:80//mythweb/
[tb] => 1099511627776
)
Code: Select all
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager6] Unable to connect to database!
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was [1/2002]:#012QMYSQL: Unable to connect#012Database error was:#012Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: A CoreContext mythcontext.cpp:428 (FindDatabase) Cannot login to database
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext lirc.cpp:208 (Init) LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'#012#011#011#011eno: No such file or directory (2)
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext jsmenu.cpp:153 (ReadConfig) No joystick configuration found, not enabling joystick control
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext cecadapter.cpp:150 (Open) CECAdapter: Failed to load libcec.
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythudplistener.cpp:32 (Enable) UDPListener: Enabling
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP 127.0.0.1:0
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP 192.168.1.146:0
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP [::1]:0
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP [fe80::49a8:6eb8:c443:26f7%eno1]:0
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP 192.168.1.255:0
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1041 (Init) Using Frameless Window
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1052 (Init) Using Full Screen Window
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1079 (Init) UI Screen Resolution: 1024 x 768
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1185 (Init) Using the Qt painter
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythuiwebbrowser.cpp:1090 (LoadUserStyleSheet) MythUIWebBrowser: Loading css from - file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythuiwebbrowser.cpp:997 (Init) MythUIWebBrowser: enabling plugins
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: N CoreContext mythlocale.cpp:123 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
Jan 31 21:11:11 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext langsettings.cpp:117 (Load) System Locale (en_US), Country (US), Language (en_US)
Jan 31 21:11:13 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythtranslation.cpp:73 (load) Loading en_us translation for module mythfrontend
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager7] Unable to connect to database!
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was [1/2002]:#012QMYSQL: Unable to connect#012Database error was:#012Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: A CoreContext mythcontext.cpp:428 (FindDatabase) Cannot login to database
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext lirc.cpp:208 (Init) LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'#012#011#011#011eno: No such file or directory (2)
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext jsmenu.cpp:153 (ReadConfig) No joystick configuration found, not enabling joystick control
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext cecadapter.cpp:150 (Open) CECAdapter: Failed to load libcec.
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythudplistener.cpp:32 (Enable) UDPListener: Enabling
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP 127.0.0.1:0
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP 192.168.1.146:0
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP [::1]:0
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP [fe80::49a8:6eb8:c443:26f7%eno1]:0
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext serverpool.cpp:508 (bind) Binding to UDP 192.168.1.255:0
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1041 (Init) Using Frameless Window
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1052 (Init) Using Full Screen Window
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1079 (Init) UI Screen Resolution: 1024 x 768
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythmainwindow.cpp:1185 (Init) Using the Qt painter
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythuiwebbrowser.cpp:1090 (LoadUserStyleSheet) MythUIWebBrowser: Loading css from - file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css
Jan 31 21:15:08 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythuiwebbrowser.cpp:997 (Init) MythUIWebBrowser: enabling plugins
Jan 31 21:15:09 serve mythtv-setup.real: mythtv-setup[8597]: N CoreContext mythlocale.cpp:123 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
Jan 31 21:15:09 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext langsettings.cpp:117 (Load) System Locale (en_US), Country (US), Language (en_US)
Jan 31 21:15:10 serve mythtv-setup.real: mythtv-setup[8597]: I CoreContext mythtranslation.cpp:73 (load) Loading en_us translation for module mythfrontend
Jan 31 21:15:12 serve mythtv-setup.real: mythtv-setup[8597]: A CoreContext mythcontext.cpp:589 (PromptForDatabaseParams) User cancelled database configuration
Jan 31 21:15:12 serve mythtv-setup.real: mythtv-setup[8597]: E CoreContext main.cpp:354 (main) Failed to init MythContext, exiting.
Code: Select all
stack@serve:~$ mythbackend
Cannot login to database
Would you like to configure the database connection now? [no] 2017-01-31 21:30:32.696304 C mythbackend version: fixes/0.28 [v0.28-115-g15cc313] www.mythtv.org
2017-01-31 21:30:32.696321 C Qt version: compile: 5.5.1, runtime: 5.5.1
2017-01-31 21:30:32.696323 N Enabled verbose msgs: general
2017-01-31 21:30:32.696331 N Setting Log Level to LOG_INFO
2017-01-31 21:30:32.706864 I Added logging to the console
2017-01-31 21:30:32.707131 I Setup Interrupt handler
2017-01-31 21:30:32.707136 I Setup Terminated handler
2017-01-31 21:30:32.707141 I Setup Segmentation fault handler
2017-01-31 21:30:32.707144 I Setup Aborted handler
2017-01-31 21:30:32.707149 I Setup Bus error handler
2017-01-31 21:30:32.707153 I Setup Floating point exception handler
2017-01-31 21:30:32.707156 I Setup Illegal instruction handler
2017-01-31 21:30:32.707161 I Setup Real-time signal 0 handler
2017-01-31 21:30:32.707165 I Setup Hangup handler
2017-01-31 21:30:32.707228 N Using runtime prefix = /usr
2017-01-31 21:30:32.707231 N Using configuration directory = /home/stack/.mythtv
2017-01-31 21:30:32.707267 I Assumed character encoding: en_US.UTF-8
2017-01-31 21:30:32.707447 N Empty LocalHostName.
2017-01-31 21:30:32.707453 I Using localhost value of serve
2017-01-31 21:30:32.708608 E [DBManager0] Unable to connect to database!
2017-01-31 21:30:32.708620 E Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Code: Select all
stack@serve:~$ sudo service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Code: Select all
stack@serve:~$ status mysql.service
status: Name "com.ubuntu.Upstart" does not exist
Code: Select all
stack@serve:~$ journalctl -xe
Jan 31 21:33:59 serve systemd[1]: mysql.service: Unit entered failed state.
Jan 31 21:33:59 serve systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 31 21:33:59 serve sudo[15470]: pam_unix(sudo:session): session closed for us
Jan 31 21:34:00 serve systemd[1]: mysql.service: Service hold-off time over, sch
Jan 31 21:34:00 serve systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Jan 31 21:34:00 serve systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profi
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profi
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profi
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8355): appar
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8356): appar
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8357): appar
Jan 31 21:34:02 serve systemd[1]: mysql.service: Main process exited, code=exite
lines 1965-1987/1987 (END)
Jan 31 21:33:59 serve systemd[1]: mysql.service: Unit entered failed state.
Jan 31 21:33:59 serve systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 31 21:33:59 serve sudo[15470]: pam_unix(sudo:session): session closed for us
Jan 31 21:34:00 serve systemd[1]: mysql.service: Service hold-off time over, sch
Jan 31 21:34:00 serve systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Jan 31 21:34:00 serve systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profi
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profi
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profi
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8355): appar
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8356): appar
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8357): appar
Jan 31 21:34:02 serve systemd[1]: mysql.service: Main process exited, code=exite
~
~
lines 1965-1987/1987 (END)
Jan 31 21:33:59 serve systemd[1]: mysql.service: Unit entered failed state.
Jan 31 21:33:59 serve systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 31 21:33:59 serve sudo[15470]: pam_unix(sudo:session): session closed for user root
Jan 31 21:34:00 serve systemd[1]: mysql.service: Service hold-off time over, scheduling restart
Jan 31 21:34:00 serve systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Jan 31 21:34:00 serve systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/m
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/m
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/m
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8355): apparmor="DENIED" op
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8356): apparmor="DENIED" op
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8357): apparmor="DENIED" op
Jan 31 21:34:02 serve systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAI
~
~
lines 1965-1987/1987 (END)
Jan 31 21:33:59 serve systemd[1]: mysql.service: Unit entered failed state.
Jan 31 21:33:59 serve systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 31 21:33:59 serve sudo[15470]: pam_unix(sudo:session): session closed for user root
Jan 31 21:34:00 serve systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Jan 31 21:34:00 serve systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Jan 31 21:34:00 serve systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/15634/status"
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/
Jan 31 21:34:00 serve audit[15634]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/15634/status"
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8355): apparmor="DENIED" operation="open" profile="/usr/sbin
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8356): apparmor="DENIED" operation="open" profile="/usr/sbin
Jan 31 21:34:00 serve kernel: audit: type=1400 audit(1485920040.034:8357): apparmor="DENIED" operation="open" profile="/usr/sbin
Jan 31 21:34:02 serve systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE