-- jh(a)tutpro.com wrote:
From: Juha Heinanen <jh(a)tutpro.com>
To: jason_hoss(a)quintum.com
Cc: <users(a)openser.org>
Subject: [Users] Debian Etch with MySQL module
Date: Mon, 3 Jul 2006 22:57:16 +0300
libmysqlclient14 is available in sarge. you could try to force
installation if you have with libmysqlclient15 installed.
-- juha
I have set up apt to pull from the ETCH repository by adding the following line to sources.list:
deb http://www.openser.org/debian etch main
This failure should not happen because the mysql installed is the base install for ETCH and the packages should work for ETCH. It seems that a recompile against this newer library should be done to make this package work for a fresh install of ETCH. Anyone have any suggestions on how to work around this? I would like to use force as a last resort.
Jason Hoss
Hi,
I World like to use SER with a point-to-multipoint sip softphone
application
This are my questions:
1- Is SER capable of handle that kind of signalling flow?
2- Is the RTP proxy able to fork RTP to more than one destination?
Thanks.
Hi SER users
I am trying to test SER+FreeRadius (for accounting) and
iam getting the follwing errors in log messages
ERROR MESSAGES:-(
localhost /usr/local/sbin/ser[3503]: Maxfwd module- initializing
localhost ser[3503]: ERROR: acc: can't get code for the
Sip-Translated-Request-URI attribute
localhost ser[3503]: init_mod(): Error while initializing module acc
even then i changed the Attribute i am getting the same error please help
regard this issue
my SER.cfg looks like this
loadmodule "/usr/local/lib/ser/modules/acc.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific parameters ---------------
# -- acc params --
# set the reporting log level
modparam("acc", "log_level", 1)
# number of flag, which will be used for accounting; if a message is
# labeled with this flag, its completion status will be reported
modparam("acc", "radius_flag", 1 )
modparam("acc", "radius_missed_flag", 2)
modparam("acc", "radius_config",
"/usr/local/etc/radiusclient-ng/radiusclient.conf")
modparam("acc", "service_type", 15)
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
# -- auth params --
# Uncomment if you are using auth module
#
modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this config),
# uncomment also the following parameter)
#
modparam("auth_db", "password_column", "password")
# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
# ------------------------- request routing logic -------------------
# main routing logic
route{
# initial sanity checks -- messages with
# max_forwards==0, or excessively long requests
if (!mf_process_maxfwd_header("10")) {
sl_send_reply("483","Too Many Hops");
break;
};
if (msg:len >= 2048 ) {
sl_send_reply("513", "Message too big");
break;
};
# we record-route all messages -- to make sure that
# subsequent messages will go through our proxy; that's
# particularly good if upstream and downstream entities
# use different transport protocol
if (!method=="REGISTER") record_route();
# subsequent messages withing a dialog should take the
# path determined by record-routing
if (loose_route()) {
# mark routing logic in request
append_hf("P-hint: rr-enforced\r\n");
route(1);
break;
};
if (!uri==myself) {
# mark routing logic in request
append_hf("P-hint: outbound\r\n");
route(1);
break;
};
# if the request is for other domain use UsrLoc
# (in case, it does not work, use the following command
# with proper names and addresses in it)
if (uri==myself) {
if (method=="REGISTER") {
# Uncomment this if you want to use digest authentication
if (!www_authorize("81.21.34.37", "subscriber")) {
www_challenge("81.21.34.37", "0");
break;
};
save("location");
break;
};
lookup("aliases");
if (!uri==myself) {
append_hf("P-hint: outbound alias\r\n");
route(1);
break;
};
# native SIP destinations are handled using our USRLOC DB
if (!lookup("location")) {
sl_send_reply("404", "Not Found");
break;
};
};
append_hf("P-hint: usrloc applied\r\n");
route(1);
}
route[1]
{
# send it out now; use stateful forwarding as it works reliably
# even for UDP2TCP
if (!t_relay()) {
sl_reply_error();
};
}
Hi,
I have problems to make my ser work since two 't_relay_to' have been added
in 'ser.cfg'.
Here is my ser.cfg:
#
# $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $
#
# simple quick-start config script
#
# ----------- global configuration parameters ------------------------
#debug=3 # debug level (cmd line: -dddddddddd)
#fork=yes
#log_stderror=no # (cmd line: -E)
/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/
check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
#port=5060
#children=4
fifo="/tmp/ser_fifo"
# ------------------ module loading ----------------------------------
# Uncomment this if you want to use SQL database
loadmodule "/usr/local/ser_directory/lib/ser/modules/mysql.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/sl.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/tm.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/rr.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/registrar.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/textops.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/ser_directory/lib/ser/modules/auth.so"
loadmodule "/usr/local/ser_directory/lib/ser/modules/auth_db.so"
modparam("tm", "fr_inv_timer", 90)
# ----------------- setting module-specific parameters ---------------
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
# -- auth params --
# Uncomment if you are using auth module
#
modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this config),
# uncomment also the following parameter)
#
modparam("auth_db", "password_column", "password")
# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
# ------------------------- request routing logic -------------------
# main routing logic
route{
if (!mf_process_maxfwd_header("10")) {
sl_send_reply("483","Too Many Hops");
break;
};
if (msg:len >= 2048 ) {
sl_send_reply("513", "Message too big");
break;
};
if (!method=="REGISTER") record_route();
if (loose_route()) {
append_hf("P-hint: rr-enforced\r\n");
route(1);
break;
};
if (!uri==myself) {
append_hf("P-hint: outbound\r\n");
route(2);
break;
};
if (uri==myself) {
if (method=="REGISTER") {
if (!www_authorize("192.168.0.120", "subscriber")) {
www_challenge("192.168.0.120", "0");
break;
};
save("location");
break;
};
lookup("aliases");
if (!uri==myself) {
append_hf("P-hint: outbound alias\r\n");
route(2);
break;
};
t_on_failure("1");
lookup("location");
};
append_hf("P-hint: usrloc applied\r\n");
route(1);
}
route[1]
{
if (uri=~"^sip:888@") {
if (!t_relay_to( "192.168.0.120", "5070")) sl_reply_error();
break;
};
t_on_failure("1");
t_relay();
}
route[2]
{
if (!t_relay()) {
sl_reply_error();
};
}
failure_route[1] {
if (!t_relay_to( "192.168.0.120", "5070"))
{
sl_reply_error();
};
}
Thank you for your help!
Michel
________________________________________________
Message sent using UebiMiau 2.7.8
Hi All
I'm seeing this error on my syslog
set_timer called on a "detached" timer
I trried to monitor when it occurs, it occurs when there are customers
calling and I make a query on mysql, the query doesn't really put that
muchload on the server, it returns it in 2 secs i just don't know why it's
causing the detached time error.
TIA
Regards
Nhadie
________________________________________________
Message sent using UebiMiau 2.7
hi User
May the Problem in Router where the server located...
OR UA client side Router ... Block the ACK session ... hung up
automatically after 32 sec....
Or problem in Softphone setting ( x-lite 3.0 )
UAC 1 and 2 are witth 192.168.2.20. and 21 which are behind the NAT with
public.... yy.y.y..y ( softphone)
UAC 3 is softphne which is located in server network with ip
192.168.2.7 have public ip as xxx.xxx.x.xx ( SIP DOMAIN NAME)...
CALL from UAC 1 to UAC 2 hungup the phone after 32 sec when it lefted . UAC
2 is hung upping and UAC1 is call establishing the Session....
CALL from UAC 2 to UAC 3 same as above....
CALL from UAC 3 to UAC 2 not hungup .
this is mines openser.cfg from route main
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++=====
_________________________________________________________________________
route {
# -----------------------------------------------------------------
# Sanity Check Section
# -----------------------------------------------------------------
if (!mf_process_maxfwd_header("10")) {
sl_send_reply("483", "Too Many Hops");
return;
};
if (msg:len > max_len) {
sl_send_reply("513", "Message Overflow");
return;
};
# -----------------------------------------------------------------
# Record Route Section and Acc Section
# -----------------------------------------------------------------
if (method=="INVITE" && client_nat_test("3")) {
# INSERT YOUR IP ADDRESS HERE
record_route_preset("192.168.2.75:5060;nat=yes");
} else if (method!="REGISTER") {
record_route();
setflag(1);
};
# -----------------------------------------------------------------
# Call Tear Down Section
# -----------------------------------------------------------------
if (method=="BYE" || method=="CANCEL") {
end_media_session();
};
# -----------------------------------------------------------------
# Loose Route Section
# -----------------------------------------------------------------
if (loose_route()) {
if (has_totag() && (method=="INVITE" || method=="ACK")) {
if (client_nat_test("3") ||
search("^Route:.*;nat=yes")) {
setflag(6);
use_media_proxy();
};
};
route(1);
return;
};
# -----------------------------------------------------------------
# Call Type Processing Section
# -----------------------------------------------------------------
if (uri!=myself) {
route(1);
return;
};
if (uri==myself) {
if (method=="CANCEL") {
route(3);
return;
} else if (method=="INVITE") {
route(4);
#route(3);
return;
} else if (method=="REGISTER") {
route(2);
return;
};
lookup("aliases");
if (uri!=myself) {
route(1);
return;
};
if (!lookup("location")) {
sl_send_reply("404", "User Not Found");
return;
};
};
route(1);
}
route[1] {
# -----------------------------------------------------------------
# Default Message Handler
# -----------------------------------------------------------------
t_on_reply("1");
if (!t_relay()) {
if (method=="INVITE" || method=="ACK") {
end_media_session();
};
sl_reply_error();
};
}
route[2] {
# -----------------------------------------------------------------
# REGISTER Message Handler
# ----------------------------------------------------------------
sl_send_reply("100", "Trying");
if (!search("^Contact:\ +\*") && client_nat_test("7")) {
setflag(6);
fix_nated_register();
force_rport();
};
if (!www_authorize("","subscriber")) {
www_challenge("","0");
return;
};
if (!check_to()) {
sl_send_reply("401", "Unauthorized");
return;
};
consume_credentials();
if (!save("location")) {
sl_reply_error();
};
}
route[3] {
# -----------------------------------------------------------------
# CANCEL and INVITE Message Handler
# -----------------------------------------------------------------
if (client_nat_test("3")) {
setflag(7);
force_rport();
fix_nated_contact();
};
lookup("aliases");
if (uri!=myself) {
route(1);
return;
};
if (!lookup("location")) {
sl_send_reply("404", "User Not Found");
return;
};
if (method=="CANCEL") {
route(1);
return;
};
if (!proxy_authorize("","subscriber")) {
proxy_challenge("","0");
return;
} else if (!check_from()) {
sl_send_reply("403", "Use From=ID");
return;
};
consume_credentials();
if (isflagset(6) || isflagset(7)) {
use_media_proxy();
};
route(1);
}
#--------------------------------------------------------------------------------------------
# Handling Trusted Sources
#--------------------------------------------------------------------------------------------
route[4] {
if(allow_trusted()) {
rewritehost("192.168.XX.XX"); #Our IP address
t_relay_to(192.168.XX.XX:5060); #relaying trusted calls to its
destination
return;
};
else { route(3); };
}
#---------------------------------------------------------------------------------------------
# Reply Route
#---------------------------------------------------------------------------------------------
onreply_route[1] {
if ((isflagset(6) || isflagset(7)) &&
(status=~"(180)|(183)|2[0-9][0-9]")) {
if (!search("^Content-Length:\ +0")) {
use_media_proxy();
};
};
if (client_nat_test("1")) {
fix_nated_contact();
};
}
-----------------------------------------------------------------------------------------------------------------------------------------------------
--
Thanks and Regards with cheers
Sunkara Ravi Prakash (Voip Developer)
Hyperion Technology
Kondapur, Hi-tech city,
Hyderabad.
www.hyperion-tech.com
+91-9985077535
Hi Nick,
Well, honestly, I don't think many of the developers are on RedHat. They
mostly use debian. The packaging for various distros are something that
need to have a sponsor (i.e. somebody who actually create the packages,
not necessary a developer). I'm not aware of a RedHat sponser, but I
may be wrong. In your case however, you may need some extra help and I
think Andrei is the person most likely to be of help (as this is a
fairly specific problem). Expecting him to spend time on serusers to
find postings like yours, is a bit of a strech, that's why I suggested a
post to serdev. Sure, Andrei subscribes to serusers, but it's something
about response time etc ;-)
If you in addition would be interested in maintaining packages for
future versions, that would be great!
g-)
PS! Yes, you can open a bug in the bugtracker: http://bugs.sip-router.org/
nick wrote:
> Greger V. Teigre wrote:
>> Nick,
>> You may want to post this to serdev(a)iptel.org so you know developers
>> see your trace.
>> g-)
>>
> Hey, I don't want to bother anyone, but is there something else needed
> on my part, do I need to open a bug in the bug tracker, or provide any
> other information to
> the devs??
>
> It's been nearly two days, and nothing is in the bug tracker, and I
> haven't seen much in the way of acknowledgement (not that I expect an
> immediate solution) I just wonder if I need to do anything else...
>
>
> Nick
>
>
>
