Problems to get Spine 0.8.7b running on HP-UX

FAQ

Memberlist

Profile

Problems to get Spine 0.8.7b running on HP-UX

Cacti Forum Index -> Help: Unstable Development Versions

Author

Message

BBRicardo

Joined: 23 Jun 2008
Posts: 3
Location: Bremen, GER

Posted: Mon Jun 23, 2008 7:08 am Post subject: Problems to get Spine 0.8.7b running on HP-UX

Hello,

I have an issue with spine in combination with mysql. When spine is starting and tries to connect to mysql a second time, it rans in a segmention fault.

Configure And Compiling Output:

Code:

checking build system type... hppa2.0w-hp-hpux11.11
checking host system type... hppa2.0w-hp-hpux11.11
checking for a BSD-compatible install... config/install-sh -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... config/install-sh -c -d
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gawk... (cached) gawk
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... config/install-sh -c
checking whether ln -s works... yes
checking for a sed that does not truncate output... /usr/local/bin/sed
checking for grep that handles long lines and -e... /usr/local/bin/grep
checking for egrep... /usr/local/bin/grep -E
checking for fgrep... /usr/local/bin/grep -F
checking for ld used by gcc... /usr/ccs/bin/ld
checking if the linker (/usr/ccs/bin/ld) is GNU ld... no
checking for BSD- or MS-compatible name lister (nm)... /usr/local/bin/nm -B
checking the name lister (/usr/local/bin/nm -B) interface... BSD nm
checking the maximum length of command line arguments... 1536000
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... no
checking for /usr/ccs/bin/ld option to reload object files... -r
checking how to recognize dependent libraries... file_magic (s[0-9][0-9][0-9]|PA-RISC[0-9].[0-9]) shared library
checking for ar... ar
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/local/bin/nm -B output from gcc object... ok
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... no
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC -DPIC
checking if gcc PIC flag -fPIC -DPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.o... (cached) yes
checking whether the gcc linker (/usr/ccs/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... yes
checking dynamic linker characteristics... hpux11.11 dld.sl
checking how to hardcode library paths into programs... relink
checking whether stripping libraries is possible... no
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking whether to enable -Wall... no
checking for gethostbyname in -lnsl... yes
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... no
checking sys/select.h presence... no
checking for sys/select.h... no
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... yes
checking malloc.h presence... yes
checking for malloc.h... yes
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_systm.h usability... yes
checking netinet/in_systm.h presence... yes
checking for netinet/in_systm.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... no
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: executing depfiles commands
config.status: executing libtool commands
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT sql.o -MD -MP -MF .deps/sql.Tpo -c -o sql.o sql.c
mv -f .deps/sql.Tpo .deps/sql.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT spine.o -MD -MP -MF .deps/spine.Tpo -c -o spine.o spine.c
mv -f .deps/spine.Tpo .deps/spine.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT util.o -MD -MP -MF .deps/util.Tpo -c -o util.o util.c
mv -f .deps/util.Tpo .deps/util.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT snmp.o -MD -MP -MF .deps/snmp.Tpo -c -o snmp.o snmp.c
snmp.c: In function 'snmp_host_init':
snmp.c:194: warning: pointer targets in assignment differ in signedness
mv -f .deps/snmp.Tpo .deps/snmp.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT locks.o -MD -MP -MF .deps/locks.Tpo -c -o locks.o locks.c
mv -f .deps/locks.Tpo .deps/locks.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT poller.o -MD -MP -MF .deps/poller.Tpo -c -o poller.o poller.c
mv -f .deps/poller.Tpo .deps/poller.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT nft_popen.o -MD -MP -MF .deps/nft_popen.Tpo -c -o nft_popen.o nft_popen.c
mv -f .deps/nft_popen.Tpo .deps/nft_popen.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT php.o -MD -MP -MF .deps/php.Tpo -c -o php.o php.c
mv -f .deps/php.Tpo .deps/php.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT ping.o -MD -MP -MF .deps/ping.Tpo -c -o ping.o ping.c
ping.c: In function 'ping_icmp':
ping.c:341: warning: passing argument 6 of 'recvfrom' from incompatible pointer type
mv -f .deps/ping.Tpo .deps/ping.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT keywords.o -MD -MP -MF .deps/keywords.Tpo -c -o keywords.o keywords.c
mv -f .deps/keywords.Tpo .deps/keywords.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT error.o -MD -MP -MF .deps/error.Tpo -c -o error.o error.c
mv -f .deps/error.Tpo .deps/error.Po
/bin/sh ./libtool --tag=CC --mode=link gcc -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -L/opt/iexpress/net-snmp//lib -L/usr/local/mysql/lib/mysql -L/usr/local/lib -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o -lnetsnmp -lmysqlclient_r -lmysqlclient_r -lcrypto -lz -lpthread -lm -lnsl
libtool: link: gcc -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o -L/opt/iexpress/net-snmp//lib -L/usr/local/mysql/lib/mysql -L/usr/local/lib -lnetsnmp -lmysqlclient_r -lcrypt -lcrypto -lz -lpthread -lm -lnsl -Wl,+b -Wl,/usr/local/mysql/lib/mysql

Output of Spine ./spine -C /usr/local/etc/spine.conf -V=5 8 8

Code:

06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /usr/local/cacti/script_server.php
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /usr/local/cacti/log/cacti.log
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_destination''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 3
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 2
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 40
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 0
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The threads variable is 5
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 50
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 8 AND 8 LIMIT 1'
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: StartHost='8', EndHost='8', TotalPHPScripts='0'
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
06/23/2008 12:00:24 PM - SPINE: Poller[0] Version 0.8.7b starting
06/23/2008 12:00:24 PM - SPINE: Poller[0] DEBUG: Start Mysql Connection
06/23/2008 12:00:24 PM - SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine parent)

changed spine.c from

Code:

SPINE_LOG_DEBUG(("DEBUG: Start Mysql Connection"));

/* connect to database */
db_connect(set.dbdb, &mysql);

SPINE_LOG_DEBUG(("DEBUG: MySQL Connection established. Checking for Thread Safe."));

Code:

SPINE_LOG_DEBUG(("DEBUG: Start Mysql Connection"));

/* connect to database */
/* db_connect(set.dbdb, &mysql); */

SPINE_LOG_DEBUG(("DEBUG: MySQL Connection established. Checking for Thread Safe."));

results in

Code:

06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /usr/local/cacti/script_server.php
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /usr/local/cacti/log/cacti.log
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_destination''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 3
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 2
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 40
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 0
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The threads variable is 5
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 50
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 8 AND 8 LIMIT 1'
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: StartHost='8', EndHost='8', TotalPHPScripts='0'
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
06/23/2008 12:04:29 PM - SPINE: Poller[0] Version 0.8.7b starting
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: Start Mysql Connection
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: MySQL Connection established. Checking for Thread Safe.
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
06/23/2008 12:04:29 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.2.1.2
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.2.1.2
06/23/2008 12:04:29 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: Querybuffer: SELECT id FROM host WHERE disabled='' AND id BETWEEN 8 AND 8 ORDER BY id
06/23/2008 12:04:29 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 8 AND 8 ORDER BY id'
06/23/2008 12:04:29 PM - SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine parent)

I have no idea why the second connection fails.

I must also say, i'm not very firm in programming c. I manly write php.

Any Ideas?

Code:

# mysql -V
mysql Ver 14.12 Distrib 5.0.18, for hp-hpux11.11 (hppa2.0w) using EditLine wrapper

BBRicardo

Joined: 23 Jun 2008
Posts: 3
Location: Bremen, GER

Posted: Tue Jul 15, 2008 8:48 am Post subject:

No one any idea? mmh. i would use spine, but i get not fixed this problem. Please Help Me.

TheWitness
Developer

Joined: 14 May 2002
Posts: 9255
Location: MI, USA

Posted: Wed Jul 23, 2008 8:30 am Post subject:

Don't be playing with the MySQL connections. Also, please use the SVN 0.8.7 branch for testing. Let me know if it compiles error free and then run the command in debug mode and show the output again. Regards, TheWitness

BBRicardo

Joined: 23 Jun 2008
Posts: 3
Location: Bremen, GER

Posted: Fri Jul 25, 2008 10:38 am Post subject:

Hi, thanks for your reply.

i've cheked out the latest SVN Version (Build: 4618). But the problem is always present.

Starting Spine in debug mode:

Code:

./spine -C /usr/local/etc/spine.conf -V=5 8 8
SPINE: Using spine config file [/usr/local/etc/spine.conf]
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /usr/local/cacti/script_server.php
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /usr/local/cacti/log/cacti.log
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_destination''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 3
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 2
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 40
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 0
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The threads variable is 5
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 50
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 8 AND 8 LIMIT 1'
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: StartHost='8', EndHost='8', TotalPHPScripts='0'
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
07/25/2008 03:17:39 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
07/25/2008 03:17:39 PM - SPINE: Poller[0] Version 0.8.7c starting
07/25/2008 03:17:39 PM - SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine parent)

i must also make changes in common.h to get it compiled

Code:

*** Spine_svn_0.8.7_Build_4618/common.h Wed Jul 23 19:05:16 2008
--- Spine_svn_0.8.7/common.h Fri Jul 25 15:11:24 2008
***************
*** 80,86 ****
#include <sys/wait.h>
#include <sys/stat.h>
#include <sys/socket.h>
! #include <sys/select.h>
#include <assert.h>
#include <ctype.h>
#include <errno.h>
--- 80,90 ----
#include <sys/wait.h>
#include <sys/stat.h>
#include <sys/socket.h>
!
! #ifdef HAVE_SYS_SELECT_H
! # include <sys/select.h>
! #endif
!
#include <assert.h>
#include <ctype.h>
#include <errno.h>

and in ping.c for test purpose

Code:

*** Spine_svn_0.8.7_Build_4618/ping.c Wed Jul 23 19:05:16 2008
--- Spine_svn_0.8.7/ping.c Fri Jul 25 15:15:49 2008
***************
*** 57,63 ****
if (host->ping_method == PING_ICMP) {
/* set and then test for asroot */
#ifndef __CYGWIN__
! seteuid(0);

if (geteuid() != 0) {
host->ping_method = PING_UDP;
--- 57,63 ----
if (host->ping_method == PING_ICMP) {
/* set and then test for asroot */
#ifndef __CYGWIN__
! /* seteuid(0); */

if (geteuid() != 0) {
host->ping_method = PING_UDP;
***************
*** 72,78 ****

/* give up root privileges */
#ifndef __CYGWIN__
! seteuid(getuid());
#endif
}else if (host->ping_method == PING_UDP) {
ping_result = ping_udp(host, ping);
--- 72,78 ----

/* give up root privileges */
#ifndef __CYGWIN__
! /* seteuid(getuid()); */
#endif
}else if (host->ping_method == PING_UDP) {
ping_result = ping_udp(host, ping);

whitout changing ping.c it results in.

Code:

gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT sql.o -MD -MP -MF .deps/sql.Tpo -c -o sql.o sql.c
mv -f .deps/sql.Tpo .deps/sql.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT spine.o -MD -MP -MF .deps/spine.Tpo -c -o spine.o spine.c
mv -f .deps/spine.Tpo .deps/spine.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT util.o -MD -MP -MF .deps/util.Tpo -c -o util.o util.c
mv -f .deps/util.Tpo .deps/util.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT snmp.o -MD -MP -MF .deps/snmp.Tpo -c -o snmp.o snmp.c
snmp.c: In function 'snmp_host_init':
snmp.c:199: warning: pointer targets in assignment differ in signedness
mv -f .deps/snmp.Tpo .deps/snmp.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT locks.o -MD -MP -MF .deps/locks.Tpo -c -o locks.o locks.c
mv -f .deps/locks.Tpo .deps/locks.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT poller.o -MD -MP -MF .deps/poller.Tpo -c -o poller.o poller.c
mv -f .deps/poller.Tpo .deps/poller.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT nft_popen.o -MD -MP -MF .deps/nft_popen.Tpo -c -o nft_popen.o nft_popen.c
mv -f .deps/nft_popen.Tpo .deps/nft_popen.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT php.o -MD -MP -MF .deps/php.Tpo -c -o php.o php.c
mv -f .deps/php.Tpo .deps/php.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT ping.o -MD -MP -MF .deps/ping.Tpo -c -o ping.o ping.c
ping.c: In function 'ping_icmp':
ping.c:338: warning: passing argument 6 of 'recvfrom' from incompatible pointer type
mv -f .deps/ping.Tpo .deps/ping.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT keywords.o -MD -MP -MF .deps/keywords.Tpo -c -o keywords.o keywords.c
mv -f .deps/keywords.Tpo .deps/keywords.Po
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/local/include -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -MT error.o -MD -MP -MF .deps/error.Tpo -c -o error.o error.c
mv -f .deps/error.Tpo .deps/error.Po
/bin/sh ./libtool --tag=CC --mode=link gcc -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -L/opt/iexpress/net-snmp//lib -L/usr/local/mysql/lib/mysql -L/usr/local/lib -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o -lnetsnmp -lmysqlclient_r -lmysqlclient_r -lcrypto -lz -lpthread -lm -lnsl
libtool: link: gcc -I/opt/iexpress/net-snmp//include/net-snmp -I/opt/iexpress/net-snmp//include/net-snmp/.. -I/opt/mysql/include/mysql -O2 -march=2.0 -msio -fomit-frame-pointer -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o -L/opt/iexpress/net-snmp//lib -L/usr/local/mysql/lib/mysql -L/usr/local/lib -lnetsnmp -lmysqlclient_r -lcrypt -lcrypto -lz -lpthread -lm -lnsl -Wl,+b -Wl,/usr/local/mysql/lib/mysql
/usr/ccs/bin/ld: Unsatisfied symbols:
seteuid (first referenced in ping.o) (code)
collect2: ld returned 1 exit status
gmake: *** [spine] Error 1

hope you can help me with this issue.

Thanks

TheWitness
Developer

Joined: 14 May 2002
Posts: 9255
Location: MI, USA

Posted: Fri Jul 25, 2008 11:32 am Post subject:

Can you do a GoToMeeting? TheWitness

Display posts from previous:

	Cacti Forum Index -> Help: Unstable Development Versions	All times are GMT - 5 Hours
Page 1 of 1