9 Mar
2005
9 Mar
'05
3:54 a.m.
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
9 Mar
9 Mar
8:15 a.m.
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
9:29 a.m.
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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
2:13 p.m.
set your mysql environment variable
On Wed, 09 Mar 2005 21:29:28 +1300, Barry Murphy <barry(a)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(a)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:
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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
7:09 p.m.
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(a)gmail.com>
To: "Barry Murphy" <barry(a)unix.co.nz>
Cc: "Klaus Darilion" <klaus.mailinglists(a)pernau.at>at>;
<serusers(a)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(a)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(a)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:
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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
7:44 p.m.
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.
--
/Scoundrel
7:56 p.m.
----- Original Message -----
From: "Alexey N. Kovyrin @ Home" <alexey(a)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
7:39 p.m.
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
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
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
7:57 p.m.
----- Original Message -----
From: "Richard" <richard(a)o-matrix.org>
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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(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
>
>
> > 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
11:26 p.m.
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(a)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(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
>
>
11:50 p.m.
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(a)isquare.com.au>
To: "'Barry Murphy'" <barry(a)unix.co.nz>
Cc: <serusers(a)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(a)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(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
>
>
7208
days inactive
7208
days old
11 comments
6 participants
participants (6)
-
Alexey N. Kovyrin ＠ Home -
Barry Murphy -
Klaus Darilion -
Patrick Baker -
Richard -
Zeus Ng