[fdo-users] Problem building FDO 3.3 with MySQL/ODBC on CentOS 5

[Gavin Cramer]

Hm... was there any version pre-installed with the OS?  It looks like patchlevels are being mixed.  Unixodbc has different ways of being installed -- RPM, tarball, and whatever the OS distribution might use.  It might be worth searching the filesystem for multiple instances of files in the package.  Things to find would be libodbc.so or isql.

What was your source for the RPM -- from the CentOS distribution, or straight from http://www.unixodbc.org ?  I have seen some problems with distribution builds (e.g. RedHat) where there were run-time failures to find the .ini files from any client other than isql.  There appears to be some critically different way that RedHat builds the driver manager; perhaps CentOS does the same thing.  Thus, getting the generic unixodbc.org build is recommended.

While searching for issues with SQLGetPrivateProfileString in other forums, I found some notes from Easysoft on link-time options for drivers:  http://www.easysoft.com/developer/interfaces/odbc/linux.html .  I wonder if there are similar right and wrong ways to build the driver manager as well.

Other articles of interest:

http://mail.easysoft.com/pipermail/unixodbc-dev/2004-December/thread.html#296 ("Problem loading our ODBC driver")

http://www.nabble.com/libodbcinst.so-td11580016.html

In the "Problem loading our ODBC driver" articles, there is mention of the dynamic linker being unable to find SQLGetPrivateProfileString in 2.2.10, whereas 2.2.8 worked fine.  If some problem was found and subsequently fixed in a later patchlevel, it would be important to make sure that there are no remnants of an earlier version in an installation.  While neither of the variations (2.2.11-1 and 2.2.11-7.1) that you reported would be old enough (generic 2.2.11-1 is the tested version), it would be worth the time to manually make sure that generic 2.2.11-1 is the one and only version that exists anywhere on the system.

Do you have the MySQL Connector/ODBC installed?  This is the ODBC driver for MySQL.  It should be no older than version 3.51.16.  This is a run-time requirement, and should not be an issue during the build.  I am just noting it for after you get past the build issue.  It is available here:  http://dev.mysql.com/downloads/connector/odbc/3.51.html .

Gavin


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Andy Morsell
Sent: Thursday, March 13, 2008 10:19 PM
To: fdo-users at lists.osgeo.org
Subject: RE: [fdo-users] Problem building FDO 3.3 with MySQL/ODBC on CentOS 5


Hi Gavin,
I installed version 2.2.11-1 of unixODBC-core and unixODBC-devel.  But, when
I do an rpm, it is showing 2.2.11-7.1 of core.

Thanks.


Gavin Cramer wrote:
>
> Hello, Andy.  What version of unixodbc is installed?
>
> Gavin
>
>
> From: fdo-users-bounces at lists.osgeo.org
> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Andy Morsell
> Sent: Thursday, March 13, 2008 7:27 PM
> To: fdo-users at lists.osgeo.org
> Subject: [fdo-users] Problem building FDO 3.3 with MySQL/ODBC on CentOS 5
>
>
> I'm trying to build FDO 3.3 on CentOS 5.  I have been able to build with
> the core providers without MySQL / ODBC support, but when I attempt to
> build with that provider, it fails.  It fails in the same place when using
> the FDO build_linux script with the --w rdbms switch, or when using the
> build_linux script separately from the GenericRdbms directory.  It does
> not fail if running the FDO build_linux script with all default settings,
> but the FDO ODBC files are never created.  I do have the MySQL client and
> developer libraries installed and correctly referenced via the FDOMYSQL
> environment variable.  I also have the unixodbc libraries installed.
> Below is the last few lines of the build.  Any insight on where to go next
> would be appreciated.  Thank you.
>
>
> ../Rdbi/.libs/librdbi.a ../Util/.libs/libutil.a /usr/lib/libodbc.so -ldl
> -lpthread -lz  -Wl,--rpath -Wl,/usr/local/fdo-3.3.0/lib
>
> ../ODBC/.libs/libFdoRdbmsODBC.a(FdoRdbmsOdbcConnection.o): In function
> `FdoRdbmsOdbcConnection::GetSchemaNameFromDsn()':
>
> FdoRdbmsOdbcConnection.cpp:(.text+0x1c8f): undefined reference to
> `SQLGetPrivateProfileString'
> collect2: ld returned 1 exit status
> make[3]: *** [UnitTestOdbc] Error 1
> make[3]: Leaving directory
> `/Software/FDO/OpenSource_FDO/Providers/GenericRdbms/Src/UnitTest'
> make[2]: *** [all-recursive] Error 1
> make[2]: Leaving directory
> `/Software/FDO/OpenSource_FDO/Providers/GenericRdbms/Src/UnitTest'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory
> `/Software/FDO/OpenSource_FDO/Providers/GenericRdbms/Src'
> make: *** [all-recursive] Error 1
>
> Andy Morsell, P.E.
> Spatial Integrators, Inc.
> http://www.SpatialGIS.com
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>

--
View this message in context: http://www.nabble.com/Problem-building-FDO-3.3-with-MySQL-ODBC-on-CentOS-5-tp16041144s18162p16042947.html
Sent from the fdo-users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users