Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh ! The root of the problem is the accX_flags dialog variable isn't properly serialized. What I'm trying to find out is why this happens, that's why I will need some extra debug as I can't figure out the problem there. So please apply this last patch and try again. It should be

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razvan, I don't see the patch attached !! --- Jayesh On Wed, Dec 7, 2011 at 2:57 PM, Razvan Crainea razvancrai...@opensips.orgwrote: Hi, Jayesh ! The root of the problem is the accX_flags dialog variable isn't properly serialized. What I'm trying to find out is why this happens, that's

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Sorr, I forgot to attach it. Here it is. Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 11:59 AM, Jayesh Nambiar wrote: Hi Razvan, I don't see the patch attached !! --- Jayesh On Wed, Dec 7, 2011 at 2:57 PM, Razvan Crainea razvancrai...@opensips.org

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razvan, Applied the patch and re-tested it. Here the logs that you are interested in specifically: Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]: DBG:dialog:write_pair: Dumping var name: accX_flags value: #026 Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]: DBG:dialog:write_pair:

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! And what is the string in the database? You can see it in the database after you kill opensips with the following command: select vars from dialog; Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 12:24 PM, Jayesh Nambiar wrote: Hi Razvan, Applied the patch and

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
This is the string what I see when I query the dialog table for vars: accX_flags# |accX_db#( 2 1 11 1002 12013386166 919833171405 0 203.153.53.158 203.153.53.136 0 17 0 2 IP India - Mobile 919 9198 2 1 2 4 0.0150 0.0130 0 0. 0.0226 1. 6 1 6 1 1 2 2 2 Aal Izz

Re: [OpenSIPS-Users] Modify To:'s field and forward

2011-12-07 Thread spady
Hi list, I would share with you all what i reached about my script. Hope this would be helpfull for someone of you. if (avp_db_load($fu/username,$avp(ARS-OFS))) { if (avp_check($avp(ARS-OFS),eq/lw-re/i)) { if ($rU=~^0[0-9]+)

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! It seems like the problem appears while parsing the string got from the database, so after opensips is restarted. The patch attached should give us more information about the error. Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 12:37 PM, Jayesh Nambiar wrote:

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razwan, I have applied the patch and made it working. Do you still only need the logs after opensips shutdown or also the logs after opensips restarts. --- Jayesh On Wed, Dec 7, 2011 at 4:35 PM, Razvan Crainea razvancrai...@opensips.orgwrote: Hi, Jayesh! It seems like the problem appears

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! I need the logs after opensips restarts. The result might also be pretty large. Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 02:14 PM, Jayesh Nambiar wrote: Hi Razwan, I have applied the patch and made it working. Do you still only need the logs after opensips

Re: [OpenSIPS-Users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

2011-12-07 Thread Vlad Paiu
Hello, Can you connect to your mysql server from a shell using the credentials that you have entered in the OpenSIPS cfg ? Regards, Vlad Vlad Paiu OpenSIPS Developer On 12/06/2011 11:06 PM, M.Abdulaziz wrote: Could anyone please help in this problem? I really appreciate all your help.

Re: [OpenSIPS-Users] Opensip CDRs inaccurate

2011-12-07 Thread Vlad Paiu
Hello, Are you sure you are accounting for all of the calls in your script ? If yes, try and identify the calls that your providers see but you do not, and return with more info. Regards, Vlad Paiu OpenSIPS Developer On 12/06/2011 10:44 PM, Vic Jolin wrote: We have been running opensip for

Re: [OpenSIPS-Users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

2011-12-07 Thread M.Abdulaziz
Hello thank you for responding, yes I can access mysql with the same credentials as follows: /etc/init.d/mysqld start Starting mysqld [OK] mysql -u root -p Enter password:xx Welcome to mysql monitor. Use opensips; ... I can access the mysql only this way but

Re: [OpenSIPS-Users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

2011-12-07 Thread Vlad Paiu
Hello, You are connecting with the root username and password. I see you have OpenSIPS configured this way : modparam(usrloc, db_url,mysql://opensips:opensipsrw@localhost/opensips) opensips is the username opensipsrw is the password Please make sure these are correct. Regards, Vlad

Re: [OpenSIPS-Users] Dialog statistics

2011-12-07 Thread M.Abdulaziz
Thank you for your valuable help Bogdan. Best Regards -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Dialog-statistics-tp7060702p7070513.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com.

Re: [OpenSIPS-Users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

2011-12-07 Thread Ovidiu Sas
Make sure that you are able to connect to mysql using tcp: http://www.howtoforge.com/faq/6_8_en.html Regards, Ovidiu Sas On Wed, Dec 7, 2011 at 8:41 AM, M.Abdulaziz malduwa...@ksu.edu.sa wrote: Hello thank you for responding, yes I can access mysql with the same credentials as follows:

Re: [OpenSIPS-Users] Configuring OpenSIPS with Postgresql

2011-12-07 Thread Bogdan-Andrei Iancu
Hi Jerry, If I said postgres://., then that's the way it should be, right ? Regards, Bogdan On 12/06/2011 09:41 PM, Jerry Richards wrote: Thanks, Bogdan. Which of these should it be? modparam(usrloc, db_url, postgres://opensips:opensipsrw@localhost/opensips) modparam(usrloc,

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! Can you check in your mysql database if the vars column from the dialog table is declared as TEXT or BLOB and not CHAR? If not, please change your column into BLOB: ALTER TABLE dialog CHANGE vars vars BLOB; Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 02:27 PM,

Re: [OpenSIPS-Users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

2011-12-07 Thread M.Abdulaziz
Thank you very very much Vald Ovidiu finally its working how nice is to see things working with no errors I really appreciate your help -- View this message in context:

[OpenSIPS-Users] proxy non-existing domain to another address

2011-12-07 Thread Leon de Rooij
Hello all, Sorry for the subject not being too clear, but let me explain what I'd like to achieve (not sure if it's possible at all?) * A carrier (UA2) would like us to send them INVITEs with a domain (lets say foo.com) in the RURI and To header, while that domain is not resolvable through

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razvan, This actually solved the problem. Thank you very much. It was defined as VARCHAR instead of TEXT. Thank you very much for all the efforts. Really appreciate it. Need to get hold of my DB guy for the stupid mistake !! --- Jayesh On Wed, Dec 7, 2011 at 8:13 PM, Razvan Crainea

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Ryan Bullock
Could a VARBINARY be used here instead? We actually use a memory table for the dialog table to reduce load on our disk and it does not support BLOB or TEXT, so instead we changed it to a large VARCHAR. The mysql docs suggest you can treat a TEXT the same as a VARCHAR, but obviously there are

Re: [OpenSIPS-Users] multiple rtpproxy for multiple NAT?

2011-12-07 Thread Matt Hamilton
Hi Sammy, Thanks for the suggestion. I had actually tried it with one rttpproxy and got it mostly working. However, I'm new to this and I'm on a pretty tight schedule so no time for experimenting. I moved the Asterisk servers into the DMZ with Opensips, and the far-end NAT traversal is

[OpenSIPS-Users] B2BUA Ripping/Truncating Callid

2011-12-07 Thread Logan
Hello list this is the second odd thing I've seen with b2bua in opensips 1.7.1 It looks like the b2bua module is mangling the cancel message and is ripping out the callid when sending upstream:U 2011/12/07 20:15:05.895915 192.168.1.143:5060 - 192.168.1.145:5090 CANCEL

Re: [OpenSIPS-Users] B2BUA Ripping/Truncating Callid

2011-12-07 Thread Ovidiu Sas
Are you trying to perform any msg manipulations during b2b scenarios? Also, keep in mind that the b2b server functionality must be kept isolated from the proxy server functionality (proxy mode is not compatible with b2b mode). Regards, Ovidiu Sas -- VoIP Embedded, Inc.http://www.voipembedded.com

Re: [OpenSIPS-Users] B2BUA Ripping/Truncating Callid

2011-12-07 Thread Logan
I'm storing some $vars in route[0] prior to calling b2b_init_request("top hiding");Then in my local route Im appending a P-Asserted-Identity header.I can't use the custom_headers modparam because it's going to preserve the PAI as it comes in. Most of the time it's not present, or is in the wrong

Re: [OpenSIPS-Users] B2BUA Ripping/Truncating Callid

2011-12-07 Thread Ovidiu Sas
You need to be careful when you alter requests in B2B mode (the received INVITE and the sent INVITE belong to different transactions). Make sure that you have something valid in those vars before applying any changes to the outgoing message. Regards, Ovidiu Sas On Wed, Dec 7, 2011 at 4:49 PM,

Re: [OpenSIPS-Users] B2BUA Ripping/Truncating Callid

2011-12-07 Thread Logan
This is the extent of my local route. If the $var is not present, I do not add it. Do you see any issue with what I'm doing here?local_route {#xlog("L_INFO","* IN LOCAL ROUTE \n");if (is_method("INVITE")) {if($var(pai_userpart)) {

Re: [OpenSIPS-Users] B2BUA Ripping/Truncating Callid

2011-12-07 Thread Ovidiu Sas
Add a log and print out what are you adding before adding it and you will see if it's good or not. On Wed, Dec 7, 2011 at 5:13 PM, Logan voipmas...@me.com wrote: This is the extent of my local route. If the $var is not present, I do not add it. Do you see any issue with what I'm doing here?

[OpenSIPS-Users] SNMP oid for OpenSIPs

2011-12-07 Thread Leon Li
Hi, Is there a list of name-to-number list for SNMP oid for OpenSIPs? Regards Leon ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] handle_command: delete request failed

2011-12-07 Thread Nick
Hi When Ip phone 1 call to ip phone 2. It's worked. But When Ip phone 2 interrupt the call. Ip phone 1 can't interrupt the call. This is my message. Dec 8 14:32:51 sfs-staging rtpproxy[19226]: INFO:handle_delete: forcefully deleting session 1 on ports 36050/36858 Dec 8 14:32:51