Kodi: Difference between revisions

From James's Wiki
No edit summary
No edit summary
Line 30: Line 30:
  FLUSH PRIVILEGES;
  FLUSH PRIVILEGES;
  quit
  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
===On your kodi box===
ssh in
find
<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>

Revision as of 21:08, 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

On your kodi box

ssh in

find

<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>