Re: [OpenSIPS-Users] Changing Address of Opensips Server
I have 0 in as the port, I've also tried putting 5060 to see if that makes a difference. -David From: Bogdan-Andrei Iancu [mailto:bog...@opensips.org] Sent: Friday, February 27, 2015 2:20 PM To: OpenSIPS users mailling list; David Crow Subject: Re: [OpenSIPS-Users] Changing Address of Opensips Server Hi David, Are you sure it is not a port issue ? maybe the src port does not match the port your have in the address table. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 26.02.2015 15:38, David Crow wrote: I've done some more troubleshooting on this and it doesn't appear to have anything to do with the NAT. The issue seems to be related to one host sending calls to Opensips. From all other hosts it works fine, but this one host doesn't work at all. I've double checked the ip address, port, etc. I"ve also tried removing the address from the table and adding it back, still nothing. Very strange. -David From: users-boun...@lists.opensips.org<mailto:users-boun...@lists.opensips.org> [mailto:users-boun...@lists.opensips.org] On Behalf Of David Crow Sent: Tuesday, February 24, 2015 5:10 PM To: 'users@lists.opensips.org<mailto:users@lists.opensips.org>' Subject: [OpenSIPS-Users] Changing Address of Opensips Server I'm moving our one of our opensips server to a new datacenter with new ip addresses and I'm running into an issue. It seems to be failing to find the group properly based on the 503 message I'm getting back. $avp(s:group) = get_source_group(); # Reject if no group found for this call if ($avp(s:group) == -1) { sl_send_reply("503","Service Unavailable - NOPERM"); exit; } This server is behind a firewall doing NAT and I've changed all references in the opensips.cfg to the new external address. Opensipsctl address dump shows the address table and the server that's sending the calls from properly. I'm not really sure where to look next, I'm pretty green when it comes to opensips. I only have to tinker with it when I change something like this. Any assistance would be greatly appreciated. David Crow | Senior Systems Architect 1301 Gervais Street, Suite 1800 | Columbia, SC 29201 (d) 803.978.2727 | (f) 803.733.5888 david.c...@vc3.com<mailto:david.c...@vc3.com>| www.VC3.com<http://www.vc3.com/> Follow us: [Description: Description: Description: Description: Description: cid:image002.png@01CC30E6.8E093080] <http://www.facebook.com/VC3Inc> [Description: Description: Description: Description: Description: cid:image004.png@01CC30E6.8E093080] <http://twitter.com/#%21/VC3Inc> [cid:image003.jpg@01CE41C2.E8635D50] [cid:image004.png@01D054CD.C48A6F20] ___ Users mailing list Users@lists.opensips.org<mailto: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] Changing Address of Opensips Server
I've done some more troubleshooting on this and it doesn't appear to have anything to do with the NAT. The issue seems to be related to one host sending calls to Opensips. From all other hosts it works fine, but this one host doesn't work at all. I've double checked the ip address, port, etc. I"ve also tried removing the address from the table and adding it back, still nothing. Very strange. -David From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of David Crow Sent: Tuesday, February 24, 2015 5:10 PM To: 'users@lists.opensips.org' Subject: [OpenSIPS-Users] Changing Address of Opensips Server I'm moving our one of our opensips server to a new datacenter with new ip addresses and I'm running into an issue. It seems to be failing to find the group properly based on the 503 message I'm getting back. $avp(s:group) = get_source_group(); # Reject if no group found for this call if ($avp(s:group) == -1) { sl_send_reply("503","Service Unavailable - NOPERM"); exit; } This server is behind a firewall doing NAT and I've changed all references in the opensips.cfg to the new external address. Opensipsctl address dump shows the address table and the server that's sending the calls from properly. I'm not really sure where to look next, I'm pretty green when it comes to opensips. I only have to tinker with it when I change something like this. Any assistance would be greatly appreciated. David Crow | Senior Systems Architect 1301 Gervais Street, Suite 1800 | Columbia, SC 29201 (d) 803.978.2727 | (f) 803.733.5888 david.c...@vc3.com<mailto:david.c...@vc3.com>| www.VC3.com<http://www.vc3.com/> Follow us: [Description: Description: Description: Description: Description: cid:image002.png@01CC30E6.8E093080] <http://www.facebook.com/VC3Inc> [Description: Description: Description: Description: Description: cid:image004.png@01CC30E6.8E093080] <http://twitter.com/#!/VC3Inc> [cid:image003.jpg@01CE41C2.E8635D50] [cid:image004.png@01D0519F.A4343840] ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Changing Address of Opensips Server
I'm moving our one of our opensips server to a new datacenter with new ip addresses and I'm running into an issue. It seems to be failing to find the group properly based on the 503 message I'm getting back. $avp(s:group) = get_source_group(); # Reject if no group found for this call if ($avp(s:group) == -1) { sl_send_reply("503","Service Unavailable - NOPERM"); exit; } This server is behind a firewall doing NAT and I've changed all references in the opensips.cfg to the new external address. Opensipsctl address dump shows the address table and the server that's sending the calls from properly. I'm not really sure where to look next, I'm pretty green when it comes to opensips. I only have to tinker with it when I change something like this. Any assistance would be greatly appreciated. David Crow | Senior Systems Architect 1301 Gervais Street, Suite 1800 | Columbia, SC 29201 (d) 803.978.2727 | (f) 803.733.5888 david.c...@vc3.com<mailto:david.c...@vc3.com>| www.VC3.com<http://www.vc3.com/> Follow us: [Description: Description: Description: Description: Description: cid:image002.png@01CC30E6.8E093080] <http://www.facebook.com/VC3Inc> [Description: Description: Description: Description: Description: cid:image004.png@01CC30E6.8E093080] <http://twitter.com/#!/VC3Inc> [cid:image003.jpg@01CE41C2.E8635D50] [cid:image004.png@01D05054.BCBB97B0] ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Truncating ACC and CDRs
Yes, that’s the plan long term. For now, though I’m just wondering if deleting everything in the acc table will cause problems. Or does anyone have any other suggestions on how to clean this up? -David From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Adrian Georgescu Sent: Friday, February 21, 2014 6:31 PM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Truncating ACC and CDRs Any operation that writes to your MySQL database for any great length of time like trimming your table will block anything else accesing the same database. You should auto rotate tables and use non transactional table storage to be able to trim older tables without impacting the active ones. -- Adrian On 21 Feb 2014, at 16:49, David Crow mailto:david.c...@vc3.com>> wrote: I’ve got an opensips proxy that I just use for PSTN routing, no billing or anything is done from this system. I only use the cdrs to identify when provider a call went to or from. Both the ACC and CDRs table have just been growing and I haven’t done anything with them and now the acc table has gotten to over 4.6 GB and it’s almost impossible to search through. I have stopped generating the CDRs for now. I would like to just purge these tables and start over but I wasn’t sure if I would break anything if I run a truncate on the acc table. Does anything read from the ACC table other than the CDR generation script? Would it be ok to run a TRUNCATE on this table? Thanks, David Crow | Senior Systems Architect 1301 Gervais Street, Suite 1800 | Columbia, SC 29201 (d) 803.978.2727 | (f) 803.733.5888 david.c...@vc3.com<mailto:david.c...@vc3.com>| www.VC3.com<http://www.vc3.com/> Follow us: <http://www.facebook.com/VC3Inc><http://twitter.com/#!/VC3Inc> ___ Users mailing list Users@lists.opensips.org<mailto: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] Truncating ACC and CDRs
I've got an opensips proxy that I just use for PSTN routing, no billing or anything is done from this system. I only use the cdrs to identify when provider a call went to or from. Both the ACC and CDRs table have just been growing and I haven't done anything with them and now the acc table has gotten to over 4.6 GB and it's almost impossible to search through. I have stopped generating the CDRs for now. I would like to just purge these tables and start over but I wasn't sure if I would break anything if I run a truncate on the acc table. Does anything read from the ACC table other than the CDR generation script? Would it be ok to run a TRUNCATE on this table? Thanks, David Crow | Senior Systems Architect 1301 Gervais Street, Suite 1800 | Columbia, SC 29201 (d) 803.978.2727 | (f) 803.733.5888 david.c...@vc3.com<mailto:david.c...@vc3.com>| www.VC3.com<http://www.vc3.com/> Follow us: [Description: Description: Description: Description: Description: cid:image002.png@01CC30E6.8E093080] <http://www.facebook.com/VC3Inc> [Description: Description: Description: Description: Description: cid:image004.png@01CC30E6.8E093080] <http://twitter.com/#!/VC3Inc> <><>___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] OpenSIPs Database Maintenance
I've got an opensips system that we've been running for about 3 years now. Recently I've noticed that the load average on the system has been creeping up slowly over time. I've narrowed this down to the cdr generation script in the opensips-cp, which seems to be taking longer and longer to finish. I was looking at the mysql database and it looks like both the acc and cdrs tables just continue to grow. I know that I can remove stuff from the CDR table, but I'm not really sure about the ACC table. Does anyone have scripts that regularly purge old stuff from these databases? Also what do I do now with them as large as they are? Thanks, David Crow | Senior Systems Architect 1301 Gervais Street, Suite 1800 | Columbia, SC 29201 (d) 803.978.2727 | (f) 803.733.5888 david.c...@vc3.com<mailto:david.c...@vc3.com>| www.VC3.com<http://www.vc3.com/> Follow us: [Description: Description: Description: Description: Description: cid:image002.png@01CC30E6.8E093080] <http://www.facebook.com/VC3Inc> [Description: Description: Description: Description: Description: cid:image004.png@01CC30E6.8E093080] <http://twitter.com/#!/VC3Inc> [cid:image003.jpg@01CE23C4.0EB5A2F0] [cid:image006.jpg@01CE23C4.72A6CFA0] <><><><>___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users