[Users] OpenSER attempting local mysql connection

[Daniel-Constantin Mierla]

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
>
>