Hi all
OpenSER does have the mysql module but it seems to work with particular database schema installed and access through predefined authentication functions like www_authorize and proxy_authorize.
All I have to do is, just invoke a sql query to check if the user exists in the database or not. Is there any way to run simple "select" sql query in openser?
I'd be so grateful if anyone can help me out in this.
miconda
Joined: Feb 02, 2007
Posts: 354
Location: Germany
Status: Offline
If using older version, then check avp_db_query() from avpops. Also, uri_db module can do subscriber checking.
nomi
Joined: May 27, 2005
Posts: 4
Status: Offline
Posted:
Jun 22, 2009 - 06:06 PM
thnx miconda, actually am using version 1.3.2 which does not have sqlops module which is the feature I exactly wannit. In my case now, perl module looked best way to me. I wrote a perl script which has a function quering DB for me.
All logos and trademarks in this site are property of their respective owner. Comments and posts are property of the poster, all the rest (c) 2003-2008 VoIP User Limited.
VoIP User Limited is incorporated in England and Wales under Company Number 6694577.
No part of this site may be reproduced without our prior consent.