I posted this originally on Thu, 9 May 2002 16:50:35 -0700 (MST). See http:[EMAIL PROTECTED]/msg11424.html if you want to see the reference.
In any case, the problem was solved and I wanted to record the documents involved for anybody else who has this problem in the future: ---------- Forwarded message ---------- Date: Thu, 16 May 2002 18:27:51 +0200 From: Ritz Daniel <[EMAIL PROTECTED]> To: Aaryn <[EMAIL PROTECTED]> Subject: Re: [Dbi-interbase-devel] DBD::Interbase 0.30 install problems hi aaryn dbd-interbase 0.30 is known not to compile with InterBase prior to 6. but current CVS should compile again with IB 5 (compile only tested on winblows since that's the only platform i have IB 5 for). i don't know if it actually works 'cos i don't have a valid IB5 license. but what i know is that many of the test suit simply cannot work 'cos it tests IB 6 features.... read on... > ############## > Section 2) > I would like to add that I did not perform the Interbase install but I am > sure that the client is installed. I'm not sure if the client libraries > are installed or how to find out. Here are the files in my interbase > include directory: > > landsat: /opt/interbase/include a> ls > gds.f gds.h gds.hxx ibase.h interbase.a perf.h > > Here are the files in my interclient directory. I do not have an > interclient/include. Should I? > interclient is not needed since it's java stuff > > ############## > Section 3) > ------------------------------ > The output of "perl Makefile.PL CC=gcc" is this: > ------------------------------ > > hyperion: > /opt/dial/software/perl_5.6.1/DBD-InterBase-0.30 r> perl Makefile.PL CC=gcc > > InterBase bin directory : > [/opt/interbase/bin] > > InterBase include directory : > [/opt/interbase/include] > > Reading cached test configuration... > > Full path to your test database : > [/opt/interbase/isc4.gdb] please use another database like /tmp/test.gdb (auto created if it doesn't exist) isc4.gdb is the password DB and therefore not a good choice.... > .... > Checking if your kit is complete... > Looks good > Note (probably harmless): No library found for -lgdsmt _not_ harmless. gdsmt is the client library that is used to link dbd-interbase against. are there any files named *gds* in /opt/interbase/lib/ or /usr/lib/ ?? (use ls | grep gds) may be the file has another name with older IB versions...try to edit Makefile.PL, search for -lgdsmt and replace it with -lgds or -lgdslib > Using DBI 1.21 installed in > /opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI > Writing Makefile for DBD::InterBase > > ------------------------------ > > The output of "make" is this: > > ------------------------------ > cp lib/Bundle/DBD/InterBase.pm blib/lib/Bundle/DBD/InterBase.pm > cp InterBase.pm blib/lib/DBD/InterBase.pm > cp lib/DBD/InterBase/FAQ.pm blib/lib/DBD/InterBase/FAQ.pm > /opt/dial/software/bin/perl -p -e "s/~DRIVER~/InterBase/g" < > /opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI/Driver.xst > > InterBase.xsi > /opt/dial/software/bin/perl -I/opt/dial/software/perl_5.6.1/lib/5.6.1/sun4-solaris > -I/opt/dial/software/perl_5.6.1/lib/5.6.1 > /opt/dial/software/perl_5.6.1/lib/5.6.1/ExtUtils/xsubpp -noprototypes -typemap > /opt/dial/software/perl_5.6.1/lib/5.6.1/ExtUtils/typemap InterBase.xs > > > InterBase.xsc && mv InterBase.xsc InterBase.c > gcc -c -I/opt/interbase/include > -I/opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI > -fno-strict-aliasing > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"0.30\" > -DXS_VERSION=\"0.30\" -fPIC > -I/opt/dial/software/perl_5.6.1/lib/5.6.1/sun4-solaris/CORE > > InterBase.c > > gcc -c -I/opt/interbase/include > -I/opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI > -fno-strict-aliasing > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O > -DVERSION=\"0.30\" > -DXS_VERSION=\"0.30\" -fPIC > -I/opt/dial/software/perl_5.6.1/lib/5.6.1/sun4-solaris/CORE > > dbdimp.c > In file included from dbdimp.c:14: > dbdimp.h:30: redefinition of `DBI_SQL_CHAR' > dbdimp.h:30: `DBI_SQL_CHAR' previously defined here > dbdimp.h:30: `SQL_CHAR' undeclared here (not in a function) > dbdimp.h:31: redefinition of `DBI_SQL_NUMERIC' > dbdimp.h:31: `DBI_SQL_NUMERIC' previously defined here > dbdimp.h:31: `SQL_NUMERIC' undeclared here (not in a function) > dbdimp.h:32: redefinition of `DBI_SQL_DECIMAL' > dbdimp.h:32: `DBI_SQL_DECIMAL' previously defined here > dbdimp.h:32: `SQL_DECIMAL' undeclared here (not in a function) > dbdimp.h:33: redefinition of `DBI_SQL_INTEGER' > dbdimp.h:33: `DBI_SQL_INTEGER' previously defined here > dbdimp.h:33: `SQL_INTEGER' undeclared here (not in a function) > dbdimp.h:34: redefinition of `DBI_SQL_SMALLINT' > dbdimp.h:34: `DBI_SQL_SMALLINT' previously defined here > dbdimp.h:34: `SQL_SMALLINT' undeclared here (not in a function) > dbdimp.h:35: redefinition of `DBI_SQL_FLOAT' > dbdimp.h:35: `DBI_SQL_FLOAT' previously defined here > dbdimp.h:36: redefinition of `DBI_SQL_REAL' > dbdimp.h:36: `DBI_SQL_REAL' previously defined here > dbdimp.h:36: `SQL_REAL' undeclared here (not in a function) > dbdimp.h:37: redefinition of `DBI_SQL_DOUBLE' > dbdimp.h:37: `DBI_SQL_DOUBLE' previously defined here > dbdimp.h:38: redefinition of `DBI_SQL_DATE' > dbdimp.h:38: `DBI_SQL_DATE' previously defined here > dbdimp.h:39: redefinition of `DBI_SQL_TIME' > dbdimp.h:39: `DBI_SQL_TIME' previously defined here > dbdimp.h:39: `SQL_TIME' undeclared here (not in a function) > dbdimp.h:40: redefinition of `DBI_SQL_TIMESTAMP' > dbdimp.h:40: `DBI_SQL_TIMESTAMP' previously defined here > dbdimp.h:40: `SQL_TIMESTAMP' undeclared here (not in a function) > dbdimp.h:41: redefinition of `DBI_SQL_VARCHAR' > dbdimp.h:41: `DBI_SQL_VARCHAR' previously defined here > dbdimp.h:41: `SQL_VARCHAR' undeclared here (not in a function) > dbdimp.h:42: redefinition of `DBI_SQL_TYPE_TIME' > dbdimp.h:42: `DBI_SQL_TYPE_TIME' previously defined here > dbdimp.h:43: redefinition of `DBI_SQL_TYPE_DATE' > dbdimp.h:43: `DBI_SQL_TYPE_DATE' previously defined here > dbdimp.h:44: redefinition of `DBI_SQL_ARRAY' > dbdimp.h:44: `DBI_SQL_ARRAY' previously defined here > dbdimp.h:45: redefinition of `DBI_SQL_BLOB' > dbdimp.h:45: `DBI_SQL_BLOB' previously defined here > dbdimp.h:141: redefinition of `struct imp_drh_st' > dbdimp.h:147: redefinition of `struct imp_dbh_st' > dbdimp.h:164: redefinition of `struct imp_sth_st' > dbdimp.h:184: redefinition of `struct vary' > dbdimp.h:187: redefinition of `VARY' > dbdimp.h:187: `VARY' previously declared here > dbdimp.c: In function `ib2sql_type': > dbdimp.c:222: `SQL_FLOAT' undeclared (first use in this function) > dbdimp.c:222: (Each undeclared identifier is reported only once > dbdimp.c:222: for each function it appears in.) > dbdimp.c:226: `SQL_DOUBLE' undeclared (first use in this function) > dbdimp.c:230: `SQL_TYPE_DATE' undeclared (first use in this function) > dbdimp.c:234: `SQL_TYPE_TIME' undeclared (first use in this function) > dbdimp.c:238: `SQL_TIMESTAMP' undeclared (first use in this function) > dbdimp.c: In function `dbd_db_login6': > dbdimp.c:445: `isc_dpb_SQL_dialect' undeclared (first use in this function) > dbdimp.c: In function `ib_st_prepare': > dbdimp.c:1062: `SQL_TYPE_DATE' undeclared (first use in this function) > dbdimp.c:1084: `SQL_TIMESTAMP' undeclared (first use in this function) > dbdimp.c:1097: `SQL_TYPE_TIME' undeclared (first use in this function) > dbdimp.c:1063: warning: unreachable code at beginning of switch statement > dbdimp.c: In function `ib_st_fetch': > dbdimp.c:1492: `SQL_FLOAT' undeclared (first use in this function) > dbdimp.c:1496: `SQL_DOUBLE' undeclared (first use in this function) > dbdimp.c:1562: `SQL_DATE' undeclared (first use in this function) > dbdimp.c:1685: `SQL_BLOB' undeclared (first use in this function) > dbdimp.c:1836: `SQL_ARRAY' undeclared (first use in this function) > dbdimp.c: In function `ib_fill_isqlda': > dbdimp.c:2421: `SQL_TIMESTAMP' undeclared (first use in this function) > dbdimp.c:2429: `SQL_TYPE_DATE' undeclared (first use in this function) > dbdimp.c:2437: `SQL_TYPE_TIME' undeclared (first use in this function) > dbdimp.c:2422: warning: unreachable code at beginning of switch statement > dbdimp.c:2737: `SQL_FLOAT' undeclared (first use in this function) > dbdimp.c:2754: `SQL_DOUBLE' undeclared (first use in this function) > dbdimp.c:2771: `SQL_DATE' undeclared (first use in this function) > dbdimp.c:2783: warning: unreachable code at beginning of switch statement > dbdimp.c:2845: `SQL_BLOB' undeclared (first use in this function) > dbdimp.c:2856: `SQL_ARRAY' undeclared (first use in this function) > make: *** [dbdimp.o] Error 1 > most of these defines are in dbi_sql.h which is included in DBIXS.h (included by the DBD) so i think there's somethings wrong with the DBI installation... what files are in /opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI/ ? what about the perl headers in /opt/dial/software/perl_5.6.1/lib/5.6.1/sun4-solaris/CORE ? the other of these defines not belonging to DBI are InterBase 6 specific stuff. this is fixed in current CVS. for now i can't test the build on sparc/solaris 'cos i don't own a sun. i have to use one at work...may be next week i get an old ultra5...but i can only test with the freely available InterBase 6 or with FireBird 1..... -daniel
