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.
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
On Mon, 10 Dec 2007 12:39:09 +0100, Henning Westerholt henning.westerholt@1und1.de wrote:
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'.
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.
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.
On Monday 10 December 2007, Richard Bennett wrote:
[..] 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.
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
-
Henning Westerholt -
Richard Bennett