Your message dated Thu, 09 Aug 2012 10:20:40 +0200 with message-id <502372d8.8070...@melix.org> and subject line Re: Bug#684067: redmine postgresql backend fails in redmine clean has caused the Debian Bug report #684067, regarding redmine postgresql backend fails in redmine clean instalation (whatever version 1.4.3, 1.4.4 or 1.4.2) to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 684067: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=684067 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---On 08/08/2012 22:03, PICCORO McKAY Lenz wrote: > FIND it! > > dpkg-reconfigure -plow --force redmine Do you really need --force there ? Otherwise it is true -plow is needed in some cases. dbconfig can be inconvenient... > follow verbose steps, now in config dialos u can see that in > usernames said "Mysql" and its using pgsql backend.. this was minor > mistake.. so change db name redmine_default to redmine (by removing > lIinstance var) in postinst script (lines: 175 aprox) > > this its due in postgresql by default when user connect assumes a > equal db name exist for users , so postinst scritp when connect user > redmine this cant due redmine database dont exist, event > redmine_default (in default instace case) its the db to use.. This is not true, postgresql doesn't assume the db name is equal to the user name by default. *You* probably wanted your db name to be "redmine", in which case the dbconfig prompts allow you to set it. No hack needed for that. Closing because this is just not a bug. Jérémy.
--- End Message ---
