[OpenSIPS-Users] [load_balancer] lb_disable() cannot be used in onreply route block
Hell All: I tried load_balancer module, when received 408 in onreply route block, I cannot use lb_disable to mark this unavailble destination. Let lb_disable can be used in onreply route block, is this idea correct? Thanks! Best regards! -- View this message in context: http://n2.nabble.com/load-balancer-lb-disable-cannot-be-used-in-onreply-route-block-tp4795694p4795694.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] 302 redirect question
Brett,
I can't answer how it's *supposed* to work, but I can explain how I've made it
work.
if (t_check_status("302")) {
if(!get_redirects("*")) {
route(20); # No redirects, junk the call (send an
error to the caller, other than 302)
exit;
}
# Brett, these two may be your key
serialize_branches(1);
next_branches();
setbflag(3);# 302 in progress
t_on_failure("4"); # This failure_route
t_on_branch("1"); # Not sure why I need this, but it used
to fail without I think
resetflag(1);
route(23); # Send request (some wrappers around a t_relay,
nothing relevant to the 302)
}
if (isbflagset(3)) {
if (next_branches()) {
t_on_failure("4"); # This failure_route
resetflag(22);
route(23); # Send request
} else {
resetbflag(3); # The 302's over
setflag(22);# Make sure there's failure accounting
route(20); # Done trying, fail the call (send an
error to the caller, other than 302)
}
}
This is some older config of mine. I haven't revisited it because it works,
but I would imagine there are efficiency improvements to be had.
- Jeff
On Mar 24, 2010, at 10:41 PM, Brett Nemeroff wrote:
Hello All,
I have a question about 302 redirects.Maybe I'm just misunderstanding how it's
supposed to work..
I get the following redirect:
SIP/2.0 302 Moved temporarily.
Via:SIP/2.0/UDP 192.168.21.10;branch=z9hG4bK6cd5.ae1f6c43.0,SIP/2.0/UDP
10.10.10.11:5060;branch=z9hG4bK-a96e3-4baac9a7-8c685c67-5898d54b.
From:http://sip:+5125551...@10.10.10.11:5060/>>;tag=a9d5ed0-13c4-4baac9a7-8c685c67-19c2a61a.
To:http://sip:15205551...@192.168.21.10:5060/>>;tag=100063687-1269483944267.
Call-ID:cxc-410-65762490-a9d5ed0-13c4-4baac9a7-8c685c67-17d58...@10.10.10.11.
CSeq:1 INVITE.
Record-Route:.
Contact:;q=0.5,;q=0.25.
Content-Length:0.
And in my failure route I have:
if (t_check_status("302")) {
get_redirects("*");
t_relay();
exit;
}
Now when I watch a sip trace, right after the 302, an INVITE fires off to BOTH
192.168.50.10 and 192.168.30.10 at the exact same time. The q values are
different, shouldn't they be serial?
I'm not entirely sure how much "magic" is handled in the q-value and how much
needs to be scripted.. But I was under the impression that this magic was
"fully automatic"
Thanks!
-Brett
___
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] 302 redirect question
Hello All,
I have a question about 302 redirects.Maybe I'm just misunderstanding how
it's supposed to work..
I get the following redirect:
SIP/2.0 302 Moved temporarily.
Via:SIP/2.0/UDP 192.168.21.10;branch=z9hG4bK6cd5.ae1f6c43.0,SIP/2.0/UDP
10.10.10.11:5060;branch=z9hG4bK-a96e3-4baac9a7-8c685c67-5898d54b.
From:;tag=a9d5ed0-13c4-4baac9a7-8c685c67-19c2a61a.
To:;tag=100063687-1269483944267.
Call-ID:cxc-410-65762490-a9d5ed0-13c4-4baac9a7-8c685c67-17d58...@10.10.10.11
.
CSeq:1 INVITE.
Record-Route:.
Contact:;q=0.5,;q=0.25.
Content-Length:0.
And in my failure route I have:
if (t_check_status("302")) {
get_redirects("*");
t_relay();
exit;
}
Now when I watch a sip trace, right after the 302, an INVITE fires off to
BOTH 192.168.50.10 and 192.168.30.10 at the exact same time. The q values
are different, shouldn't they be serial?
I'm not entirely sure how much "magic" is handled in the q-value and how
much needs to be scripted.. But I was under the impression that this magic
was "fully automatic"
Thanks!
-Brett
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSIPs-CP CDRviewer question
Christian,
To make this work, there are a number of changes you need to make. This is
what I did:
1. ACC module params:
modparam("acc", "db_extra", "from_did=$avp(s:from_did);
to_did=$avp(s:to_did)")
of course, you'll need to set from_did and to_did in your script
2. Update stored procedure:
CREATE PROCEDURE opensips_cdrs_1_6()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE bye_record INT DEFAULT 0;
DECLARE v_callid,v_from_tag, v_to_tag,v_from_did,v_to_did VARCHAR(64);
DECLARE v_inv_time, v_bye_time DATETIME;
DECLARE inv_cursor CURSOR FOR SELECT time, callid, from_tag,
to_tag,from_did,to_did FROM acc where method='INVITE' and cdr_id='0';
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN inv_cursor;
REPEAT
FETCH inv_cursor INTO v_inv_time, v_callid, v_from_tag, v_to_tag,
v_from_did, v_to_did;
IF NOT done THEN
SET bye_record = 0;
SELECT 1, time INTO bye_record, v_bye_time FROM acc WHERE method='BYE'
AND callid=v_callid AND ((from_tag=v_from_tag AND to_tag=v_to_tag) OR
(from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER BY time ASC LIMIT 1;
IF bye_record = 1 THEN
INSERT INTO cdrs
(from_did,to_did,call_start_time,duration,sip_call_id,sip_from_tag,sip_to_tag,created)
VALUES
(v_from_did,v_to_did,v_inv_time,UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time),v_callid,v_from_tag,v_to_tag,NOW());
UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND (
(from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag AND
to_tag=v_from_tag));
END IF;
SET done = 0;
END IF;
UNTIL done END REPEAT;
END
//
DELIMITER ;
~
(notice we pull from_did/to_did from acc table)
3. Add from_did/to_did fields to acc table
4. Add from_did/to_did fields to cdrs tables
5. Update cdrviewer configuration
// what fields to show
$show_field[0]['from_did'] = "Caller" ;
$show_field[1]['to_did'] = "Callee" ;
$show_field[2]['call_start_time'] = "Call Start Time";
$show_field[3]['duration'] = "Duration";
$show_field[4]['leg_type'] = "Leg Type";
I don't really know what Leg Type is. I'd probably stuff something in there
like inbound/outbound/interstate/local/LD/TF/etc/etc/etc.
-Brett
Now a cavet here.. I just got this working.. however I'm getting multiple
CDR records for each call.. for example, for one call I'll see 2 x 6 second
calls and 1x36 second call. So I'm not entirely sure how that is happening
yet.. I think it's because I'm logging ACKs and early media. (pretty sure
actually).
On the other hand... Despite all the criticism out there regarding the
generation of CDR from a proxy, I'd really like to see this done at the
dialog level. After all, if you are going to piece together ACC recs to form
a dialog based CDR, this really should be done in the dialog module. Rather
than trying to replicate this kind of logic in a stored proc (blah!).
On Wed, Mar 24, 2010 at 3:49 PM, Christian Vo wrote:
>
>
> Thx Bogdan,
>
>
> Seems to be correct though:
>
> // what fields to show
> $show_field[0]['caller_id'] = "Caller" ;
> $show_field[1]['callee_id'] = "Callee" ;
> $show_field[2]['call_start_time'] = "Call Start Time";
> $show_field[3]['duration'] = "Duration";
> $show_field[4]['leg_type'] = "Leg Type";
>
>
>
> I don't know what "leg_type" corresponds to, (no entry in the acc table
> afaik), but I do see caller_id and callee_id...
> but the CDRviewer is showing my call entry with these fields blanked out...
>
>
>
> -Original Message-
> From: users-boun...@lists.opensips.org [mailto:
> users-boun...@lists.opensips.org] On Behalf Of Bogdan-Andrei Iancu
> Sent: Wednesday, March 24, 2010 12:24 PM
> To: OpenSIPS users mailling list
> Subject: Re: [OpenSIPS-Users] OpenSIPs-CP CDRviewer question
>
> Hi Christian,
>
> you need to go into opensips-cp > trunk > config > tools > system >
> cdrviewer > local.inc.php file and configure the $show_field array to
> show you whatever columns you need. Probably by mistake, it is
> configured to show some columns that does not exists.
>
> Regards,
> Bogdan
>
>
> Christian Vo wrote:
> > Hello,
> > So I realized I didn't have accounting to database enabled properly,
> > And added the following lines to my opensips.cfg:
> > modparam("acc", "db_url", "mysql://:@localhost/opensips")
> > modparam("acc", "db_extra", "caller_id=$fu; callee_id=$tu")
> > now I see there is an entry into the "acc" table:
> > mysql> select * from acc;
> >
> +++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
> > | id | method | from_tag | to_tag | callid | sip_code | sip_reason |
> > time | cdr_id | src_uri | dst_uri | caller_id | caller_domain | rpid |
> > src_ip | src_port | sip_proxy_ip | user_agent | accountcode | amaflags
> > | ca
Re: [OpenSIPS-Users] OpenSIPs-CP CDRviewer question
Thx Bogdan,
Seems to be correct though:
// what fields to show
$show_field[0]['caller_id'] = "Caller" ;
$show_field[1]['callee_id'] = "Callee" ;
$show_field[2]['call_start_time'] = "Call Start Time";
$show_field[3]['duration'] = "Duration";
$show_field[4]['leg_type'] = "Leg Type";
I don't know what "leg_type" corresponds to, (no entry in the acc table
afaik), but I do see caller_id and callee_id...
but the CDRviewer is showing my call entry with these fields blanked out...
-Original Message-
From: users-boun...@lists.opensips.org
[mailto:users-boun...@lists.opensips.org] On Behalf Of Bogdan-Andrei Iancu
Sent: Wednesday, March 24, 2010 12:24 PM
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] OpenSIPs-CP CDRviewer question
Hi Christian,
you need to go into opensips-cp > trunk > config > tools > system >
cdrviewer > local.inc.php file and configure the $show_field array to
show you whatever columns you need. Probably by mistake, it is
configured to show some columns that does not exists.
Regards,
Bogdan
Christian Vo wrote:
> Hello,
> So I realized I didn't have accounting to database enabled properly,
> And added the following lines to my opensips.cfg:
> modparam("acc", "db_url", "mysql://:@localhost/opensips")
> modparam("acc", "db_extra", "caller_id=$fu; callee_id=$tu")
> now I see there is an entry into the "acc" table:
> mysql> select * from acc;
> +++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
> | id | method | from_tag | to_tag | callid | sip_code | sip_reason |
> time | cdr_id | src_uri | dst_uri | caller_id | caller_domain | rpid |
> src_ip | src_port | sip_proxy_ip | user_agent | accountcode | amaflags
> | callee_id | callee_domain | contact |
> +++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
> | 1 | INVITE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
> 11:20:03 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | |
> sip:1...@10.32.0.97 | | NULL |
> | 2 | ACK | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
> 11:20:03 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | |
> sip:1...@10.32.0.97 | | NULL |
> | 3 | BYE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
> 11:20:26 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | |
> sip:1...@10.32.0.97 | | NULL |
> +++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
> However, when I view from CDRViewer, the
> Caller, Callee , and Leg Type fields for this entry are blank.
> Is this expected behavior?
>
> This email message is for the sole use of the intended recipient(s)
> and may contain confidential information. Any unauthorized review,
> use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and
> destroy all copies of the original message.
>
>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
--
Bogdan-Andrei Iancu
www.voice-system.ro
___
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] OpenSIPs-CP CDRviewer question
Hi Christian,
you need to go into opensips-cp > trunk > config > tools > system >
cdrviewer > local.inc.php file and configure the $show_field array to
show you whatever columns you need. Probably by mistake, it is
configured to show some columns that does not exists.
Regards,
Bogdan
Christian Vo wrote:
> Hello,
> So I realized I didn’t have accounting to database enabled properly,
> And added the following lines to my opensips.cfg:
> modparam("acc", "db_url", "mysql://:@localhost/opensips")
> modparam("acc", "db_extra", "caller_id=$fu; callee_id=$tu")
> now I see there is an entry into the “acc” table:
> mysql> select * from acc;
> +++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
> | id | method | from_tag | to_tag | callid | sip_code | sip_reason |
> time | cdr_id | src_uri | dst_uri | caller_id | caller_domain | rpid |
> src_ip | src_port | sip_proxy_ip | user_agent | accountcode | amaflags
> | callee_id | callee_domain | contact |
> +++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
> | 1 | INVITE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
> 11:20:03 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | |
> sip:1...@10.32.0.97 | | NULL |
> | 2 | ACK | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
> 11:20:03 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | |
> sip:1...@10.32.0.97 | | NULL |
> | 3 | BYE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
> 11:20:26 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | |
> sip:1...@10.32.0.97 | | NULL |
> +++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
> However, when I view from CDRViewer, the
> Caller, Callee , and Leg Type fields for this entry are blank.
> Is this expected behavior?
>
> This email message is for the sole use of the intended recipient(s)
> and may contain confidential information. Any unauthorized review,
> use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and
> destroy all copies of the original message.
>
>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
--
Bogdan-Andrei Iancu
www.voice-system.ro
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] OpenSIPs-CP CDRviewer question
Hello,
So I realized I didn't have accounting to database enabled properly,
And added the following lines to my opensips.cfg:
modparam("acc", "db_url", "mysql://:@localhost/opensips")
modparam("acc", "db_extra", "caller_id=$fu; callee_id=$tu")
now I see there is an entry into the "acc" table:
mysql> select * from acc;
+++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
| id | method | from_tag | to_tag | callid
| sip_code | sip_reason | time| cdr_id |
src_uri | dst_uri | caller_id | caller_domain | rpid | src_ip |
src_port | sip_proxy_ip | user_agent | accountcode | amaflags | callee_id
| callee_domain | contact |
+++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
| 1 | INVITE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
11:20:03 | 0 | | | sip:1...@10.32.0.97 | |
|| | || | |
sip:1...@10.32.0.97 | | NULL|
| 2 | ACK| 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
11:20:03 | 0 | | | sip:1...@10.32.0.97 | |
|| | || | |
sip:1...@10.32.0.97 | | NULL|
| 3 | BYE| 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 |
E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24
11:20:26 | 0 | | | sip:1...@10.32.0.97 | |
|| | || | |
sip:1...@10.32.0.97 | | NULL|
+++--+--+--+--++-++-+-+-+---+--++--+--++-+--+-+---+-+
However, when I view from CDRViewer, the
Caller, Callee , and Leg Type fields for this entry are blank.
Is this expected behavior?
---
This email message is for the sole use of the intended recipient(s) and may
contain
confidential information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact the
sender by
reply email and destroy all copies of the original message.
---
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] opensips updates
Hi Erik, This is good one: deb http://www.opensips.org/apt/ lenny main or deb http://www.opensips.org/apt/ etch main Regards, Bogdan Erick Chinchilla Berrocal wrote: > > FYI > > Before, I read about the link to update the opensips ,add the > information in the file > > /etc/apt/sources.list > > If can send me the correct link. > > I remember about this o similar. > > deb http://opensips.org/ lenny/updates main > > > > Thanks > > Erick Ch. > > > > > > __ Information from ESET NOD32 Antivirus, version of virus > signature database 3997 (20090409) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] opensips updates
FYI Before, I read about the link to update the opensips ,add the information in the file /etc/apt/sources.list If can send me the correct link. I remember about this o similar. deb http://opensips.org/ lenny/updates main Thanks Erick Ch. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSISP 1.6.2 / Control Panel 1.4 - Installation problems
I've just installed the latest version of opensips-cp
Here's what I found:
1) Monit link error:
[Wed Mar 24 10:41:53 2010] [error] [client 10.31.53.156] PHP Fatal error:
require_once(): Failed opening required
'../../../../config/tools/monit/local.inc.php'
(include_path='.:/usr/share/php5:/usr/share/php5/PEAR') in
/srv/www/htdocs/opensips-cp/web/tools/system/monit/monit_proxyfy.php on line
26, referer: http://10.32.0.97/cp/tools/system/monit/monit.php
I noticed that path is set wrong in this script
"opensips-cp/web/tools/system/monit/monit_proxyfy.php"
Was missing the"system/" subdirectory
>> require_once("../../../../config/tools/system/monit/local.inc.php");
2) Not seeing any entries in either the "acc" nor "sip_trace" database
tables... so I'm not sure what I've missed in my basic opensips config so that
either cdrviewer or sip_trace would work...
From: users-boun...@lists.opensips.org
[mailto:users-boun...@lists.opensips.org] On Behalf Of Erick Chinchilla Berrocal
Sent: Wednesday, March 24, 2010 10:42 AM
To: 'OpenSIPS users mailling list'
Subject: Re: [OpenSIPS-Users] OpenSISP 1.6.2 / Control Panel 1.4 - Installation
problems
Alex
I will installing the OpenSIPS Control Panel 4.0 (date 03-24-2010)
Can you explain me with more detail the procedure for SMONITOR and CDR modules
With this version don't need run the patch (opensips-cp_4.0.patch)
Thanks
Erick Ch.
From: users-boun...@lists.opensips.org
[mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu
Sent: Wednesday, March 24, 2010 5:35 AM
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] OpenSISP 1.6.2 / Control Panel 1.4 - Installation
problems
Hi,
There has been made a fix for the "add user" issue. There were some
non-existent fields in the insert query.
Please download latest version and it should work.
For the Smonitor :
- you must add in the crontab the php script get_opensips_stats.php (you'll
find it in the folder CRON_JOB).
- also, do not forget to edit the paths in the script above (you'll see that
there is a path to the smonitor module that you have to change);
- for the CDR module - there is also a script for that (can also be found in
CRON_JOB - and this script calls a stored procedure) - if you carefully read
the INSTALL file you'll find explanations there.
Regards,
Alex
On 3/23/2010 23:44, Christian Vo wrote:
doesn't generate any info
--
Alex Ionescu
www.voice-system.ro
__ Information from ESET NOD32 Antivirus, version of virus signature
database 3997 (20090409) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__ Information from ESET NOD32 Antivirus, version of virus signature
database 3997 (20090409) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
---
This email message is for the sole use of the intended recipient(s) and may
contain
confidential information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact the
sender by
reply email and destroy all copies of the original message.
---
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSISP 1.6.2 / Control Panel 1.4 - Installation problems
Alex I will installing the OpenSIPS Control Panel 4.0 (date 03-24-2010) Can you explain me with more detail the procedure for SMONITOR and CDR modules With this version don't need run the patch (opensips-cp_4.0.patch) Thanks Erick Ch. From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu Sent: Wednesday, March 24, 2010 5:35 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] OpenSISP 1.6.2 / Control Panel 1.4 - Installation problems Hi, There has been made a fix for the "add user" issue. There were some non-existent fields in the insert query. Please download latest version and it should work. For the Smonitor : - you must add in the crontab the php script get_opensips_stats.php (you'll find it in the folder CRON_JOB). - also, do not forget to edit the paths in the script above (you'll see that there is a path to the smonitor module that you have to change); - for the CDR module - there is also a script for that (can also be found in CRON_JOB - and this script calls a stored procedure) - if you carefully read the INSTALL file you'll find explanations there. Regards, Alex On 3/23/2010 23:44, Christian Vo wrote: doesn't generate any info -- Alex Ionescu www.voice-system.ro __ Information from ESET NOD32 Antivirus, version of virus signature database 3997 (20090409) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Add db_mysql module
Yes.. Any dependencies or changes will automatically be taken care of with a new make / make modules. Give it a shot. let us know if you have any trouble. -Brett On Wed, Mar 24, 2010 at 10:40 AM, brianpocock < briankeithja...@googlemail.com> wrote: > > Thanks, So can i just do a make install again with it uncommened without > removing the old files first, i.e. will it overwrite them? > > Thanks > -- > View this message in context: > http://n2.nabble.com/Add-db-mysql-module-tp4791554p4791808.html > Sent from the OpenSIPS - Users mailing list archive at Nabble.com. > > ___ > 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] Add db_mysql module
Thanks, So can i just do a make install again with it uncommened without removing the old files first, i.e. will it overwrite them? Thanks -- View this message in context: http://n2.nabble.com/Add-db-mysql-module-tp4791554p4791808.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Based on this thread (http://www.pear-forum.org/topic1244.html)
, I added the following to user_management.php
$resultset = $link->prepare($sql);
##added this
if (PEAR::isError($resultset)) {
die($resultset->getMessage() . ', ' .
$resultset->getDebugInfo());
}
##
$resultset->execute();
The error I got after trying to add user was this:
MDB2 Error: no such field, _doQuery: [Error message: Could not execute
statement] [Last executed query: PREPARE
MDB2_STATEMENT_mysql_81a2b39d1bc2abeacb0359a975958e93 FROM 'INSERT INTO
subscriber (last_name, first_name,
username,domain,password,email_address,ha1,ha1b,datetime_created) VALUES
(\'\',\'\',\'1002\',\'10.32.0.97\',\'1002\',\'c...@nvidia.com\',\'\',\'\',
NOW())'] [Native code: 1054] [Native message: Unknown column 'last_name' in
'field list']
mysql> describe subscriber;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | NO | PRI | NULL| auto_increment |
| username | char(64) | NO | MUL | ||
| domain| char(64) | NO | | ||
| password | char(25) | NO | | ||
| email_address | char(64) | NO | | ||
| ha1 | char(64) | NO | | ||
| ha1b | char(64) | NO | | ||
| rpid | char(64) | YES | | NULL||
+---+--+--+-+-++
8 rows in set (0.00 sec)
Not sure where last_name & first_name come in here...??
From: users-boun...@lists.opensips.org
[mailto:users-boun...@lists.opensips.org] On Behalf Of TCB
Sent: Sunday, March 21, 2010 9:03 AM
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Tried running ocp and i'm getting this error on adding users.
Failed to issue query, error message : MDB2 Error: no such field
I'm not getting any useful error to start tracing.
TC.
On Sat, Mar 20, 2010 at 12:10 AM, Christian Vo
mailto:c...@nvidia.com>> wrote:
Thanks Anca,
I think that's fixed the problem with smonitor,
I still can't add users though,
Fatal error: Call to undefined method MDB2_Error::execute() in
/srv/www/htdocs/opensips-cp/web/tools/users/user_management/user_management.php
on line 223,...
-Original Message-
From: Anca Vamanu [mailto:a...@opensips.org]
Sent: Friday, March 19, 2010 2:41 PM
To: OpenSIPS users mailling list
Cc: Christian Vo
Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Forward from Alex:
---
Hi Christian,
Please check the following :
In the OpenSIPS config :
- if you have loaded the mi_fifo module;
loadmodule "mi_fifo.so"
- if you have declared the correct fifo parameters (if the fifo file
name is the same as in Control Panel boxes config and if it has right
permissions set);
- if I'm not wrong it should be something like this :
modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")
modparam("mi_fifo", "fifo_mode", 0666)
Leave the db.inc.php commented as it was before and please check the
stuff above and let me know.
Regards,
Alex
---
Christian Vo wrote:
>
> Forgot to add:
>
> I had smonitor's db.inc.php settings uncommented,
>
> Now getting this error instead
>
> [Fri Mar 19 09:59:50 2010] [error] [client 172.18.53.97] PHP Fatal
> error: Call to undefined method MDB2_Error::setFetchMode() in
> /srv/www/htdocs/opensips-cp/web/tools/system/smonitor/lib/db_connect.php
> on line 39, referer: http://10.32.0.97/cp/menu.php
>
> I'm very sure I installed pear and the related parts as per the
> install guide..
>
> *From:* Christian Vo
> *Sent:* Friday, March 19, 2010 9:57 AM
> *To:* OpenSIPS users mailling list
> *Subject:* RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
>
> Thx Alex,
>
> Confirming that these are my settings:
>
> // each server is a box
>
> $box_id=0;
>
> // mi host:port pair || fifo_file
>
> // $boxes[$box_id]['mi']['conn']="127.0.0.1:8080";
>
> $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";
>
> // monit host:port
>
> $boxes[$box_id]['monit']['conn']="127.0.0.1:2812";
>
> $boxes[$box_id]['monit']['user']="admin";
>
> $boxes[$box_id]['monit']['pass']="monit";
>
> $boxes[$box_id]['monit']['has_ssl']=0;
>
> // description (appears in mi , monit )
>
> $boxes[$box_id]['desc']="SIP server";
>
> At this point, Monit seems to be working, but Statistics Monitor
> complains
>
> "Cannot connect to OpenSIPS Server via Management Interface
> (127.0.0.1/8080)
>
> "
>
> *From:*
> users-boun...@lists.opensi
Re: [OpenSIPS-Users] Error message on opensips-cp 4.0
Hi Alex, Yes, I have installed php-pear and MDB2 drivers. I've checked twice, the dependencies, the configuration of php.ini and database connection parameters. I'm using debian 5.0.1 and mysql 5.0.51-24. Seems to be something in the prepared statements. Database connections are ok, because I have created domains without any problem. Best regards, Flavio E. Goncalves 2010/3/19 Alex Ionescu : > Hi Flavio, > > I've checked again but on our test platform appears to work fine and > this is the first time somebody reports a bug related to User > Managemet/Add New. > > Can you please check that you have installed php-pear and MDB2 and > MDB2_Driver_mysql ? > Let me know if this solved your problem. > > Regards, > Alex > > On 3/19/2010 00:39, Flavio Goncalves wrote: >> Fatal error: Call to undefined method MDB2_Error::execute() > > > -- > Alex Ionescu > www.voice-system.ro > > > ___ > 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] can OpenSIPS-cp and SerMyAdmin co-exist?
Hi David, In the last version opensips-cp 3.0 it worked, I have this setup in my machine. In the new one (4.0) I didn´t test. Regards, Flavio E. Goncalves 2010/3/22 David J. : > Just curious, Whats the sense of this? > > Christian Vo wrote: >> Trying to manually install SerMyAdmin (step by step , since install >> script uses apt-get) on my OpenSUSE 11 setup.. >> Which already has OpenSIPs-CP installed… >> I’m noticing that the sql script has several conflicts… anyone try >> this before? >> >> This email message is for the sole use of the intended recipient(s) >> and may contain confidential information. Any unauthorized review, >> use, disclosure or distribution is prohibited. If you are not the >> intended recipient, please contact the sender by reply email and >> destroy all copies of the original message. >> >> >> >> ___ >> 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] Error on opensips-cp 4.0
Hi, I got the following error when trying to insert a new user. Fatal error: Call to undefined method MDB2_Error::execute() in /var/www/opensips-cp/web/tools/users/user_management/user_management.php on line 223 Any help would be welcome. Thanks, Flavio E. Goncalves ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] keepalived for HA OpenSIPS
Gavin, OpenSIPS works as well as any other service managed by HA (heartbeat). A typical /etc/ha.d/ha.cnf file may look like this: logfile /var/log/ha-log logfacility local0 keepalive 2 warntime 4 deadtime 8 initdead 120 bcast eth0 udpport 694 auto_failback on node opensips-1 node opensips-2 Mario Stocco http://advantia.ca On 14-Mar-10, at 3:00 PM, Gavin Henry wrote: > Hi, > > When using OpenSIPS and the load balancer module your SPOF is still > OpenSIPS. Have others had success with keepalived looking after two > OpenSIPS servers? > > We have OpenSIPS in front of a cluster of Asterisk boxes for a > customer and the same setup in a different data center. We'd like to > put a keepalived in front of both OpenSIPS servers, i.e. in front of > both datacentres. But then that leaves a SPOF with the keepalived > server. We could have backup server of that two (both data centers > have real time replication between them also). > > What are the best practices you recommend here? > > Thanks, > > Gavin. > > -- > http://www.suretecsystems.com/services/openldap/ > http://www.suretectelecom.com > > ___ > 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] need help -- opensips cp --> sip trace setup giving errors
Hello, Just installed opensips control panel and some things are not working: I noticed that selecting the SIP trace feature was initially giving me error: "Array ( [0] => sorry -- cannot open write fifo )" So I then uncommented the sections in opensips-cp/config/tools/system/siptrace/db.inc.php , providing proper db login credentials... Trying to access the SIP trace feature then gave me blank main screen, Apache error log message: [Wed Mar 17 14:06:30 2010] [error] [client 10.31.53.162] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /srv/www/htdocs/opensips-cp/web/tools/system/siptrace/lib/db_connect.php on line 39, referer: http://10.32.0.97/cp/menu.php Does anyone know what needs to be fixed? Thx --- This email message is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Add db_mysql module
Hi Brian, when you installed opensips, was the db_mysql module enabled ? without the presence of db_mysql module, the installer will not copy that script . So, be sure you remove the 'db_mysql" module from the "exclude_modules" list in Makefile and do a re-install. Regards, Bogdan brianpocock wrote: > Hi, basically I just install OpenSIPS with the OSP module, spent lots of time > making sure it would install correctly, it all installed fine and it starts > fine with opensipsctl start but when I came to create the database with > opensipsdbctl create I get the error: > ERROR: could not load the script in > /usr/local/lib/opensips/opensipsctl/opensipsdbctl.mysql for database engine > MYSQL > ERROR: database engine not loaded - tried 'MYSQL' > > Turns out I forgot to install the db_mysql module as when I got to > /usr/local/lib/opensips/modules/ the module is not there. Is there anyway I > can add the module now or do I have to reinstall it all again? > > Thanks > -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Add db_mysql module
You need to uncomment db_mysql from the Makefile and re-compile. Assuming that's how you installed. -Brett On Wed, Mar 24, 2010 at 10:08 AM, brianpocock < briankeithja...@googlemail.com> wrote: > > Hi, basically I just install OpenSIPS with the OSP module, spent lots of > time > making sure it would install correctly, it all installed fine and it starts > fine with opensipsctl start but when I came to create the database with > opensipsdbctl create I get the error: > ERROR: could not load the script in > /usr/local/lib/opensips/opensipsctl/opensipsdbctl.mysql for database engine > MYSQL > ERROR: database engine not loaded - tried 'MYSQL' > > Turns out I forgot to install the db_mysql module as when I got to > /usr/local/lib/opensips/modules/ the module is not there. Is there anyway I > can add the module now or do I have to reinstall it all again? > > Thanks > -- > View this message in context: > http://n2.nabble.com/Add-db-mysql-module-tp4791554p4791554.html > Sent from the OpenSIPS - Users mailing list archive at Nabble.com. > > ___ > 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] Add db_mysql module
Hi, basically I just install OpenSIPS with the OSP module, spent lots of time making sure it would install correctly, it all installed fine and it starts fine with opensipsctl start but when I came to create the database with opensipsdbctl create I get the error: ERROR: could not load the script in /usr/local/lib/opensips/opensipsctl/opensipsdbctl.mysql for database engine MYSQL ERROR: database engine not loaded - tried 'MYSQL' Turns out I forgot to install the db_mysql module as when I got to /usr/local/lib/opensips/modules/ the module is not there. Is there anyway I can add the module now or do I have to reinstall it all again? Thanks -- View this message in context: http://n2.nabble.com/Add-db-mysql-module-tp4791554p4791554.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] how to modify a Via header?
Hi, if you want to do ipv4 -> ipv6 you do not need to change the previous VIA headers. That is illegal. Also OpenSIPS will correctly generate its own VIA, so there is no need to make changes by yourself to the VIA headers. you just need to forward to an ipv6 address Regards, Bogdan CheeWii wrote: > Hi! > Now I use opensips as a v4-v6 gateway.so I want to change every ipv4 > address in VIA header to ipv6 address. How can I accomplish this? > For example： > Via: SIP/2.0/UDP 192.25.132.227:5069;branch=z9hG4bKdf6e.49b8c2c2.0 > -> > Via: SIP/2.0/UDP > [2002:da8:214:1115:b0cc:8604:1fc9:6448]:5069;branch=z9hG4bKdf6e.49b8c2c2.0 > Thanks a lot！ > > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSISP 1.6.2 / Control Panel 1.4 - Installation problems
Hi, There has been made a fix for the "add user" issue. There were some non-existent fields in the insert query. Please download latest version and it should work. For the Smonitor : - you must add in the crontab the php script get_opensips_stats.php (you'll find it in the folder CRON_JOB). - also, do not forget to edit the paths in the script above (you'll see that there is a path to the smonitor module that you have to change); - for the CDR module - there is also a script for that (can also be found in CRON_JOB - and this script calls a stored procedure) - if you carefully read the INSTALL file you'll find explanations there. Regards, Alex On 3/23/2010 23:44, Christian Vo wrote: doesn't generate any info -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSIPS & OpenXCAP
Hello Saul,
> Are you sending any request directly to the presence server? Or do you
> mean authorization policy?
The request is being sent to the core OpenSIPS (which also works as a Registrar
and SIP proxy). The core OpenSIPS performs digest authentication on the message
correctly, and then forwards it to the presense OpenSIPS.
Initially I tried to have the presence OpenSIPS in a separate IP address. Say
10.1.1.2:5060, while the core OpenSIPS was at 10.1.1.1:5060.
I have in the core OpenSIPS something like:
if( is_method("PUBLISH|SUBSCRIBE|NOTIFY") ) {
rewritehostport("10.1.1.2:5060");
t_relay();
exit;
}
While running as such, I noticed on the Presence OpenSIPS messages mentioning
that realm 10.1.1.2 is not local, and the status of the UAs was not propagated.
When I changed the IP address of the presence OpenSIPS to 10.1.1.1:5061
everything worked properly. Maybe it has something to do with the domains
allowed? (I tried adding the domain 10.1.1.2 on the domains table, but I think
that made things worse) I am kind of new at this, so forgive me if I am
completely off :)
Regards,
Paris Statopoulos
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
