[mythtv-users] mythweb not connecting to the database

Rodney D. Myers rod_myers at fastmail.fm
Sat Nov 1 14:55:44 UTC 2014


Unitd States, debian testing, mythtv0.27.4-dmo2, HDHomeRun over the air
version

I can manually create the database, connnect via the command line, and
run mythtv-setup successfully. I can also run "mythfilldatabase"
successfully.

Not sure what I am missing. Thank you for any assistance.

Yet when I attempt to connect via a browser, same machine or networked
machine, all I see is the following output;


Fatal Error

!!NoTrans: Access denied for user 'mythtv'@'localhost' (using password:
YES) [#1045]

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] => Access denied for user 'mythtv'@'localhost' (using password:
YES) [#1045] [err] => Access denied for user
'mythtv'@'localhost' (using password: YES) [errno] => 1045
[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] => 261
[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] => Access denied for user 'mythtv'@'localhost' (using password:
YES) [#1045] [err] => Access denied for user
'mythtv'@'localhost' (using password: YES) [errno] => 1045
[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] => Access denied for user 'mythtv'@'localhost' (using password:
YES) [#1045] [err] => Access denied for user
'mythtv'@'localhost' (using password: YES) [errno] => 1045
[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] => gizWWTU2QpaLmLEi
[3] => localhost
[4] =>
[5] => mysql
)

)

[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
)

)
!!

If you choose to submit a bug report please make sure to include a
brief description of what you were doing, along with the following
backtrace as an attachment (please don\'t just paste the whole thing
into the ticket) datetime: 2014-11-01 10:36:46 (EDT) errornum: 256
error type: User Error error string: !!NoTrans: Access denied for user
'mythtv'@'localhost' (using password: YES) [#1045] 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] => Access denied for user
'mythtv'@'localhost' (using password: YES) [#1045] [err] => Access
denied for user 'mythtv'@'localhost' (using password: YES) [errno] =>
1045 [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] => 261
[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] => Access denied for
user 'mythtv'@'localhost' (using password: YES) [#1045] [err] => Access
denied for user 'mythtv'@'localhost' (using password: YES) [errno] =>
1045 [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] => Access denied for user
'mythtv'@'localhost' (using password: YES) [#1045] [err] => Access
denied for user 'mythtv'@'localhost' (using password: YES) [errno] =>
1045 [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] => gizWWTU2QpaLmLEi [3] =>
localhost [4] => [5] => mysql ) ) [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/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] => Access
denied for user 'mythtv'@'localhost' (using password: YES) [#1045]
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] => Access denied for user
'mythtv'@'localhost' (using password: YES) [#1045] [err] => Access
denied for user 'mythtv'@'localhost' (using password: YES) [errno] =>
1045 [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] => 261
[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] => Access denied for
user 'mythtv'@'localhost' (using password: YES) [#1045] [err] => Access
denied for user 'mythtv'@'localhost' (using password: YES) [errno] =>
1045 [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] => Access denied for user
'mythtv'@'localhost' (using password: YES) [#1045] [err] => Access
denied for user 'mythtv'@'localhost' (using password: YES) [errno] =>
1045 [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] => gizWWTU2QpaLmLEi [3] =>
localhost [4] => [5] => mysql ) ) [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: 261 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] => gizWWTU2QpaLmLEi [3] => localhost
[4] => [5] => mysql ) 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] =>
gizWWTU2QpaLmLEi [HTTP_HOST] => 192.168.1.101 [HTTP_USER_AGENT] =>
Mozilla/5.0 (X11; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.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_DNT] => 1 [HTTP_CONNECTION] => keep-alive [PATH]
=> /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
[SERVER_SIGNATURE] => <address>Apache/2.4.10 (Debian) Server at
192.168.1.101 Port 80</address> [SERVER_SOFTWARE] => Apache/2.4.10
(Debian) [SERVER_NAME] => 192.168.1.101 [SERVER_ADDR] => 192.168.1.101
[SERVER_PORT] => 80 [REMOTE_ADDR] => 192.168.1.42 [DOCUMENT_ROOT]
=> /var/www/html [REQUEST_SCHEME] => http [CONTEXT_PREFIX] => /mythweb
[CONTEXT_DOCUMENT_ROOT] => /usr/share/mythtv/mythweb [SERVER_ADMIN] =>
webmaster at localhost [SCRIPT_FILENAME]
=> /usr/share/mythtv/mythweb/mythweb.php [REMOTE_PORT] => 53272
[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] => 1414852606.061
[REQUEST_TIME] => 1414852606 [STATUS] => 200 [URL] => /mythweb/
[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] => riverside [http_host] =>
192.168.1.101 [kb] => 1024 [mb] => 1048576 [module] => [modules_path]
=> /usr/share/mythtv/mythweb/modules [root] => /mythweb/
[root_auth_url] => http://192.168.1.101/mythweb/ [root_url] =>
http://192.168.1.101/mythweb/ [stream_url] =>
http://192.168.1.101:80//mythweb/ [tb] => 1099511627776 )


-- 
Rodney D. Myers <rod_dmyers at fastmail.fm>

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
        Ben Franklin - 1759
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 221 bytes
Desc: not available
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141101/413e63a6/attachment.sig>


More information about the mythtv-users mailing list