On Monday 16 March 2009, Sara EL KABIRI wrote:
Thanks.
I have already logged on to the mysql server and granted all the privileges
to the user that was being rejected at kamailio's database
authentication... And i still get the same error.
Hi Sara,
have you tried to login with the 'mysql' console client using the same
credentials as in the configuration? MySQL is sometimes a bit picky with the
hostnames..
What i don't understand is that in
Kamailio's config file, whether i set
the db_url parameter to the "root" user or to the "openser" one:
*modparam("uri_db", "db_url",
"mysql://root:<password>@localhost/openser")*
or
*modparam("uri_db", "db_url", "mysql://openser:<password>
@localhost/openser")*
i get indifferently "*Access denied for user 'openser'@'localhost'
(using
password: YES)*".
Perhaps you've some modules without a modparam statement that configures a
db_url in your cfg. They will then use the default credentials which
are 'openser' and a default password. I noticed in the logs that the usrloc
module fails for example, do you've a db_url for this module too?
from the previous logs, seems that the module with problems is usrloc -
check if db_url for that module is set properly.
Cheers,
Daniel
--
Daniel-Constantin Mierla