Spine Compile Issues Here

[dagonet]

Post the output of your "./configure" command please. I will accomodate in the build script.

TheWitness

As you requested:
marcus@ollowain:~/cacti/cacti-spine-0.8.7->./configure
checking build system type... i386-unknown-freebsd6.2
checking host system type... i386-unknown-freebsd6.2
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... nawk
checking whether make sets $(MAKE)... yes
checking for gawk... (cached) nawk
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking how to run the C preprocessor... gcc -E
checking for a BSD-compatible install... /usr/bin/install -c
checking whether ln -s works... yes
checking for a sed that does not truncate output... /usr/bin/sed
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking how to recognise dependent libraries... pass_all
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C++ preprocessor... g++ -E
checking for g77... no
checking for xlf... no
checking for f77... f77
checking whether we are using the GNU Fortran 77 compiler... yes
checking whether f77 accepts -g... yes
checking the maximum length of command line arguments... 196608
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking for correct ltmain.sh version... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... yes
checking dynamic linker characteristics... freebsd6.2 ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... freebsd6.2 ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for f77 option to produce PIC... -fPIC
checking if f77 PIC flag -fPIC works... yes
checking if f77 static flag -static works... yes
checking if f77 supports -c -o file.o... yes
checking whether the f77 linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... freebsd6.2 ld.so
checking how to hardcode library paths into programs... immediate
checking whether to enable -Wall... no
checking for gethostbyname in -lnsl... no
checking for socket in -lsocket... no
checking for floor in -lm... yes
checking for pthread_exit in -lpthread... yes
checking for deflate in -lz... yes
checking for kstat_close in -lkstat... no
checking for CRYPTO_realloc in -lcrypto... yes
checking for ANSI C header files... (cached) yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/select.h usability... yes
checking sys/select.h presence... yes
checking for sys/select.h... yes
checking sys/wait.h usability... yes
checking sys/wait.h presence... yes
checking for sys/wait.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking assert.h usability... yes
checking assert.h presence... yes
checking for assert.h... yes
checking ctype.h usability... yes
checking ctype.h presence... yes
checking for ctype.h... yes
checking errno.h usability... yes
checking errno.h presence... yes
checking for errno.h... yes
checking signal.h usability... yes
checking signal.h presence... yes
checking for signal.h... yes
checking math.h usability... yes
checking math.h presence... yes
checking for math.h... yes
checking malloc.h usability... no
checking malloc.h presence... no
checking for malloc.h... no
checking netdb.h usability... yes
checking netdb.h presence... yes
checking for netdb.h... yes
checking for signal.h... (cached) yes
checking stdarg.h usability... yes
checking stdarg.h presence... yes
checking for stdarg.h... yes
checking stdio.h usability... yes
checking stdio.h presence... yes
checking for stdio.h... yes
checking syslog.h usability... yes
checking syslog.h presence... yes
checking for syslog.h... yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking netinet/ip.h usability... no
checking netinet/ip.h presence... yes
configure: WARNING: netinet/ip.h: present but cannot be compiled
configure: WARNING: netinet/ip.h: check for missing prerequisite headers?
configure: WARNING: netinet/ip.h: see the Autoconf documentation
configure: WARNING: netinet/ip.h: section "Present But Cannot Be Compiled"
configure: WARNING: netinet/ip.h: proceeding with the preprocessor's result
configure: WARNING: netinet/ip.h: in the future, the compiler will take precedence
configure: WARNING: ## ------------------------------------ ##
configure: WARNING: ## Report this to http://bugs.cacti.net ##
configure: WARNING: ## ------------------------------------ ##
checking for netinet/ip.h... yes
checking netinet/ip_icmp.h usability... no
checking netinet/ip_icmp.h presence... yes
configure: WARNING: netinet/ip_icmp.h: present but cannot be compiled
configure: WARNING: netinet/ip_icmp.h: check for missing prerequisite headers?
configure: WARNING: netinet/ip_icmp.h: see the Autoconf documentation
configure: WARNING: netinet/ip_icmp.h: section "Present But Cannot Be Compiled"
configure: WARNING: netinet/ip_icmp.h: proceeding with the preprocessor's result
configure: WARNING: netinet/ip_icmp.h: in the future, the compiler will take precedence
configure: WARNING: ## ------------------------------------ ##
configure: WARNING: ## Report this to http://bugs.cacti.net ##
configure: WARNING: ## ------------------------------------ ##
checking for netinet/ip_icmp.h... yes
checking for unsigned long long... yes
checking for long long... yes
checking for an ANSI C-conforming const... yes
checking for size_t... yes
checking whether time.h and sys/time.h may both be included... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking return type of signal handlers... void
checking for malloc... yes
checking for calloc... yes
checking for gettimeofday... yes
checking for strerror... yes
checking for strtoll... yes
checking for mysql_init in -lmysqlclient_r... yes
checking for mysql_thread_init in -lmysqlclient_r... yes
checking if UCD-SNMP needs crypto support... no
checking if Net-SNMP needs crypto support... yes
checking for snmp_timeout in -lnetsnmp... yes
checking whether we are using nifty popen... no
configure: creating ./config.status
config.status: creating Makefile
config.status: creating config/config.h
config.status: config/config.h is unchanged
config.status: executing depfiles commands

Dagonet

[Smux]

Dagonet, you cant compile because this warnings in ./configure ? Freebsd normally show this infos and can be compiled.

ps. sorry for my bad english

[TheWitness]

It's actually a ip_icmp.h structure formatting issue. It's troubling, but I might just have the fix.

TheWitness

[dagonet]

Dagonet, you cant compile because this warnings in ./configure ? Freebsd normally show this infos and can be compiled.

ps. sorry for my bad english

I can't compile because the icmphdr struct used in ping.c is an otherone than in ip_icmp.h.
Please, see one of my previous post to this issue.

Regards,
Dagonet.

[repudi8or]

Hi, Trying to compile Spine 0.8.7 on solaris10

I am stalled at :-

-bash-3.00$ make
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include/net-snmp -I/usr/local/include/net-snmp/.. -I/usr/local/mysql/include/mysql -g -O2 -MT sql.o -MD -MP -MF .deps/sql.Tpo -c -o sql.o sql.c
In file included from common.h:86,
from sql.c:34:
/usr/include/netinet/ip_icmp.h:91: error: syntax error before "n_time"
/usr/include/netinet/ip_icmp.h:96: error: field `idi_ip' has incomplete type
/usr/include/netinet/ip_icmp.h:101: error: syntax error before '}' token
/usr/include/netinet/ip_icmp.h:108: error: syntax error before '}' token
make: *** [sql.o] Error 1

Which i presume is the same error you guys are talking about.

Dagonet said he :-

"removed ip_icmp.h from the common.h file. Tweaked a little in ping.h and bingo!

could i have some details of the "tweaking" please

Kind Regards
Repudi8or

[crimsonstone]

I'm getting the following:

Code: Select all

configure: error: Cannot find MySQL headers.

Not sure where the header files are? I've tried all sorts of directories with the --with-mysql= command..

[FIXED]
By installing libmysqlclient15-dev.



Another problem....

Code: Select all

checking for snmp_timeout in -lnetsnmp... no
Cannot find NET-SNMP libraries(snmp)... checking UCD-SNMP
checking for snmp_timeout in -lsnmp... no
configure: error: Cannot find UCD-SNMP libraries(snmp)

Ubuntu 7.10 - LAMP setup
MySQL v5.0.45

[dagonet]

I'm getting the following:

Code: Select all

configure: error: Cannot find MySQL headers.

Not sure where the header files are? I've tried all sorts of directories with the --with-mysql= command..

[FIXED]
By installing libmysqlclient15-dev.



Another problem....

Code: Select all

checking for snmp_timeout in -lnetsnmp... no
Cannot find NET-SNMP libraries(snmp)... checking UCD-SNMP
checking for snmp_timeout in -lsnmp... no
configure: error: Cannot find UCD-SNMP libraries(snmp)

Ubuntu 7.10 - LAMP setup
MySQL v5.0.45

Hi,
did you install the net-snmp package? It seems to me that this is missing on your system.

Dagonet

[crimsonstone]

Yeah, I've got snmpd installed.

#snmpd -v
NET-SNMP version: 5.3.1
Web: http://www.net-snmp.org/
Email: net-snmp-coders@lists.sourceforge.net


it installs with:
#apt-get install snmpd

[TheWitness]

You need the dev and lib packages.

TheWitness

[super-hornet]

Hi there. I run your suggested SQL script and I can return value but value quite huge (more than 100 lines).

Do u still want to copy and paste it?

By looking at the error message, it appear that something trying to query SQL with string that contain spaces (Get Processor Utilization) but the SQL command do not encapsulate the string with quote.

It should be:
...snmp_query_graph_rrd.snmp_query_graph_id='Get Processor Utilization' and ....

Where do that SQL command come from? Is it from data_queries.php or lib/utility.php ?
What if u modify the above php (data_queries.php) to be something like:

{ somewhere in line 407 }
$data_template_rrds = db_fetch_assoc("select
data_template_rrd.id,
data_template_rrd.data_source_name,
snmp_query_graph_rrd.snmp_field_name,
snmp_query_graph_rrd.snmp_query_graph_id
from data_template_rrd
left join snmp_query_graph_rrd on (snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.id and snmp_query_graph_rrd.snmp_query_graph_id='" . $_GET["id"] . "' and snmp_query_graph_rrd.data_template_id=" . $data_template["id"] . ")
where data_template_rrd.data_template_id=" . $data_template["id"] . "
and data_template_rrd.local_data_id=0
order by data_template_rrd.data_source_name");

{ Notice the single quote ? }

SH

Where on the utilities page? What action where you performing.

Hi. That error message I got from the cacti log. So far, I only do a normal SNMP queries. If u want to know more, please tell me where can I dig out more information or what information do u need in order to debug it?

SH

Run the following query and attach to the bug report: http://bugs.cacti.net/view.php?id=1051

Code: Select all

select data_input_data.data_template_data_id, data_input_fields.type_code, data_input_data.value
from (data_input_fields,data_input_data)
where data_input_fields.id=data_input_data.data_input_field_id
and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type');

[rony]

Well, that's is not the fix.

That is why I wanted to see your data. Something is not correct about the data, because a string should never make it into that query. Adding single quotes will only work with Mysql.

[super-hornet]

OK.

Here is the result from the SQL command you requested:
"data_template_data_id","type_code","value"
1,"output_type",""
1,"index_value",""
1,"index_type",""
2,"output_type",""
2,"index_value",""
2,"index_type",""
3,"output_type",""
3,"index_value",""
3,"index_type",""
7,"output_type",""
7,"index_value",""
7,"index_type",""
8,"output_type",""
8,"index_value",""
8,"index_type",""
9,"output_type",""
9,"index_value",""
9,"index_type",""
10,"output_type",""
10,"index_value",""
10,"index_type",""
35,"output_type",""
35,"index_value",""
35,"index_type",""
36,"output_type",""
36,"index_value",""
36,"index_type",""
37,"output_type",""
37,"index_value",""
37,"index_type",""
38,"output_type",""
38,"index_value",""
38,"index_type",""
39,"output_type",""
39,"index_value",""
39,"index_type",""
40,"output_type",""
40,"index_value",""
40,"index_type",""
41,"output_type",""
41,"index_value",""
41,"index_type",""
55,"output_type",""
55,"index_value",""
55,"index_type",""
56,"output_type",""
56,"index_value",""
56,"index_type",""
57,"output_type",""
57,"index_value",""
57,"index_type",""
75,"index_value","1"
75,"output_type","Get Processor Utilization"
75,"index_type","|hrProcessorFrwID|"
76,"index_type","|hrProcessorFrwID|"
76,"output_type","Get Processor Utilization"
76,"index_value","2"
77,"output_type","Get Processor Utilization"
77,"index_value","3"
77,"index_type","|hrProcessorFrwID|"
78,"index_value","0"
78,"output_type","Get Processor Utilization"
78,"index_type","|hrProcessorFrwID|"
97,"index_value","0"
97,"output_type","Get Processor Utilization"
97,"index_type","|hrProcessorFrwID|"
98,"index_value","1"
98,"output_type","Get Processor Utilization"
98,"index_type","|hrProcessorFrwID|"
99,"index_type","|hrProcessorFrwID|"
99,"output_type","Get Processor Utilization"
99,"index_value","2"
100,"output_type","Get Processor Utilization"
100,"index_value","3"
100,"index_type","|hrProcessorFrwID|"
101,"output_type",""
101,"index_value",""
101,"index_type",""
121,"output_type","19"
121,"index_value","0"
121,"index_type","hrProcessorFrwID"
122,"output_type","19"
122,"index_value","1"
122,"index_type","hrProcessorFrwID"
123,"output_type","19"
123,"index_value","2"
123,"index_type","hrProcessorFrwID"
124,"output_type","19"
124,"index_value","3"
124,"index_type","hrProcessorFrwID"
125,"output_type","19"
125,"index_value","4"
125,"index_type","hrProcessorFrwID"
126,"output_type","19"
126,"index_value","5"
126,"index_type","hrProcessorFrwID"
127,"output_type","19"
127,"index_value","6"
127,"index_type","hrProcessorFrwID"
128,"output_type","19"
128,"index_value","7"
128,"index_type","hrProcessorFrwID"
129,"output_type","13"
129,"index_value","eth0"
129,"index_type","ifDescr"
140,"output_type","Get Processor Utilization"
139,"index_value","2"
139,"output_type","Get Processor Utilization"
139,"index_type","|hrProcessorFrwID|"
138,"index_type","|hrProcessorFrwID|"
138,"output_type","Get Processor Utilization"
138,"index_value","1"
137,"index_type","|hrProcessorFrwID|"
137,"output_type","Get Processor Utilization"
137,"index_value","0"
140,"index_type","|hrProcessorFrwID|"
140,"index_value","3"
160,"output_type","19"
160,"index_value","0"
160,"index_type","hrProcessorFrwID"
161,"output_type","19"
161,"index_value","1"
161,"index_type","hrProcessorFrwID"
162,"output_type","19"
162,"index_value","2"
162,"index_type","hrProcessorFrwID"
163,"output_type","19"
163,"index_value","3"
163,"index_type","hrProcessorFrwID"
164,"output_type","13"
164,"index_value","eth0"
164,"index_type","ifDescr"

[TheWitness]

Export the Data Query that is reflected by this. Provide both the XML from the resource/xxx/ directory and the XML from the Data Query export.

TheWitness

139,"index_value","2"
139,"output_type","Get Processor Utilization"
139,"index_type","|hrProcessorFrwID|"

[super-hornet]

Export the Data Query that is reflected by this. Provide both the XML from the resource/xxx/ directory and the XML from the Data Query export.

TheWitness

139,"index_value","2"
139,"output_type","Get Processor Utilization"
139,"index_type","|hrProcessorFrwID|"

I not sure whether I export the correct one or not. So here it goes:
I export the Data Query for "SNMP - Get Processor Information"

I look a the resource/xxx but not sure which one you need:
resource/script_queries has this:
host_cpu.xml
host_disk.xml
unix_disk.xml

resource/script_server has this:
host_cpu.xml
host_disk.xml

resource/snmp_queries has this:
host_disk.xml
interface.xml
kbridge.xml
net-snmp_disk.xml
netware_cpu.xml
netware_disk.xml

SH

[buckwestern]

It's actually a ip_icmp.h structure formatting issue. It's troubling, but I might just have the fix.

can I get the fix, too, please? I am experiencing the same issue.

thanks.