Gilles2;513583 Wrote: > Hi Frank, > I love the promise of this ACC. > I gave it a try and can't get it work. I am running SqeezeCenter on a > WHS. > I installed the ODBC driver and configured the access on the Server, > editing the my.tt file as explained. > I mapped a drive to the Music Share on the Server. > My Server access options look now like : > - Drive mapped to remote Server music share : Z: > - IP address of remote SC server : 192.168.1.22, which is the address > of the server on my network > - Port number used by Squeezebox Server: 9000 > - Full remote physical path to music share : D:\Musique (my server in > in French) > When trying the "Test" button, it runs for a while and then I get the > following error message : > Error connecting to 192.168.1.22 > Possible reasons: > - The required mySQL ODBC driver is not installed. > - If you are accessing mySQL on a remote server please make sure remote > access is allowed by remote server (default = disbled). ... > Error description: [MySQL][ODBC 5.1 Driver] Can't connect to MySQL > server on '192.168.1.22' (10060). > > One thing I noticed which differs from your help screen is that my SQL > share on my Server sits in C:\Program Files\SqueezeBox\server\MySQL\ > and not C:\Program Files\SqueezeCenter\server\MySQL\ could that be > source of the problem ? > > Thanks in advance
The difference in path is of no concern. I'll update the reference in ACC as SqueezeCenter has been replaced by Squeezebox Server. Sounds like you've done everything quiet right actually. Some questions: 1. Do you run ACC from the server or from a remote computer? If you run it directly from the server do not configure any remote server settings. In this scenario you don't even have to edit the my.tt file as the server is not being accessed remotely. If you already did made configuration settings while running ACC from the server, remove all ACC settings which are stored in the registry and than try again by removing HKEY_CURRENT_USER\Software\ACC (run regedit.exe to edit the registry) 2. Did you install version 5.1 of the ODBC driver? (EDIT: I saw you did in your posting. Skip this one ;-) 3. The ODBC driver must be installed on the machine you run ACC from. So if you run ACC from a remote computer, install it on that computer. No need to install it on the server here. 4. Did you restart SBS or the server after you modified the my.tt file? It will become active only after restart of MySql and hence a SBS or server restart is required. 5. Do you have a firewall configured on the server that my be blocking traffic. Try disabling it. If it resolves the issue add port 9092 to be allowed Let me know if this is of any help.... Frank -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for SqueezeCenter '_' (http://www.badkamerpech.nl) SlimServer. 2xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS ------------------------------------------------------------------------ SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
