Re: Upgrade failure

Markus,
> Hi Bruce,
> 
> are you sure you have to? I've just checked the UPGRADING file, and it  
> reports no changes in the reference database schema since 0.9.6. I'd  
> expect that you can continue to access your databases. Are there  
> specific error messages that make you think so? Or did you  
> accidentally hose the databases?

Fear I was confused between my database (refs) and the main database
/usr/local/share/refdb/db/refdb yesterday. After "refdbd -a" didn't seem 
to go well I deleted my refs database and created a new one from a 
single .ris file.

refdbc:  selectdb refs
main database version is not supported

So I have deleted both /usr/local/share/refdb/db/refdb and refs and 
attempted to use refdb-init while root. Below is output, it complains 
about lack of refdb.dump.sqlite

mme-pc2132# refdb-init


This script will help you to set up a fresh RefDB installation.
WARNING: It is not yet designed to upgrade an existing installation.
In this case you'll have to backup your data before running this script
and to restore them after performing this installation.

I'll first ask a couple of questions and try to collect some information
from your system. If all checks are ok, you'll be asked for confirmation
before any changes are committed. Up to that point you can terminate this
script anytime by pressing Ctrl-c


===
Checking for the status of the application server control script.
You need to have the permissions to run this script in order to set up
RefDB with all the bells and whistles. If this test fails, you are most
likely not running as root.
refdbctl seems to be executable.

===
Please select the database engine you want to use.
Available are: mysql pgsql sqlite sqlite3

sqlite3

refdb.dump.sqlite is not readable or missing

refdbd-init.sh failed.
refdb-init is finished.

mme-pc2132# ll /usr/local/etc/refdb/
total 100
-r--r--r--  1 root  wheel   2.6K 11 Aug  2005 bib2riscgirc
-r--r--r--  1 root  wheel   2.6K 19 Mar 14:34 bib2riscgirc.example
-r--r--r--  1 root  wheel   2.6K 11 Aug  2005 bib2risrc
-r--r--r--  1 root  wheel   2.6K 19 Mar 14:34 bib2risrc.example
-r--r--r--  1 root  wheel   1.0K 11 Aug  2005 db2risrc
-r--r--r--  1 root  wheel   1.0K 19 Mar 14:34 db2risrc.example
-r--r--r--  1 root  wheel   1.6K 11 Aug  2005 marc2risrc
-r--r--r--  1 root  wheel   1.6K 19 Mar 14:34 marc2risrc.example
-r--r--r--  1 root  wheel   1.5K 11 Aug  2005 med2riscgirc
-r--r--r--  1 root  wheel   1.5K 19 Mar 14:34 med2riscgirc.example
-r--r--r--  1 root  wheel   1.7K 11 Aug  2005 med2risrc
-r--r--r--  1 root  wheel   1.9K 19 Mar 14:34 med2risrc.example
-r--r--r--  1 root  wheel   1.6K 11 Aug  2005 nmed2riscgirc
-r--r--r--  1 root  wheel   1.5K 11 Aug  2005 nmed2risrc
-r--r--r--  1 root  wheel   1.8K 11 Aug  2005 refdbarc
-r--r--r--  1 root  wheel   1.8K 19 Mar 14:34 refdbarc.example
-r--r--r--  1 root  wheel   2.3K 11 Aug  2005 refdbcgirc
-r--r--r--  1 root  wheel   2.3K 19 Mar 14:34 refdbcgirc.example
-r--r--r--  1 root  wheel   2.7K 11 Aug  2005 refdbcrc
-r--r--r--  1 root  wheel   2.8K 19 Mar 14:34 refdbcrc.example
-rw-r-----  1 root  wheel   3.3K 11 Aug  2005 refdbdrc
-r--r--r--  1 root  wheel   4.2K 19 Mar 14:34 refdbdrc.mysql.example
-r--r--r--  1 root  wheel   4.2K 19 Mar 14:34 refdbdrc.pgsql.example
-r--r--r--  1 root  wheel   4.2K 19 Mar 14:34 refdbdrc.sqlite.example
-r--r--r--  1 root  wheel   4.2K 19 Mar 14:34 refdbdrc.sqlite3.example
-r--r--r--  1 root  wheel   2.7K 11 Aug  2005 refdbibrc
-r--r--r--  1 root  wheel   2.9K 19 Mar 14:34 refdbibrc.example
-r--r--r--  1 root  wheel   3.6K 11 Aug  2005 refdbxmlrc
-r--r--r--  1 root  wheel   3.6K 19 Mar 14:34 refdbxmlrc.example

mme-pc2132# ls /usr/local/share/refdb/
css          declarations dtd          refdb.cat    styles       xsl
db           dsssl        examples     sql          www

mme-pc2132# ls /usr/local/share/refdb/sql/
empty.2.dump.mysql41 empty.2.dump.sqlite3 refdb.2.dump.mysql41 
refdb.2.dump.sqlite
empty.2.dump.pgsql   refdb.2.dump.mysql   refdb.2.dump.pgsql

mme-pc2132# ll /usr/local/share/refdb/sql/
total 156
-r--r--r--  1 root  wheel    10K 19 Mar 14:34 empty.2.dump.mysql41
-r--r--r--  1 root  wheel    26K 19 Mar 14:34 empty.2.dump.pgsql
-r--r--r--  1 root  wheel   3.8K 19 Mar 14:34 empty.2.dump.sqlite3
-r--r--r--  1 root  wheel    31K 19 Mar 14:34 refdb.2.dump.mysql
-r--r--r--  1 root  wheel    20K 19 Mar 14:34 refdb.2.dump.mysql41
-r--r--r--  1 root  wheel    28K 19 Mar 14:34 refdb.2.dump.pgsql
-r--r--r--  1 root  wheel    28K 19 Mar 14:34 refdb.2.dump.sqlite

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV