TOra 1.3.6.1 alpha ebuild

[rizzo]

I realize that all things come to those who wait, but I thought I'd give a post here in case anyone wanted to try it out while I'm waiting for the bug-wranglers to come across this:

https://bugs.gentoo.org/show_bug.cgi?id=4430

The ebuild and digest for the latest and greatest TOra, a gui client for Oracle that will soon rival TOAD. You need to have the Oracle client software installed, I recommend 9i, which you can download from Oracle. I don't know the answers to any licensing questions, so I'm assuming you are kosher on that end.

Anyway TOra is open-source and free, which is a Good Thing(tm).

[mueller]

Hi,
I'm just wondering, why we have to use oracle (which of course is not in gentoo...), while the original tora is able to connect to mysql and postgresql and others.
regards,
axel

[rizzo]

Yeah you are right. I had taken mysql into account. I'll edit the ebuild to handle the postgres USE flag.

I guess one issue with excluding oracle is that there is no "oracle" USE flag. Does anyone know the policies on just putting new use flags into the mix? I assume I could handle it and you would have to just put "oracle" or "-oracle" in your make.conf.

[rizzo]

Alright the jury's still out on the idea of an oracle USE flag. I'll get back to you on that one.

mysql and postgres support will be present assuming you compiled qt >= 3.0.0 with mysql and/or postgres support.

I'm working with one of the bug-wranglers on how to handle an oracle flag. His last message to me was

[longint]

No luck for me. Is anyone using tora in combination with gcc32?

TiA
--------

toral tora-1.3.7 # emerge tora
Calculating dependencies ...done!
>>> emerge dev-db/tora-1.3.7 to /
>>> md5 tora-alpha-1.3.7.tar.gz
>>> Unpacking source...
>>> Unpacking tora-alpha-1.3.7.tar.gz
>>> Source unpacked.
kde
oci8
checking for perl... perl
checking for KDE include files ... /usr/kde/3/include
checking for KDE version ... 3.0.3
checking for KDE print support ... yes
checking for KDE libraries ... /usr/kde/3/lib
checking for KDE base ... /usr/kde/3
checking for Qt library linked to KDE ... libqt-mt
checking for Qt library ... /usr/qt/3/lib
checking for moc ... /usr/qt/3/bin/moc
checking for uic ... /usr/qt/3/bin/uic
checking for lrelease ... /usr/qt/3/bin/lrelease
checking for Qt include files ... /usr/qt/3/include
checking for Qt version ... 3.0.5
checking for library consistency ... yes
checking for static Qt library ... no
checking for Oracle ... /opt/oracle
checking for Oracle version ... 8.1.7.0.0
checking for MySQL support ... Available through QSql only with Qt >= 3.0.0
checking for any database ... Oracle QSql
checking for extra libraries ... -lcrypt
checking /usr/bin/cc compiler ... In file included from /tmp/toraconfig.30486.cpp:6:
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h: In member function `void
otl_cur::error(otl_exc&)':
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h:8023: `min' undeclared
(first use this function)
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h:8023: (Each undeclared
identifier is reported only once for each function it appears in.)
no
checking /usr/bin/g++ compiler ... In file included from /tmp/toraconfig.30486.cpp:6:
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h: In member function `void
otl_cur::error(otl_exc&)':
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h:8023: `min' undeclared
(first use this function)
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h:8023: (Each undeclared
identifier is reported only once for each function it appears in.)
no
checking /usr/bin/gcc compiler ... In file included from /tmp/toraconfig.30486.cpp:6:
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h: In member function `void
otl_cur::error(otl_exc&)':
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h:8023: `min' undeclared
(first use this function)
/var/tmp/portage/tora-1.3.7/work/tora-1.3.7/otlv4.h:8023: (Each undeclared
identifier is reported only once for each function it appears in.)
no

Failed to find compatible GCC compiler. This doesn't necessary mean that
there are no c++ compiler that won't work. This test includes compiling
a Qt application using Oracle. So if anything went wrong finding these
this test will fail.

The command tried was the following ($CC is replaced with whatever C
compiler used):

$CC "-L/usr/kde/3/lib" -Xlinker "--rpath=/usr/kde/3/lib" "-L/opt/oracle/lib" "-L/usr/qt/3/lib" -Xlinker "--rpath=/opt/oracle/lib" -Xlinker "--rpath=/usr/qt/3/lib" -I`pwd` "-I/usr/kde/3/include" "-I/opt/oracle/rdbms/demo" "-I/opt/oracle/plsql/public" "-I/opt/oracle/rdbms/public" "-I/opt/oracle/network/public" "-I/usr/qt/3/include" -lm -lpthread -lkdeprint -lkdecore -lkdeui -lDCOP -lkhtml -lkparts -lkio -lcrypt -ldl -lqt-mt -lclntsh -otemp /tmp/toraconfig.30486.cpp


!!! ERROR: The ebuild did not complete successfully.
!!! Function src_compile, Line 27, Exitcode 2
!!! configure failed

[rizzo]

This is actually an issue being discussed on the tora-develop mailing list at the moment.

http://www.geocrawler.com/lists/3/SourceForge/9281/0/

[rizzo]

According to the TOra author, the fixes for GCC 3.2 should be in CVS, which means they'll be in the 1.3.8 release. You could probably whip up an ebuild based on 1.3.7 and have it use the nightly tarball from http://tora.sourceforge.net/tora-nightly.tar.gz if you don't want to wait for 1.3.8.

[longint]

Have you tried it? It doesn't work.
I read that thread too, but the fix is regarding to another issue (in my opinion)...

Thx,
Jan

----------------

toral tora-20020903 # ./configure
checking for perl... perl
checking for KDE include files ... /usr/kde/3/include
checking for KDE version ... 3.0.3
checking for KDE print support ... yes
checking for KDE libraries ... /usr/kde/3/lib
checking for KDE base ... /usr/kde/3
checking for Qt library linked to KDE ... libqt-mt
checking for Qt library ... /usr/qt/3/lib
checking for moc ... /usr/qt/3/bin/moc
checking for uic ... /usr/qt/3/bin/uic
checking for lrelease ... /usr/qt/3/bin/lrelease
checking for Qt include files ... /usr/qt/3/include
checking for Qt version ... 3.0.5
checking for library consistency ... yes
checking for static Qt library ... no
checking for Oracle ... /opt/oracle
checking for Oracle version ... 8.1.7.0.0
checking for MySQL support ... Available through QSql only with Qt >= 3.0.0
checking for any database ... Oracle QSql
checking for extra libraries ... -lcrypt
checking for plugin support ... yes
checking /usr/bin/cc compiler ... In file included from /tmp/toraconfig.7675.cpp:6:
/usr/src/tora-20020903/otlv4.h: In member function `void
otl_cur::error(otl_exc&)':
/usr/src/tora-20020903/otlv4.h:8023: `min' undeclared (first use this function)
/usr/src/tora-20020903/otlv4.h:8023: (Each undeclared identifier is reported
only once for each function it appears in.)
no
checking /usr/bin/g++ compiler ... In file included from /tmp/toraconfig.7675.cpp:6:
/usr/src/tora-20020903/otlv4.h: In member function `void
otl_cur::error(otl_exc&)':
/usr/src/tora-20020903/otlv4.h:8023: `min' undeclared (first use this function)
/usr/src/tora-20020903/otlv4.h:8023: (Each undeclared identifier is reported
only once for each function it appears in.)
no
checking /usr/bin/gcc compiler ... In file included from /tmp/toraconfig.7675.cpp:6:
/usr/src/tora-20020903/otlv4.h: In member function `void
otl_cur::error(otl_exc&)':
/usr/src/tora-20020903/otlv4.h:8023: `min' undeclared (first use this function)
/usr/src/tora-20020903/otlv4.h:8023: (Each undeclared identifier is reported
only once for each function it appears in.)
no

Failed to find compatible GCC compiler. This doesn't necessary mean that
there are no c++ compiler that won't work. This test includes compiling
a Qt application using Oracle. So if anything went wrong finding these
this test will fail.

The command tried was the following ($CC is replaced with whatever C
compiler used):

$CC "-L/usr/kde/3/lib" -Xlinker "--rpath=/usr/kde/3/lib" "-L/opt/oracle/lib" "-L/usr/qt/3/lib" -Xlinker "--rpath=/opt/oracle/lib" -Xlinker "--rpath=/usr/qt/3/lib" -I`pwd` "-I/usr/kde/3/include" "-I/opt/oracle/rdbms/demo" "-I/opt/oracle/plsql/public" "-I/opt/oracle/rdbms/public" "-I/opt/oracle/network/public" "-I/usr/qt/3/include" -lm -lpthread -lkdeprint -lkdecore -lkdeui -lDCOP -lkhtml -lkparts -lkio -lcrypt -ldl -lqt-mt -lclntsh -otemp /tmp/toraconfig.7675.cpp

[rizzo]

No I don't use GCC 3 so I haven't had this problem. Perhaps you might want to join the tora-develop mailing list and post your problem.

[NePhie]

ok setting oci8 as a use flag makes it compile with oracle support BUT it fails...

[rizzo]

Uhh ... you need to have the oracle client software installed. This is a fact. I don't have the oracle server installed on any of the machines that I use TOra from. But you need to install the oracle client software. This is just a fact, jack.

TOra doesn't do it automatically for the same reason that there isn't an Oracle ebuild package. You have to go to Oracle's website and manually agree to all sorts of licensing. Once you've installed the oracle client software and set your environment variables you should be good to go.

[NePhie]

ok tnx

but euhm...wouldn't it be "a-good-idea" to make the tora ebuild say this, maybe with a url and a good description at what it needs....a bit like the ebuild of sun java ? (maybe even alot like the ebuild of sun java, so one would just have to download it, copy it to the right directory and let it emerge...isn't this what it's all about?)


allright, let's see how them peeps called this client software, i don't see it on first glance
_________________
.:: $witty_statement ::.

[rizzo]

Yes you are right. This is something that I meant to do originally but never got around to and eventually forgot about.

TOra 1.3.8 is due out this Monday, I'll try to have this for the next ebuild. Probably should also have an -r1 for the 1.3.7.

Sorry for the confusion. Don't let it stop you from enjoying TOra.

[NePhie]

great ... I really think i'll be using tora yes

so for now i just have to find out what i have to download, cause i don't really find it :/
_________________
.:: $witty_statement ::.

[rizzo]

[rizzo]

[NePhie]

tnx.....

really nasty you have to download 1+ gig for a client though :/
damn oracle :/
_________________
.:: $witty_statement ::.

[rizzo]

https://bugs.gentoo.org/show_bug.cgi?id=8724

TOra 1.3.7-r1 ebuild and digest files submitted to the bug wranglers. We'll see when it gets added.

[rizzo]

[NePhie]

tnx
_________________
.:: $witty_statement ::.

[NePhie]

pff ...i unpack the files, create the user, create the dirs, export the stuff, ...

and when i try to run the runInstaller , i get a "permission denied" error ... and the unpacked files are all owned by the user oracle (which is the user created earlier, and with whom i try to run it) and it has exec rights set :/
_________________
.:: $witty_statement ::.

[rizzo]

I'm sure there's something simple you're missing. I've followed those instructions for many linux installs and they've worked every time. Keep at it and double-check your steps.

[NePhie]

for some strange reason, the oracle user isn't allowed to acces the x server ??

and that "xhost...." stuff doesn't work...unknown command stuff (yes as root)

and i am running this on my desktop pc, so according to those docs, it shouldn't be a problem :/
_________________
.:: $witty_statement ::.

[rizzo]

Are you doing "su" or "su -". You probably want to do "su -".

Also in addition to allowing xhost +localhost you need to export the display as the oracle user:

[NePhie]

well actually i'm doing "su oracle" since it says i should do it as the oracle user i created ....

and allowing xhost+localhost ... the line in that docs does not work...at all

it's xhost blablabla...and xhost gives unknown command
_________________
.:: $witty_statement ::.