[slim] Re: Reports Stats
OK that works - I may be able to do the SQL I want from here (basically finding all LP without replay gain) Cheers all Eserim -- Eserim Eserim's Profile: http://forums.slimdevices.com/member.php?userid=1932 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Reports Stats
I'll try that some-time, however whenever I go to the mysql.cm site it crashes on me and all their pages time-out/reset! -- Eserim Eserim's Profile: http://forums.slimdevices.com/member.php?userid=1932 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Reports Stats
Hi I'm using the official 6.5 with MySQL. This is from my prefs file dbpassword: '' dbsource: dbi:mysql:hostname=127.0.0.1;port=9092;database=%s dbusername: slimserver Still can't see what options to use to get the connection working Cheers Eserim -- Eserim Eserim's Profile: http://forums.slimdevices.com/member.php?userid=1932 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Reports Stats
Eserim, Try downloading the MySQL Query Browser as mentioned in previous post and install it on the same computer that SlimServer is installed on. Try filling in the following values and see if you can connect. Server host name: localhost OR 127.0.0.1 Port: 9902 Username: slimserver Password: Default Schema: slimserver Make sure you can connect with this tool. If you cannot, change the port to 3306 the MySQL default. Once you find a working config, use the same settings to the ODBC portion. -- Linzer -- Linzer Linzer's Profile: http://forums.slimdevices.com/member.php?userid=462 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Reports Stats
I'm having problems with the oDBC setting for MySQL - using the beta versio 5 driver. The options needed are Data Source Name (I assume this can be what I want to call it) server (the slimserver prefs have this as the loop-back ip address of 127.0.0.1 User - I'm using slimserver No password Database - slimserver? Port 9092? And yet not seeing any tables when I try and connect in MS Access. Any ideas? Cheers Eserim -- Eserim Eserim's Profile: http://forums.slimdevices.com/member.php?userid=1932 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Reports Stats
Eserim;162789 Wrote: I'm having problems with the oDBC setting for MySQL - using the beta versio 5 driver. The options needed are Data Source Name (I assume this can be what I want to call it) server (the slimserver prefs have this as the loop-back ip address of 127.0.0.1 User - I'm using slimserver No password Database - slimserver? Port 9092? And yet not seeing any tables when I try and connect in MS Access. Any ideas? Cheers Eserim Your port should be defined in your slimserver.pref file on the dbsource line. My port is not 9002 but something else as defined by the MySQL setup. Your Data Source Name will be slimserver unless you've defined something else in slimserver.pref file. You could also try the MySQL Query Browser http://dev.mysql.com/doc/query-browser/en/index.html to ensure the ODBC portion is not causing problems. When I use this on my setup I have to define the following parameters: Server host name (location where slimserver is running). Port (already mentioned) Username (dbusername as found in slimserver.pref file) Password (dbpassword as found in slimserver.pref file) Default Schema (slimserver unless otherwise definded in slimserver.pref file). HTH -- Linzer -- Linzer Linzer's Profile: http://forums.slimdevices.com/member.php?userid=462 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Reports Stats
Eserim, I have a couple of questions for you. 1) What version of SlimServer are you running? 2) What is your backend database? The reason I ask is my previous post assumed you were running 6.5.0 or at least a previous version with MySQL. See http://wiki.slimdevices.com/index.cgi?SQLite for a history of the backend options. If you are not running MySQL you can search the forums here for an ODBC hook into SQLite. Sorry I didn't think of this sooner. -- Linzer -- Linzer Linzer's Profile: http://forums.slimdevices.com/member.php?userid=462 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
