Not sure if I should be posting this here... but having MAJOR difficulties getting my Xbian driven Raspberry Pis to sync with my SQL server... This is my setup:
Office Dell Optiplex running Ubuntu 12.04, 1 250gb hhd running the OS, 2x2tb hard drives in raid put together with LVM and sharing 2 folders: TV and Movies... The videos are ported into XBMC as SMB://192.168.1.101/Movies (or TV)...
Server is running XBMC at all times, and I essentially coped and pasted the advancedsettings.xml from the wiki... changing the IP to 192.168.1.101 (The IP of my server)
I put the same exact xml on each raspberry pi under .xbmc/userdata
The RPis see the shared folders and I link to them via SMB://192.168.1.101/Movies/ and SMB://192.168.1.101/TV/ (Named Movies and TV Shows respectively on each RPi)
1 Rpi and the Server are wired connections, 1 RPi is wireless (My mac is also running XBMC and shared with the same structure... with no joy)
Set up the MySQL server as per the wiki instructions...
How can I troubleshoot this situation, or what do I look for? What other info can I supply?
with mysql, the steps to check would be:
1) check whether mysql is accessible from .101 itself. for instance with:
Code:
mysql -u user_name_you_set -p
2) check whether the mysql is accessible for the user from other IPs (by default the access is just for localhost (127.0.0.1). you can do that still from the optiplex.
Code:
mysql -u user_name_you_set -h 192.168.1.101 -p
3) then check this from RPI…
btw: /home/xbian/.xbmc/temp/xbmc.log is quite useful in that case, what is in on the RPI?
OK... Can't login from 101 to 101... Will check things in the morning...
(3rd Sep, 2013 11:58 PM)mk01 Wrote: [ -> ]with mysql, the steps to check would be:
1) check whether mysql is accessible from .101 itself. for instance with:
Code:
mysql -u user_name_you_set -p
2) check whether the mysql is accessible for the user from other IPs (by default the access is just for localhost (127.0.0.1). you can do that still from the optiplex.
Code:
mysql -u user_name_you_set -h 192.168.1.101 -p
3) then check this from RPI…
btw: /home/xbian/.xbmc/temp/xbmc.log is quite useful in that case, what is in on the RPI?
OK, I can connect TO 101 FROM 101, but only locally... If I try to connect with the -h I get can not connect to host.
It also seems as if there isnt a password set for the xbmc user... I tried reading the docs for MySQL... but I must have the syntax wrong for assigning the user xbmc the password of xbmc...
Any pointers? (Im using: SET PASSWORD FOR 'xbmc' = PASSWORD (xbmc); But it kicks back saying theres an error on line 1
(4th Sep, 2013 10:00 PM)rbthompsonv Wrote: [ -> ] (3rd Sep, 2013 11:58 PM)mk01 Wrote: [ -> ]with mysql, the steps to check would be:
1) check whether mysql is accessible from .101 itself. for instance with:
Code:
mysql -u user_name_you_set -p
2) check whether the mysql is accessible for the user from other IPs (by default the access is just for localhost (127.0.0.1). you can do that still from the optiplex.
Code:
mysql -u user_name_you_set -h 192.168.1.101 -p
3) then check this from RPI…
btw: /home/xbian/.xbmc/temp/xbmc.log is quite useful in that case, what is in on the RPI?
OK, I can connect TO 101 FROM 101, but only locally... If I try to connect with the -h I get can not connect to host.
It also seems as if there isnt a password set for the xbmc user... I tried reading the docs for MySQL... but I must have the syntax wrong for assigning the user xbmc the password of xbmc...
Any pointers? (Im using: SET PASSWORD FOR 'xbmc' = PASSWORD (xbmc); But it kicks back saying theres an error on line 1
WORKAROUND: Created a new account on MySql called media... worked flawlessly once put into advancedsettings.xml as media/media..
I suppose the problem will be in the defaults of mysql accepting connections only from localhost for you user xbmc. You can check that by using the "mysql" tool.
Code:
mysql -h localhost -u XXXX -p
connect mysql;
select Host,User,Password from user;
if there is no "%" in the "Host" column for a specific user (% means any host), you can update the table with
Code:
update user set Host='%' where User='youruser';
check some guides or install Windows client to manage mysql DBs -
http://dev.mysql.com/downloads/tools/workbench/