9 Mar
2005
9 Mar
'05
11:50 p.m.
Yeah i added that, but still issues, if you're using mysql, could you copy
ur entire ser.cfg and post it to me offlist,
thanks
Barry
----- Original Message -----
From: "Zeus Ng" <zeus.ng(a)isquare.com.au>
To: "'Barry Murphy'" <barry(a)unix.co.nz>
Cc: <serusers(a)lists.iptel.org>
Sent: Thursday, March 10, 2005 11:26 AM
Subject: RE: [Serusers] remote mysql server
Looks like you haven't load the mysql module. In
your ser.cfg, add the
following line:
loadmodule "/path/to/your/ser/modules/mysql.so"
As for serctl, try the following:
_linux> SQL_DB=your_ser_db_name
_linux> SQL_HOST=your_db_host_name
_linux> SQL_USER=your_ser_db_user_name
_linux> export SQL_DB SQL_HOST SQL_USER
_linux> serctl ...
If that doesn't work, it may be a firewall issue. Make sure the db host
accepts tcp 3306 connection.
Zeus
>
-----Original Message-----
> From: serusers-bounces(a)lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org]
> On Behalf Of Barry Murphy
> Sent: Wednesday, March 09, 2005 8:39 AM
> To: Klaus Darilion
> Cc: serusers(a)lists.iptel.org
> Subject: Re: [Serusers] remote mysql server
>
> Ok, so I've tried just about everything, is SER just
built to work
> with
a
> local mysql server and not a remote one?
>
> ser.cfg:
> modparam("usrloc", "db_mode", 2)
>
> ## tried 1 ##
> modparam("usrloc",
"db_url","sql://ser:pwd@db.fast.co.nz/ser")
> ## /tried 1 ##
>
> ## tried 2 ##
> modparam("usrloc|acc|auth_db|group|msilo", "db_url",
> "sql://ser:pwd@db.fast.co.nz/ser")
> ## /tried 2 ##
>
>
> I get this error (seen from debug level):
> Maxfwd module- initializing
> 0(80209) DEBUG: init_mod: usrloc
> 0(80209) usrloc - initializing
> 0(80209) DEBUG: register_fifo_cmd: new command (ul_stats)
> registered
> 0(80209) DEBUG: register_fifo_cmd: new command (ul_rm) registered
> 0(80209) DEBUG: register_fifo_cmd: new command (ul_rm_contact)
registered
> 0(80209) DEBUG: register_fifo_cmd: new
command (ul_dump)
registered
> 0(80209) DEBUG: register_fifo_cmd: new
command (ul_flush)
> registered
> 0(80209) DEBUG: register_fifo_cmd: new command (ul_add)
registered
> 0(80209) DEBUG: register_fifo_cmd: new
command (ul_show_contact)
> registered
> 0(80209) find_export: <db_use_table> not found
> 0(80209) mod_init(): Can't bind database module
> 0(80209) init_mod(): Error while initializing module usrloc
>
> Thanks
> Barry
>
>