[Serusers] SER connection to Postgres

[Johan Landerholm]

Hi,

I'm configuring SER to get subscriber information from a Postgres database.
When I start the ser server, ser crashes with the following error message:
PG[144] connect_db FATAL:  sorry, too many clients already
PG[248] db_init Error while trying to open database, FATAL
auth_db:init_child(): Unable to connect database
init_mod_child(): Error while initializing module auth_db
init_child failed

My postgres config file allows for 50 clients to connect and I have no
other applications running on Postgres. It does not matter if I change the
max_connections to anything between 30-100. Same error.

My ser.cfg (database bits...) looks like:

loadmodule "/usr/local/lib/ser/modules/group.so"
loadmodule "/usr/local/lib/ser/modules/postgres.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
modparam("auth_db", "password_column", "password")
modparam("auth_db", "calculate_ha1", yes)
modparam("usrloc","user_column","user_id")
modparam("usrloc","db_url",
         "sql://seruser:seruserpass@localhost:5432/ser")
modparam("group","user_column","user_id")
modparam("group","db_url",
         "sql://seruser:seruserpass@localhost:5432/ser")
modparam("auth_db","user_column","user_id")
modparam("auth_db","db_url",
         "sql://seruser:seruserpass@localhost:5432/ser")

Has anyone got this config working for ser-0.8.14 and Postgres 7.4.3 ?

Best regards,
Johan Landerholm