Kodi Community Forum

Kodi Community Forum > Support > General Support > Raspberry Pi > Pi keeps creating new database
Full Version: Pi keeps creating new database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

rcmpayne

2014-11-18, 01:22
Hello All,

i have three windows PC's using a shared MySql database on host 192.168.0.100:3306 and everything is working just fine however, whenever i try to add a Pi Raspbmc it does not use the database on my mySQL Server, but rather creates a new database.

MySQL Database
Videodb78 -> created by Pi
Videodb90 -> created by Windows Kodi
Music46 -> created by Pi
Music48 -> created by Windows Kodi

If i delete the pi databases from my mysql server and restart the PI, it will recreate them which is very odd.

If i attempt to add the name of the databases to the advancesettings.xml where names are Videodb90 and Music48, the pi will create a database with the following

Videodb9078
Music4846


[advancesettings.xml] -> Used for all my kodi installs (pi and windows)
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.100</host>
<name>videodb</name>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.100</host>
<name>musicdb</name>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>


[RaspBMC Logs]
23:00:54 T:3037519872 NOTICE: Contents of special://xbmc/system/advancedsettings.xml are...
<?xml version="1.0" encoding="UTF-8" ?>
<advancedsettings>
<network>
<readbufferfactor>4.0</readbufferfactor>
</network>
<imageres>540</imageres>
<fanartres>720</fanartres>
<video>
<defaultplayer>omxplayer</defaultplayer>
<defaultdvdplayer>omxplayer</defaultdvdplayer>
</video>
</advancedsettings>
23:00:54 T:3037519872 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
23:00:54 T:3037519872 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.100</host>
<name>videodb</name>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.100</host>
<name>musicdb</name>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/mediasources.xml</from>
<to>smb://192.168.0.100/cache/appdata/xbmc/userdata/mediasources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/profiles.xml</from>
<to>smb://192.168.0.100/cache/appdata/xbmc/userdata/profiles.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/sources.xml</from>
<to>smb://192.168.0.100/cache/appdata/xbmc/userdata/sources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/upnpserver.xml</from>
<to>smb://192.168.0.100/cache/appdata/xbmc/userdata/upnpserver.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/playlists/</from>
<to>smb://192.168.0.100/cache/appdata/xbmc/userdata/playlists/</to>
</substitute>
<substitute>
<from>special://masterprofile/keymaps/</from>
<to>smb://192.168.0.100/cache/appdata/xbmc/userdata/keymaps/</to>
</substitute>
<substitute>
<from>special://masterprofile/Thumbnails/</from>
<to>smb://192.168.0.100/cache/appdata/xbmc/userdata/Thumbnails/</to>
</substitute>
</pathsubstitution>
<useddsfanart>true</useddsfanart>
<network>
<disableipv6>true</disableipv6>
</network>
<videolibrary>
<dateadded>0</dateadded>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>
23:00:54 T:3037519872 WARNING: VIDEO database configuration is experimental.
...

--> Here you can see the scanning for the DB's but it never looks for a videodb90

23:01:15 T:3037519872 DEBUG: Mysql commit transaction
23:01:15 T:3037519872 ERROR: Unable to open database: videodb78 [1049](Unknown database 'videodb78')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb77 [1049](Unknown database 'videodb77')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb76 [1049](Unknown database 'videodb76')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb75 [1049](Unknown database 'videodb75')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb74 [1049](Unknown database 'videodb74')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb73 [1049](Unknown database 'videodb73')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb72 [1049](Unknown database 'videodb72')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb71 [1049](Unknown database 'videodb71')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb70 [1049](Unknown database 'videodb70')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb69 [1049](Unknown database 'videodb69')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb68 [1049](Unknown database 'videodb68')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb67 [1049](Unknown database 'videodb67')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb66 [1049](Unknown database 'videodb66')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb65 [1049](Unknown database 'videodb65')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb64 [1049](Unknown database 'videodb64')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb63 [1049](Unknown database 'videodb63')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb62 [1049](Unknown database 'videodb62')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb61 [1049](Unknown database 'videodb61')
23:01:15 T:3037519872 ERROR: Unable to open database: videodb60 [1049](Unknown database 'videodb60')
..

Here its starting to create the 78 database for video's

23:01:15 T:3037519872 INFO: creating version table
23:01:15 T:3037519872 DEBUG: Mysql execute: CREATE TABLE version (idVersion integer, iCompressCount integer)
CHARACTER SET utf8 COLLATE utf8_general_ci
23:01:16 T:3037519872 DEBUG: Mysql execute: INSERT INTO version (idVersion,iCompressCount) values(78,0)


So i guess my question is why is the pi not even picking up the videodb90 database that exist on the mysql server. I assume because it does not find that database when its starting the scan, it creates a new one..


Versions:
Windows kodi 14.0 Beta 3
Pi: raspbmc using the newest download package from the website. ive even tried to install the nightly builds (RC1, Beta 1-4 and the lattest nightly build from the pi UI interface)

kyungrak

2014-11-18, 02:26
Probably because raspbmc is not based on helix yet but only gotham (which goes up to version 78 for the video database).

rcmpayne

2014-11-18, 04:43
Ok thanks, will give this a try tomorrow night

http://forum.kodi.tv/showthread.php?tid=...pid1837164

Milhouse

2014-11-18, 05:53
Fyi... http://kodi.wiki/view/XBMC_databases/Versions

sparticle

2014-11-20, 16:45
@rcmpayne

Just install the latest nightly from Miappa http://forum.kodi.tv/showthread.php?tid=...pid1839753 follow the instructions carefully and ensire you run the enable script first, and you should be good to go. I use a central MySQL server for 14 Clients from all platforms. All the pi's are currently running the latest nightly from Miappa. All is well for me including LiveTV etc.

Cheers
Spart

rcmpayne

2015-02-07, 22:54
just installed the newest OSMC and it now has support for videodb90 on my 512MB pi
Kodi Community Forum > Support > General Support > Raspberry Pi > Pi keeps creating new database