Posts by johannausrohan

johannausrohan · MariaDB mysql server addon johannausrohan April 4, 2019 at 9:13 PM

Code

mysql -u kodi -p
Enter password:
ERROR 1045 (28000): Access denied for user 'kodi'@'localhost' (using password: YES)

Unfortunately, it works neither with user kodi nor with root.

I have also noticed a problem with the PID file:

Code

service.mariadb.service - MariaDB server
   Loaded: loaded (/storage/.kodi/addons/service.mariadb/system.d/service.mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2019-04-04 22:11:13 CEST; 57s ago
  Process: 1529 ExecStop=/bin/sh -c exec sh /storage/.kodi/addons/service.mariadb/bin/mariadb.stop (code=exited, status=0/SUCCESS)
  Process: 2644 ExecStart=/bin/sh -c exec sh /storage/.kodi/addons/service.mariadb/bin/mariadb.start (code=exited, status=0/SUCCESS)
 Main PID: 2656 (mysqld)
   CGroup: /system.slice/service.mariadb.service
           └─2656 /storage/.kodi/addons/service.mariadb/bin/mysqld

Apr 04 22:11:12 pi-wohnzimmer systemd[1]: Starting MariaDB server...
Apr 04 22:11:12 pi-wohnzimmer sh[2644]: Starting mysqld
Apr 04 22:11:12 pi-wohnzimmer systemd[1]: service.mariadb.service: Can't open PID file /var/run/mysqld/mysqld.pid (yet?) after start: No such file or directory
Apr 04 22:11:12 pi-wohnzimmer sh[2644]: 2019-04-04 22:11:12 0 [Note] /storage/.kodi/addons/service.mariadb/bin/mysqld (mysqld 10.3.12-MariaDB) starting as process 2656 ...
Apr 04 22:11:13 pi-wohnzimmer systemd[1]: Started MariaDB server.

Display More

johannausrohan · MariaDB mysql server addon johannausrohan April 4, 2019 at 7:32 PM

thank you both!

i changed the password to "kodi" for user "kodi".
Here is my advancedsettings.xml:

<advancedsettings> <videodatabase> <type>mysql</type> <host>192.168 - Pastebin.com

And here is the log:

2019-04-04 20:27:35.614 T:1936929440 NOTICE: ---------------------------------- - Pastebin.com

johannausrohan · MariaDB mysql server addon johannausrohan April 4, 2019 at 5:11 PM

Quote

ERROR: Unable to open database: MyVideos116 [1130](Host 'pi-wohnzimmer.fritz.box' is not allowed to connect to this MariaDB server)

2019-04-04 18:06:16.926 T:1807721328 ERROR: Unable to create new database

2019-04-04 18:06:16.934 T:1807721328 NOTICE: Running database version TV32

Thats what it says now. I tried both, root and kodi user.

johannausrohan · MariaDB mysql server addon johannausrohan April 4, 2019 at 4:52 PM

Whoops, that went wrong - Sorry.

The log reads "ERROR Unable to open Database MyVideos116"

Thanks for your reply, Klojum!

johannausrohan · MariaDB mysql server addon johannausrohan April 4, 2019 at 4:44 PM

okay, my log looks like that:

Code

T:1807721328   ERROR: Unable to open database: MyVideos116

and i noticed that my device is NOT listening on port 3306?

Also another question; i have to create the advancedsettings.xml by myself, the addon does not do that, does it?

johannausrohan · MariaDB mysql server addon johannausrohan April 4, 2019 at 4:32 PM

hello there,

is their any kind of manual for this?
how do i set this up?

i have installed the addon and messed around with advancedsettings.xml and so on but my kodi does not scan for content unfortunately