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?
Cheers,
Henning