[andcbii]

Here is my situation. I recently moved and now I can not get XBMC to work with MySQL. Before I moved everything was working fine. Is there something special I have to do when I restart the server that MySQL 5.5 is installed on? Everything is connected to the network and working just fine, except xbmc. I checked the advanced settings and the ip address of my server is correct. In MySQL if i type "SHOW DATABASES;" i see the data bases. When i type "select User from mysql.users;" i see the user from my advanced settings.

I'm relatively sure everything is set up correctly, since it was working just fine before. For some reason XBMC (on any of my machines) will not reconnect to the sever after it was moved. Any ideas?

[Ned Scott]

debug log (wiki) needed

[andcbii]

21:56:28 T:5016 NOTICE: DONE initializing playlistplayer
21:56:29 T:5796 ERROR: CRemoteControl::Connect - failed to connect
21:56:49 T:5016 ERROR: Unable to open database: MyVideosvideo60 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:57:10 T:5016 ERROR: Unable to open database: MyVideosvideo59 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:57:31 T:5016 ERROR: Unable to open database: MyVideosvideo58 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:57:52 T:5016 ERROR: Unable to open database: MyVideosvideo57 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:58:13 T:5016 ERROR: Unable to open database: MyVideosvideo56 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:58:34 T:5016 ERROR: Unable to open database: MyVideosvideo55 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:58:55 T:5016 ERROR: Unable to open database: MyVideosvideo54 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:59:16 T:5016 ERROR: Unable to open database: MyVideosvideo53 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:59:37 T:5016 ERROR: Unable to open database: MyVideosvideo52 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
21:59:58 T:5016 ERROR: Unable to open database: MyVideosvideo51 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:00:19 T:5016 ERROR: Unable to open database: MyVideosvideo50 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:00:40 T:5016 ERROR: Unable to open database: MyVideosvideo49 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:01:01 T:5016 ERROR: Unable to open database: MyVideosvideo48 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:01:22 T:5016 ERROR: Unable to open database: MyVideosvideo47 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:01:43 T:5016 ERROR: Unable to open database: MyVideosvideo46 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:02:04 T:5016 ERROR: Unable to open database: MyVideosvideo45 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:02:25 T:5016 ERROR: Unable to open database: MyVideosvideo44 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:02:46 T:5016 ERROR: Unable to open database: MyVideosvideo43 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:03:07 T:5016 ERROR: Unable to open database: MyVideosvideo42 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:03:28 T:5016 ERROR: Unable to open database: MyVideosvideo41 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:03:49 T:5016 ERROR: Unable to open database: MyVideosvideo40 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:04:10 T:5016 ERROR: Unable to open database: MyVideosvideo39 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:04:31 T:5016 ERROR: Unable to open database: MyVideosvideo38 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:04:52 T:5016 ERROR: Unable to open database: MyVideosvideo37 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:05:13 T:5016 ERROR: Unable to open database: MyVideosvideo36 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))
22:05:34 T:5016 ERROR: Unable to open database: MyVideosvideo35 [2003](Can't connect to MySQL server on '192.168.0.109' (10060))

[andcbii]

Ok, i don't know if I'm just being stupid or what. I can not figure out how to post the whole log file. So i just made a google doc for it.

xbmc.log


Figured it out sorry...

xbmc.log

[artrafael]

A couple of hints/suggestions:

• Enable debug logging in XBMC so the xbmc.log includes more diagnostic information that may help identify the problem cause
  
• Upload your log to www.pastebin.com or www.xbmclogs.com . Logs uploaded to these sites will be more readable than Google docs. Do not post logs directly here.
  

---

Okay, I see you found xbmclogs.com. The comment about enabling debug logging still applies.

[andcbii]

OK here is with the debug logging

debug logging

[andcbii]

I figured out the issue. When I moved I temporally had a modem/router combo box from the cable company. I had hooked my router up behind theirs so that i wouldn't lose my IP settings. I normally just go to the router to set static ip address via DHCP. When i did this my router automatically changed it's ip address and the ip address of the DHCP settings. Everything went from 192.168.0.xxx to 192.168.1.xxx. Since the DHCP mapping was working fine, i was able to remote connect and print normally so i didn't realize anything had changed. Now everything is working fine. I just changed the IP address of the router back to what it was.