[k1rld5]

Hi all,

I'm having issues with my setup.

I do have a AppleTV + win7 both running same version of XBMC (latest beta 4)

On aTV, I did set it up to boot directly in XMBC (lot faster and easier)

The issue is that when doing that, I do not have access to my mysql DB on remote server :

Starting XBMC, Platform: Mac OS X (8.8.2 i386). Built on Oct 28 2010 (SVN:35068)
...
14:01:37 T:2684407808 M: 62967808 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
14:01:37 T:2684407808 M: 62967808 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<skiploopfilter>8</skiploopfilter>
<osx_gl_fullscreen>true</osx_gl_fullscreen>
<videodatabase>
<type>mysql</type>
<host>192.168.1.7</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.7</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
14:01:37 T:2684407808 M: 62967808 WARNING: VIDEO database configuration is experimental.
....
14:01:41 T:2684407808 M: 30392320 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.1.7' (65))
14:01:41 T:2684407808 M: 30392320 ERROR: Unable to open database at host: 192.168.1.7 db: xbmc_video (old version?)
14:01:41 T:2684407808 M: 30392320 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.1.7' (65))
14:01:41 T:2684407808 M: 30388224 ERROR: Unable to open database at host: 192.168.1.7 db: xbmc_video (old version?)
14:01:41 T:2684407808 M: 30384128 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.1.7' (65))
14:01:41 T:2684407808 M: 30384128 ERROR: Unable to open database at host: 192.168.1.7 db: xbmc_video (old version?)
14:01:41 T:2684407808 M: 30384128 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.1.7' (65))
14:01:41 T:2684407808 M: 30380032 ERROR: Unable to open database at host: 192.168.1.7 db: xbmc_video (old version?)

When I ping, host is reachable, of course, mysql server is running fine there

I have to exit xbmc, go back to finder then start it from the menu. When doing that it works fine (start searching for updates, ...)

Any ideas ?

[k1rld5]

nobody has the same issue ? Nobody can help ?

Looks like something isn't properly initialised with multifinder, but can't finf anything in the logs

[.mad]

I ran in a similar problem,
it looks like you haven't configured the mysql server for access from a remote computer.

In the mysql config file "my.cnf" (on Ubuntu that file is under /etc/mysql/my.cnf, you have to check where it is on whatever OS you are running the mysql Server) under the [mysqld] section find the entry that reads
bind-adress = 127.0.0.1

and change it to match your servers IP adress and restart mysql

If it still doesn't connect after that maybe check if port 3306 is blocked on the server

cheers
.mad

[k1rld5]

Thanks .mad, but maybe It wasn't clear :

If I quit then restart XBMC then I can connect fine and have all my mysql livrary available...

Only when XBMC is autostarted with multifinder I have the problem

[Ogi010]

This probably isn't it, but is port 3306 open on your MySql server? ... that gave me trouble. Also it probably doesn't matter but I had the <name> tag above <user> and <pass> tags.

Best of luck!

[konan]

Can you run any script from the ATV that tests the MySql connection when XBMC can not connect? You need to figure out whether XBMC depends on any OSX configuration to connect to MySql or not. If some other script/program can connect to MySql but XBMC can not then post a bug because it's obviously an XBMC problem. However I myself can not imagine why would XBMC rely on any OS settings to connect to MySql. May be something wrong with the TCP/IP stack config?

BTW, how do you configure XBMC to start up automatically? I'd like to test it too.

[k1rld5]

I can connect by SSH to the ATV when started, so I should be able to run any script.

XMBC is started by enabling the advanced settings in launcher then choosing to boot directly with XBMC : http://forum.xbmc.org/showpost.php?p=523854&postcount=1

I did already verify that I can properlyping my mysql server with no problem, and yes, for me it is a XBMC issue, either inside it either because some dependancies are not started with multifinder (but I did a diff between running process before (autoboot) and after (stop and restart) and can't find any new/different processes)

[konan]

I can connect by SSH to the ATV when started, so I should be able to run any script.

Pinging the server is not enough since the ping does not test the connection with the MySql per se. So the obvious way would be to install a mysql command line utility on ATV and try to run it from SSH and see if it can connect to your MySql server. If it can then of course something is wrong with XBMC. If it cannot may be it gives you some extended diagnostics that'll help with troubleshooting the problem.

However I can not help with the mysql installation. On MySql web site there is an installer download for OS X so if you feel comfortable enough with SSH on ATV you could try.

[k1rld5]

I can ftp to that port on the mysql server :
-bash-2.05b$ ftp -P 3306 192.168.1.7
Connected to 192.168.1.7.


There is no telnet on atv so can't test more than this... Will check if I can get a mysql client running

[konan]

The official troubleshooting guide is here http://dev.mysql.com/doc/refman/5.5/en/c...erver.html but I am not sure if it's helpful. My XBMC on ATV OSX can connect to MySql but I am not using auto start so this is where the problem is I guess.

[k1rld5]

Thanks but that isn't really useful... the mysql server is running fine... I can access it with no issue (have a website running and even phpmyadmin, that is properly showing the tables)

The issue is more with XBMC that can't access it when started with multifinder autoboot (but fine when started manually)

[ktjensen]

I noticed the same issue when i automatically started XBMC versis starting it manually.

No solution yet.

[konan]

I noticed the same issue when i automatically started XBMC versis starting it manually.

No solution yet.

I suggest either you or k1rld5 log a bug for XBMC OS X. Do not forget to list all the steps required to reproduce the problem. That will ensure that someone from the dev team will come across sooner or later.

[prongATO]

I had this same issue with a Win7 x64 server running mysql and an XBMCLive box trying to access the database. It took me a day to realize ubuntu wasn't loading my network card with the correct driver. Once that was solved I was having the start-up database connect problem you were. Since the box would connect to the database with no problems after it was already loaded (startx, then xbmc) I thought maybe the autoload wasn't giving the network card long enough to initialize. I don't know anything about OSX but increasing the GRUB timer gave mine enough time to initialize the network adapter and connect to the database.

When you set it to auto-load XBMC, is there a way you can increase a timer on load? You might give that a shot.