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