I've updated
Bug 109721. Install the contrib as described in the wiki
yum install smeserver-cacti --enablerepo=smecontribs
2. Create a database password
config setprop cacti DbPassword $(< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c${1:-32};echo;)
3. Create a corrected copy of the template
[edited 2020-07-04 to include the command that creates the custom template folder]# create the custom template folder
mkdir -p /etc/e-smith/templates-custom/etc/e-smith/sql/init/
# copy and customize the default template into the custom template folder
sed -e 's/DbName/DbDatabase/' \
-e 's/\([^\]\)@/\1\\@/' \
-e 's/`mysql`.`time_zone_name`/mysql.time_zone_name/' \
-e 's|/etc/e-smith/db/configuration/migrate/80cacti_sme.sql|/usr/share/doc/cacti-1.1.19/cacti.sql|' \
/etc/e-smith/templates/etc/e-smith/sql/init/80cacti \
> /etc/e-smith/templates-custom/etc/e-smith/sql/init/80cacti
4. Re-expand the cacti db.php config to get the new password configured
expand-template /etc/cacti/db.php
5. Initialize the database
service mysql.init restart
NOTE: you need to drop the database using
mysql -e "drop database cacti_sme;" if it already exists or the initialize step is skipped...
6. Reboot to update the web server
signal-event post-upgrade; signal-event reboot
This still leaves the system wanting:
* a newer version of mysql (preferred version = 5.6+)
* several other performance-related changes to the mysql config
* configuration to get it to start working
...but it seems to be up and running.