On Thu, Jun 7, 2012 at 5:24 PM, Daniel-Constantin Mierla <mico...@gmail.com> wrote: > Hello, > > > On 6/5/12 11:17 AM, Aft nix wrote: >> >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Hi all, >> >> We are thinking about launching a different "usage policy". The usage >> policy will be prepaid in some sense. >> but instead of limiting "number of minutes" we are thinking about >> limiting "number of calls". >> >> That means if you pay this X amount of doller, you can make Y amount >> of calls. calls can last whatever the >> user wants given that its under 1 hr. >> >> I've seen how to limit concurrent calls using SER, but the usage i >> have described, is not seen by me. >> >> So please help me out with this thing. >> >> My initial understanding about how it can be done : >> >> 1) when a dialog is confirmed with ACK(we have both callid, from tag, >> to tag), we can make an entry to the database >> by increasing "number of calls" field by one. >> >> 2) A field in database will be used as flag for usage limit. when >> "number of calls" exceeds the usage limit, it will flag it >> as "finished usage limit". >> >> 3) when a INVITE arrives, a check will be made with $fU against DB. >> >> With this framework in mind, I have read "db_mysql" module. And to my >> surprise, no direct the database >> functions are not exported to the cfg. >> >> I don't know if any module in kamailio exports mysql_queury() to cfg, >> which i need for my purpose. >> >> And may be there is some built in module which provides a higher level >> layer which will enable myself achieving >> my goal. >> >> If in the end i need "exported" mysql functions, then i can develop it >> myself. >> >> So which way i should go? > > see the sqlops module that provides sql query interfaces to various database > systems, including mysql. > http://kamailio.org/docs/modules/stable/modules_k/sqlops.html >
Thank you for the link. I will post updates on how its going about the implementation. Cheers, > Cheers, > Daniel > > -- > Daniel-Constantin Mierla - http://www.asipto.com > http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda > Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - > http://asipto.com/u/katu > Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - > http://asipto.com/u/kpw > > > -- -aft _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
