1 Dec
2005
1 Dec
'05
8:40 a.m.
I have openser.cgf pointing openser to use a remote database using this
line:
modparam("auth_db", "db_url",
"mysql://serusr:mypass@192.168.0.54/ser")
Upon initializing the auth_db module it seems to be insisting on
connecting locally (which fails) I compiled all the modules for mysql5
using the devel libs from the mysql official redhat enterprise rpms.
I can add/rem users to this remote database using openserctl.
When I start openser I get this output:
0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
Listening on
udp: 127.0.0.1 [127.0.0.1]:5060
udp: 192.168.0.52 [192.168.0.52]:5060
tcp: 127.0.0.1 [127.0.0.1]:5060
tcp: 192.168.0.52 [192.168.0.52]:5060
Aliases:
tcp: localhost:5060
tcp: localhost.localdomain:5060
tcp: amnesiac:5060
udp: localhost:5060
udp: localhost.localdomain:5060
udp: amnesiac:5060
stateless - initializing
0(0) Maxfwd module- initializing
textops - initializing
0(0) AUTH module - initializing
0(0) AUTH_DB module - initializing
0(0) new_connection: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
0(0) register_udomain(): Can not open database connection
0(0) domain_fixup(): Error while registering domain
ERROR: error -1 while trying to fix configuration
any ideas?
Rick
1 Dec
1 Dec
1:13 p.m.
Hello,
it seems that your mysql client is using a different socket than the one
the mysql server is listening to. You have to check mysql config file
and make sure that the socket files are the same. For more about the
mysql config, see:
http://dev.mysql.com/doc/refman/5.0/en/option-files.html
The "socket" in [client] section must be set to the same value as in
[mysqld] section.
Cheers,
Daniel
On 12/01/05 08:40, Rick Richardson wrote:
I have openser.cgf pointing openser to use a remote
database using this
line:
modparam("auth_db", "db_url",
"mysql://serusr:mypass@192.168.0.54/ser")
Upon initializing the auth_db module it seems to be insisting on
connecting locally (which fails) I compiled all the modules for mysql5
using the devel libs from the mysql official redhat enterprise rpms.
I can add/rem users to this remote database using openserctl.
When I start openser I get this output:
0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
Listening on
udp: 127.0.0.1 [127.0.0.1]:5060
udp: 192.168.0.52 [192.168.0.52]:5060
tcp: 127.0.0.1 [127.0.0.1]:5060
tcp: 192.168.0.52 [192.168.0.52]:5060
Aliases:
tcp: localhost:5060
tcp: localhost.localdomain:5060
tcp: amnesiac:5060
udp: localhost:5060
udp: localhost.localdomain:5060
udp: amnesiac:5060
stateless - initializing
0(0) Maxfwd module- initializing
textops - initializing
0(0) AUTH module - initializing
0(0) AUTH_DB module - initializing
0(0) new_connection: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
0(0) register_udomain(): Can not open database connection
0(0) domain_fixup(): Error while registering domain
ERROR: error -1 while trying to fix configuration
any ideas?
Rick
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
10:03 p.m.
I'm not sure that this is the case. I have a my.cnf but it is pointing
the client to the default (3306) port which is the same as the server.
The log entry that worries me is:
Dec 1 11:48:41 amnesiac openser: 0(0) db_init: Connection
'mysql://openser:openserrw@localhost/openser' not found in pool
Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Opening MySQL
connection: mysql://openser:openserrw@localhost/openser
Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Even though i have quite explicitly set the db_url to a remote machine
in the config, I have verified that there are no other openser.cfg's on
my system. Where else could this be getting its information?
On Thu, 2005-12-01 at 13:13 +0200, Daniel-Constantin Mierla wrote:
Hello,
it seems that your mysql client is using a different socket than the one
the mysql server is listening to. You have to check mysql config file
and make sure that the socket files are the same. For more about the
mysql config, see:
http://dev.mysql.com/doc/refman/5.0/en/option-files.html
The "socket" in [client] section must be set to the same value as in
[mysqld] section.
Cheers,
Daniel
On 12/01/05 08:40, Rick Richardson wrote:
> I have openser.cgf pointing openser to use a remote database using this
> line:
> modparam("auth_db", "db_url",
"mysql://serusr:mypass@192.168.0.54/ser")
>
> Upon initializing the auth_db module it seems to be insisting on
> connecting locally (which fails) I compiled all the modules for mysql5
> using the devel libs from the mysql official redhat enterprise rpms.
> I can add/rem users to this remote database using openserctl.
>
> When I start openser I get this output:
>
> 0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
> 0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
> Listening on
> udp: 127.0.0.1 [127.0.0.1]:5060
> udp: 192.168.0.52 [192.168.0.52]:5060
> tcp: 127.0.0.1 [127.0.0.1]:5060
> tcp: 192.168.0.52 [192.168.0.52]:5060
> Aliases:
> tcp: localhost:5060
> tcp: localhost.localdomain:5060
> tcp: amnesiac:5060
> udp: localhost:5060
> udp: localhost.localdomain:5060
> udp: amnesiac:5060
>
> stateless - initializing
> 0(0) Maxfwd module- initializing
> textops - initializing
> 0(0) AUTH module - initializing
> 0(0) AUTH_DB module - initializing
> 0(0) new_connection: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> 0(0) register_udomain(): Can not open database connection
> 0(0) domain_fixup(): Error while registering domain
> ERROR: error -1 while trying to fix configuration
>
> any ideas?
>
> Rick
>
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
11:32 p.m.
Just for kicks i hardcoded the remote mysql url into the config.h define
and recompiled and it worked beautfully. So I'm quite sure then that my
entry in the config file is incorrect, misplaced, or simply being
ignored by the corresponding module. It is currently my first modparam
entry in the config file, and it checks out okay according to the
openser -c, so i'm not sure what is going on.
On Thu, 2005-12-01 at 12:03 -0800, Rick Richardson wrote:
I'm not sure that this is the case. I have a
my.cnf but it is pointing
the client to the default (3306) port which is the same as the server.
The log entry that worries me is:
Dec 1 11:48:41 amnesiac openser: 0(0) db_init: Connection
'mysql://openser:openserrw@localhost/openser' not found in pool
Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Opening MySQL
connection: mysql://openser:openserrw@localhost/openser
Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Even though i have quite explicitly set the db_url to a remote machine
in the config, I have verified that there are no other openser.cfg's on
my system. Where else could this be getting its information?
On Thu, 2005-12-01 at 13:13 +0200, Daniel-Constantin Mierla wrote:
Hello,
it seems that your mysql client is using a different socket than the one
the mysql server is listening to. You have to check mysql config file
and make sure that the socket files are the same. For more about the
mysql config, see:
http://dev.mysql.com/doc/refman/5.0/en/option-files.html
The "socket" in [client] section must be set to the same value as in
[mysqld] section.
Cheers,
Daniel
On 12/01/05 08:40, Rick Richardson wrote:
> I have openser.cgf pointing openser to use a remote database using this
> line:
> modparam("auth_db", "db_url",
"mysql://serusr:mypass@192.168.0.54/ser")
>
> Upon initializing the auth_db module it seems to be insisting on
> connecting locally (which fails) I compiled all the modules for mysql5
> using the devel libs from the mysql official redhat enterprise rpms.
> I can add/rem users to this remote database using openserctl.
>
> When I start openser I get this output:
>
> 0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
> 0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
> Listening on
> udp: 127.0.0.1 [127.0.0.1]:5060
> udp: 192.168.0.52 [192.168.0.52]:5060
> tcp: 127.0.0.1 [127.0.0.1]:5060
> tcp: 192.168.0.52 [192.168.0.52]:5060
> Aliases:
> tcp: localhost:5060
> tcp: localhost.localdomain:5060
> tcp: amnesiac:5060
> udp: localhost:5060
> udp: localhost.localdomain:5060
> udp: amnesiac:5060
>
> stateless - initializing
> 0(0) Maxfwd module- initializing
> textops - initializing
> 0(0) AUTH module - initializing
> 0(0) AUTH_DB module - initializing
> 0(0) new_connection: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> 0(0) register_udomain(): Can not open database connection
> 0(0) domain_fixup(): Error while registering domain
> ERROR: error -1 while trying to fix configuration
>
> any ideas?
>
> Rick
>
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
2 Dec
2 Dec
6:53 a.m.
The problem is that you have not set the db_url parameter for usrloc
module (you have set db_mode 2 which requires database connection).The
default value is pointing to the localhost database server.
When the database server is on localhost then the client tries to
connect via unix socket files, not via net sockets.
Cheers,
Daniel
On 12/01/05 23:32, Rick Richardson wrote:
Just for kicks i hardcoded the remote mysql url into
the config.h define
and recompiled and it worked beautfully. So I'm quite sure then that my
entry in the config file is incorrect, misplaced, or simply being
ignored by the corresponding module. It is currently my first modparam
entry in the config file, and it checks out okay according to the
openser -c, so i'm not sure what is going on.
On Thu, 2005-12-01 at 12:03 -0800, Rick Richardson wrote:
I'm not sure that this is the case. I have a
my.cnf but it is pointing
the client to the default (3306) port which is the same as the server.
The log entry that worries me is:
Dec 1 11:48:41 amnesiac openser: 0(0) db_init: Connection
'mysql://openser:openserrw@localhost/openser' not found in pool
Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Opening MySQL
connection: mysql://openser:openserrw@localhost/openser
Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Even though i have quite explicitly set the db_url to a remote machine
in the config, I have verified that there are no other openser.cfg's on
my system. Where else could this be getting its information?
On Thu, 2005-12-01 at 13:13 +0200, Daniel-Constantin Mierla wrote:
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
Hello,
it seems that your mysql client is using a different socket than the one
the mysql server is listening to. You have to check mysql config file
and make sure that the socket files are the same. For more about the
mysql config, see:
http://dev.mysql.com/doc/refman/5.0/en/option-files.html
The "socket" in [client] section must be set to the same value as in
[mysqld] section.
Cheers,
Daniel
On 12/01/05 08:40, Rick Richardson wrote:
> I have openser.cgf pointing openser to use a remote database using this
> line:
> modparam("auth_db", "db_url",
"mysql://serusr:mypass@192.168.0.54/ser")
>
> Upon initializing the auth_db module it seems to be insisting on
> connecting locally (which fails) I compiled all the modules for mysql5
> using the devel libs from the mysql official redhat enterprise rpms.
> I can add/rem users to this remote database using openserctl.
>
> When I start openser I get this output:
>
> 0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
> 0(3076) WARNING: fix_socket_list: could not rev. resolve 192.168.0.52
> Listening on
> udp: 127.0.0.1 [127.0.0.1]:5060
> udp: 192.168.0.52 [192.168.0.52]:5060
> tcp: 127.0.0.1 [127.0.0.1]:5060
> tcp: 192.168.0.52 [192.168.0.52]:5060
> Aliases:
> tcp: localhost:5060
> tcp: localhost.localdomain:5060
> tcp: amnesiac:5060
> udp: localhost:5060
> udp: localhost.localdomain:5060
> udp: amnesiac:5060
>
> stateless - initializing
> 0(0) Maxfwd module- initializing
> textops - initializing
> 0(0) AUTH module - initializing
> 0(0) AUTH_DB module - initializing
> 0(0) new_connection: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> 0(0) register_udomain(): Can not open database connection
> 0(0) domain_fixup(): Error while registering domain
> ERROR: error -1 while trying to fix configuration
>
> any ideas?
>
> Rick
>
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
6930
days inactive
6931
days old
4 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Rick Richardson