Hi Sandra, and the others,
I found the solution to my pbm, in a previous test configuration I commented the modparam
for acc module, if you look at the syslog in my previous message, the error is related to
the loading of the acc module looking for the default password cause I forgot to set the
modparam (in fact the conf is commented).
For those who have pbm with sql password take a deeper look (than me) to the syslog
message.
Thanks for this great user list, and sorry for the kiddy pbm :)
Rodrigue
-----Message d'origine-----
De : sandrad(a)tid.es [mailto:sandrad@tid.es]
Envoyé : mardi 5 juillet 2005 11:12
À : Rodrigue ESTEVE
Objet : Re: [Serusers] Mysql with a different password than heslo
Hi Rodrigue!
I've change tha pass too, and in the cfg I only specify the param of usrloc:
modparam("usrloc", "db_url",
"sql://ser:newpass@localhost/ser")
And its run ok, This and the param of msilo.
Rodrigue ESTEVE escribió:
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
------------------------------------------------------------------------
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
Sandra Donaire Arroyo
Telefónica I+D
División de "Tecnologías de acceso a redes IP"