sr-users November 2003

sr-users@lists.kamailio.org

116 participants
267 discussions

RE: [Serusers] MySQL table scheme docs
by Stephen Miles 20 Nov '03

20 Nov '03

There should be a ser_mysql.sh in /usr/local/sbin (or where ever you installed ser) that will create the tables for you. Dans admin guide is also really good at www.iptel.org/ser Hope this helps -----Original Message----- From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org]On Behalf Of Darren Nay Sent: Friday, 21 November 2003 10:38 a.m. To: serusers(a)lists.iptel.org Subject: [Serusers] MySQL table scheme docs Hey all, Another quick question. Being new to SER I … [View More]

1 0

[Serusers] MySQL table scheme docs
by Darren Nay 20 Nov '03

20 Nov '03

Hey all, Another quick question. Being new to SER I don't completely understand the mysql table schema and how the data in the tables affects the configuration of the server. Are there any good docs on Configuring the data within the MySQL "ser" database? schema, values, etc.. I have been unsuccessful in finding such documentation thus far. :) Thanks for your help! Darren Nay - dnay(a)libertyisp.com

1 0

RE: [Serusers] Request input
by Peter David 20 Nov '03

20 Nov '03

Jan, is that script in the IPTEL site -----Original Message----- From: Jan Janak [mailto:jan@iptel.org] Sent: Thursday, November 20, 2003 10:29 AM To: Peter David Cc: serusers(a)lists.iptel.org; John W. Leonard; George Sepeda; otto(a)unitedlayer.com Subject: Re: [Serusers] Request input Hello, On 20-11 10:21, Peter David wrote: > > Hello everyone, > > > I am in the process of installing ser-0.8.11_src.tar.gz > into a Linux 9 box and I had followed the instrictions … [View More]

2 1

[Serusers] Request input
by Peter David 20 Nov '03

20 Nov '03

Hello everyone, I am in the process of installing ser-0.8.11_src.tar.gz into a Linux 9 box and I had followed the instrictions from the Install doc link http://cvs.berlios.de/cgi-bin/viewcvs.cgi/*checkout*/ser/sip_router/INSTALL Building ser From Source Distribution However, when looking at all the file generated, I don't see a and ser startup file in the /etc/init.d/ directory I ran the rpm version but in this version I don't see the file. here are the files: /usr/local/etc/… [View More]

2 1

[Serusers] Too many hops
by Urvish Khandwalla 20 Nov '03

20 Nov '03

Hi, I an dialing from my Cisco IP phone to SER (0.8.11) on the same network (192.168.1.x) and it is giving me a STATUS message: 483 Too many hops. Any suggestions. TIA, Urvish Khandwalla

2 1

[Serusers] RE: voicemail
by Klaus Darilion 20 Nov '03

20 Nov '03

Hi! 1. Please answer always to the mailing list, so others can help you too! 2. Your configuration is wrong! Are you using 2 ser proxies? If you want to use redirect to voicemail after a certain time, you need 2 instances of ser! The may run on the same PC. One ser instance is the main proxy (register, forwarding, forward to the voicemail proxy after timeout) and the other proxy serves the voicemail server. You should split your configuration (as in the examples of jiri) --- # Voicemail … [View More]specific configuration - begin if(method=="ACK" || method=="INVITE" || method=="BYE"){ if (!t_newtran()) { log("could not create new transaction\n"); sl_send_reply("500","could not create new transaction"); break; }; t_reply("100","Trying -- just wait a minute !"); if(method=="INVITE"){ log("**************** vm start - begin ******************\n"); if (uri=~"sip:as_welcome@.*" || uri=~"sip:as_nomoney@.*") { if (!vm("/tmp/am_fifo", "announcement")) { log("couldn't contact announcement server\n"); t_reply("500", "couldn not contact announcement server"); }; } else { if(!vm("/tmp/am_fifo","voicemail")){ log("could not contact the answer machine\n"); t_reply("500","could not contact the answer machine"); }; }; log("**************** vm start - end ******************\n"); } else if(method=="BYE"){ log("**************** vm end - begin ******************\n"); if(!vm("/tmp/am_fifo","bye")){ log("could not contact the answer machine\n"); t_reply("500","could not contact the answer machine"); }; log("**************** vm end - end ******************\n"); }; break; }; ----------- This part must be in the ser.cfg of the voicemail proxy, not in the ser.cfg of the main processing proxy. Klaus > -----Original Message----- > From: Sesha B [mailto:sesha@iic.com] > Sent: Thursday, November 20, 2003 4:00 PM > To: Klaus Darilion > Subject: RE: voicemail > > > I used the same thing in my config, but I dont know why it is directly > transferring to the voicemail. Can youplease see the attached > ser.cfg in > this mail and please let me know where I'm doing wrong? That > would be a > great help to me. Please let me know. Thank you very much. > > -----Original Message----- > From: Klaus Darilion [mailto:darilion@ict.tuwien.ac.at] > Sent: Tuesday, November 18, 2003 10:17 AM > To: sesha(a)iic.com > Cc: serusers(a)lists.iptel.org > Subject: RE: voicemail > > > I used the sample config files provided by jiri from > http://iptel.org/~faqomatic/fom-serve/cache/92.html > > klaus > > > -----Original Message----- > > From: Sesha B [mailto:sesha@iic.com] > > Sent: Tuesday, November 18, 2003 4:10 PM > > To: Klaus Darilion > > Subject: RE: voicemail > > > > > > Hi, > > > > I'm trying to do the redirection to voicemail, but I was not > > able to. Can > > you please do me a favor? Can you please send me the section > > of the code > > that does the redirection to the voicemail? Thank you very much. > > > > > > -----Original Message----- > > From: serusers-bounces(a)lists.iptel.org > [mailto:serusers-bounces@lists.iptel.org]On > > Behalf Of Klaus Darilion > > Sent: Tuesday, November 18, 2003 6:01 AM > > To: serusers(a)lists.iptel.org > > Subject: [Serusers] fr_inv_timer problem when using SIPPS > > > > > > Hi! > > > > I tried voicemail with redirect to the vm-proxy if the user > > doesn't pick up > > the phone after 10 seconds. It works fine if I call a kphone > > user, but not > > with SIPPS users. SIPPS sends a 180 Ringing every five seconds which > > probably resets the timer - if I choose timer intervalls > > shorter than 5 > > seconds it also works with SIPPS. > > > > Is this a bug? > > > > tried with ser: > > 0.8.12dev-t14 > > 0.8.11rc1 > > 0.8.11-r1 > > > > regards, > > Klaus > > > > > > ---------- > > # > > # $Id: ser.cfg,v 1.21 2003/06/04 13:47:36 jiri 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 > > 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" > > alias=obelix.ict.tuwien.ac.at > > # ------------------ module loading > ---------------------------------- > > > > # Uncomment this if you want to use SQL database > > loadmodule "/usr/local/lib/ser/modules/mysql.so" > > > > loadmodule "/usr/local/lib/ser/modules/sl.so" > > loadmodule "/usr/local/lib/ser/modules/tm.so" > > loadmodule "/usr/local/lib/ser/modules/rr.so" > > loadmodule "/usr/local/lib/ser/modules/maxfwd.so" > > loadmodule "/usr/local/lib/ser/modules/usrloc.so" > > loadmodule "/usr/local/lib/ser/modules/registrar.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" > > > > # load the voicemail module > > #loadmodule "/usr/local/lib/ser/modules/vm.so" > > > > # load the enum module > > loadmodule "/usr/local/lib/ser/modules/enum.so" > > > > # load the group module, to verify if a user forwards to voicemail > > loadmodule "/usr/local/lib/ser/modules/group.so" > > > > # load the nathelper module > > #loadmodule "/usr/local/lib/ser/modules/nathelper.so" > > > > # ----------------- 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) > > modparam("usrloc", "db_url", "sql://ser:ser2000@localhost/ser") > > > > # -- 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") > > modparam("auth_db", "db_url", "sql://ser:ser2000@localhost/ser") > > > > # -- rr params -- > > # add value to ;lr param to make some broken UAs happy > > modparam("rr", "enable_full_lr", 1) > > > > # -- voicemail params -- > > #modparam("voicemail", "db_url","sql://ser:ser2000@localhost/ser") > > > > # -- voicemail params -- > > modparam("group", "db_url","sql://serro:serro2000@localhost/ser") > > > > # -- nathelper params -- > > #modparam("nathelper", "natping_interval", 10) > > > > modparam("tm", "fr_inv_timer", 8 ) > > modparam("tm", "fr_inv_timer", 8 ) > > > > # ------------------------- request routing logic > ------------------- > > > > # main routing logic > > > > route{ > > > > lookup("aliases"); > > # 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) { > > if (len_gt( 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 > > > > #remove record route for dissipate > > #if (!(method=="REGISTER")) record_route(); > > > > # loose-route processing > > if (loose_route()) { > > t_relay(); > > 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("obelix.ict.tuwien.ac.at", > > "subscriber")) { > > # www_challenge("obelix.ict.tuwien.ac.at", > > "0"); > > # break; > > # }; > > > > if (!save("location")) { > > sl_reply_error(); > > }; > > break; > > }; > > > > # check if number beginns with 00, then convert > > it into a + > > if (uri=~"^sip:00[0-9]*@") { > > # strip booth leading "0" > > strip(2); > > prefix("+"); > > }; > > # check if request uri begins with an internation phone > > number, if yes, try enum to resolve > > if (uri=~"sip:\+?[0-9]+@.*") { > > enum_query("voice"); > > }; > > > > #mark transaction for voicemail > > if (is_user_in("Request-URI", "voicemail")) { > > setflag(4); > > }; > > > > # native SIP destinations are handled using our > > USRLOC DB > > if (!lookup("location")) { > > # handle user which was not found > > route(4); > > break; > > }; > > }; > > > > #add failure route which should be performed if > > response code >=300 > > if (method=="INVITE" && isflagset(4)) { > > t_on_failure("1"); > > }; > > > > # 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(); > > }; > > > > } > > > > route[4]{ > > > > # non-Voip -- just send "off-line" > > if (!(method == "INVITE" || method == "ACK" || method > > == "CANCEL" || > > method == "REFER" || method == "BYE")) { > > sl_send_reply("404", "Not Found"); > > break; > > }; > > > > # not voicemail subscriber > > if (!isflagset(4)) { > > sl_send_reply("404", "Not Found and no voicemail turned > > on"); > > break; > > }; > > > > # forward to voicemail now > > #rewritehostport("machtnix.ict.tuwien.ac.at:5060"); > > t_relay_to_udp("machtnix.ict.tuwien.ac.at", "5060"); > > > > #klaus > > #forward(machtnix.ict.tuwien.ac.at, 5060) > > } > > > > > > > > failure_route[1] { > > /* XX: note: unsafe if preloaded routes without username used */ > > revert_uri(); > > revert_uri(); > > #rewritehostport("machtnix.ict.tuwien.ac.at:5060"); > > append_branch(); > > t_relay_to_udp("machtnix.ict.tuwien.ac.at", "5060"); > > } > > > > > > _______________________________________________ > > Serusers mailing list > > serusers(a)lists.iptel.org > > http://lists.iptel.org/mailman/listinfo/serusers > > > > > [View Less]

1 0

[Serusers] Re: postgres module
by Greg Fausak 20 Nov '03

20 Nov '03

Hi Alex, Please keep these questions on the list, the answer may (or may not) help others! Anyway, I thought that postgres was distributed with SER. It is in the modules/postgres directory, and it can be compiled in by removing it from the Makefile, ie, remove postgres from the lines in the Makefile that look something like: exclude_modules?= cpl cpl-c ext extcmd mangler pdt \ postgres snmp xlog \ im radius_acc radius_auth \… [View More]

2 1

[Serusers] Re: postgres.so question
by Greg Fausak 20 Nov '03

20 Nov '03

I looked around, I cannot find the create script. I know I wrote the initial copy...a mystery. Anyway, the postgres module is not 'completely' done. It is working in production at our place, but there are some missing parts. For example, I had to hack my copy of serctl for the db specific stuff. As far as creating the tables, I don't have the script. I'll cobble together the commands here. I note that many of the tables are now missing; phonebook, pending, event, active_sessions, acc, … [View More]silo, realm, uri, server_monitoring and server_monitoring_ul. I also note that the column names seem to change with each release of SER. I don't know if my tables listed here will reflect those changes...but they can be controlled via ser.cfg, ie: modparam("usrloc","db_mode",1) modparam("usrloc","user_column","user_id") modparam("usrloc","db_url", "sql://USERNAME:PASSWORD@postgres.hostname.com:5432/DBNAME") Just because the tables are missing doesn't mean that the modules that use them won't work under postgres, it simply means that I haven't used them yet and therefore haven't created the table and tested the functionality of that module. I use the SER/postgres combination for subscriber and location and that is it. I have about 3000 current users, the postgres module is hit relatively hard, and it hasn't experienced any problems. Memory usage is steady and I go months between restarts (which are necessary when reconfiguring ser.cfg). There is one issue with the postgres module that I experience, if you restart the postgres database you will have to restart SER. Good Luck, ---greg CREATE TABLE public.subscriber ( phplib_id varchar(32) NOT NULL DEFAULT '', user_id varchar(100) NOT NULL DEFAULT '', password varchar(25) NOT NULL DEFAULT '', first_name varchar(25) NOT NULL DEFAULT '', last_name varchar(45) NOT NULL DEFAULT '', phone varchar(15) NOT NULL DEFAULT '', email_address varchar(50) NOT NULL DEFAULT '', datetime_created timestamptz NOT NULL, datetime_modified timestamptz NOT NULL, confirmation varchar(64) NOT NULL DEFAULT '', flag char(1) NOT NULL DEFAULT 'o', sendnotification varchar(50) NOT NULL DEFAULT '', greeting varchar(50) NOT NULL DEFAULT '', ha1 varchar(128) NOT NULL DEFAULT '', domain varchar(128) NOT NULL DEFAULT '', ha1b varchar(128) NOT NULL DEFAULT '', perms varchar(32), allow_find char(1) NOT NULL DEFAULT '0', timezone varchar(128), first_reg timestamptz, last_reg timestamptz ) WITH OIDS; CREATE TABLE public.reserved ( user_id char(100) NOT NULL DEFAULT '' ) WITH OIDS; CREATE TABLE public.missed_calls ( sip_from varchar(128) NOT NULL DEFAULT '', sip_to varchar(128) NOT NULL DEFAULT '', sip_status varchar(128) NOT NULL DEFAULT '', sip_method varchar(16) NOT NULL DEFAULT '', i_uri varchar(128) NOT NULL DEFAULT '', o_uri varchar(128) NOT NULL DEFAULT '', sip_callid varchar(128) NOT NULL DEFAULT '', user_id varchar(64) NOT NULL DEFAULT '', time timestamptz NOT NULL, timestamp timestamptz NOT NULL ) WITH OIDS; CREATE TABLE public.location ( user_id varchar(50) NOT NULL DEFAULT '', domain varchar(100) NOT NULL DEFAULT '', contact varchar(255) NOT NULL DEFAULT '', expires timestamptz, q numeric(10,2), callid varchar(255), cseq numeric(11), last_modified timestamptz NOT NULL DEFAULT now(), replicate numeric(10), state numeric(3) ) WITH OIDS; CREATE TABLE public.grp ( user_id varchar(50) NOT NULL, grp varchar(50) NOT NULL, last_modified timestamptz NOT NULL DEFAULT now(), domain varchar(128) ) WITH OIDS; CREATE TABLE public.config ( attribute varchar(32) NOT NULL, value varchar(128) NOT NULL, user_id varchar(100) NOT NULL DEFAULT '', modified timestamptz ) WITH OIDS; CREATE TABLE public.domain ( did varchar(32) NOT NULL, pdid varchar(32), dname varchar(60) NOT NULL, ddesc varchar(255) NOT NULL ) WITH OIDS; CREATE TABLE public.aliases ( user_id varchar(50) NOT NULL, contact varchar(255) NOT NULL, last_modified timestamptz NOT NULL DEFAULT now(), expires timestamptz NOT NULL, q numeric(10,2), callid varchar(255), cseq int4, replicate int4, stage int4, state int4 ) WITH OIDS; sip wrote: > hi, greg. > where i can find ser_postgres.sh > for create postgres db ? > or db structure ? > > thanks [View Less]

2 1

[Serusers] CPLEd and cpl-c module
by Brinker, Oliver 20 Nov '03

20 Nov '03

Hello, does anybody have experience with CPLEd and the cpl-c module? The installation of CPLEd on a SuSE 8.2 machine works without any problems, but I cannot compile the latest cpl-c module from cvs. I'm using gcc 3.3, make 3.80, libxml2 and ser 0.8.11 on the machine. If needed I can post the error output. Thanks.

3 2

[Serusers] Komodo Phone --
by Kannaiyan Natesan 20 Nov '03

20 Nov '03

I have got a Cisco ATA 182 (Komodo Phone) and it has got a facility to connect to a PSTN line. Can anyone help me, how can I configure to work with SER (SIP) and use the PSTN line. I could not see any settings for SIP anywhere. Pls help. Best Regards, Kannaiyan

1 0

← Newer
1
...
11
12
13
14
15
16
17
...
27
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users November 2003