Right, in other words
vi /usr/src/sip_router/modules/acc/Makefile
uncomment where it says SQL. Make sure mysql.so exists, if not you may
need to install mysql from tarball, I never had luck using the
mysql-devel packages.
-----Original Message-----
From: Iqbal [mailto:iqbal@gigo.co.uk]
Sent: Tuesday, April 26, 2005 10:29 AM
To: serusers(a)lists.iptel.org
Subject: [Serusers] ACC into mysql
Need for immediate resolution .. please help ..
thanks,
ed
Hi
when you compiled ser, did you edit the Makefile in the modules/acc
directory
If not please do, it can either use radius OR mysql, hence comment out
the lines u dont need, and then recompile and start ser
Iqbal
------------------
Hi!
I appreciate your immediate feedback and Im so thankful for extending
your help to me. However, after I followed the instruction you gave,
this is what happened.
speed:/usr/local/src/project/ser-0.8.14# /usr/local/ser/sbin/ser -f
/usr/local/ser/etc/ser/ser.cfg start & [1] 23521
0(23521) set_mod_param_regex: parameter <db_url> not found in module
<acc>
0(23521) parse error (49,60-61): Can't set module parameter
0(23521) set_mod_param_regex: parameter <db_flag> not found in module
<acc>
0(23521) parse error (50,29-30): Can't set module parameter
I remember during my ser installation, I use make all. Will this enable
my accounting using mysql.
thanks,
ed
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
hi
i had the same problem
i solved it in such a way
set the rpid to 123456789(a)sip.com
and the append_hf to
append_rpid_hf("<sip:", ">;party=calling;id-type=subscriber;screen=yes");
hope solves your probelm
raid
--
+++ GMX - die erste Adresse f�r Mail, Message, More +++
10 GB Mailbox, 100 FreeSMS http://www.gmx.net/de/go/topmail
Hi guys,
I've noticed that my sip methods are not decoded and are stored as
integers in mysql database. For instance,
Acct-Status-Type = Start
Service-Type = Sip-Session
Sip-Response-Code = 200
Sip-Method = 1 <-------------------------------------------- Here
User-Name = "2001(a)orion.lab.test.com"
Calling-Station-Id = "sip:1001@orion.lab.test.com"
Called-Station-Id = "sip:91711@orion.lab.test.com"
Sip-Translated-Req-ID = "sip:91711@192.168.1.1:5060"
Acct-Session-Id = "000ded22-eeb200af-7abf52ea-7594628f(a)192.168.4.2"
Sip-To-Tag = "19C6CC30-4E3"
Sip-From-Tag = "000ded22eeb200127e7c3590-329e270c"
Sip-Cseq = "102"
NAS-IP-Address = 192.168.1.2
NAS-Port = 5060
Acct-Delay-Time = 0
Client-IP-Address = 127.0.0.1
Acct-Unique-Session-Id = "fb24188f75e8946d"
Realm = "orion.lab.test.com"
Timestamp = 1113208054
Am I missing something, such as missing entries in my dictionary? How
can I make it convert the code into the actual text representing the sip
method, such as INVITE?
Kindly advise,
Regards,
YY
Need for immediate resolution .. please help ..
thanks,
ed
Hi
when you compiled ser, did you edit the Makefile in the modules/acc
directory
If not please do, it can either use radius OR mysql, hence comment out
the lines u dont need, and then recompile and start ser
Iqbal
------------------
Hi!
I appreciate your immediate feedback and Im so thankful for extending your
help to me.
However, after I followed the instruction you gave, this is what happened.
speed:/usr/local/src/project/ser-0.8.14# /usr/local/ser/sbin/ser -f
/usr/local/ser/etc/ser/ser.cfg start &
[1] 23521
0(23521) set_mod_param_regex: parameter <db_url> not found in module
<acc>
0(23521) parse error (49,60-61): Can't set module parameter
0(23521) set_mod_param_regex: parameter <db_flag> not found in module
<acc>
0(23521) parse error (50,29-30): Can't set module parameter
I remember during my ser installation, I use make all. Will this enable my
accounting using mysql.
thanks,
ed
Hi,
Does anyone know what correct format of a packet
should be pushed into fifo buffer? For example,
serctl fifo t_uac_dlg BYE sip:1111@xxx.xxx.xxx
'sip:from:1111@xxx.xxx.xxx' 'sip:to:2222@xxx.xxx.xxx'
'callid:xxxxxxxxxxxx' 'Cseq:xxxxxx' . .
The above command I've tried,but got errors.
Hope someone can help me to solve this problem.
Thank a lots.
Oz
_______________________________________________________________________
Yahoo!奇摩電子信箱
免費容量250MB,信件在多也不怕
http://tw.promo.yahoo.com/mail_new/index.html
hi
i had the same problem
Hi
So you mean instead of having rpid=12345678 have it read
rpid=12345678(a)domain.com
Also I looked at my outgoing message and it doesnt seem to show the
Remote-party header in tghe outgoing message as Jan mentioned, I am
using xlite to test this one, is your cli working with xlite.
The xlite is calling via cisco-gw to mobile phone
Iqbal
-------------------------------
i solved it in such a way
set the rpid to 123456789 at sip.com
and the append_hf to
append_rpid_hf("<sip:",
">;party=calling;id-type=subscriber;screen=yes");
hope solves your probelm
raid
--
+++ GMX - die erste Adresse für Mail, Message, More +++
10 GB Mailbox, 100 FreeSMS http://www.gmx.net/de/go/topmail
Hi
CDRTool is okay, but there opensource version does not include and
scripts for rating etc, but you can use it as a starting point to
fashion your own
Iqbal
-------
Hello list,
I'm newbie to SER, have a little voip network (with SER) and want to
expand
it so
did anyone used CDRTool for billing in SER ?
Maybe you know other good open source "ready to deploy" billing systems?
If this topic was already mentioned on this forum ,please give me pointer.
--
Pozdrawiam,
Wojciech Ziniewicz
Optocomp sp.z.o.o, www.optocomp.pl
mailto: wojtekz at optocomp.pl
+48(0)691031535
Hi all,
I know that this topic was discussed before, but my
case is diferent.
The name of the network in my work is intranet, and
I'm testing two computers, the first one's name is
parati with ip 10.0.161.52 runing SER with the 'Hello
World' config, and the other one is saopaulo
10.0.161.59 runing Kphone.
I've tryed this configuration for kphone:
Name:
Fabio
User Part of the SIP URL:
fabioldr
Host Part of the SIP URL:
parati.intranet
Auto Register: yes
Wen I try to registrar with SER :
fabioldr@saopaulo:~$ kphone
Found 2 interfaces.
SipClient: Listening UDP on port: 5060
SipClient: Our address: 10.0.161.59
SipRegister: Auth is '(null)'
SipRegister: Proxy Auth is '(null)'
SipClient: Sending: 12:04:16.526
--------------------------------
REGISTER sip:parati.intranet SIP/2.0
Via: SIP/2.0/UDP 10.0.161.59;branch=z9hG4bK5DD0E9F7
CSeq: 7190 REGISTER
To: "Fabio Luiz Doreto Rodrigues"
<sip:fabioldr@parati.intranet>
Expires: 900
From: "Fabio Luiz Doreto Rodrigues"
<sip:fabioldr@parati.intranet>
Call-ID: 778680124(a)10.0.161.59
Content-Length: 0
User-Agent: kphone/4.0.5
Event: registration
Allow-Events: presence
Contact: "Fabio Luiz Doreto Rodrigues"
<sip:fabioldr@10.0.161.59;transport=udp>;methods="INVITE,
MESSAGE, INFO, SUBSCRIBE, OPTIONS, BYE, CANCEL,
NOTIFY, ACK, REFER"
res_search: NO result !
res_search: NO result !
SipClient: Sending to 'parati.intranet:5060'
SipTransaction: Retransmit 1 (4000)
SipClient: Sending: 12:04:20.527
--------------------------------
REGISTER sip:parati.intranet SIP/2.0
Via: SIP/2.0/UDP 10.0.161.59;branch=z9hG4bK5DD0E9F7
CSeq: 7190 REGISTER
To: "Fabio Luiz Doreto Rodrigues"
<sip:fabioldr@parati.intranet>
Expires: 900
From: "Fabio Luiz Doreto Rodrigues"
<sip:fabioldr@parati.intranet>
Call-ID: 778680124(a)10.0.161.59
Content-Length: 0
User-Agent: kphone/4.0.5
Event: registration
Allow-Events: presence
Contact: "Fabio Luiz Doreto Rodrigues"
<sip:fabioldr@10.0.161.59;transport=udp>;methods="INVITE,
MESSAGE, INFO, SUBSCRIBE, OPTIONS, BYE, CANCEL,
NOTIFY, ACK, REFER"
then Kphone retransmit for 10 times with no response,
I've tried to change the name parati.intranet for the
IP number but the same happens.
Anyone had the same problem?
Thank you
Yahoo! Acesso Grátis - Internet rápida e grátis.
Instale o discador agora! http://br.acesso.yahoo.com/
Hi
isnt record_route not about sending the call, but the METHODS through
Iqbal
I am assuming your question is if the record_route() function is a
parameter
for accounting? If that was your question then the answer is no. Generally
you invoke record_route() to ensure acl acceptance on a gateway (i.e. all
calls through that gateway)
-----Original Message-----
From: Edgardo O. Gonzales II [mailto:edgardo.g at pacific.net.ph]
Sent: Monday, April 25, 2005 6:22 PM
To: Kofi Obiri-Yeboah
Cc: serusers at iptel.org
Subject: RE: [Serusers] ACC into mysql
Hi Kofi!
got it.. thanks for immediate feedback .. however my accounting is not
working.
any parameters to be added to make it work..
I have the following info already on my ser.cfg
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", 1)
modparam("acc", "log_missed_flag", 3)
record_route(); -> its this a parameter for accounting
thanks,
ed
At 08:32 AM 4/26/2005, Kofi Obiri-Yeboah wrote:
I think the correct modparam statement should read as follows:
modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")
please note that "my" is required in front of sql
and not:
modparam("acc", "db_url", "sql://ser:heslo@localhost/ser")
-----Original Message-----
From: serusers-bounces at iptel.org [
mailto:serusers-bounces at iptel.org]On Behalf Of Edgardo O. Gonzales II
Sent: Monday, April 25, 2005 5:20 PM
To: serusers at iptel.org
Subject: Re: [Serusers] ACC into mysql
Hi all!
Im also receiving this error message.
Can somebody help us on how to make accounting work using mysql.
thanks,
ed
At 06:01 AM 4/26/2005, Leon Sun wrote:
Hi,
I am using 0.8.12 in Fedora 3. I tried to log account info into
Mysql followed instruction from manual. I found, first, modparam("acc",
"db_url", "sql://ser:heslo@localhost/ser") coudnlt work at all in
ser.cfg.
If I enabled in cfg file, it showed Starting ser: ERROR: bad config file
(1
errors)
If I disabled it, SER worked fine but I couldnt see any record in
acc table.
Would anyone suggest how to put call records into Mysql?
Thank you.
# ----------- 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
debug=7
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/lib/ser/modules/mysql.so"
loadmodule "/usr/lib/ser/modules/acc.so"
loadmodule "/usr/lib/ser/modules/sl.so"
loadmodule "/usr/lib/ser/modules/tm.so"
loadmodule "/usr/lib/ser/modules/rr.so"
loadmodule "/usr/lib/ser/modules/maxfwd.so"
loadmodule "/usr/lib/ser/modules/usrloc.so"
loadmodule "/usr/lib/ser/modules/registrar.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/lib/ser/modules/auth.so"
loadmodule "/usr/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific
parameters ---------------
#modparam("acc", "db_url", "sql://ser:heslo@localhost/ser")
# -- 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)
modparam("acc","log_level",1)
modparam("acc","log_flag",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 > max_len ) {
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
record_route();
# loose-route processing
if (loose_route()) {
if (method=="BYE") {
setflag(1);
setflag(2);
}
t_relay();
break;
};
#labeled all transaction for accounting
setflag(1);
setflag(2);
if (method=="CANCEL"){
t_relay();
};
# (in case, it does not work, use the following command
# with proper names and addresses in it)
if (uri==myself) {
# This for PSTN destination
if (uri=~"^sip:1")
{ rewritehost("10.10.10.10");
forward(10.10.10.10,5060);
break;
}
if (method=="REGISTER") {
# Uncomment this if you want to use digest
authentication
if
(!www_authorize("sip.mycommunications.com", "subscriber")) {
www_challenge("sip.mycommunications.com", "0");
break;
};
save("location");
break;
};
# native SIP destinations are handled using our
USRLOC DB
if (!lookup("location")) {
sl_send_reply("404", "Not Found");
break;
};
};
# forward to current uri now; use stateful forwarding;
that
# works reliably even if we forward from TCP to UDP
if (!t_relay()) {
sl_reply_error();
};
}
Hi!
I've managed to implement and compile Peter Griffiths' free TLS
implementation. It worked well, a test-connection with "openssl
s_client" did also work.
Now, how do I tell my UAs (snom 190, sipura SPA-1001) to use SIP over
TLS? Both vendors of these UAs claim their UA is capable of SIPS, so how
do I enable it?
Alex Mack