cactid mysql error on 64bit

[phpgold]

Hi all,

I'm trying to configure cactid on fedora core 5 64 bit but when I go to execute: ./configure

it gives me the following error:

checking for mysql_init in -lmysqlclient... no
configure: error: MySQL libraries not found.


even though I have the following rpms installed:

[root@box1 cacti-cactid-0.8.6g]# rpm -qa | grep mysql
mysql-server-5.0.22-1.FC5.1
mysqlclient14-4.1.14-4.2
mysql-5.0.22-1.FC5.1
mysqlclient14-devel-4.1.14-4.2
mysqlclient10-devel-3.23.58-9.2
mysql-devel-5.0.22-1.FC5.1
php-mysql-5.1.4-1
mysqlclient10-3.23.58-9.2


Does anyone have any idea why this isn't working? Is this not compatible with 64 bit?

Thanks...

Neil

[TheWitness]

What version?

[phpgold]

The version of cactid that I'm using is the latest on the site (0.8.6g).

Later...

[dgamble]

I have the same issue. Looks like it affects all versions of cactid.

[TheWitness]

Have either of you build BRANCH_0_8_6 of Cacti SVN? I specifically addressed this issue. I have to get to Ian to get the release done.

TheWitness

[dgamble]

More info here...

It looks like the configure script was simply never designed to look for 64-bit libraries. They're under /usr/lib64/{libdir} on RHEL, which I think is the typical location for Linux.

I added the following block under the "for i in $MYSQL_DIR...." loop:

Code: Select all

        str="$i/lib64/mysql/libmysqlclient.*"
        for j in `echo $str`; do
                if test -r $j; then
                MYSQL_LIB_DIR=$i/lib64/mysql
                break 2
        fi
        done

... which lets it find the MySQL libraries. Of course, now it can't find libcrypto, and I assume it will have a similar issue with net-snmp. I'm guessing it will at least compile once similar additions are done for those libraries.

(This was for cactid-0.8.6e; I am looking to migrate an existing installation to a 64-bit machine, and then upgrade cacti/cactid afterwards)

[dgamble]

Have either of you build BRANCH_0_8_6 of Cacti SVN? I specifically addressed this issue. I have to get to Ian to get the release done.

TheWitness

Sorry, I was typing my previous message while you were typing this one.

I am not sure if I can just take the database install from my 32-bit cactid-0.8.6e/cacti-0.8.6f installation and drop it into a 64-bit version running the current versions of these. I am guessing this would skip crucial upgrade scripts. I was planning to first migrate to the same version on 64-bit, and then upgrade afterwards.

Perhaps I could just check out the SVN configure script and use it to compile cactid-0.8.6e, and then run SVN cactid once the migration is done? That might work better.

[TheWitness]

At least test it.

TheWitness

[dgamble]

At least test it.

TheWitness

I'm sorry, I'll try to be more clear on my issue.

I need more information such that I COULD test it. I'd LIKE to test it, because I have to migrate the 32-bit setup to a 64-bit machine ASAP.

I have cacti data from a slightly older 32-bit installation. If I were to get a copy of the database, and then import it onto a 64-bit machine running SVN cactid and recent cacti, should this work, yes or no? Will I be skipping some critical upgrade scripts?

So if this won't work, how about checking the SVN configure script out, and configuring the older cactid against it? Should this work instead? If not that, any other suggestions?

I can't upgrade the current machine. It's working, people are using it, and I can't risk another problem with upgrading it.

[dgamble]

Here are the results from simply trying to compile it (obtained from SVN around the time of my last post):

Code: Select all

gcc  -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2  -L/usr/lib64 -L/usr/lib64/mysql  -o cactid  sql.o cactid.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o  -lnetsnmp -lmysqlclient -lmysqlclient -lcrypto -lz -lpthread -lm -lnsl
cactid.o(.text+0x7d): In function `main':
/home/dgamble/cactid/cactid.c:150: undefined reference to `install_cactid_signal_handler'
cactid.o(.text+0x841):/home/dgamble/cactid/cactid.c:602: undefined reference to `uninstall_cactid_signal_handler'
collect2: ld returned 1 exit status
make: *** [cactid] Error 1

At least it knows where to look for the libraries now. This is after an "autoconf", "./configure" and then "make" (autoconf 2.59, gcc 3.4.5, on RHEL, 64-bit). I don't actually know if this is the expected way to build this, since the files in SVN don't appear to contain any instructions whatsoever on how to build it...

[TheWitness]

Well, you must have taken some of the cactid source as well. You need the Makefile.am, and then run automake. You will also need the error.c and error.h that I introduced in this new version.

TheWitness

[dgamble]

Well, you must have taken some of the cactid source as well. You need the Makefile.am, and then run automake. You will also need the error.c and error.h that I introduced in this new version.

TheWitness

Thanks for your reply.

I am a bit confused here. Yes, of course I did take the cactid source... that's what I need to compile, after all. These commands were run in the "cactid" directory, which is what I checked out. Your error.c and error.h are in there. I must be missing something here.

I'll poke at it a bit early next week. I was able to get the cactid-0-8-6e working earlier today on 64-bit by adding the appropriate entries to the configure file.

[TheWitness]

Talked with Ian again today. I'm pushing for the release...

TheWitness

[fla_roadkill]

Hello, is there any update on this? I am having the same issue with compiling on a 64Bit platform. Thanks much for all the hard work.

[TheWitness]

Are you attempting to build 0.8.6i or some other release?

TheWitness