sr-users July 2003

sr-users@lists.kamailio.org

67 participants
160 discussions

[Serusers] PostgreSQL
by Takefumi Naito 26 Jul '03

26 Jul '03

Thank you for your reply. I tried, but location database hasn't run yet. The machine I use are installed SER and PostgreSQL. First, what I did is created a database "ser" and created table "location", "subscriber" and "grp" according to the way you teached me. Then I did following procedure. $psql ser postgres=# create user seruser with password 'seruserpass'; postgres=# Grant all on table location to seruser; postgres=# Grant all on table subscriber to seruser; postgres=# Grant all on table grp to seruser; In the ser.cfg file, I set db_url "sql://seruser:seruserpass@localhost:5432/ser" for three modules: userloc, group and auth_db. Is that right? Could you point my mistake out? Best regards. Takefumi > Hi, > > Wow, I didn't think anybody was going to ever use it! > > I've been running, in production, for several months. > The driver seems to work. > > First, it goes without saying, but you have to get Postgres > installed on your machine, and perhaps two machines. > If you are running postgres on the same machine that is doing > the SER process, then one machine will do, otherwise, install > Postgres on the machine that runs the database, and on the machine > that compiles (and runs) SER. > > Second, start the database and create a couple of tables: > > CREATE TABLE subscriber ( > phplib_id character varying(32) DEFAULT '' NOT NULL, > user_id character varying(100) DEFAULT '' NOT NULL, > "password" character varying(25) DEFAULT '' NOT NULL, > first_name character varying(25) DEFAULT '' NOT NULL, > last_name character varying(45) DEFAULT '' NOT NULL, > phone character varying(15) DEFAULT '' NOT NULL, > email_address character varying(50) DEFAULT '' NOT NULL, > datetime_created timestamp with time zone NOT NULL, > datetime_modified timestamp with time zone NOT NULL, > confirmation character varying(64) DEFAULT '' NOT NULL, > flag character(1) DEFAULT 'o' NOT NULL, > sendnotification character varying(50) DEFAULT '' NOT NULL, > greeting character varying(50) DEFAULT '' NOT NULL, > ha1 character varying(128) DEFAULT '' NOT NULL, > "domain" character varying(128) DEFAULT '' NOT NULL, > ha1b character varying(128) DEFAULT '' NOT NULL, > perms character varying(32), > allow_find character(1) DEFAULT '0' NOT NULL, > timezone character varying(128), > first_reg timestamp with time zone, > last_reg timestamp with time zone > ); > > CREATE UNIQUE INDEX subscriber_primary ON subscriber USING btree > ("domain", user_id); > > CREATE TABLE "location" ( > user_id character varying(50) DEFAULT '' NOT NULL, > "domain" character varying(100) DEFAULT '' NOT NULL, > contact character varying(255) DEFAULT '' NOT NULL, > expires timestamp with time zone, > q numeric(10,2), > callid character varying(255), > cseq numeric(11,0), > last_modified timestamp with time zone DEFAULT now() NOT NULL, > replicate numeric(10,0), > state numeric(3,0) > ); > > CREATE INDEX location_primary ON "location" USING btree (user_id); > > CREATE TABLE grp ( > user_id character varying(50) NOT NULL, > grp character varying(50) NOT NULL, > last_modified timestamp with time zone DEFAULT now() NOT NULL, > "domain" character varying(128) > ); > > CREATE UNIQUE INDEX grp_primary ON grp USING btree (user_id, grp); > > Create a user in the database, for instance: > > Create user seruser with password 'seruserpass'; > > Grant permission on the tables to the newly created user: > > Grant all on table location to seruser; > Grant all on table subscriber to seruser; > Grant all on table grp to seruser; > > Ok, this is the basic database. > > You need this line in the ser.cfg file: > > loadmodule "/usr/ser/lib/ser/modules/postgres.so" > > modparam("usrloc","db_mode",1) > modparam("usrloc","user_column","user_id") > modparam("usrloc","db_url", > "sql://seruser:seruserpass@db.host.name.or.ip:5432/dbname") > > modparam("group","user_column","user_id") > modparam("group","db_url", > "sql://seruser:seruserpass@db.host.name.or.ip:5432/dbname") > > modparam("auth_db","user_column","user_id") > modparam("auth_db","db_url", > "sql://seruser:seruserpass@db.host.name.or.ip:5432/dbname") > > By the way, I had problems changing the column names. I've got many > other > tables and applications that refer to the column names as they were in > 0.8.10. Since the column name change didn't really affect anything but > the > name, I left them the way they were. Changing them would be > too much work for me! > > That is it. Oh, there is one other thing. > Your serctl program won't work. Use the serctl call serpgctl and > rename it serctl if you wish. > > Good luck, > ---greg > Greg Fausak > Addaline.com, Inc. > greg(a)addaline.com > www.addaline.com >

2 1

[Serusers] Aliases with XLite don't work but they work with FXS device
by Director General: NEFACOMP 26 Jul '03

26 Jul '03

I finally got the aliases to work with my FXS device (Mediatrix 1104) I think there is a problem with XLite with aliases. I used aliases on my Mediatrix 4 FXS ports and they work with no problem Thanks, __________________________________ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: dg(a)nefacomp.net http://www.nefacomp.net/

1 0

[Serusers] radius accounting capabilities with SER
by jaime＠umtstrial.co.uk 26 Jul '03

26 Jul '03

Hello all, I have been going through the archives, but could not see any question on the same subject, so here it goes: After putting together a freeradius server and a CVS version of SER, the server can authenticate users using RADIUS. Now I'm trying to do accounting on certain events, mainly calling and sending messages between clients. Radius Accounting Start messages are created and sent to the RADIUS server when calling from one User Agent to the other, but no Stop messages are created once the two end points finish the conversation. SIP dialogs are record-routed, so SER is able to see all the transactions. My questions are: - What triggers the generation of radius accounting requests? - Can we configure these triggers somehow (on a per method/filter basis)? Any hints on this would be very appreciated. Jaime

4 5

[Serusers] FW: How to use pa?
by Kevin Chu 25 Jul '03

25 Jul '03

Hi, I am interested of using pa module to provide presence function between regular SIP users. Is that usage supported at this moment? or only SIP users can see presence of jabber users as mentioned in the README of pa module? >This module implements a presence server, i.e. entity that >receives SUBSCRIBE messages and sends NOTIFY when presence >status of a user changes. Currently the presence server can be >connected to registar and jabber module so SIP users can see >presence of jabber users. Can anybody provide me a sample configuration file for using pa module? I tried to call the exported function as example from README, but it always failed: ... handle_subscription("registar"); ... Thanks, Kevin

1 0

Re: [Serusers] Voicemail implementation
by Jan Janak 25 Jul '03

25 Jul '03

Hello, comments inline. On 24-07 16:45, Juan J. Sierralta P. wrote: > On Thu, 2003-07-24 at 16:17, Jan Janak wrote: > > > > First of all thanks to SER developers for the great work. > > > I'm new to SIP and SER, I been playing with it a week ago and I was > > > able to setup a 0.8.11pre, and now I want to try the voicemail service. > > > It seems that I need to run another SER instance for voicemail and > > > redirect the requests to that instance. > > > > No, you can run it on the same server. > > > > > It is posible to process the voicemail request on the same instance I > > > use to forward/register users ? > > > > Yes. > > > > > Or I need a second SER running. In case of 2 SER servers, it is posible > > > to run them in the same box using diferent ports and diferent databases > > > ? > > > > Yes, if the servers listen on different ports and use different > > databases. > > The problem I see with two instances is maintaing the users table > syncronized to get the email address. You can use the same table as for the "routing" SIP server. subscriber table (the table which contains usernames and correspondings e-mails) is not modified by the proxy or voicemail, so there is no need to synchronize it. I mean the routing proxy will query the table to get credentials and voicemail will query it to get email addresses. > So is there an example out there how to implement voicemail in the same > instance used for forwarding/register. A sample config file for a voicemail running within another ser instance is attached. Note that you can also put the snippets of the config into the main proxy config, you need no separate instance. > Correct me if I'm wrong: > - I receive an INVITE for an offline user. > - I detect the offline status and must rewrite the uri in some way to > signal echo,conference or voicemail. > > The problem I see if I rewrite the URI the VM will no be able to locate > the user's email address. It uses To header field to get URI of the callee, To header field URI never changes. Jan. PS: Please always CC the list.

3 11

Re: [Serusers] Questions about the clients SIP cisco?
by Nils Ohlmeier 25 Jul '03

25 Jul '03

I know what you read, but just that their is a UA mentioned does not mean that it is in anyway related to SER (expect using it as proxy). The howto also mentions a lot other external things like ngrep or sipsak. Read the fine manual (RTFM) of your Cisco 7960, obviously the TFTP server do not have be the same server as the SIP proxy! Nils On Friday 25 July 2003 17:32, you wrote: > thanks for you > but i am reading this article, in the Url: > http://www.fitawi.com/ser-Howto.html > > They explained how to configure Cisco 7960, but I want to know for me > the TFTP server is the same that the proxy server.??? > Thank you in advance > Hassan > > > > 7.2. Cisco 79XX phones > Cisco has complete documentation on how to convert a 79XX series phone > to use SIP. The basic steps are: > > 7.2.1. Configure a DHCP service that provides: > a. IP address > > b. Subnet mask > > c. Default gateway > > d. DNS server addresses > > e. TFTP server address > > 7.2.2. On the TFTP server load these files: > a. OS79XX – Identifies which firmware the phone should load > with no extension. Example: P0S3-04-1-00 > > b. P0S3-04-1-00.bin – The firmware image > > c. SIPDefault.cnf - Site wide configuration options > > d. SIPmacaddress.cnf – Phone specific settings, including logon > name and password. Example: SIP000A8A93D466.cnf > > e. RINGLIST.DAT, ringer1.pcm, ringer2.pcm – ring tones > > > > Each time the phone is powered on it will tftp download OS79XX and > determine if it needs a firmware update. If no update is needed the > next step is to download SIPDefault.cnf, SIPmacaddress.cnf, and > optionally a dialplan, ringlist and ring tones. > > > > Calls can be placed to other registered SIP clients, or to a PSTN > number provided there is PSTN gateway identified in the SER > configuration file. > > ------------------- > > >No IT IS NOT neccesarry to download anything ON THE SIP PROXY. You > > even can > > >not download anything on our proxy! > >You have to configure the Cisco 7960 for the SER. But this is not > > related to > > >SER, this related to your network settings. > > > > Nils > > > >On Friday 25 July 2003 15:50, you wrote: > >> hello, > >> But this question concerns ser because to configure the user agent > > SIP > > >> Cisco 7960, it is necessary to download files on the proxy server > > SIP. > > >> Thank you > >> Hassan > >> > >> ------------------- > >> > >> >Hello, > >> > > >> >please RTFM of your Cisco 7960. This question is not related to > > SER. > > >> >Configuration have to placed on a TFTP server. > >> > > >> >Regards > >> > Nils Ohlmeier > >> > > >> >On Friday 25 July 2003 15:01, Hassan CHOUMAR wrote: > >> >> Hello all, > >> >> Anybody knows where are file installed on the proxy server SIP, > > to > > >> use > >> > >> >> the cisco customer SIP 7960, if anybody it had them, please send > > to > > >> me > >> > >> >> Thank you in advance > >> >> > >> >> > >> >> 7.2.2. On the TFTP server load these files: > >> >> a. OS79XX – Identifies which firmware the phone should > > load > > >> >> with no extension. Example: P0S3-04-1-00 > >> >> > >> >> b. P0S3-04-1-00.bin – The firmware image > >> >> > >> >> c. SIPDefault.cnf - Site wide configuration options > >> >> > >> >> d. SIPmacaddress.cnf – Phone specific settings, including > >> > >> logon > >> > >> >> name and password. Example: SIP000A8A93D466.cnf > >> >> > >> >> e. RINGLIST.DAT, ringer1.pcm, ringer2.pcm – ring tones > >> >> > >> >> Thank you in advance > >> >> > >> >> CHOUMAR Hassan > >> >> cité universitaire de la pacaterie (chambre459) > >> >> 91400 Orsay > >> >> Por :33/0675909977 > >> >> Email: hmchoumar(a)hotmail.com > >> >> > >> >> _______________________________________________ > >> >> Serusers mailing list > >> >> serusers(a)lists.iptel.org > >> >> http://lists.iptel.org/mailman/listinfo/serusers > >> > >> CHOUMAR Hassan > >> cité universitaire de la pacaterie (chambre459) > >> 91400 Orsay > >> Por :33/0675909977 > >> Email: hmchoumar(a)hotmail.com > > CHOUMAR Hassan > cité universitaire de la pacaterie (chambre459) > 91400 Orsay > Por :33/0675909977 > Email: hmchoumar(a)hotmail.com

1 0

[Serusers] Questions about the clients SIP cisco?
by Hassan CHOUMAR 25 Jul '03

25 Jul '03

Hello all, Anybody knows where are file installed on the proxy server SIP, to use the cisco customer SIP 7960, if anybody it had them, please send to me Thank you in advance 7.2.2. On the TFTP server load these files: a. OS79XX – Identifies which firmware the phone should load with no extension. Example: P0S3-04-1-00 b. P0S3-04-1-00.bin – The firmware image c. SIPDefault.cnf - Site wide configuration options d. SIPmacaddress.cnf – Phone specific settings, including logon name and password. Example: SIP000A8A93D466.cnf e. RINGLIST.DAT, ringer1.pcm, ringer2.pcm – ring tones Thank you in advance CHOUMAR Hassan cité universitaire de la pacaterie (chambre459) 91400 Orsay Por :33/0675909977 Email: hmchoumar(a)hotmail.com

2 1

[Serusers] Questions about SIP cleints Cisco7960?
by Hassan CHOUMAR 25 Jul '03

25 Jul '03

Hello all, Anybody knows how we configure a device IPphone Cisco 7960, to use it on a server SER, and which are files in downloaded on the server (SIPDefault.cnf....), if anybody he have them, please send to me Thank you in advance Hassan CHOUMAR Hassan cité universitaire de la pacaterie (chambre459) 91400 Orsay Por :33/0675909977 Email: hmchoumar(a)hotmail.com

1 0

[Serusers] ODBC connection failed on ser 8.11 Mysql database
by George KAPELIOS 25 Jul '03

25 Jul '03

It might be more a MySQL oriented question: I was running ser 8.10 on RH8.0 and I had odbc driver running on a Win PC, importing the tables of the ser Mysql database to a Microsoft Access, without any problem. Since I upgraded ser to 8.11 and use the new ser database, I am not able to import the tables using odbc driver. Connection to Mysql is failed. Is anybody aware about the issue ? Any suggestion to problem resolution ? George

1 0

[Serusers] Re:New Introduce
by jenny 24 Jul '03

24 Jul '03

Multi Neoprene China Factory T : 0086-769-5835182 F : 0086-769-5586689 US$ S012 13.00 S014 17.00 D955 2.50/Pr DSCF0009 1.50/Pr Rash Guard 6.00 Shorts 6.50 Footstrap 4.00 Waist pad (surfing) 3.00 Palm bag 1.00 Uniform Jacket 3.50 T shirt 2.50 Boot 3.5/Pr Shoe 3.00/pr Beach chair 8.00 Life Jacket 10.00 paper bag 34x12x23cm 0.40 paper bag 26x8x31.8cm 0.38 Website : http://home.netvigator.com/~sky888s/ Thanks, Jenny

1 0

← Newer
1
2
3
4
5
6
7
8
...
16
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 July 2003