XMBC and MySQL

[rbthompsonv]

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?

[mk01]

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?

[rikardo1979]

any help in these threads? we have quite a few in forum
http://forum.xbian.org/thread-1248.html?highlight=mysql
http://forum.xbian.org/thread-1133.html?highlight=mysql

[rbthompsonv]

OK... Can't login from 101 to 101... Will check things in the morning...

[rbthompsonv]

(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

[rbthompsonv]

(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..

[mk01]

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/