Ad Widget

**richlv** · 12-12-2010, 11:18

looks like plain compilation fails on /usr/include/mysql/dbug.h

which os/distribution ? can you try reinstalling mysql development headers ?

**Davidus** · 12-12-2010, 21:25

I`m using AIX 5.3 unfortunately
I can reinstall everything if necessary, cause I just wanna make it work…
Let me explain what I did; actually, I think that this was inappropriate move
I got MySQL from MySQL official web-site, when I was doing ./configure part it asked me mysql client, devel and stuff, because I wasn’t able to get all this stuff anywhere I got RPMs and it looked like everything is going to work, now I think that this wasn’t good idea

now I faced this issue and think like I have to start everything again…
I`m going to try reinstall SQL stuff and will let you know what is going to happened
Thank you for respond

**Davidus** · 13-12-2010, 08:55

I tried, however, it didn`t worked out... I even tried different rpm-s for client and devel...and keep getting same error on make install

**Davidus** · 13-12-2010, 12:53

I edited dbug.h file
from:
extern void _db_doprnt_ _VARARGS((const char *format,...));
to
extern void _db_doprnt_VARARGS(const char *format);

and os some point problem is solved
however, now I have following error:
Making install in zbxdb
gcc -DHAVE_CONFIG_H -I. -I../../../include -g -O2 -I'/usr/include/mysql' -I/usr/src/iksemel-1.3/include -I/opt/freeware/include -I/usr/local/include -I. -I/opt/freeware/include -MT db.o -MD -MP -MF .deps/db.Tpo -c -o db.o db.c
db.c: In function 'zbx_db_connect':
db.c:139: error: 'CLIENT_MULTI_STATEMENTS' undeclared (first use in this function)
db.c:139: error: (Each undeclared identifier is reported only once
db.c:139: error: for each function it appears in.)
make: 1254-004 The error code from the last command is 1.

Stop.
make: 1254-004 The error code from the last command is 1.

Stop.
make: 1254-004 The error code from the last command is 1.

Stop.
make: 1254-004 The error code from the last command is 1.

Stop.

**dave_t** · 13-12-2010, 12:55

I have a similar - possibly related problem to compile error on AIX

Fist of all, I have to say that Zabbix really is an excellent product, and I've been running it: compiled with with jabber/curl/netsnmp etc - basically everything on Fedora on PPC since version 1.4.2.
However, I really need to move off the fedora installation onto AIX.

I had similar "make" errors as reported by "Davidus", with both the GNU Make 3.80 and the AIX version of make on AIX6.1

Therefore I gave up and reverted back to a vanilla AIX5300-09 installation.

However, after installing mysql from mysql.com (version mysql-5.1.53-aix5.3-powerpc-64bit.tar.gz)

the output of configure:
# ./configure --enable-server --with-mysql
...
...
checking for mysql_config... /usr/local/mysql/bin/mysql_config
checking for main in -lmysqlclient ... no
configure: error: Not found mysqlclient library

# echo $LDFLAGS
-L/zabbix_db_fs/mysql-5.1.53-aix5.3-powerpc-64bit/lib -lmysqlclient

# /usr/local/mysql/bin/mysql_config
Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags [-I/usr/local/mysql/include -g -q64 -ma -qstrict -qoptimize=2 -qmaxmem=8192 -DUNIV_AIX -DUNIV_AIX]
--include [-I/usr/local/mysql/include]
--libs [-Wl,-brtl -L/usr/local/mysql/lib -lmysqlclient -lz -lnsl_r -lm]
--libs_r [-Wl,-brtl -L/usr/local/mysql/lib -lmysqlclient_r -lz -lnsl_r -lm]
--plugindir [/usr/local/mysql/lib/plugin]
--socket [/tmp/mysql.sock]
--port [0]
--version [5.1.53]
--libmysqld-libs [-Wl,-brtl -L/usr/local/mysql/lib -lmysqld -ldl -lz -lnsl_r -lm -lrt]

# ls -l /usr/local/mysql/include /usr/local/mysql/lib
/usr/local/mysql/include:
total 888
-rw-r--r-- 1 root mysql 4058 Nov 5 19:22 decimal.h
-rw-r--r-- 1 root mysql 3854 Nov 5 19:22 errmsg.h
-rw-r--r-- 1 root mysql 6954 Nov 5 19:22 keycache.h
-rw-r--r-- 1 root mysql 22690 Nov 5 19:22 m_ctype.h
-rw-r--r-- 1 root mysql 7451 Nov 5 19:22 m_string.h
-rw-r--r-- 1 root mysql 1804 Nov 5 19:22 my_alloc.h
-rw-r--r-- 1 root mysql 1941 Nov 5 19:22 my_attribute.h
-rw-r--r-- 1 root mysql 3991 Nov 5 19:22 my_compiler.h
-rw-r--r-- 1 root mysql 37039 Nov 5 19:22 my_config.h
-rw-r--r-- 1 root mysql 6947 Nov 5 19:22 my_dbug.h
-rw-r--r-- 1 root mysql 3460 Nov 5 19:22 my_dir.h
-rw-r--r-- 1 root mysql 3669 Nov 5 19:22 my_getopt.h
-rw-r--r-- 1 root mysql 52661 Nov 5 19:22 my_global.h
-rw-r--r-- 1 root mysql 1488 Nov 5 19:22 my_list.h
-rw-r--r-- 1 root mysql 3656 Nov 5 19:22 my_net.h
-rw-r--r-- 1 root mysql 1763 Nov 5 19:22 my_no_pthread.h
-rw-r--r-- 1 root mysql 27068 Nov 5 19:22 my_pthread.h
-rw-r--r-- 1 root mysql 41391 Nov 5 19:22 my_sys.h
-rw-r--r-- 1 root mysql 2677 Nov 5 19:22 my_xml.h
-rw-r--r-- 1 root mysql 33724 Nov 5 19:22 mysql.h
-rw-r--r-- 1 root mysql 20494 Nov 5 19:22 mysql_com.h
-rw-r--r-- 1 root mysql 1130 Nov 5 19:22 mysql_embed.h
-rw-r--r-- 1 root mysql 2097 Nov 5 19:22 mysql_time.h
-rw-r--r-- 1 root mysql 820 Nov 5 19:22 mysql_version.h
-rw-r--r-- 1 root mysql 23447 Nov 5 19:22 mysqld_ername.h
-rw-r--r-- 1 root mysql 23502 Nov 5 19:22 mysqld_error.h
-rw-r--r-- 1 root mysql 29654 Nov 5 19:22 plugin.h
-rw-r--r-- 1 root mysql 1957 Nov 5 19:22 sql_common.h
-rw-r--r-- 1 root mysql 12332 Nov 5 19:22 sql_state.h
-rw-r--r-- 1 root mysql 1006 Nov 5 19:22 sslopt-case.h
-rw-r--r-- 1 root mysql 2061 Nov 5 19:22 sslopt-longopts.h
-rw-r--r-- 1 root mysql 1107 Nov 5 19:22 sslopt-vars.h
-rw-r--r-- 1 root mysql 1501 Nov 5 19:22 typelib.h

/usr/local/mysql/lib:
total 147328
-rw-r--r-- 1 root mysql 6001 Nov 5 19:22 libdbug.a
-rw-r--r-- 1 root mysql 772598 Nov 5 19:22 libheap.a
-rw-r--r-- 1 root mysql 2783065 Nov 5 19:22 libmyisam.a
-rw-r--r-- 1 root mysql 973469 Nov 5 19:22 libmyisammrg.a
-rw-r--r-- 1 root mysql 3485051 Nov 5 19:22 libmysqlclient.a
-rwxr-xr-x 1 root mysql 994 Nov 5 19:22 libmysqlclient.la
lrwxrwxrwx 1 503 staff 24 Dec 11 22:24 libmysqlclient.so -> libmysqlclient.so.16.0.0
lrwxrwxrwx 1 503 staff 24 Dec 11 22:24 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rwxr-xr-x 1 root mysql 3157127 Nov 5 19:22 libmysqlclient.so.16.0.0
-rw-r--r-- 1 root mysql 3546337 Nov 5 19:22 libmysqlclient_r.a
-rwxr-xr-x 1 root mysql 1008 Nov 5 19:22 libmysqlclient_r.la
lrwxrwxrwx 1 503 staff 26 Dec 11 22:24 libmysqlclient_r.so -> libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 503 staff 26 Dec 11 22:24 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rwxr-xr-x 1 root mysql 3223680 Nov 5 19:22 libmysqlclient_r.so.16.0.0
-rw-r--r-- 1 root mysql 53646387 Nov 5 19:23 libmysqld.a
-rw-r--r-- 1 root mysql 2119775 Nov 5 19:22 libmystrings.a
-rw-r--r-- 1 root mysql 1355704 Nov 5 19:22 libmysys.a
-rw-r--r-- 1 root mysql 40900 Nov 5 19:23 libvio.a
-rw-r--r-- 1 root mysql 279330 Nov 5 19:22 libz.a
-rwxr-xr-x 1 root mysql 876 Nov 5 19:22 libz.la
drwxr-xr-x 2 root mysql 4096 Dec 11 22:38 plugin

Anyone got any ideas, as this has taken a couple of days (well a few hours) of my life

**Davidus** · 13-12-2010, 13:08

dave_t

checking for main in -lmysqlclient ... no
configure: error: Not found mysqlclient library

I solved this problem installing mysql-client and mysql-devel rpm-s

**Davidus** · 13-12-2010, 14:25

By the way, you cant use 64bit MYSQL with Zabbix as I know so try 32...

**dave_t** · 13-12-2010, 15:40

Thanks davidus, I was going round in circles for a while.

I also just spotted your comment on the 64bit version, so have just re-installed 32bit ver.

Unfortunately, the retrograde to AIX 5.3 is now giving me the same problem as you originally reported (and the same one as I had on my AIX 6.1 partition):

i.e.
root@zabbix-master:/home/zabbix_server/zabbix-1.8.3 > make
Making all in src
Making all in libs
Making all in zbxcrypto
gcc -DHAVE_CONFIG_H -I. -I../../../include -g -O2 -I'/usr/include/mysql' -MT md5.o -MD -MP -MF .deps/md5.Tpo -c -o md5.o md5.c
In file included from /usr/include/xcoff.h:134,
from /usr/include/a.out.h:42,
from /usr/include/sys/user.h:54,
from ../../../include/sysinc.h:301,
from ../../../include/common.h:23,
from md5.c:54:
/usr/include/mysql/dbug.h:38: error: expected '=', ',', ';', 'asm' or '__attribute__' before '_VARARGS'

I don't necessarily believe the proglem is just with the brackets.

I'll keep chipping away and come back to you if I manage to resolve it.

....as they say: "so near, but yet so far"

Dave

**Davidus** · 13-12-2010, 15:47

Dave
talking about your issue

I edited dbug.h file
from:
extern void _db_doprnt_ _VARARGS((const char *format,...));
to
extern void _db_doprnt_VARARGS(const char *format);
this worked out, and I was happy for limited time

and this change took me to the next issue

Making install in zbxdb
gcc -DHAVE_CONFIG_H -I. -I../../../include -g -O2 -I'/usr/include/mysql' -I/usr/src/iksemel-1.3/include -I/opt/freeware/include -I/usr/local/include -I. -I/opt/freeware/include -MT db.o -MD -MP -MF .deps/db.Tpo -c -o db.o db.c
db.c: In function 'zbx_db_connect':
db.c:139: error: 'CLIENT_MULTI_STATEMENTS' undeclared (first use in this function)
db.c:139: error: (Each undeclared identifier is reported only once
db.c:139: error: for each function it appears in.)
make: 1254-004 The error code from the last command is 1.

now I`m trying to solve this problem, which seems is in db.c file`s code or somethin` like that...
If I`ll found solution will inform you asap

**dave_t** · 13-12-2010, 17:16

don't know if this is of any relevance, but I've been back through my config.log and noticed the following:

configure:10094: checking for mysql_config
configure:10112: found /usr/bin/mysql_config
configure:10125: result: /usr/bin/mysql_config
configure:10240: checking for main in -lmysqlclient
configure:10269: gcc -o conftest -g -O2 -I'/usr/include/mysql' -L/usr/local/mysql/lib -lmysqlclient -L'/usr/lib/mysql' conftest.c -lmysqlclient -lperfstat
>&5
configure:10275: $? = 0
configure:10293: result: yes
configure:10496: checking for function PQserverVersion()
configure:10524: gcc -o conftest -g -O2 -L/usr/local/mysql/lib -lmysqlclient conftest.c -lperfstat >&5
conftest.c:97:22: error: libpq-fe.h: No such file or directory
conftest.c: In function 'main':
conftest.c:103: error: 'PGconn' undeclared (first use in this function)
conftest.c:103: error: (Each undeclared identifier is reported only once
conftest.c:103: error: for each function it appears in.)
conftest.c:103: error: 'conn' undeclared (first use in this function)
conftest.c:103: error: 'NULL' undeclared (first use in this function)
configure:10530: $? = 1
configure: failed program was:
| /* confdefs.h. */
...
...

**Davidus** · 13-12-2010, 18:50

what gave you such error? ./configure?
I never this kind of error before... hmmm

**dave_t** · 13-12-2010, 18:54

yes, just the following:

root@zabbix-master:/home/zabbix_server/zabbix-1.8.3 > ./configure --enable-server --with-mysql

frustrating, but I'm going to have to leave this for today. maybe a pair of fresh eyes in the morning will help (or maybe not)

**Davidus** · 13-12-2010, 18:55

which gcc are you using by the way
gcc -v
mine is 4.2.4 I believe

and which mysql-client, mysql-devel are they rpm-s?

**Davidus** · 13-12-2010, 18:57

I`m out of office as well, however, cant stop thinking about this issue...

in my personal opinion its all about source code! too bad nobody is helping us... real word

Ad Widget

make install issues

make install issues

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment