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:[EMAIL PROTECTED]/openser' not found in pool Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Opening MySQL connection: mysql://openser:[EMAIL PROTECTED]/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:[EMAIL PROTECTED]/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 > > [email protected] > > http://openser.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
