[Serusers] remote mysql server

[Barry Murphy]

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


----- Original Message -----
From: "Klaus Darilion" <klaus.mailinglists at pernau.at>
To: "Barry Murphy" <barry at unix.co.nz>
Cc: <serusers at lists.iptel.org>
Sent: Wednesday, March 09, 2005 8:15 PM
Subject: Re: [Serusers] remote mysql server


> wrong syntax!
>
> modparam("domain","db_url","mysql://ser:heslo@localhost/ser")
>
> // is missing
>
> regards,
> klaus
>
>
> Barry Murphy wrote:
>
> > I'm trying to get SER to talk to a remtoe DB, I notice other people in
#SER
> > on FreeNode also have this issue, but no one has a fix.
> >
> > I'm using the following in the config:
> > modparam("usrloc|acc|auth_db|group|msilo", "db_url",
> > "mysql::asterisk:passwd at dbserver/ser")
> >
> > Ser seems to be looking at /tmp/mysql.sock instead of the remote mysql
> > server.
> >
> > Has anyone got this working?
> >
> > Thanks
> > Barry
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
> >
> >
>