个人工具

“UbuntuHelp:Cacti”的版本间的差异

来自Ubuntu中文

跳转至: 导航, 搜索
(新页面: {{From|https://help.ubuntu.com/community/Cacti}} {{Languages|UbuntuHelp:Cacti}} == Introduction == [http://www.cacti.net/ Cacti] is a complete network graphing solution designed to har...)
 
 
(未显示2个用户的14个中间版本)
第1行: 第1行:
 
{{From|https://help.ubuntu.com/community/Cacti}}
 
{{From|https://help.ubuntu.com/community/Cacti}}
 
{{Languages|UbuntuHelp:Cacti}}
 
{{Languages|UbuntuHelp:Cacti}}
 
+
<<Include(Tag/Unsupported)>>
 
+
 
== Introduction ==
 
== Introduction ==
 
 
[http://www.cacti.net/ Cacti] is a complete network graphing solution designed to harness the power of RRDTool's data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices.
 
[http://www.cacti.net/ Cacti] is a complete network graphing solution designed to harness the power of RRDTool's data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices.
 
+
== Cacti on Gutsy ==
 +
=== snmpd setup ===
 +
apt-get install snmp snmpd<<BR>>
 +
snmpconf -g basic_setup
 
== Installing Cacti on Ubuntu 6.06 LTS (Dapper Drake) ==
 
== Installing Cacti on Ubuntu 6.06 LTS (Dapper Drake) ==
 
 
=== Caveats ===
 
=== Caveats ===
 
+
* These instructions are for the graphical installer.  Server installation instructions are found below.
*** These instructions are for the graphical installer.  Server installation instructions are found below.
+
* If this procedure doesn't work for you, try the previous procedure which is documented below.
*** If you have already created a MySQL root password before installing Cacti, the Cacti install will fail.
+
*** If this procedure doesn't work for you, try the previous procedure which is documented below.
+
 
+
=== Enable the extra software repositories ===
+
 
+
*** Go to: System > Administration > Software Properties
+
*** Click on all the empty checkboxes to enable the additional software repositories
+
 
+
 
=== Install MySQL server ===
 
=== Install MySQL server ===
 +
To install MySQL server you need to install the mysql-server package
 +
=== Install Cacti ===
 +
<ol><li>You can get the cacti package from the Universe Repository.
 +
</li><li>Click "Forward" on the warning titled "Configuring libphp-adodb"
 +
</li><li>If you have entered a root password for MySQL, enter it on the window titled "Password of your database's administrative user:".</li></ol>
  
** Go to: System > Administration > Synaptic Package Manager
+
If the root password is blank, just hit enter and continue.
** Click on "Search" and type "mysql-server" in the pop-up window
+
<ol><li>Leave the question "MySQL application password for Cacti" blank and hit "Forward".</li></ol>
** Click on the checkbox next to "mysql-server" and choose to "Mark for installation"
+
** Click "Mark" on the pop-up screen asking if you want to install the dependancies
+
** Click "Apply" and then click "Apply" again on the pop-up screen to confirm this action.
+
  
=== Install Cacti ===
+
* Note:  The system will create a random password for you, so you don't need to enter one
 
+
<ol><li>On the "Webserver type" question, select "Apache2" and then click "Forward"</li></ol>
** Go to: System > Administration > Synaptic Package Manager
+
** Click on "Search" and type "cacti" in the pop-up window
+
** Click on the checkbox next to "cacti" and choose to "Mark for installation"
+
** Click "Mark" on the pop-up screen asking if you want to install the dependancies
+
** Click "Apply" and then click "Apply" again on the pop-up screen to confirm this action.
+
** Click "Forward" on the warning titled "Configuring libphp-adodb"
+
** Leave the question "Password of your database's administrative user:" blank and hit "Forward".
+
** Leave the question "MySQL application password for Cacti" blank and hit "Forward".
+
Note:  The system will create a random password for you, so you don't need to enter one
+
** On the "Webserver type" question, select "Apache2" and then click "Forward"
+
  
 
=== Setup Cacti ===
 
=== Setup Cacti ===
 
+
<ol><li>Visit the website of your Cacti server, should be similar to "http://localhost/cacti/"
** Visit the website of your Cacti server, should be similar to "http://localhost/cacti/"
+
</li><li>This should automatically initiate the "Cacti Installation Guide" in your web-browser
** This should automatically initiate the "Cacti Installation Guide" in your web-browser
+
</li><li>Click "Next", "Next", and "Finish" to complete this guide
** Click "Next", "Next", and "Finish" to complete this guide
+
</li><li>Login to Cacti with the default username and password of "admin" and "admin"
** Login to Cacti with the default username and password of "admin" and "admin"
+
</li><li>You will be forced to change the "admin" password to something new
** You will be forced to change the "admin" password to something new
+
</li><li>'''Cacti is now successfully installed!'''</li></ol>
** '''Cacti is now successfully installed!'''
+
  
 
=== Recommended: Create a root password for MySQL ===
 
=== Recommended: Create a root password for MySQL ===
 
+
If you have a blank root password for MySQL then you are recommended to create one.
** Go to: Applications > Accessories > Terminal
+
Note: Choose a password and place it between the quotation marks below
+
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo mysqladmin -u root password "YourPasswordGoesHere"
 
sudo mysqladmin -u root password "YourPasswordGoesHere"
</nowiki></pre>
+
    </nowiki></pre>
 
+
 
== Installing Cacti on Ubuntu Server 6.06 (Dapper Drake) ==
 
== Installing Cacti on Ubuntu Server 6.06 (Dapper Drake) ==
 +
<ol><li>To install MySQL-server install the mysql-server package.
 +
</li><li>To install Cacti install the cacti package from the Universe Repository.
 +
</li><li>Leave the question "Password of your database's administrative user:" blank and hit "Forward".
 +
</li><li>Leave the question "MySQL application password for Cacti" blank and hit "Forward".</li></ol>
  
** add the extra sources into apt.  (sudo nano /etc/apt/sources.list and then remove the comment lines in front of the "universe" and "security" repositories.)
+
*Note:  The system will create a random password for you, so you don't need to enter one
** sudo apt-get update
+
<ol><li>On the "Webserver type" question, select "Apache2" and then click "Forward"</li></ol>
** sudo apt-get install mysql-server
+
** sudo apt-get install cacti
+
** Leave the question "Password of your database's administrative user:" blank and hit "Forward".
+
** Leave the question "MySQL application password for Cacti" blank and hit "Forward".
+
Note:  The system will create a random password for you, so you don't need to enter one
+
** On the "Webserver type" question, select "Apache2" and then click "Forward"
+
  
 
=== Setup Cacti ===
 
=== Setup Cacti ===
 
+
<ol><li>Visit the website of your Cacti server, should be similar to "http://server.ip.address/cacti/"
** Visit the website of your Cacti server, should be similar to "http://server.ip.address/cacti/"
+
</li><li>This should automatically initiate the "Cacti Installation Guide" in your web-browser
** This should automatically initiate the "Cacti Installation Guide" in your web-browser
+
</li><li>Click "Next", "Next", and "Finish" to complete this guide
** Click "Next", "Next", and "Finish" to complete this guide
+
</li><li>Login to Cacti with the default username and password of "admin" and "admin"
** Login to Cacti with the default username and password of "admin" and "admin"
+
</li><li>You will be forced to change the "admin" password to something new
** You will be forced to change the "admin" password to something new
+
</li><li>'''Cacti is now successfully installed!'''</li></ol>
** '''Cacti is now successfully installed!'''
+
  
 
=== Recommended: Create a root password for MySQL ===
 
=== Recommended: Create a root password for MySQL ===
 
+
Now you need to create a root password for MySQL
** Go to: Applications > Accessories > Terminal
+
* Note: Choose a password and place it between the quotation marks below
Note: Choose a password and place it between the quotation marks below
+
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo mysqladmin -u root password "YourPasswordGoesHere"
 
sudo mysqladmin -u root password "YourPasswordGoesHere"
</nowiki></pre>
+
      </nowiki></pre>
 
+
 
== Previous Documentation on Installing Cacti ==
 
== Previous Documentation on Installing Cacti ==
 
=== Installing Cacti for Ubuntu - Part 1 ===
 
=== Installing Cacti for Ubuntu - Part 1 ===
 
 
1. Open up a terminal window, easiest to log in as root
 
1. Open up a terminal window, easiest to log in as root
 +
2. Install Apache2 (If not already installed) by installing the apache2 package.
  
2. Install Apache2 (If not already installed) by installing the following packages<pre><nowiki>apache2
+
}}} (see [[UbuntuHelp:InstallingSoftware|InstallingSoftware]]).
</nowiki></pre> (see InstallingSoftware).
+
3. Install MySQL components (If not already installed) by installing the php5-mysql and mysql-server packages (see [[UbuntuHelp:InstallingSoftware|InstallingSoftware]]).
 +
4. During the mail server installation, select the following options if you're not sure what else to use:
  
3. Install MySQL components (If not already installed) by installing the following packages <code><nowiki>php5-mysql, mysql-server</nowiki></code> (see InstallingSoftware).
+
<pre><nowiki>
 
+
Internet Site
4. During the mail server installation, select the following options if you're not sure what else to use:
+
<pre><nowiki>Internet Site
+
 
localhost.localdomain (for the purposes of this install of cacti, i just left this as default)</nowiki></pre>
 
localhost.localdomain (for the purposes of this install of cacti, i just left this as default)</nowiki></pre>
 +
5. Install Cacti by installing the Cacti package in Ubuntu (see [[UbuntuHelp:InstallingSoftware|InstallingSoftware]]).
 +
6. During the cacti installation, select the following options if you're not sure what else to use:
  
5. Install Cacti package: <code><nowiki>cacti</nowiki></code> (see InstallingSoftware).
 
 
6. During the cacti installation, select the following options if you're not sure what else to use:
 
 
<pre><nowiki>
 
<pre><nowiki>
 
MySQL server host name: localhost
 
MySQL server host name: localhost
第111行: 第84行:
 
</nowiki></pre>
 
</nowiki></pre>
 
7. Install the MySQL database: (ignore the mysql instructions to change your password; proceed to step 8.)
 
7. Install the MySQL database: (ignore the mysql instructions to change your password; proceed to step 8.)
 +
 
<pre><nowiki>
 
<pre><nowiki>
 
mysql_install_db
 
mysql_install_db
 
</nowiki></pre>
 
</nowiki></pre>
 
8. Create a MySQL database called "cacti":
 
8. Create a MySQL database called "cacti":
 +
 
<pre><nowiki>
 
<pre><nowiki>
 
mysqladmin --user=root create cacti
 
mysqladmin --user=root create cacti
第125行: 第100行:
 
</nowiki></pre>
 
</nowiki></pre>
 
NOTE: make "cacti_password" whatever you set the cacti password to during the installation of cacti.
 
NOTE: make "cacti_password" whatever you set the cacti password to during the installation of cacti.
 
 
11. Type:  
 
11. Type:  
 
<pre><nowiki>
 
<pre><nowiki>
第135行: 第109行:
 
</nowiki></pre>
 
</nowiki></pre>
 
13. You will be prompted for a password here, use the same password again you set during the installation of cacti.
 
13. You will be prompted for a password here, use the same password again you set during the installation of cacti.
 
 
=== Installing Cacti for Ubuntu - Part 2 ===
 
=== Installing Cacti for Ubuntu - Part 2 ===
 
 
1. Open a web browser on the machine with cacti installed
 
1. Open a web browser on the machine with cacti installed
 
+
2. Type [http://localhost/cacti] into the address bar. Note, you can also use the IP address or DNS address of the PC instead of using "localhost".</li>
2. Type [[UbuntuHelp:http://localhost/cacti]] into the address bar. Note, you can also use the IP address or DNS address of the PC instead of using "localhost".</li>
+
 
+
 
3. Click '''Next'''
 
3. Click '''Next'''
 
 
4. Make sure '''New Install''' is selected and click '''Next'''
 
4. Make sure '''New Install''' is selected and click '''Next'''
 
 
5. If all steps in Part 1 were followed correctly, all options on this page should show as <font color="green">[FOUND]</font>
 
5. If all steps in Part 1 were followed correctly, all options on this page should show as <font color="green">[FOUND]</font>
 
 
6. Make sure '''NET-SNMP 5.x''' and '''RRDTool 1.2.x''' are selected and click '''Next'''
 
6. Make sure '''NET-SNMP 5.x''' and '''RRDTool 1.2.x''' are selected and click '''Next'''
 
 
7. At this point, you should be prompted to login. You can use the username '''Admin''' and any password you previously set for this account, if any. The fault password should be '''admin'''. Upon logging in you'll most likely be forced to change your password for security purposes.
 
7. At this point, you should be prompted to login. You can use the username '''Admin''' and any password you previously set for this account, if any. The fault password should be '''admin'''. Upon logging in you'll most likely be forced to change your password for security purposes.
 
 
8. You should now be logged into cacti, if you need further assistance from here, it most likely won't be ubuntu specific so you should be able to refer to the generic guides on [http://www.cacti.net/] .
 
8. You should now be logged into cacti, if you need further assistance from here, it most likely won't be ubuntu specific so you should be able to refer to the generic guides on [http://www.cacti.net/] .
  
 
=== Installing Cacti for Ubuntu - Part 3: Errors FAQ (Work In Progress) ===
 
=== Installing Cacti for Ubuntu - Part 3: Errors FAQ (Work In Progress) ===
 
 
'''Q1.''' When I go to localhost/cacti, I keep getting the follow error:
 
'''Q1.''' When I go to localhost/cacti, I keep getting the follow error:
 
<pre><nowiki>
 
<pre><nowiki>
第161行: 第125行:
 
</nowiki></pre>
 
</nowiki></pre>
 
'''A.''' If you get this error, you've set the wrong password for cacti in mysql. To fix it, follow steps 9 & 10 in Part 1 of this guide.
 
'''A.''' If you get this error, you've set the wrong password for cacti in mysql. To fix it, follow steps 9 & 10 in Part 1 of this guide.
 
 
'''A2.''' You can also get this message if you run the GRANT ALL command without the quotes around the password or without the semi-colon at the end.
 
'''A2.''' You can also get this message if you run the GRANT ALL command without the quotes around the password or without the semi-colon at the end.
 
 
'''Q2.''' The default password won't work when I try to log in through the web interface, how can I log in?
 
'''Q2.''' The default password won't work when I try to log in through the web interface, how can I log in?
 
 
'''A.''' Go back to command line and type '''mysql'''. At the mysql> prompt, type:
 
'''A.''' Go back to command line and type '''mysql'''. At the mysql> prompt, type:
 
<pre><nowiki>
 
<pre><nowiki>
update user_auth set password == md5('admin') where username == 'admin';
+
update user_auth set password = md5('admin') where username = 'admin';
 
</nowiki></pre>
 
</nowiki></pre>
 
'''Q3.''' I get a "red X" and my graphs will not display properly.
 
'''Q3.''' I get a "red X" and my graphs will not display properly.
 
 
'''A.''' I have found that this is because the mysql module sometimes does not get properly registered with PHP.  Run the command "php -m" and if you do not see mysql listed then this is your problem.  Run the command "dpkg-reconfigure php5-mysql" to correct the problem and then run the command "php -m" again to see if it is now listed.  Run the command "apache2ctl restart" to restart the Apache server.
 
'''A.''' I have found that this is because the mysql module sometimes does not get properly registered with PHP.  Run the command "php -m" and if you do not see mysql listed then this is your problem.  Run the command "dpkg-reconfigure php5-mysql" to correct the problem and then run the command "php -m" again to see if it is now listed.  Run the command "apache2ctl restart" to restart the Apache server.
 
 
'''Q4.''' I get a "red X" and my graphs will not display properly.
 
'''Q4.''' I get a "red X" and my graphs will not display properly.
 
<pre><nowiki>
 
<pre><nowiki>
 
Fatal error: Call to undefined function mysql_pconnect() in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 372
 
Fatal error: Call to undefined function mysql_pconnect() in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 372
 
</nowiki></pre>
 
</nowiki></pre>
 
 
'''A.''' This is probably due to the fact that the poller runs using the commandline php. So you have to edit /etc/php5/cli/php.ini and make sure you add extension=mysql.so.
 
'''A.''' This is probably due to the fact that the poller runs using the commandline php. So you have to edit /etc/php5/cli/php.ini and make sure you add extension=mysql.so.
 
 
'''Q5.''' When I add a graph, I notice an error in the log: "CMDPHP: Poller[0] ERROR: SQL Exec Failed "update data_template_data set rrd_maximum='|query_ifSpeed|' where local_data_id=8""
 
'''Q5.''' When I add a graph, I notice an error in the log: "CMDPHP: Poller[0] ERROR: SQL Exec Failed "update data_template_data set rrd_maximum='|query_ifSpeed|' where local_data_id=8""
 
 
'''A.''' I believe there's a problem with the package.  The query is trying to update a field in a column that doesn't exist in the table data_template_data.  I was able to clear this error by running 'sudo apt-get remove cacti' and installing 0.8.6i manually.  (I think the package currently installs 0.8.6h)  I didn't locate a .php file  that had both the string 'data_template_data' and the string 'rrd_maximum' but something launched that sql command.  
 
'''A.''' I believe there's a problem with the package.  The query is trying to update a field in a column that doesn't exist in the table data_template_data.  I was able to clear this error by running 'sudo apt-get remove cacti' and installing 0.8.6i manually.  (I think the package currently installs 0.8.6h)  I didn't locate a .php file  that had both the string 'data_template_data' and the string 'rrd_maximum' but something launched that sql command.  
 
 
'''Q6.''' When I change the Title of a graph, the graph disappears from the list.  The log says, "CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id= and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')"  
 
'''Q6.''' When I change the Title of a graph, the graph disappears from the list.  The log says, "CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id= and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')"  
 
 
'''A.''' I believe there's a problem with the package.  This sql query is just broken - though it may be the log process munging the report of the query being attempted rather than the query itself.  I was able to clear this error by running 'sudo apt-get remove cacti' and installing 0.8.6i manually.  (I think the package currently installs 0.8.6h)
 
'''A.''' I believe there's a problem with the package.  This sql query is just broken - though it may be the log process munging the report of the query being attempted rather than the query itself.  I was able to clear this error by running 'sudo apt-get remove cacti' and installing 0.8.6i manually.  (I think the package currently installs 0.8.6h)
 
 
 
----
 
----
[[category:CategoryDocumentation]] [[category:CategoryCleanup]] [[category:CategoryDocumentation]]
+
[[category:CategoryNetworking]]
  
 
[[category:UbuntuHelp]]
 
[[category:UbuntuHelp]]

2010年5月19日 (三) 21:49的最新版本


<<Include(Tag/Unsupported)>>

Introduction

Cacti is a complete network graphing solution designed to harness the power of RRDTool's data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices.

Cacti on Gutsy

snmpd setup

apt-get install snmp snmpd<
> snmpconf -g basic_setup

Installing Cacti on Ubuntu 6.06 LTS (Dapper Drake)

Caveats

  • These instructions are for the graphical installer. Server installation instructions are found below.
  • If this procedure doesn't work for you, try the previous procedure which is documented below.

Install MySQL server

To install MySQL server you need to install the mysql-server package

Install Cacti

  1. You can get the cacti package from the Universe Repository.
  2. Click "Forward" on the warning titled "Configuring libphp-adodb"
  3. If you have entered a root password for MySQL, enter it on the window titled "Password of your database's administrative user:".

If the root password is blank, just hit enter and continue.

  1. Leave the question "MySQL application password for Cacti" blank and hit "Forward".
  • Note: The system will create a random password for you, so you don't need to enter one
  1. On the "Webserver type" question, select "Apache2" and then click "Forward"

Setup Cacti

  1. Visit the website of your Cacti server, should be similar to "http://localhost/cacti/"
  2. This should automatically initiate the "Cacti Installation Guide" in your web-browser
  3. Click "Next", "Next", and "Finish" to complete this guide
  4. Login to Cacti with the default username and password of "admin" and "admin"
  5. You will be forced to change the "admin" password to something new
  6. Cacti is now successfully installed!

Recommended: Create a root password for MySQL

If you have a blank root password for MySQL then you are recommended to create one.

sudo mysqladmin -u root password "YourPasswordGoesHere"
    

Installing Cacti on Ubuntu Server 6.06 (Dapper Drake)

  1. To install MySQL-server install the mysql-server package.
  2. To install Cacti install the cacti package from the Universe Repository.
  3. Leave the question "Password of your database's administrative user:" blank and hit "Forward".
  4. Leave the question "MySQL application password for Cacti" blank and hit "Forward".
  • Note: The system will create a random password for you, so you don't need to enter one
  1. On the "Webserver type" question, select "Apache2" and then click "Forward"

Setup Cacti

  1. Visit the website of your Cacti server, should be similar to "http://server.ip.address/cacti/"
  2. This should automatically initiate the "Cacti Installation Guide" in your web-browser
  3. Click "Next", "Next", and "Finish" to complete this guide
  4. Login to Cacti with the default username and password of "admin" and "admin"
  5. You will be forced to change the "admin" password to something new
  6. Cacti is now successfully installed!

Recommended: Create a root password for MySQL

Now you need to create a root password for MySQL

  • Note: Choose a password and place it between the quotation marks below
sudo mysqladmin -u root password "YourPasswordGoesHere"
      

Previous Documentation on Installing Cacti

Installing Cacti for Ubuntu - Part 1

1. Open up a terminal window, easiest to log in as root 2. Install Apache2 (If not already installed) by installing the apache2 package.

}}} (see InstallingSoftware). 3. Install MySQL components (If not already installed) by installing the php5-mysql and mysql-server packages (see InstallingSoftware). 4. During the mail server installation, select the following options if you're not sure what else to use:

Internet Site
localhost.localdomain (for the purposes of this install of cacti, i just left this as default)

5. Install Cacti by installing the Cacti package in Ubuntu (see InstallingSoftware). 6. During the cacti installation, select the following options if you're not sure what else to use:

MySQL server host name: localhost
Database name for cacti: cacti
Cacti database username: cacti
Cacti user password: cacti_password
Webserver type: Apache2

7. Install the MySQL database: (ignore the mysql instructions to change your password; proceed to step 8.)

mysql_install_db

8. Create a MySQL database called "cacti":

mysqladmin --user=root create cacti

9. Type mysql to enter into MySQL management.

10. At the mysql> prompt, type:

GRANT ALL ON cacti.* TO cacti@localhost IDENTIFIED BY "cacti_password";

NOTE: make "cacti_password" whatever you set the cacti password to during the installation of cacti. 11. Type:

exit

12. Back at the shell type:

zcat /usr/share/doc/cacti/cacti.sql.gz |mysql -u cacti -p cacti

13. You will be prompted for a password here, use the same password again you set during the installation of cacti.

Installing Cacti for Ubuntu - Part 2

1. Open a web browser on the machine with cacti installed 2. Type [1] into the address bar. Note, you can also use the IP address or DNS address of the PC instead of using "localhost".</li> 3. Click Next 4. Make sure New Install is selected and click Next 5. If all steps in Part 1 were followed correctly, all options on this page should show as [FOUND] 6. Make sure NET-SNMP 5.x and RRDTool 1.2.x are selected and click Next 7. At this point, you should be prompted to login. You can use the username Admin and any password you previously set for this account, if any. The fault password should be admin. Upon logging in you'll most likely be forced to change your password for security purposes. 8. You should now be logged into cacti, if you need further assistance from here, it most likely won't be ubuntu specific so you should be able to refer to the generic guides on [2] .

Installing Cacti for Ubuntu - Part 3: Errors FAQ (Work In Progress)

Q1. When I go to localhost/cacti, I keep getting the follow error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'cacti@localhost' (Using password: YES) in /usr/share/adodb/drivers/adodb-mysql.inc.php on line 338

A. If you get this error, you've set the wrong password for cacti in mysql. To fix it, follow steps 9 & 10 in Part 1 of this guide. A2. You can also get this message if you run the GRANT ALL command without the quotes around the password or without the semi-colon at the end. Q2. The default password won't work when I try to log in through the web interface, how can I log in? A. Go back to command line and type mysql. At the mysql> prompt, type:

update user_auth set password = md5('admin') where username = 'admin';

Q3. I get a "red X" and my graphs will not display properly. A. I have found that this is because the mysql module sometimes does not get properly registered with PHP. Run the command "php -m" and if you do not see mysql listed then this is your problem. Run the command "dpkg-reconfigure php5-mysql" to correct the problem and then run the command "php -m" again to see if it is now listed. Run the command "apache2ctl restart" to restart the Apache server. Q4. I get a "red X" and my graphs will not display properly.

Fatal error: Call to undefined function mysql_pconnect() in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 372

A. This is probably due to the fact that the poller runs using the commandline php. So you have to edit /etc/php5/cli/php.ini and make sure you add extension=mysql.so. Q5. When I add a graph, I notice an error in the log: "CMDPHP: Poller[0] ERROR: SQL Exec Failed "update data_template_data set rrd_maximum='|query_ifSpeed|' where local_data_id=8"" A. I believe there's a problem with the package. The query is trying to update a field in a column that doesn't exist in the table data_template_data. I was able to clear this error by running 'sudo apt-get remove cacti' and installing 0.8.6i manually. (I think the package currently installs 0.8.6h) I didn't locate a .php file that had both the string 'data_template_data' and the string 'rrd_maximum' but something launched that sql command. Q6. When I change the Title of a graph, the graph disappears from the list. The log says, "CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id= and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')" A. I believe there's a problem with the package. This sql query is just broken - though it may be the log process munging the report of the query being attempted rather than the query itself. I was able to clear this error by running 'sudo apt-get remove cacti' and installing 0.8.6i manually. (I think the package currently installs 0.8.6h)