[Pkg-cacti-maint] Bug#933683: cacti: Cacti needs fixes in order to work with newer MySQL versions to be merged

[Rafael David Tinoco]

Package: cacti
Severity: normal
Tags: patch upstream

Hello, I'm opening this bug to track the merge request made at:

https://salsa.debian.org/cacti-team/cacti/merge_requests/1

Where the changelog tells history about why it is needed:

  * dbc_authplugin parameter for dbconfig-common:
    - debian/cacti.config changes default MySQL authentication
      plugin to a compatible (to PHP PDO and PHP mysqli) one.

  * Instructions have to contain workaround for NO_AUTO_CREATE_USER
    - debian/README.Debian

  * General instructions have to contain workaround for NO_AUTO_CREATE_USER
    - docs-source/General-Installing-Instructions.md

  * Fix MySQL keyword usage in table "aggregate_graph_templates"
    - cacti.sql

It goes together with dbconfig fixes proposed at:

https://salsa.debian.org/debian/dbconfig-common/merge_requests/3

in order to make both packages to work with recent MySQL versions.

Thank you very much in advance for reviewing and considering this.

Best Regards

Rafael D. Tinoco
rafaeldtinoco at ubuntu.com

-- System Information:
Debian Release: bullseye/sid
  APT prefers unstable-debug
  APT policy: (500, 'unstable-debug'), (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 5.0.0-21-generic (SMP w/8 CPU cores)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages cacti depends on:
pn  dbconfig-common                      <none>
pn  dbconfig-mysql | dbconfig-no-thanks  <none>
ii  debconf [debconf-2.0]                1.5.72
ii  fonts-dejavu-core                    2.37-1
pn  fonts-dejavu-extra                   <none>
pn  fonts-fork-awesome                   <none>
ii  javascript-common                    11
pn  libapache2-mod-php | php             <none>
pn  libjs-c3                             <none>
pn  libjs-chart.js                       <none>
pn  libjs-d3                             <none>
ii  libjs-jquery                         3.3.1~dfsg-3
ii  libjs-jquery-colorpicker             1.2.17-1
pn  libjs-jquery-cookie                  <none>
pn  libjs-jquery-hotkeys                 <none>
ii  libjs-jquery-jstree                  3.3.7+dfsg1-1
pn  libjs-jquery-metadata                <none>
pn  libjs-jquery-tablesorter             <none>
pn  libjs-jquery-timepicker              <none>
ii  libjs-jquery-ui                      1.12.1+dfsg-5
ii  libjs-jquery-ui-theme-smoothness     1.12.1+dfsg-1
ii  libjs-jquery-ui-theme-south-street   1.12.1+dfsg-1
ii  libjs-jquery-ui-theme-ui-darkness    1.12.1+dfsg-1
pn  libjs-jquery-ui-touch-punch          <none>
pn  libphp-phpmailer                     <none>
ii  perl                                 5.28.1-6
pn  php-cli                              <none>
pn  php-gd                               <none>
pn  php-gmp                              <none>
pn  php-json                             <none>
pn  php-ldap                             <none>
pn  php-mbstring                         <none>
pn  php-mysql                            <none>
pn  php-phpseclib                        <none>
pn  php-snmp                             <none>
pn  php-twig                             <none>
pn  php-xml                              <none>
pn  rrdtool                              <none>
pn  snmp                                 <none>
ii  ucf                                  3.0038+nmu1

Versions of packages cacti recommends:
pn  apache2 | lighttpd | nginx | httpd           <none>
pn  default-mysql-server | virtual-mysql-server  <none>
ii  iputils-ping                                 3:20190515-2
ii  logrotate                                    3.14.0-4

Versions of packages cacti suggests:
pn  cacti-spine  <none>
pn  moreutils    <none>
pn  snmpd        <none>