Cacti Install - MYSQL Probs

[absolutezero273c]

Sorry for the somewhat easy question but I'm fairly new to linux and cacti and am trying to install cacti on CentOS 6.3.

I get the CentOS install no prob, and I've installed the dag.wieers repo and installed Cacti via "yum install cacti" using that repo, but I can't seem to get past the mysql configuration. I've also tried this doing the completely manual install following the 14 page Cacti SNMP Management doc, too. Different messages though.

I'm looking at a number of docs:
1) Cacti SNMP Management - Installation How-to for Linux (http://www.cacti.net/downloads/docs/con ... How-To.pdf),
2) The Cacti Manual (http://www.cacti.net/downloads/docs/con ... How-To.pdf),
3) HowTo: Cacti 8.8 Source Install on CentOS (http://forums.cacti.net/viewtopic.php?f=2&t=46997) and
4) Install Cacti (Network Monitoring) on RHEL/CentOS 6.3/5.8 and Fedora 17-12 (http://www.tecmint.com/install-cacti-ne ... ora-17-12/), but all have different scenarios for how to do the initial config for mysql.

Which one should I follow? The problem I'm running into right now is when I try paragraph 2.5 of "The Cacti Manual" I get:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

I could hunt down these error messages too but it seems each time I do I get no where.

I'm trying to do this in the specific order that is mentioned in these docs and start the services but since they are all different I can't help but wonder which one I should really be following.

I've tried other docs but each time I still have an issue with mysql. I've tried mysql forums, too for help but can't seem to figure out which is the right way to go.

Can someone point me in the right direction?

Thanks.

[absolutezero273c]

If this list and the versions help this is what was installed when performing the latest install using yum and the dag.wieers repo:

Installing:
cacti noarch 0.8.8a-1.el6.rf
Installing for dependencies:
apr x86_64 1.3.9-5.el6_2
apr-util x86_64 1.3.9-3.el6_0.1
apr-util-ldap x86_64 1.3.9-3.el6_0.1
dejavu-lgc-sans-mono-fonts noarch 2.30-2.el6
dejavu-sans-mono-fonts noarch 2.30-2.el6
httpd x86_64 2.2.15-15.el6.centos.1
httpd-tools x86_64 2.2.15-15.el6.centos.1
lm_sensors-libs x86_64 3.1.1-10.el6
mysql x86_64 5.1.61-4.el6
net-snmp x86_64 1:5.5-41.el6_3.1
net-snmp-libs x86_64 1:5.5-41.el6_3.1
net-snmp-utils x86_64 1:5.5-41.el6_3.1
php x86_64 5.3.3-14.el6_3
php-cli x86_64 5.3.3-14.el6_3
php-common x86_64 5.3.3-14.el6_3
php-mysql x86_64 5.3.3-14.el6_3
php-pdo x86_64 5.3.3-14.el6_3
php-snmp x86_64 5.3.3-14.el6_3
rrdtool x86_64 1.3.8-6.el6

[cigamit]

That last link seems to be pretty straightforward so I am not sure where you are having issues. It seems from the errors you posted, mysql isn't started. You may need to try starting it again, and then check the mysql error logs as to why it isn't starting.

If all else fails, maybe you should try out CactiEZ (the link is in my signature). Its basically the same exact thing you are trying, but it does it all for you.

[absolutezero273c]

Thanks for your response cigamit. After I posted that error, I have to agree, it seemed pretty straight forward and I probably look like a fool. But that was after I had just spent an hour or 2 trying get other installs working where they kept failing on the mysql password assignment. ...albeit with much different errors.
I've reinstalled CentOS a couple times now to get this right and simply got frustrated when trying to follow the manuals regarding the mysql config.

I do have a copy of CactiEZ but I wanted to learn how to install and use Cacti from my own build.

If all else fails I guess I just spend a few more hours digging through mysql forums and docs.

I probably should have left out the error message and just stayed with my original question which was: "Which documentation should I follow?" as they all differ a little bit and I want to understand.

[absolutezero273c]

Being this is the first time I've attempted to build a linux server I have to ask this question, too:

When building something like this Cacti server does it matter if I perform an install using yum to install the dependencies or should you install the dependencies manually?

[absolutezero273c]

Starting again fresh this morning I've been able to resolve my 'mysql' problems so please disregard that...

yum install cacti installed a lot of dependencies but it didn't install mysql-server. Kind of important...

[cigamit]

Glad you got it working!