Ok I finally found some time to do this post so here are the things asked. Any help is really appreciated.
So lets try something simple, lets say I connect a windows (XP) version on my Netgear readyNAS NV+ which is where I store my medias and the mysql.
rocketpants Wrote:What does your advancedsettings.xml have in it
[HTML]<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.111.105</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.111.105</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>[/HTML]
rocketpants Wrote:What does the debug log say when you try and connect to the mySQL DB
Here is the log I get when I start xbmc. you can see at line 107 the errors about mysql starting
http://pastebin.com/RPBX9yWv
and here a log when I watch a file:
http://pastebin.com/TL2KNAHW
rocketpants Wrote:Are your shares accessible to the client PC
Yes, I can view the files with my local vlc player through the smb share
rocketpants Wrote:Have you set up the sources correctly using smb or other networking protocol
Yes smb, like I said I can read all the files on any xbmc. The problem is what you can read on my first post.
rocketpants Wrote:What is the directory structure of your media
Example my tv shows are:
TV Shows/[tv show name]/season 1/[name]s01exx.[blahblah].avi
rocketpants Wrote:What scraper are you using
tvdb
rocketpants Wrote:Does the scraper work on a standard XBMC install
rocketpants Wrote:What appears in your library once you have set it up
Nothing, I've got absolutely nothing! I had stuff in my library with the same files when not connected to mysql
rocketpants Wrote:What is your server and client OS
server: readyNAS NV+ clients: see my signature!
rocketpants Wrote:what is your version of XBMC?
please read my signature
rocketpants Wrote:How have you tested it out so far
I read forums for about 2 days trying to find my problem. Everyone seems to find a solution after a while but not me
. I drop all shemas on the mysql and restarted xbmc the shema and tables are created so THERE IS a connection, read for your self:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| firefly |
| frontview |
| mysql |
| mythconverg |
| slimserver |
| xbmc_music |
| xbmc_video |
+--------------------+
8 rows in set (0.03 sec)
mysql> use xbmc_video
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------------+
| Tables_in_xbmc_video |
+----------------------+
| actorlinkmovie |
| actors |
| bookmark |
| country |
| countrylinkmovie |
| directorlinkmovie |
| genre |
| genrelinkmovie |
| movie |
| path |
| settings |
| stacktimes |
| sys_seq |
| version |
| writerlinkmovie |
+----------------------+
15 rows in set (0.01 sec)
mysql>
NOW why xbmc doesn't create all the tables it need?? This part I don't get...
