Re: main database is too old or corrupt

Hi Marcus,

I think the trouble is coming if you try to access mysql rather than
mysql lite.

I have just replaced all the various libraries on my Ubuntu 5.10 setup
with those from your sources.list and still get a database too old or
corrupt error. So I should have all the same versions you do.

Looking over the libdbi info, it is not clear to me that it is finding t
mysql driver even though it is installed and working.

Here are the results of the two windows when I test the installation:


> dan@wiglaf:~$ sudo refdbd -s -e 0 -l 7
> dbi_driver_dir went to:
> 
> dbi is up using default driver dir
> Available libdbi database drivers:
> mysql
> sqlite
> Requested libdbi driver found
> Database directory:
> /var/lib/refdb/db
> application server started
> share extended notes by default
> use /tmp/refdbd_fifo14848 as fifo
> server waiting n_max_fd=4
> server exited gracefully
> 
(and trying to specify mysql):

> dan@wiglaf:~$ sudo refdbd -D mysql -s -e 0 -l 7
> dbi_driver_dir went to:
> 
> dbi is up using default driver dir
> Available libdbi database drivers:
> mysql
> sqlite
> Requested libdbi driver found
> Database directory:
> /var/lib/refdb/db
> application server started
> share extended notes by default
> use /tmp/refdbd_fifo14955 as fifo
> server waiting n_max_fd=4
> 
And in the other terminal:


> dan@wiglaf:~$ sudo refdba -u root
> Password:
> refdba: set
> serverip 127.0.0.1
> port 9734
> verbose f
> pager less
> username root
> timeout 180
> logfile /var/log/refdba.log
> logdest FILE
> loglevel INFO
> refdblib
> refdba: viewstat
> main database is too old or corrupt
> refdba: quit
> 
And the second time:
> 
> dan@wiglaf:~$ sudo refdba -u root
> refdba: set
> serverip 127.0.0.1
> port 9734
> verbose f
> pager less
> username root
> timeout 180
> logfile /var/log/refdba.log
> logdest FILE
> loglevel INFO
> refdblib
> refdba: viewstat
> main database is too old or corrupt
> refdba:
> 







On Sat, 2006-04-03 at 00:19 +0100, Markus Hoenicka wrote:
> Hi,
> 
> $,1 .(Bo$,1 /(Bo writes:
>  > jozef@clue12:~$ refdba
>  > refdba: viewstat
>  > main database is too old or corrupt
>  > refdba:
>  > 
>  > Any idea what could go wrong?
>  > 
> 
> I'm sorry that it took me so long to return to this issue, but my
> dayjob is pretty intense these days.
> 
> I went to an office computer running Debian, purged all refdb and
> libdbi/libdbi-drivers packages to make sure I'm starting from scratch,
> and then went ahead by running the following as root:
> 
> mortimer:/home/markus# apt-get update
> [...]
> mortimer:/home/markus# apt-get install libdbi0
> [...]
> mortimer:/home/markus# apt-get install libdbi0-dev
> [...]
> mortimer:/home/markus# apt-get install libdbd-sqlite
> [...]
> mortimer:/home/markus# apt-get install refdb
> [...]
> Setting up refdb (0.0-cvs-20051003) ...
> Starting bibliography tool application server: refdb.
> /usr/bin/refdbctl start: bibliography tool application server started
> RefDB database ('/var/lib/refdb/db/refdb') is not present.
> Creating it now...
> Database created successfully.
> 
> I have the following entries in my /etc/apt/sources.list:
> 
> deb http://ftp.de.debian.org/debian/ testing main contrib non-free
> deb http://refdb.sourceforge.net/debian/cvs/ testing main
> deb http://libdbi.sourceforge.net/debian testing main
> 
> This installation seems to work ok. viewstat returns the expected
> output. I can create databases and use refdbc to connect to these
> databases. I can add references and retrieve them.
> 
> Now I'd really like to know what's different on those boxes where this
> procedure does not work. Do you all use unstable? Could those affected
> by the "main database is too old or corrupt" problem send me a list of
> the version numbers of the relevant packages? I'm afraid I won't be
> able to fix this unless I can reproduce it.
> 
> regards
> Markus
> 
-- 
Daniel Paul O'Donnell
Associate Professor and Chair,
Director, Digital Medievalist Project
(http://www.digitalmedievalist.org/),
Department of English,
University of Lethbridge,
Lethbridge AB T1K 3M4
Canada

Vox: +1 (403) 329-2378
Fax: +1 (403) 382-7191
email: [email protected]



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642