Login at Kodi Home

frieten · 2011-12-12, 19:14

ok so im in the process of setting up my atv2 to be linked to a mysql database and i want it to access my thumbnails on my SMB share.

here is my advanced settings.xml

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.20.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>smb://username:assword@bowan-pc/Media/Thumbnails/</to>
</substitute>
</pathsubstitution>

</advancedsettings>

now whenever i try to get into XBMC now it just freezes at the XBMC screen.

the log puts up an error saying it can't access the smb.

i've tried it with numerous combos for the path substitute part but nothing works. using 192.168.20.100 or just the pc name or anything wont work. does anyone have any ideas?

here is a snippet from the log error that it repeats over and over again:

Code:
T:101081088  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.

58:04 T:101081088  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.

58:04 T:101081088  NOTICE: No settings file to load to load (special://xbmc/system/advancedsettings.xml)

58:04 T:101081088  NOTICE: Loaded settings file from special://profile/advancedsettings.xml

58:04 T:101081088  NOTICE: Contents of special://profile/advancedsettings.xml are...

                                            <advancedsettings>

                                              <videodatabase>

                                                <type>mysql</type>

                                                <host>192.168.20.100</host>

                                                <port>3306</port>

                                                <user>xbmc</user>

                                                <pass>xbmc</pass>

                                                <name>xbmc_video</name>

                                              </videodatabase>

                                              <pathsubstitution>

                                                <substitute>

                                                  <from>special://masterprofile/Thumbnails</from>

                                                  <to>smb://username:password@bowan-pc/Media/Thumbnails/</to>

                                                </substitute>

                                              </pathsubstitution>

                                            </advancedsettings>

58:04 T:101081088   DEBUG: Configuring path substitutions

58:04 T:101081088   DEBUG:   Registering substition pair:

58:04 T:101081088   DEBUG:     From: [/var/mobile/Library/Preferences/XBMC/userdata/Thumbnails]

58:04 T:101081088   DEBUG:     To:   [smb://bowan:july111984@bowan-pc/Media/Thumbnails/]

58:04 T:101081088 WARNING: VIDEO database configuration is experimental.

58:04 T:101081088  NOTICE: Getting hardware information now...

58:04 T:101081088    INFO: Using analog output

58:04 T:101081088    INFO: AC3 pass through is disabled

58:04 T:101081088    INFO: DTS pass through is disabled

58:04 T:101081088    INFO: AAC pass through is disabled

58:04 T:101081088    INFO: MP1 pass through is disabled

58:04 T:101081088    INFO: MP2 pass through is disabled

58:04 T:101081088    INFO: MP3 pass through is disabled

58:04 T:101081088   DEBUG: Error: Requested setting (videoscreen.screenmode) was not found.  It must be case-sensitive

58:04 T:101081088  NOTICE: Checking resolution 12

58:04 T:101081088  NOTICE: Default DVD Player: dvdplayer

58:04 T:101081088  NOTICE: Default Video Player: dvdplayer

58:04 T:101081088  NOTICE: Default Audio Player: paplayer

58:04 T:101081088  NOTICE: Disabled debug logging due to GUI setting. Level 0.

58:04 T:101081088  NOTICE: Log level changed to 0

58:04 T:101081088  NOTICE: Loading media sources from special://masterprofile/sources.xml

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails

58:04 T:101081088   ERROR: Create - Error creating special://masterprofile/Thumbnails

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music

58:04 T:101081088   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/Artists

58:04 T:101081088   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/Artists

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/LastFM

58:04 T:101081088   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/LastFM

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video

58:04 T:101081088   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/Fanart

58:04 T:101081088   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/Fanart

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/Fanart

58:04 T:101081088   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/Fanart

58:04 T:101081088   ERROR: Create - Error( Permission denied )

58:04 T:101081088   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/Bookmarks

58:04 T:101081088

Jester · 2011-12-12, 19:24

have you tried to change that share so everybody can read/write to it ? (without password) just for testing.

frieten · 2011-12-12, 20:13

Jester Wrote:have you tried to change that share so everybody can read/write to it ? (without password) just for testing.

ok will do that now and report back

frieten · 2011-12-12, 20:31

Jester Wrote:have you tried to change that share so everybody can read/write to it ? (without password) just for testing.

yep, exact same error.

**Memphiz** · 2011-12-12, 22:17

add a second substitution

Code:
<from>special://profile/Thumbnails</from>

with same target and try again... you need to have 2 substitute blocks then...

frieten · (This post was last modified: 2011-12-13, 16:32 by frieten.)

Code:
<advancedsettings>

<videodatabase>

<type>mysql</type>

<host>192.168.20.100</host>

<port>3306</port>

<user>xbmc</user>

<pass>xbmc</pass>

<name>xbmc_video</name>

</videodatabase>

<pathsubstitution>

<substitute>

<from>special://masterprofile/Thumbnails</from>

<to>smb://bowan-pc/Media/Thumbnails/</to>

</substitute>

</pathsubstitution>

<pathsubstitution>

<substitute>

<from>special://profile/Thumbnails</from>

<to>smb://bowan-pc/Media/Thumbnails/</to>

</substitute>

</pathsubstitution>

</advancedsettings>

like this you mean?

if not can you show me please i think this is what you meant.

im not to fussed if i can't get it to work but i was trying to get it setup as i plan to get a few more ATV2s for around the house.

**Memphiz** · 2011-12-13, 18:29

Code:
<pathsubstitution>

<substitute>

<from>special://masterprofile/Thumbnails</from>

<to>smb://bowan-pc/Media/Thumbnails/</to>

</substitute>

<substitute>

<from>special://profile/Thumbnails</from>

<to>smb://bowan-pc/Media/Thumbnails/</to>

</substitute>

</pathsubstitution>

this is what i mean...

frieten · 2011-12-13, 18:54

Memphiz Wrote:
Code:
<pathsubstitution> <substitute> <from>special://masterprofile/Thumbnails</from> <to>smb://bowan-pc/Media/Thumbnails/</to> </substitute> <substitute> <from>special://profile/Thumbnails</from> <to>smb://bowan-pc/Media/Thumbnails/</to> </substitute> </pathsubstitution>

this is what i mean...

ok thanks will give it a go.

frieten · (This post was last modified: 2011-12-13, 19:09 by frieten.)

Memphiz Wrote:
Code:
<pathsubstitution> <substitute> <from>special://masterprofile/Thumbnails</from> <to>smb://bowan-pc/Media/Thumbnails/</to> </substitute> <substitute> <from>special://profile/Thumbnails</from> <to>smb://bowan-pc/Media/Thumbnails/</to> </substitute> </pathsubstitution>

this is what i mean...

CHAMPION!! no idea if it is functioning how it is supposed to but it loaded and thats all that matters!!

how do i check if its actually functioning now? just in the log again?

edit: heres the current log after it loads now with the settings you provided.

still seems like its having issues but at least it loaded up now so we are getting somewhere.

i notice it has an error at the bottom connecting to the mysql database, could it be becasuse my database is called xbmc_video and its trying to load xbmc_video58 for some reason?

http://pastebin.com/wFvsEAmU

**Maetrik** · 2011-12-13, 19:33

may is ask why a second substitution was needed in this case?

frieten · 2011-12-13, 19:35

i think we are getting somewhere Memphiz can you please bare with me.

it loaded and i tried going to tvshows and it locked up again.

i then changed somethings in my advanced.xml and i get into tv shows now without a crash.

here is my new advanced.xml

Code:
advancedsettings>

<videodatabase>

<type>mysql</type>

<host>smb://bowan-pc</host>

<port>3306</port>

<user>xbmc</user>

<pass>xbmc</pass>

<name>xbmc_video</name>

</videodatabase>

<pathsubstitution>

<substitute>

<from>special://masterprofile/Thumbnails</from>

<to>smb://bowan-pc/Media/Thumbnails/</to>

</substitute>

<substitute>

<from>special://profile/Thumbnails</from>

<to>smb://bowan-pc/Media/Thumbnails/</to>

</substitute>

</pathsubstitution>

</advancedsettings>

i tried with SMB to the mysql thinking it was that, well it didnt crash but the log is saying its still not connecting.

here is the new xbmc.log

any idea what this is all about? what can i change for it to connect to mysql since its locking up when i use ip address.

DLeavy · 2011-12-13, 20:01

You don't specify the smb in the MySQL host - plus, it has been recommended on this forum to just use the ip address as you had before.

frieten · 2011-12-13, 20:20

DLeavy Wrote:You don't specify the smb in the MySQL host - plus, it has been recommended on this forum to just use the ip address as you had before.

yes i found the error was port 3306 was not opened in windows firewall, i thought allowing it in my router is enough.

it seems its connected to the MYsql database, now my issue is when i add tvshows it just instantly scans it in and doesn't add it to the database, IE it doesnt look like its scraping.

here is the newest xbmc.log with the db errors its returning when i tried adding stuff.

at least im slowly getting somewhere, everyones input is greatly appreciated as i work through this Smile

Pillzbury · 2011-12-13, 21:02

Did you just set up the mysql according to a guide you found somewhere? If so, which guide. Your problem (at least one of them) has to do with XBMC looking for the database, finding what it thinks is the database and it being seemingly empty.

If you HAVE NOT populated your database with information yet (you've just set it up and haven't told xbmc anything at the "This folder contains..." page), then go to the mysql command prompt and type:

DROP database xbmc_video;

Then, in your advancedsettings.xml , remove the line:

<name>xbmc_video</name>

Reload XBMC. It SHOULD create a new database on its own called MyVideos58 (or something of the sort) and get rid of all database errors in the log.

This will only work if you granted the user XBMC permissions on mysql. (A command similar to "GRANT ALL ON *.* TO 'xbmc';")

frieten · 2011-12-13, 21:06

Pillzbury Wrote:Did you just set up the mysql according to a guide you found somewhere? If so, which guide. Your problem (at least one of them) has to do with XBMC looking for the database, finding what it thinks is the database and it being seemingly empty.

If you HAVE NOT populated your database with information yet (you've just set it up and haven't told xbmc anything at the "This folder contains..." page), then go to the mysql command prompt and type:

DROP database xbmc_video;

Then, in your advancedsettings.xml , remove the line:

<name>xbmc_video</name>

Reload XBMC. It SHOULD create a new database on its own called MyVideos58 (or something of the sort) and get rid of all database errors in the log.

This will only work if you granted the user XBMC permissions on mysql. (A command similar to "GRANT ALL ON *.* TO 'xbmc';")

thanks thats the sort of info i needed, i had a feeling i had to do something like this but didn't know the commands.

also yes i have been using a guide, i was following the wiki guide

http://wiki.xbmc.org/index.php?title=HOW..._libraries

will report back in a few minutes.