[OpenSIPS-Users] Could I use mysql lines in opensips.cfg?

Bogdan-Andrei Iancu bogdan at voice-system.ro
Fri Apr 2 11:18:32 CEST 2010


or for any kind of mysql query, you may use the "avp_db_query" function 
from avpops module:
    http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id271033

Regards,
Bogdan

Brett Nemeroff wrote:
> I personally would probably end up storing the users into memcache and
> checking against that.
>
> the userblacklist module might also do what you need..
> http://www.opensips.org/html/docs/modules/1.6.x/userblacklist.html#id227282
>
>
> On Fri, Apr 2, 2010 at 12:15 AM, CheeWii <quanwei87 at gmail.com> wrote:
>   
>> Hi,
>>     I use Opensips as an SMS gateway. Now I need to check all message's
>> username firstly. If the username is in my mysql database,thus it belong to
>> the white name-list,then I realy it normally.If not ,I will drop it
>> directlly.
>>    So I think I should exec some some mysql commands to check the usename.
>> How can I accomplish it?
>>    Thanks a lot:)
>>
>> CheeWii
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>     
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro




More information about the Users mailing list