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