I give up: perhaps somebody else knows an answer?

Well having spent all day and done several reinstalls, I can't get it
done. Here's a wikified list of what I did the last time, in case anybody
can figure out how to solve the problem.

The problem seems to lie in a couple of architecture mixups:

1) refdb build from source seems to look in the wrong place for libdbi0
library files, though this should be fixable with an option on
./configure, it doesn't seem to work. You can get around it by symlinking
the libdbi0 librarys from /usr/local/lib/ to /usr/lib

2) libdbi0-drivers is unable to recognise debian installations of mysql.
You should be able to get around this by adding the
--with-mysql-directory, but it is unclear what directory ./configure
wants. I tried every single mysql directory (as far as I can tell) and got
nowhere. I also tried /usr/bin, and similar directories to no avail.

If you follow the instructions here below, you can get refdb up and
running, but will run into the "Initiatialized libdbi, but no drivers were
found!" error. Until point 2) is solved, you won't get past that.

==Installing refdb from a clean install of Ubuntu 6.06 LTS==

* Ensure that the community and multiverse repositories are enabled.

* get the make utility

 sudo apt-get install make

* Install mysql server and client

  sudo apt-get install mysql-client mysql-server

* Get btparse (Universe)

 sudo apt-get install libbtparse0 libbtparse-dev

* Get libreadline5-dev (libreadline5 is already installed)

 sudo apt-get install libreadline5-dev

* Get gcc

 sudo apt-get install gcc

* Get libexpat-dev files (libexpat already installed)

 sudo apt-get install libexpat1-dev

* Get source files for libdbi0 =>8.0. In the download directory do the
following (note: Debian linux stores library files in a different
directory than the source files for libdbi install them in. You need to
symlink the libdbi files to /usr/lib from /usr/local/lib/):

 wget http://umn.dl.sourceforge.net/sourceforge/libdbi/libdbi-0.8.1.tar.gz
 tar zxvf libdbi-0.8.1.tar.gz
 cd libdbi-0.8.1/
 ./configure
 make
 sudo make install
 cd ..

* Get source files for libdbi drivers and install (note this doesn't seem
to work in Debian: the configure file is unable to tell that mysql is
installed, and I for one can't figure out what root directory it is
looking for when I try to specify one with --with-mysql-dir):

 wget
http://umn.dl.sourceforge.net/sourceforge/libdbi-drivers/libdbi-drivers-0.8.1a.tar.gz
 tar zxvf libdbi-drivers-0.8.1a.tar.gz
 cd libdbi-drivers-0.8.1/
 ./configure --with-mysql
 make
 sudo make install
 cd ..

* Get refdb

 wget http://refdb.sourceforge.net/pre/refdb-latest.tar.gz

* install (note: during make you will get a recurring invalid pointer
error. This is not important).

 tar zxvf refdb-latest.tar.gz
 cd refdb-0.9.7-pre7/
 ./configure --sysconfdir=/etc
--with-refdb-url=http://refdb.kakelbont.homelinux.net/refdb
 make
 sudo make install

* Add a password to mysql

 mysqladmin -u root password '<your favourite password here>'

* Run the installation script
 cd /usr/local/bin/
 sudo refdb-init.sh

==Problems==

* Everything works fine except the libdbi0 and libdbi0-drivers.
Unfortunately these are fatal problems. You can get around the build
problems with libdbi0 by symlinking the relevant files as mentioned above,
but nothing I could do could solve the libdbi0-drivers problem.




-- 
Daniel Paul O'Donnell
Director, Digital Medievalist Project (http://www.digitalmedievalist.org/)
Associate Professor of English
University of Lethbridge
Lethbridge AB T1K 3M4
Tel. +1 (403) 329-2377
Fax. +1 (403) 382-7191

(@webmail)


All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642