Cactiusers.org

I have some error message in logs

06/30/2007 07:45:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_date=ips_current_date WHERE ips_current > ips_max"
06/30/2007 07:45:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges` (ip_range, site_id, ips_current, ips_current_date) VALUES (10.1.5,2,38,2007-06-30 19:45:06)"
06/30/2007 07:45:13 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_ip_ranges WHERE ip_range='10.1.5' AND site_id='2'"
06/30/2007 07:45:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges` (ip_range, site_id, ips_current, ips_current_date) VALUES (10.1.2,2,20,2007-06-30 19:45:06)"
06/30/2007 07:45:13 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_ip_ranges WHERE ip_range='10.1.2' AND site_id='2'"

I have noticed via Webmin \ MySQL Database server what mac_track_ip_ranges table does not exist at all.

Can samebody send me description of this table? for manual creation?

CactyEZ Version 0.8.6i

Check the mactrack.sql that comes with the plugin.

I'm new in cacti and sql. What is it mine, check?
I've find this file in plagin folder. So... what else i can do?

I find also via webmin management console for
MySQL Database Server (MySQL version 4.1.20)
and cacti database there. So I look cacti databace for all table with "mac" in their names. Here is result
mac_track_device_type
mac_track_devices
mac_track_ips
mac_track_ports
mac_track_processes
mac_track_scan_dates
mac_track_scanning_functions
mac_track_sites
mac_track_temp_ports
mac
As you can see, there is no mac_track_ip_ranges table in the list

Sure I still have error message in cacti log file like this
07/11/2007 05:40:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges` (ip_range, site_id, ips_current, ips_current_date) VALUES (10.1.5,2,36,2007-07-11 17:40:08)"

I think table 'mac_track_ip_ranges' mast be there after cacti install.
Could you tell me this table format ?
thank you.

Check the "mactrack.sql" file that was included in the archive you downloaded. The definition for that table should be in there.

I find table format and create table.
waiting for result....
Thank you very much...

All right! almost....

SQL couldn't insert or replace record in new-created mac_track_ip_range
Here is log message:
07/12/2007 09:25:30 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges` (ip_range, site_id, ips_current, ips_current_date) VALUES (10.1.5,2,37,2007-07-12 09:25:14)"

I find following workaround
- I insert corresponded record by hands via sql manager, but ip_range and date-time data I place inside ‘ mark. As you can see in log message inside VALUES () – there is no data inside ‘ mark. So my sql command looks like this line:

SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges` (ip_range, site_id, ips_current, ips_current_date) VALUES (‘10.1.5’,2,37,’2007-07-12 09:25:14’)

- After that replace command successfully done
But I wouldn’t insert new ip range by hand every time. Beside that ip range info not used in my mactrack’s report. So, I’ve decide to upgrade to Device Tracking (mactrack - v1.0)

Coming soon….