make install fails in centos 6

[NIK12345]

i executed the command: ./configure --enable-server --enable-agent --with-mysql --net-snmp-devel --with-jabber --with-libcurl

Then when i am executing : make install then i am seeing the below exception. Please help me figuring out the problem. Thanks.


../../../include/zbxdb.h:67:20: error: mysql.h: No such file or directory
../../../include/zbxdb.h:68:21: error: errmsg.h: No such file or directory
../../../include/zbxdb.h:69:27: error: mysqld_error.h: No such file or directory
In file included from ../../../include/db.h:25,
from db.c:22:
../../../include/zbxdb.h:71: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
../../../include/zbxdb.h:174: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
../../../include/zbxdb.h:175: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
../../../include/zbxdb.h:177: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'zbx_db_fetch'
In file included from db.c:22:
../../../include/db.h:546: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
../../../include/db.h:548: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
../../../include/db.h:549: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'DBfetch'
../../../include/db.h:586: error: expected declaration specifiers or '...' before 'MYSQL_ROW'
db.c:34: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
db.c: In function 'zbx_db_connect':
db.c:119: error: 'conn' undeclared (first use in this function)
db.c:119: error: (Each undeclared identifier is reported only once
db.c:119: error: for each function it appears in.)
db.c:121: error: 'CLIENT_MULTI_STATEMENTS' undeclared (first use in this function)
db.c:145: error: 'CR_CONN_HOST_ERROR' undeclared (first use in this function)
db.c:146: error: 'CR_SERVER_GONE_ERROR' undeclared (first use in this function)
db.c:147: error: 'CR_CONNECTION_ERROR' undeclared (first use in this function)
db.c:148: error: 'CR_SERVER_LOST' undeclared (first use in this function)
db.c:149: error: 'ER_SERVER_SHUTDOWN' undeclared (first use in this function)
db.c:150: error: 'ER_ACCESS_DENIED_ERROR' undeclared (first use in this function)
db.c:151: error: 'ER_ILLEGAL_GRANT_FOR_TABLE' undeclared (first use in this function)
db.c:152: error: 'ER_TABLEACCESS_DENIED_ERROR' undeclared (first use in this function)
db.c:153: error: 'ER_UNKNOWN_ERROR' undeclared (first use in this function)
db.c: In function 'zbx_db_close':
db.c:350: error: 'conn' undeclared (first use in this function)
db.c: At top level:
db.c:409: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
db.c: In function 'zbx_db_vexecute':
db.c:656: error: 'conn' undeclared (first use in this function)
db.c:668: error: 'CR_CONN_HOST_ERROR' undeclared (first use in this function)
db.c:669: error: 'CR_SERVER_GONE_ERROR' undeclared (first use in this function)
db.c:670: error: 'CR_CONNECTION_ERROR' undeclared (first use in this function)
db.c:671: error: 'CR_SERVER_LOST' undeclared (first use in this function)
db.c:672: error: 'ER_SERVER_SHUTDOWN' undeclared (first use in this function)
db.c:673: error: 'ER_ACCESS_DENIED_ERROR' undeclared (first use in this function)
db.c:674: error: 'ER_ILLEGAL_GRANT_FOR_TABLE' undeclared (first use in this function)
db.c:675: error: 'ER_TABLEACCESS_DENIED_ERROR' undeclared (first use in this function)
db.c:676: error: 'ER_UNKNOWN_ERROR' undeclared (first use in this function)
db.c: At top level:
db.c:825: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
db.c:1124: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token
db.c:1139: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'zbx_db_fetch'
make[3]: *** [db.o] Error 1
make[3]: Leaving directory `/root/xyy/zabbix-1.8.4/src/libs/zbxdb'
make[2]: *** [install-recursive] Error 1
make[2]: Leaving directory `/root/xyz/zabbix-1.8.4/src/libs'
make[1]: *** [install-recursive] Error 1
make[1]: Leaving directory `/root/xyz/zabbix-1.8.4/src'
make: *** [install-recursive] Error 1

[joshuamcdo]

../../../include/zbxdb.h:67:20: error: mysql.h: No such file or directory
../../../include/zbxdb.h:68:21: error: errmsg.h: No such file or directory
../../../include/zbxdb.h:69:27: error: mysqld_error.h: No such file or directory

I am a n00b myself at Zabbix, however it would appear that you don't have mysql-dev / mysql headers installed on the system. The first failure indicates that problem. I think the other ones are coming because of the first.

Try yum install mysql-devel

Then try your build again.
However, that poses the question.. Why build form source?

J

[NIK12345]

i tried installing mysql-devel but i get the below error message:
Error: Package: mysql-devel-5.1.69-1.el6_4.x86_64 (updates)
Requires: mysql = 5.1.69-1.el6_4
Installed: mysql-5.5.28-1.el6.remi.x86_64 (@remi)
mysql = 5.5.28-1.el6.remi
Available: mysql-5.1.66-2.el6_3.x86_64 (base)
mysql = 5.1.66-2.el6_3
Available: mysql-5.1.67-1.el6_3.x86_64 (updates)
mysql = 5.1.67-1.el6_3
Available: mysql-5.1.69-1.el6_4.x86_64 (updates)
mysql = 5.1.69-1.el6_4
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

[joshuamcdo]

Re: Msql error

It appears that your using a newer version of Mysql than is availible through your repos. Where did you get that version of mysql ? I think a layout of what you have done so far is needed at this point. Do you have the remi repos enabled for your install? If not, enabling them will probably make this go away too.

J

i tried installing mysql-devel but i get the below error message:
Error: Package: mysql-devel-5.1.69-1.el6_4.x86_64 (updates)
Requires: mysql = 5.1.69-1.el6_4
Installed: mysql-5.5.28-1.el6.remi.x86_64 (@remi)
mysql = 5.5.28-1.el6.remi
Available: mysql-5.1.66-2.el6_3.x86_64 (base)
mysql = 5.1.66-2.el6_3
Available: mysql-5.1.67-1.el6_3.x86_64 (updates)
mysql = 5.1.67-1.el6_3
Available: mysql-5.1.69-1.el6_4.x86_64 (updates)
mysql = 5.1.69-1.el6_4
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

[NIK12345]

i am using mysql 5.5 version. Please help in resolving the issue.

[joshuamcdo]

Re:

i am using mysql 5.5 version. Please help in resolving the issue.

I understand that your using 5.5.

**Where did you get it?

It appears that your using the REMI packaged version of Mysql.

**Are the REMI repos still enabled on your system?

Check in /etc/yum.repos.d/

Can you post a reply that explains what insutrctions you followed to get where you are so far?

Thanks,
J

[joshuamcdo]

Re:

i am using mysql 5.5 version. Please help in resolving the issue.

I was only able to find that RPM in one place..

I know nothing of that repo, or RPM, so use it at your own risk...

yum install http://rpms.southbridge.ru/rhel6/sta...emi.x86_64.rpm

Now on the flipside... You could do a yum upgrade and upgrade everything.. Not sure how you would fair on the mysql thing though because the version you have is newer than anything that yum is currently offering..

You should still answer the questions that I posed above.

J

P.S. Admins, can I get my allowable link count increased please? It's posing a serious problem for me.

[tchjts1]

P.S. Admins, can I get my allowable link count increased please? It's posing a serious problem for me.

Unfortunately, not. I am also hobbled by that rule. If you knew the amount of spam that tries to get posted to our forums, you would understand why that rule is in place though.

[NIK12345]

when i did fire the command ls -l /etc/yum.repos.d/ it list the below:

-rw-r--r-- 1 root root 1926 Jun 26 2012 CentOS-Base.repo
-rw-r--r-- 1 root root 637 Jun 26 2012 CentOS-Debuginfo.repo
-rw-r--r-- 1 root root 626 Jun 26 2012 CentOS-Media.repo
-rw-r--r-- 1 root root 2593 Jun 26 2012 CentOS-Vault.repo
-rw-r--r-- 1 root root 475 Aug 19 2012 ZabbixZone.repo
-rw-r--r-- 1 root root 1056 Nov 5 2012 epel-testing.repo
-rw-r--r-- 1 root root 957 Aug 21 2012 epel.repo
-rw-r--r-- 1 root root 739 Nov 13 2010 mirrors-rpmforge
-rw-r--r-- 1 root root 717 Nov 13 2010 mirrors-rpmforge-extras
-rw-r--r-- 1 root root 728 Nov 13 2010 mirrors-rpmforge-testing
-rw-r--r-- 1 root root 633 Nov 13 2010 remi.repo
-rw-r--r-- 1 root root 1113 Aug 21 2012 rpmforge.repo
-rw-r--r-- 1 root root 401 Jan 25 23:10 zabbix.repo


And below are the steps that i followed:

1. tar -zxvf zabbix-2.0.0.tar.gz
2. ./configure --enable-server --enable-agent --with-mysql --enable-ipv6 --with-net-snmp --with-libcurl
3. mysql -u<username> -p<password>
4. create database zabbix character set utf8 collate utf8_bin;
5. mysql -u<username> -p<password> zabbix < database/mysql/schema.sql
6. mysql -u<username> -p<password> zabbix < database/mysql/images.sql
7. mysql -u<username> -p<password> zabbix < database/mysql/data.sql
8. make install

when i am firing make install i am geting the above error.
Below are some mysql setup details:
mysql> show variables like '%version%';
+-------------------------+--------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------+
| innodb_version | 1.1.8 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.28-log |
| version_comment | MySQL Community Server (GPL) by Remi |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+--------------------------------------+
7 rows in set (0.00 sec)

Thanks

[joshuamcdo]

when i did fire the command ls -l /etc/yum.repos.d/ it list the below:

-rw-r--r-- 1 root root 1926 Jun 26 2012 CentOS-Base.repo
...
-rw-r--r-- 1 root root 633 Nov 13 2010 remi.repo
...

I still do not understand why your building from source.. But the next thing you need to do is check to see if the remi repo is actually enabled.

cat /etc/yum.repos.d/remi.repo

You should see either enabled=1 or enabled=0, if it's 0 you need to edit the file vi /etc/yum.repos.d/remi.repo and change it to be enabled. Then try executing a yum install mysql-devel again.

J

[joshuamcdo]

Is this dead now ?

Did you give up?

when i did fire the command ls -l /etc/yum.repos.d/ it list the below:
Thanks