+- Forum (http://forum.xbian.org)
+-- Forum: Software (/forum-6.html)
+--- Forum: Configuration (/forum-17.html)
+--- Thread: SYNCING via RPI2 and mysql (/thread-3486.html)
SYNCING via RPI2 and mysql - keebler - 31st Mar, 2016 07:38 PM
starting my next project of syncing all the rpi's.
i have a RPI2 running mysql
1 RPI3 running XBIAN
2 RPI2's running XBIAN
2 RPI's running XBIAN
so here is the problem
here is the important part of the advancedsettings.xml
<advancedsettings>
<!-- VERSION 20160330.A -->
<videodatabase>
<type>mysql</type>
<host>192.168.1.80</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>adminvideo</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.80</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>adminaudio</name>
</musicdatabase>
then i have various substitutions, etc. (the substitutions, all seem to work fine)
the IP address of the RPI running mysql IS 1.80
i guess my REAL question lies with MYSQL running on Rasbian on RPI2
the settings in MYSQL, etc
any suggestions would be greatly appreciated
thank you
RE: SYNCING via RPI2 and mysql - Nachteule - 31st Mar, 2016 09:39 PM
So WHAT is your problem?
RE: SYNCING via RPI2 and mysql - Nachteule - 31st Mar, 2016 09:53 PM
I have similar configuation (4 Pi's, one Hummingboard, 1 Linux Desktop, 1 Linux Notebook) and Database on Cubieboard2 server
I managed this some years ago, these sites helped me doing this job:
http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL
http://www.howtogeek.com/75535/how-to-sync-your-media-across-your-entire-house-with-xbmc/
RE: SYNCING via RPI2 and mysql - keebler - 1st Apr, 2016 06:29 AM
(31st Mar, 2016 09:39 PM)Nachteule Wrote: So WHAT is your problem?
sorry,
the RPI's (TV's) wont talk to the MYSQL RPI.
RE: SYNCING via RPI2 and mysql - Nachteule - 1st Apr, 2016 07:12 AM
Does your mysql listen on all interfaces?
extract of /etc/mysql/my.cnf
Code:
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
bind-address = ::