XBMC Advanced Settings Not Working since I changed Broadband Supplier
Smithgf
Junior Member
Posts: 24
#16
2016-03-05, 19:22
Ok I bit the bullet and started a fresh on this deleted old database and old user on phpmyadmin. Set up new user and created a new advanced settings file freshly installed kodi 15.2 then added the new advanced settings file with the synology nas ip looking for it to build a new database mbut it doesn't it just freezes.

here is the bit of the error log that shows it basically looking for a music database etc

6:53:48 T:3788 NOTICE: Running database version Addons19
16:53:48 T:3788 NOTICE: Running database version ViewModes6
16:53:48 T:3788 NOTICE: Running database version Textures13
16:53:59 T:3788 ERROR: Unable to open database: xbmc_music52 [1049](Unknown database 'xbmc_music52')
16:54:09 T:3788 ERROR: Unable to open database: xbmc_music51 [1049](Unknown database 'xbmc_music51')
16:54:19 T:3788 ERROR: Unable to open database: xbmc_music50 [1049](Unknown database 'xbmc_music50')
16:54:29 T:3788 ERROR: Unable to open database: xbmc_music49 [1049](Unknown database 'xbmc_music49')
16:54:39 T:3788 ERROR: Unable to open database: xbmc_music48 [1049](Unknown database 'xbmc_music48')
16:54:49 T:3788 ERROR: Unable to open database: xbmc_music47 [1049](Unknown database 'xbmc_music47')
16:54:59 T:3788 ERROR: Unable to open database: xbmc_music46 [1049](Unknown database 'xbmc_music46')
16:55:09 T:3788 ERROR: Unable to open database: xbmc_music45 [1049](Unknown database 'xbmc_music45')
16:55:19 T:3788 ERROR: Unable to open database: xbmc_music44 [1049](Unknown database 'xbmc_music44')
16:55:29 T:3788 ERROR: Unable to open database: xbmc_music43 [1049](Unknown database 'xbmc_music43')
16:55:39 T:3788 ERROR: Unable to open database: xbmc_music42 [1049](Unknown database 'xbmc_music42')
16:55:49 T:3788 ERROR: Unable to open database: xbmc_music41 [1049](Unknown database 'xbmc_music41')
16:55:59 T:3788 ERROR: Unable to open database: xbmc_music40 [1049](Unknown database 'xbmc_music40')
16:56:10 T:3788 ERROR: Unable to open database: xbmc_music39 [1049](Unknown database 'xbmc_music39')
16:56:20 T:3788 ERROR: Unable to open database: xbmc_music38 [1049](Unknown database 'xbmc_music38')
16:56:30 T:3788 ERROR: Unable to open database: xbmc_music37 [1049](Unknown database 'xbmc_music37')
16:56:40 T:3788 ERROR: Unable to open database: xbmc_music36 [1049](Unknown database 'xbmc_music36')
16:56:50 T:3788 ERROR: Unable to open database: xbmc_music35 [1049](Unknown database 'xbmc_music35')
16:57:00 T:3788 ERROR: Unable to open database: xbmc_music34 [1049](Unknown database 'xbmc_music34')
16:57:10 T:3788 ERROR: Unable to open database: xbmc_music33 [1049](Unknown database 'xbmc_music33')
16:57:20 T:3788 ERROR: Unable to open database: xbmc_music32 [1049](Unknown database 'xbmc_music32')
16:57:30 T:3788 ERROR: Unable to open database: xbmc_music31 [1049](Unknown database 'xbmc_music31')
16:57:40 T:3788 ERROR: Unable to open database: xbmc_music30 [1049](Unknown database 'xbmc_music30')
16:57:50 T:3788 ERROR: Unable to open database: xbmc_music29 [1049](Unknown database 'xbmc_music29')
16:58:00 T:3788 ERROR: Unable to open database: xbmc_music28 [1049](Unknown database 'xbmc_music28')
16:58:10 T:3788 ERROR: Unable to open database: xbmc_music27 [1049](Unknown database 'xbmc_music27')
16:58:20 T:3788 ERROR: Unable to open database: xbmc_music26 [1049](Unknown database 'xbmc_music26')
16:58:30 T:3788 ERROR: Unable to open database: xbmc_music25 [1049](Unknown database 'xbmc_music25')
16:58:40 T:3788 ERROR: Unable to open database: xbmc_music24 [1049](Unknown database 'xbmc_music24')
16:58:50 T:3788 ERROR: Unable to open database: xbmc_music23 [1049](Unknown database 'xbmc_music23')
16:59:00 T:3788 ERROR: Unable to open database: xbmc_music22 [1049](Unknown database 'xbmc_music22')
16:59:10 T:3788 ERROR: Unable to open database: xbmc_music21 [1049](Unknown database 'xbmc_music21')
16:59:20 T:3788 ERROR: Unable to open database: xbmc_music20 [1049](Unknown database 'xbmc_music20')

So it must be unable to find the nas box on the network via this method but I can map the drives via NFS from Kodi and it plays fine it just stops working anytime I add an advanced settings file I am now stumped?
Find
Reply
Sionzris
Senior Member
Posts: 140
#17
2016-03-05, 20:21
Post your Advanced Settings plz. Also check the MySQL User rights (localhost and locallan added?), as well as tell us what Version MySQL you use. While you are at it, it might help to know how you set the ips.
Find
Reply
black_eagle
Team-Kodi Member
Posts: 3,901
#18
2016-03-05, 20:34
Several things I can think of, apart from what Sionzris has already asked you.

What is the IP address of your NAS ? Is this a static IP? If it changes when you reboot the NAS then it isn't.

Have you set the permissions correctly in MySQL so that Kodi can create a new database ?

NFS has absolutely nothing to do with MySQL.

You also said in a previous post that you thought that the database might contain the old IP addresses. Well, of course it does. Thats why you have to use a network source with a shared database, so that the database stores the full network path of a file. Otherwise it's impossible to share a library between machines.
Learning Linux the hard way !!
Find
Reply
Sionzris
Senior Member
Posts: 140
#19
2016-03-05, 20:42
My best guess is, looking at your first as.xml, that the naming is creating problems. Why even do it? Why have the TVShows sorted in the music DB? To me this is asking for trouble. If the IP stuff is sorted to 100%, humor me and try this as.xml.

Code:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>127.0.0.1</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>127.0.0.1</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>

<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

This is all that is needed. Kodi will create and update the database as needed. Of course you need to replace it with the correct STATIC ip address of your NAS (which possibly was set as static by your old router, so triple check that!).

The default user you find in any guide is xbmc, and the default password is xbmc as well, so i expect you used that. You wrote that you "set" the user. I guess that means you created it and gave rights as mentioned above.
Find
Reply
Smithgf
Junior Member
Posts: 24
#20
2016-03-06, 01:45
Ok Guys good stuff forget the old files I have deleted that database and started from scratch. Set a new user up xbmc with global permission. New advacned settings is

-<-<advancedsettings>
-<videodatabase>
<type>mysql</type>
<host>192.168.1.87</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
-<musicdatabase>
<type>mysql</type>
<host>192.168.1.87</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
Find
Reply
Smithgf
Junior Member
Posts: 24
#21
2016-03-06, 01:51
Juyst checked my phpmyadmin database and it has opened a music52 database but that is it kodi still wont open
Find
Reply
Sionzris
Senior Member
Posts: 140
#22
2016-03-06, 02:13
Drop (delete) all related DB from MySQL. Do NOT create any new ones. Kodi sorts this out on it's own.
After that use the as.xml i posted and report back what happens. Give it some time when starting.

<name>xbmc_video</name> and such is not needed. Just leave it out.

P.s. phpmyadmin is just a tool to look at your databases. Not your database itself.
Find
Reply
Smithgf
Junior Member
Posts: 24
#23
2016-03-06, 02:20
Ok assume i swap your IP data for mine?
Find
Reply
Sionzris
Senior Member
Posts: 140
#24
2016-03-06, 02:28
Yes. I did mention that in the post. Please read them, they are meant to help you.
Find
Reply
Smithgf
Junior Member
Posts: 24
#25
2016-03-06, 03:43
Yup read did that and changed the adv set file it opened ok it opened great but no database created in phpmyadmin
Find
Reply
Smithgf
Junior Member
Posts: 24
#26
2016-03-06, 03:45
Ok when I try to open the adv set file in xml it is blank opens ok in note ++
Find
Reply
Smithgf
Junior Member
Posts: 24
#27
2016-03-06, 03:47
01:44:19 T:7012 NOTICE: special://profile/ is mapped to: special://masterprofile/
01:44:19 T:7012 NOTICE: destroy
01:44:19 T:7012 WARNING: Attempted to remove window 10013 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10014 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10015 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10016 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10017 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10018 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10019 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10021 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10107 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10115 from the window manager when it didn't exist
01:44:19 T:7012 WARNING: Attempted to remove window 10104 from the window manager when it didn't exist
01:44:19 T:7012 NOTICE: closing down remote control service
01:44:19 T:7012 NOTICE: unload sections
01:44:19 T:7012 NOTICE: application stopped...
01:44:19 T:7012 ERROR: dllFreeLibrary - Invalid hModule specified
Find
Reply
nickr
Retired Team-Kodi Member
Posts: 19,982
#28
2016-03-06, 06:29
(2016-03-06, 03:45)Smithgf Wrote: Ok when I try to open the adv set file in xml it is blank opens ok in note ++

What does this even mean ? How do you "open" something in "xml"?

Please follow the wiki instructions word for word, including setting up the xbmc user (or whatever username you want to use) and granting all the permissions.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Find
Reply
Sionzris
Senior Member
Posts: 140
#29
2016-03-06, 11:51
(2016-03-06, 03:43)Smithgf Wrote: Yup read did that and changed the adv set file it opened ok it opened great but no database created in phpmyadmin

Everything opened and worked? Did it scrape? Do what nickr said, you have not granted rights correctly.
Find
Reply
Smithgf
Junior Member
Posts: 24
#30
2016-03-06, 14:41
Hi,

OK I have gone through everything from scratch.

1) Text from kodi user set up in phpmyadmin-
Database Privileges Grant Table-specific privileges Action
kodi\_% SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE No No Edit Privileges Edit Privileges Revoke Revoke

It also has a bit saying add all privileges on the following databases - mysql test

2) Sionzris - Used your advanced settings
2:24:40 T:7856 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.87</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.87</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

3) Still freezes with the following error messages.

12:24:41 T:7856 NOTICE: Running database version Addons19
12:24:41 T:7856 NOTICE: Running database version ViewModes6
12:24:41 T:7856 NOTICE: Running database version Textures13
12:24:51 T:7856 ERROR: Unable to open database: MyMusic52 [1049](Unknown database 'MyMusic52')
12:25:01 T:7856 ERROR: Unable to open database: MyMusic51 [1049](Unknown database 'MyMusic51')
12:25:11 T:7856 ERROR: Unable to open database: MyMusic50 [1049](Unknown database 'MyMusic50')
12:25:21 T:7856 ERROR: Unable to open database: MyMusic49 [1049](Unknown database 'MyMusic49')
12:25:32 T:7856 ERROR: Unable to open database: MyMusic48 [1049](Unknown database 'MyMusic48')
12:25:42 T:7856 ERROR: Unable to open database: MyMusic47 [1049](Unknown database 'MyMusic47')
12:25:52 T:7856 ERROR: Unable to open database: MyMusic46 [1049](Unknown database 'MyMusic46')
Find
Reply

Home
Search
Help
Logout Mark Read Team Forum Stats Members Help
XBMC Advanced Settings Not Working since I changed Broadband Supplier0