Re: [OpenSIPS-Users] domain in prepaid scenarios not honoured
Hi Samuel, A domain can be defined in the billing_customers table. In your case testintern.domain.com mailto:0034123456...@testintern.domain.com. You should also add the timezone to this domain in the same table. If this still does not work, and like you said, the domain is not properly split/retrieved from the uri, I've to look deeper in the code why this can happen. So can you please add the domain and let me know the outcome? Best regards, -- Tijmen de Mes AG Projects On 02/13/2012 05:30 PM, samuel wrote: Hi all, Recently I was playing with the prepaid functionallity of CDRTool (8.2.3) and found out that when the customer is not explicitely defined in the field Subscriber, the domain is not looked up. I have opensips (1.7.1) with call control application from apt sources (2.0.15) and when the following call is sent: sent from opensips to CDRTool: MaxSessionTime Duration=36000 CallId=JeJ5LJz8iCXozC1AGxhqoOIliuToIm53 From=sip:m...@testintern.domain.com mailto:sip%3a...@testintern.domain.com Gateway=X.Y.Z.W To=sip :0034123456...@testintern.domain.com mailto:0034123456...@testintern.domain.com.. ## reply from CDRTool error: cannot figure out the billing timezone.type=prepaid.type=prepaid Looking in the syslog we find the right answer: Feb 13 17:18:30 cdrtool cdrtool[30106]: Error: no customer found in billing_customers table for billing party=m...@testintern.domain.com mailto:m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Feb 13 17:18:30 cdrtool cdrtool[30106]: error: cannot figure out the billing timezone#012type=prepaid so it looks like the domain is not extracted from the user part and it is not checked in the billing_customers table. The query in the function lookupProfiles (file rating.php) uses $this-dictionary['domain'] as the source for the domain but in the prepaid scenario, this parameter hasn't got a value. Am I right? I've tried to dig further in the code but unfortunately got lost in the exportation of the CDR's dictionary to the function that is used in prepaid scenarios. Is there any option I'm missing? Is it possible to setup just the domain in the billing_customers table and not a line foreach prepaid customer? Congratulations for the project and thanks in advance, Samuel ___ 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] domain in prepaid scenarios not honoured
The domain is already in the billing_customers table with the corresponding timezone. The problem, as far as I could see, was that in the SQL query retrieving the customer the domain was not set and only billing_party and gateway, as states the following line of the log I sent: billing party=m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Since only the domain is stored in the customers table is set, the previous query did not return any value and the callcontrol-cdrtool connection returned error (which should be changed from the timezone to the customer not found.) Thanks a lot for taking a look at it, case you need more infromation, I can surely provide it. Best regards, Samuel On 14 February 2012 10:00, Tijmen de Mes tij...@ag-projects.com wrote: Hi Samuel, A domain can be defined in the billing_customers table. In your case testintern.domain.com 0034123456...@testintern.domain.com. You should also add the timezone to this domain in the same table. If this still does not work, and like you said, the domain is not properly split/retrieved from the uri, I've to look deeper in the code why this can happen. So can you please add the domain and let me know the outcome? Best regards, -- Tijmen de Mes AG Projects On 02/13/2012 05:30 PM, samuel wrote: Hi all, Recently I was playing with the prepaid functionallity of CDRTool (8.2.3) and found out that when the customer is not explicitely defined in the field Subscriber, the domain is not looked up. I have opensips (1.7.1) with call control application from apt sources (2.0.15) and when the following call is sent: sent from opensips to CDRTool: MaxSessionTime Duration=36000 CallId=JeJ5LJz8iCXozC1AGxhqoOIliuToIm53 From=sip:m...@testintern.domain.com Gateway=X.Y.Z.W To=sip :0034123456...@testintern.domain.com.. ## reply from CDRTool error: cannot figure out the billing timezone.type=prepaid.type=prepaid Looking in the syslog we find the right answer: Feb 13 17:18:30 cdrtool cdrtool[30106]: Error: no customer found in billing_customers table for billing party=m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Feb 13 17:18:30 cdrtool cdrtool[30106]: error: cannot figure out the billing timezone#012type=prepaid so it looks like the domain is not extracted from the user part and it is not checked in the billing_customers table. The query in the function lookupProfiles (file rating.php) uses $this-dictionary['domain'] as the source for the domain but in the prepaid scenario, this parameter hasn't got a value. Am I right? I've tried to dig further in the code but unfortunately got lost in the exportation of the CDR's dictionary to the function that is used in prepaid scenarios. Is there any option I'm missing? Is it possible to setup just the domain in the billing_customers table and not a line foreach prepaid customer? Congratulations for the project and thanks in advance, Samuel ___ Users mailing listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ 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] domain in prepaid scenarios not honoured
CDRTool Prepaid Engine was designed to work for individual SIP accounts, not for entire domains. Adrian On Feb 14, 2012, at 12:04 PM, samuel wrote: The domain is already in the billing_customers table with the corresponding timezone. The problem, as far as I could see, was that in the SQL query retrieving the customer the domain was not set and only billing_party and gateway, as states the following line of the log I sent: billing party=m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Since only the domain is stored in the customers table is set, the previous query did not return any value and the callcontrol-cdrtool connection returned error (which should be changed from the timezone to the customer not found.) Thanks a lot for taking a look at it, case you need more infromation, I can surely provide it. Best regards, Samuel On 14 February 2012 10:00, Tijmen de Mes tij...@ag-projects.com wrote: Hi Samuel, A domain can be defined in the billing_customers table. In your case testintern.domain.com. You should also add the timezone to this domain in the same table. If this still does not work, and like you said, the domain is not properly split/retrieved from the uri, I've to look deeper in the code why this can happen. So can you please add the domain and let me know the outcome? Best regards, -- Tijmen de Mes AG Projects On 02/13/2012 05:30 PM, samuel wrote: Hi all, Recently I was playing with the prepaid functionallity of CDRTool (8.2.3) and found out that when the customer is not explicitely defined in the field Subscriber, the domain is not looked up. I have opensips (1.7.1) with call control application from apt sources (2.0.15) and when the following call is sent: sent from opensips to CDRTool: MaxSessionTime Duration=36000 CallId=JeJ5LJz8iCXozC1AGxhqoOIliuToIm53 From=sip:m...@testintern.domain.com Gateway=X.Y.Z.W To=sip :0034123456...@testintern.domain.com.. ## reply from CDRTool error: cannot figure out the billing timezone.type=prepaid.type=prepaid Looking in the syslog we find the right answer: Feb 13 17:18:30 cdrtool cdrtool[30106]: Error: no customer found in billing_customers table for billing party=m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Feb 13 17:18:30 cdrtool cdrtool[30106]: error: cannot figure out the billing timezone#012type=prepaid so it looks like the domain is not extracted from the user part and it is not checked in the billing_customers table. The query in the function lookupProfiles (file rating.php) uses $this-dictionary['domain'] as the source for the domain but in the prepaid scenario, this parameter hasn't got a value. Am I right? I've tried to dig further in the code but unfortunately got lost in the exportation of the CDR's dictionary to the function that is used in prepaid scenarios. Is there any option I'm missing? Is it possible to setup just the domain in the billing_customers table and not a line foreach prepaid customer? Congratulations for the project and thanks in advance, Samuel ___ 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 ___ 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] domain in prepaid scenarios not honoured
great to know! That's what it looked like and just wanted to get reliable confirmation. Thanks a lot! Samuel. On 14 February 2012 12:48, Adrian Georgescu a...@ag-projects.com wrote: CDRTool Prepaid Engine was designed to work for individual SIP accounts, not for entire domains. Adrian On Feb 14, 2012, at 12:04 PM, samuel wrote: The domain is already in the billing_customers table with the corresponding timezone. The problem, as far as I could see, was that in the SQL query retrieving the customer the domain was not set and only billing_party and gateway, as states the following line of the log I sent: billing party=m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Since only the domain is stored in the customers table is set, the previous query did not return any value and the callcontrol-cdrtool connection returned error (which should be changed from the timezone to the customer not found.) Thanks a lot for taking a look at it, case you need more infromation, I can surely provide it. Best regards, Samuel On 14 February 2012 10:00, Tijmen de Mes tij...@ag-projects.com wrote: Hi Samuel, A domain can be defined in the billing_customers table. In your case testintern.domain.com 0034123456...@testintern.domain.com. You should also add the timezone to this domain in the same table. If this still does not work, and like you said, the domain is not properly split/retrieved from the uri, I've to look deeper in the code why this can happen. So can you please add the domain and let me know the outcome? Best regards, -- Tijmen de Mes AG Projects On 02/13/2012 05:30 PM, samuel wrote: Hi all, Recently I was playing with the prepaid functionallity of CDRTool (8.2.3) and found out that when the customer is not explicitely defined in the field Subscriber, the domain is not looked up. I have opensips (1.7.1) with call control application from apt sources (2.0.15) and when the following call is sent: sent from opensips to CDRTool: MaxSessionTime Duration=36000 CallId=JeJ5LJz8iCXozC1AGxhqoOIliuToIm53 From=sip:m...@testintern.domain.com Gateway=X.Y.Z.W To=sip :0034123456...@testintern.domain.com.. ## reply from CDRTool error: cannot figure out the billing timezone.type=prepaid.type=prepaid Looking in the syslog we find the right answer: Feb 13 17:18:30 cdrtool cdrtool[30106]: Error: no customer found in billing_customers table for billing party=m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Feb 13 17:18:30 cdrtool cdrtool[30106]: error: cannot figure out the billing timezone#012type=prepaid so it looks like the domain is not extracted from the user part and it is not checked in the billing_customers table. The query in the function lookupProfiles (file rating.php) uses $this-dictionary['domain'] as the source for the domain but in the prepaid scenario, this parameter hasn't got a value. Am I right? I've tried to dig further in the code but unfortunately got lost in the exportation of the CDR's dictionary to the function that is used in prepaid scenarios. Is there any option I'm missing? Is it possible to setup just the domain in the billing_customers table and not a line foreach prepaid customer? Congratulations for the project and thanks in advance, Samuel ___ Users mailing listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ 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 ___ 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
[OpenSIPS-Users] BLF w/ Polycom and FreeSWITCH
I am unable to get BLF to work when I have OpenSIPS in front of FreeSWITCH. The NOTIFY/SUBSCRIBE appears to be successful, here is SIP trace: test1.voip.demo.i-evolve.net is the SIP domain pointing at OpenSIPS (72.43.207.158) FreeSWITCH IP is 72.43.207.155 begin of packet - U 2012/02/14 08:30:15.660850 72.43.207.130:1666 - 72.43.207.158:5060 REGISTER sip:test1.voip.demo.i-evolve.net SIP/2.0 Via: SIP/2.0/UDP 72.43.207.130:1666;branch=z9hG4bKf59d03a4266B7F41 From: Jackie C. sip:1...@test1.voip.demo.i-evolve.net;tag=37656326-ABE8AE0B To: sip:1...@test1.voip.demo.i-evolve.net CSeq: 1 REGISTER Call-ID: 2673bb72-3f195707-51caae10@192.168.99.21 Contact: sip:1000@72.43.207.130:1666;methods=INVITE, ACK, BYE, CANCEL, OPTIONS, INFO, MESSAGE, SUBSCRIBE, NOTIFY, PRACK, UPDATE, REFER User-Agent: PolycomSoundPointIP-SPIP_330-UA/3.2.2.0477 Accept-Language: en Max-Forwards: 70 Expires: 3600 Content-Length: 0 --end of packet - begin of packet - U 2012/02/14 08:30:15.661413 72.43.207.158:5060 - 72.43.207.155:5060 REGISTER sip:72.43.207.155:5060 SIP/2.0 Via: SIP/2.0/UDP 72.43.207.158;branch=z9hG4bKf54f.188e1555.0 Via: SIP/2.0/UDP 72.43.207.130:1666;branch=z9hG4bKf59d03a4266B7F41 From: Jackie C. sip:1...@test1.voip.demo.i-evolve.net;tag=37656326-ABE8AE0B To: sip:1...@test1.voip.demo.i-evolve.net CSeq: 1 REGISTER Call-ID: 2673bb72-3f195707-51caae10@192.168.99.21 Contact: sip:1000@72.43.207.130:1666;methods=INVITE, ACK, BYE, CANCEL, OPTIONS, INFO, MESSAGE, SUBSCRIBE, NOTIFY, PRACK, UPDATE, REFER User-Agent: PolycomSoundPointIP-SPIP_330-UA/3.2.2.0477 Accept-Language: en Max-Forwards: 30 Expires: 3600 Content-Length: 0 Path: sip:72.43.207.158;lr;received=sip:72.43.207.130:1666 X-AUTH-IP: 72.43.207.130 --end of packet - begin of packet - U 2012/02/14 08:30:15.664242 72.43.207.155:5060 - 72.43.207.158:5060 SIP/2.0 401 Unauthorized Via: SIP/2.0/UDP 72.43.207.158;branch=z9hG4bKf54f.188e1555.0 Via: SIP/2.0/UDP 72.43.207.130:1666;branch=z9hG4bKf59d03a4266B7F41 From: Jackie C. sip:1...@test1.voip.demo.i-evolve.net;tag=37656326-ABE8AE0B To: sip:1...@test1.voip.demo.i-evolve.net;tag=B3eFSHXS8Q0vN Call-ID: 2673bb72-3f195707-51caae10@192.168.99.21 CSeq: 1 REGISTER User-Agent: AMPSwitch Allow: INVITE, ACK, BYE, CANCEL, OPTIONS, MESSAGE, UPDATE, INFO, REGISTER, REFER, NOTIFY, PUBLISH, SUBSCRIBE Supported: timer, precondition, path, replaces WWW-Authenticate: Digest realm=test1.voip.demo.i-evolve.net, nonce=079dfd86-5710-11e1-af11-2f1196b916eb, algorithm=MD5, qop=auth Content-Length: 0 --end of packet - begin of packet - U 2012/02/14 08:30:15.664558 72.43.207.158:5060 - 72.43.207.130:1666 SIP/2.0 401 Unauthorized Via: SIP/2.0/UDP 72.43.207.130:1666;branch=z9hG4bKf59d03a4266B7F41 From: Jackie C. sip:1...@test1.voip.demo.i-evolve.net;tag=37656326-ABE8AE0B To: sip:1...@test1.voip.demo.i-evolve.net;tag=B3eFSHXS8Q0vN Call-ID: 2673bb72-3f195707-51caae10@192.168.99.21 CSeq: 1 REGISTER User-Agent: AMPSwitch Allow: INVITE, ACK, BYE, CANCEL, OPTIONS, MESSAGE, UPDATE, INFO, REGISTER, REFER, NOTIFY, PUBLISH, SUBSCRIBE Supported: timer, precondition, path, replaces WWW-Authenticate: Digest realm=test1.voip.demo.i-evolve.net, nonce=079dfd86-5710-11e1-af11-2f1196b916eb, algorithm=MD5, qop=auth Content-Length: 0 --end of packet - begin of packet - U 2012/02/14 08:30:15.682827 72.43.207.130:1666 - 72.43.207.158:5060 REGISTER sip:test1.voip.demo.i-evolve.net SIP/2.0 Via: SIP/2.0/UDP 72.43.207.130:1666;branch=z9hG4bK7a3b5bcD257C8B9 From: Jackie C. sip:1...@test1.voip.demo.i-evolve.net;tag=37656326-ABE8AE0B To: sip:1...@test1.voip.demo.i-evolve.net CSeq: 2 REGISTER Call-ID: 2673bb72-3f195707-51caae10@192.168.99.21 Contact: sip:1000@72.43.207.130:1666;methods=INVITE, ACK, BYE, CANCEL, OPTIONS, INFO, MESSAGE, SUBSCRIBE, NOTIFY, PRACK, UPDATE, REFER User-Agent: PolycomSoundPointIP-SPIP_330-UA/3.2.2.0477 Accept-Language: en Authorization: Digest username=1000, realm=test1.voip.demo.i-evolve.net, nonce=079dfd86-5710-11e1-af11-2f1196b916eb, qop=auth, cnonce=CNyXC4dNuYJCV0G, nc=0001, uri=sip:test1.voip.demo.i-evolve.net, response=4ff00198d12440fbc2aa14dcf9fb213b, algorithm=MD5 Max-Forwards: 70 Expires: 3600 Content-Length: 0 --end of packet - begin of packet - U 2012/02/14 08:30:15.683235 72.43.207.158:5060 - 72.43.207.155:5060 REGISTER sip:72.43.207.155:5060 SIP/2.0 Via: SIP/2.0/UDP 72.43.207.158;branch=z9hG4bKc54f.4c7b9b9.0 Via: SIP/2.0/UDP 72.43.207.130:1666;branch=z9hG4bK7a3b5bcD257C8B9 From: Jackie C. sip:1...@test1.voip.demo.i-evolve.net;tag=37656326-ABE8AE0B To:
[OpenSIPS-Users] Error opening OpenSIPS's FIFO /tmp/opensips_fifo
Hello, I'm getting this error(s), but did not find a solution that works from the Email archives on the subject. I'm using CentOS 5.7 and openSIPS 1.7.1. ERROR: Error opening OpenSIPS's FIFO /tmp/opensips_fifo ERROR: Make sure you have the line 'modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)' in your config ERROR: and also have loaded the mi_fifo module. I verified these lines are in my opensips.cfg file: modparam(mi_fifo, fifo_name, /tmp/opensips_fifo) modparam(mi_fifo, fifo_mode, 0666) I verified this line in my opensipsctlrc file: OSIPS_FIFO=/tmp/opensips_fifo I also verified there is no /tmp/opensips_fifo file or folder. Can someone help? Thanks, Jerry ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] NOTIFY authentication for UACs
Hi, I'm using Opensips to authenticate/authorize REGISTER and SUBSCRIBE messages for UACs before relaying them to Asterisk. secret field for sip peers is empty so Asterisk doesn't require authentication again for those. This works fine, but the lack of password in Asterisk seems to create a problem when I send NOTIFY messages to UACs which require authentication for NOTIFY. Is it possible to intercept Asterisk's reply and change the authorization header in Opensips before sending it to the UAC- maybe via uac_auth()? Thanks, Matt ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] NOTIFY authentication for UACs
14 feb 2012 kl. 17:40 skrev Matt Hamilton: Hi, I'm using Opensips to authenticate/authorize REGISTER and SUBSCRIBE messages for UACs before relaying them to Asterisk. secret field for sip peers is empty so Asterisk doesn't require authentication again for those. This works fine, but the lack of password in Asterisk seems to create a problem when I send NOTIFY messages to UACs which require authentication for NOTIFY. Is it possible to intercept Asterisk's reply and change the authorization header in Opensips before sending it to the UAC- maybe via uac_auth()? New version of Asteirsk has the remotesecret option to separate inbound and outbound auth. /O ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] NOTIFY authentication for UACs
Thanks, I'll check it out (I'm on 1.8.7.2 now) From: o...@edvina.net Date: Tue, 14 Feb 2012 17:49:29 +0100 To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] NOTIFY authentication for UACs 14 feb 2012 kl. 17:40 skrev Matt Hamilton: Hi, I'm using Opensips to authenticate/authorize REGISTER and SUBSCRIBE messages for UACs before relaying them to Asterisk. secret field for sip peers is empty so Asterisk doesn't require authentication again for those. This works fine, but the lack of password in Asterisk seems to create a problem when I send NOTIFY messages to UACs which require authentication for NOTIFY. Is it possible to intercept Asterisk's reply and change the authorization header in Opensips before sending it to the UAC- maybe via uac_auth()? New version of Asteirsk has the remotesecret option to separate inbound and outbound auth. /O ___ 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] Error opening OpenSIPS's FIFO /tmp/opensips_fifo
Hi Jerry, Check if the daemon is up using: ps -ef |grep opensips. If were not up, check the syslog file tail /var/log/messages Sometimes one start opensips, the screen shows the ip/names, but the daemon is not starting for some reason. Flavio E. Goncalves CEO - SipPulse On Tue, Feb 14, 2012 at 1:15 PM, Jerry Richards jerry.richa...@teotech.comwrote: Hello, I'm getting this error(s), but did not find a solution that works from the Email archives on the subject. I'm using CentOS 5.7 and openSIPS 1.7.1. ERROR: Error opening OpenSIPS's FIFO /tmp/opensips_fifo ERROR: Make sure you have the line 'modparam(mi_fifo, fifo_name, /tmp/opensips_fifo)' in your config ERROR: and also have loaded the mi_fifo module. I verified these lines are in my opensips.cfg file: modparam(mi_fifo, fifo_name, /tmp/opensips_fifo) modparam(mi_fifo, fifo_mode, 0666) I verified this line in my opensipsctlrc file: OSIPS_FIFO=/tmp/opensips_fifo I also verified there is no /tmp/opensips_fifo file or folder. Can someone help? Thanks, Jerry ___ 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
