List for users of the RefDB bibliography database package

Frank M Salter | 12 Jul 2011 15:57

RefDB chooses NOT to communicate with latest version of PostgreSQL

Refdb complains about the version number of the latest version of
PostgreSQL 9.0.4 and does not continue.

Is there real incompatibility?

Is there a workaround to allow access?

If not, what is the latest version of PostgreSQL with which RefDB will
work successfully?

Regards

Frank Salter

------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric 
Ries, the creator of the Lean Startup Methodology on "Lean Startup 
Secrets Revealed." This video shows you how to validate your ideas, 
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev

headers

markus.hoenicka | 13 Jul 2011 21:43

RefDB chooses NOT to communicate with latest version of PostgreSQL

Frank M Salter writes:
 > Refdb complains about the version number of the latest version of
 > PostgreSQL 9.0.4 and does not continue.
 > 
 > Is there real incompatibility?
 > 
 > Is there a workaround to allow access?
 > 
 > If not, what is the latest version of PostgreSQL with which RefDB will
 > work successfully?
 > 

Hi Frank,

it would be very helpful to actually see the error messages. In fact,
I suspect the problem is more likely related to the libdbi driver
rather than to RefDB itself. In any case, please use the refdbd -l
(and maybe -e and -L) command line switches or the corresponding
variables in /usr/local/etc/refdb/refdbdrc (don't forget to restart or
reload the server in that case) to switch on debug level
logging. You'll find the documentation right here:

http://refdb.sourceforge.net/manual/re02.html

Now run any refdbc or refdba command which demonstrates the problem,
and send the refdbd log to the list.

You should also try to locate the PostgreSQL log output. I can't recall
where it goes to by default, but have a look at /var/log/messages for
a start.

(Continue reading)

headers

markus.hoenicka | 17 Jul 2011 18:52

RefDB chooses NOT to communicate with latest version of PostgreSQL

Frank M Salter writes:
 > Refdb complains about the version number of the latest version of
 > PostgreSQL 9.0.4 and does not continue.
 > 
 > Is there real incompatibility?
 > 

Hi Frank,

I've set up PostgreSQL 9.03 on my FreeBSD 8.1 box. I've edited
pg_hba.conf to use password authentication for everything. I've then
set up a RefDB database according to

http://refdb.sourceforge.net/manual/ch04s08.html#sect2-manual-setup

I've used manual setup as I've already installed RefDB with MySQL as a
backend. Next I've added myself as a user. The only problem that I
encountered is that I cannot connect to PostgreSQL unless I provide a
password with the refdba adduser command, but this is expected. After
adding the user properly, I was able to use RefDB without any
problems.

Now if that procedure does not work on your box, we'll have to figure
out other potential problems. I've checked the PostgreSQL release
notes. There should not be any changes from 9.03 to 9.04 that pertain
to access problems.

To get an idea of what else may be the culprit, could you please
provide some more system information. Please run the following
command:

(Continue reading)