| 37 | |
| 38 | === small modification === |
| 39 | |
| 40 | In your default installation mysql server runs in strict mode. let's disable it. |
| 41 | |
| 42 | Create the following file |
| 43 | {{{ |
| 44 | sudo vi /etc/mysql/conf.d/disable_strict_mode.cnf |
| 45 | }}} |
| 46 | |
| 47 | Add the following line |
| 48 | {{{ |
| 49 | [mysqld] |
| 50 | sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
| 51 | }}} |
| 52 | |
| 53 | Restart the service |
| 54 | {{{ |
| 55 | sudo service mysql restart |
| 56 | }}} |
132 | | [http://192.248.4.49/NetMon/monitor.tar.gz NetMon.vdi] |
| 152 | == Cacti Plugins == |
| 153 | |
| 154 | Cacti monitoring system have plenty of plugins available. You can download and install them. Let install the threshold plugin |
| 155 | |
| 156 | * Go to '''/usr/share/cacti/sites/plugins''' |
| 157 | |
| 158 | * To install threshold or thold pluging you also need the setting plugin to be install. Lets install both. First download the plugins |
| 159 | {{{ |
| 160 | wget http://192.248.4.49/NetMon/setting.tar.gz |
| 161 | wget http://192.248.4.49/NetMon/thold.tar.gz |
| 162 | }}} |
| 163 | |
| 164 | * Extract the files |
| 165 | {{{ |
| 166 | tar -zxvf setting.tar.gz |
| 167 | tar -zxvf thold.tar.gz |
| 168 | {{{ |
| 169 | |
| 170 | * Now go to cacti web interface and go to '''Console''' and click '''Plugin Management''' |
| 171 | |
| 172 | * You will see the downloaded plugins. Install both plugins by clicking the blue arrow icon. and enable the plugin by clicking the green arrow icon. |
| 173 | |
| 174 | * You have successfully install the thold plugin. |
| 175 | |
| 176 | * Now let's create a threshold. Go to '''Console''' and click '''Thresholds''' |
| 177 | |
| 178 | * Click '''Add''' |