-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Package: dbconfig-common
Version: 1.8.41
Severity: grave
Hello,
I have already mailed you about this issue.
I have taken over the maintenance of the otrs2 package. At work we used
2.2 and then we upgraded to 2.3 and to 2.4, without any problems.
In the past (where we switched from 2.0 to 2.2) I noticed, that some
ALTERs on the database were missing and I manualy applied them, without
taking further care about the issue.
In sid there are now the following files available:
/usr/share/dbconfig-common/data/otrs2/install/mysql
/usr/share/dbconfig-common/data/otrs2/install/pgsql
/usr/share/dbconfig-common/data/otrs2/upgrade/mysql/2.1
/usr/share/dbconfig-common/data/otrs2/upgrade/mysql/2.2
/usr/share/dbconfig-common/data/otrs2/upgrade/mysql/2.3
/usr/share/dbconfig-common/data/otrs2/upgrade/mysql/2.4
/usr/share/dbconfig-common/data/otrs2/upgrade/pgsql/2.1
/usr/share/dbconfig-common/data/otrs2/upgrade/pgsql/2.2
/usr/share/dbconfig-common/data/otrs2/upgrade/pgsql/2.3
/usr/share/dbconfig-common/data/otrs2/upgrade/pgsql/2.4
If I switch from 2.2 to 2.3 and then to 2.4, everything is fine. If I
switch directly from 2.2 to 2.4 dbconfig only applies the 2.4 update,
not the 2.3 one, for mysql and pgsql.
I hope you are fine with severity grave, because currently this will
break every otrs2 installation if users upgrade from lenny to squeeze.
The config of otrs looks like this (sorry a bit longer, but not my code :p):
$ cat config
#!/bin/sh
set -e
print_config()
{
cat << EOF
dbname="$dbname"
dbserver="$dbserver"
dbport="$dbport"
dbuser="$dbuser"
dbpass="$dbpass"
dbtype="$dbtype"
EOF
}
get_config()
{
set +e
DSN=$(/usr/share/otrs/bin/otrs.getConfig DatabaseDSN)
TYPE=$(echo $DSN | awk -F: '{ print $2 }')
DSNOPTIONS=$(echo $DSN | awk -F: '{ print $3 }')
eval $DSNOPTIONS
case $TYPE in
Pq) dbtype="pgqsl"
dbname=${dbname:-otrs}
;;
mysql) dbtype="mysql"
dbname=${database:-otrs}
;;
esac
dbserver=${host:-localhost}
dbuser=$(/usr/share/otrs/bin/otrs.getConfig DatabaseUser)
dbuser=${dbuser:-otrs}
dbpass=$(/usr/share/otrs/bin/otrs.getConfig DatabasePw)
print_config > $TMPFILE
set -e
}
. /usr/share/debconf/confmodule
dbc_dbtypes="mysql, pgsql"
TMPFILE=$(mktemp)
if [ -f "/etc/otrs/Kernel/Config.pm" ]; then
get_config
fi
dbc_dbuser="otrs"
dbc_authmethod_user="ident"
dbc_first_version="2.0.4p01-10"
dbc_load_include="sh:$TMPFILE"
if [ -f /usr/share/dbconfig-common/dpkg/config ]; then
. /usr/share/dbconfig-common/dpkg/config
dbc_go otrs2 "$@"
fi
# FIXME: db_get otrs2/database-type = pgsql
db_get otrs2/pgsql/authmethod-user
METHOD="$RET"
db_get otrs2/db/app-user
USER="$RET"
if [ "$METHOD" = ident -a "$USER" != otrs ]; then
db_input high otrs2/resetdbuser || true
db_go || true
db_get otrs2/resetdbuser
if [ $RET = true ]; then
db_set otrs2/db/app-user otrs
fi
fi
- --
/*
Mit freundlichem Gruß / With kind regards,
Patrick Matthäi
GNU/Linux Debian Developer
E-Mail: pmatth...@debian.org
patr...@linux-dev.org
Comment:
Always if we think we are right,
we were maybe wrong.
*/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iEYEARECAAYFAksmizQACgkQ2XA5inpabMd08ACfR6pjBXxIhm2ldgbEy8GrjpkD
xRIAn2yxYsm2eYra0EkqJFI1xlVYmmEN
=oPC6
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
