(2022-06-09, 04:42)themusj Wrote: I launch Kodi and I can tell it is trying to process request. But it hangs. I check MariaDB for new databases and none are created. I verified I can login into database with kodi account via phpMyadmin.

(2022-06-09, 04:42)themusj Wrote: Edited my.cnf file in MariaDB with vim editor and added #bind-address = 0.0.0.0 to allow for Remote Client Access. #skip-networking already set in file.

(2022-06-09, 06:05)Klojum Wrote: Please provide Kodi's debug log

(2022-06-10, 01:45)themusj Wrote: I just looked at the log

(2022-06-10, 17:05)themusj Wrote: Is that not so?

sql:
klojum@server:~$ ssh dtbsrvr

klojum@dtbsrvr`s password: 

Welcome to Ubuntu 18.04.6 LTS (GNU/Linux 5.4.0-117-generic x86_64)



klojum@dtbsrvr:~$ 

klojum@dtbsrvr:~$ sudo mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.7.38-0ubuntu0.18.04.1 (Ubuntu)



mysql> use mysql;

Database changed



mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| MyMusic82          |

| MyVideos119        |

| mysql              |

| performance_schema |

| sys                |

+--------------------+

6 rows in set (0,00 sec)



mysql> select * from user where user="kodi";;

+------+------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+

| Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin                | authentication_string                     | password_expired | password_last_changed | password_lifetime | account_locked |

+------+------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+

| %    | kodi | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | N          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            | Y                      |          |            |             |              |             0 |           0 |               0 |                    0 | mysql_native_password | **********************                    | N                | 2022-05-07 07:59:37   |              NULL | N              |

+------+------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+

1 row in set (0,00 sec)



mysql> 

• Cannot login in as root via Putty to Qnap IP address. Does not accept password.
  
• Qnap user accounts are admin, and the one I created for myself. I can login with Putty using both those accounts. Commands such as SHOW DATABASES and CREATE USER error with command not found.
  
• I can login to phpMyAdmin with root localhost all privileges. Root password was changed in MariaDB GUI via reset.
  
• When attempting to reset User Passwords in MariaDB10 Account and Database, it requires root password. Now root password is not accepte
  

(2022-06-11, 02:40)themusj Wrote: 1). The log file has my full name all over the place. Is that normal?

(2022-06-11, 02:40)themusj Wrote: 2). I have tried to login as root and follow your commands. Perplexing. 

(2022-06-11, 02:40)themusj Wrote: I can login to phpMyAdmin with root localhost all privileges. Root password was changed in MariaDB GUI via reset.

(2022-06-11, 02:40)themusj Wrote: When attempting to reset User Passwords in MariaDB10 Account and Database, it requires root password. Now root password is not accepte

• I set Qnap up with a static internal IP address from my router. I can log into it all day long with my new user account (upon setup) and the re-enabled admin account. 
  
• I can only login to phpMyadmin with root.
  
• Using Putty, I can only login with my new user account (upon setup) and the re-enabled admin account. IE, using the same internal IP address as my Qnap.
  
• Logging in with Putty with either my user account or admin, most commands do not run.
  • SHOW DATABASES, or CREATE USER for example. Message was like no such command exists. 
    • When I login with admin, I am given a menu of choices, and getting into the terminal, I have a # prompt.
      
    • When I login with my user account, I am right at a terminal with a $ prompt. I received a message about "We trust you have received the usual lecture from the local System Administrator.
      
• BTW, I restarted completely from scratch this morning.
  
• The log file I sent from Kodi was using root. I figured if that could connect, at least I am going in the right direction.