Summary:ASTERISK-02334: [patch] Add mysqlcanblock= and mysqlsipfriends= to chan_sip
Reporter:Roy Sigurd Karlsbakk (rkarlsba)Labels:
Date Opened:2004-09-03 03:49:49Date Closed:2011-06-07 14:04:46
Versions:Frequency of
Environment:Attachments:( 0) sip_canblock_mysqldbfriendsenable.patch
( 1) sip_canblock_mysqldbfriendsenable-0.0.2.patch
Description:Add mysqlcanblock= and mysqlsipfriends= to chan_sip to allow blocking users existing in sipfriends table. This requires a new column:
ALTER TABLE sipfriends ADD active char(1);
if this is set to 'y', the user is active. Otherwise, he's blocked. The mysqlsipfriends= simply disables or enables the mysqlsipfriends= if compiled in
Comments:By: Roy Sigurd Karlsbakk (rkarlsba) 2004-09-03 05:28:45

the 0.0.2 file should replace the first one attached.
some comments are removed and a braindead strncat() bug has been removed
works stably for me now

By: Mark Spencer (markster) 2004-09-03 20:21:15

There is another patch which allows you to specify the queries for pulling this sort of information.  I think that would likely be the better mechanism.

By: Roy Sigurd Karlsbakk (rkarlsba) 2004-09-04 03:05:36

This patch contains two extensions to chan_sip. The one that allows for enabling/disabling the mysqlsipfriends from a config file should quite obviously be merged into the main source as this is a small patch, and since it's a major improvement (otherwise, you'll need a recompile).

The second, mydbcanblock, may perhaps be solved another way. Where is this patch you're mentioning?

By: twisted (twisted) 2004-10-01 12:04:48

This will likely need to be updated to remain current.  Also, we need some real activity on this bug to remain open.  Thanks.

By: Brian West (bkw918) 2004-10-06 09:48:18

MYSQLFRIENDS is getting ripped out and replaced with the new REALTIME stuff in the next few days.  Please be on the look out for that.