[Serusers] Mysql with a different password than heslo

[Rodrigue ESTEVE]

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

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050704/5f693434/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3026 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050704/5f693434/attachment.bin>