Icecast - Jun 2007 - history of your mount point sessions

Dear all SmileThank you for your timeWell I like to ask some thing about(
total_bytes_read )(total_bytes_sent)Etc.. () Mount point valuesAs 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 disappear .Well what I am looking for is some think like
this :If we have a mount point named as , e.g. /lovemusic.mp3Automatically
Icecast will create a new record in the MysqlThe 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
information !e.g. mount-name , passwordPS : Each mount point will has his own
record.This is a voluble thing , you can see a history of your mount point
sessions ! Idea
_________________________________________________________________
Check out some new online services at Windows Live Ideas?so new they haven?t
even been officially released yet.
http://ideas.live.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.xiph.org/pipermail/icecast/attachments/20070608/d5722bbc/attachment.htm>

Hi beshoo,

 

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
the config.xml

 

I will make up a diff you can patch the icecast-2.3.1 source tree with if
you like.

 

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
connections.

 

Cheers

 

Rob

 

 

  _____  

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 )
(total_bytes_sent)
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
disappear .

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
information !
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
! Idea

  _____  

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...
URL:
<http://lists.xiph.org/pipermail/icecast/attachments/20070609/fa3aac51/attachment.htm>