8 Mar
2006
8 Mar
'06
6:37 p.m.
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.
--
-------------------------------
David Castro Mosquera
Adianta
Tel: (34) 902 999 178
Fax: (34) 902 501 437
Email: david.castro(a)adianta.net
Web: www.adianta.net
-------------------------------
8 Mar
8 Mar
6:45 p.m.
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?
Search for another db_url line in your config. There is obviously one
still there with the default settings.
Hope this helps.
--
-Barry Flanagan
7:20 p.m.
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.
6841
days inactive
6841
days old
2 comments
3 participants
participants (3)
-
Barry Flanagan -
david.castro -
Norman Brandinger