Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Creating Site not working

 
Post new topic   Reply to topic    Cacti Forum Index -> Plugin: (MAC Track)
Author Message
StarLog
Cacti User


Joined: 02 Jun 2007
Posts: 128
PostPosted: Fri Feb 08, 2008 7:27 pm    Post subject: Creating Site not working Reply with quote
Running CactiEZ from cactiusers.
I am trying to create a site for the mactrack, and get the following errors:
Not sure why or what they mean.
Code:
 02/08/2008 06:16:52 PM - SYSTEM STATS: Time:51.1932 Method:spine Processes:1 Threads:1 Hosts:21 HostsPerProcess:21 DataSources:1666 RRDsProcessed:836
02/08/2008 06:15:52 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT COUNT(mac_track_devices.device_id) FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%'))"
02/08/2008 06:15:52 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_readstring, mac_track_devices.snmp_readstrings, mac_track_devices.snmp_version, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.snmp_status, mac_track_devices.ignorePorts, mac_track_devices.disabled, mac_track_devices.scan_type, mac_track_devices.ips_total, mac_track_devices.ports_total, mac_track_devices.ports_active, mac_track_devices.ports_trunk, mac_track_devices.macs_active, mac_track_devices.last_rundate, mac_track_devices.last_runmessage, mac_track_devices.last_runduration FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%')) ORDER BY site_name ASC LIMIT 0,30"
02/08/2008 06:15:48 PM - SYSTEM STATS: Time:46.7216 Method:spine Processes:1 Threads:1 Hosts:21 HostsPerProcess:21 DataSources:1666 RRDsProcessed:836
02/08/2008 06:14:53 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT count(*) FROM (mac_track_macwatch "
02/08/2008 06:13:49 PM - SYSTEM STATS: Time:45.5483 Method:spine Processes:1 Threads:1 Hosts:21 HostsPerProcess:21 DataSources:1666 RRDsProcessed:836
02/08/2008 06:13:20 PM - AUTH LOGIN: User 'admin' Authenticated
Back to top
TheWitness
Developer


Joined: 14 May 2002
Posts: 9671
Location: MI, USA
PostPosted: Sat Feb 09, 2008 6:21 am    Post subject: Reply with quote
Run the database_upgrade.php script. You may have to do it twice.

TheWitness
Back to top
StarLog
Cacti User


Joined: 02 Jun 2007
Posts: 128
PostPosted: Sat Feb 09, 2008 1:26 pm    Post subject: Reply with quote
Witness,

Thanks, got it, now to see if this fixes it.
Back to top
StarLog
Cacti User


Joined: 02 Jun 2007
Posts: 128
PostPosted: Sat Feb 09, 2008 5:46 pm    Post subject: Reply with quote
Seems we still have a problem, after running the upgrader.


Code:
 02/09/2008 05:44:22 PM - SYSTEM STATS: Time:5.9815 Method:spine Processes:1 Threads:1 Hosts:21 HostsPerProcess:21 DataSources:1130 RRDsProcessed:745
02/09/2008 05:44:22 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (829,'traffic_in','2008-02-09 17:44:22','451637980'),(829,'traffic_out','2008-02-09 17:44:22','1485783248'),(828,'traffic_in','2008-02-09 17:44:22','732754641'),(828,'traffic_out','2008-02-09 17:44:22','794906470'),(827,'traffic_in','2008-02-09 17:44:22','3480496716'),(825,'traffic_in','2008-02-09 17:44:22','2378171664'),(825,'traffic_out','2008-02-09 17:44:22','2267095750'),(822,'traffic_out','2008-02-09 17:44:22','1397904940'),(822,'traffic_in','2008-02-09 17:44:22','2173075893'),(823,'traffic_out','2008-02-09 17:44:22','3870856017'),(823,'traffic_in','2008-02-09 17:44:22','1890326829'),(824,'traffic_out','2008-02-09 17:44:22','0'),(824,'traffic_in','2008-02-09 17:44:22','0'),(827,'traffic_out','2008-02-09 17:44:22','375845508'),(843,'traffic_out','2008-02-09 17:44:22','809114024'),(826,'traffic_in','2008-02-09 17:44:22','709529864'),(826,'traffic_out','2008-02-09 17:44:22','1041532369'),(830,'traffic_out','2008-02-09 17:44:22','17616'
Back to top
StarLog
Cacti User


Joined: 02 Jun 2007
Posts: 128
PostPosted: Mon Feb 11, 2008 7:08 pm    Post subject: Reply with quote
This is what I see after the upgrade. and moving the distro to a dedicated server, off of VMWare. Doing that cleared up a bunch of problems.. But still have an issue with Mac track on the Dell switches.

Code:
 wp-sw6 (192.168.111.176)
SNMP Information

Warning: Missing argument 10 for cacti_snmp_get(), called in /var/www/html/plugins/mactrack/mactrack_devices.php on line 807 and defined in /var/www/html/lib/snmp.php on line 39

Warning: Missing argument 10 for cacti_snmp_get(), called in /var/www/html/plugins/mactrack/mactrack_devices.php on line 812 and defined in /var/www/html/lib/snmp.php on line 39

Warning: Missing argument 10 for cacti_snmp_get(), called in /var/www/html/plugins/mactrack/mactrack_devices.php on line 813 and defined in /var/www/html/lib/snmp.php on line 39

Warning: Missing argument 10 for cacti_snmp_get(), called in /var/www/html/plugins/mactrack/mactrack_devices.php on line 814 and defined in /var/www/html/lib/snmp.php on line 39
System: Neyland 24T
Uptime: 136410622
Hostname: switch6
ObjectID: .1.3.6.1.4.1.674.10895.3004
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Plugin: (MAC Track) All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group