cross
New Foswiki release 2.1.6 is available with important security fixes.
Sourceforge foswiki email lists being discontinued. Subscribe to the new Foswiki announce and discuss lists at MailingLists
This question about Using an extension: Answered

DBI driver name for Postgres

Hello

I am trying to install the Dtabase Plugin and I have largely succeeded having connected to a My SQL test database. Unfortunately the data I wish to access is in a Postgres (8.3) database. I have changed the approrpriate fields in configure but I am unable to find the driver name. I thought it might be pg, which I have tried and also postgres but both return an error. Postgres is installed on the same machine as foswiki so I am fairly sure that the dbi driver will be installed

Can anyone tell me what the driver is called please.

-- RayHojka - 24 Jun 2009

Quick search on the net suggests: Pg. Have you tried already?

-- OliverKrueger - 24 Jun 2009

Thanks for the response. Yes I have tried that already. Also tried postgres. I also installed libdbd-pg-perl so I'm fairly sure I have the driver installed but when I enter use pg I get this response

install_driver(pg) failed: Can't locate DBD/pg.pm in @INC (@INC contains: /var/lib/foswiki/lib /etc/foswiki . /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl) at (eval 220) line 3. at (eval 220) line 3 eval 'package # hide from PAUSE DBI::_firesafe; # just in case require DBD::pg; # load the driver

Perhaps I'm missing something else?

Any help is appreciated.

-- RayHojka - 26 Jun 2009

Problem sorted. Many thanks for the help. I noticed after pasting in the error above that I had used 'pg' and not 'Pg'. ( Cant get used to Linux being case sensitive as I have to use Windows a lot of the time).

Thanks again.

-- RayHojka - 26 Jun 2009

QuestionForm edit

Subject Using an extension
Extension DatabasePlugin
Version
Status Answered
Topic revision: r3 - 26 Jun 2009, RayHojka - This page was cached on 22 Mar 2018 - 03:15.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License