[OPEN-ILS-DEV] Creating the database schema

[Don McMorris]

For those not monitoring Wiki changes through E-Mail subscription or
RSS, I've updated the "Generic Apache2 configs" per Dan's suggestion
and Mike's confirmations:

http://www.open-ils.org/dokuwiki/doku.php?id=generic_apache2_configs&rev=1163947150&do=diff

This now includes the suggestion to run Apache as the "opensrf" user.

--Don

On 3/7/07, Mike Rylander <mrylander at gmail.com> wrote:
> On 3/7/07, Dan Scott <denials at gmail.com> wrote:
> > On 07/03/07, Mike Rylander <mrylander at gmail.com> wrote:
> > > On 3/4/07, Dan Scott <denials at gmail.com> wrote:
> > > > Hi:
> > > >
> > > > Trying out 1.1.0 and seem to have most things working (all of the
> > > > opensrf drones are running, I am not seeing opensrf-c crashing as I
> > > > was before increasing the max_user_sessions variable for ejabberd).
> > > >
> > > > However, the database is empty; none of the tables have been created,
> > > > which means that nothing really works. From reading through the
> > > > comments, it sounds like the schema should be created as part of the
> > > > Evergreen "make install" - but I have tried running that again to no
> > > > avail. I have confirmed that the database is empty through psql. I
> > > > *know* that with the 1.0.2.x versions the schema used to be created at
> > > > install time :)
> > > >
> > > > So what is the process for creating the schema in 1.1.0?
> > >
> > > It's the same as the 1.0 series ... I'm not sure at all what could be
> > > going wrong other than not having the proper target in the make list.
> > > Other than a /very/ early error (say, in the offline schema) that's
> > > the only thing that would keep the entire thing from happening
> > > altogether ... and even that would leave some stuff in the DB.
> > >
> >
> > Yep, mea culpa, there was a lack of a proper target in the make list.
> > It looks like the default targets changed between the 1.0.x series
> > (defaulting to opensrf-all openils-all evergreen-core) and 1.1.x
> > series (opensrf-all openils-core openils-web evergreen-core). Adding
> > openils-all to the make target in 1.1.x solved that problem -- but now
> > I've discovered that the 1.1.x branch started making use of
> > PostgreSQL's contrib/xml2 functions, and of course I didn't have "xml"
> > in my USE flags, so I'm off and recompiling PostgreSQL again. Heh...
> > the fun never stops :)
>
> Well, it's not exactly making use of it yet ... but you will need to
> install the xml2 contrib module in dev.  It's actually more
> complicated than that (requiring a patch to the contrib module), so I
> think I'll extract that bit from 1.1.2...
>
> So, mea culpa back atcha! :)
>
> --
> Mike Rylander
> mrylander at gmail.com
> GPLS -- PINES Development
> Database Developer
> http://open-ils.org
>