Re: compiling unixodbc support
Eddie <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <CAGJaks=-wuG-C8tbpQtjgrxUX7=V-eJhd0OR8zzFiSDiFj0uZg@mail.gmail.com> |
still trying to figure out whats wrong Im getting the following from configure stderr ./configure --prefix=/home/aubit/aubit4gl --with-informix=/home/informix --with-pgsql=no --with-pdf=/usr/local/bin --with-unixodbc=/usr/bin --with-iodbc=no configure: WARNING: ** Directory specified as prefix: configure: WARNING: ** /home/aubit/aubit4gl configure: WARNING: ** already exists. configure: WARNING: Installing aubitrc for current user only configure: WARNING: No system global settings will be created configure: WARNING: GNU Make 3.81 and possibly up broken completely. Google for more info - but you've chosen to ignore it... ./configure: line 19150: mysql_config: command not found ./configure: line 19234: mysql_config: command not found configure: WARNING: No locally installed postmaster detected configure: WARNING: Disabled testing for PG ESQL compiler - libpg was not detect ed configure: WARNING: incl/cli/infxcli.h: present but cannot be compiled configure: WARNING: incl/cli/infxcli.h: check for missing prerequisite heade rs? configure: WARNING: incl/cli/infxcli.h: see the Autoconf documentation configure: WARNING: incl/cli/infxcli.h: section "Present But Cannot Be Compi led" configure: WARNING: incl/cli/infxcli.h: proceeding with the compiler's result configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: incl/cli/infxsql.h: present but cannot be compiled configure: WARNING: incl/cli/infxsql.h: check for missing prerequisite heade rs? configure: WARNING: incl/cli/infxsql.h: see the Autoconf documentation configure: WARNING: incl/cli/infxsql.h: section "Present But Cannot Be Compi led" configure: WARNING: incl/cli/infxsql.h: proceeding with the compiler's result configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: Missing incl/cli/infxcli.h or incl/cli/infxsql.h - disabling Informix ODBC support configure: WARNING: Using headers from Aubit CVS - tools/odbctest/pgsql/iodbc configure: WARNING: pgsql/iodbc/isql.h: present but cannot be compiled configure: WARNING: pgsql/iodbc/isql.h: check for missing prerequisite heade rs? configure: WARNING: pgsql/iodbc/isql.h: see the Autoconf documentation configure: WARNING: pgsql/iodbc/isql.h: section "Present But Cannot Be Compi led" configure: WARNING: pgsql/iodbc/isql.h: proceeding with the compiler's result configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: pgsql/iodbc/isqlext.h: present but cannot be compiled configure: WARNING: pgsql/iodbc/isqlext.h: check for missing prerequisite he aders? configure: WARNING: pgsql/iodbc/isqlext.h: see the Autoconf documentation configure: WARNING: pgsql/iodbc/isqlext.h: section "Present But Cannot Be Co mpiled" configure: WARNING: pgsql/iodbc/isqlext.h: proceeding with the compiler's result configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: isql.h: present but cannot be compiled configure: WARNING: isql.h: check for missing prerequisite headers? configure: WARNING: isql.h: see the Autoconf documentation configure: WARNING: isql.h: section "Present But Cannot Be Compiled" configure: WARNING: isql.h: proceeding with the compiler's result configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: isqlext.h: present but cannot be compiled configure: WARNING: isqlext.h: check for missing prerequisite headers? configure: WARNING: isqlext.h: see the Autoconf documentation configure: WARNING: isqlext.h: section "Present But Cannot Be Compiled" configure: WARNING: isqlext.h: proceeding with the compiler's result configure: WARNING: ## ----------------------------------------------------- ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ----------------------------------------------------- ## /bin/bash: line 7: /etc/ld.so.conf: Permission denied this section from stdout seems to indicate everything is in place but the plugin doesnt get built ^[[1mChecking for iODBC support:^[[m disabled ^[[1mChecking for unixODBC support:^[[m checking for main in -lodbc... yes checking sql.h usability... yes checking sql.h presence... yes checking for sql.h... yes checking sqlext.h usability... yes checking sqlext.h presence... yes checking for sqlext.h... yes checking odbcinst.h usability... yes checking odbcinst.h presence... yes checking for odbcinst.h... yes ADBACCESS: Query-language Error: can't open DLL /home/aubit/aubit4gl/plugins-1.2_28/libSQL_unixodbc.so - STOP Error msg: /home/aubit/aubit4gl/plugins-1.2_28/libSQL_unixodbc.so: cannot open shared object file: No such file or directory---- aubit4glsrc]$ ll /home/aubit/aubit4gl/plugins-1.2_28/*odbc* ls: /home/aubit/aubit4gl/plugins-1.2_28/*odbc*: No such file or directory On Tue, Jan 28, 2014 at 11:34 AM, Eddie <[email protected]> wrote: > It is not in the plugins directory so it seems its not getting compiled. > When I tried compiling unixODBC from source it had dependency problems with > qt so I'm using the one from the RHEL repositories. Is there a specific > binary/file I can run a find for to verify what would be the correct path > on --with-unixodbc ? > > For example, odbcinst is in /usr/bin > > > On Tue, Jan 28, 2014 at 11:28 AM, Mike Aubury <[email protected]> wrote: > >> Do you have a "libSQL_unixodbc.so" in the plugins directory ? >> >> (--with-unixodbc=/usr/bin looks wrong so it might not be detecting >> unixodbc properly) >> >> >> On 28 January 2014 15:26, Eddie <[email protected]> wrote: >> >>> >>> >>> >>> adding --with-iodbc=no got it to compile but adbacces fails to open >>> when using type=odbc >>> >>> >>> ADBACCESS: Query-language Error: can't open DLL >>> /home/aubit/aubit4gl/plugins-1 >>> .2_28/libSQL_unixodbc.so - STOP >>> Error msg: >>> /home/aubit/aubit4gl/plugins-1.2_28/li >>> bSQL_unixodbc.so: cannot open shared object file: No such file or >>> directory---- >>> >>> >>> >>> ./configure --prefix=/home/aubit/aubit4gl --with- >>> informix=/home/informix --with-pgsql=no --with-pdf=/usr/local/bin >>> --with-unixodb >>> c=/usr/bin --with-iodbc=no >>> >>> Aubit 4gl compiler is working - compiler build was successfull. >>> >>> >>> >>> >>> Im using unixODBC from yum repository so Im using /usr/bin for the path >>> in the configure command >>> >>> Installed Packages >>> unixODBC.i386 2.2.11-10.el5 installed >>> unixODBC.x86_64 2.2.11-10.el5 installed >>> unixODBC-devel.i386 2.2.11-10.el5 installed >>> unixODBC-devel.x86_64 2.2.11-10.el5 installed >>> unixODBC-libs.i386 2.2.11-10.el5 installed >>> unixODBC-libs.x86_64 2.2.11-10.el5 installed >>> >>> >>> >>> >>> >>> >>> >>> >>> On Tue, Jan 28, 2014 at 10:59 AM, Mike Aubury <[email protected]> wrote: >>> >>>> Did you rerun the ./configure ? >>>> What about --with-iodbc=no >>>> or --without-iodbc >>>> >>>> ? >>>> >>>> >>>> >>>> On 28 January 2014 14:40, Eddie <[email protected]> wrote: >>>> >>>>> >>>>> thanks for responding, >>>>> >>>>> removed libiodbc and a few files left behind in /usr/lib/libiodbc.* >>>>> but it seems to be required when using --with-unixodbc=/usr/bin >>>>> >>>>> gcc -shared sql.o sqlex.o array.o sqlstates.o -o >>>>> /home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so -liodbc >>>>> -L/usr/local/lib -L/usr/lib -L/usr/local/lib >>>>> /usr/bin/ld: cannot find -liodbc >>>>> collect2: ld returned 1 exit status >>>>> gmake[2]: *** >>>>> [/home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so] Error 1 >>>>> >>>>> >>>>> >>>>> I can query SQL server with no problems using odbc from the CLI >>>>> /usr/bin/isql -v mssql2005 >>>>> +---------------------------------------+ >>>>> | Connected! | >>>>> | | >>>>> | sql-statement | >>>>> | help [tablename] | >>>>> | quit | >>>>> | | >>>>> +---------------------------------------+ >>>>> SQL> >>>>> >>>>> >>>>> >>>>> but aubit wont compile when adding odbc support >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Tue, Jan 28, 2014 at 4:25 AM, Mike Aubury <[email protected]> wrote: >>>>> >>>>>> That looks like its the iodbc library thats broken - not the unixodbc >>>>>> (at least - not at that point in time) >>>>>> >>>>>> Try removing the libraries completely (especially iodbc if you're not >>>>>> using it) - and reinstall unixodbc ? >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On 28 January 2014 03:20, Eddie <[email protected]> wrote: >>>>>> >>>>>>> Hi all, >>>>>>> >>>>>>> >>>>>>> Trying to compile unixodbc support to query tables in MS SQLSERVER >>>>>>> from 4gl modules but getting an error: >>>>>>> >>>>>>> >>>>>>> >>>>>>> ./configure --prefix=/home/aubit/aubit4gl >>>>>>> --with-informix=/home/informix --with-pgsql=no --with-pdf=/usr/local/bin >>>>>>> --with-unixodbc=/usr/bin >>>>>>> >>>>>>> >>>>>>> gcc -shared sql.o sqlex.o array.o sqlstates.o -o >>>>>>> /home/aubit/sourcecode/aubit4gl >>>>>>> src/plugins-1.2_35/libSQL_iodbc.so -liodbc -L/usr/local/lib >>>>>>> -L/usr/lib -L/usr/lo >>>>>>> cal/lib >>>>>>> /usr/bin/ld: skipping incompatible /usr/lib/libiodbc.so when >>>>>>> searching for -liod >>>>>>> bc >>>>>>> /usr/bin/ld: /usr/lib/libiodbc.a(catalog.o): relocation R_X86_64_32 >>>>>>> against `iod >>>>>>> bcdm_global_lock' can not be used when making a shared object; >>>>>>> recompile with -f >>>>>>> PIC >>>>>>> /usr/lib/libiodbc.a: could not read symbols: Bad value >>>>>>> collect2: ld returned 1 exit status >>>>>>> gmake[2]: *** >>>>>>> [/home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so >>>>>>> ] Error 1 >>>>>>> gmake[2]: Leaving directory >>>>>>> `/home/aubit/sourcecode/aubit4glsrc/lib/libsql/odbc' >>>>>>> gmake[1]: *** >>>>>>> [/home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so >>>>>>> ] Error 2 >>>>>>> gmake[1]: Leaving directory `/home/aubit/sourcecode/aubit4glsrc/lib' >>>>>>> make: *** [corecompile] Error 2 >>>>>>> >>>>>>> >>>>>>> >>>>>>> rpm -qa |grep -i odbc >>>>>>> unixODBC-2.2.11-10.el5 >>>>>>> unixODBC-libs-2.2.11-10.el5 >>>>>>> libiodbc-devel-3.52.7-1.el5 >>>>>>> unixODBC-libs-2.2.11-10.el5 >>>>>>> unixODBC-devel-2.2.11-10.el5 >>>>>>> libiodbc-3.52.7-1.el5 >>>>>>> unixODBC-2.2.11-10.el5 >>>>>>> unixODBC-devel-2.2.11-10.el5 >>>>>>> libiodbc-devel-3.52.7-1.el5 >>>>>>> libiodbc-3.52.7-1.el5 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Seems to be some misconfiguration between 32 and 64 bit libraries. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> environment >>>>>>> >>>>>>> >>>>>>> export AUBITDIR=/home/aubit/aubit4glsrc >>>>>>> export AUBITDIR_SRC=/home/aubit/aubit4glsrc >>>>>>> export A4GL_INIFILE=/home/aubit/aubit4glsrc/etc/aubitrc >>>>>>> export AWK=gawk >>>>>>> export DBSCREENOUT=/tmp/${USER}.out >>>>>>> export A4GL_PRINTSCRKEY=CONTROL-P >>>>>>> export A4GL_PRINTSCRFILE=+$DBSCREENOUT >>>>>>> export ODDOPTIONS=N >>>>>>> export FORCE_CLOSE=Y >>>>>>> export BINDDBDATE=Y >>>>>>> export CACHESCHEMA=Y >>>>>>> export DATE_AS_CHAR=Y >>>>>>> export NO_UPDATE_TABLE=Y >>>>>>> export FIXUPDATE=Y >>>>>>> export A4GL_SQLTYPE=esql >>>>>>> export DBDATE=DMY4/ >>>>>>> #export SQLUID=xxx >>>>>>> #export SQLPWD=yyy >>>>>>> #export >>>>>>> PATH=$PATH:/home/aubit/aubit4glsrc/bin:/usr/local/unixODBC/bin >>>>>>> export PATH=$PATH:/home/aubit/aubit4glsrc/bin >>>>>>> export NODATETIMES=Y >>>>>>> export A4GL_ALLOWCOMMAINDECIMAL=Y >>>>>>> export LOGODBCSQL=N >>>>>>> export A4GL_NUMERIC=,. >>>>>>> export DATE_AS_ISO_DATE_STRING=Y >>>>>>> export USEREALTABLEFORREP=Y >>>>>>> #export >>>>>>> LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/unixODBC/lib:/lib:/lib/esql:/usr/local/lib:/home/aubit/aubit4glsrc/lib >>>>>>> export >>>>>>> LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/lib/esql:/usr/local/lib:/home/aubit/aubit4glsrc/lib >>>>>>> >>>>>>> >>>>>>> cat /etc/redhat-release >>>>>>> Red Hat Enterprise Linux Server release 5.5 (Tikanga) >>>>>>> >>>>>>> uname -a >>>>>>> Linux localhost 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT >>>>>>> 2010 x86_64 x86_64 x86_64 GNU/Linux >>>>>>> >>>>>>> >>>>>>> >>>>>>> How can I troubleshoot this problem? >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> ------------------------------------------------------------------------------ >>>>>>> WatchGuard Dimension instantly turns raw network data into actionable >>>>>>> security intelligence. It gives you real-time visual feedback on key >>>>>>> security issues and trends. Skip the complicated setup - simply >>>>>>> import >>>>>>> a virtual appliance and go from zero to informed in seconds. >>>>>>> >>>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk >>>>>>> _______________________________________________ >>>>>>> Aubit4gl-discuss mailing list >>>>>>> [email protected] >>>>>>> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> WatchGuard Dimension instantly turns raw network data into actionable >>>>> security intelligence. It gives you real-time visual feedback on key >>>>> security issues and trends. Skip the complicated setup - simply import >>>>> a virtual appliance and go from zero to informed in seconds. >>>>> >>>>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk >>>>> _______________________________________________ >>>>> Aubit4gl-discuss mailing list >>>>> [email protected] >>>>> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss >>>>> >>>>> >>>> >>> >>> >>> ------------------------------------------------------------------------------ >>> WatchGuard Dimension instantly turns raw network data into actionable >>> security intelligence. It gives you real-time visual feedback on key >>> security issues and trends. Skip the complicated setup - simply import >>> a virtual appliance and go from zero to informed in seconds. >>> >>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk >>> _______________________________________________ >>> Aubit4gl-discuss mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss >>> >>> >> > ------------------------------------------------------------------------------ WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk _______________________________________________ Aubit4gl-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss