26 Apr
2006
26 Apr
'06
4:55 p.m.
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
26 Apr
26 Apr
5:29 p.m.
Hello,
Which billing system are you using ?
Harry
--- Nhadie <nhadie(a)tbgi.net.ph> a écrit :
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
___________________________________________________________________________
Faites de Yahoo! votre page d'accueil sur le web pour retrouver directement vos
services préférés : vérifiez vos nouveaux mails, lancez vos recherches et suivez
l'actualité en temps réel.
Rendez-vous sur http://fr.yahoo.com/set
10:49 p.m.
Hi,
You can do like this:
1. When a customer signs up for his W-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.
For implementing this, you give him your db credentials+schema , so that
he can run the query one after another in hsi registration script.
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.
3. Finally, At the time of settlement, do query something like "select CDR
where flag='ON' " and present the records to him for settlement.
Regard,
Ashutosh
On 4/26/06, Nhadie <nhadie(a)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(a)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".
27 Apr
27 Apr
5:24 a.m.
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?
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?
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?
3. Finally, At the time of settlement, do query
something like "select
CDR where flag='ON' " and present the records to him for settlement.
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).
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?
Regard,
Ashutosh
On 4/26/06, *Nhadie* <nhadie(a)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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
8:14 a.m.
Hi,
See my answers inline.
On 4/27/06, Ronald Ramos <nhadie(a)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:
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.
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? For implementing this, you give him your db
credentials+schema ,
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.
so that he can run the query one after another in
hsi registration
script.
what type of query will he run? 2. Create/Use a flag set to 'ON' for all such
customers which have
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).
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? 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(a)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(a)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(a)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".
5:38 a.m.
Hi,
This is what's on my mind right now:
when a user connects to his wi-fi access, e.g $20 card, his credit will
already start decraesing, then suddenly he decided to make a phone call
using our system. what i need to do now is send updates to his billing
system that your customer is making phone calls deduct 3 cents on his
credit, another minute deduct again, since he's using internet and voip
at the same time his credit goes down faster, if his $20 credit is zero,
then his internet will get cut-off and eventually the phone call will
get cut-off.
I don't know if this is possible and I don't have a clue on how to do it
if it's possible. Hope you guys can help me thank you
Regards,
Ron
Kumar, Ashutosh wrote:
Hi,
You can do like this:
1. When a customer signs up for his W-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.
For implementing this, you give him your db credentials+schema ,
so that he can run the query one after another in hsi registration script.
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.
3. Finally, At the time of settlement, do query something like "select
CDR where flag='ON' " and present the records to him for settlement.
Regard,
Ashutosh
On 4/26/06, *Nhadie* <nhadie(a)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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
6785
days inactive
6786
days old
5 comments
4 participants
participants (4)
-
hgaillac-sip＠yahoo.fr -
Kumar, Ashutosh -
Nhadie -
Ronald Ramos