9 Mar
2005
9 Mar
'05
7:55 p.m.
should the protocol be mysql, not sql?
-----Original Message-----
From: serusers-bounces(a)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
----- Original Message -----
From: "Klaus Darilion" <klaus.mailinglists(a)pernau.at>
To: "Barry Murphy" <barry(a)unix.co.nz>
Cc: <serusers(a)lists.iptel.org>
Sent: Wednesday, March 09, 2005 8:15 PM
Subject: Re: [Serusers] remote mysql server
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers