You are not logged in.

#1 2004-08-11 17:19:53

lanrat
Member
From: Poland
Registered: 2003-10-28
Posts: 1,274

tora pkgbuild: oracle tool with postgresql and mysql support

Tora is a tool for oracle databases with some support for postgresql and mysql.
tora PKGBUILD

pkgname=tora-alpha
pkgver=1.3.14.1
pkgrel=1
pkgdesc="Qt toolkit originally for Oracle databases administration with some support for Postgresql and Mysql"
url="http://www.globecom.net/tora/"
depends=('qt')
makedepends=('perl')
conflicts=('tora')
source=(http://dl.sourceforge.net/tora/${pkgname}-${pkgver}.tar.gz)
md5sums=('5560b5104438e1b71bd89386d0fcdc00')

build() {

  cd $startdir/src/tora-$pkgver

  ./configure --prefix=/usr 
    --without-kde 
    --without-oracle 
    --without-rpath

  make || return 1

  make ROOT=$startdir/pkg install

}

I'm posting this pkgbuild only for testing/research.
Fist, it's alpha (aka devel) version but stable release does not want to easly compile on my machine and it's too old IMO.
As you can see it can be built without the need for kde (good news for other WMs/DEs users).
The funny thing is that I built it without support for... oracle :-) That's because it needs lots of oracle stuff installed and I don't have it. If someone has, he can build a static version of oracle support (if you do please post some info here if it works, etc.).
The postgresql/mysql support depends on the qt package configuration. Current qt arch package does not inlcude postgresql/mysql plugin support. The next qt release will have mysql support at least (http://bugs.archlinux.org/index.php?do=details&id=1040, http://bugs.archlinux.org/index.php?do=details&id=1166) and I have made a feature reqest for postgresql http://bugs.archlinux.org/index.php?do=details&id=1244.
I'm still not 100% sure if postgresql and mysql should/shouldn't be put in makedepends (according to the docs and mailinglists it's not needed). I'll check that again when new qt release will be available.

In other words in such configuration and present qt version this application is pretty useless :-) (though it can be run). But I'm posting this pkgbuild for the others (if someone needs to test it or tries to build it, etc.). I'm sure tora will soon be more attractive especially for someone using oracle databases.

Offline

#2 2005-01-27 12:16:39

Cybermario
Member
Registered: 2004-03-10
Posts: 16

Re: tora pkgbuild: oracle tool with postgresql and mysql support

Doesn't work for me yet, even with QT 3.3.4.  :cry:

Offline

#3 2005-01-27 22:51:16

lanrat
Member
From: Poland
Registered: 2003-10-28
Posts: 1,274

Re: tora pkgbuild: oracle tool with postgresql and mysql support

Details?

Note: this application seems a little outdated now but there are no new releases.

Offline

#4 2005-01-28 12:19:06

Cybermario
Member
Registered: 2004-03-10
Posts: 16

Re: tora pkgbuild: oracle tool with postgresql and mysql support

It'was always saying "no provider connection found":

But now, with the last update of QT 3.3.4-2 it works ... yes, now that I'plaining to migrate to knoda.  wink

Offline

#5 2005-01-28 17:00:41

lanrat
Member
From: Poland
Registered: 2003-10-28
Posts: 1,274

Re: tora pkgbuild: oracle tool with postgresql and mysql support

This was becasue support for postgresql and mysql is only through qt and these dbms were upgraded in the meantime. I guess new qt was recompiled with the latest versions of psql and mysql libs.

Offline

#6 2005-01-30 14:37:11

miki
Member
Registered: 2003-04-02
Posts: 25

Re: tora pkgbuild: oracle tool with postgresql and mysql support

I built it with oracle support and it works ok. You have to export the oracle home path first.

pkgname=tora-alpha
pkgver=1.3.14.1
pkgrel=1
pkgdesc="Qt toolkit originally for Oracle databases administration with some
support for Postgresql and Mysql"
url="http://www.globecom.net/tora/"
depends=('qt')
makedepends=('perl')
conflicts=('tora')
source=(http://dl.sourceforge.net/tora/${pkgname}-${pkgver}.tar.gz)
md5sums=('5560b5104438e1b71bd89386d0fcdc00')

build() {

  export ORACLE_HOME=/opt/oracle/product/10.1.0

  cd $startdir/src/tora-$pkgver

  ./configure --prefix=/usr
    --with-qt=/opt/qt
    --with-qt-lrelease=/opt/qt/bin/lrelease
    --with-kde
    --with-oracle
    --without-rpath

  make || return 1

  make ROOT=$startdir/pkg install

}

Offline

#7 2005-01-30 14:48:06

lanrat
Member
From: Poland
Registered: 2003-10-28
Posts: 1,274

Re: tora pkgbuild: oracle tool with postgresql and mysql support

miki: tnx. good job.

Offline

#8 2005-01-31 10:17:22

Cybermario
Member
Registered: 2004-03-10
Posts: 16

Re: tora pkgbuild: oracle tool with postgresql and mysql support

Hey Miki, please how did you install Oracle on Linux ???

I get always en error compiling sqlplus.mk, dbms.mk, etc.

Which version you have? any tips, please ?

Offline

#9 2006-08-14 09:41:20

STiAT
Member
From: Vienna, Austria
Registered: 2004-12-23
Posts: 606

Re: tora pkgbuild: oracle tool with postgresql and mysql support

This won't work using a newer oracle instant client version though, since the pathes won't be set correct.
The Project TOra won't use automake, since the author refuses doing so.
Probably it would be a larger patching work to get it working with instantclient_10_2 (the current release version from Oracle).

Why so?
It seems as if the include pathes for the oracle client won't be set correclty, since TOra seems to expect a full oracle product installation.

The configure does not accept a --with-oracle-includes or --with-oracle-libs option any longer (in 1.3.21 it did). Therefore, TOra won't find in example oci.h, since it's not in any include directory known.
Also, some other files are not in the path TOra expects them to be.
Without the possibility of passing by configure options handling this, i guess it won't be possible to get this TOra version running with the current instantclient.

// STi


Ability is nothing without opportunity.

Offline

Board footer

Powered by FluxBB