Forum
  • Search
  • Member List
  • Calendar
Hello There, Guest! Login Register — Login with Facebook

SYNCING via RPI2 and mysql
Thank you for your donation

Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode | Linear Mode
SYNCING via RPI2 and mysql
31st Mar, 2016, 07:38 PM
Post: #1
keebler Offline
Registered
Posts: 5
Joined: Mar 2016
Reputation: 0
SYNCING via RPI2 and mysql
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
Find all posts by this user
Quote this message in a reply
31st Mar, 2016, 09:39 PM
Post: #2
Nachteule Offline
Administrator
******
Posts: 2,405
Joined: Dec 2014
Reputation: 122
RE: SYNCING via RPI2 and mysql
So WHAT is your problem?
Find all posts by this user
Quote this message in a reply
31st Mar, 2016, 09:53 PM
Post: #3
Nachteule Offline
Administrator
******
Posts: 2,405
Joined: Dec 2014
Reputation: 122
RE: SYNCING via RPI2 and mysql
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/
Find all posts by this user
Quote this message in a reply
1st Apr, 2016, 06:29 AM
Post: #4
keebler Offline
Registered
Posts: 5
Joined: Mar 2016
Reputation: 0
RE: SYNCING via RPI2 and mysql
(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.
Find all posts by this user
Quote this message in a reply
1st Apr, 2016, 07:12 AM
Post: #5
Nachteule Offline
Administrator
******
Posts: 2,405
Joined: Dec 2014
Reputation: 122
RE: SYNCING via RPI2 and mysql
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            = ::
Find all posts by this user
Quote this message in a reply
« Next Oldest | Next Newest »
Post Reply 


  • View a Printable Version
  • Send this Thread to a Friend
  • Subscribe to this thread
Forum Jump:

Current time: 20th May, 2025, 03:37 PM Powered By MyBB, © 2002-2025 MyBB Group.