[DRE-maint] Bug#695774: redmine: fails to upgrade, says something about a pgsql_adapter

Jérémy Lal kapouer at melix.org
Fri Jan 11 18:52:40 UTC 2013


On 11/01/2013 17:12, Thorsten Glaser wrote:
> On Sun, 16 Dec 2012, Jérémy Lal wrote:
> 
>> I am working on a fix.
> 
> Any news? 

I'll try to make config script use the first generated
password if a second database user name is the same as a first
one. But i'm not sure i can even read the first password value.

> In the meantime, I tried to recover myself: look into
> /etc/redmine/default/database.yml what was used as
> password, connect as postgres to the DB and ALTER ROLE
> and set the redmine user’s password to that.
> 
> Doesn’t work ☹

well it should, so maybe only the md5 sum of the password
is recorded or something.
The problem if you do that is that dbconfig still
has another value for the password, so next time database.yml
is updated after reconfigure/update it will be populated
by a wrong value (but you will be prompted since it is a config
file).

You'd better try :
* dump db
* dpkg-reconfigure -plow redmine
  and ask for reinstallation of the database.

Jérémy.




More information about the Pkg-ruby-extras-maintainers mailing list