[Kamailio-Users] Problem starting Kamailio

[Henning Westerholt]

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