|Summary:||ASTERISK-02334: [patch] Add mysqlcanblock= and mysqlsipfriends= to chan_sip|
|Reporter:||Roy Sigurd Karlsbakk (rkarlsba)||Labels:|
|Date Opened:||2004-09-03 03:49:49||Date Closed:||2011-06-07 14:04:46|
|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.