[OPEN-ILS-DEV] Creating the database schema

[Don McMorris]

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).

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? ;)

--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
>