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