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