frodo and MYSQL
#1
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
Reply
#2
Broke for me... Library not functioning at all. Still investigating
Reply
#3
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.
Reply
#4
Am I able to set it back up to sync over all XBMCs though, because I too have found out it no longer works.
Reply
#5
What exactly isn't working?
Reply
#6
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!
Reply
#7
Ah gotcha. Yeah, that's what I was referring to in my first post about your Frodo and Eden boxes would no longer be in sync since they are now using different databases Wink

All your boxes will need to be on the same XBMC version.
Reply
#8
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.
Reply
#9
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!
Reply
#10
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)
Reply
#11
And noone bothers to supply any information about it.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#12
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?
Reply
#13
Would you mind providing the xbmc.log, please.
Reply
#14
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
Reply
#15
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.
Reply

Logout Mark Read Team Forum Stats Members Help
frodo and MYSQL0