backup(supplement)

in psql ref, copy ref_category to /tmp/ref_category

Directly adding http://refdb.sourceforge.net/debian/release to /etc/apt/sources.list doesn't work because the "Description" field in Packages.gz is in wrong format. So download repositary.tar.gz from http://refdb.sourceforge.net/debian/release and create a local repositary /usr/local/debian/refdb. repositary.tar.gz is broken and needs manual download of refdb_0.9.6-pre2_i386.deb.

install refdb, libperl-marc-charset and libperl-marc-record

config files(/etc/refdb):

• refdbarc: set passwd to *, it'll ask for it.
• refdbcrc: set passwd to *, it'll ask for it.
• refdbdrc: modify the pidfile to be /tmp/refdbd.pid. Now /etc/init.d/refdb becomes much simpler and doesn't contain pidfile.

/etc/init.d/refdb

modify /usr/local to /usr

recovery(supplement)

psql ref <refdb.sql and COPY ref_category from '/tmp/ref_category';

install RefDB-perlmod-0.4(for MARC and Pubmed import filters, i.e. med2ris):

• download RefDB-perlmod-0.4 from sourceforge
• perl Makefile.PL
• make
• make install (require root privilege), file list:

    Installing /usr/local/share/perl/5.8.7/RefDB/Log.pm
    Installing /usr/local/share/perl/5.8.7/RefDB/Pubmed.pm
    Installing /usr/local/share/perl/5.8.7/RefDB/Prefs.pm
    Installing /usr/local/share/perl/5.8.7/RefDB/Makestyle.pm
    Installing /usr/local/share/perl/5.8.7/RefDB/CGI.pm
    Installing /usr/local/man/man3/RefDB::Log.3pm
    Installing /usr/local/man/man3/RefDB::Pubmed.3pm
    Installing /usr/local/man/man3/RefDB::Prefs.3pm
    Installing /usr/local/man/man3/RefDB::CGI.3pm
    Installing /usr/local/man/man3/RefDB::Makestyle.3pm
  

install web interface:

• download source code from sourceforge
• run ./configure --with-db-server=pgsql --disable-server --prefix=/usr. --disable-server makes configure go through without saying needs dbi. --prefix=/usr is because now refdb is a system package. One web file, login.php needs the absolute path of refdbc and refdba.
• cp *.php /usr/local/share/refdb/www
• cp *.html /usr/local/share/refdb/www
• cp *.css /usr/local/share/refdb/www
• change the ownership of /usr/local/share/refdb/www to www-data. Apache needs to create temporary files in that directory.
• apache's conf file remains same
• remove bib2ris med2ris.pl nmed2ris refdbc from /usr/local/cgi_bin. not needed.
• all related to the old version are mirrored into /root/refdb_0.9.4