Fresh Install on Centos7 but can't get initial webpage to go

[SoleoInfo]

New to Cacti and Linux in general but I'm learning quickly.

I followed this install guide: https://www.itzgeek.com/how-tos/linux/c ... hel-7.html

However, MariaDB is no longer able to be installed so MYSql 8 is now installed. The /usr/share/doc/cacti-*/cacti.sql script doesn't work but found a post here with a corrected script so all looks good (sorry to the solution provider for not linking).

I can't get the initial page to load; "FATAL: Connection to Cacti database failed. Please ensure the database is running and your credentials in config.php are valid." I've checked and all is good. I can log into MYSQL as the user, select the database, list tables, select * from version gets results ("new install"}). I've tried setting hostname in config.php to the VM name, it's IP, 127.0.0.1 all with no luck.

I've rebuilt the VM 4 times from base ISO and just can't figure it out. There are no errors reported in /var/log/messages or cacti or apache logs......

Any help would be greatly appreciated. I know you'll probably want me to post contents of files or do some other troubleshooting, I just don;t know what you're looking for so post back and I'll provide the requested info...

Centos 7
MYSQL 8.0.12
Cacti 1.1.37

[SoleoInfo]

It was applematt84's script that helped me get past the sql script issues:

viewtopic.php?f=2&t=58734

[netniV]

You need to be using the latest development version from GitHub at the moment. 1.1.38 and below are NOT compatible with the very latest version of MySQL. Ubuntu 18.04 has the same issue. We are very close to a beta phase of 1.2 so it's stable enough to run on a new system (especially if it's not in production yet) to try it out.

[SoleoInfo]

@netniV - Thank you for the reply! I've been banging my head trying to get this going for the past 5 days.

As I am VERY new to linux and all its variants, and if I may ask a very basic question....how do I pull from github?

Thank you in advance for your patience and response!

[netniV]

There are several methods. If you only want a single static release, check out the download options on the repo at https://github.com/cacti/cacti/

However, I would recommend using git to pull down the code which as simple as saying

git checkout https://github.com/cacti/cacti/ <cacti_folder>

Then when you wish to update, you use git's pull command to update. My wiki's in my signature have details on how I setup my dev environments, but you will need to adjust since I tend to create three copies of cacti per OS I'm testing.

[SoleoInfo]

So I FINALLY got cacti installed!!!

I thought I would post so that anyone else might find guidance in my pain and suffering.

@netniV had suggested pulling the latest from git. Simple as that sounded, and I was able to clone the repository, I couldn't figure out what to do next to get Cacti to go......

Then it dawned on me....@netniV mentioned that the current version was not compatible with the latest mysql......so why not just install a previous version of mysql?????

I found this on the mysql website on how to do just that: https://dev.mysql.com/doc/mysql-yum-rep ... -guide/en/

I followed and installed mysql 5.7, finished the installation of Cacti and BOOM!!!!! license agreement page comes up!!!!!

Many, Many thanks to @netniV for pointing me in the right direction.

[tertius]

I'm a bit late in this thread, but why did the original and default mariadb server in CentOS 7 not work? It's version 5.5.56, but it's a version Cacti is able to use, and it works without any hassle.
For a Cacti rpm file, add the EPEL 7 repository: https://fedoraproject.org/wiki/EPEL
EPEL 7 is essentially all packages from Fedora that are not in RHEL 7/CentOS 7.

Then install (including dependencies):

Code: Select all

$ yum install mariadb-server
$ yum install cacti

Then enable+start the mariadb server:

Code: Select all

$ systemctl enable mariadb
$ systemctl start mariadb

Then follow the cacti documentation about creating the cacti database, connecting cacti to its database, tuning mariadb server settings and may be some missing php packages.
Special in the EPEL cacti package: cacti configuration file db.php is located in /etc/cacti/db.php.
That's it.