Issue with advancedsettings.xml

Help and Support Raspberry Pi
1

Fresh installation of OMSC. I have a MySQL server, and several other TVs all using Kodi Isengard and able to access the database and nfs server without issue. They all use the exact same (copied from one to the other) advancedsettings.xml file.

After OSMC is all set up, I copy the advancedsettings.xml to the userdata folder.

Reboot the system to get it to take effect, and i get a sad face icon boot loop. It never finishes booting and cannot be accessed by ssh.

The only way I can get back to functional is to format and reinstall OSMC.

Hardware is RASPI Model B, hardwired to GB.
MySQL on Turnkey VM running on Server 2012 R2 Hyper-V
NFS Server running on Windows Server 2012 R2

Advancedsettings.xml is as follows:

<videodatabase>
    <type>mysql</type>
    <host>10.101.170.20</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>xbmc_videolibrary</name>        
</videodatabase> 

<musicdatabase>
    <type>mysql</type>
    <host>10.101.170.20</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>xbmc_musiclibrary</name>
</musicdatabase>

Please help!

2

Do not copy/paste the text from the MySQL tutorial page (particularly from a windows machine). That would be my first suggestion. Myself and others have made that mistake and it doesn’t work. Try typing it into OSMC by hand.

3

I did not copy and paste…i copied the entire file with winscp to the unit.

This is the file i pulled off my RasPi when it was running xmbc, before the upgrade to OSMC.

But I appreciate the heads up on that. So i tried creating the file with the same contents from my Linux Mint 17 machine… No difference. OSMC still fails on boot immediately after this file is out in place.

4

Pastebin the kodi.log. It will tell us what the issue is.

5

If that is everything in the advancedsettings.xml then it is structured incorrectly.

Needs tags.

6

True, I was going on the assumption that that was a snippet… My error…

7

Indeed.

It is missing the outer advancedsettings tags. It should be:

<advancedsettings>
<videodatabase>
    <type>mysql</type>
    <host>10.101.170.20</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>xbmc_videolibrary</name>        
</videodatabase> 

<musicdatabase>
    <type>mysql</type>
    <host>10.101.170.20</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>xbmc_musiclibrary</name>
</musicdatabase>
</advancedsettings>

If that still doesn’t work I would rename advancedsettings.xml, enable debug logging, rename advancedsettings.xml back again, then when it crashes paste the kodi log as follows:

paste-log /home/osmc/.kodi/temp/kodi.log
8

I know. When i put those in the msg box on the webpage here, some of the text didn’t show up.

I can’t get any logs because it never finishes booting after the file is in place. So I also can’t rename the file.

Once it fails, the only way I can get it to boot again is to rebuild the disk.

9

Ok, I took a chance that WinSCP might be able to get the logs before it rebooted again (from the loop) and I have the log.
I have never used pastebin before, so I don’t know how to upload it.
Tell me if this works… http://paste.osmc.io/viviyicisa.xml

10

Our own paste.osmc.io is functionally similar.

Paste
Save
Provide resulting link

11

Thanks for the paste help!

12 
19:55:43 T:3024265776   ERROR: SQL: The table does not exist
Query: SELECT idVersion FROM version
13

What files are present in/home/osmc/.kodi/userdata/Databases ?

14

Yes, I saw that , but I don’t know what it means, I have no option to select anything… unless i am supposed to specify the version number on the database line like this?

xbmc_videolibrary93

I have 6 other devices in the house that use the same xml file without issue, all running Kodi Isengard

15

Files are as follows:
Addons16.db
Egp.db
MyMusic48.db
MyVideos90.db
Textures13.db
TV26.db
ViewModes6.db
And a folder named CDDB

16

It’s hanging on the music db… This user has the same prob…

17

So I do have a music database on my MySQL server as well, so If I put that into the advancedsettings.xml, will it effectively ignore the MyMusic48.db and get past this?

<advancedsettings>
   <videodatabase>
      <type>mysql</type>
      <host>10.101.170.20</host>
      <port>3306</port>
      <user>xbmc</user>
      <pass>xbmc</pass>
      <name>xbmc_videolibrary</name>        
    </videodatabase> 

    <musicdatabase>
      <type>mysql</type>
      <host>10.101.170.20</host>
      <port>3306</port>
      <user>xbmc</user>
      <pass>xbmc</pass>
      <name>xbmc_musiclibrary</name>
   </musicdatabase>
<network>
 <cachemembuffersize>3512880</cachemembuffersize>
</network>
</advancedsettings>
18

Not sure if it will help or not but go into MyOSMC.networking and make sure wait for network is checked

19

ok, did a fresh build and checked the “Wait for network” , and added:
<?xml version="1.0" encoding="UTF-8"?>
to the beginning of my advancedsettings.xml file. Now it at least boots, but does not recognize any of my media from my database.

On the upside, I was able to add media streams from IHeartRadio with no issue and they play great.

20

OK, now post a kodi debug log