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@pernau.at To: "Barry Murphy" barry@unix.co.nz Cc: serusers@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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers