[Icecast] history of your mount point sessions
rob.mcdonald at nzpages.net
Fri Jun 8 16:06:54 PDT 2007
I have written a crude hack for icecast2 that implements mysql access logs.
It's basically a few extra methods in logging.c, some configuration
directives added, and a new file mylog.c
You have the option of having MySQL Logging in addition to standard file
logging, and it can be switched on and off, and authentication can be set in
I will make up a diff you can patch the icecast-2.3.1 source tree with if
Then a quick query like
SELECT * FROM `icecastLogs` WHERE `method` = 'SOURCE';
should give you a list of every source connection, and its end date and
duration. (startdate is enddate - duration seconds)
On a busy busy server this might consume quite a lot of overhead, and
possible bring down your mysql server, as I haven't implemented persistent
From: icecast-bounces at xiph.org [mailto:icecast-bounces at xiph.org] On Behalf
Of beshoo beshoo
Sent: Saturday, 9 June 2007 12:51 a.m.
To: icecast at xiph.org
Subject: [Icecast] history of your mount point sessions
Dear all Smile
Thank you for your time
Well I like to ask some thing about
( total_bytes_read )
Etc.. () Mount point values
As we know each Mount Point has a separated status diagram in the admin page
I want to save this numbers in a Mysql database !
So I can see some thing like (total_bytes_read /total_bytes_sent.etc)
history , because when you disconnect you broadcast the status diagram will
Well what I am looking for is some think like this :
If we have a mount point named as , e.g. /lovemusic.mp3
Automatically Icecast will create a new record in the Mysql
The content of the is all values is of lovemusic mount point showed in admin
page is included!
When the mount point sessions is disconnect e.g. ( closing OddCast program /
disconnect ...etc.), that mean next time we well have a new record line in
the Mysql show a new session and information value!
PS : I like to add a new value : ( Disconnect time date ).
PS : When icecast will insert the record it will insert mount point owner
e.g. mount-name , password
PS : Each mount point will has his own record.
This is a voluble thing , you can see a history of your mount point sessions
Check out some new online services at Windows Live Ideas-so new they haven't
even been officially released yet. Try it! <http://ideas.live.com>
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Icecast