Re: [OpenSIPS-Users] Could I use mysql lines in opensips.cfg?
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 quanwe...@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@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Could I use mysql lines in opensips.cfg?
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 quanwe...@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@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Could I use mysql lines in opensips.cfg?
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@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users