Hello every one!
I installed cacti + mysql on vmware ubuntu
Problem on screens
problem with mysql
Moderators: Developers, Moderators
problem with mysql
- Attachments
-
- graphs.png (47.51 KiB) Viewed 719 times
-
- logs.png (77 KiB) Viewed 719 times
Re: problem with mysql
Has the table been created ? from cacti.sql
-- Glenn
> describe poller_output;
+---------------+-----------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------------------+-------+
| local_data_id | mediumint(8) unsigned | NO | PRI | 0 | |
| rrd_name | varchar(19) | NO | PRI | | |
| time | datetime | NO | PRI | 0000-00-00 00:00:00 | |
| output | text | NO | | NULL | |
+---------------+-----------------------+------+-----+---------------------+-------+
4 rows in set (0.00 sec)
--
-- Table structure for table `poller_output`
--
CREATE TABLE poller_output (
local_data_id mediumint(8) unsigned NOT NULL default '0',
rrd_name varchar(19) NOT NULL default '',
time datetime NOT NULL default '0000-00-00 00:00:00',
output text NOT NULL,
PRIMARY KEY (local_data_id,rrd_name,time) /*!50060 USING BTREE */
) ENGINE=MyISAM;
-- Glenn
> describe poller_output;
+---------------+-----------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------------------+-------+
| local_data_id | mediumint(8) unsigned | NO | PRI | 0 | |
| rrd_name | varchar(19) | NO | PRI | | |
| time | datetime | NO | PRI | 0000-00-00 00:00:00 | |
| output | text | NO | | NULL | |
+---------------+-----------------------+------+-----+---------------------+-------+
4 rows in set (0.00 sec)
--
-- Table structure for table `poller_output`
--
CREATE TABLE poller_output (
local_data_id mediumint(8) unsigned NOT NULL default '0',
rrd_name varchar(19) NOT NULL default '',
time datetime NOT NULL default '0000-00-00 00:00:00',
output text NOT NULL,
PRIMARY KEY (local_data_id,rrd_name,time) /*!50060 USING BTREE */
) ENGINE=MyISAM;
Who is online
Users browsing this forum: No registered users and 5 guests