Hi @all,
I want to run OpenSER with ORACLE Database. I use unixODBC and
libsqora.so.10.1 to connect to the DB.
But now I have problems with inserting Data in the DB.
When OpenSER wants to add Data in the "location" table I always get an
error because of the timeformat (expires, last_modified)
I use SQL*Plus Client in Windows and when I write the Connection String
from OpenSER usrloc here, everything is running well,
Because I did alter session set nls_date_format = 'YYYY-MM-DD
HH24:MM:SS';
Is it a Driver problem?
Does anybody have a solution or experience with it?
Thanks
Martin
Hello all,
I need some advice from all you NAT experts. Assume that we have two
OpenSER proxies serving two different domains and they both use
nathelper. Also assume that their configuration is identical and looks
roughly like:
route {
...
record_route();
if (nat_uac_test("23")) {
if (method!="REGISTER" &&
!is_present_hf("Record-Route")) {
fix_nated_contact();
}
}
t_on_reply("1");
}
onreply_route[1] {
if (nat_uac_test("23")) {
fix_nated_contact();
};
}
clientA and clientB are both behind NAT. clientA@domainA sends an INVITE
to clientB@domainB through proxyA:
clientA@domainA -----> ProxyA -----> ProxyB ------> clientB@domainB
ProxyA detects that clientA is behind NAT and fixes the contact. ProxyB
finds the Record-Route header, so it does not fix the contact. My
question is about how to handle the 200 OK. With this configuration both
proxies detect that clientB is behind NAT and the contact gets fixed
twice. Is there a way to avoid this?
thank you
George
Disclaimer
The information in this e-mail and any attachments is confidential. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorized to, and must not, read, copy, distribute, use or retain this message or any part of it. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.
Hi,
Has anyone got to install SerWEB with openser 1.2.x? I have tried php4, php5, xml-rpc, fifo. The browser freezes when logging in. If FIFO is not accessible it logs in, indicating a problem, maybe in the new mi_fifo module.
Cheers,
Flavio E. Goncalves
i m using openser with postgresql.my openser crashed 5 times a
day.anyonecan help me on this pls?
--
Regards
----------
M Emran
InSpiration Software Ltd.
I just want to redirect all communication to phones 2xx to another SIP proxy through TCP.
I have 2 problems, the first one is that the extensions don't exist in the location database, so I have added them manualy:
openserctl ul add 299 sip:299@62.210.194.120
And when I use:
if (method==INVITE && uri=~"sip:2[0-9][0-9]@*") {
rewritehostport("62.210.194.120:5060");
t_relay("tcp:62.210.194.120:5060");
exit;
};
I get:
0(17174) rewrite_uri: Rewriting Request-URI with 'sip:299@62.210.194.120'
0(17174) parse_headers: flags=ffffffffffffffff
0(17174) !!!! STARTING ROUTE 1: NORMAL FORWARD
0(17174) subst_run: running. r=1
0(17174) subst_str: no match
0(17174) !!!! STARTING ROUTE 3: SET/UNSET RTPPROXY
0(17174) DEBUG: t_newtran: T on entrance=0xffffffff
0(17174) parse_headers: flags=ffffffffffffffff
0(17174) parse_headers: flags=78
0(17174) t_lookup_request: start searching: hash=5349, isACK=1
Any idea?
Yes I have followed the tutorial and after some changes due to upgrades, it's working,
in the cdrtool web interface, I can see the cdrs... With the time of the calls, the canonical URI, the billing_party...
But the price is not calculated...
Is there any way to see if cdrtool is doing something?
In my last email, i have posted the databases...
Thanks
Dan-Cristian Bogos a écrit :
> Hello Marc,
>
> did u follow ./doc/INSTALL.txt? Can u access CDRTool via the web
> interface? Make sure u can see the cdrs with the search tool. After
> that it is a question of proper setting the pricelist (since it can be
> pretty complex) and making sure u can connect to rating engine.
>
> Cheers,
> DanB
>
> On 8/7/07, Marc LEURENT <lftsy(a)free.fr> wrote:
>> Hello everybody,
>> I was wondering what should I add in my cdrtool configuration to enable the communication price calculation
>> CDRTool has evrything he needs from the freeradius.acct table, billing party and Canonical URI...
>>
>>
>> Is it possible to monitor what CDRTool is doing???
>> Is there logs somewhere...
>> Thanks
>>
>>
>>
>> I have also filled the billing_rates database:
>> id gateway domain subscriber name destination durationRate trafficRate application connectCost
>> "1";;"sd-7501.dedibox.fr";;;"103(a)sd-7501.dedibox.fr";"23";;"3";"2"
>>
>>
>> destinations database:
>> id gateway domain subscriber dest_id dest_name
>> "1";;"sd-7501.dedibox.fr";"103(a)sd-7501.dedibox.fr";"1";"Domaine SIP locale"
>>
>> billing_customers:
>> id gateway domain subscriber profile_name1 profile_name1_alt profile_name2 profile_name2_alt timezone increment min_duration country_code
>> "1";;"sd-7501.dedibox.fr";"103(a)sd-7501.dedibox.fr";;;;;;"10";"10";
>> "2";;"sd-7501.dedibox.fr";"106(a)sd-7501.dedibox.fr";;;;;;"20";"35";
>>
>>
>>
>> Here is what I see with CDRTool interface:
>>
>> 1N 2007-08-07 10:38:52 88.191.45.91 103(a)sd-7501.dedibox.fr 00:04 0.00 0.00 Ok (200)
>> Signalling information
>> Session: sjozozxmfficcar(a)192.168.95.47
>> Start time: 2007-08-07 10:38:52 Europe/Paris
>> Stop time: 2007-08-07 10:38:56 Europe/Paris
>> Method: INVITE from :
>> From:
>> Dialed URI:
>> Canonical URI: 103(a)sd-7501.dedibox.fr
>> Next hop URI:
>> Billing Party: sip:106@sd-7501.dedibox.fr
>>
>> Rating information
>> Free call
>>
>>
>>
>> Best Regards,
>>
>> Marc LEURENT
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>>
Hello everybody,
I was wondering what should I add in my cdrtool configuration to enable the communication price calculation
CDRTool has evrything he needs from the freeradius.acct table, billing party and Canonical URI...
Is it possible to monitor what CDRTool is doing???
Is there logs somewhere...
Thanks
I have also filled the billing_rates database:
id gateway domain subscriber name destination durationRate trafficRate application connectCost
"1";;"sd-7501.dedibox.fr";;;"103(a)sd-7501.dedibox.fr";"23";;"3";"2"
destinations database:
id gateway domain subscriber dest_id dest_name
"1";;"sd-7501.dedibox.fr";"103(a)sd-7501.dedibox.fr";"1";"Domaine SIP locale"
billing_customers:
id gateway domain subscriber profile_name1 profile_name1_alt profile_name2 profile_name2_alt timezone increment min_duration country_code
"1";;"sd-7501.dedibox.fr";"103(a)sd-7501.dedibox.fr";;;;;;"10";"10";
"2";;"sd-7501.dedibox.fr";"106(a)sd-7501.dedibox.fr";;;;;;"20";"35";
Here is what I see with CDRTool interface:
1N 2007-08-07 10:38:52 88.191.45.91 103(a)sd-7501.dedibox.fr 00:04 0.00 0.00 Ok (200)
Signalling information
Session: sjozozxmfficcar(a)192.168.95.47
Start time: 2007-08-07 10:38:52 Europe/Paris
Stop time: 2007-08-07 10:38:56 Europe/Paris
Method: INVITE from :
From:
Dialed URI:
Canonical URI: 103(a)sd-7501.dedibox.fr
Next hop URI:
Billing Party: sip:106@sd-7501.dedibox.fr
Rating information
Free call
Best Regards,
Marc LEURENT