Kodi - Revision history

Ractive at 21:32, 18 March 2018

2018-03-18T21:32:40Z

← Older revision		Revision as of 21:32, 18 March 2018
Line 41:		Line 41:
	nano /home/osmc/.kodi/userdata/advancedsettings.xml		nano /home/osmc/.kodi/userdata/advancedsettings.xml

	<advancedsettings>		<advancedsettings>
	<videodatabase>		<videodatabase>
	<type>mysql</type>		<type>mysql</type>
Line 60:		Line 60:
	<importresumepoint>true</importresumepoint>		<importresumepoint>true</importresumepoint>
	</videolibrary>		</videolibrary>
	</advancedsettings>		</advancedsettings>

	reboot		reboot

2018-03-18T21:32:05Z

← Older revision		Revision as of 21:32, 18 March 2018
Line 39:		Line 39:
	ssh in		ssh in

	~~find~~		nano /home/osmc/.kodi/userdata/advancedsettings.xml

	<advancedsettings>		<advancedsettings>

2018-03-18T21:13:09Z

← Older revision		Revision as of 21:13, 18 March 2018
Line 33:		Line 33:
	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===		===On your kodi box===
Line 63:		Line 65:

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

2018-03-18T21:11:11Z

← Older revision		Revision as of 21:11, 18 March 2018
Line 59:		Line 59:
	</videolibrary>		</videolibrary>
	</advancedsettings>		</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.

2018-03-18T21:08:57Z

@@ Line 30: / Line 30: @@
   FLUSH PRIVILEGES;
   quit
 comment out the bind in this file on server:
   sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

2018-03-18T21:07:24Z

← Older revision		Revision as of 21:07, 18 March 2018
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

2018-03-18T21:06:29Z

← Older revision		Revision as of 21:06, 18 March 2018
Line 23:		Line 23:
	Note that I'm using a raspberry pi 3 (stretch) as a NAS server and mysql server for kodi.<br>		Note that I'm using a raspberry pi 3 (stretch) as a NAS server and mysql server for kodi.<br>

			sudo mysql -u root

	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

2018-03-18T21:04:57Z

← Older revision		Revision as of 21:04, 18 March 2018
Line 16:		Line 16:


	===Set up mysql database sharing for multiple kodi boxes at home===		==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.<br>


	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

2018-03-18T21:02:58Z

← Older revision		Revision as of 21:02, 18 March 2018
Line 14:		Line 14:
	==logs==		==logs==
	sudo nano /home/osmc/.kodi/temp/kodi.log		sudo nano /home/osmc/.kodi/temp/kodi.log


			===Set up mysql database sharing for multiple kodi boxes at home===



	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

2018-03-18T20:48:24Z

← Older revision		Revision as of 20:48, 18 March 2018
Line 14:		Line 14:
	==logs==		==logs==
	sudo nano /home/osmc/.kodi/temp/kodi.log		sudo nano /home/osmc/.kodi/temp/kodi.log


			comment out the bind in this file on server:
			sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf