[Icecast-dev] MySQL/HTTP Auth

[Mike Whitaker]

On 30 Dec 2004, at 23:58, Michael Smith wrote:

> On Thu, 30 Dec 2004 23:49:43 +0000 (GMT), andrew at tranceairwaves.com
> <andrew at tranceairwaves.com> wrote:
>> Hi,
>>         I have read alot of the archives, and looked over the 
>> development
>> of listener authentication, and wondered if anyone has a working 
>> version
>> with MySQL enabled ? as it seems more in 'development' however I would
>> like to give it a try.
>
> I haven't heard of anyone using mysql for anything directly with
> icecast (people use it for playlist automation systems external to
> icecast, though).

*holds hand up*

We tried out Karl's URL based auth scheme talking to a MySQL DB, to 
serve premium pay content ('radio'-style sports commentary on that 
strange English game called cricket). The basic concept rocks utterly, 
but we did run into some stability problems - this was kh58 - which 
unfortunately due to pressures of having Real Customers we had to scrap 
in favour of a cron job that dumped the DB to a flat file and use the 
basic auth in 2.1.

I'll try and thrash the latest kh- branch when I get a chance - it 
seems that sometimes, a URL-auth request would cause icecast to lock up 
in a manner that simply stopped it receiving connections, and dumped 
existing ones.