Odd Installation Problem

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Odd Installation Problem

Post by research »

Hello,

I'm trying to install cacti on my openbsd3.7 box, I have installed mysql-server-4.0.23p1 , also have installed apache, php4 and php4-mysql , rrdtool,net-snmp. But when I enter to http://myhost/cacti , I receive this error :

Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

I have done this page:

http://www.cacti.net/downloads/docs/htm ... _unix.html

,

here is the nmap results:

open ports:
80 apache
3306 mysql

--

Result of trying plain mysql command:

Error: 1405: Access denied for use root@localhost ( using password: no )

---

Could someone please help me to install cacti ?

Thanks.
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Have you added and configured the cacti database in mysql? Have you granted rights to the user that will use that database?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

yes I did,

shell> mysql --user=root mysql
mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'somepassword';
mysql> flush privileges;


I did it same
and configurated .conf file for these settings but nothing changed :-/
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

I even tried mysql root and password at config.php file but didnt worked either...
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

Installation worked BUT I changed the following things :

mysql user to root
mysql pass to root
and IP to Real IP. it didnt worked with 127.0.0.1 , localhost
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

okay while installation,

it shows the paths of the binaries. But it didnt recognized php,netsnmp and rrdtool.

but when I type locate rrdtool, it shows as /usr/local/bin/rrdtool, but cacti installation cant recognize it ?

also

while login screen, it wont accept admin/admin as username and password, what might be wrong ?
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Ok, what happens when you attempt to login with admin/admin. Do you get any red text?

Confirm that rrdtool is installed in that location, functioning and executable by the web server.

What OS are you running?
What version of the following are installed:
Cacti
NET-SNMP
mySQL
php
apache
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

nope, it acts like that I didnt entered any information... no red warnings..

RRDtool: 1.0.49 is installed
Mysql: 4.0.23p1
Php: 4.3.10p1
Apache: 1.3.29
Net-SNMP:5.1.2p0

Cacti: 0.8.6g

OS: OpenBSD 3.7
--

paths:

rrdtool: /usr/local/bin/rrdtool
mysql: /usr/local/bin/mysqld_safe
php: /usr/local/bin/php
netsnmp things are under /usr/local/bin.

cacti is located in /var/www/htdocs/cacti
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Make sure you have sessions installed/enabled for PHP....
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

Send the link by pm.

sessions seems installed/enabled
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Ok, sessions are enabled, please double check the permissions on your /tmp directory.

FYI, stop PM'ing me, post info here, results of the URL's you are sending me. ;)
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

Okay :)

What about /tmp?
How its gotta be ?
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

chmod 777 /tmp

That should do it.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
research
Cacti User
Posts: 72
Joined: Tue Sep 20, 2005 9:27 am

Post by research »

didnt worked

btw

/tmp is nodev,nosuid
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Anything that would give a clue in your apache error log?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest