[mythtv-users] mythtv: access denied to mythweb

[Klaus]

On 21/08/2018 17:32, Allen Edwards wrote:
> 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


Hallo Allen and everybody,

for the mythtv-version:

  apt-cache policy mythtv
mythtv:
   Installé : 29.1+fixes20180603.git1777cc4425-dmo1
   Candidat : 29.1+fixes20180603.git1777cc4425-dmo1
  Table de version :
  *** 29.1+fixes20180603.git1777cc4425-dmo1 500
         500 http://www.deb-multimedia.org unstable/main amd64 Packages
         100 /var/lib/dpkg/status

There is no file mythtv.cnf in Debian Sid, neither under 
/etc/mysql/conf.d/ nor elsewhere:

ls /etc/mysql/conf.d/
mysql.cnf  mysqldump.cnf

On another machine with Debian Sid, mythweb worked out of the box. I use 
the same mythtv-version on both machines.

sincerely

Klaus



> 
> 
> On Tue, Aug 21, 2018 at 8:24 AM, Klaus <colonius at free.fr 
> <mailto: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/mysqlicompat.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
>     )
> 
>     )
>     !!