[Users] Change default users and password in MySQL problems

[Norman Brandinger]

Hey David,

Maybe the following will help:

I created a file: /usr/local/etc/openser/.opensermysqlrc

In this file I have some overrides for MySQL for example:

PW="password"
DEFAULT_PW="default_password"
RW_PW="read_write_password"
RO_PW="read_only_password"

You might consider using overrides instead of updating openser_mysql.sh.

If you take a look at this document: 
http://openser.org/docs/scripting.html#id2457708 you will find an 
example of using M4 to override database usernames/passwords in  your 
configuration files.

It is important that the usernames/passwords you used to create the 
OpenSER database match exactly with the usernames/passwords you use in 
your configuration files.

We use phpMyAdmin over here as a GUI to look at what's going on with 
MySQL.  A review of the "privileges" section (within phpMyAdmin) might 
shed some light on your problem.

Regards,
Norm




david.castro wrote:
> Hello. I'm David.
>
> I'm working with openser 1.0.1 and MySQL 5.0.18.
> I'd like changing defaults users and passwords to openser talk to MySQL.
> I edited "openser_mysql.sh" and I changed some variables in that file. 
> I execute "openser_mysql.sh" and the database was created fine.
> I wrote next statment in openser.cfg:
> modparam("auth_db", "db_url", "mysql://user:pass@localhost/openser").
> Indeed user and pass are the same in mysql.
> I run openser but gives an error:
> 0(0) new_connection: Access denied for user 'openser'@'localhost' 
> (using password: YES)
>
> I don't have any user called openser in MySQL because I changed 
> "openser_mysql.sh".
> How I change the defaults users and passwords in openser?
>
> Thank you.
>