[DRE-maint] Bug#684067: redmine postgresql backend fails in redmine clean instalation (whatever version 1.4.3, 1.4.4 or 1.4.2)

PICCORO McKAY Lenz mckaygerhard at gmail.com
Mon Aug 6 17:09:26 UTC 2012


Package: redmine
Version: 1.4.4+dfsg1-1
Justification: renders package unusable
Severity: grave

When i install or upgrade redmine (whatever clen or not environment or
server debian)
with postgresql backend didint finally install and get this error:

Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)
Error when running rake db:migrate, check database configuration.
exit: 295: Illegal number: -1

i installed to clean env 1.4.3 redmine and failts with same error, but
i not have any plugin extra, and i used pgsql backend.. it faild with
others backend but sqlite not fail...

this bug are present since 1.4.3 and on some rare cisrcunstances on
1.4.2 too, its permanent and in redmine 1.4.4

this its seriously... i market grave and render package unusable due
only works if i used mysql or postgres
also works with mariadb inclusively!!!! but not using dbconfig common
with postgres..

I ATTACHED DEBIAN SYSTEM INFO FOR THE TWO CASES with postgres when
fail and for mysql that install perfectly

later i'l try install in varios king of environment and for sqlite or
mysql not fail, only postgresql backend fails, it seem to be a bad
username/password due in installation configuration do not ask for
postgresql admin's password..

my postgresql configuration permit and trust the user admindb

Complete error at instalation its:

Configuring redmine-pgsql (1.4.4+dfsg1-1) ...
Configuring redmine (1.4.4+dfsg1-1) ...
dbconfig-common: writing config to
/etc/dbconfig-common/redmine/instances/default.conf
Creating config file
/etc/dbconfig-common/redmine/instances/default.conf with new version
Creating config file /etc/redmine/default/database.yml.new with new version
creating postgres user redmine:  success.
verifying creation of user: success.
creating database redmine_default: success.
verifying database redmine_default exists: success.
dbconfig-common: flushing administrative password
Creating config file /etc/redmine/default/database.yml with new version
NOTE: Gem.source_index is deprecated, use Specification. It will be
removed on or after 2011-11-01.
Gem.source_index called from
/usr/share/redmine/config/../vendor/rails/railties/lib/rails/gem_dependency.rb:21.
Please install RDoc 2.4.2+ to generate documentation.
Creating config file /etc/redmine/default/session.yml with new version
A new secret session key has been generated in /etc/redmine/default/session.yml
Populating database for redmine instance "default".
This may take a while.
NOTE: Gem.source_index is deprecated, use Specification. It will be
removed on or after 2011-11-01.
Gem.source_index called from
/usr/share/redmine/config/../vendor/rails/railties/lib/rails/gem_dependency.rb:21.
Please install RDoc 2.4.2+ to generate documentation.
rake aborted!
Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)
Error when running rake db:migrate, check database configuration.
exit: 295: Illegal number: -1
dpkg: error al procesar redmine (--configure):
 el subproceso instalado el script post-installation devolvió el
código de salida de error 2


THERE's REPORT SYSTEMWITH POSTGRESQL PACKAGE:

-- System Information:
Debian Release: 6.0.3
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.39-bpo.2-686-pae (SMP w/2 CPU cores)
Locale: LANG=es_VE.UTF-8, LC_CTYPE=es_VE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages redmine depends on:
ii  bundler              1.1.3-1             Manage Ruby application dependenci
ii  dbconfig-common      1.8.46              common framework for packaging dat
ii  debconf [debconf-2.0 1.5.36.1            Debian configuration management sy
ii  redmine-pgsql        1.4.4+dfsg1-1 metapackage providing MySQL depend
ii  ruby                 4.5                 An interpreter of object-oriented
ii  ruby-coderay         1.0.6-1         Venenux Ruby library for syntax hi
ii  ruby-fastercsv       1.5.5-1         Complete replacement to the CSV st
ii  ruby-net-ldap        0.3.1-1         LDAP client library for Ruby
ii  ruby-rack            1.4.1-1         Modular Ruby webserver interface
ii  ruby-rails-2.3       2.3.14-2      MVC ruby based framework geared fo

Versions of packages redmine recommends:
ii  libopenid-ruby [ruby-o 2.1.8debian-1 Ruby library for verifying and ser
ii  ruby-rmagick           2.13.1-5    ImageMagick API for Ruby (document

Versions of packages redmine suggests:
ii  subversion           1.6.18dfsg-1vnzsqe1 Advanced version control system in

  redmine/instances/default/password-confirm: (password omitted)
  redmine/instances/default/mysql/admin-pass: (password omitted)
  redmine/instances/default/app-password-confirm: (password omitted)
  redmine/instances/default/mysql/app-pass: (password omitted)
  redmine/instances/default/pgsql/admin-pass: (password omitted)
  redmine/instances/default/pgsql/app-pass: (password omitted)
  redmine/instances/default/passwords-do-not-match:
  redmine/instances/default/remote/newhost:
  redmine/instances/default/db/basepath:
  redmine/instances/default/pgsql/changeconf: false
  redmine/instances/default/missing-db-package-error: abort
  redmine/default-language: ${defaultLocale}
  redmine/instances/default/pgsql/no-empty-passwords:
  redmine/instances/default/pgsql/method: unix socket
* redmine/instances/default/database-type: pgsql
  redmine/instances/default/pgsql/manualconf:
  redmine/instances/default/pgsql/authmethod-admin: ident
  redmine/instances/default/pgsql/admin-user: postgres
  redmine/missing-redmine-package:
  redmine/instances/default/pgsql/authmethod-user: password
  redmine/instances/default/dbconfig-reinstall: false
  redmine/instances/default/db/app-user: redmine
  redmine/instances/default/default-language: es
  redmine/notify-migration:
  redmine/old-instances:
  redmine/instances/default/upgrade-error: abort
  redmine/instances/default/db/dbname: redmine_default
  redmine/instances/default/purge: false
  redmine/current-instances: default
  redmine/instances/default/remote/host:
  redmine/instances/default/dbconfig-upgrade: true
  redmine/instances/default/internal/reconfiguring: false
  redmine/instances/default/upgrade-backup: true
  redmine/instances/default/install-error: abort
  redmine/instances/default/mysql/admin-user: root
  redmine/instances/default/mysql/method: unix socket
  redmine/instances/default/internal/skip-preseed: false
  redmine/instances/default/remove-error: abort
  redmine/instances/default/dbconfig-remove:
  redmine/instances/default/remote/port:
* redmine/instances/default/dbconfig-install: true

THERE's REPORT SYSTEM WITH MYSQL/MARIADB PACKAGE:


-- System Information:
Debian Release: 6.0.3
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.39-bpo.2-686-pae (SMP w/2 CPU cores)
Locale: LANG=es_VE.UTF-8, LC_CTYPE=es_VE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages redmine depends on:
ii  bundler              1.1.3-1             Manage Ruby application dependenci
ii  dbconfig-common      1.8.46              common framework for packaging dat
ii  debconf [debconf-2.0 1.5.36.1            Debian configuration management sy
ii  redmine-mysql        1.4.4+dfsg1-1 metapackage providing MySQL depend
ii  ruby                 4.5                 An interpreter of object-oriented
ii  ruby-coderay         1.0.6-1         Venenux Ruby library for syntax hi
ii  ruby-fastercsv       1.5.5-1         Complete replacement to the CSV st
ii  ruby-net-ldap        0.3.1-1         LDAP client library for Ruby
ii  ruby-rack            1.4.1-1         Modular Ruby webserver interface
ii  ruby-rails-2.3       2.3.14-2      MVC ruby based framework geared fo

Versions of packages redmine recommends:
ii  libopenid-ruby [ruby-o 2.1.8debian-1 Ruby library for verifying and ser
ii  ruby-rmagick           2.13.1-5    ImageMagick API for Ruby (document

Versions of packages redmine suggests:
ii  subversion           1.6.18dfsg-1vnzsqe1 Advanced version control system in

-- debconf information:
  redmine/instances/default/password-confirm: (password omitted)
  redmine/instances/default/mysql/admin-pass: (password omitted)
  redmine/instances/default/app-password-confirm: (password omitted)
  redmine/instances/default/mysql/app-pass: (password omitted)
  redmine/instances/default/pgsql/admin-pass: (password omitted)
  redmine/instances/default/pgsql/app-pass: (password omitted)
  redmine/instances/default/passwords-do-not-match:
  redmine/instances/default/remote/newhost:
  redmine/instances/default/db/basepath:
  redmine/instances/default/pgsql/changeconf: false
  redmine/instances/default/missing-db-package-error: abort
  redmine/default-language: ${defaultLocale}
  redmine/instances/default/pgsql/no-empty-passwords:
  redmine/instances/default/pgsql/method: unix socket
* redmine/instances/default/database-type: mysql
  redmine/instances/default/pgsql/manualconf:
  redmine/instances/default/pgsql/authmethod-admin: ident
  redmine/instances/default/pgsql/admin-user: postgres
  redmine/missing-redmine-package:
  redmine/instances/default/pgsql/authmethod-user: password
  redmine/instances/default/dbconfig-reinstall: false
  redmine/instances/default/db/app-user: redmine
  redmine/instances/default/default-language: es
  redmine/notify-migration:
  redmine/old-instances:
  redmine/instances/default/upgrade-error: abort
  redmine/instances/default/db/dbname: redmine_default
  redmine/instances/default/purge: false
  redmine/current-instances: default
  redmine/instances/default/remote/host:
  redmine/instances/default/dbconfig-upgrade: true
  redmine/instances/default/internal/reconfiguring: false
  redmine/instances/default/upgrade-backup: true
  redmine/instances/default/install-error: abort
  redmine/instances/default/mysql/admin-user: root
  redmine/instances/default/mysql/method: unix socket
  redmine/instances/default/internal/skip-preseed: false
  redmine/instances/default/remove-error: abort
  redmine/instances/default/dbconfig-remove:
  redmine/instances/default/remote/port:
* redmine/instances/default/dbconfig-install: true


--
Lenz McKAY Gerardo (PICCORO)
http://qglochekone.blogspot.com




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