Cacti / plugin_syslog

Syslog Plugin for Cacti
GNU General Public License v2.0
21 stars 16 forks source link

Can not load host table when use different syslog server #111

Closed sank007 closed 4 years ago

sank007 commented 4 years ago

can not load host when use different syslog server

2020/02/27 09:57:14 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti_syslog.host' doesn't exist

syslog.php host in cacti is in another server can not join

                            $hosts = syslog_db_fetch_assoc("SELECT sh.host_id, sh.host, h.id
                                FROM `" . $syslogdb_default . "`.`syslog_hosts` AS sh
                                LEFT JOIN host AS h
                                ON sh.host = h.hostname
                                OR sh.host = h.description
                                OR sh.host LIKE substring_index(h.hostname, '.', 1)
                                OR sh.host LIKE substring_index(h.description, '.', 1)
                                $hosts_where
                                ORDER BY host");
TheWitness commented 4 years ago

That's a bummer. Checking into it now.

TheWitness commented 4 years ago

This should be fixed now.