Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Getting many network interfaces via SNMP fails #102

Closed
shavenne opened this issue Dec 29, 2016 · 3 comments
Closed

Getting many network interfaces via SNMP fails #102

shavenne opened this issue Dec 29, 2016 · 3 comments

Comments

@shavenne
Copy link

shavenne commented Dec 29, 2016

Tried to add the network interfaces of my Windows machine.
It seems they are so many that it fails.
When I click the green cirle it says 'Success [0 Items, 0 Rows]'. But when I click 'Verbose Query' there are coming maaaaaaany interfaces (Index Count 48), without any error.

This is coming into the cacti log then:
2016-12-29 02:11:18 - 5 ERROR: A DB Exec Failed!, Error: Data too long for column 'field_value' at row 126
2016-12-29 02:11:18 - CMDPHP SQL Backtrace: (/host.php: 91 host_reload_query)(/host.php: 586 run_data_query)(/lib/data_query.php: 51 query_snmp_host)(/lib/data_query.php: 586 data_query_update_host_cache_from_buffer)(/lib/data_query.php: 651 db_execute)(/lib/database.php: 110 db_execute_prepared)(/lib/database.php: 174 cacti_debug_backtrace)

@cigamit
Copy link
Member

cigamit commented Dec 29, 2016

Try this database command and try again:

ALTER TABLE host_snmp_cache MODIFY COLUMN field_value varchar(512) default NULL;

@shavenne
Copy link
Author

Yep! Works now :). Thanks.

cigamit added a commit that referenced this issue Dec 29, 2016
@cigamit
Copy link
Member

cigamit commented Dec 29, 2016

Okay, upgrade script has been updated. Thanks!

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants