Hi all,

I’ve got a pbm using mysql with ser 0.9.3 when I set a password different from the default passwd heslo for ser user.

When using the default password configuration and the ser_mysql.sh script, I’ve got no pbm. I can use the localhost database and even a database started on another proxy with a different password than heslo (heslo2), using the settings below in ser.cfg:

fifo_db_url="mysql://ser2:heslo2@172.30.30.104/ser2"

modparam("auth_db|uri_db|usrloc", "db_url", "mysql://ser2:heslo2@172.30.30.104/ser2")

But when I modify the ser_mysql.sh to use a different password than heslo (heslo 2 for example, see below), ser does not start using:

fifo_db_url="mysql://ser:heslo2@localhost/ser"

modparam("auth_db|uri_db|usrloc", "db_url", "mysql://ser:heslo2@localhost/ser").

Moreover I’m now unable to log to the database loaded on the other proxy (172.30.30.104) using the first configuration above.

When using mysql –h localhost –u ser –p  and using the new password, I can connect to the database.

The syslog shows this when trying with a different password:

Jul  4 18:56:34 sip /sbin/ser[7155]: new_connection(): Access denied for user: 'ser@localhost' (Using password: YES)

Jul  4 18:56:34 sip /sbin/ser[7155]: db_init(): Could not create a connection

Jul  4 18:56:34 sip /sbin/ser[7155]: ERROR: acc_db_init: unable to connect to the database

Jul  4 18:56:34 sip /sbin/ser[7155]: init_mod_child(): Error while initializing module acc

Jul  4 18:56:34 sip /sbin/ser[7155]: init_child failed

Jul  4 18:56:34 sip /sbin/ser[7155]: WARNING: destroy_fifo: cannot delete fifo (/tmp/ser_fifo): No such file or directory

Does somebody can help me; I’m trying to get this working without success.

Thanks a lot,

Rodrigue