headers
Frank M Salter | 12 Jul 2011 15:57
Picon
Favicon

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
Permalink | Reply | 2 comments |
headers
markus.hoenicka | 13 Jul 2011 21:43
Picon

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)

Permalink | Reply | 0 comments |
headers
markus.hoenicka | 15 Jul 2011 23:15
Picon

Re: RefDB chooses NOT to communicate with latest version of PostgreSQL

Hi Frank,

Frank M Salter writes:
 > main database version is not supported

this in fact indicates that the libdbi driver somehow doesn't manage
to talk to the PostgreSQL engine properly.

 > At some point: I was using a number of terminal screens and did not
 > see the exact moment
 > when the following (transcribed by me) appeared:
 > =======================================================
 > *** glibc detected  *** refdb *** munmap_chunk(): invalid pointer
 > 0xb75f48e0  ***
 > =======  Backtrace:  =======
 > /lib/libc.so.6(+0x6f68a)[0xb76f068a]
 > /usr/local/lib/libdbi.so.1(dbi_result_free + 0x14c)[0xb782827c]
 > refdbd[0x804d9a5]
 > /lib/libc.so.6(__libc_start_main+0xe6)[0xb7697db6]
 > refdbd[0x804aa21]

This looks like a crash in libdbi. This may be caused by some
incompatibility between the driver and the engine, or it's just a
plain libdbi bug. However, I've never had any such crashes with any of
the drivers that I've used, so I still suspect the pgsql driver does
not work well with the latest PostgreSQL releases.

 > Thank you for your prompt reply. If you need any more information,
 > please let me know.
(Continue reading)

Permalink | Reply | 0 comments |
headers
markus.hoenicka | 17 Jul 2011 18:52
Picon

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)

Permalink | Reply | 0 comments |

Gmane