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

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: Sat 19 of Nov, 2005 (21:19 UTC) by bmacleod
Please update this page with new information, just login and click on the "Edit" or "Discussion" tab. Get a free login here: Register Thanks! - Find us on Google+