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
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
I still get:
root@wix:/usr/local/etc/ser# serctl acl show ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I'm connecting to a DB on a remote mysql server remember.
Barry
-----Original Message----- From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] Sent: Wednesday, 9 March 2005 8:16 p.m. To: Barry Murphy Cc: serusers@lists.iptel.org 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
set your mysql environment variable
On Wed, 09 Mar 2005 21:29:28 +1300, Barry Murphy barry@unix.co.nz wrote:
I still get:
root@wix:/usr/local/etc/ser# serctl acl show ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I'm connecting to a DB on a remote mysql server remember.
Barry
-----Original Message----- From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] Sent: Wednesday, 9 March 2005 8:16 p.m. To: Barry Murphy Cc: serusers@lists.iptel.org 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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Could you explain a little more, i.e. export MYSQL="host.of.db.co.nz"
With bsd, does this go into the user SER's .profile?
Thanks Barry
----- Original Message ----- From: "Patrick Baker" patricksbaker@gmail.com To: "Barry Murphy" barry@unix.co.nz Cc: "Klaus Darilion" klaus.mailinglists@pernau.at; serusers@lists.iptel.org Sent: Thursday, March 10, 2005 2:13 AM Subject: Re: [Serusers] remote mysql server
set your mysql environment variable
On Wed, 09 Mar 2005 21:29:28 +1300, Barry Murphy barry@unix.co.nz wrote:
I still get:
root@wix:/usr/local/etc/ser# serctl acl show ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I'm connecting to a DB on a remote mysql server remember.
Barry
-----Original Message----- From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] Sent: Wednesday, 9 March 2005 8:16 p.m. To: Barry Murphy Cc: serusers@lists.iptel.org 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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Barry Murphy wrote:
still get:
root@wix:/usr/local/etc/ser# serctl acl show ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I'm connecting to a DB on a remote mysql server remember.
AFAIK, serctl doesn't looks into ser.cfg file for mysql params. Params are stored directly in serctl script file. serctl acl show - in that case, not reads ser.cfg, but constructs sql qurery and calls for external mysql binary.
----- Original Message ----- From: "Alexey N. Kovyrin @ Home" alexey@home.kovyrin.net
AFAIK, serctl doesn't looks into ser.cfg file for mysql params. Params are stored directly in serctl script file. serctl acl show - in that case, not reads ser.cfg, but constructs sql qurery and calls for external mysql binary.
Ok this doesn't bother me, I can install SER on our DB server and just use the serctl from the local server.
I guess now my issue is getting the ser.cfg to connect to the remote DB so I can start SER.
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
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
should the protocol be mysql, not sql?
-----Original Message----- From: serusers-bounces@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@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@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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
----- Original Message ----- From: "Richard" richard@o-matrix.org
should the protocol be mysql, not sql?
Sorry I forgot to mention, I have tried both, I thought I had put that in, but obviously not :)
-----Original Message----- From: serusers-bounces@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@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@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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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@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@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
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@isquare.com.au To: "'Barry Murphy'" barry@unix.co.nz Cc: serusers@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@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@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
-
Alexey N. Kovyrin ＠ Home -
Barry Murphy -
Klaus Darilion -
Patrick Baker -
Richard -
Zeus Ng