[mbu10]

well updated to the newest version,
and had some problems to start with.
but sorted the back end sql and created the db and scanned the tv movies and music in
verified that these have been done all good
tv and movies show the correct information
but the music still only show "files or add ons"
does not show genes singer etc etc
any idea
thanks
martin

[artrafael]

Debug log (wiki)?

[mbu10]

Ok have uploaded the debug file.
Recreated or (deleted and let xbmc recreate the db) again
but still no fun,
here is the info you need
http://xbmclogs.com/show.php?id=63234
thanks
looks like it has not created something it self but has full access to the sql server and

[nokdim]

get rid of the <name>xbmc_video</name> tag and <name>xbmc_music</name> tag and try again.
This is legacy config and no longer needed.

You dont need to create the DB it will create a DB for you.

[mbu10]

ok so what is the format for giving details for the mysql db then?
if i remove that it, how does it create them on the mysql
funny though it creates the db video and music
just with the music db there is errors
thanks
martin

[nokdim]

when you do:

GRANT ALL ON *.* TO 'xbmc'; it allows the user xbmc to create db's.

you can lock it down after db's are created and do:

GRANT ALL ON `MyMusic%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyVideos%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';

[mbu10]

evening
yes the user xmbc has full access it has no problems creating db,tables etc
but the question i had is from this part
" <advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.2.194</host>
<port>3306</port>
<user>USER</user>
<pass>PASSWORD</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.2.194</host>
<port>3306</port>
<user>USER</user>
<pass>PASSWORD</pass>
<name>xbmc_music</name>
</musicdatabase>
<videolibrary>
<recentlyaddeditems>50</recentlyaddeditems>
</videolibrary>
</advancedsettings>"

what should it actually look like as all the docs i have reads say this needs to be in

is this how it is meant to look

"<type>mysql</type>
<host>192.168.2.194</host>
<port>3306</port>
<user>USER</user>
<pass>PASSWORD</pass>"


thanks
martin

[Ned Scott]

Yes

[mbu10]

well tried that and it did not create a db on the sql server at all??
http://xbmclogs.com/show.php?id=63264

sorry this is the correct mysql server i use (used wrong ip address)
http://xbmclogs.com/show.php?id=63266
but still says using internal storage for the data.
thanks

[mbu10]

well changed my xml file to the one below
on the mysql server i saw it created the DB's
then came back with the following errors
http://xbmclogs.com/show.php?id=63275


<advancedsettings>
- <videodatabase>
<type>mysql</type>
<host>192.168.2.194</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
-
- <musicdatabase>
<type>mysql</type>
<host>192.168.2.194</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
- <videolibrary>
<recentlyaddeditems>50</recentlyaddeditems>
</videolibrary>
</advancedsettings>

[mbu10]

ok figured it out was running sql 5.6
go figure

[forkless]

Doesn't matter. You can get it running on MySQL 5.6 just fine.

http://forum.xbmc.org/showthread.php?tid=173974

The dumps which you can use alternatively (for Frodo, using it on 12.2 myself) are included in the thread.

However I would suggest backing up/moving the SQLite MyVideos75.db and MyMusic32.db, disable common cache plugin and restart the your XBMC. This should re-create the tables properly.

[mbu10]

well tbh
i think there is a problem with 5.6, removed it and ran it against 5.1 and ran through fine and created the db perfectly
with everything showing up fine

thanks

[mbu10]

just checked against a 5.5 and working fine as well, looks like something not compatible with 5.6

[forkless]

I couldn't get the db create going on 5.1.36 either with prior SQLite database files present. I'm not really convinced it's a 5.6 problem. The SQL queries done should be pretty vanilla.

I have exported the DB structures for Frodo 12.2 on MySQL 5.1.36 that work fine on 5.6 as well, so this may lead me to think that there may be something wrong with the DB abstraction layer (if that's used) or the scripts/error trapping within creating the tables. Eg. Frodo MySQL DB init scripts are b0rked under certain circumstances.

EDIT: I've been doing some more testing on a sandbox. One of the potential problems is the common cache plugin (available in the addon repo) if there are already existing SQLite databases.