Greetings,

I'm currently attempting to install ser 0.8.14 on FreeBSD 4.10 with mysql 4.0.18 installed. The server has a single ethernet interface.

Previously, ser 0.8.12 from /usr/ports/net/ser was running flawlessly, but was lacking several features and didn't do things I wanted.

SO i've tried upgrading (and failed) by installing:

ser-0.8.14_src.tar.gz ser-0.8.14_freebsd_i386.tar.gz

and even cvs version via 'cvs co -r rel_0_8_14 sip_router'

Everything compiles without any error (not counting *.d warnings):

gmake all gmake install

then it's required to

ln -s /usr/local/lib/mysql/libmysqlclient.so.12 /usr/local/lib/mysql/libmysqlclient.so.10,

as the ser's mysql.so module is looking for .so.10 version.

The problem is that the moment i enable mysql module by adding/uncommenting this in the default ser.cfg:

loadmodule "/usr/local/lib/ser/modules/mysql.so" loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so"

modparam("usrloc","db_mode", 1) modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "password_column", "password")

optionally adding: modparam("auth_db", "db_url","mysql://ser:heslo@localhost/ser")

SER fails to load: ---

sip# ser -E Listening on 195.250.77.70 [195.250.77.70]:5060 Aliases: sip.arminco.com:5060 sip:5060 195.250.77.70:* sip# stateless - initializing Maxfwd module- initializing 0(71635) mod_init(): Database connection opened successfuly 0(0) INFO: udp_init: SO_RCVBUF is initially 41600 0(0) INFO: udp_init: SO_RCVBUF is finally 231936 5(71640) INFO: fifo process starting: 71640 2(71637) 3(71638) 4(71639) 1(71636) connect_db(): No enough memory connect_db(): No enough memory connect_db(): No enough memory connect_db(): No enough memory 2(71637) 3(71638) 4(71639) 5(71640) 1(71636) db_init(): Error while trying to connect database db_init(): Error while trying to connect database db_init(): Error while trying to connect database connect_db(): No enough memory db_init(): Error while trying to connect database 2(71637) 3(71638) 4(71639) 5(71640) 1(71636) auth_db:init_child(): Unable to connect database auth_db:init_child(): Unable to connect database auth_db:init_child(): Unable to connect database db_init(): Error while trying to connect database auth_db:init_child(): Unable to connect database 2(71637) 3(71638) 4(71639) 5(71640) 1(71636) init_mod_child(): Error while initializing module auth_db init_mod_child(): Error while initializing module auth_db init_mod_child(): Error while initializing module auth_db auth_db:init_child(): Unable to connect database init_mod_child(): Error while initializing module auth_db 2(71637) 3(71638) 4(71639) 5(71640) 1(71636) init_child failed init_child failed init_child failed init_mod_child(): Error while initializing module auth_db init_child failed 5(71640) 3(71638) 4(71639) 5(71640) 1(71636) 2(71637) INFO: signal 15 received INFO: signal 15 received INFO: signal 15 received INFO: signal 15 received INFO: signal 15 received INFO: signal 15 received --

If I disable mysql by 'modparam("usrloc","db_mode", 0)', it runs without it ok. I've tried compiling with gcc-3.2, tried compiling mysql 4.0.18/4.0.20 manually, tried binary distrib from www.mysql.com, same error message.

So is this a known mysql/auth_db bug and is there a solution for it?

-- With best regards, Vahan Yerkanian ARMINCO Global Telecom