[OPEN-ILS-DEV] Creating the database schema

[Mike Rylander]

On 3/7/07, Don McMorris <don.mcmorris at gmail.com> wrote:
> When I was helping Grace a week or two ago, I came across this also.
> I forget the issue exactly... All I remember is that the database
> issue that was fixed in 1.0.24 (from 1.0.23) didn't appear to have
> been fixed in 1.1.0.
>
> When I say database issue, I mean when I tried manually the
> build-db.sh script (/ILS/Open-ILS/src/sql/Pg/), one of the merge
> scripts gave an error (I think it may've been "schema.metabib.sql",
> but I don't recall).

That was actually a separate issue, but it was also found by our
intrepid dbs.  That was a premature view definition (a dependent table
didn't exist yet, just an ordering issue), but this seems to be that
we're not including the DB initializing make target by default in the
1.1 stuff.

We'll fix the default with the next dev release, but it's not a
show-stopper IMHO.  In any case, there will probably be a 1.1.2 very
soon (early and often, early and often)... :)

>
> I guess I'll have to fire up my time-making machine so that I can
> farse with it some more ;)
>
> Before I run ahead and update the Wiki to reflect running apache as
> OpenSRF, has anyone tried this with a successful outcome? I mean,
> wouldn't want to break Apache's stuff now would we? ;)
>

I just checked our dev server and it runs apache as user opensrf.
Just use the User http.conf setting to control that.

Thanks Don!

-miker

> --Don
>
> On 3/7/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.
> >
> > In any case, there's a new dev cut in the works ... I'll announce soon! :)
> >
> > >
> > > I should also point out, as an aside, that apache either needs to be
> > > running under the opensrf user, or you need to set the permissions on
> > > the files in the cgi-bin directory so that the apache user can read &
> > > execute them.
> > >
> >
> > Good point.  For simplicity's sake, running Apache as opensrf is
> > probably easiest ... anyone feel like updating the wiki? ;)
> >
> > > Dan
> > >
> >
> >
> > --
> > Mike Rylander
> > mrylander at gmail.com
> > GPLS -- PINES Development
> > Database Developer
> > http://open-ils.org
> >
>


-- 
Mike Rylander
mrylander at gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org