forum.lissyara.su

Код: Выделить всё

[root@cacti ~]# mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  ....
Your MySQL connection id is 11
Server version: 5.1.55 FreeBSD port: mysql-server-5.1.55
.......
mysql>

Код: Выделить всё

cd /usr/ports/net-mgmt/cacti && make deinstall && make reinstall 

Код: Выделить всё

Cacti is now installed. If you intall it for the first time,
you may have to follow this steps to make it work correctly:

1. Create the MySQL database:
# mysqladmin --user=root create cacti
2. Create a mysql user/password for cacti:
   (change user and/or password if required)
# echo "GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactiuser'; FLUSH PRIVILEGES;" | mysql
3. Import the default cacti database:
# mysql cacti < /usr/local/share/cacti/cacti.sql
4. Edit /usr/local/share/cacti/include/config.php.
5. Add the line to cron jobs with the command:
# crontab -u cacti -e
*/5 * * * * /usr/local/bin/php /usr/local/share/cacti/poller.php > /dev/null 2>&1
6. Add alias in apache config for the cacti dir:
Alias /cacti "/usr/local/share/cacti/"
7. Be sure apache gives an access to the directory ('Allow from' keywords).
8. Open a cacti login page in your web browser and login with admin/admin.

If you update cacti, open a login page, an updating process
will start automatically.
=======================================================================
===>   Registering installation for cacti-0.8.7g
[root@cacti /usr/ports/net-mgmt/cacti]# mysqladmin --user=root creat cacti
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root@cacti /usr/ports/net-mgmt/cacti]#  

Код: Выделить всё

mysql -u root -p 

Код: Выделить всё

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost Identified BY 'cactiuser'; FLUSH PRIVILEGES;  
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)

Код: Выделить всё

mysql> cacti < /usr/local/share/cacti/cacti.sql;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cacti < /usr/local/share/cacti/cacti.sql' at line 1

Код: Выделить всё

[root@cacti ~]# mysql -u root -p -h localhost cacti </usr/local/share/cacti/cacti.sql;
Enter password: 
[root@cacti ~]#
[root@cacti ~]# mysql cacti -u root -p
Enter password: 
.............................
.............................
mysql> show tables;
mysql> show tables;
+---------------------------+
| Tables_in_cacti           |
+---------------------------+
| cdef                      |
| cdef_items                |
| colors                    |
| data_input                |
| data_input_data           |
| data_input_fields         |
.......
| user_auth_perms           |
| user_auth_realm           |
| user_log                  |
| version                   |
+---------------------------+
[code]48 rows in set (0.01 sec)

Код: Выделить всё

*/5 * * * * /usr/local/bin/php /usr/local/share/cacti/poller.php > /dev/null 2>&1

Код: Выделить всё

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 154

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 154

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 155

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 155

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 156

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 156

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 157

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 157

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Omsk' for 'OMSST/7.0/DST' instead in /usr/local/share/cacti/include/global_constants.php on line 158

Код: Выделить всё

 
<?php phpinfo(); ?>

Код: Выделить всё

...Loaded Configuration File  (none)  
Scan this dir for additional .ini files  /usr/local/etc/php  
Additional .ini files parsed  /usr/local/etc/php/extensions.ini 

Код: Выделить всё

SNMP INFORMATION 
System:Cisco IOS Software, 2800 ........ 
Uptime.......... 
HostName...... 

Ping results success 

Код: Выделить всё

 RRDTool Command: 

/usr/local/bin/rrdtool graph - \ 
--imgformat=PNG \ 
--start=-86400 \ 
--end=-300 \ 
--title='cisco2800 - CPU Usage' \ 
--rigid \ 
--base=1000 \ 
--height=120 \ 
--width=500 \ 
--alt-autoscale-max \ 
--lower-limit=0 \ 
--vertical-label='percent' \ 
--slope-mode \ 
--font TITLE:12: \ 
--font AXIS:8: \ 
--font LEGEND:10: \ 
--font UNIT:8: \ 
DEF:a="/usr/local/share/cacti/rra/cisco2800_5min_cpu_16.rrd":5min_cpu:AVERAGE \ 
AREA:a#FF0000FF:"CPU Usage"  \ 
GPRINT:a:LAST:"Current\:%8.0lf"  \ 
GPRINT:a:AVERAGE:"Average\:%8.0lf"  \ 
GPRINT:a:MAX:"Maximum\:%8.0lf\n" RRDTool Says: 

ERROR: opening '/usr/local/share/cacti/rra/cisco2800_5min_cpu_16.rrd': No such file or directory