Trusted, Bureaucrats, Administrators
12,424
edits
Changes
From Amahi Wiki
→Synchronize XBMC library with devices (Raspberry)
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, which is "hda" in Amahi 7){{Code| mysql -uroot -p}}
Create the user "xbmc"
Create the databases "xbmc_video" and "xbmc_music"
Grant the user "xbmc" access to these databases
Make sure the MySQL knows the changes made
Now to have XMBC make use of the MySQL databases:
<advancedsettings>
<videodatabase>
</musicdatabase>
</advancedsettings>
EOF}}</pre>
Done! Restart XBMC to enable the new settings.
1. SSH into the server or via Terminal and create a MySQL user and database (this will be the user for the XBMC installations)
<!--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)
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 = <advancedsettings>
<videodatabase>
</musicdatabase>
</advancedsettings>
2.2 Save the file.
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]]
