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:[EMAIL PROTECTED]/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.
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
