Q about mysql database connection

TomB19 · March 28, 2021 at 2:14 AM

I created the file: /storage/.kodi.userdata/advancesettings.xml

When the file ends with the tag, "</advancedsettings>", kodi will reboot when I try to play a video.

It seems odd that it works when I drop the close advancedsettings tag. I discovered this by accident. All examples I've seen have the </advancedsettings> tag.

Is this normal? Am I doing something wrong? Appreciate any thoughts on this!

TomB19 · March 28, 2021 at 2:16 AM

My advancedsettings.xml file looks like this, but without the final close tag.

Quote

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>server</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>server</host>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
</advancedsettings>

Display More

**chewitt** · March 28, 2021 at 2:18 AM Official Post

There is no issue with using the </advancedsettings> tag (works fine here with a range of devices I test with). I'd guess there is an XML formatting problem somewhere else in the file.

**chewitt** · March 28, 2021 at 2:21 AM Official Post

XML

<?xml version="1.0" encoding="utf-8" ?>
<advancedsettings version="1.0">
  <!-- enable debug logging -->
  <loglevel hide="false">1</loglevel>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.100</host>
    <port>3306</port>
    <user>username</user>
    <pass>password</pass>
  </videodatabase> 
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.100</host>
    <port>3306</port>
    <user>username</user>
    <pass>password</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

Display More

^ FYI, this is mine, with minor edits to change credentials

TomB19 · March 28, 2021 at 3:31 AM

Further clarity: The </advancedsettings> tag does not cause the rPi4b to reboot, but Kodi restarts. It has always been so. I mis-reported it in the first post.

I just took your XML file, changed the server, user, pass and it did the same thing. When I try to play a file, Kodi restarts. Remove the </advancedsettings> and it works fine.

Very odd. I'm running a nightly build.

LibreELEC (community): nightly-20210302-73c0ce6 (RPi4.arm)

I will try 10.0b1 and see what happens.

**chewitt** · March 28, 2021 at 10:49 AM Official Post

I'm running my own image with some minor tweaks, but only cosmetic things. Do you have any funny characters in passwords?

frakkin64 · March 28, 2021 at 11:31 AM

Path is /storage/.kodi/userdata/advancedsettings.xml

Not sure if what you have above is a typo, but there is a slash between .kodi & userdata, and the file is named "advancedsettings.xml" not advancesettings.xml

TomB19 · March 28, 2021 at 5:30 PM

Thank you, frakkin64. That was a typo on my post.

v10.0b1 works properly, with the trailing tag so I expect this was an issue in 20210311-3f55efc that has been resolved.

I really appreciate the help.

TomB19 · March 28, 2021 at 8:49 PM

Further.

I just upgraded two identical devices to v10.0b1 with the argon utilities, mysql, etc.

The first installed exactly as expected and operated perfectly from the first boot.

The second would reload Kodi when I try to play any video file. This behavior stops when I remove the tag </advancedsettings> from the file: /storage/.kodi/userdata/advancedsettings.xml. The first box works fine with this tag in place. Both were created from the same downloaded image and there is no difference in hardware.

Very odd.

frakkin64 · March 28, 2021 at 10:32 PM

Perhaps posting a debug log of the failure scenario would be useful. Assuming the parser is checking closing tags then probably omitting the closing tag causes the XML file to be ignored completely.

I have been using advancedsettings.xml with a shared MySQL DB for probably 8 or 10 years since XBMC 13.0 on multiple platforms, early on I used Windows, but now I am on Amlogic & RPi4 devices.