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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers