Kodi: Difference between revisions
From James's Wiki
No edit summary |
No edit summary |
||
(5 intermediate revisions by the same user not shown) | |||
Line 24: | Line 24: | ||
sudo mysql -u root | sudo mysql -u root | ||
CREATE USER 'KodiUser' IDENTIFIED BY 'KodiPassword'; | |||
GRANT ALL ON `MyVideos%`.* TO 'KodiUser'; | |||
GRANT ALL ON `MyMusic%`.* TO 'KodiUser'; | |||
FLUSH PRIVILEGES; | |||
quit | |||
comment out the bind in this file on server: | comment out the bind in this file on server: | ||
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf | sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf | ||
sudo systemctl restart mysql | |||
===On your kodi box=== | |||
ssh in | |||
nano /home/osmc/.kodi/userdata/advancedsettings.xml | |||
<advancedsettings> | |||
<videodatabase> | |||
<type>mysql</type> | |||
<host>XXX.XXX.XXX.XXX</host> | |||
<port>3306</port> | |||
<user>KodiUser</user> | |||
<pass>KodiPassword</pass> | |||
</videodatabase> | |||
<musicdatabase> | |||
<type>mysql</type> | |||
<host>XXX.XXX.XXX.XXX</host> | |||
<port>3306</port> | |||
<user>KodiUser</user> | |||
<pass>KodiPassword</pass> | |||
</musicdatabase> | |||
<videolibrary> | |||
<importwatchedstate>true</importwatchedstate> | |||
<importresumepoint>true</importresumepoint> | |||
</videolibrary> | |||
</advancedsettings> | |||
reboot | |||
there will be no movies or tv shows. the database is blank. go to videos, click add content on your sources. the database will be created. | |||
if nothing happens...check error logs on kodi box...maybe its error 111 connection refused...then mariadb is still on localhost only or firewall is blocking |
Latest revision as of 21:32, 18 March 2018
bug...smb share don't show up anymore....add manually instead by typing in the path ect
ssh:
user osmc
pass osmc
TuneIn
ssh in and
wget https://github.com/brianhornsby/plugin.audio.tuneinradio/releases/download/v3.0.0/plugin.audio.tuneinradio-3.0.0.zip
logs
sudo nano /home/osmc/.kodi/temp/kodi.log
Set up mysql database sharing for multiple kodi boxes at home
On your mysql server
Note that I'm using a raspberry pi 3 (stretch) as a NAS server and mysql server for kodi.
sudo mysql -u root
CREATE USER 'KodiUser' IDENTIFIED BY 'KodiPassword'; GRANT ALL ON `MyVideos%`.* TO 'KodiUser'; GRANT ALL ON `MyMusic%`.* TO 'KodiUser'; FLUSH PRIVILEGES; quit
comment out the bind in this file on server:
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
sudo systemctl restart mysql
On your kodi box
ssh in
nano /home/osmc/.kodi/userdata/advancedsettings.xml
<advancedsettings> <videodatabase> <type>mysql</type> <host>XXX.XXX.XXX.XXX</host> <port>3306</port> <user>KodiUser</user> <pass>KodiPassword</pass> </videodatabase> <musicdatabase> <type>mysql</type> <host>XXX.XXX.XXX.XXX</host> <port>3306</port> <user>KodiUser</user> <pass>KodiPassword</pass> </musicdatabase> <videolibrary> <importwatchedstate>true</importwatchedstate> <importresumepoint>true</importresumepoint> </videolibrary> </advancedsettings>
reboot
there will be no movies or tv shows. the database is blank. go to videos, click add content on your sources. the database will be created.
if nothing happens...check error logs on kodi box...maybe its error 111 connection refused...then mariadb is still on localhost only or firewall is blocking