hxxp:///t/p/original/hYpSPhGvMZK9oeVtcdgPHZVMXUz.jpg Only problem I see, is that when I look at the movie table, c08 and any of the art column / fields are pulling data from TMDB. I don't work with databases every day but I was able to get this up and running, and I can remote in and query the data, so I'm sure my other Kodi instances will connect. Could be a configuration change is all that is needed, and I welcome any thoughts on the matter. Still I think that LibreElec should be able to run the database from a local drive, without an active network connection. So that solved my problem, as I am building a system for a friend that has no internet access. I solved the issue by simply blocking the LibreElec appliance from reaching the internet, and that allowed me to test and confirm that LibreElec will run the database independent of the internet. Granted, that running MariaDB is primarily to share the library with other kodi installs on the network, but there are many other reasons to run an SQL database for Kodi. I understand that Mariadb is tied into the networking, but the database should not be entirely dependent upon an active network connection to run locally. If I unplug the network cable the DB stops. Okay well the issue seems to be that anytime the network (LAN) disconnects the database stops. I am now going to try reloading MariaDB and see what happens without any additional add-ons and standard skin. There could be any number of add-on issues causing that, so with a fresh install I found that all my local NFO and Art would scan in without issue. I did a recovery on the unit for a fresh LibreElec install after finding that no movie data would load unless I was connected to the internet. Thanks for all the hard work on LibreElec, much appreciated. I can connect and the data is imported into the database from the library, so this post can be disregarded or deleted. Note: This appears to be a TMM issue, or an issue of my mis-understanding of NFO data. MariaDB > select * from episode_view Ĭode LibreELEC:~ # mysql -ukodi -pjg7PtiU6ĮRROR 1045 (28000): Access denied for user (using password: YES) Type '\c' to clear the current input statement. Server version: 10.3.14-MariaDB MariaDB ServerĬopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Let me know if you need logs etc, happy to provide or test anything you want me to try.įor reference removing the plug-in and running maria-sql via docker worked first time.Ĭode LibreELEC:~ # mysql -uroot -pAq4gXPhl On checking the logs each log-in attempt was met with a message saying that the account chosen wasn't allowed to connect from the machines IP. Uninstalling the add-on and retrying had no effect, still no joy. Manually changing the passwords in the app resulted in not being able to log in to sql with either account. I've installed from scratch on a Pi 3 Model B+, installed the add-on for MariaSQL and experienced very similar behaviour to that described in previous posts.įrom install the autogenerated root password did not work (couldn't log-in to sql command line), the kodi autogenerated password did work. Thanks so much for working on this, its hugely exciting to be able to use add-ons to extend the functionality of LibreELEC in this way. Long time buntu & kodi user, first time LibreELEC, loving it so far Īpr 04 22:11:13 pi-wohnzimmer systemd: Started MariaDB server. └─2656 /storage/.kodi/addons/service.mariadb/bin/mysqldĪpr 04 22:11:12 pi-wohnzimmer systemd: Starting MariaDB server.Īpr 04 22:11:12 pi-wohnzimmer sh: Starting mysqldĪpr 04 22:11:12 pi-wohnzimmer systemd: : Can't open PID file /var/run/mysqld/mysqld.pid (yet?) after start: No such file or directoryĪpr 04 22:11:12 pi-wohnzimmer sh: 22:11:12 0 /storage/.kodi/addons/service.mariadb/bin/mysqld (mysqld 10.3.12-MariaDB) starting as process 2656. Process: 2644 ExecStart=/bin/sh -c exec sh /storage/.kodi/addons/service.mariadb/bin/mariadb.start (code=exited, status=0/SUCCESS)ĬGroup: /system.slice/ Process: 1529 ExecStop=/bin/sh -c exec sh /storage/.kodi/addons/service.mariadb/bin/mariadb.stop (code=exited, status=0/SUCCESS) Loaded: loaded (/storage/.kodi/addons/service.mariadb/system.d/ enabled vendor preset: disabled)Īctive: active (running) since Thu 22:11:13 CEST 57s ago
0 kommentar(er)
