Thread Closed
HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker
Finchy
Senior Member
Posts: 279
#293
2011-11-26, 16:56
Thanks for the replies guys. I am very inexperienced with SQL so you'll have to bear with me!

darkscout Wrote:It has nothing to do with SQL.

Search for 'debug log' and xbmc.

But if SQLyog can connect to the SQL when installed on the WHS but not when installed on another PC doesn't that suggest there is a problem with SQL? I'd have thought I need to make sure I have a connection to it before looking at other causes?

Methanoid Wrote:I had major problems with this all working UNTIL i added this to the INI file for MySQL

(add to mysqld section)
skip-name-resolve

It would take 40 seconds or more to boot from the XBMC screen and twenty seconds between keypresses.

The other thing was to grant permissions in SQL but ALLOW XBMC to create the DBs.

Hope that helps someone!

My problem isn't how slow it it, I've not got that far yet! As far as I can detect, mine just doesn't connect to the SQL at all. In SQLyog locally I can see all the tables and have granted priveledges to xbmc user in the User Manager, but when I try to connect with SQLyog from another PC I get error 10060, which means it's not connecting.

I've run netstat from CMD on the WHS and that says port 3306 is listening on that machine. I don't know how to change MySQL to allow remote connections, can anyone advise?
Find
  Thread Closed


Messages In This Thread
[No subject] - by Flomaster - 2010-09-10, 19:50
[No subject] - by lloydsmart - 2010-09-10, 20:53
[No subject] - by avus m3 - 2010-09-10, 22:30
[No subject] - by skunobe - 2010-09-10, 22:44
[No subject] - by kophinos - 2010-09-12, 21:15
[No subject] - by PreviousN - 2010-09-17, 17:05
[No subject] - by bcboncs - 2010-09-17, 18:05
[No subject] - by mjjstorey - 2010-09-18, 13:37
[No subject] - by Ogi010 - 2010-10-05, 05:36
[No subject] - by Nick8888 - 2010-10-05, 05:46
[No subject] - by avus m3 - 2010-10-05, 09:30
[No subject] - by Cirion - 2010-10-08, 09:28
[No subject] - by ederson - 2010-10-15, 19:41
[No subject] - by ederson - 2010-10-16, 13:12
[No subject] - by aeiah - 2010-10-20, 16:34
[No subject] - by Magua - 2010-10-20, 21:39
library update problem - by Magua - 2010-10-20, 21:42
[No subject] - by enoklinger - 2010-10-21, 21:47
[No subject] - by opensauce - 2010-10-22, 01:53
[No subject] - by enoklinger - 2010-10-22, 02:44
[No subject] - by mcoto - 2010-10-24, 18:08
[No subject] - by Cirion - 2010-10-25, 10:03
[No subject] - by weedenbc - 2010-10-31, 14:24
Sorry if this is the wrong place - by jwdv22 - 2010-11-04, 23:03
[No subject] - by hitman - 2010-11-05, 10:12
[No subject] - by jwdv22 - 2010-11-05, 15:31
[No subject] - by jwdv22 - 2010-11-05, 20:20
[No subject] - by PasiZ - 2010-11-10, 23:21
[No subject] - by Cirion - 2010-11-12, 13:10
[No subject] - by Croaker - 2010-11-12, 14:59
[No subject] - by hitman - 2010-11-12, 17:40
[No subject] - by Croaker - 2010-11-15, 15:58
[No subject] - by PasiZ - 2010-11-16, 10:28
[No subject] - by weedenbc - 2010-11-18, 04:02
[No subject] - by PasiZ - 2010-11-18, 08:57
[No subject] - by PasiZ - 2010-11-18, 08:58
[No subject] - by Croaker - 2010-11-21, 17:35
[No subject] - by Thermos - 2010-11-22, 02:20
[No subject] - by Ram2000 - 2010-11-27, 23:03
[No subject] - by Thermos - 2010-11-28, 20:11
[No subject] - by Ram2000 - 2010-11-28, 23:33
[No subject] - by Thermos - 2010-12-05, 06:12
Library Mode working - by Def_Proc - 2010-12-07, 21:03
[No subject] - by ant_thomas - 2010-12-07, 22:16
[No subject] - by ^FrEaK^ - 2010-12-11, 12:42
[No subject] - by avus m3 - 2010-12-12, 00:54
[No subject] - by ^FrEaK^ - 2010-12-12, 14:02
[No subject] - by pig13t - 2010-12-12, 16:03
[No subject] - by pig13t - 2010-12-12, 18:44
[No subject] - by grongs - 2010-12-13, 11:34
[No subject] - by Ram2000 - 2010-12-14, 22:25
[No subject] - by castortray - 2010-12-17, 23:24
[No subject] - by PasiZ - 2010-12-18, 12:56
[No subject] - by PasiZ - 2010-12-18, 12:57
[No subject] - by Cash - 2010-12-21, 03:06
[No subject] - by ^FrEaK^ - 2010-12-21, 18:04
[No subject] - by Cash - 2010-12-21, 23:17
[No subject] - by ^FrEaK^ - 2010-12-22, 09:43
[No subject] - by ^FrEaK^ - 2010-12-22, 22:27
[No subject] - by chrissbu - 2010-12-26, 15:01
[No subject] - by ^FrEaK^ - 2010-12-27, 01:20
[No subject] - by ^FrEaK^ - 2010-12-27, 01:22
[No subject] - by macshield - 2010-12-28, 22:35
[No subject] - by wicked_n_raw - 2011-01-01, 21:03
No XBMC on WHS - by czfj5r - 2011-01-02, 01:27
[No subject] - by wicked_n_raw - 2011-01-02, 05:16
[No subject] - by wicked_n_raw - 2011-01-02, 09:43
[No subject] - by ^FrEaK^ - 2011-01-02, 11:49
[No subject] - by czfj5r - 2011-01-02, 18:28
[No subject] - by wicked_n_raw - 2011-01-02, 20:49
[No subject] - by wicked_n_raw - 2011-01-03, 05:58
[No subject] - by tboooe - 2011-01-03, 06:18
\ vs / ? - by czfj5r - 2011-01-03, 11:09
[No subject] - by wicked_n_raw - 2011-01-03, 16:13
[No subject] - by rcoops - 2011-01-03, 17:29
[No subject] - by rcoops - 2011-01-03, 23:03
Can't add videos to library - by tboooe - 2011-01-03, 23:51
[No subject] - by bluenote - 2011-01-13, 08:07
[No subject] - by alexxxo - 2011-01-19, 14:47
[No subject] - by castortray - 2011-01-23, 01:26
[No subject] - by clambert - 2011-01-28, 23:22
[No subject] - by NickSoapdish - 2011-02-01, 21:50
[No subject] - by clambert - 2011-02-02, 00:21
[No subject] - by NickSoapdish - 2011-02-02, 03:45
[No subject] - by clambert - 2011-02-02, 03:53
[No subject] - by NickSoapdish - 2011-02-02, 03:58
[No subject] - by clambert - 2011-02-02, 04:15
[No subject] - by NickSoapdish - 2011-02-03, 02:56
[No subject] - by clambert - 2011-02-03, 03:06
[No subject] - by IAmNotAUser - 2011-02-03, 12:21
[No subject] - by NickSoapdish - 2011-02-03, 21:17
[No subject] - by clambert - 2011-02-04, 23:04
[No subject] - by ^FrEaK^ - 2011-02-05, 21:06
[No subject] - by tboooe - 2011-02-05, 21:20
[No subject] - by twotone8 - 2011-02-06, 04:59
[No subject] - by panaman - 2011-02-06, 07:01
[No subject] - by ^FrEaK^ - 2011-02-06, 11:51
[No subject] - by NickSoapdish - 2011-02-07, 15:46
Music fanart not showing up - by tboooe - 2011-02-07, 18:04
[No subject] - by paco - 2011-02-08, 07:01
[No subject] - by NickSoapdish - 2011-02-09, 00:00
[No subject] - by tboooe - 2011-02-09, 01:44
[No subject] - by paco - 2011-02-09, 07:26
[No subject] - by Hudson_Hawk04 - 2011-02-10, 23:06
[No subject] - by clambert - 2011-02-10, 23:14
[No subject] - by Hudson_Hawk04 - 2011-02-11, 03:35
[No subject] - by svenh - 2011-02-12, 05:40
[No subject] - by Emohawk - 2011-02-13, 14:19
[No subject] - by Hudson_Hawk04 - 2011-02-13, 16:18
[No subject] - by Emohawk - 2011-02-13, 18:11
[No subject] - by cptjsparrow7 - 2011-02-14, 08:07
[No subject] - by Hudson_Hawk04 - 2011-02-14, 23:26
[No subject] - by castortray - 2011-02-18, 10:02
[No subject] - by Hudson_Hawk04 - 2011-02-18, 19:21
[No subject] - by Kewlj1313 - 2011-02-19, 18:19
[No subject] - by Kewlj1313 - 2011-02-19, 18:19
[No subject] - by tboooe - 2011-02-19, 18:46
[No subject] - by castortray - 2011-02-20, 22:57
[No subject] - by TugboatBill - 2011-02-23, 22:22
[No subject] - by clambert - 2011-02-23, 22:24
[No subject] - by TugboatBill - 2011-02-24, 01:33
It works! - by cptjsparrow7 - 2011-02-25, 18:59
[No subject] - by NoPantsJim - 2011-02-27, 19:02
[No subject] - by TugboatBill - 2011-02-27, 19:18
[No subject] - by NoPantsJim - 2011-02-27, 19:27
[No subject] - by svenh - 2011-03-01, 00:46
[No subject] - by P_Jamula - 2011-03-22, 08:27
[No subject] - by P_Jamula - 2011-03-25, 07:57
[No subject] - by tboooe - 2011-03-25, 16:22
[No subject] - by P_Jamula - 2011-03-26, 08:02
[No subject] - by labtopia - 2011-04-03, 15:52
[No subject] - by clambert - 2011-04-03, 16:20
Thank you so much for this - by akira6968 - 2011-04-08, 13:44
[No subject] - by pumkinut - 2011-04-10, 00:04
[No subject] - by attilag78 - 2011-04-10, 05:06
[No subject] - by evanl81 - 2011-04-30, 03:29
[No subject] - by xypus - 2011-04-30, 11:52
[No subject] - by no_Legend - 2011-05-01, 15:58
[No subject] - by Xenomes - 2011-05-06, 09:31
[No subject] - by Thibaultvdb - 2011-05-12, 20:58
[No subject] - by TugboatBill - 2011-05-12, 22:04
[No subject] - by Xenomes - 2011-05-13, 13:58
[No subject] - by aptalca - 2011-05-13, 19:11
[No subject] - by Xenomes - 2011-05-16, 10:16
[No subject] - by orons - 2011-05-16, 10:24
[No subject] - by Xenomes - 2011-05-16, 10:33
[No subject] - by clambert - 2011-05-16, 12:53
[No subject] - by aptalca - 2011-05-17, 00:17
[No subject] - by clambert - 2011-05-17, 01:42
[No subject] - by deefortyone - 2011-05-29, 08:51
[No subject] - by tboooe - 2011-05-29, 14:32
[No subject] - by mdewyer - 2011-06-01, 23:05
[No subject] - by mwkurt - 2011-06-02, 16:55
[No subject] - by mdewyer - 2011-06-02, 19:37
[No subject] - by mwkurt - 2011-06-02, 20:19
[No subject] - by mdewyer - 2011-06-02, 20:53
[No subject] - by mwkurt - 2011-06-03, 12:05
[No subject] - by HarryRosen - 2011-06-11, 12:55
[No subject] - by HarryRosen - 2011-06-13, 05:31
[No subject] - by jtheilbrun - 2011-06-13, 19:14
[No subject] - by Xenomes - 2011-06-17, 11:44
[No subject] - by clambert - 2011-06-17, 13:15
[No subject] - by clambert - 2011-06-19, 07:54
[No subject] - by reksveks - 2011-06-19, 12:02
[No subject] - by thadiyan - 2011-06-20, 04:08
[No subject] - by clambert - 2011-06-20, 04:23
[No subject] - by thadiyan - 2011-06-20, 13:30
[No subject] - by Sparhawk1995 - 2011-06-23, 02:56
[No subject] - by mrdally204 - 2011-06-24, 11:17
[No subject] - by reblutus - 2011-06-24, 20:32
[No subject] - by sbentin - 2011-06-25, 19:10
[No subject] - by thadiyan - 2011-06-25, 19:50
[No subject] - by Jete246 - 2011-06-26, 20:25
[No subject] - by sbentin - 2011-06-26, 20:49
[No subject] - by Jete246 - 2011-06-26, 21:14
[No subject] - by sbentin - 2011-06-26, 21:19
[No subject] - by Jete246 - 2011-06-26, 22:28
[No subject] - by mrdally204 - 2011-06-27, 00:56
[No subject] - by Jete246 - 2011-06-27, 09:22
[No subject] - by mrdally204 - 2011-06-28, 09:20
[No subject] - by hitman - 2011-06-28, 10:27
[No subject] - by Jete246 - 2011-06-28, 10:31
[No subject] - by mrdally204 - 2011-06-28, 20:16
[No subject] - by gyrene2083 - 2011-06-28, 20:51
[No subject] - by Jete246 - 2011-06-28, 21:25
[No subject] - by RockDawg - 2011-06-28, 22:26
[No subject] - by mrdally204 - 2011-06-29, 03:49
[No subject] - by gyrene2083 - 2011-06-29, 04:01
symlink help needed - by hori - 2011-06-29, 08:30
[No subject] - by Jete246 - 2011-06-29, 11:05
[No subject] - by mrdally204 - 2011-06-29, 11:42
[No subject] - by Jete246 - 2011-06-29, 11:50
[No subject] - by Jete246 - 2011-06-29, 11:57
[No subject] - by mrdally204 - 2011-06-29, 12:10
[No subject] - by NorDemoniac - 2011-06-29, 12:20
[No subject] - by RockDawg - 2011-06-29, 14:23
[No subject] - by NorDemoniac - 2011-06-29, 14:35
[No subject] - by RockDawg - 2011-06-29, 14:55
[No subject] - by NorDemoniac - 2011-06-29, 15:18
[No subject] - by NorDemoniac - 2011-06-30, 10:42
[No subject] - by kiboy6 - 2011-07-05, 10:30
[No subject] - by clambert - 2011-07-05, 13:38
[No subject] - by Xenomes - 2011-07-06, 16:14
[No subject] - by svenh - 2011-07-09, 05:09
[No subject] - by tboooe - 2011-07-09, 16:01
[No subject] - by svenh - 2011-07-11, 21:58
[No subject] - by PetSue - 2011-07-13, 09:46
[No subject] - by PetSue - 2011-07-16, 07:33
[No subject] - by mrdally204 - 2011-07-16, 08:54
[No subject] - by PetSue - 2011-07-16, 09:36
[No subject] - by gabbott - 2011-08-14, 17:43
[No subject] - by ederson - 2011-08-17, 10:30
[No subject] - by gabbott - 2011-08-17, 15:57
[No subject] - by aptalca - 2011-08-17, 17:05
[No subject] - by svenh - 2011-08-17, 21:18
[No subject] - by aptalca - 2011-08-17, 21:42
[No subject] - by svenh - 2011-08-18, 02:47
[No subject] - by ederson - 2011-08-18, 19:47
[No subject] - by aptalca - 2011-08-19, 18:00
[No subject] - by smiffy1989 - 2011-08-20, 22:21
[No subject] - by elmerohueso - 2011-08-21, 05:54
[No subject] - by ederson - 2011-08-21, 16:29
[No subject] - by aptalca - 2011-08-21, 22:07
[No subject] - by phsyraxion - 2011-08-22, 07:12
[No subject] - by gabbott - 2011-08-22, 16:21
[No subject] - by Headcase_Fargon - 2011-08-24, 17:11
[No subject] - by phsyraxion - 2011-08-25, 03:00
[No subject] - by phsyraxion - 2011-08-26, 00:41
[No subject] - by Hyram - 2011-09-06, 22:44
[No subject] - by Methanoid - 2011-09-17, 21:08
[No subject] - by hyperlink - 2011-09-23, 21:03
[No subject] - by StanLee - 2011-09-25, 22:28
[No subject] - by scooper750 - 2011-09-27, 17:17
[No subject] - by scooper750 - 2011-09-27, 17:21
[No subject] - by SophT - 2011-10-04, 06:59
[No subject] - by constrictor - 2011-10-05, 19:49
[No subject] - by Kolkjaer - 2011-10-15, 17:58
[No subject] - by Tobas - 2011-10-16, 09:31
[No subject] - by daninino - 2011-10-26, 10:14
[No subject] - by Ray_N - 2011-10-27, 23:34
[No subject] - by nchall - 2011-10-28, 07:32
[No subject] - by DrGosha - 2011-11-01, 12:34
[No subject] - by jacintech.fire - 2011-11-01, 16:17
[No subject] - by Ray_N - 2011-11-01, 17:15
[No subject] - by DrGosha - 2011-11-01, 23:09
[No subject] - by Ray_N - 2011-11-01, 23:35
[No subject] - by DrGosha - 2011-11-02, 00:45
[No subject] - by devilshaven - 2011-11-02, 06:26
[No subject] - by DrGosha - 2011-11-03, 02:30
[No subject] - by devilshaven - 2011-11-03, 05:27
[No subject] - by rcloud - 2011-11-05, 00:42
[No subject] - by devilshaven - 2011-11-05, 19:45
[No subject] - by Ray_N - 2011-11-06, 04:10
[No subject] - by rcloud - 2011-11-06, 05:48
[No subject] - by Finchy - 2011-11-10, 10:16
[No subject] - by jwdv22 - 2011-11-10, 16:07
[No subject] - by dsimages - 2011-11-10, 22:46
[No subject] - by Finchy - 2011-11-11, 00:20
[No subject] - by Darkcloud - 2011-11-13, 09:49
[No subject] - by Klyde - 2011-11-13, 23:07
[No subject] - by Ned Scott - 2011-11-14, 08:39
[No subject] - by darkscout - 2011-11-14, 09:04
[No subject] - by Fruitfly - 2011-11-16, 03:55
[No subject] - by darkscout - 2011-11-16, 04:48
[No subject] - by Fruitfly - 2011-11-16, 10:18
[No subject] - by Xsabre - 2011-11-16, 16:14
[No subject] - by Fruitfly - 2011-11-16, 17:35
[No subject] - by Fruitfly - 2011-11-16, 17:48
[No subject] - by darkscout - 2011-11-16, 18:17
[No subject] - by Fruitfly - 2011-11-16, 19:32
[No subject] - by darkscout - 2011-11-16, 19:38
[No subject] - by Klyde - 2011-11-17, 16:15
[No subject] - by darkscout - 2011-11-17, 16:30
[No subject] - by Klyde - 2011-11-17, 17:05
[No subject] - by darkscout - 2011-11-17, 18:10
[No subject] - by Klyde - 2011-11-17, 20:41
[No subject] - by darkscout - 2011-11-17, 23:36
[No subject] - by Finchy - 2011-11-25, 23:16
[No subject] - by darkscout - 2011-11-26, 01:53
[No subject] - by Finchy - 2011-11-26, 03:30
[No subject] - by darkscout - 2011-11-26, 03:46
[No subject] - by Methanoid - 2011-11-26, 12:36
[No subject] - by Finchy - 2011-11-26, 16:56
[No subject] - by darkscout - 2011-11-26, 18:10
[No subject] - by Finchy - 2011-11-26, 22:24
[No subject] - by Finchy - 2011-11-26, 23:53
[No subject] - by Finchy - 2011-11-27, 00:27
[No subject] - by Finchy - 2011-11-27, 17:26
[No subject] - by chrissbu - 2011-12-13, 04:10
[No subject] - by Finchy - 2011-12-13, 09:45
[No subject] - by Klyde - 2012-01-04, 04:18
[No subject] - by silencery - 2012-01-04, 06:49
[No subject] - by jwdv22 - 2012-01-04, 16:35
[No subject] - by jwdv22 - 2012-01-04, 17:23
[No subject] - by EMETIB - 2012-01-10, 00:10
[No subject] - by {{INX}} - 2012-01-10, 15:50
[No subject] - by {{INX}} - 2012-01-10, 20:49
[No subject] - by Klyde - 2012-01-11, 00:44
[No subject] - by hjid - 2012-01-11, 21:58
[No subject] - by Ray_N - 2012-01-11, 22:03
[No subject] - by hjid - 2012-01-11, 22:51
[No subject] - by jdoggvt - 2012-01-11, 22:59
[No subject] - by bill55 - 2012-01-12, 18:13
[No subject] - by bill55 - 2012-01-13, 04:20
[No subject] - by {{INX}} - 2012-01-13, 20:45
[No subject] - by TeKo - 2012-01-14, 01:43
[No subject] - by {{INX}} - 2012-01-14, 04:51
[No subject] - by TeKo - 2012-01-14, 05:10
[No subject] - by {{INX}} - 2012-01-14, 11:47
[No subject] - by TeKo - 2012-01-14, 17:22
[No subject] - by Blaxxor - 2012-01-19, 21:29
[No subject] - by kmusk01 - 2012-01-24, 17:59
[No subject] - by kmusk01 - 2012-01-26, 20:37
[No subject] - by Dam0 - 2012-01-27, 12:33
[No subject] - by Betard - 2012-01-29, 19:46
[No subject] - by jwdv22 - 2012-01-30, 15:19
[No subject] - by kmusk01 - 2012-01-30, 16:20
[No subject] - by Ned Scott - 2012-01-30, 21:36
[No subject] - by Ned Scott - 2012-01-30, 21:47
[No subject] - by Blaxxor - 2012-01-31, 09:05
[No subject] - by kri kri - 2012-02-01, 21:11
[No subject] - by Ned Scott - 2012-02-02, 07:39
[No subject] - by Jedfordski - 2012-02-05, 10:41
[No subject] - by Ned Scott - 2012-02-06, 06:20
CWinFileSMB Error - by mholzma - 2012-02-09, 04:14
[No subject] - by macrossmaxim - 2012-02-09, 04:46
[No subject] - by malibu327 - 2012-02-09, 06:58
[No subject] - by Ned Scott - 2012-02-09, 22:19
[No subject] - by mattdamon - 2012-02-10, 00:19
[No subject] - by mattdamon - 2012-02-10, 00:25
[No subject] - by Ned Scott - 2012-02-10, 00:59
[No subject] - by mattdamon - 2012-02-10, 10:14
[No subject] - by snoopy78 - 2012-02-10, 19:32
[No subject] - by Herkatus - 2012-02-11, 13:27
[No subject] - by Herkatus - 2012-02-11, 16:43
[No subject] - by gabbott - 2012-02-11, 17:27
[No subject] - by sbalani - 2012-02-18, 18:53
[No subject] - by Necochino - 2012-02-19, 02:33
How does this work in Eden Beta 3 - by frr792 - 2012-02-22, 04:12
Setting up MYSQL on OSX - by tdhz77 - 2012-02-23, 14:02
[No subject] - by mikeprep - 2012-03-05, 12:08
[No subject] - by Ned Scott - 2012-03-06, 03:31
[No subject] - by impmonkey - 2012-03-07, 04:03
Don't use MySQL 5.6 - by Squigibo - 2013-02-23, 20:46
Please close thread - by Ray_N - 2013-02-25, 20:06
Home
Search
Help
Logout Mark Read Team Forum Stats Members Help
HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker1