9 Dec
2007
9 Dec
'07
5:36 a.m.
Hi,
After moving a working openser config for trunk to a new server, and
updating the sources, I kept getting the error:
ERROR:mysql:db_mysql_new_connection: driver error: Access denied for user
'openserro'@'localhost' (using password: YES)
I double-checked, and the settings in:
/usr/local/etc/openser/openserctlrc
were set correct:
DBROPW=newpassword
So I set the mysql password for openserro back to the default 'openserro'
in mysql, and it works, even with a different value in openserctlrc.
Is this a known issue, bug, or am I doing something wrong?
Richard.
10 Dec
10 Dec
6:39 a.m.
On Sunday 09 December 2007, Richard Bennett wrote:
Hi,
After moving a working openser config for trunk to a new server, and
updating the sources, I kept getting the error:
ERROR:mysql:db_mysql_new_connection: driver error: Access denied for user
'openserro'@'localhost' (using password: YES)
I double-checked, and the settings in:
/usr/local/etc/openser/openserctlrc
were set correct:
DBROPW=newpassword
So I set the mysql password for openserro back to the default 'openserro'
in mysql, and it works, even with a different value in openserctlrc.
Is this a known issue, bug, or am I doing something wrong?
Hi Richard,
the setting in the openserctlrc file is only used for database setup and the
control script 'openserctl'. You need also set this password in the
openser.cfg for the server, for each module that needs to use the connection.
Do you have defined the 'db_url' parameter with the new password in your
config file?
If this is not the error, please post more from the server logs. What module
don't work for you?
Cheers,
Henning
2:30 p.m.
On Mon, 10 Dec 2007 12:39:09 +0100, Henning Westerholt
<henning.westerholt(a)1und1.de> wrote:
Thanks for clearing that up.
I
double-checked, and the settings in:
/usr/local/etc/openser/openserctlrc
were set correct:
DBROPW=newpassword
So I set the mysql password for openserro back to the default
'openserro'
in mysql, and it works, even with a different value in openserctlrc.
Is this a known issue, bug, or am I doing something wrong?
Hi Richard,
the setting in the openserctlrc file is only used for database setup and
the
control script 'openserctl'. You need also set this password in the
openser.cfg for the server, for each module that needs to use the
connection.
Do you have defined the 'db_url' parameter with the new password in your
config file?
Yes, and it is using the mysql user 'openser', not
'openserro' which is
the one causing the error.
Maybe a module uses openserro:openserro by default if you don't specify
otherwise...
I'll check the docs. I'm using these modules, in case anyone knows by
heart.
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
loadmodule "registrar.so"
loadmodule "textops.so"
loadmodule "mi_fifo.so"
loadmodule "xlog.so"
loadmodule "alias_db.so"
loadmodule "acc.so"
loadmodule "nathelper.so"
loadmodule "uri.so"
loadmodule "avpops.so"
loadmodule "siptrace.so"
Thanks for your reply,
Richard.
11 Dec
11 Dec
6:19 a.m.
On Monday 10 December 2007, Richard Bennett wrote:
All modules uses either the 'openser' or 'openserro' user with their
default
passwords, if no db_url is specified. This was changed from 1.2.
Check the error message in your log file, this should give you the module name
that could not access the db.
Cheers,
Henning
[..]
the setting in the openserctlrc file is only used for database setup and
the
control script 'openserctl'.
Thanks for clearing that up.
You need also set this password in the
openser.cfg for the server, for each module that needs to use the
connection.
Do you have defined the 'db_url' parameter with the new password in your
config file?
Yes, and it is using the mysql user 'openser', not 'openserro' which is
the one causing the error.
Maybe a module uses openserro:openserro by default if you don't specify
otherwise...
I'll check the docs. I'm using these modules, in case anyone knows by
heart.
6032
days inactive
6034
days old
3 comments
2 participants
participants (2)
-
Henning Westerholt -
Richard Bennett