Posts: 1,197
Joined: Oct 2008
Reputation:
0
garyi
Posting Freak
Posts: 1,197
Hi all, I have a mysql database set up with eden on my mini which my other XBMCs tap into, by tyring out the beta of frodo, will all this continue to work or will it likely break?
Thanks
Posts: 11
Joined: Aug 2008
Reputation:
0
mudboy
Junior Member
Posts: 11
Broke for me... Library not functioning at all. Still investigating
Posts: 1,544
Joined: Jul 2007
Reputation:
27
gabbott
Team-Kodi Member
Posts: 1,544
Eden and Frodo use different library databases. So if you install Frodo onto a box it will create a new database leaving your existing db untouched. This means that your Frodo box won't be in sync with your Eden boxes but shouldn't adversely affect their library. However if you do that a db backup is recommended.
Posts: 1,197
Joined: Oct 2008
Reputation:
0
garyi
Posting Freak
Posts: 1,197
Am I able to set it back up to sync over all XBMCs though, because I too have found out it no longer works.
Posts: 1,544
Joined: Jul 2007
Reputation:
27
gabbott
Team-Kodi Member
Posts: 1,544
What exactly isn't working?
Posts: 1,197
Joined: Oct 2008
Reputation:
0
garyi
Posting Freak
Posts: 1,197
Sorry, that was not detailed I know.
In essence, new episode added, Updated library (from the frodo XBMC)
On all other XBMCs episode not showing. On this basis I can assume simply that I need to upgrade all XBMCs?
On an upside frodo seemed slick as lightning. So quick even on my harmony where typically it always feels sluggish, just felt great.
However I really like the data base thing over all macs, so back to eden until I understand what I am doing!
Posts: 1,197
Joined: Oct 2008
Reputation:
0
garyi
Posting Freak
Posts: 1,197
No Probs. Will update another one and see if they keep sync, if so I am taking the plunge 'cause I want me some of that sweet sweet frodo.
Posts: 30
Joined: Nov 2012
Reputation:
0
ciantm
Junior Member
Posts: 30
Hi,
I am having the same issue with MySql after moving to Frodo, once installing the current Frodo beta (or the Rasbmc Frodo Alpha 7) XBMC refuses to startup failing on the database recognition.
I thought XBMC built it's own databases rather than needing any created? I am using the same advancedsettings.xml that I used in Eden across several systems, and with Media Elch in tow also. All synched perfectly.
Does anyone know why Frodo refuses to create/read the MySql DBs or even boot? (ps when i remove the advancedsettings.xml file everything boot sperfectly.
Thanks!
Posts: 16,946
Joined: Feb 2011
Reputation:
256
we seem to have problems when trying to update from some older database versions to the frodo db sheme.
AppleTV4/iPhone/iPod/iPad: HowTo find debug logs and everything else which the devs like so much:
click here
HowTo setup NFS for Kodi:
NFS (wiki)
HowTo configure avahi (zeroconf):
Avahi_Zeroconf (wiki)
READ THE IOS FAQ!:
iOS FAQ (wiki)
Posts: 26,215
Joined: Oct 2003
Reputation:
187
And noone bothers to supply any information about it.
Posts: 30
Joined: Nov 2012
Reputation:
0
ciantm
Junior Member
Posts: 30
2012-11-17, 12:12
(This post was last modified: 2012-11-17, 12:41 by ciantm.)
Frodo (Beta 1 Repack, Win 7) does not seem to want to communicate correctly with MySql at all. Is this the same issue that is causing the scraping problems? There was no problem in Eden with either, has the DB format changed or something?
Funnily enough scraping seems fine in Rasbmc based on the Frodo Alpha 7, but not in the actual Alpha 7.
The MyVideos72 is created but movies do not scrape as movies, the same as the scraping issue so likely the same problem.
Thanks!
(p.s. I have just reinstalled Eden on one of my stations and the whole setup works prefectly, scraping, saving in xbmc into the MySql database as it should (albeit a lower numbered database. Frodo still crashes when I add the advancedsettings.xml:
"
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
</advancedsettings>
"
Any ideas?
Posts: 5,952
Joined: Sep 2008
Reputation:
201
Koying
Retired Team-Kodi Member
Posts: 5,952
Would you mind providing the xbmc.log, please.
Posts: 30
Joined: Nov 2012
Reputation:
0
ciantm
Junior Member
Posts: 30
Hi Koying - thanks for the response. Here is the xbmc.log. It kind of looks like the Music db worked ok, and the problem cqame afterwards. Thanks for your thoughts!
16:13:42 T:8136 NOTICE: -----------------------------------------------------------------------
16:13:42 T:8136 NOTICE: Starting XBMC (12.0-BETA1 Git:20121116-f7dc858), Platform: Windows 7 SP1 32-bit, build 7601. Built on Nov 15 2012 (compiler 1600)
16:13:42 T:8136 NOTICE: AMD Athlon II X4 640 Processor
16:13:42 T:8136 NOTICE: Desktop Resolution: 1024x768 32Bit at 60Hz
16:13:42 T:8136 NOTICE: Running with restricted rights
16:13:42 T:8136 NOTICE: Aero is disabled
16:13:42 T:8136 NOTICE: special://xbmc/ is mapped to: C:\Program Files\XBMC
16:13:42 T:8136 NOTICE: special://xbmcbin/ is mapped to: C:\Program Files\XBMC
16:13:42 T:8136 NOTICE: special://masterprofile/ is mapped to: C:\Users\murf\AppData\Roaming\XBMC\userdata
16:13:42 T:8136 NOTICE: special://home/ is mapped to: C:\Users\murf\AppData\Roaming\XBMC\
16:13:42 T:8136 NOTICE: special://temp/ is mapped to: C:\Users\murf\AppData\Roaming\XBMC\cache
16:13:42 T:8136 NOTICE: The executable running is: C:\Program Files\XBMC\XBMC.exe
16:13:42 T:8136 NOTICE: Local hostname: MURF-DESKTOP
16:13:42 T:8136 NOTICE: Log File is located: C:\Users\murf\AppData\Roaming\XBMC\xbmc.log
16:13:42 T:8136 NOTICE: -----------------------------------------------------------------------
16:13:42 T:8136 NOTICE: Enumerated WASAPI devices:
16:13:42 T:8136 NOTICE: Device 1
16:13:42 T:8136 NOTICE: m_deviceName : {77B3517B-069E-4555-86BE-7D0273134B8B}
16:13:42 T:8136 NOTICE: m_displayName : SPDIF - SPDIF Interface (TX0) (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_displayNameExtra: WASAPI: SPDIF Interface (TX0) (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_deviceType : AE_DEVTYPE_IEC958
16:13:42 T:8136 NOTICE: m_channels : FL,FR
16:13:42 T:8136 NOTICE: m_sampleRates : 96000,88200,48000,44100
16:13:42 T:8136 NOTICE: m_dataFormats : AE_FMT_DTS,AE_FMT_AC3,AE_FMT_S24NE4,AE_FMT_S24LE4,AE_FMT_S24BE4,AE_FMT_S16NE,AE_FMT_S16LE,AE_FMT_S16BE
16:13:42 T:8136 NOTICE: Device 2
16:13:42 T:8136 NOTICE: m_deviceName : {BE6E7A50-063C-44C7-A7F9-DDF7E2AAD6CF}
16:13:42 T:8136 NOTICE: m_displayName : Speakers - Speakers (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_displayNameExtra: WASAPI: Speakers (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_deviceType : AE_DEVTYPE_PCM
16:13:42 T:8136 NOTICE: m_channels : FL,FR,FC,LFE,BL,BR
16:13:42 T:8136 NOTICE: m_sampleRates : 192000,96000,88200,48000,44100
16:13:42 T:8136 NOTICE: m_dataFormats : AE_FMT_S24NE4,AE_FMT_S24LE4,AE_FMT_S24BE4,AE_FMT_S16NE,AE_FMT_S16LE,AE_FMT_S16BE,AE_FMT_LPCM
16:13:42 T:8136 NOTICE: Enumerated DirectSound devices:
16:13:42 T:8136 NOTICE: Device 1
16:13:42 T:8136 NOTICE: m_deviceName : {77B3517B-069E-4555-86BE-7D0273134B8B}
16:13:42 T:8136 NOTICE: m_displayName : SPDIF - SPDIF Interface (TX0) (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_displayNameExtra: DirectSound: SPDIF Interface (TX0) (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_deviceType : AE_DEVTYPE_IEC958
16:13:42 T:8136 NOTICE: m_channels : FL,FR
16:13:42 T:8136 NOTICE: m_sampleRates : 48000
16:13:42 T:8136 NOTICE: m_dataFormats : AE_FMT_FLOAT,AE_FMT_AC3
16:13:42 T:8136 NOTICE: Device 2
16:13:42 T:8136 NOTICE: m_deviceName : {BE6E7A50-063C-44C7-A7F9-DDF7E2AAD6CF}
16:13:42 T:8136 NOTICE: m_displayName : Speakers - Speakers (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_displayNameExtra: DirectSound: Speakers (VIA High Definition Audio)
16:13:42 T:8136 NOTICE: m_deviceType : AE_DEVTYPE_PCM
16:13:42 T:8136 NOTICE: m_channels : FL,FR
16:13:42 T:8136 NOTICE: m_sampleRates : 48000
16:13:42 T:8136 NOTICE: m_dataFormats : AE_FMT_FLOAT,AE_FMT_AC3
16:13:42 T:8136 NOTICE: load settings...
16:13:42 T:8136 NOTICE: special://profile/ is mapped to: special://masterprofile/
16:13:42 T:8136 NOTICE: loading special://masterprofile/guisettings.xml
16:13:42 T:8136 NOTICE: Getting hardware information now...
16:13:42 T:8136 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
16:13:42 T:8136 NOTICE: Loaded playercorefactory configuration
16:13:42 T:8136 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
16:13:42 T:8136 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
16:13:42 T:8136 NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
16:13:42 T:8136 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
16:13:42 T:8136 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<substitute>
<from>special://profile/sources.xml</from>
<to>SMB://192.168.1.10/Volume_1/xbmc/userdata/sources.xml</to>
</substitute>
<videodatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
<pathsubstitution />
</advancedsettings>
16:13:42 T:8136 WARNING: VIDEO database configuration is experimental.
16:13:42 T:8136 NOTICE: Getting hardware information now...
16:13:42 T:8136 NOTICE: Default DVD Player: dvdplayer
16:13:42 T:8136 NOTICE: Default Video Player: dvdplayer
16:13:42 T:8136 NOTICE: Default Audio Player: paplayer
16:13:42 T:8136 NOTICE: Disabled debug logging due to GUI setting. Level 0.
16:13:42 T:8136 NOTICE: Log level changed to 0
16:13:42 T:8136 NOTICE: Loading media sources from special://masterprofile/sources.xml
16:13:42 T:8144 NOTICE: Thread CSoftAE start, auto delete: false
16:13:42 T:8136 NOTICE: Running database version Addons15
16:13:42 T:8148 NOTICE: Thread XBMC Peripherals start, auto delete: false
16:13:42 T:8152 NOTICE: Thread CRemoteControl start, auto delete: false
16:13:42 T:8136 NOTICE: Found screen: BenQ FP51G on ATI Radeon 3000 Graphics, adapter 0.
16:13:42 T:8136 NOTICE: Primary mode: 1024x768 @ 60.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 640x480 @ 59.94 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 640x480 @ 60.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 640x480 @ 73.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 640x480 @ 75.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 800x600 @ 56.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 800x600 @ 60.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 800x600 @ 70.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 800x600 @ 72.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 800x600 @ 75.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 1024x768 @ 60.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 1024x768 @ 70.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 1024x768 @ 72.00 - Full Screen
16:13:42 T:8136 NOTICE: Additional mode: 1024x768 @ 75.00 - Full Screen
16:13:42 T:8136 NOTICE: Checking resolution 15
16:13:43 T:8136 NOTICE: Running database version Addons15
16:13:43 T:8136 NOTICE: Running database version ViewModes4
16:13:43 T:8136 NOTICE: Running database version Textures13
16:13:43 T:8136 NOTICE: Running database version MyMusic30
16:13:43 T:8136 ERROR: SQL: The table does not exist
Query: SELECT idVersion FROM version
Posts: 5,952
Joined: Sep 2008
Reputation:
201
Koying
Retired Team-Kodi Member
Posts: 5,952
Looks like your Video database (MyVideos72) is corrupted.
You should do a "DROP DATABASE MyVideos72;".
If you had a previous version, this one will be upgraded otherwise you will have to start with a blank db.
P.S. Please do not cut&paste logs in the forum. Use the log uploader addon or pastebin.