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
Show replies by date