[request-tracker-maintainers] Bug#985141: request-tracker4: Misconfigured DatabaseAdmin when using mysql
Peter Nagel
peter.nagel at kit.edu
Sat Mar 13 15:18:17 GMT 2021
Package: request-tracker4
Version: 4.4.3-2
Severity: normal
Dear Maintainer,
When installing request-tracker4 (mariadb-server and rt4-db-mysql are already installed)
I see (during installation) the following output:
...
populating database via scriptfile... Working with:
Type: mysql
Host: localhost
Port: 3306
Name: rtdb
User: rtuser
DBA: rtuser (No DBA)
...
However, when looking into the RT "System Configuration" I see that DatabaseAdmin (DBA) is defined as user 'postgres':
DatabaseAdmin -> ‘postgres’
DatabaseExtraDSN -> {}
DatabaseHost -> ‘localhost’
DatabaseName -> ‘rtdb’
DatabasePassword -> Password not printed
DatabasePort -> ‘3306’
DatabaseRTHost -> ‘localhost’
DatabaseType -> ‘mysql’
DatabaseUser -> ‘rtuser’
Within mysql only user rtuser is defined:
+-----------+--------+-------------------------------------------+
| host | user | password |
+-----------+--------+-------------------------------------------+
| localhost | root | |
| localhost | rtuser | *D9D2F1F526795EE8EB2CEBBCC4FB868F20E28EF4 |
+-----------+--------+-------------------------------------------+
This lead to problems when installing plugins (e.g. RT-Extension-RepeatTicket-1.11)
because DBA 'postgres' does not exist.
A workaround for this problem was to add the following line into RT_SiteConfig.pm:
Set($DatabaseAdmin , 'rtuser');
Best regards,
Peter
-- Package-specific info:
Changed files:
There are locally modified files in /usr/local/share/request-tracker4/,
these may (or may not) be the source of the problem.
-- System Information:
Debian Release: 10.8
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.19.0-13-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en (charmap=UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages request-tracker4 depends on:
ii dbconfig-common 2.0.11+deb10u1
ii debconf [debconf-2.0] 1.5.71
ii exim4-daemon-light [mail-transport-agent] 4.92-8+deb10u4
ii fonts-droid-fallback 1:6.0.1r16-1.1
ii fonts-noto-hinted 20181227-1
ii libapache-session-perl 1.93-3
ii libbusiness-hours-perl 0.13-1
ii libcgi-emulate-psgi-perl 0.23-1
ii libcgi-pm-perl 4.40-1
ii libcgi-psgi-perl 0.15-2
ii libclass-accessor-perl 0.51-1
ii libclone-perl 0.41-1+b1
ii libconvert-color-perl 0.11-2
ii libcpanel-json-xs-perl 4.09-1
ii libcrypt-eksblowfish-perl 0.009-2+b5
ii libcrypt-x509-perl 0.51-1
ii libcss-minifier-xs-perl 0.09-2+b5
ii libcss-squish-perl 0.10-1
ii libdata-guid-perl 0.049-1
ii libdata-ical-perl 0.22+dfsg-1
ii libdata-page-pageset-perl 1.02-1
ii libdate-extract-perl 0.06-1
ii libdate-manip-perl 6.76-1
ii libdatetime-format-natural-perl 1.06-1
ii libdatetime-locale-perl 1:1.23-1
ii libdatetime-perl 2:1.50-1+b1
ii libdbi-perl 1.642-1+deb10u2
ii libdbix-searchbuilder-perl 1.67-1
ii libdevel-globaldestruction-perl 0.14-1
ii libemail-address-list-perl 0.06-1
ii libemail-address-perl 1.912-1
ii libfile-sharedir-perl 1.116-2
ii libfile-which-perl 1.23-1
ii libgd-graph-perl 1.54~ds-2
ii libgd-text-perl 0.86-9
ii libgnupg-interface-perl 0.52-10
ii libgraphviz-perl 2.22-1
ii libhtml-formattext-withlinks-andtables-perl 0.07-1
ii libhtml-formattext-withlinks-perl 0.15-1
ii libhtml-gumbo-perl 0.18-2+b1
ii libhtml-mason-perl 1:1.58-1
ii libhtml-mason-psgihandler-perl 0.53-2
ii libhtml-quoted-perl 0.04-2
ii libhtml-rewriteattributes-perl 0.05-2
ii libhtml-scrubber-perl 0.17-1
ii libhttp-message-perl 6.18-1
ii libipc-run-perl 20180523.0-1
ii libipc-run3-perl 0.048-1
ii libjavascript-minifier-xs-perl 0.11-1+b5
ii libjson-perl 4.02000-1
ii liblist-moreutils-perl 0.416-1+b4
ii liblocale-maketext-fuzzy-perl 0.11-2
ii liblocale-maketext-lexicon-perl 1.00-1
ii liblog-dispatch-perl 2.68-1
ii libmailtools-perl 2.18-1
ii libmime-tools-perl 5.509-1
ii libmime-types-perl 2.17-1
ii libmodule-refresh-perl 0.17-1
ii libmodule-versions-report-perl 1.06-2
ii libnet-cidr-perl 0.19-1
ii libnet-ip-perl 1.26-2
ii libnet-ldap-perl 1:0.6500+dfsg-1
ii libnet-ssleay-perl 1.85-2+b1
ii libperlio-eol-perl 0.17-1+b1
ii libplack-perl 1.0047-1
ii libregexp-common-net-cidr-perl 0.03-1
ii libregexp-common-perl 2017060201-1
ii libregexp-ipv6-perl 0.03-3
ii librole-basic-perl 0.13-2
ii libscope-upper-perl 0.31-1+b1
ii libstring-shellquote-perl 1.04-1
ii libsymbol-global-name-perl 0.05-1
ii libtext-autoformat-perl 1.740000-2
ii libtext-password-pronounceable-perl 0.30-2
ii libtext-quoted-perl 2.10-1
ii libtext-template-perl 1.55-1
ii libtext-wikiformat-perl 0.79-1
ii libtext-wrapper-perl 1.05-2
ii libtime-parsedate-perl 2015.103-3
ii libtimedate-perl 2.3000-2+deb10u1
ii libtree-simple-perl 1.33-1
ii libuniversal-require-perl 0.18-1
ii liburi-perl 1.76-1
ii libwww-perl 6.36-2
ii libxml-rss-perl 1.60-1
ii libxml-simple-perl 2.25-1
ii lsb-base 10.2019051400
ii perl [libencode-perl] 5.28.1-6+deb10u1
ii rsyslog [system-log-daemon] 8.1901.0-1
ii rt4-clients 4.4.3-2
ii rt4-db-mysql 4.4.3-2
ii rt4-standalone 4.4.3-2
ii ucf 3.0038+nmu1
Versions of packages request-tracker4 recommends:
ii cron [cron-daemon] 3.0pl1-134+deb10u1
ii libfile-dropbox-perl 0.7-1
ii libhtml-formatexternal-perl 26-3
ii libnet-amazon-s3-perl 0.85-1
ii w3m 0.5.3-37
Versions of packages request-tracker4 suggests:
pn rt4-doc-html <none>
-- debconf information excluded
More information about the pkg-request-tracker-maintainers
mailing list