Login at Kodi Home

AnalBeard · (This post was last modified: 2012-01-15, 13:26 by AnalBeard.)

Ok, so I exported my locally-based library to a single file, set up my mysql server and then tried to import. The import fails and whilst watching the debug log with tail -f i see the following appearing:

Code:
19:02 T:112115712    INFO: Loading skin file: FileBrowser.xml

19:02 T:112115712   DEBUG: ------ Window Init (FileBrowser.xml) ------

19:07 T:133435392   DEBUG: Thread Jobworker start, auto delete: 1

19:30 T:112115712   DEBUG: ------ Window Deinit (FileBrowser.xml) ------

19:30 T:112115712   ERROR: Unable to open database: xbmc_video58 [1049](Unknown database 'xbmc_video58')

19:30 T:112115712   ERROR: Unable to open database: xbmc_video57 [1049](Unknown database 'xbmc_video57')

19:30 T:112115712   ERROR: Unable to open database: xbmc_video56 [1049](Unknown database 'xbmc_video56')

19:30 T:112115712   ERROR: Unable to open database: xbmc_video55 [1049](Unknown database 'xbmc_video55')

19:30 T:112115712   ERROR: Unable to open database: xbmc_video54 [1049](Unknown database 'xbmc_video54')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video53 [1049](Unknown database 'xbmc_video53')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video52 [1049](Unknown database 'xbmc_video52')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video51 [1049](Unknown database 'xbmc_video51')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video50 [1049](Unknown database 'xbmc_video50')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video49 [1049](Unknown database 'xbmc_video49')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video48 [1049](Unknown database 'xbmc_video48')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video47 [1049](Unknown database 'xbmc_video47')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video46 [1049](Unknown database 'xbmc_video46')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video45 [1049](Unknown database 'xbmc_video45')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video44 [1049](Unknown database 'xbmc_video44')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video43 [1049](Unknown database 'xbmc_video43')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video42 [1049](Unknown database 'xbmc_video42')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video41 [1049](Unknown database 'xbmc_video41')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video40 [1049](Unknown database 'xbmc_video40')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video39 [1049](Unknown database 'xbmc_video39')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video38 [1049](Unknown database 'xbmc_video38')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video37 [1049](Unknown database 'xbmc_video37')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video36 [1049](Unknown database 'xbmc_video36')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video35 [1049](Unknown database 'xbmc_video35')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video34 [1049](Unknown database 'xbmc_video34')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video33 [1049](Unknown database 'xbmc_video33')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video32 [1049](Unknown database 'xbmc_video32')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video31 [1049](Unknown database 'xbmc_video31')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video30 [1049](Unknown database 'xbmc_video30')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video29 [1049](Unknown database 'xbmc_video29')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video28 [1049](Unknown database 'xbmc_video28')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video27 [1049](Unknown database 'xbmc_video27')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video26 [1049](Unknown database 'xbmc_video26')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video25 [1049](Unknown database 'xbmc_video25')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video24 [1049](Unknown database 'xbmc_video24')

19:31 T:112115712   ERROR: Unable to open database: xbmc_video23 [1049](Unknown database 'xbmc_video23')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video22 [1049](Unknown database 'xbmc_video22')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video21 [1049](Unknown database 'xbmc_video21')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video20 [1049](Unknown database 'xbmc_video20')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video19 [1049](Unknown database 'xbmc_video19')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video18 [1049](Unknown database 'xbmc_video18')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video17 [1049](Unknown database 'xbmc_video17')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video16 [1049](Unknown database 'xbmc_video16')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video15 [1049](Unknown database 'xbmc_video15')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video14 [1049](Unknown database 'xbmc_video14')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video13 [1049](Unknown database 'xbmc_video13')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video12 [1049](Unknown database 'xbmc_video12')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video11 [1049](Unknown database 'xbmc_video11')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video10 [1049](Unknown database 'xbmc_video10')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video9 [1049](Unknown database 'xbmc_video9')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video8 [1049](Unknown database 'xbmc_video8')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video7 [1049](Unknown database 'xbmc_video7')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video6 [1049](Unknown database 'xbmc_video6')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video5 [1049](Unknown database 'xbmc_video5')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video4 [1049](Unknown database 'xbmc_video4')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video3 [1049](Unknown database 'xbmc_video3')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video2 [1049](Unknown database 'xbmc_video2')

19:32 T:112115712   ERROR: Unable to open database: xbmc_video1 [1049](Unknown database 'xbmc_video1')

19:32 T:112115712  NOTICE: Old database found - updating from version 0 to 58

19:32 T:112115712   ERROR: SQL: The source database was unexpectedly empty.

19:32 T:112115712   ERROR: Unable to copy old database xbmc_video to new version xbmc_video58

any ideas?

edit: also, here is my advancedsettings.xml:

Code:
<advancedsettings>

<gui>    

   <algorithmdirtyregions>1</algorithmdirtyregions>

</gui>

<videodatabase>

  <type>mysql</type>

  <host>192.168.1.40</host>

  <port>3306</port>

  <user>xbmc</user>

  <pass>xbmc</pass>

  <name>xbmc_video</name>

</videodatabase>

<musicdatabase>

  <type>mysql</type>

  <host>192.168.1.40</host>

  <port>3306</port>

  <user>xbmc</user>

  <pass>xbmc</pass>

  <name>xbmc_music</name>

</musicdatabase>

<pathsubstitution>

  <substitute>

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

   <to>smb://192.168.1.40/sepulveda.tank/var/XBMC/Thumbnails/</to>

  </substitute>

</pathsubstitution>

</advancedsettings>

and also my databases:

Code:
mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| xbmc_music         |

| xbmc_video         |

+--------------------+

4 rows in set (0.00 sec)

GavinCampbell · 2012-01-15, 19:24

Did you give the xbmc rights on the sql database to create/edit databases and tables?

AnalBeard · 2012-01-15, 19:35

GavinCampbell Wrote:Did you give the xbmc rights on the sql database to create/edit databases and tables?

Code:
GRANT ALL ON *.* TO 'xbmc';

**Maetrik** · 2012-01-15, 19:48

delete xbmc_music and xbmc_video from mysql. Eden creates the databases needed on its own.

AnalBeard · 2012-01-16, 10:15

Maetrik Wrote:delete xbmc_music and xbmc_video from mysql. Eden creates the databases needed on its own.

Ok, so i did this and then re-imported. It's imported the location of my files and all their info etc, but none of my artwork is available. Whilst doing the import i watched the log file and it kept making reference to the Thumbnails/ directory and the fact that it couldn't find it. As you can see from my advancedsettings.xml, I've also got that hosted on my fileserver. I know for a fact that the directory path is correct, so why could this happen? Permissions error possibly?

AnalBeard · 2012-01-16, 14:03

Ok, so in order to clarify things a little, this is at the start of the log when XBMC first launches:

Code:
22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/Artists

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/Artists

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/LastFM

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/LastFM

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/Fanart

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/Fanart

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/Fanart

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/Fanart

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/Bookmarks

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/Bookmarks

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/generated

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/generated

22:50 T:79458304    INFO: thumbnails folder: special://masterprofile/Thumbnails

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/0

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/0

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/0

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/0

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/0

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/0

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/generated/0

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/generated/0

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/1

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/1

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/1

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/1

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/1

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/1

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/generated/1

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/generated/1

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/2

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/2

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/2

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/2

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/2

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/2

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/generated/2

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/generated/2

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Music/3

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/3

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/3

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/3

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/3

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/3

22:50 T:79458304   ERROR: Create - Error( Permission denied )

22:50 T:79458304   ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/generated/3

22:50 T:79458304   ERROR: Create - Error creating special://masterprofile/Thumbnails/generated/3

22:50 T:79458304   ERROR: Create - Error( Permission denied )

I've not quoted all the errors because of the character limit, but it's the same for each folder within the Thumbnails/ directory.

Also, the relevant part of my advancedsettings.xml:

Code:
<pathsubstitution>

  <substitute>

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

   <to>smb://192.168.1.40/sepulveda.tank/var/XBMC/Thumbnails/</to>

  </substitute>

</pathsubstitution>

the only difference between the Thumbnails directory on the ATV and on the fileserver is the ownership, it's simon Confused

imon on the server but it's mobile:mobile on the ATV.

**Maetrik** · (This post was last modified: 2012-01-16, 14:21 by Maetrik.)

Dont you need username/password for your smb share? As your log says, XBMC is not allowed to create the folders in your thumbnail directory. Make sure to set correct permissions and set a proper smb pathsubstitution. If its simon Confused

imon then it should be

Code:

smb://simon:[email protected]/sepulveda.tank/var/XBMC/Thumbnails/

in your advancedsettings.xml

AnalBeard · 2012-01-16, 23:40

Maetrik Wrote:Dont you need username/password for your smb share? As your log says, XBMC is not allowed to create the folders in your thumbnail directory. Make sure to set correct permissions and set a proper smb pathsubstitution. If its simonimon then it should be

Code:
smb://simon:[email protected]/sepulveda.tank/var/XBMC/Thumbnails/

in your advancedsettings.xml

That did the trick, thanks! I should have realised that giving XBMC the username/pass for the samba share wouldn't be enough for it to access the thumbnails directory on launch too. Working beautifully now.

lenni-online · 2012-01-16, 23:41

Hi Together.
If have the same problem while trying to create a central mySQL Database.
I just followed the "how to" everything looks like in the tutorial, bit it dosenßt work at all.
I have the same errors in xbmc.log an xbmc freezes on startup showing the bootlogo.
Im a using the default User xmbc and password. The database is located on my nas. At first i created the two databases (xbmc_video & xbmc_music) by myself. In a second step ereased them and tryed to let them be created by Eden itselfe.
Like described in the tutorial, I have a databaseuser "xbmc" like above with all right incl.Grant.
so my first question. are am i too imatien? I´v waited around 5 minutes before I killed xbmc. How long should it take and is it normal that xbmc s "trying" all kinds of Databases (it´s counting down from 58 to 0)

sincerly lenni

AnalBeard · (This post was last modified: 2012-01-16, 23:49 by AnalBeard.)

lenni-online Wrote:Hi Together.
If have the same problem while trying to create a central mySQL Database.
I just followed the "how to" everything looks like in the tutorial, bit it dosenßt work at all.
I have the same errors in xbmc.log an xbmc freezes on startup showing the bootlogo.
Im a using the default User XBMC and password. The database is located on my nas. At first i created the two databases (xbmc_video & xbmc_music) by myself. In a second step ereased them and tryed to let them be created by Eden itselfe.
Like described in the tutorial, I have a databaseuser "xbmc" like above with all right incl.Grant.
so my first question. are am i too imatien? I´v waited around 5 minutes before I killed xbmc. How long should it take and is it normal that xbmc s "trying" all kinds of Databases (it´s counting down from 58 to 0)

sincerly lenni

Lenni, watch your xbmc.log and see if the reason is given in there. also, did you uncomment the line in the conf file that allows access to mysql from other devices? it sounds like it's not connecting to the sql server.

lenni-online · 2012-01-17, 00:04

Here is a Sample of the xbmc.log:
DONE initializing playlistplayer
22:02:24 T:6628032 ERROR: Unable to open database: xbmc_video58 [1049](Unknown database 'xbmc_video58')
I think it schound´t be xbmc_video58, or am I wrong? It should be without the number?

"also, did you uncomment the line in the conf file that allows access to mysql from other devices?" just give a hint, with conf file do you mean?

please be aweare, i´m absolutly new in Linux, so sometimes it would take a little patience Smile

greets lenni

~~Ned Scott~~ · 2012-01-17, 04:53

With *58 is correct.

AnalBeard · 2012-01-17, 14:44

lenni-online Wrote:Here is a Sample of the xbmc.log:
DONE initializing playlistplayer
22:02:24 T:6628032 ERROR: Unable to open database: xbmc_video58 [1049](Unknown database 'xbmc_video58')
I think it schound´t be xbmc_video58, or am I wrong? It should be without the number?

"also, did you uncomment the line in the conf file that allows access to mysql from other devices?" just give a hint, with conf file do you mean?

please be aweare, i´m absolutly new in Linux, so sometimes it would take a little patience

greets lenni

Quote:Linux: Comment out the following line in the MySQL configuration file (/etc/mysql/my.cnf)
from: bind-address = 127.0.0.1
to : #bind-address = 127.0.0.1

have you done that?

lenni-online · 2012-01-21, 15:32

Hi togethter.
One week late.
XBMC has created the database (MyVideos58) and filled it up with contend.
As we would say in germany "so far, so good"
Now I´m trying ti speed it up a little. As described in may posts, Lantin 1 is too by choosen while creating the database and the tables. XBMC dosen´t give me a choise. It stays on UTF8.
When I try to create a database on my own, XBMC crashes on startup (Message:no table found" I tried this with the <name>MyVideos58</name> within advanced settings.xml and without.
Anybody a idea where i can set up the collation characterset?

greets Lenni