XBMC - Revision history

Bigfoot65: /* Synchronize XBMC library with devices (Raspberry) */

2019-02-01T02:27:08Z

Synchronize XBMC library with devices (Raspberry)

Bigfoot65: /* Setup XBMC to use MySQL */

2019-02-01T02:26:31Z

Setup XBMC to use MySQL

Bigfoot65 at 22:29, 14 September 2015

2015-09-14T22:29:34Z

Bigfoot65 at 22:29, 14 September 2015

2015-09-14T22:29:15Z

Bigfoot65 at 14:02, 29 March 2015

2015-03-29T14:02:19Z

Cpg: /* Setup XBMC to use MySQL */

2015-03-20T06:17:58Z

Setup XBMC to use MySQL

Alex Lane: Gotham SQL Database info

2014-07-02T01:15:53Z

Gotham SQL Database info

Bigfoot65 at 14:21, 24 January 2013

2013-01-24T14:21:13Z

Bigfoot65 at 17:43, 15 January 2012

2012-01-15T17:43:40Z

Bigfoot65 at 17:43, 15 January 2012

2012-01-15T17:43:16Z

@@ Line 144: / Line 144: @@
 . SSH into the server or via Terminal and create a MySQL user and database (this will be the user for the XBMC installations)
-{{Code|hda-create-user-and-db xbmc}}
+ hda-create-user-and-db xbmc
 <!--1. SSH into the server or via Terminal and access the MySQL environment in order to create a user (this will be the user for the XBMC installations)
@@ Line 161: / Line 161: @@
 .1 Open the OpenELEC SMB Share "Userdata" and in it create a file called "advancedsettings.xml" (or edit it if it's already created; DO NOT delete the content already written in it, just add the following code). The following needs to be entered (replace 'x.x.x.x' with the IP of the HDA):
-{{Code|
+<pre>
 Code =  <advancedsettings>
 <videodatabase>
@@ Line 178: / Line 178: @@
 </musicdatabase>
 </advancedsettings>
-}}
+</pre>
 .2 Save the file.

@@ Line 53: / Line 53: @@
 Log into the MySQL core using the root account (it will ask you for the password, which is "hda" in Amahi 7)
-{{Code|mysql -uroot -p}}
+ mysql -uroot -p
 Create the user "xbmc"
-{{Code|CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';}}
+ CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
 Create the databases "xbmc_video" and "xbmc_music"
-{{Code|CREATE database xbmc_video;
+ CREATE database xbmc_video;
-CREATE database xbmc_music;}}
+ CREATE database xbmc_music;
 Grant the user "xbmc" access to these databases
-{{Code|GRANT ALL ON xbmc_music.* TO 'xbmc'@'localhost' identified by 'xbmc';
+ GRANT ALL ON xbmc_music.* TO 'xbmc'@'localhost' identified by 'xbmc';
-GRANT ALL ON xbmc_video.* TO 'xbmc'@'localhost' identified by 'xbmc';}}
+ GRANT ALL ON xbmc_video.* TO 'xbmc'@'localhost' identified by 'xbmc';
 Make sure the MySQL knows the changes made
-{{Code|flush privileges;}}
+ flush privileges;
 Now to have XMBC make use of the MySQL databases:
-{{Code|cat > /home/xbmcuser/.xbmc/userdata/advancedsettings.xml << 'EOF'
+<pre>cat > /home/xbmcuser/.xbmc/userdata/advancedsettings.xml << 'EOF'
 <advancedsettings>
    <videodatabase>
@@ Line 91: / Line 91: @@
    </musicdatabase>
 </advancedsettings>
-EOF}}
+EOF</pre>
 Done! Restart XBMC to enable the new settings.

← Older revision		Revision as of 22:29, 14 September 2015
Line 1:		Line 1:
−	~~{{MessageBox\|backgroundcolor = #FBB\|~~
−	~~image =Warning.png\|~~
−	~~heading =WARNING\|~~
−	~~message = [[Amahi 8]] is the latest stable release.}}~~
−	~~----~~
−
−
	{{NeedsUpdate}}		{{NeedsUpdate}}
	<br />		<br />

@@ Line 2: / Line 2: @@
 image	=Warning.png|
 heading	=WARNING|
-message = Fedora 14 is in maintenance mode.<br>[[Amahi 7]] is the latest stable release.}}
+message = [[Amahi 8]] is the latest stable release.}}
 ----

← Older revision		Revision as of 14:02, 29 March 2015
Line 1:		Line 1:
		+	{{MessageBox\|backgroundcolor = #FBB\|
		+	image =Warning.png\|
		+	heading =WARNING\|
		+	message = Fedora 14 is in maintenance mode.<br>[[Amahi 7]] is the latest stable release.}}
		+	----
		+
		+
	{{NeedsUpdate}}		{{NeedsUpdate}}
	<br />		<br />

@@ Line 52: / Line 52: @@
 First we need to create a user and 2 databases which will hold the indexed media (video and music):
-Log into the MySQL core using the root account (it will ask you for the password)
+Log into the MySQL core using the root account (it will ask you for the password, which is "hda" in Amahi 7)
 {{Code|mysql -uroot -p}}

← Older revision		Revision as of 01:15, 2 July 2014
Line 185:		Line 185:

	3. Reboot the Raspberry		3. Reboot the Raspberry
		+
		+	=== XBMC Gotham MySQL Database===
		+
		+	<ins>'''Configure MySQL for XBMC'''</ins>
		+
		+	In previous XBMC versions, we manually created the SQL databases for XBMC, with version 12.0 and up, the databases will automatically created by XMBC. The only thing we need to do is create a user account Open phpMyAdmin from the HDA app page (or install it).
		+
		+	Click on the 'Add user' link at the 'Users' tab.
		+
		+	[http://www.robvanhamersveld.nl/wp-content/uploads/2013/02/phpMyAdmin01.png ''<ins>phpMyAdmin Users</ins>'']
		+
		+	Fill in the user details, I'm using username 'xbmc' with password 'xbmc'. Click at 'Global privileges' on 'Check All', by doing this the account is capable to create and alter databases on the MySQL server. In a production setup you probably don't want to do this but in a home network it's fine.
		+
		+	[http://www.robvanhamersveld.nl/wp-content/uploads/2013/02/phpMyAdmin02.png ''<ins>phpMyAdmin User Details</ins>'']
		+
		+	That's it, your database server is ready to serve XBMC.
		+
		+	<ins>'''Connect XBMC to your shared database'''</ins>
		+
		+	OK, the database is up, only thing left is to connect XBMC to it. There is no fancy configuration option in the GUI so we have to edit/create a .xml file again. Don't worry, it isn't that hard.
		+
		+	The file we need to create (not default present after the installation of XBMC) is advancedsettings.xml and place it into the XBMC userdata folder. In this file we define the MySQL database connection. It should look like this;
		+
		+	[http://www.robvanhamersveld.nl/wp-content/uploads/2012/03/advancedsettings.png ''<ins>Advanced Settings</ins>'']
		+
		+	You must replace *...* with the IP-address of your MySQL database server.
		+
		+	That's all, your centralized library and media files are ready to use.
		+
		+	For further information, please visit: http://www.robvanhamersveld.nl/2013/02/05/share-your-xbmc-12-0-library-on-a-synology-ds-or-other-nas/

	[[Category:Apps]]		[[Category:Apps]]

← Older revision		Revision as of 14:21, 24 January 2013
Line 131:		Line 131:

	[[image:xbmc-ss.png]]		[[image:xbmc-ss.png]]
		+
		+	=== Synchronize XBMC library with devices (Raspberry)===
		+
		+	First the starting point:
		+
		+	I have OpenELEC mainly running on my RPi (version is r13078 from http://openelec.thestateofme.com/) and wanted other devices, e.g. a tablet, to pick up at the same position where I stopped watching on the RPi. Usually XBMC stores this information locally so you could potentially run into a big mess and unsynchronized XBMC installations. So I wanted to get a neat setup where I would not have to worry about which device I now need to use to start at the same part where I left. For this I wanted to use the built-in MySQL server that comes with Amahi and store the media related information there.
		+
		+	In order to do so we just need to modify/ create the advancedsettings.xml file in the XBMC installation(s). They all need to be the same though, i.e. a Frodo installation cannot work on the same database as an Eden installation.
		+
		+	This is what you need to do:
		+
		+	1. SSH into the server or via Terminal and create a MySQL user and database (this will be the user for the XBMC installations)
		+
		+	{{Code\|hda-create-user-and-db xbmc}}
		+	<!--1. SSH into the server or via Terminal and access the MySQL environment in order to create a user (this will be the user for the XBMC installations)
		+
		+	Code = mysql -u root -p
		+	}}
		+
		+	The standard password used by Amahi is "hda".
		+
		+	2. Paste the SQL command to create the user, set permissions, and update everything
		+	{{Code\|
		+	Code = CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
		+	GRANT ALL ON . TO 'xbmc'; FLUSH PRIVILEGES;
		+	}}-->
		+
		+	2. Now we need to make the adjustments on the OpenELEC installation in order to have OpenELEC connect and use the MySQL database
		+
		+	2.1 Open the OpenELEC SMB Share "Userdata" and in it create a file called "advancedsettings.xml" (or edit it if it's already created; DO NOT delete the content already written in it, just add the following code). The following needs to be entered (replace 'x.x.x.x' with the IP of the HDA):
		+	{{Code\|
		+	Code = <advancedsettings>
		+	<videodatabase>
		+	<type>mysql</type>
		+	<host>x.x.x.x</host>
		+	<port>3306</port>
		+	<user>xbmc</user>
		+	<pass>xbmc</pass>
		+	</videodatabase>
		+	<musicdatabase>
		+	<type>mysql</type>
		+	<host>x.x.x.x</host>
		+	<port>3306</port>
		+	<user>xbmc</user>
		+	<pass>xbmc</pass>
		+	</musicdatabase>
		+	</advancedsettings>
		+	}}
		+
		+	2.2 Save the file.
		+
		+	2.3 In the same SMB share on your OpenELEC installation please go into the "Database" folder to delete "MyVideosXX.db" & "MyMusicXX.db". XX seem to be random numbers.
		+
		+	3. Reboot the Raspberry
		+
		+	[[Category:Apps]]

@@ Line 1: / Line 1: @@
 {{NeedsUpdate}}
 <br />
-[http://www.amahi.org/apps/xbmc-media-center-retired XBMC Media Center] has been packaged for Amahi (Fedora 14) and is currently in ALPHA status.
+[http://www.amahi.org/apps/xbmc-media-center-retired XBMC Media Center] has been packaged for Amahi (Fedora 14).
 This was mainly tested on a fairly basic test system, HP a282n, 2gb ram, 40gb hd, nvidia mx-440 8xAGP using the Fedora 12 based, 32bit Amahi express cd.

← Older revision		Revision as of 17:43, 15 January 2012
Line 1:		Line 1:
	{{NeedsUpdate}}		{{NeedsUpdate}}
		+	<br />
		+	[http://www.amahi.org/apps/xbmc-media-center-retired XBMC Media Center] has been packaged for Amahi (Fedora 14) and is currently in ALPHA status.
		+
	This was mainly tested on a fairly basic test system, HP a282n, 2gb ram, 40gb hd, nvidia mx-440 8xAGP using the Fedora 12 based, 32bit Amahi express cd.		This was mainly tested on a fairly basic test system, HP a282n, 2gb ram, 40gb hd, nvidia mx-440 8xAGP using the Fedora 12 based, 32bit Amahi express cd.