login | register
Sat 17 of May, 2008 [05:25 UTC]

voip-info.org

Navigation
Today's Deals
Recently Visited Pages
Search with Google
Search this site with Google. Results may not include recent changes.
 
Google Ads
Last Changes
Shoutbox
  • Juan Ortega, Thu 15 of May, 2008 [10:33 UTC]: Hi everybody, I'm Juan, an ITCom student, and I need to know what basic elements I need to create a VoIP network. Can anybody helpme, please?,Thank you very much
  • gineta, Wed 14 of May, 2008 [03:58 UTC]: any here not fine the configuration of firewall juniper -screem for VOIP asterisk????
  • Anoop Prabhakaran, Tue 13 of May, 2008 [12:16 UTC]: I am developing Asterisk IVR, Whenever i make a internation call to the IVR system, the DTMF is not getting detected properly, this happens only for the first time, second call onwards system works fine. why this is happening
  • joe, Mon 12 of May, 2008 [04:27 UTC]: Is there an opensource browser based softphone, or a system like Busta where everything is not manages through their website?
  • Nick Barnes, Fri 09 of May, 2008 [11:36 UTC]: Christopher - yesterday I tried an Asterisk install on a CentOS 5.1 box with stock GUI and it all worked fine. Sorry I can't help.
  • aero, Fri 09 of May, 2008 [08:20 UTC]: can someone help me out on this, i tried to play some sound files on my asterisk box and this is the error message i got. WARNING[4429]: format_wav.c:169 check_header: Unexpected freqency 22050 May 8 11:17:39 WARNING[4433]: codec_gsm.c:194 gsmtolin_fra
  • Christopher Faust, Thu 08 of May, 2008 [14:15 UTC]: I beleive that I may have to change something in the xserver configuration. Please advise
  • Christopher Faust, Thu 08 of May, 2008 [14:14 UTC]: Everything was perfect. In the bios I have increased the memory allocated Still receive input not supported on my display.
  • Christopher Faust, Thu 08 of May, 2008 [14:13 UTC]: This would not be my main box. I am doing some testing to see if I can install zaptel and asterisk 1.4 on a full centos 5.1 box with development software Its bizzare, because before I went through the asterisk and zaptel installation everything was perfe
  • Nick Barnes, Thu 08 of May, 2008 [13:44 UTC]: Christopher - I can't see any way in which an Asterisk installation would muck your GUI, but remember that it is advised not to use a GUI on an Asterisk box anyway.
Server Stats
  • Execution time: 0.39s
  • Memory usage: 2.21MB
  • Database queries: 33
  • GZIP: Disabled
  • Server load: 0.55

SER module postgres

You may have to recompile (open)SER to get the postgres.so module.

make include_modules="postgres"


A minimal postgresql setup:


$ createdb ser
$ psql -U postgres ser
ser=# CREATE TABLE subscriber (
 username varchar(32),
 domain varchar(32),
 password varchar(16),
 PRIMARY KEY (username, domain)
);
ser=# create user ser with password 'mypass';
ser=# grant all on table subscriber to ser;


and to add users manually


ser=# insert into subscriber values ('user', 'domain_or_realm', 'pass');


make sure these are in ser.cfg


loadmodule "/usr/lib/ser/modules/postgres.so"
loadmodule "/usr/lib/ser/modules/usrloc.so"
loadmodule "/usr/lib/ser/modules/auth.so"
loadmodule "/usr/lib/ser/modules/auth_db.so"
modparam("usrloc", "db_mode", 0) # not using postgresql for usrloc database, in memory only
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("auth_db","db_url", "sql://ser:mypass@localhost:5432/ser")


Please note that later versions (=> 0.9.x) of SER require a change to the db_url:

modparam("auth_db","db_url", "postgres://ser:mypass@localhost:5432/ser")


mailing list posts with more information:
http://mail.iptel.org/pipermail/serusers/2003-July/001997.html
http://mail.iptel.org/pipermail/serusers/2003-November/003773.html

SER admin guide
auth_db README

Created by stan, Last modification by bmacleod on Sat 19 of Nov, 2005 [21:19 UTC]

Comments

Comments Filter

Re: ident sameuser

by pupeno on Wednesday 29 of March, 2006 [17:39:49 UTC]
It was solved by connecting to the socket instead of the host, I've achieve that by replacing the URL with postgres://pupeno@/ser (PostgreSQL connects to the local socket by default).

ident sameuser

by pupeno on Wednesday 29 of March, 2006 [16:23:57 UTC]
There's an awesome feature of postgresql where you authenticate only by being logged in as a particular user. I am using that so I don't have to type any password either by running the sql command line interface or in any configuration file.
But when I configure it to connect to postgresql it seems it doesn't even try to log in unless there's a password, because I get this error:
0(17038) ERROR: pg_con.c:164: postgres:new_connection: fe_sendauth: no password supplied
0(17038) ERROR:domain:connect_db: Unable to connect database postgres://pupeno@127.0.0.1/ser

Module

by Kuehner on Thursday 23 of June, 2005 [12:32:07 UTC]
Where can I get the postgresql-module. I can't find it anywhere...

where is postgres.so?

by Joe Prosser on Monday 20 of September, 2004 [03:38:12 UTC]
It doesn't appear to be in the latest dist (for linux at least)

Complete migration?

by dfilion on Thursday 16 of September, 2004 [22:33:30 UTC]
Is it possible to completely migrate SER to PostgreSQL?
Edit

ser 0.8.14

by Anonymous on Monday 16 of August, 2004 [22:26:22 UTC]
(:exclaim:) Do you have the script for creating tables with PostgreSQL using ser version 0.8.14???

Please update this page with new information, just login and click on the "Edit" or "Add Comment" button above. Get a free login here: Register Thanks! - support@voip-info.org

Page Changes | Comments

Sponsored by:
Terms of Service Privacy Policy
© 2003-2008 VOIP-Info.org LLC

Powered by bitweaver