[OPEN-ILS-DEV] cstore problem

[Don McMorris]

Hi Rene:

I'm going to focus on this line:
open-ils.cstore 2007-05-14 12:43:34 [ERR :5882:oils_cstore.c:243:] Error
loading database driver [Pg]
and start troubleshooting from there.

First, I want to make sure the PostgreSQL server is functioning right
and that the evergreen database is populated properly.  To do this:
root# su postgres -c "psql -h tamarak -p 5432 -U evergreen evergreen"
evergreen> \z
evergreen> \q
root#
Note that some of this may be redundant (IE: a couple options are
default), but just to check.
There have been reports in the past that the postgres database wasn't
populating correctly, so if there seems to be a small number of
tables, this could cause your issue (although I believe this was
determined to be caused by a bug that has long since been fixed).  If
you're comfortable, pasting the output may be of help.



Assuming that the above works, my next step would be to verify the
DBD::Pg module is working at least partially correct.  You _should_ be
able to do this as follows (note: I'm not a big Perl guy _yet_, but am
learning):

perl -MDBD::Pg -e
'DBI->connect("dbi:Pg:dbname=evergreen;host=tamarak;port=5432;",
"evergreen", "$password", {AutoCommit => 0});'

(Another note, you may want to wait and see what others think of the
above command... It _could_ potentially break something I guess...)


Let us know how you make out or what you end up with!

--Don

On 5/14/07, Rene Paquin <rpaquin at wlu.ca> wrote:
> Thanks for the suggestion Hennie, however, that didnt fix my problem.
> What dead end have you arrived at?
>
>
>
>
>
>
> >>> hennie at sabinet.co.za 5/14/2007 1:22 PM >>>
> Rene Paquin wrote:
> > The relevant part in openils.xml file is this )I believe and I do
> not
> > see anything out of the ordinary.
> >
> > <open-ils.cstore>
> >                 <keepalive>6</keepalive>
> >                 <stateless>1</stateless>
> >                 <language>C</language>
> >                 <implementation>oils_cstore.so</implementation>
> >                 <max_requests>95</max_requests>
> >                 <unix_config>
> >                     <unix_log>cstore.log</unix_log>
> >                     <unix_sock>cstore.sock</unix_sock>
> >                     <unix_pid>cstore.pid</unix_pid>
> >                     <max_requests>400</max_requests>
> >                     <min_children>1</min_children>
> >                     <max_children>15</max_children>
> >                     <min_spare_children>1</min_spare_children>
> >                     <max_spare_children>5</max_spare_children>
> >                 </unix_config>
> >                 <app_settings>
> >                     <IDL>/openils/conf/fm_IDL.xml</IDL> <!--
> deprecated
> > with 1.1.0-->
> >                     <driver>Pg</driver>
> >                     <database>
> >                         <type>master</type>
> >                         <weight>2</weight>
> >                         <user>evergreen</user>
> >                         <host>tamarak</host>
> >                         <port>5432</port>
> >                         <pw>********</pw>
> >                         <db>evergreen</db>
> >                         <client_encoding>UTF-8</client_encoding>
> >                     </database>
> >                 </app_settings>
> >             </open-ils.cstore>
> >
>
> I'd recommend you substitute the hostname (tamarak) to the fully
> qualified domain name.
>
> I am waiting in anticipation to see your progress as I am at a dead end
>
> :-) I am sitting back to see if you get past the point where I got
> stuck.
>
> Regards,
>
> Hennie
>
>