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

[Richard Revels]

or alias_db is designed exactly to handle looking up a username. if found you have side benefit of having the request uri set for next hop.

On Apr 2, 2010, at 5:18 AM, Bogdan-Andrei Iancu wrote:

> 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
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users