2012-12-30, 03:53
]Hi All,
Please bare with me and I ask for your patience as I am a noob to this and certainly no IT guru.
I've been using XBMC on several devices for a while an love it but have recently taken the plunge to get my databases centralised. I have 3 units, 1 acer revo 3700 running openELEC, and 2 windows 7 PC's (one 32bit Home premium and one 64bit ultimate). All 3 are running XBMC 11 eden.
I have all my media stored on a readynas NV+ version 1 (1024MB RAM upgrade) which has myphpadmin, mysqlon and php5 addons all running.
I seem to have eventually done all the requirements with sources.xml and advancedsettings.xml files and copied them to all 3 devices but I have several issues (incidentally I am using all SMB protocols for my sources and / not \.....my databases don't seem to be updating when I start/stop movies and resume on another device and all 3 instances of XBMC are running really slowly. when I start a second device with xbmc running it populates the Videos section with my movies but I don't get a tab on the homescreen to go directly to Movies but have to navigate through the files option underneath videos to view what is available, that is unless i update the source and set scrapers for the movies source (will this be mucking it up maybe...should I just leave it?..presumably I don't just have a master PC that I have to use to update librarys and scrape movie info?)
I have also added the pathsubstitution script in the advancedsettings.xml for thumbnail sharing.
I have checked the XBMC logs and am getting the ERROR: Unable to open database: MyVideos60 [2003](Can't connect to MySQL server on 'localhost' (10061)). Is this anything to worry about? as I seemed to have this error when I did the setup and the databases created OK on mysql. I have forwarded port 3306 on my router to the NAS (not sure if i need to do this!) and I have tested with all firewalls off on local machines....I have read hundreds of posts on various sites but don't seem to be able to find a definitive answer.
i have myphpadmin setup using host name localhost
server socket as /var/run/mysqld/mysqld.sock
conection type: socket
php extension :mysqli
connect without password ticked and allow logins without password ticked.
I have used localhost in advancedsettings.xml, port 3306, user xbmc and password xbmc
Hope someone can help
xbmc log
http://pastebin.com/embed_js.php?i=fae7Ey8F
sources.xml
http://pastebin.com/embed_js.php?i=yR167iRK
advancedsettings.xml
http://pastebin.com/embed_js.php?i=WH3NJtpL
Matt
Please bare with me and I ask for your patience as I am a noob to this and certainly no IT guru.
I've been using XBMC on several devices for a while an love it but have recently taken the plunge to get my databases centralised. I have 3 units, 1 acer revo 3700 running openELEC, and 2 windows 7 PC's (one 32bit Home premium and one 64bit ultimate). All 3 are running XBMC 11 eden.
I have all my media stored on a readynas NV+ version 1 (1024MB RAM upgrade) which has myphpadmin, mysqlon and php5 addons all running.
I seem to have eventually done all the requirements with sources.xml and advancedsettings.xml files and copied them to all 3 devices but I have several issues (incidentally I am using all SMB protocols for my sources and / not \.....my databases don't seem to be updating when I start/stop movies and resume on another device and all 3 instances of XBMC are running really slowly. when I start a second device with xbmc running it populates the Videos section with my movies but I don't get a tab on the homescreen to go directly to Movies but have to navigate through the files option underneath videos to view what is available, that is unless i update the source and set scrapers for the movies source (will this be mucking it up maybe...should I just leave it?..presumably I don't just have a master PC that I have to use to update librarys and scrape movie info?)
I have also added the pathsubstitution script in the advancedsettings.xml for thumbnail sharing.
I have checked the XBMC logs and am getting the ERROR: Unable to open database: MyVideos60 [2003](Can't connect to MySQL server on 'localhost' (10061)). Is this anything to worry about? as I seemed to have this error when I did the setup and the databases created OK on mysql. I have forwarded port 3306 on my router to the NAS (not sure if i need to do this!) and I have tested with all firewalls off on local machines....I have read hundreds of posts on various sites but don't seem to be able to find a definitive answer.
i have myphpadmin setup using host name localhost
server socket as /var/run/mysqld/mysqld.sock
conection type: socket
php extension :mysqli
connect without password ticked and allow logins without password ticked.
I have used localhost in advancedsettings.xml, port 3306, user xbmc and password xbmc
Hope someone can help
xbmc log
http://pastebin.com/embed_js.php?i=fae7Ey8F
sources.xml
http://pastebin.com/embed_js.php?i=yR167iRK
advancedsettings.xml
http://pastebin.com/embed_js.php?i=WH3NJtpL
Matt