[Users] OpenSER attempting local mysql connection

[Rick Richardson]

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 at openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >