Hi Ronald,
 
  The concept of using groups is a nice idea, it didnt come to my mind. You can do a simple check is_uri_in_group or better is_radius_group_in() .
But after that  i think that your approach is slightly not ok.
>If ser detects that it is a call from an extension from a wi-fi group,
>can i call a script that will insert a script on the cronjob and that
>script on the cronjob will  be the one to tell the wi-fi database to
>deduct amount because he's making calls. I just don't know if this is
>possible, and another thing i see here is how can I remove the script on
>the cron when call is hangup.
 
 I preceive from this that you want to present to your WiFi provider the call details as and when they take place. As such it can be called not precisley wrong, but CDR genration is done when a call has been completed(disconnected). For this the best bet will be to use a Radius server in conjunction with SER, and define a billing settlement time interval during which you will preseent the records to your WiFi provider.This will save you from adding extra overhead bof creating/using cron scripts, etc.
 
Regards,
Ashutosh 
 


On 4/28/06, Ronald Ramos <nhadie@tbgi.net.ph> wrote:
Hi Kumar,

Is what i'm thinking possible:

i will create a group called wi-fi, instead of using the flags, all
extensions that belong on that group means it's the extension for the
wi-fi customer.
If ser detects that it is a call from an extension from a wi-fi group,
can i call a script that will insert a script on the cronjob and that
script on the cronjob will  be the one to tell the wi-fi database to
deduct amount because he's making calls. I just don't know if this is
possible, and another thing i see here is how can I remove the script on
the cron when call is hangup.
Thank You

Regards,
Ron


Kumar, Ashutosh wrote:

> Hi,
>  See my answers inline.
>
> On 4/27/06, *Ronald Ramos* < nhadie@tbgi.net.ph
> <mailto:nhadie@tbgi.net.ph>> wrote:
>
>     Hi,
>     I'm sorry didn't understand swhat eeds to be done please see
>     inline for
>     some more of my questions
>
>     Kumar, Ashutosh wrote:
>
>     > Hi,
>     >     You can do like this:
>     >  1. When a customer signs up for his Wi-Fi service, after an insert
>     > into hsi 'subsriber' table, the same record should be passed to you
>     > for inserting into your 'subscriber' table so that his users are
>     > autheinticated succesfully against your AAA requests.
>
>     when you say his subscriber table, do you mean wi-fi subscriber
>     table?
>     or he should have a voip subscriber table of his own?
>
>
> By "his subscriber table'  i mean  the WIFI subscriber table. In
> addition, you will have voip table for your own use. So it is like,
> - WIFI provider has wifi subscriber table
> -VOIP provider has voip subscriber table.
>
>     >     For implementing this, you give him your db credentials+schema ,
>     > so that he can run the query one after another in hsi
>     registration script.
>
>     what type of query will he run?
>
>
>  The query will be a simple SQL insert statement, which will insert
> the record  into the VOIP subsriber table. It may be noted that there
> are two ways to do the insert.
>   1. The WIFI sends/redirects the insertion page after hsi wifi
> registration to the VOIP web'site inserion script.
>   2. The VOIP provider gives database access to WIFI provider to to
> the insertion. Here the VOIP insertion will be almost same as WIFI
> insertion, differing only in DB info.
>
>     > 2. Create/Use a flag set to 'ON' for all such customers which have
>     > been created in such a manner.This will differentiate your users and
>     > users from the Wi-Fi provider.
>
>     I'm also not familiar with flags, i'll try to read more on that, but
>     basically what does that flag do?
>
>
> FLAG here denotes a database BOOL field (it may be char, int
> whaterver, serving the same purpose), which will have two values,; one
> for your users, and another for the users in the table who are
> created  'from' the WIFI provider side.
>   For eg, Here you might set the default flag value as 0 (ZERO or
> OFF), and when you add a WIFI user record, set the flag in that case=1
> (ON).
>
>     > 3. Finally, At the time of settlement, do query something like
>     "select
>     > CDR where flag='ON' " and present the records to him for settlement.
>
> For Billing, create a cron script, which genertate a report of
> successful based on the following query
>           SELECT * FROM CDR WHERE flag=1 AND DISCONNECT_CAUSE='SUCESS'
> (Of course, the above might differ from your chema) .
>        The generated report can be presented for billing to your WIFI
> provider.
>
>
>     when his user login to their wi-fi system the billing already starts,
>     meaning the credit already starts to go down, then on that
>     duration he
>     decided he wants to make a phone call:
>
>     1. how can i make it in such a way that the username and password
>     on his
>     card, will be the one configured on the phone (example an XPRO) that
>     will authenticate to mine (or maybe his subcriber table if that's
>     what
>     you mean on number 1).
>
>    If the subscriber table you created is integrated with a radius
> server (freeqrduius?), and you are using an appropriate call flow
> route in ser.cfg, then the authentication will be automatic, no need
> to do anything extra.
>
>
>     2. next will be how can i send him the update of how much he has
>     already
>     consume fo VoIP alone to deduct it to hisWi-Fi credit simultaneously
>     with his Wi-Fi usage?
>
> See Answer 3. Here, automaitically, the charge you will present to him
> will be automatcally only for the charges incurred by your switch,
> irrespective of the fact that the subscirber was latched up to WIFI,
> dialup or whatever.
>
>
>     >
>     > Regard,
>     > Ashutosh
>     >
>     > On 4/26/06, *Nhadie* < nhadie@tbgi.net.ph
>     <mailto:nhadie@tbgi.net.ph> <mailto:nhadie@tbgi.net.ph
>     <mailto:nhadie@tbgi.net.ph >>>
>     > wrote:
>     >
>     >     Hi All,
>     >
>     >     I have built an ser server and offering postpaid voip right
>     now.
>     >     It's just a
>     >     basic ser setup, authenticate then make calls then i bill them.
>     >
>     >     But one client that offers Wi-Fi pepaid card would like to
>     offer VoIP
>     >     service using their card and he's going to use my system. My
>     main
>     >     problem is
>     >     how to integrate it to their billing system.
>     >
>     >     how can i do it in such a way that his customer can use my voip
>     >     service and
>     >     deduct the amount of usage on their Wi-Fi credit? And then I'll
>     >     just bill my
>     >     client for the usage of all his customers.
>     >
>     >     hope my question was clear, thank you in advance.
>     >
>     >     Regards
>     >     Nhadie
>     >
>     >     ________________________________________________
>     >     Message sent using UebiMiau 2.7
>     >
>     >     _______________________________________________
>     >     Serusers mailing list
>     >     serusers@lists.iptel.org <mailto:Serusers@iptel.org> <mailto:
>     serusers@lists.iptel.org <mailto: serusers@lists.iptel.org>>
>     >     http://lists.iptel.org/mailman/listinfo/serusers
>     >     < http://lists.iptel.org/mailman/listinfo/serusers>
>     >
>     >
>     >
>     >
>     > --
>     > -----BEGIN PGP SIGNATURE-----
>     > Version: GnuPG v1.2.7 (GNU/Linux)
>     > iD8DBQBEPo9P/OykOp7fM/wRAjw8AKCOlSsiHl7cyfCiitFJyEIEMhinHgCfb6YX
>     > lrreitIO+tLZKrpjm81hsbY= =MEGA
>     > -----END PGP SIGNATURE----- "
>     >
>     > There are 10 kinds of people in this world, those who understand
>     > Binary and those who dont".
>     >
>     >------------------------------------------------------------------------
>
>     >
>     >_______________________________________________
>     >Serusers mailing list
>     >serusers@lists.iptel.org <mailto: serusers@lists.iptel.org>
>     > http://lists.iptel.org/mailman/listinfo/serusers
>     >
>     >
>
>
>
>
> --
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.7 (GNU/Linux)
> iD8DBQBEPo9P/OykOp7fM/wRAjw8AKCOlSsiHl7cyfCiitFJyEIEMhinHgCfb6YX
> lrreitIO+tLZKrpjm81hsbY= =MEGA
> -----END PGP SIGNATURE----- "
>
> There are 10 kinds of people in this world, those who understand
> Binary and those who dont".





--
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.7 (GNU/Linux) iD8DBQBEPo9P/OykOp7fM/wRAjw8AKCOlSsiHl7cyfCiitFJyEIEMhinHgCfb6YX lrreitIO+tLZKrpjm81hsbY= =MEGA
-----END PGP SIGNATURE----- "

There are 10 kinds of people in this world, those who understand Binary and those who dont".