[Serusers] Pbm Solved :Mysql with a different password than heslo

[Rodrigue ESTEVE]

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 at tid.es [mailto:sandrad at 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 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
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Serusers mailing list
>serusers at 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"

-------------- 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/20050705/ceb07f3e/attachment.bin>