MySQL help (cant sync anything)
#1
OK... Ive had a bunch of experience setting up XMBC and linking with MySQL.. but never had problems quite like this (Migrated everything to apple products...and cant figure out what im doing wrong)

OSX Version (MBP1 (server-hosts media (my mac mini took a crap))): 10.9.1
OSX Version (MBP2 - my laptop running XBMC) 10.9.2
Platform Apple TV 1 and an Apple TV 2
ATV is running CrystalBuntu w/ XBMC 12.3
ATV2 jailbroken, running XBMC 12.3
MBP2 is running XBMC 12.3

MBP1 is running MySQL 5.5.36
All shares are via NFS (Movies, TV shows, and database)

LOGS:
Macbook: http://pastebin.com/8HBrJH7P
ATV: http://pastebin.com/RVQkHpg4
ATV2: http://pastebin.com/M0e6nBMM
MySQL: http://pastebin.com/6Cyg5rpu
MySQL logs are in the order of: Reboot MBP1, reboot ATV, reboot ATV2. Launch XBMC and play a video (all 3, different videos) in the order of MBP2, ATV, ATV2.. Log looks like its seeing things... but no sync happens.
Anyone point me in the right direction (I feel like the error needs to lay with the "server"... either my mysql install or permissions...
Reply
#2
ATV2 has an error in the advancedsettings.xml file, probably a typo in the tags or a permissions error in copying the file over. That's not the main issue, but just an FYI.

When you say you migrated, does that mean you transferred existing files from another MySQL server to the MBP 1? I'm guessing maybe there is something is funky in how the MySQL tables were created.
Reply
#3
migrated is sort of a misnomer... Switched to all apple products is more appropriate terminology. (last time i had mysql running correctly was on a windows machine as a server)... switched to mac mini with an external icydrive 2 bay NAS drive (running as a BIG, since its the only way i could actually get it to be recognized by a mac machine). Then the mini took a crap (never had mysql installed)... now on a mbp as my "server" trying to get the sql database working and syncing. i will look at the advancedsettings in the ATV2 (although, honestly, they are all the exact same XML shared between all machines.. (can you point out the error that you see?)..
That being said, the ATV and MBP wont even show the stop marks (pause points) for watched videos paused to be resumed later... but the ATV2 does... Havent properly tested with watching full videos to see if they get tagged correctly as watched.
Reply
#4
The ATV2 is falling back on the internal local DB, which is why it works and the others don't. You can see it in your debug log like this:

Quote:15:24:07 T:42545152 ERROR: Error loading special://profile/advancedsettings.xml, no <advancedsettings> node

If it's not a typo then it's probably a permissions issue: http://wiki.xbmc.org/index.php?title=XBM...r_settings


What I would do is try to drop the current MySQL DB and try setting up the library again. It might just be something funky that happened when XBMC first tried to create the DB.
Reply
#5
ok... removed MySQL as per:
http://tomkeur.net/39/how-to-remove-mysq...opard.html


now, when i try to recreate, i get this:
mysql> CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
ERROR 1396 (HY000): Operation CREATE USER failed for 'xbmc'@'%'

Tried FLUSH PRIVILEGES but still get the same error.

What gives?
Reply
#6
NM, fixed the user create error... used:
drop user 'xbmc'
and
delete from mysql.user where user = 'xbmc'

rebuilt MySQL... still no joy
Reply
#7
Ended up fixing my Mac Mini (it's old... hard drive died on it)... installed snow leopard, NFS manager, MySQL... and rewrote my advanced settings file for all machines... works beautifully now...

Wonder if it was a sharing issue or an issue with Mavericks...
Reply
#8
Weird. Glad to hear it's working now.
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL help (cant sync anything)0