[Serusers] remote mysql server

[Zeus Ng]

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 at lists.iptel.org 
> [mailto:serusers-bounces at lists.iptel.org] 
> > > On Behalf Of Barry Murphy
> > > Sent: Wednesday, March 09, 2005 8:39 AM
> > > To: Klaus Darilion
> > > Cc: serusers at 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
> > >
> > >
>