+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
- dpaget21 - 2010-06-27 04:16
charrua Wrote:Don't use root as the user, use a different one, it should work.
I have tried that
I think my problem might be with my mysql setup
I have some screen shots of mysql setup but can't attach them here. Sorry I am new to both my sql and xbmc
This is the error in the log file
ERROR: Unable to open database: xbmcvideo [2002](Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2))
- MrDVD - 2010-06-29 23:55
Hallo all,
it looks like that xbmc cant update the db version from 34(svn28256) to 40(svn31495).
Code:
22:49:01 T:3023214464 M:3359436800 NOTICE: Attempting to update the database xbmc_video from version 34 to 40
22:49:01 T:3023214464 M:3359662080 DEBUG: Mysql Start transaction
22:49:01 T:3023214464 M:3359662080 DEBUG: Mysql execute: alter table settings add NonLinStretch bool
22:49:01 T:3023214464 M:3359662080 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: alter table settings add NonLinStretch bool
22:49:01 T:3023214464 M:3359576064 ERROR: Error attempting to update the database version!
22:49:01 T:3023214464 M:3359576064 DEBUG: Mysql rollback transaction- ringgh0st - 2010-06-30 09:43
MrDVD Wrote:Hallo all,
it looks like that xbmc cant update the db version from 34(svn28256) to 40(svn31495).
When i create a new db with svn31495 it works.Code:
22:49:01 T:3023214464 M:3359436800 NOTICE: Attempting to update the database xbmc_video from version 34 to 40
22:49:01 T:3023214464 M:3359662080 DEBUG: Mysql Start transaction
22:49:01 T:3023214464 M:3359662080 DEBUG: Mysql execute: alter table settings add NonLinStretch bool
22:49:01 T:3023214464 M:3359662080 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: alter table settings add NonLinStretch bool
22:49:01 T:3023214464 M:3359576064 ERROR: Error attempting to update the database version!
22:49:01 T:3023214464 M:3359576064 DEBUG: Mysql rollback transaction
same prob here. confirmed! sad ;/
- charrua - 2010-07-05 06:50
dpaget21 Wrote:I have tried that
I think my problem might be with my mysql setup
I have some screen shots of mysql setup but can't attach them here. Sorry I am new to both my sql and xbmc
This is the error in the log file
ERROR: Unable to open database: xbmcvideo [2002](Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2))
Try adding these lines to the MySQL config file usually located in /opt/local/etc/mysql5/my.cnf:
Code:
[mysqld_safe]
socket = /opt/local/var/run/mysql5/mysqld.sock
[client]
socket = /opt/local/var/run/mysql5/mysqld.sock- robinsj - 2010-07-06 01:15
Okay, so I am really hoping one of you guys can help me out. I am pretty much a newb at mysql stuff... But here is what I got...
I have added this to the advancedsettings.xml file
<videodatabase>
<type>mysql</type>
<host>192.168.0.189</host>
<port>3306</port>
<user>xbmc</user>
<pass></pass>
<name>xbmc_movies</name>
</videodatabase>
mysql runs on my unraid server. I created the xbmc user as stated i think on page 14 of this thread. Then i ran xbmc, but it didn't create the database. I also didn't get any errors in the xbmc.log... here is a post from the log...
17:11:48 T:3360 M:1541582848 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
17:11:48 T:3360 M:1541578752 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<video>
<defaultplayer>dsplayer</defaultplayer>
</video>
<videodatabase>
<type>mysql</type>
<host>192.168.0.189</host>
<port>3306</port>
<user>xbmc</user>
<pass />
<name>xbmc_movies</name>
</videodatabase>
</advancedsettings>
17:11:48 T:3360 M:1541574656 WARNING: VIDEO database configuration is experimental.
17:11:48 T:3360 M:1541574656 NOTICE: Getting hardware information now...
17:11:48 T:3360 M:1541574656 NOTICE: Checking resolution 12
17:11:48 T:3360 M:1541574656 NOTICE: Default DVD Player: dvdplayer
That is the only thing posted in the log about mysql, nothing else. So then I manually created the mysql database named xbmc_movies, i believe I got that from a post on page 15 or 16..... I only have 2 movies on my server right now that I am using to mess around with this, but I don't believe it is doing anything with the database, and I am about to start going crazy cause I have no idea what else to do.
I look at the database file on the network and it is still only 1 kb, and the last access it has had was when i first created it. Is there something I can do from the mysql command line to test it?? Help, please!!
- charrua - 2010-07-06 02:34
robinsj Wrote:I look at the database file on the network and it is still only 1 kb, and the last access it has had was when i first created it. Is there something I can do from the mysql command line to test it?? Help, please!!
Activate debug mode in XBMC, delete the db you've created in MySQL, restart XBMC, upload the full log to pastebin.com and post the link here if you want us to try to help you.
- robinsj - 2010-07-06 03:08
Thanks so much for the response... deleted the db, turned on debugging and here ya go...
http://pastebin.com/WFQHXmXz
Looking through it, right after it loads home.XML it says it is missing essential MySQL information. Is there someplace else I am supposed to enter the MySQL info?
- charrua - 2010-07-06 04:59
robinsj Wrote:Thanks so much for the response... deleted the db, turned on debugging and here ya go...
http://pastebin.com/WFQHXmXz
Looking through it, right after it loads home.XML it says it is missing essential MySQL information. Is there someplace else I am supposed to enter the MySQL info?
No, just in the advancedsettings.xml
Create a password for user xbmc in MySQL server, add it to the <pass></pass> tag in the advancedsettings.xml file and restart xbmc.
- robinsj - 2010-07-06 05:10
Hmm... How do I go about creating a password for user xbmc? I am a totally newb when it comes to mysql...
Did a google search and figured that out.....
It works, thank you for pointing me in the right direction, i really was racking my brain on that one....
- robinsj - 2010-07-06 06:02
Okay so getting closer... I believe this has something to do with mysql, because it was working when I didn't have mysql turned on. The recentlyadded script isn't showing anything. It shows the total counts for movies and everything, but when I go into it, it should show me the last 5 added, and it is just a blank list with nothing in it? Is there something else I need to change for this to work also? Thanks so much for your help!!
EDIT:
Been doing some testing, and if I have this option totals=true in onfocus in the skin, then i get the total of the movies, but i get no movies listed. If i take it out, i get the recent movies, but no movie totals..... odd