LOVE THIS! Eden Workaround for MySQL?

[Cirion]

I found a workaround...

I deleted the mysql database and started over with this:

Code:

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE DATABASE xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;
CREATE DATABASE xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci;
GRANT ALL ON bbcode.txt insert_posts.sh mybb_posts.csv mybb_posts.sql oej34_kunena_messages.csv oej34_kunena_messages_text.csv oej34_kunena_messages_text.sql oej34_kunena_users_banned.csv oej34_kunena_users.csv oej34_users.csv openelecj34prod.sql posts.sh replace.sh test.csv test.txt update_sample.sql TO 'xbmc';

But that just gave me lots of errors.

Then I deleted the databases, and gave the xbmc user all privleges globally.
Rebooted and the databases where created correctly
No errors in the xbmc.log (at least about databases).

So now I started a import from a backup...

[Cirion]

IT WORKS!!! Thanks for the help :cheer:

[Cirion]

It worked, but I lost all my covers...
Found out I had to put pathsubstitution outside of advancedsettings.
Now everything works (except my pcsc cardreader).

This is my working advancedsettings.xml:

Code:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.100</host>
<port>3306</port>
<name>xbmc_video</name>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.100</host>
<port>3306</port>
<name>xbmc_music</name>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
</advancedsettings>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>smb://xbmc:xbmc@192.168.1.100/Multimedia/XBMC-Userdata/Thumbnails </to>
</substitute>
</pathsubstitution>

[xe]

Just two points for clarity:

you never manaully creat the databases. XBMC dos that for you. If it doesnt then your xbmc mysql user permissions are wrong.

The 57 at the end of the database names are INTERNAL TO XBMC. As far as the config file goes exclude the version number. So if you call your dbase "bob" in advanced settings XBMC will make the dbase as "bob57". Your settings file will always omit the version number.

[Simon_rb]

Sorry for asking but where do I get the latest Eden build for ION.. (Revo R3700).

Cheers

[Gtach]

Hi Cirion,
that actually worked. Great!
The music import failed, but a rescan fixed that.
Works like a charm now.