Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-30 Thread Tijmen de Mes

Hi,

On Nov 25, 2010, at 10:06 AM, ha do wrote:

and opensips.cfg with fifo config
# - mi_fifo params -
modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)
modparam(mi_fifo, fifo_mode, 0600)
modparam(mi_fifo, fifo_group, 0)
modparam(mi_fifo, fifo_group, root)
modparam(mi_fifo, fifo_user, 0)
modparam(mi_fifo, fifo_user, root)

and the callcontrol config.ini
[CallControl]
group   = root
[OpenSIPS]
socket_path = /tmp
;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i  
need 100

terminated i need to increase to 100, right???

how to fix the issue
Try  using socket_path=/tmp/socket in config.ini. The socket path  
should match the mi_datagram ,socket_name

 in the opensips config.

Tijmen de Mes
AG Projects


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-30 Thread ha do
Hi Tijmen

it works fine right now for callcontrol hangups a call in my last email
can i request to make the instruction on config.sample.ini of the OPENSIPS part
callcontrol uses the mi_datagram to make it clearer not confusing with mi_fifo
and the socket_path is the same socket_name in mi_datagram config of opensips
it should be good for someone, likes me

i still need help
 2 opensips2 is a gateway
endpoint-opensips1---opensips2internet-VOIP service 
provider
So basically opensips2 is just a gateway to opensips1?
[ha] yes,how to config cdrtool rating calls for opensips2


Thank you
Ha


- Original Message 
From: Tijmen de Mes tij...@ag-projects.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Tue, November 30, 2010 3:44:12 PM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi,

On Nov 25, 2010, at 10:06 AM, ha do wrote:
 and opensips.cfg with fifo config
 # - mi_fifo params -
 modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)
 modparam(mi_fifo, fifo_mode, 0600)
 modparam(mi_fifo, fifo_group, 0)
 modparam(mi_fifo, fifo_group, root)
 modparam(mi_fifo, fifo_user, 0)
 modparam(mi_fifo, fifo_user, root)
 
 and the callcontrol config.ini
 [CallControl]
 group   = root
 [OpenSIPS]
 socket_path = /tmp
 ;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i need 100
 terminated i need to increase to 100, right???
 
 how to fix the issue
Try  using socket_path=/tmp/socket in config.ini. The socket path should match 
the mi_datagram ,socket_name
in the opensips config.

Tijmen de Mes
AG Projects


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



  

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-29 Thread ha do
Hi Tijimen

[ha - solved] with help from bogdan_vs: i change the sock_path = 
/tmp/opensips.sock and use the mi_datagram in opensips.cfg
callcontrol hangup calls successfull. So the callcontrol use the mi_datagram, 
right??

i still need help
 2 opensips2 is a gateway
endpoint-opensips1---opensips2internet-VOIP service 
provider
So basically opensips2 is just a gateway to opensips1?
[ha] yes,

Thank you
Ha

- Original Message 
From: ha do haloha...@yahoo.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Thu, November 25, 2010 4:06:14 PM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi all

can anyone help me on call-control, i already try the 
mi_datagrambut i get the same error, permission denied

Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com started for maximum 60 seconds
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com connected for maximum 60 seconds
callcontrol.opensips.UNIXSocketProtocol starting on 
'/var/run/callcontrol/opensips_01.sock'
error: cannot write request to /tmp: Connection refused
error: failed to end dialog: Cannot send request to OpenSIPS
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com disconnected by call control after 60 seconds, call 
price 

is 0.0998

prepaid account 100 has only 60s to connect the call, and after 60s callcontrol 
cannot disconnected call

the mi_fifo located in /tmp

and opensips.cfg with fifo config
# - mi_fifo params -
modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)
modparam(mi_fifo, fifo_mode, 0600)
modparam(mi_fifo, fifo_group, 0)
modparam(mi_fifo, fifo_group, root)
modparam(mi_fifo, fifo_user, 0)
modparam(mi_fifo, fifo_user, root)

and the callcontrol config.ini
[CallControl]
group   = root
[OpenSIPS]
socket_path = /tmp
;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i need 100 
terminated i need to increase to 100, right???

how to fix the issue

thank you
Ha



- Original Message 
From: ha do haloha...@yahoo.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Wed, November 17, 2010 10:07:16 AM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi Tijimen


sorry for late reply


 2 opensips2 is a gateway
endpoint-opensips1---opensips2internet-VOIP service 
provider
So basically opensips2 is just a gateway to opensips1?
[ha] yes,



 i just try to see what happen in cdrtool, call from subscriber to subscriber
 
 these are the logs
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime Duration=36000
 callid=1289463574-3016-hiep...@192.168.1.36 From=sip:843...@192.168.1.39
 Gateway=192.168.1.36 To=sip:00842...@192.168.1.39
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime=unlimited Type=postpaid
 callid=1289463574-3016-hiep...@192.168.1.36 billingparty=843...@192.168.1.39
 
 log of call-control
 Call id 1289463575-3016-hiep...@192.168.1.36 of 843...@192.168.1.39 to
 sip:00842...@192.168.1.39 is postpaid not limited
 
 it always return postpaid
You need to specify that a sip account is prepaid if you want it to act like a 
prepaid account.

[ha] it is done and work perfectly except 1 thing

Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com started for maximum 60 seconds
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com connected for maximum 60 seconds
callcontrol.opensips.UNIXSocketProtocol starting on 
'/var/run/callcontrol/opensips_01.sock'
error: cannot write request to /tmp: Connection refused
error: failed to end dialog: Cannot send request to OpenSIPS
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com disconnected by call control after 60 seconds, call 
price 


is 0.0998

prepaid account 100 has only 60s to connect the call, and after 60s callcontrol 
cannot disconnected call

the mi_fifo located in /tmp

and opensips.cfg with fifo config
# - mi_fifo params -
modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)
modparam(mi_fifo, fifo_mode, 0600)
modparam(mi_fifo, fifo_group, 0)
modparam(mi_fifo, fifo_group, root)
modparam(mi_fifo, fifo_user, 0)
modparam(mi_fifo, fifo_user, root)

and the callcontrol config.ini
[CallControl]
group   = root
[OpenSIPS]
socket_path = /tmp
;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i need 100 
terminated i need to increase to 100, right???

how to fix the issue


Thank you
Ha`

- Original Message 
From: Tijmen de Mes tij...@ag-projects.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Mon, November 15, 2010 4:11:20 PM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi,

 
 The following steps are performed to rate a CDR:
 
 1. Determination of the billing party

Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-25 Thread ha do
Hi all

can anyone help me on call-control, i already try the 
mi_datagrambut i get the same error, permission denied

Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com started for maximum 60 seconds
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com connected for maximum 60 seconds
callcontrol.opensips.UNIXSocketProtocol starting on 
'/var/run/callcontrol/opensips_01.sock'
error: cannot write request to /tmp: Connection refused
error: failed to end dialog: Cannot send request to OpenSIPS
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com disconnected by call control after 60 seconds, call 
price 
is 0.0998

prepaid account 100 has only 60s to connect the call, and after 60s callcontrol 
cannot disconnected call

the mi_fifo located in /tmp

and opensips.cfg with fifo config
# - mi_fifo params -
modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)
modparam(mi_fifo, fifo_mode, 0600)
modparam(mi_fifo, fifo_group, 0)
modparam(mi_fifo, fifo_group, root)
modparam(mi_fifo, fifo_user, 0)
modparam(mi_fifo, fifo_user, root)

and the callcontrol config.ini
[CallControl]
group   = root
[OpenSIPS]
socket_path = /tmp
;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i need 100 
terminated i need to increase to 100, right???

how to fix the issue

thank you
Ha



- Original Message 
From: ha do haloha...@yahoo.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Wed, November 17, 2010 10:07:16 AM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi Tijimen


sorry for late reply


 2 opensips2 is a gateway
endpoint-opensips1---opensips2internet-VOIP service 
provider
So basically opensips2 is just a gateway to opensips1?
[ha] yes,



 i just try to see what happen in cdrtool, call from subscriber to subscriber
 
 these are the logs
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime Duration=36000
 callid=1289463574-3016-hiep...@192.168.1.36 From=sip:843...@192.168.1.39
 Gateway=192.168.1.36 To=sip:00842...@192.168.1.39
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime=unlimited Type=postpaid
 callid=1289463574-3016-hiep...@192.168.1.36 billingparty=843...@192.168.1.39
 
 log of call-control
 Call id 1289463575-3016-hiep...@192.168.1.36 of 843...@192.168.1.39 to
 sip:00842...@192.168.1.39 is postpaid not limited
 
 it always return postpaid
You need to specify that a sip account is prepaid if you want it to act like a 
prepaid account.

[ha] it is done and work perfectly except 1 thing

Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com started for maximum 60 seconds
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com connected for maximum 60 seconds
callcontrol.opensips.UNIXSocketProtocol starting on 
'/var/run/callcontrol/opensips_01.sock'
error: cannot write request to /tmp: Connection refused
error: failed to end dialog: Cannot send request to OpenSIPS
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com disconnected by call control after 60 seconds, call 
price 

is 0.0998

prepaid account 100 has only 60s to connect the call, and after 60s callcontrol 
cannot disconnected call

the mi_fifo located in /tmp

and opensips.cfg with fifo config
# - mi_fifo params -
modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)
modparam(mi_fifo, fifo_mode, 0600)
modparam(mi_fifo, fifo_group, 0)
modparam(mi_fifo, fifo_group, root)
modparam(mi_fifo, fifo_user, 0)
modparam(mi_fifo, fifo_user, root)

and the callcontrol config.ini
[CallControl]
group   = root
[OpenSIPS]
socket_path = /tmp
;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i need 100 
terminated i need to increase to 100, right???

how to fix the issue


Thank you
Ha`

- Original Message 
From: Tijmen de Mes tij...@ag-projects.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Mon, November 15, 2010 4:11:20 PM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi,

 
 The following steps are performed to rate a CDR:
 
 1. Determination of the billing party
 a. SIP account u...@domain
 b. SIP domain of the SIP account
 c. Source IP of the session
d. Default (when none of the above matches)
 if there is no sip account u...@domain in cdrtool the cdrtool try next
 option(sip domain) if sip domain does not exist it try next option(source 
ip)and
 then the default option
 please let me know if i am wrong
This is correct.

 2. Determination of the destination id
 a. CanonicalURI (the destination after all lookups inside the SIP Proxy)
 b. SipTranslatedRequestURI (the Request URI as presented by the SIP UA)
 c. CalledStationId (the content of the To header, used as a last resort)
 if the CanonicalURI does not exist

Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-16 Thread ha do
Hi Tijimen


sorry for late reply


 2 opensips2 is a gateway
endpoint-opensips1---opensips2internet-VOIP service 
provider
So basically opensips2 is just a gateway to opensips1?
[ha] yes,



 i just try to see what happen in cdrtool, call from subscriber to subscriber
 
 these are the logs
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime Duration=36000
 callid=1289463574-3016-hiep...@192.168.1.36 From=sip:843...@192.168.1.39
 Gateway=192.168.1.36 To=sip:00842...@192.168.1.39
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime=unlimited Type=postpaid
 callid=1289463574-3016-hiep...@192.168.1.36 billingparty=843...@192.168.1.39
 
 log of call-control
 Call id 1289463575-3016-hiep...@192.168.1.36 of 843...@192.168.1.39 to
 sip:00842...@192.168.1.39 is postpaid not limited
 
 it always return postpaid
You need to specify that a sip account is prepaid if you want it to act like a 
prepaid account.

[ha] it is done and work perfectly except 1 thing

Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com started for maximum 60 seconds
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com connected for maximum 60 seconds
callcontrol.opensips.UNIXSocketProtocol starting on 
'/var/run/callcontrol/opensips_01.sock'
error: cannot write request to /tmp: Connection refused
error: failed to end dialog: Cannot send request to OpenSIPS
Call id NTJjNzY1NzI1MzgwNmQ2MmU4NDMxMWIzZDgzNWFkOTI. of 1...@cucku.com to 
sip:00842...@cucku.com disconnected by call control after 60 seconds, call 
price 
is 0.0998

prepaid account 100 has only 60s to connect the call, and after 60s callcontrol 
cannot disconnected call

the mi_fifo located in /tmp

and opensips.cfg with fifo config
# - mi_fifo params -
modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)
modparam(mi_fifo, fifo_mode, 0600)
modparam(mi_fifo, fifo_group, 0)
modparam(mi_fifo, fifo_group, root)
modparam(mi_fifo, fifo_user, 0)
modparam(mi_fifo, fifo_user, root)

and the callcontrol config.ini
[CallControl]
group   = root
[OpenSIPS]
socket_path = /tmp
;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i need 100 
terminated i need to increase to 100, right???

how to fix the issue


Thank you
Ha`

- Original Message 
From: Tijmen de Mes tij...@ag-projects.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Mon, November 15, 2010 4:11:20 PM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi,

 
 The following steps are performed to rate a CDR:
 
 1. Determination of the billing party
 a. SIP account u...@domain
 b. SIP domain of the SIP account
 c. Source IP of the session
d. Default (when none of the above matches)
 if there is no sip account u...@domain in cdrtool the cdrtool try next
 option(sip domain) if sip domain does not exist it try next option(source 
ip)and
 then the default option
 please let me know if i am wrong
This is correct.

 2. Determination of the destination id
 a. CanonicalURI (the destination after all lookups inside the SIP Proxy)
 b. SipTranslatedRequestURI (the Request URI as presented by the SIP UA)
 c. CalledStationId (the content of the To header, used as a last resort)
 if the CanonicalURI does not exist it try to next option(Request URI) ...
 please let me know if i am wrong
This is also correct.

 3. Determination of the costs
 2 opensips2 is a gateway
endpoint-opensips1---opensips2internet-VOIP service 
provider
So basically opensips2 is just a gateway to opensips1?

 
 how can i config cdrtool rating all calls from opensips1 and opensips2
 could you please guide me some steps to do
Did you load the sample data so you can see if a call gets rated?

 
 i just try to see what happen in cdrtool, call from subscriber to subscriber
 
 these are the logs
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime Duration=36000
 callid=1289463574-3016-hiep...@192.168.1.36 From=sip:843...@192.168.1.39
 Gateway=192.168.1.36 To=sip:00842...@192.168.1.39
 Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime=unlimited Type=postpaid
 callid=1289463574-3016-hiep...@192.168.1.36 billingparty=843...@192.168.1.39
 
 log of call-control
 Call id 1289463575-3016-hiep...@192.168.1.36 of 843...@192.168.1.39 to
 sip:00842...@192.168.1.39 is postpaid not limited
 
 it always return postpaid
You need to specify that a sip account is prepaid if you want it to act like a 
prepaid account.

--
Tijmen de Mes
AG Projects


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



  

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-11 Thread Tijmen de Mes

Hi,

You should verify by hand that you can connect to the database by
executing a mysql -h 192.168.1.39 -u opensips -psips  opensips.

Maybe you forgot to remove the bind interfaces directive in the mysql  
config.


Best regards,

Tijmen de Mes
AG Projects

On Nov 9, 2010, at 4:11 AM, ha do wrote:


Hi all

i installed opensips and mediaproxy in server 1, ip address :  
192.168.1.39

and cdrtool and freeradius in server 2, ip address : 192.168.1.42

the opensips, mediaproxy, freeradius starting are fine


i use the link below as a guide
http://cdrtool.ag-projects.com/browser/doc/INSTALL.txt

the problem i got only with cdrtool
Nov  9 04:56:22 cdrtool cdrtool[3219]: Read 12291 PSTN destinations  
from cache

in 0 seconds
Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect  
as opensips

to 192.168.1.39 failed
Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:   
(0) select *

from domain
Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect  
as opensips

to 192.168.1.39 failed
Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:   
(0) select *

from trusted
Nov  9 04:56:22 cdrtool cdrtool[3219]: PSTN destinations cache size:  
0.64 MB
Nov  9 04:56:22 cdrtool cdrtool[3219]: SIP destinations cache size:  
0.00 MB
Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 12291 total, 12291  
default, 0

gateway, 0 domain, 0 subscriber destinations
Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 0 SIP destinations


the cdrtool is fine with almost component except the connection to  
opensips

the global.inc with define opensips server
class DB_opensips extends DB_Sql {
var $Host = 192.168.1.39;
var $Database = opensips;
var $User = opensips;
var $Password = sips;
var $Halt_On_Error = no;
}

and issue the command  grant all on opensips.* to  
opensips@'192.168.1.%'

identified by 'sips'; in opensips server

please help

Ha`





___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-11 Thread ha do
Hi Tijmen

Maybe you forgot to remove the bind interfaces directive in the mysql config.
that is useful information, i edit the my.cnf and now it works fine now

i read the RATING.txt, PREPAID.txt times to times but i cannot understand it


The following steps are performed to rate a CDR:

1. Determination of the billing party
a. SIP account u...@domain 
b. SIP domain of the SIP account
c. Source IP of the session
d. Default (when none of the above matches)
if there is no sip account u...@domain in cdrtool the cdrtool try next 
option(sip domain) if sip domain does not exist it try next option(source 
ip)and 
then the default option
please let me know if i am wrong

2. Determination of the destination id
a. CanonicalURI (the destination after all lookups inside the SIP Proxy) 
b. SipTranslatedRequestURI (the Request URI as presented by the SIP UA)
c. CalledStationId (the content of the To header, used as a last resort)
if the CanonicalURI does not exist it try to next option(Request URI) ...
please let me know if i am wrong

3. Determination of the costs


i try to test 
1. opensips1 is the registrar server and try to do prepaid for every 
subscribers 
of opensips
subscriber registers to opensips1, opensips1 domain 192.168.1.39

2 opensips2 is a gateway
endpoint-opensips1---opensips2internet-VOIP service provider

how can i config cdrtool rating all calls from opensips1 and opensips2
could you please guide me some steps to do

i did check the global.inc and cdr_generic.php 
-global.inc is a copy of global.inc.simple.sample and i change 
# Normalize engine settings
$CDRTool['normalize']['defaultCountryCode']  = 84;
-cdr-generic.php does not change


i config  in web

the destination
Ops,Reseller,Trusted 
peer,Domain,Subscriber,Destination,Region,Description,Incr,Min Dur,Max Dur,Max 
Price
2,084,,vietnam,6,6,0,

rate
Ops,Reseller,Rate,Destination,App,Connect,Duration,Conn In,Duration In
2,0,84,84,audio,0,998,,

profile
Ops,Reseller,Profile,Rate 1,00-H1,Rate 2,H1-H2,Rate 3,H2-H3,Rate 4,H3-24
2,0,84,84,24,0,0,,0,,0


i just try to see what happen in cdrtool, call from subscriber to subscriber

these are the logs
Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime Duration=36000 
callid=1289463574-3016-hiep...@192.168.1.36 From=sip:843...@192.168.1.39 
Gateway=192.168.1.36 To=sip:00842...@192.168.1.39
Nov 11 12:39:46 opensips cdrtool[2302]: MaxSessionTime=unlimited Type=postpaid 
callid=1289463574-3016-hiep...@192.168.1.36 billingparty=843...@192.168.1.39

log of call-control
Call id 1289463575-3016-hiep...@192.168.1.36 of 843...@192.168.1.39 to 
sip:00842...@192.168.1.39 is postpaid not limited

it always return postpaid

Thank you




- Original Message 
From: Tijmen de Mes tij...@ag-projects.com
To: OpenSIPS users mailling list users@lists.opensips.org
Sent: Thu, November 11, 2010 4:42:49 PM
Subject: Re: [OpenSIPS-Users] need help on connection CDRTool to opensips

Hi,

You should verify by hand that you can connect to the database by
executing a mysql -h 192.168.1.39 -u opensips -psips  opensips.

Maybe you forgot to remove the bind interfaces directive in the mysql config.

Best regards,

Tijmen de Mes
AG Projects

On Nov 9, 2010, at 4:11 AM, ha do wrote:

 Hi all
 
 i installed opensips and mediaproxy in server 1, ip address : 192.168.1.39
 and cdrtool and freeradius in server 2, ip address : 192.168.1.42
 
 the opensips, mediaproxy, freeradius starting are fine
 
 
 i use the link below as a guide
 http://cdrtool.ag-projects.com/browser/doc/INSTALL.txt
 
 the problem i got only with cdrtool
 Nov  9 04:56:22 cdrtool cdrtool[3219]: Read 12291 PSTN destinations from cache
 in 0 seconds
 Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect as 
opensips
 to 192.168.1.39 failed
 Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:  (0) 
 select 
*
 from domain
 Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect as 
opensips
 to 192.168.1.39 failed
 Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:  (0) 
 select 
*
 from trusted
 Nov  9 04:56:22 cdrtool cdrtool[3219]: PSTN destinations cache size: 0.64 MB
 Nov  9 04:56:22 cdrtool cdrtool[3219]: SIP destinations cache size: 0.00 MB
 Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 12291 total, 12291 default, 0
 gateway, 0 domain, 0 subscriber destinations
 Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 0 SIP destinations
 
 
 the cdrtool is fine with almost component except the connection to opensips
 the global.inc with define opensips server
 class DB_opensips extends DB_Sql {
 var $Host = 192.168.1.39;
 var $Database = opensips;
 var $User = opensips;
 var $Password = sips;
 var $Halt_On_Error = no;
 }
 
 and issue the command  grant all on opensips.* to opensips@'192.168.1.%'
 identified by 'sips'; in opensips server
 
 please help
 
 Ha`
 
 
 
 
 
 ___
 Users mailing list
 Users@lists.opensips.org

[OpenSIPS-Users] need help on connection CDRTool to opensips

2010-11-08 Thread ha do
Hi all

i installed opensips and mediaproxy in server 1, ip address : 192.168.1.39
and cdrtool and freeradius in server 2, ip address : 192.168.1.42

the opensips, mediaproxy, freeradius starting are fine


i use the link below as a guide
http://cdrtool.ag-projects.com/browser/doc/INSTALL.txt

the problem i got only with cdrtool
Nov  9 04:56:22 cdrtool cdrtool[3219]: Read 12291 PSTN destinations from cache 
in 0 seconds
Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect as opensips 
to 192.168.1.39 failed
Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:  (0) select 
* 
from domain
Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect as opensips 
to 192.168.1.39 failed
Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:  (0) select 
* 
from trusted
Nov  9 04:56:22 cdrtool cdrtool[3219]: PSTN destinations cache size: 0.64 MB
Nov  9 04:56:22 cdrtool cdrtool[3219]: SIP destinations cache size: 0.00 MB
Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 12291 total, 12291 default, 0 
gateway, 0 domain, 0 subscriber destinations
Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 0 SIP destinations


the cdrtool is fine with almost component except the connection to opensips
the global.inc with define opensips server
class DB_opensips extends DB_Sql {
  var $Host = 192.168.1.39;
  var $Database = opensips;
  var $User = opensips;
  var $Password = sips;
  var $Halt_On_Error = no;
}

and issue the command  grant all on opensips.* to opensips@'192.168.1.%' 
identified by 'sips'; in opensips server

please help

Ha`



  

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users