maybe there is another module that uses the default db_url -> check all
the module you are using to see if they have a db_url param; if so, set
it according to your DB setup.
(hint: in the logs, after the access error, you may get some following
logs about the module that failed to init).
Regards,
Bogdan
brianpocock wrote:
> Right, I realised I was missing these parameters from the config:
>
> modparam("auth_db", "db_url","mysql://root:passw...@localhost/opensips")
> modparam("auth_db", "load_credentials", "")
>
> So I've added those and all the auth_db parameters are:
> modparam("auth_db", "calculate_ha1", yes)
> modparam("auth_db", "password_column", "password")
> modparam("auth_db", "db_url","mysql://root:brian...@localhost/opensips")
> modparam("auth_db", "load_credentials", "")
>
> The guide on the OpenSIPS website tells me to uncomment these lines:
> if (is_method("REGISTER"))
> {
> # authenticate the REGISTER requests (uncomment to enable auth)
> if (!www_authorize("", "subscriber"))
> {
> www_challenge("", "0");
> exit;
> }
> }
>
> Which I have done and now when starting it there is this error in
> /var/log/messages:
> ERROR:db_mysql:db_mysql_connect: driver error(1045): Access denied for user
> 'opensips'@'localhost' (using password: YES)
>
> which I think is whats probably causing it. I have set the username and
> password in the opensipsctlrc file, content of this file minus the comments
> is shown below:
> SIP_DOMAIN=192.168.1.2
> DBENGINE=MYSQL
> DBHOST=localhost
> DBNAME=opensips
> DBRWUSER=root
> DBRWPW="password"
> DBROUSER=root
> DBROPW=password
> DBROOTUSER="root"
> USERCOL="username"
> INSTALL_EXTRA_TABLES=ask
> INSTALL_PRESENCE_TABLES=ask
> ALIASES_TYPE="DB"
> CTLENGINE="FIFO"
> OSIPS_FIFO="/tmp/opensips_fifo"
> PID_FILE=/var/run/opensips.pid
> (passwords have been changed)
>
> Where is it getting user 'opensips'@'localhost' (using password: YES) from?
> or am i going completely wrong here?
>
> Thanks for all the help!
>
>
--
Bogdan-Andrei Iancu
www.voice-system.ro
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
