[mythtv-users] mythtv: access denied to mythweb

Allen Edwards allen.p.edwards at gmail.com
Tue Aug 21 15:32:32 UTC 2018


I don't actually recall the error I was getting and I don't know your
version but installing Mythbuntu 16.04 and letting it update some files
mythweb did not work.  The solution was an edit of a file.

allen at MythNew:/etc$ more /etc/mysql/conf.d/mythtv.cnf
[mysqld]
#bind-address=::
max_connections=100
sql_mode=NO_ENGINE_SUBSTITUTION


On Tue, Aug 21, 2018 at 8:24 AM, Klaus <colonius at free.fr> wrote:

> Hi,
>
> under Debian Sid, mythtv works fine, but I cannot access to
> localhost/mythweb.
>
> See the error message.
>
> thanks for help
>
> Klaus
>
>
> =============
>
> 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/mysqlicompa
> t.php
> [line] => 65
> [function] => error
> [class] => Database
> [object] => Database_mysqlicompat 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_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] => 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_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] => 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_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] => dnFbsombnqx9Jk1t
> [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
> )
>
> )
> !!
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180821/ddd7d576/attachment.html>


More information about the mythtv-users mailing list