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.