[charrua]

I came back to post an update on my timings to say that there is a problem.

No matter how many permissions i give the user i.e. full DBA, i get the following errors. Obviously the timings are meaningless when there are errors:

Code:

23:32:15 T:4040 M:3117604864 WARNING: VIDEO database configuration is experimental.
23:32:15 T:4040 M:3117543424  NOTICE: Getting hardware information now...
23:32:15 T:4040 M:3117527040  NOTICE: Checking resolution 11
23:32:15 T:4040 M:3117551616  NOTICE: Default DVD Player: dvdplayer
23:32:15 T:4040 M:3117539328  NOTICE: Default Video Player: dvdplayer
23:32:15 T:4040 M:3117539328  NOTICE: Default Audio Player: paplayer
23:32:15 T:4040 M:3117559808  NOTICE: Loading media sources from special://masterprofile/sources.xml
23:32:15 T:4040 M:3112566784  NOTICE: initializing playlistplayer
23:32:15 T:4040 M:3112558592  NOTICE: DONE initializing playlistplayer
23:32:15 T:4040 M:3112546304  NOTICE: load default skin:[Confluence]
23:32:15 T:4040 M:3106430976   ERROR: SQL: The table does not exist
                                            Query: select count(1) from tvshow
23:32:15 T:4040 M:3106390016   ERROR: CVideoDatabase::HasContent failed
23:32:17 T:4040 M:3103436800  NOTICE: initialize done
23:32:17 T:4040 M:3103436800  NOTICE: Running the application...
23:32:17 T:4040 M:3103420416  NOTICE: Webserver: Starting...
23:32:17 T:4040 M:3103375360  NOTICE: WebServer: Started the webserver
23:32:17 T:4040 M:3103350784  NOTICE: ES: Starting event server
23:32:17 T:4056 M:3103236096  NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
23:32:17 T:4056 M:3103981568  NOTICE: UDP: Listening on port 9777
23:32:17 T:4040 M:3102797824   ERROR: SQL: The table does not exist
                                            Query: select count(1) from musicvideo
23:32:17 T:4040 M:3102793728   ERROR: CVideoDatabase::HasContent failed
23:32:17 T:3076 M:3094691840  NOTICE: -->Python Interpreter Initialized<--
23:32:17 T:4040 M:3092451328   ERROR: SQL: The table does not exist
                                            Query: select * from movieview order by idMovie desc limit 4
23:32:17 T:4040 M:3092451328   ERROR: CVideoDatabase::GetArbitraryQuery failed
23:32:17 T:4040 M:3092430848   ERROR: SQL: The table does not exist
                                            Query: select * from episodeview order by idepisode desc limit 4
23:32:17 T:4040 M:3092430848   ERROR: CVideoDatabase::GetArbitraryQuery failed

Probably the errors are due to some SQL queries done from a script that it's trying to select from the tvshow view that doesn't exist in the db anymore. The issue is not related to XBMC MySQL feature, but with the script/s trying to access view/s that no longer exists in the db.

[crashnburn]

Its okay if I dont get the play / pause sync. But, it would be nice to get the same skin and other fan art etc all Library settings to be the same on the multiple Apple TV & XBox XBMCs on my home network.

[xexe]

Probably the errors are due to some SQL queries done from a script that it's trying to select from the tvshow view that doesn't exist in the db anymore. The issue is not related to XBMC MySQL feature, but with the script/s trying to access view/s that no longer exists in the db.

If that is the case it has to be the confluence skin as this is the instant after startup on a clean install.

Seems the import completed but something went wrong. Lots of entry for movies, none for tv and none of the library views work.

Will try to debug.

Edit: tried again and no tv table fo any sort is being created. can someone dump a .sql export of the xbmc_video database for me somewhere for me to compare cause I am thinking it should contain more tables than mine does
Edit2: I dumped the structure quickly here http://pastebin.com/k2iuTbkP you can see nothing tv related at all. from what i can see in the svn there should be tv versions of all the movie tables. confused
Edit3: Special thanks to firnsy. Turns out my choice of UTF-8 char-set was the issue. Changed to Latin1 and the import is going strong. Were a few hours in now estimate perhaps 6 more.
Edit4: well its 7 hours later and boy was I off the mark. re-estimate another 12 hours. not the fastest thing ever

[xexe]

Well the import finally completed.

For reference it took 48 hours almost to the minute. No small amount of time but the data looks good.

[ringgh0st]

as i said some posts before i now have a mixed home with windows and mac os pc's

since changing to this im not able to go the symlink way anymore because the mountpoints differ (f.i. mac: //192.168.*.1/movies is mounted to /volumes/movies while windows movies is mounted @ \\192.168.*.1\movies)

anyone has a solution to get it back working?

when i install a mysql server like firnsy described the problem will be the same i think, isnt isnt it?

[jmarshall]

Hmm, that seems WAY too long. Mind providing your export?

Cheers,
Jonathan

[xexe]

jmarshall can we use the Fake FS library to test this? I am loathed to let my lib list out into the world.

I dropped a copy to firsny of the fake fs a few days ago.

[jmarshall]

Fake is fine - I just want some idea of what's taking so long.

[firnsy]

I have one question though: I've got the database on the server, and everything looks good, except none of my thumbnails are present except on the machine I initially used to scrape.

Yes, this is a side effect and you will still have to sync your thumbnail cache between boxes. During the new db rewrite this will be addressed.

edit: just updated my htpc box and things are running super slow. don't see anything obvious in the debug log... I'm no mysql expert, is there something simple that could be hugely slowing things down. From my mac to my linux server things are nice and snappy, but from my linux htpc to my linux server it is super slow.

of note, when I initially tried to connect to the database I created using my mac, it would not play back the files b/c it said they could not be found. I then created a new database on the server and started scanning things into it from the htpc. Its still super slow, but once the video stream is started it will playback HD video no problem. The slowness seems to be due solely to reading the database.

You have to remember that there is no optimisation done from the mysql side of the house, and this patch was cleaned up to get committed to the mainline and get some airtime.

There are bound to benefits gained from tuning your mysql server. For those who have trepidations about this, remember it is an advanced feature.

[firnsy]

as i said some posts before i now have a mixed home with windows and mac os pc's

since changing to this im not able to go the symlink way anymore because the mountpoints differ (f.i. mac: //192.168.*.1/movies is mounted to /volumes/movies while windows movies is mounted @ \\192.168.*.1\movies)

anyone has a solution to get it back working?

when i install a mysql server like firnsy described the problem will be the same i think, isnt isnt it?

If the PC/Mac's all access the media by the same remote path (eg smb://mediaserver/videos/...) then I don't believe you will have this issue.

[Swifty]

Guys I have a Synology CS407 too and have setup the MySql database for shared database in XBMC, it's been running nicely for a few weeks now.

If you need some pointers let me know.

[Swifty]

Ok, spoke a little too soon

Updated to build 29325 just now and it fails to update the database version;

Code:

18:18:43 T:3078924160 M:932675584   DEBUG: CDatabase: Connecting to database xbmcvideo at 192.168.1.252:3306
18:18:43 T:3078924160 M:932675584  NOTICE: Attempting to update the database xbmcvideo from version 35 to 37
18:18:43 T:3078924160 M:932675584   DEBUG: Mysql Start transaction
18:18:43 T:3078924160 M:932675584   DEBUG: Mysql execute: alter table path add exclude bool
18:18:43 T:3078924160 M:932675584   ERROR: SQL: Undefined MySQL error: Code (1060)
                                            Query: alter table path add exclude bool
18:18:43 T:3078924160 M:932675584   ERROR: Error attempting to update the database version!
18:18:43 T:3078924160 M:932675584   DEBUG: Mysql rollback transaction
18:18:43 T:3078924160 M:932675584   ERROR: Can't update the database xbmcvideo from version 35 to 37

SQL user has full rights to the DB.
I don't expect it to be fixed as I know everything is in flux.. just posting up the info incase it's useful
Removing the DB and letting XBMC create a fresh one seems to work ok.

[ringgh0st]

offtopic:

Ok, spoke a little too soon

Updated to build 29325 just now and it fails to update the database version;

mhh. but where did you get that nightly from? latest nightly for win32 @ the mirrors is 28256

-> http://mirrors.xbmc.org/nightlies/win32/

ontopic:
@firnsy: jep if i'd only knew how to achive it? ill try it tonight again but had always no luck with my mac mini (im a mac noob ). im mounting the NAS-shares through a little applescript because the mac mini dosnt remember the shares like windows pc's do.

when im in xbmc i had no luck looking for the smb mounts. i do not know why, maybe its a problem with my synology NAS.


@swifty: do you just installed the synology phpmyadmin package and configured a new user? then everything went fine?
i tried it right now - setup on the synology was really easy.

but nothing happens. i inserted the necessary lines in the advancedsettings.xml:

Code:

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

but when i check the log it seems that xbmc doesnt recognize this setting? it does not try to connect to the mysql database it asap loads the standard database:

Code:

21:36:21 T:8208 M:2460504064   DEBUG: CDatabase: Connecting to database MyVideos34.db at C:\Users\xxx\AppData\Roaming\XBMC\userdata\Database:
21:36:21 T:8208 M:2460069888   DEBUG: CDatabase: Connecting to database MyVideos34.db at C:\Users\xxx\AppData\Roaming\XBMC\userdata\Database:
21:36:21 T:8208 M:2459959296   DEBUG: Load Home.xml: 33.62ms

any suggestions?

[Swifty]

ringg0hst: I am using henning pingels builds of the PVR-Testing2 branch, I should have probably mentioned that

Yes, it was quite easy to set the mysql database on the CS407, login to the NAS over the web interface and go to Network Services > Web Services, then enable web services and Mysql functionality.
Now head over to the synology website and get the phpmyadmin package, go into package management on the NAS and install it.
Now simply browse to the phpmyadmin page using the link it provides in package management and add a user (default login is root, no password) then configure your advancedsettings.xml accordingly and let XBMC do the rest

[ringgh0st]

ringg0hst: I am using henning pingels builds of the PVR-Testing2 branch, I should have probably mentioned that

Yes, it was quite easy to set the mysql database on the CS407, login to the NAS over the web interface and go to Network Services > Web Services, then enable web services and Mysql functionality.
Now head over to the synology website and get the phpmyadmin package, go into package management on the NAS and install it.
Now simply browse to the phpmyadmin page using the link it provides in package management and add a user (default login is root, no password) then configure your advancedsettings.xml accordingly and let XBMC do the rest

this was exactly what i did. but no luck. anyways (follow my post before). i'll try another pc. i HAS TO WORK.