PDA

View Full Version : Reports & Stats



wagging_tail
2006-12-10, 23:18
Have there been any posts about ways to generate statistics from the slimserver database? I could not find any when searching on reports and/or statistics. I realized that I could query the database, but I was looking for something simple like an xml export or some way to create crosstab type reports on the data. I'm not too handy with straight SQL. For example, how many albums / songs per genre classification?

Thanks,
Peter

mherger
2006-12-11, 00:55
> straight SQL. For example, how many albums / songs per genre
> classification?

When I browse my collection this information is given at the web pages
top. For further statistics you could use ODBC to connect to the MySQL
database.

--

Michael

-----------------------------------------------------------------
http://www.herger.net/SlimCD - your SlimServer on a CD
http://www.herger.net/slim - AlbumReview, Biography, MusicInfoSCR

Eserim
2006-12-16, 04:12
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

Linzer
2006-12-16, 08:35
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
2006-12-16, 09:23
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.

Eserim
2006-12-17, 09:14
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

Linzer
2006-12-17, 09:22
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.

Eserim
2006-12-19, 13:48
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
2006-12-25, 03:27
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