Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 59203
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: ribasushi [...] leporine.io
Cc:
AdminCc:

Bug Information
Severity: Unimportant
Broken in: (no value)
Fixed in: (no value)



Subject: Unable to automatically locate a *.mk on oracle-xe under debian
Download (untitled) / with headers
text/plain 4.9k
DBD::Oracle compiles cleanly against the .deb of Oracle XE (distributed by oracle themselves), but sadly requires handholding: =================== Files available from Oracle: =================== rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ locate .mk | grep oracle /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/env_ctx.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/ins_ctx.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk =================== Without hints: =================== rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client perl Makefile.PL Using DBI 1.611 (for perl 5.013002 on i686-linux-thread-multi) installed in /home/rabbit/perl5/perlbrew/perls/5.13.2/lib/site_perl/5.13.2/i686-linux-thread-multi/auto/DBI/ Configuring DBD::Oracle for perl 5.013002 on linux (i686-linux-thread-multi) Remember to actually *READ* the README file! Especially if you have any problems. Installing on a linux, Ver#2.6 Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/client DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) Oracle version 10.2.0.1 (10.2) Unable to locate an oracle.mk, proc.mk or other suitable *.mk file in your Oracle installation. (I looked in /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_rdbms32.mk /usr/share/oracle/xe/app/oracle/product/10.2.0/client/demo.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/demo/proc/proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/demo/proc/demo_proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/proc/lib/proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/proc16/lib/proc16.mk /usr/share/oracle/10.2/client/demo.mk /usr/share/oracle/10.2/client64/demo.mk under /usr/lib/oracle/xe/app/oracle/product/10.2.0/client) The oracle.mk (or demo_rdbms.mk) file is part of the Oracle RDBMS product. The proc.mk (or demo_proc.mk) file is part of the Oracle Pro*C product. You need to build DBD::Oracle on a system which has one of these Oracle components installed. (Other *.mk files such as the env_*.mk files will not work.) Alternatively you can use Oracle Instant Client. In the unlikely event that a suitable *.mk file is installed somewhere non-standard you can specify where it is using the -m option: perl Makefile.PL -m /path/to/your.mk See the appropriate README file for your OS for more information and some alternatives. at Makefile.PL line 1095. =================== With -m: =================== rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client perl Makefile.PL -m /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Using DBI 1.611 (for perl 5.013002 on i686-linux-thread-multi) installed in /home/rabbit/perl5/perlbrew/perls/5.13.2/lib/site_perl/5.13.2/i686-linux-thread-multi/auto/DBI/ Configuring DBD::Oracle for perl 5.013002 on linux (i686-linux-thread-multi) Remember to actually *READ* the README file! Especially if you have any problems. Installing on a linux, Ver#2.6 Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/client DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) Oracle version 10.2.0.1 (10.2) Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Looks like Oracle XE (/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk) Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Your LD_LIBRARY_PATH env var is set to '' WARNING: Your LD_LIBRARY_PATH env var doesn't include '/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib' but probably needs to. Checking for functioning wait.ph System: perl5.013002 linux thesaurus 2.6.29.2.thes2 #1 preempt tue sep 8 11:27:43 cest 2009 i686 gnulinux Compiler: cc -O2 -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/bin/ld Sysliblist: Oracle makefiles would have used these definitions but we override them: CC: /usr/bin/gcc LDFLAGS: -g [-g] Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/ -lclntsh -lpthread Checking if your kit is complete... Looks good LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib Using DBD::Oracle 1.24. Using DBD::Oracle 1.24. Using DBI 1.611 (for perl 5.013002 on i686-linux-thread-multi) installed in /home/rabbit/perl5/perlbrew/perls/5.13.2/lib/site_perl/5.13.2/i686-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help.txt files. (Of course, you have read README by now anyway, haven't you?) Cheers!
Download (untitled) / with headers
text/plain 613b
Will have to call on you for a little debugging for the Makfile.PL Having a quick look at the output and what I know I am looking for I can see that the Makefile.PL is not finding the file for whatever reason. The only difference is you are using perl 5.13 which is rather new and I have yet to work with it myself. This would lead me to believe that something might be up with perl in this case. Anyway the bug is in find_mkfile someplace if you could have a look there for it yourself as the best I can do now (without the same environment/perl as you) is just provide a warning to use -M if it a debian XE
Download (untitled) / with headers
text/plain 8.7k
On Thu Jul 08 14:37:41 2010, PYTHIAN wrote: Show quoted text
> Will have to call on you for a little debugging for the Makfile.PL > > Having a quick look at the output and what I know I am looking for I can > see that the Makefile.PL is not finding the file for whatever reason.
Sorry I thought it's rather obvious thus didn't elaborate: my @mk_oci32 = ( 'rdbms/demo/demo_rdbms32.mk' ); my @mk_oci64 = ( 'rdbms/demo/demo_xe.mk', 'rdbms/lib/oracle.mk', 'rdbms/demo/oracle.mk', 'rdbms/demo/demo_rdbms.mk', 'rdbms/demo/demo_rdbms64.mk', 'rdbms/lib/ins_rdbms.mk' #Oracle 11 full client for 64 bit and maybe 32 bit?? ); my @mk_oci = perl_is_64bit() ? @mk_oci64 : @mk_oci32; I however run an all-32bit system and yet my file is still called demo_xe.mk. I am attaching a list of files in the Oracle-XE client .deb obtainable from http://download.oracle.com/otn/linux/oracle10g/xe/10201/oracle-xe-client_10.2.0.1-1.0_i386.deb: rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ dpkg -L oracle-xe-client /. /usr /usr/lib /usr/lib/oracle /usr/lib/oracle/xe /usr/lib/oracle/xe/app /usr/lib/oracle/xe/app/oracle /usr/lib/oracle/xe/app/oracle/product /usr/lib/oracle/xe/app/oracle/product/10.2.0 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.csh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/nls_lang.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/ott /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/zip /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/unzip /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jdbc /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jdbc/lib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jdbc/lib/ojdbc14.jar /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jlib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jlib/orai18n.jar /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libsqlplusic.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libsqlplus.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocixe.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libsqora.so.10.1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libnnz10.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocci.so.10.1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libclntsh.so.10.1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocijdbc10.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libheteroxa10.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/utl /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/utl/odbc_update_ini.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html/ODBC_Readme_Unix.html /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html/ODBCRelnotesUS.htm /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html/ODBCRelnotesJA.htm /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/lib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/lib/ottclasses.zip /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/admin /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/admin/ottcfg.cfg /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/xa.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ort.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oro.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/orl.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/orid.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ori.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oratypes.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/odci.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocixmldb.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocikpr.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ociextp.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocidfn.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocidem.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocidef.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ociapr.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ociap.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oci8dp.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oci1.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oci.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiObjects.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiData.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiControl.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiCommon.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiAQ.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occi.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/nzt.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/nzerror.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/odbcdemo.c /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occiobj.typ /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occiobj.cpp /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occidml.cpp /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occidemo.sql /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/cdemo81.c /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/sqlplus.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/runsqlplus.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/registerforonlineforum.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/readdocumentation.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/oraclexe-client-rhel3.menu /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/oraclexe-client-merge.menu /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/gotoonlineforum.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/sqlplus/glogin.sql /usr/lib/oracle/xe/app/oracle/doc /usr/share /usr/share/pixmaps /usr/share/pixmaps/oraclexe-client-10g.png /usr/share/pixmaps/oraclexe-client-gethelp.png /usr/share/pixmaps/oraclexe-client-gotoonlineforum.png /usr/share/pixmaps/oraclexe-client-readdocumentation.png /usr/share/pixmaps/oraclexe-client-registerforonlineforum.png /usr/share/pixmaps/oraclexe-client-runsqlcommandline.png /usr/share/applications /usr/share/applications/oraclexe-client-gotoonlineforum.desktop /usr/share/applications/oraclexe-client-readdocumentation.desktop /usr/share/applications/oraclexe-client-registerforonlineforum.desktop /usr/share/applications/oraclexe-client-runsql.desktop /usr/share/gnome /usr/share/gnome/vfolders /usr/share/gnome/vfolders/oraclexe-client-10g.directory /usr/share/gnome/vfolders/oraclexe-client-gethelp.directory /usr/share/desktop-directories /usr/share/desktop-directories/oraclexe-client-gethelp.directory /usr/share/desktop-directories/oraclexe-client-10g.directory /usr/share/lintian /usr/share/lintian/overrides /usr/share/lintian/overrides/oracle-xe-client /usr/share/doc /usr/share/doc/oracle-xe-client /usr/share/doc/oracle-xe-client/README.Debian /usr/share/doc/oracle-xe-client/copyright /usr/share/doc/oracle-xe-client/changelog.Debian.gz /usr/share/man /usr/share/man/man1 /usr/share/man/man1/client-sqlplus.1.gz /etc /etc/xdg /etc/xdg/menus /etc/xdg/menus/oraclexe-client.menu /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libclntsh.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocci.so
Download (untitled) / with headers
text/plain 351b
Oh OK I think we already fixed that one (looking at the code anyway) can you give this Makefile.pl a try and see if it works for you http://svn.perl.org/modules/dbd-oracle/trunk/Makefile.PL This is the latest version from trunk and it sets this for the mk_oci32 my @mk_oci32 = ( 'rdbms/demo/demo_xe.mk', 'rdbms/demo/demo_rdbms32.mk' );
Download (untitled) / with headers
text/plain 455b
On Thu Jul 08 20:08:14 2010, PYTHIAN wrote: Show quoted text
> Oh OK I think we already fixed that one (looking at the code anyway) > > can you give this Makefile.pl a try and see if it works for you > > http://svn.perl.org/modules/dbd-oracle/trunk/Makefile.PL > > This is the latest version from trunk and it sets this for the mk_oci32 > > my @mk_oci32 = ( > 'rdbms/demo/demo_xe.mk', > 'rdbms/demo/demo_rdbms32.mk' > ); >
Yup. You may close this ticket.
This ticket has been resolved a while ago. Please close.
Duh, apparently I can do it myself.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.