[Serusers] trouble running 0.8.14 on FreeBSD 4.10 with mysql module enabled

[Vahan Yerkanian]

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