KInterbasDB

Logged In: YES
user_id=414645

Okay, I just wanted to make sure it wasn't a
kinterbasdb-specific problem.

I'll close this bug report now.

Logged In: YES
user_id=600278

when i tried to start the FireBird DB appp, after installing
it, it did not start. Sorry, I did not look into it much bc i
was getting turned off by the whole thing.

i was working with firebird-1.0.2.908, from ports.

The python module and the Zope product installed fine,
no errors.

hth

Logged In: YES
user_id=414645

Okay. Just a couple of questions, if you don't mind.

"Did not start" means it encountered an error upon import,
or upon your first connection attempt, or what?

What version of Firebird were you attempting to use it with?
I myself haven't been able to get the RPM distro of
Firebird 1.5 to work with kinterbasdb on Linux; kinterbasdb
segfaults in the database client library upon any attempt to
connect. That's ridiculous, because kinterbasdb is broadly
compatible with Interbase and Firebird versions on Win32 and
POSIX; it must be a Firebird 1.5 problem. Is this what you
encountered on FreeBSD?

Logged In: YES
user_id=600278

it compliled but did not start and then we decided it was
more work than we were ready to do for the time being,
and so we put firebird on hold for us.

Logged In: YES
user_id=414645

George, does 3.1_pre4 compile cleanly on FreeBSD?

Logged In: YES
user_id=414645

> Now i just have to get this to work with Zope!

There are two Zope DAs based on kinterbasdb; links are
available at this page (which is just an online version of
kinterbasdb's docs/links.html):
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/*checkout*/kinterbasdb/Kinterbasdb-3.0/docs/links.html

> if you need any help with getting this set up with
> freebsd or the ports, let me know...

When 3.1_pre4 is released (maybe two weeks from now), I'd
appreciate it if you could compile it on FreeBSD and send me
a transcript. I want to ensure that it builds without any
warnings.

Also, I'll update setup.py so that it probes
/usr/local/firebird as a possible database_home_dir if none
is manually specified.

Logged In: YES
user_id=600278

ok i got it to build with python 2.1.3 i modified setup.cfg:

alpha# vi setup.cfg
# Distutils Setup Configuration for the KInterbasDB 3.0

# Manual configuration options
[manual_config]
datetime_include_dir=/usr/local/zope/py21/lib/
python2.1/site-packages/mx/DateTime/mxDateTime

database_is_firebird=1
database_home_dir=/usr/local/firebird
#database_home_dir=d:/code/projects/kinterbasdb/
kinterbasdb
database_include_dir=/usr/local/firebird/include
database_lib_dir=/usr/local/firebird/lib
database_lib_name=gds.so

it built with only a few warnings and the import
kinetrbasdb in python did not throw an error. i've
attached the successful build transcript.

Thanks for your help, didn't occur to me to edit
setup.cfg, Now i just have to get this to work with Zope!

if you need any help with getting this set up with freebsd
or the ports, let me know,

Logged In: YES
user_id=600278

thanks for your help.

version: firebird-1.0.2.908
home: /usr/local/firebird
include: /usr/local/firebird/include
lib: /usr/local/firebird/lib

hth

Logged In: YES
user_id=414645

The compiler can't find the Firebird/Interbase header file
ibase.h (in the command that distutils sends to cc, there's
no "-I/path/to/include/dir" directive sent to the compiler
for the database include directory, as there is for Python
and mx.DateTime).

kinterbasdb's setup.py doesn't know anything specific about
FreeBSD, so it doesn't "autodetect" the database include
directory, as it does (for example) on Windows.

To correct this, manually set the following options in
kinterbasdb's setup.cfg to something like this:
database_home_dir=/path/to/firebird
database_include_dir=/path/to/firebird/include
database_lib_dir=/path/to/firebird/lib

Ideally, kinterbasdb's setup.py would deduce
database_include_dir and database_lib_dir on the basis of
database_home_dir (they're usually subdirectories of
database_home_dir), but the names of those directories have
changed slightly on some platforms over the Interbase
5.5-Firebird 1.5 period, so for the most part I left the
specification manual unless it could be made fully automatic.
-----
In order to make setup.py work more automatically on
FreeBSD, I request the following feedback from you:
- the version of Interbase or Firebird you're using
- the default home, include, and lib directories for that
version of the database on FreeBSD