cacti-user Mailing List for Cacti

Spud wrote:
> On 12/27/06, J.P. Pasnak <pa...@wa...> wrote:
>
>>
>>
>> Spud wrote:
>>
>>> On 12/27/06, J.P. Pasnak <pa...@wa...> wrote:
>>>
>>>>
>>>> Spud wrote:
>>>>
>>>>
>>>>> Hi,
>>>>> Ok I'm stuck... any help would be very much appreciated thanks!!!
>>>>> You have created a new database, but have not yet imported the
>>>>> 'cacti.sql'
>>>>> Please make sure you have specified a vaild MySQL database in
>>>>> 'include/config.php'.
>>>>> So I look inside the config.php file and...
>>>>> require_once("db.php"); /* ----- you probably do not need to
>>>>> change anything below this line ----- */
>>>>
>>>> You are not using an official Cacti release.   Check 'db.php' for
>>>> the correct info.
>>>>
>>>> By the way, where did this release come from?
>>>>
>>>
>>> I'm running Fedora Core 5 and typed in Yum install cacti and thats
>>> what it gave me.
>>>
>>> So you think this is the problem?!?
>>>
>>>
>>
>> I think the problem is with 'db.php' - double-check the settings in
>> that file.
>
>
>
> Well tried a few changes to the db.php configuration file with no luck,
> here it is maybe i cant see the problem for looking.
>
> -----------------------------------------------------------------------=
--
> ------------------------------------------
> <?php
> /* make sure these values refect your actual database/host/user/passwor=
d
> */
> $database_type =3D "mysql";
> $database_default =3D "cactidb";
> $database_hostname =3D "localhost";
> $database_username =3D "spud";
> $database_password =3D "mypasswordisinbithere";
> $database_port =3D "3306";
> ?>
> -----------------------------------------------------------------------=
---
> -----------------------------------------
>
I don't see anything wrong with this, as long as you can log into mysql
with those values:

mysql -uspud -p cactidb

>
> Do you think it would be worth removing this version of cacti and
> downloading the RPM for FC5 from the cacti website and installing that?

It would be worth a shot...

--=20
Live fast, die young,
You're sucking up my bandwidth.

J.P. Pasnak, CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca

Please find some walkthroughs at http://docs.cacti.net/node/70
And find more traffic at http://forums.cacti.net

Reinhard


Peter Morton wrote:
> Hi,
> 
> I have successfully installed cacti 0.8.6i from the .tar.gz on the website,
> onto my debian 4 system. After days of wrestling with it I have the CPU
> usage successfully graphing but am still struggling to get hard drive space
> monitoring working.
> 
> I am running cacti on the same machine as I would like to monitor. I
> eventually got the CPU monitoring working via snmp, is that the correct way
> of doing it? I am assuming hard drive monitoring is done the same way
> (unless cacti can query the server itself?). I used the Local Linux Machine
> template, then tried to add "Unix - Hard Drive Space", and then "ucd/net -
> Hard Drive Space" however both yield no results when trying to graph them
> (either an empty graph appeared or no graph at all).
> 
> I added "com2sec readonly  localhost         public" to my smnpd config
> file, which I am assuming should allow access to everything.
> 
> Thanks
> Pete
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user
> 

All,

The cmd.php in SVN BRANCH_0_8_6 currently addresses this issue.  We will be
meeting on January 1st to discuss a patch release to address more
permanently in the form of either an official release or maintenance patch.

The link to the patched file can be found here:

http://svn.cacti.net/cgi-bin/viewcvs.cgi/branches/BRANCH_0_8_6/cacti/cmd.php
?rev=3828&sortby=date&view=log


TheWitness

> -----Original Message-----
> From: cac...@li... [mailto:cacti-user-
> bo...@li...] On Behalf Of Frank Bulk
> Sent: Saturday, December 30, 2006 8:44 PM
> To: cac...@li...
> Subject: Re: [cacti-user] Cacti remote code and SQL injection
vulnerability
> 
> I would be remiss if I didn't at least mention the Cacti remote code and
SQL
> vulnerability.
> 
> I read about it on SANS two days ago:
> http://isc.sans.org/diary.php?storyid=1986&rss
> 
> It includes links to the actual advisories from Secunia and CVE, as well
as
> steps to mitigate the threat.
> 
> Regards,
> 
> Frank
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user

I would be remiss if I didn't at least mention the Cacti remote code and SQL
vulnerability.  

I read about it on SANS two days ago:
http://isc.sans.org/diary.php?storyid=1986&rss

It includes links to the actual advisories from Secunia and CVE, as well as
steps to mitigate the threat.

Regards,

Frank

Hi,

I have successfully installed cacti 0.8.6i from the .tar.gz on the website,
onto my debian 4 system. After days of wrestling with it I have the CPU
usage successfully graphing but am still struggling to get hard drive space
monitoring working.

I am running cacti on the same machine as I would like to monitor. I
eventually got the CPU monitoring working via snmp, is that the correct way
of doing it? I am assuming hard drive monitoring is done the same way
(unless cacti can query the server itself?). I used the Local Linux Machine
template, then tried to add "Unix - Hard Drive Space", and then "ucd/net -
Hard Drive Space" however both yield no results when trying to graph them
(either an empty graph appeared or no graph at all).

I added "com2sec readonly  localhost         public" to my smnpd config
file, which I am assuming should allow access to everything.

Thanks
Pete

Reinhard, This is what I get.

$ snmpget -v 1 -c public sol_10 memory
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: UCD-SNMP-MIB::memory

$ snmpget -v 1 -c public sol_10 cpu
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: UCD-SNMP-MIB::ssCpuRawInterrupt

Thank you for your help.

On 12/28/06, Reinhard Scheck <Rei...@te...> wrote:
>
> Please try
>
> snmpget -v 1 -c public sol_10 memory
> and
> snmpget -v 1 -c public sol_10 cpu
>
> If they do not return data, you have an issue with your snmp version on
> your target box. 5.0.9 is not that current ...
>
> Please consider posting to http://forums.cacti.net, there's more traffic
> ...
>
> Reinhard
>
>
>
> Adeday wrote:
> > I am new to cacti and here is the issue I have:
> >
> > I am adding a solaris 10 box to cacti to graph CPU, memory usage and
> > established connections. However, I am not able to get the CPU and
> memory
> > graphs. I only get the established connections graph. The cacti
> server  is
> > ver. 5.0.9 and the solaris 10 box has net-snmp ver. 5.0.9 installed on
> it
> > that came with the OS. SNMP seems to be working fine since I am able to
> do
> > snmpget from the cacti server to the solaris 10 box.
> >
> > [cacti_server]$ snmpget -v 1 -c public sol_10 sysUpTime.0
> > SNMPv2-MIB::sysUpTime.0 = Timeticks: (261330381) 30 days, 5:55:03.81
> >
> > what do I need to do to get the CPU and memory graphs?
> >
> > Thanks in advance.
> >
> -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> > opinions on IT & business topics through brief surveys - and earn cash
> >
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > cacti-user mailing list
> > cac...@li...
> > https://lists.sourceforge.net/lists/listinfo/cacti-user
> >
> >
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user
>

Please try

snmpget -v 1 -c public sol_10 memory
and
snmpget -v 1 -c public sol_10 cpu

If they do not return data, you have an issue with your snmp version on your target box. 5.0.9 is not that current ...

Please consider posting to http://forums.cacti.net, there's more traffic ...

Reinhard



Adeday wrote:
> I am new to cacti and here is the issue I have:
>
> I am adding a solaris 10 box to cacti to graph CPU, memory usage and
> established connections. However, I am not able to get the CPU and memory
> graphs. I only get the established connections graph. The cacti server  is
> ver. 5.0.9 and the solaris 10 box has net-snmp ver. 5.0.9 installed on it
> that came with the OS. SNMP seems to be working fine since I am able to do
> snmpget from the cacti server to the solaris 10 box.
>
> [cacti_server]$ snmpget -v 1 -c public sol_10 sysUpTime.0
> SNMPv2-MIB::sysUpTime.0 = Timeticks: (261330381) 30 days, 5:55:03.81
>
> what do I need to do to get the CPU and memory graphs?
>
> Thanks in advance.
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user
>
>   

I am new to cacti and here is the issue I have:

I am adding a solaris 10 box to cacti to graph CPU, memory usage and
established connections. However, I am not able to get the CPU and memory
graphs. I only get the established connections graph. The cacti server  is
ver. 5.0.9 and the solaris 10 box has net-snmp ver. 5.0.9 installed on it
that came with the OS. SNMP seems to be working fine since I am able to do
snmpget from the cacti server to the solaris 10 box.

[cacti_server]$ snmpget -v 1 -c public sol_10 sysUpTime.0
SNMPv2-MIB::sysUpTime.0 = Timeticks: (261330381) 30 days, 5:55:03.81

what do I need to do to get the CPU and memory graphs?

Thanks in advance.

On 12/28/06, Siddharth Deshpande <sid...@de...> wrote:
>
> On Thu, 2006-12-28 at 19:22 +0530, Siddharth Deshpande wrote:
> > > Date: Wed, 27 Dec 2006 13:28:51 +0100 (MET)
> > > From: Reinhard Scheck <Rei...@te...>
> > > Subject: Re: [cacti-user] Help needed with Cacti installation on Linux
> >
> > > Please check php.ini setings, especially session support
> > >
> > > Reinhard
> > >
> > > BTB: more traffic to be found at http://forums.cacti.net
> >
> > Forgive me for being such a dummy, but what exactly do you mean by
> > session support? There are a lot of session-related parameters
> > in /etc/php5/apache/php.ini, if that's the file you are referring to
> > (there are other similar ones for cli/php.ini etc, but i don't think
> > those would be of interest here). So what exactly are you referring to?
> >
> > Anyway, initially when i would point my browser to
> > http://localhost/cacti, it would give me a 404 not found error. Then a
> > colleague told me i'll have to configure /etc/apache2/httpd.conf and let
> > it know where the "/cacti" part is located. (Of course, the manual
> > doesn't say anything about this). The only way i could figure to do this
> > was add an alias (i copied some of the settings for other aliases which
> > were working with the web server).. so here is my httpd.conf(the only
> > non-comment part of it) :


Hi

you need to have mysql and php update version
any problem post back with errors

ram

On Thu, 2006-12-28 at 19:22 +0530, Siddharth Deshpande wrote:
> > Date: Wed, 27 Dec 2006 13:28:51 +0100 (MET)
> > From: Reinhard Scheck <Rei...@te...>
> > Subject: Re: [cacti-user] Help needed with Cacti installation on Linux
> 
> > Please check php.ini setings, especially session support
> > 
> > Reinhard
> > 
> > BTB: more traffic to be found at http://forums.cacti.net
> 
> Forgive me for being such a dummy, but what exactly do you mean by
> session support? There are a lot of session-related parameters
> in /etc/php5/apache/php.ini, if that's the file you are referring to
> (there are other similar ones for cli/php.ini etc, but i don't think
> those would be of interest here). So what exactly are you referring to?
> 
> Anyway, initially when i would point my browser to
> http://localhost/cacti, it would give me a 404 not found error. Then a
> colleague told me i'll have to configure /etc/apache2/httpd.conf and let
> it know where the "/cacti" part is located. (Of course, the manual
> doesn't say anything about this). The only way i could figure to do this
> was add an alias (i copied some of the settings for other aliases which
> were working with the web server).. so here is my httpd.conf(the only
> non-comment part of it) :
> -------------------------------------------------------------------------
> <IfModule mod_alias.c>
>         Alias /cacti /usr/src/cacti
> 
>         <Directory /usr/src/cacti>
>                  Options MultiViews
>                  AllowOverride None
>                  Order allow,deny
>                  Allow from all
>          </Directory>
> </IfModule>
> ---------------------------------------------------------------------------
> 
> in spite of this being the only entry, http://127.0.0.1/icons shows me
> the icons directory (without there being any alias for it in the apache2
> httpd.conf). (also note that http://localhost/cacti just yields a blank
> page, while http://127.0.0.1 kinda works, i.e., it starts downloading
> the index.php file under some random name, but does not show any html
> content. (Earlier, while tinkering, i had aliased /cacti to the file
> poller.php in the cacti directory, and *that* used to display the html
> text in the browser). I have been to the forums and found a thread for
> "cacti url yields blank screen", but that didn't solve my problem.
> 
> Please help!
> 
> - Siddharth.

	This problem seems to have been solved - the php*-mysql module was
missing. Now i've gotten to the first page in the browser. Let's see how
it goes from there. I don't know how many steps out of what i have done
were unneccessary, but if i get the time i'll retrace them and try to
find out. I'll post it on the list if i come up with anything. This
problem seems to have occured only because of a selective installation
of debian packages (cacti i had installed from source). Anyway, thanks a
lot to Reinhard and the others who have helped me out.

Cheers,
Siddharth.

> Date: Wed, 27 Dec 2006 13:28:51 +0100 (MET)
> From: Reinhard Scheck <Rei...@te...>
> Subject: Re: [cacti-user] Help needed with Cacti installation on Linux

> Please check php.ini setings, especially session support
> 
> Reinhard
> 
> BTB: more traffic to be found at http://forums.cacti.net

Forgive me for being such a dummy, but what exactly do you mean by
session support? There are a lot of session-related parameters
in /etc/php5/apache/php.ini, if that's the file you are referring to
(there are other similar ones for cli/php.ini etc, but i don't think
those would be of interest here). So what exactly are you referring to?

Anyway, initially when i would point my browser to
http://localhost/cacti, it would give me a 404 not found error. Then a
colleague told me i'll have to configure /etc/apache2/httpd.conf and let
it know where the "/cacti" part is located. (Of course, the manual
doesn't say anything about this). The only way i could figure to do this
was add an alias (i copied some of the settings for other aliases which
were working with the web server).. so here is my httpd.conf(the only
non-comment part of it) :
-------------------------------------------------------------------------
<IfModule mod_alias.c>
        Alias /cacti /usr/src/cacti

        <Directory /usr/src/cacti>
                 Options MultiViews
                 AllowOverride None
                 Order allow,deny
                 Allow from all
         </Directory>
</IfModule>
---------------------------------------------------------------------------

in spite of this being the only entry, http://127.0.0.1/icons shows me
the icons directory (without there being any alias for it in the apache2
httpd.conf). (also note that http://localhost/cacti just yields a blank
page, while http://127.0.0.1 kinda works, i.e., it starts downloading
the index.php file under some random name, but does not show any html
content. (Earlier, while tinkering, i had aliased /cacti to the file
poller.php in the cacti directory, and *that* used to display the html
text in the browser). I have been to the forums and found a thread for
"cacti url yields blank screen", but that didn't solve my problem.

Please help!

- Siddharth.

On 12/27/06, J.P. Pasnak <pa...@wa...> wrote:
>
>
> Spud wrote:
> > On 12/27/06, J.P. Pasnak <pa...@wa...> wrote:
> >>
> >> Spud wrote:
> >>
> >>> Hi,
> >>> Ok I'm stuck... any help would be very much appreciated thanks!!!
> >>> You have created a new database, but have not yet imported the
> >>> 'cacti.sql'
> >>> Please make sure you have specified a vaild MySQL database in
> >>> 'include/config.php'.
> >>> So I look inside the config.php file and...
> >>> require_once("db.php"); /* ----- you probably do not need to change
> >>> anything below this line ----- */
> >>
> >> You are not using an official Cacti release.   Check 'db.php' for the
> >> correct info.
> >>
> >> By the way, where did this release come from?
> >
> > I'm running Fedora Core 5 and typed in Yum install cacti and thats what
> > it gave me.
> >
> > So you think this is the problem?!?
> >
>
> I think the problem is with 'db.php' - double-check the settings in that
> file.



Well tried a few changes to the db.php configuration file with no luck, here
it is maybe i cant see the problem for looking.

-------------------------------------------------------------------------------------------------------------------
<?php
/* make sure these values refect your actual database/host/user/password */
$database_type = "mysql";
$database_default = "cactidb";
$database_hostname = "localhost";
$database_username = "spud";
$database_password = "mypasswordisinbithere";
$database_port = "3306";
?>
-------------------------------------------------------------------------------------------------------------------

Do you think it would be worth removing this version of cacti and
downloading the RPM for FC5 from the cacti website and installing that?

thanks again

-- 
db

Spud wrote:
> On 12/27/06, J.P. Pasnak <pa...@wa...> wrote:
>>
>> Spud wrote:
>>
>>> Hi,
>>> Ok I'm stuck... any help would be very much appreciated thanks!!!
>>> You have created a new database, but have not yet imported the
>>> 'cacti.sql'
>>> Please make sure you have specified a vaild MySQL database in
>>> 'include/config.php'.
>>> So I look inside the config.php file and...
>>> require_once("db.php"); /* ----- you probably do not need to change
>>> anything below this line ----- */
>>
>> You are not using an official Cacti release.   Check 'db.php' for the
>> correct info.
>>
>> By the way, where did this release come from?
>
> I'm running Fedora Core 5 and typed in Yum install cacti and thats what
> it gave me.
>
> So you think this is the problem?!?
>

I think the problem is with 'db.php' - double-check the settings in that
file.

--=20
Live fast, die young,
You're sucking up my bandwidth.

J.P. Pasnak, CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca

I'm running Fedora Core 5 and typed in Yum install cacti and thats what it
gave me.

So you think this is the problem?!?

thanks

On 12/27/06, J.P. Pasnak <pa...@wa...> wrote:
>
>
> Spud wrote:
> > Hi,
> >
> >
> > Ok I'm stuck... any help would be very much appreciated thanks!!!
> > You have created a new database, but have not yet imported the
> > 'cacti.sql'
> > Please make sure you have specified a vaild MySQL database in
> > 'include/config.php'.
> > So I look inside the config.php file and...
> > require_once("db.php"); /* ----- you probably do not need to change
> > anything below this line ----- */
>
> You are not using an official Cacti release.   Check 'db.php' for the
> correct info.
>
> By the way, where did this release come from?
>
> --
> Live fast, die young,
> You're sucking up my bandwidth.
>
> J.P. Pasnak, CD
> CCNA, LPIC-1
> http://www.warpedsystems.sk.ca
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user
>



-- 
db

Yes, this is possible. You may even extend an exting rrd file. Find my HowTo and more at
http://docs.cacti.net/node/70
And find more traffic at http://forums.cacti.net

Reinhard

Victor Tayer wrote:
> Hi,
> 
> Is is possible for cacti to archive the graphs up to 5 years? One of my 
> customers wants to be able to see all the history up to 5 years.
> 
> Thanks
> Victor
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user
> 

Please check php.ini setings, especially session support

Reinhard

BTB: more traffic to be found at http://forums.cacti.net

Siddharth Deshpande wrote:
> On Tue, 2006-12-26 at 10:40 +0530, Siddharth Deshpande wrote:
> 
>>>Message: 5
>>>Date: Fri, 22 Dec 2006 10:24:25 +0100 (MET)
>>>From: Reinhard Scheck <Rei...@te...>
>>>Subject: Re: [cacti-user] Help needed with Cacti installation on Linux
>>
>>>You've got the wrong tarball. You've downloaded cactid instead of cacti. cactid is the fast poller
>>>that supports cacti
>>>
>>>Reinhard
>>
> 
> 
> 	Well i downloaded the *correct* tarball this time, and am just
> following the directions given in the cacti manual, and seem to have
> gotten further than i've ever had. According to the manual:
> 
> 
> 
>>1. Extract the distribution tarball.
>>   shell> tar xzvf cacti-version.tar.gz
> 
> 	- i extracted it to /usr/src/cacti.
> 
> 
> 
>>2. Create the MySQL database:
>>   shell> mysqladmin --user=root create cacti
>>3. Import the default cacti database:
>>   shell> mysql cacti < cacti.sql
>>4. Optional: Create a MySQL username and password for Cacti.
>>   shell> mysql --user=root mysql
>>   mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY
>>’somepassword’;
>>   mysql> flush privileges;
>>5. Edit include/config.php and specify the MySQL user, password and
>>database for your Cacti configuration.
>>   $database_default = "cacti";
>>   $database_hostname = "localhost";
>>   $database_username = "cactiuser";
>>   $database_password = "cacti";
>>
> 
> 	- did ALL of the above with exactly the same settings.
> 
>>6. Set the appropriate permissions on cacti’s directories for graph/log generation. You should execute these com-
>>   mands from inside cacti’s directory to change the permissions.
>>   shell> chown -R cactiuser rra/ log/
>>   (Enter a valid username for cactiuser, this user will also be used in the next step for data gathering.)
> 
> 	- now this is where i'm thrown a little off.. it says (obviously) that
> "cactiuser" is an invalid username, so i tried it with root, and it let
> me proceed further.
> 
> Then, it says:
> 
> 
>>7. Add a line to your /etc/crontab file similar to:
>>   */5 * * * * cactiuser php /var/www/html/cacti/poller.php  /dev/null
>>2>&1
>>   Replace cactiuser with the valid user specified in the previous
>>step. 
>>- Replace /var/www/html/cacti/ with your full Cacti path.
> 
> 	- which i did (replaced cactiuser with root, and /var/www/html/cacti/
> with /usr/scr/cacti).
> 
> 
> 
>>8. Point your web browser to:
>>     http://your-server/cacti/
> 
> 
> 	which is where it all falls apart. NOTE: i am using runit, not the
> default init. I have manually created a service for cron (as
> initscripts don't work with runit), the daemon itself (alongwith a
> helper daemon for logging it) seems to be running, but this thing is
> not happening. 	i do http://localhost/cacti and i get a 404 not found.
> i have apache running (but never really configured) on this system.
> when i do a netstat, this is what i get:
> 
> 
> 
>># netstat -natp
>>
>>Active Internet connections (servers and established)
>>Proto Recv-Q Send-Q 	Local Address           Foreign Address         State       PID/Program name
>>...
>>...
>>tcp        0      0 	0.0.0.0:80              0.0.0.0:*               LISTEN     10877/apache
>>...
>>tcp        0      0 	127.0.0.1:80            127.0.0.1:35718         TIME_WAIT  -
>>...
>>
> 
> 
> 	i do not know if this has any special significance, may just be useful
> to some1 in debugging the problem. And, yes, if i just open
> http://localhost or http://127.0.0.1 in my browser, i get the default
> web-page. So obviously that means that the web server itself is
> running.
>  	So what's the deal with cacti? is there some other
> configuration step i'm missing here? Please help!
> 
> - Siddharth.
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user

Spud wrote:
> Hi,
>
>
> Ok I'm stuck... any help would be very much appreciated thanks!!!
> You have created a new database, but have not yet imported the
> 'cacti.sql'
> Please make sure you have specified a vaild MySQL database in
> 'include/config.php'.
> So I look inside the config.php file and...
> require_once("db.php"); /* ----- you probably do not need to change
> anything below this line ----- */

You are not using an official Cacti release.   Check 'db.php' for the
correct info.

By the way, where did this release come from?

--=20
Live fast, die young,
You're sucking up my bandwidth.

J.P. Pasnak, CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca

On 12/26/06, Spud <spu...@gm...> wrote:
>
>
> So where do I specifie a valid MySQL database in there?
>
> I am completely at a dead end with this and have gone over this many times
> and gotten nowhere. Anyone got an idea where I should start looking or at
> least point me in the right direction


Hi,

I'd think it is at db.php
notice the: require_once("db.php");

Regards,
--
Arturo

thanks
> --
> db

Hi,

Ok I'm stuck... any help would be very much appreciated thanks!!!

This is all I'm getting when trying to connect to cacti using "
http://whatever/cacti"



  Error

You have created a new database, but have not yet imported the 'cacti.sql'
file. At the command line, execute the following to continue: mysql -u spud
-p cactidb < cacti.sql


This error may also be generated if the cacti database user does not have
correct permissions on the cacti database. Please ensure that the cacti
database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE,
ALTER, DROP, INDEX on the cacti database.


  Now I have imported the cacti.sql file because i remember doing it and I
can see it through 'mysql-administrator'  that the tables have been imported
into the cactidb database; And I have also checked the permissions through
mysql-admin for use "spud" and that user does have ALL permissions added.
In "/var/log/cacti/cacti.log" I'm getting these errors

CMDPHP: Poller[0] ERROR: SQL Cell Failed "select cacti from version"
CMDPHP: Poller[0] ERROR: Cannot connect to MYSQL server on 'localhost'.
Please make sure you have specified a vaild MySQL database in
'include/config.php'.


So I look inside the config.php file and...


----------------------------------------------------------------------------------------

<?php
/*
+-------------------------------------------------------------------------+
| Copyright (C) 2004 Ian Berry                                            |
|                                                                         |
| This program is free software; you can redistribute it and/or           |
| modify it under the terms of the GNU General Public License             |
| as published by the Free Software Foundation; either version 2          |
| of the License, or (at your option) any later version.                  |
|                                                                         |
| This program is distributed in the hope that it will be useful,         |
| but WITHOUT ANY WARRANTY; without even the implied warranty of          |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
| GNU General Public License for more details.                            |
+-------------------------------------------------------------------------+
| cacti: a php-based graphing solution                                    |
+-------------------------------------------------------------------------+
| Most of this code has been designed, written and is maintained by       |
| Ian Berry. See about.php for specific developer credit. Any questions   |
| or comments regarding this code should be directed to:                  |
| - ib...@ra...                                                     |
+-------------------------------------------------------------------------+
| - raXnet - http://www.raxnet.net/                                       |
+-------------------------------------------------------------------------+
*/
require_once("db.php");
/* ----- you probably do not need to change anything below this line -----
*/

/* Files that do not need http header information - Command line scripts */
$no_http_header_files = array(
    "poller.php",
    "cmd.php",
    "query_host_cpu.php",
    "query_host_partitions.php",
    "poller_reindex_hosts.php",
    "poller_export.php",
    "poller_commands.php",
    "rebuild_poller_cache.php",
    "script_server.php",
    "sql.php",
    "ss_host_cpu.php",
    "ss_host_disk.php",
    "ss_sql.php"
);

$config = array();
$colors = array();

/* this should be auto-detected, set it manually if needed */
$config["cacti_server_os"] = (strstr(PHP_OS, "WIN")) ? "win32" : "unix";

/* built-in snmp support */
$config["php_snmp_support"] = function_exists("snmpget");

/* used for includes */
$config["base_path"] = strtr(ereg_replace("(.*)[\/\\]include", "\\1",
dirname(__FILE__)), "\\", "/");
$config["library_path"] = ereg_replace("(.*[\/\\])include", "\\1lib",
dirname(__FILE__));
$config["include_path"] = dirname(__FILE__);

/* colors */
$colors["dark_outline"] = "454E53";
$colors["dark_bar"] = "AEB4B7";
$colors["panel"] = "E5E5E5";
$colors["panel_text"] = "000000";
$colors["panel_link"] = "000000";
$colors["light"] = "F5F5F5";
$colors["alternate"] = "E7E9F2";
$colors["panel_dark"] = "C5C5C5";

$colors["header"] = "00438C";
$colors["header_panel"] = "6d88ad";
$colors["header_text"] = "ffffff";
$colors["form_background_dark"] = "E1E1E1";

$colors["form_alternate1"] = "F5F5F5";
$colors["form_alternate2"] = "E5E5E5";

if ((!in_array(basename($_SERVER["PHP_SELF"]), $no_http_header_files, true))
&& ($_SERVER["PHP_SELF"] != "")) {
    /* we don't want these pages cached */
    header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
    header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
    header("Cache-Control: no-store, no-cache, must-revalidate");
    header("Cache-Control: post-check=0, pre-check=0", false);
    header("Pragma: no-cache");

    /* initilize php session */
    session_start();

    /* detect and handle get_magic_quotes */
    if (!get_magic_quotes_gpc()) {
        function addslashes_deep($value) {
            $value = is_array($value) ? array_map('addslashes_deep', $value)
: addslashes($value);
            return $value;
        }

        $_POST = array_map('addslashes_deep', $_POST);
        $_GET = array_map('addslashes_deep', $_GET);
        $_COOKIE = array_map('addslashes_deep', $_COOKIE);
    }

    /* make sure to start only only Cacti session at a time */
    if (!isset($_SESSION["cacti_cwd"])) {
        $_SESSION["cacti_cwd"] = $config["base_path"];
    }else{
        if ($_SESSION["cacti_cwd"] != $config["base_path"]) {
            session_unset();
            session_destroy();
        }
    }
}

/* emulate 'register_globals' = 'off' if turned on */
if ((bool)ini_get("register_globals")) {
    $not_unset = array("_GET", "_POST", "_COOKIE", "_SERVER", "_SESSION",
"_ENV", "_FILES", "database_type", "database_default", "database_hostname",
"database_username", "database_password", "config", "colors");

    /* Not only will array_merge give a warning if a parameter is not an
array, it will
    * actually fail. So we check if HTTP_SESSION_VARS has been initialised.
*/
    if (!isset($_SESSION)) {
        $_SESSION = array();
    }

    /* Merge all into one extremely huge array; unset this later */
    $input = array_merge($_GET, $_POST, $_COOKIE, $_SERVER, $_SESSION,
$_ENV, $_FILES);

    unset($input["input"]);
    unset($input["not_unset"]);

    while (list($var,) = @each($input)) {
        if (!in_array($var, $not_unset)) {
            unset($$var);
        }
    }

    unset($input);
}

/* display ALL errors */
error_reporting(E_ALL);

/* include base modules */
include($config["library_path"] . "/adodb/adodb.inc.php");
include($config["library_path"] . "/database.php");
include_once($config["library_path"] . "/functions.php");
include_once($config["include_path"] . "/config_constants.php");
include_once($config["include_path"] . "/config_arrays.php");
include_once($config["include_path"] . "/config_settings.php");

/* connect to the database server */
db_connect_real($database_hostname, $database_username, $database_password,
$database_default, $database_type, $database_port);

/* include additional modules */
include_once($config["include_path"] . "/config_form.php");
include_once($config["library_path"] . "/html.php");
include_once($config["library_path"] . "/html_form.php");
include_once($config["library_path"] . "/html_utility.php");
include_once($config["library_path"] . "/html_validate.php");
include_once($config["library_path"] . "/variables.php");
include_once($config["library_path"] . "/auth.php");

/* current cacti version */
$config["cacti_version"] = "0.8.6i";

?>
----------------------------------------------------------------------------------------



So where do I specifie a valid MySQL database in there?

I am completely at a dead end with this and have gone over this many times
and gotten nowhere. Anyone got an idea where I should start looking or at
least point me in the right direction

thanks
-- 
db

Hi,

Is is possible for cacti to archive the graphs up to 5 years? One of my 
customers wants to be able to see all the history up to 5 years.

Thanks
Victor

On Tue, 2006-12-26 at 10:40 +0530, Siddharth Deshpande wrote:
> > Message: 5
> > Date: Fri, 22 Dec 2006 10:24:25 +0100 (MET)
> > From: Reinhard Scheck <Rei...@te...>
> > Subject: Re: [cacti-user] Help needed with Cacti installation on Linux
> 
> > You've got the wrong tarball. You've downloaded cactid instead of cacti. cactid is the fast poller
> > that supports cacti
> > 
> > Reinhard
> 


	Well i downloaded the *correct* tarball this time, and am just
following the directions given in the cacti manual, and seem to have
gotten further than i've ever had. According to the manual:


> 1. Extract the distribution tarball.
>    shell> tar xzvf cacti-version.tar.gz
	- i extracted it to /usr/src/cacti.


> 2. Create the MySQL database:
>    shell> mysqladmin --user=root create cacti
> 3. Import the default cacti database:
>    shell> mysql cacti < cacti.sql
> 4. Optional: Create a MySQL username and password for Cacti.
>    shell> mysql --user=root mysql
>    mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY
> ’somepassword’;
>    mysql> flush privileges;
> 5. Edit include/config.php and specify the MySQL user, password and
> database for your Cacti configuration.
>    $database_default = "cacti";
>    $database_hostname = "localhost";
>    $database_username = "cactiuser";
>    $database_password = "cacti";
> 
	- did ALL of the above with exactly the same settings.
> 
> 6. Set the appropriate permissions on cacti’s directories for graph/log generation. You should execute these com-
>    mands from inside cacti’s directory to change the permissions.
>    shell> chown -R cactiuser rra/ log/
>    (Enter a valid username for cactiuser, this user will also be used in the next step for data gathering.)
	- now this is where i'm thrown a little off.. it says (obviously) that
"cactiuser" is an invalid username, so i tried it with root, and it let
me proceed further.

Then, it says:

> 
> 7. Add a line to your /etc/crontab file similar to:
>    */5 * * * * cactiuser php /var/www/html/cacti/poller.php  /dev/null
> 2>&1
>    Replace cactiuser with the valid user specified in the previous
> step. 
> - Replace /var/www/html/cacti/ with your full Cacti path.
	- which i did (replaced cactiuser with root, and /var/www/html/cacti/
with /usr/scr/cacti).


> 8. Point your web browser to:
>      http://your-server/cacti/

	which is where it all falls apart. NOTE: i am using runit, not the
default init. I have manually created a service for cron (as
initscripts don't work with runit), the daemon itself (alongwith a
helper daemon for logging it) seems to be running, but this thing is
not happening. 	i do http://localhost/cacti and i get a 404 not found.
i have apache running (but never really configured) on this system.
when i do a netstat, this is what i get:


> # netstat -natp
> 
> Active Internet connections (servers and established)
> Proto Recv-Q Send-Q 	Local Address           Foreign Address         State       PID/Program name
> ...
> ...
> tcp        0      0 	0.0.0.0:80              0.0.0.0:*               LISTEN     10877/apache
> ...
> tcp        0      0 	127.0.0.1:80            127.0.0.1:35718         TIME_WAIT  -
> ...
> 

	i do not know if this has any special significance, may just be useful
to some1 in debugging the problem. And, yes, if i just open
http://localhost or http://127.0.0.1 in my browser, i get the default
web-page. So obviously that means that the web server itself is
running.
 	So what's the deal with cacti? is there some other
configuration step i'm missing here? Please help!

- Siddharth.

> Message: 5
> Date: Fri, 22 Dec 2006 10:24:25 +0100 (MET)
> From: Reinhard Scheck <Rei...@te...>
> Subject: Re: [cacti-user] Help needed with Cacti installation on Linux

> You've got the wrong tarball. You've downloaded cactid instead of cacti. cactid is the fast poller
> that supports cacti
> 
> Reinhard

	- Ammmmmaaaaaaaaaazzzzzzzzing! Thanx a lot guys. I really don't know
how i ended up with such a super blooper! coz i did this twice! Anyways,
will try it out. will cactid cause any problems if it's still there on
the system while i'm installing cacti?

- cheers,
siddharth.

> -----Original Message-----
> From: cac...@li... 
> [mailto:cac...@li...] On Behalf 
> Of Thomas Schweikle
> Sent: December 22, 2006 5:14
> To: terry mcintyre; cac...@li...
> Subject: Re: [cacti-user] Cacti DB error

[...]

> > after installing cacti on a new system using php5, MySQL 5.0.27,
> > and apache 2.2.3. I am seeing this error:
> > 
> > You have created a new database, but have not yet imported the
> > 'cacti.sql' file. At the command line, execute the following to
> > continue:
> > 
> > mysql -u cactiuser -p cacti < cacti.sql
> > 
> > This error may also be generated if the cacti database user does
> > not have correct permissions on the cacti database. Please
> > ensure that the cacti database user has the ability to SELECT,
> > INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti
> > database.
> > 
> > But this database exists. It is named cacti. The username and
> > password are correctly entered in "include/config.php". Logging
> > into the database with "mysql -u cactiuser -pcactipassword
> > cacti" succeeds. I have tried "php index.php", but this does not
> >  show any anomalities (except the warning: "PHP Warning:  Module
> > 'yaz' already loaded in Unknown on line 0" --- but this can be
> > ignored afaik). There is no other output from this call
> > shouldn't it give back some html code?
> 
> If I use php4 with MySQL 4.0 it works (this is on an other
> system --- but on the new system I am bound to use php5 with
> MySQL 5.0).

I've run cacti with php4 and mysql5 in the past; it works perfectly.

For some reasons (unrelated to PHP) I was using MySQL 4.1 libraries, which
are fully compatible with MySQL 5.0

Thomas

On 12/22/06, J.P. Pasnak <pa...@wa...> wrote:
>
>
> You downloaded cactid -  which is a C Poller for Cacti, not cacti
>
> Download cacti:
>
> http://www.cacti.net/downloads/cacti-0.8.6i.tar.gz
>
Also, as you are on Debian, you might try to install it from the
repositories. I did it on mi Ubuntu box without a problem. On the forum, I
find this about Debian installs:

http://forums.cacti.net/about9179.html

Regards,
--
Arturo

--
> Live fast, die young,
> You're sucking up my bandwidth.
>
> J.P. Pasnak, CD
> CCNA, LPIC-1
> http://www.warpedsystems.sk.ca
>
>

Siddharth Deshpande wrote:
> Hi,
> I'm trying to install Cacti on a Debian system (a practice machine, i
> will do the real thing once i've gotten the hang of this), to do some
> network monitoring tasks, and i'm been having some serious trouble with
> this. Here's what i have done.
>
> 1. downloaded the tarball cacti-cactid-0.8.6i.tar.gz from the cacti
> website.

You downloaded cactid -  which is a C Poller for Cacti, not cacti

Download cacti:

http://www.cacti.net/downloads/cacti-0.8.6i.tar.gz

--=20
Live fast, die young,
You're sucking up my bandwidth.

J.P. Pasnak, CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca