[mb-devel] Re: Having trouble setting up MusicBrains on OSX 10.3.5

[Cory Hubert]

At this point I am just documenting my progress in the forum for
whoever else encounters these problems.  Seems like the crew is busy. 
But if you able to help me out, please chime in.


pg_settings table does not exist in the template1 db for postgresql 7.3.7-21

I upgraded to postgresql74 - 7.4.5-21 to be precise.

Perhaps the INSTALL documentation should change to say postgres74 or
specify the exact version of 73 you can use.


Now I am having issues syncing up the codebase with the datadumps.....

Current errors when I run InitDB

Wed Oct 20 11:24:31 2004 : Validating snapshot
Wed Oct 20 11:24:32 2004 : Snapshot timestamp is 2004-10-16 07:52:44.30401+00
Wed Oct 20 11:24:32 2004 : Schema sequence mismatch - codebase is 2,
snapshot files are 3

Failed to import dataset.
Wed Oct 20 11:24:32 2004 : InitDb.pl failed

Currently trying to match up the timestamp of the data with correct
cvs tagged codebase

I currently have RELEASE_2004109-BRANCH and I just downloaded the
latest dumps and got the error message above.




On Tue, 19 Oct 2004 17:50:44 -0400, Cory Hubert <clhubert at gmail.com> wrote:
> Still having some issues but I did some tracing into InitDB and found this
> 
> select setting from pg_settings where name = 'lc_collate'
> 
> on like 116.  It seems like it tries to run a sql query on a table
> that doesn't exist so it returns blank.  That's why it can't pick up
> the correct locale setting.
> 
> Any ideas?   It seems like it might be something trivial.
> 
> 
> 
> On Tue, 19 Oct 2004 11:51:12 -0400, Cory Hubert <clhubert at gmail.com> wrote:
> > So I ran fink to get postgresql and installed the necessary Perl
> > Modules from perl -MCPAN -e shell
> > .
> > I create /home/httpd/musicbrains and checked out mb_server into there.
> > I created the symbolic link to perl in the
> > /home/httpd/musicbrainz/mb_server/cgi-bin directory.
> >
> > I also created the postgres user and gave it a password.
> >
> > here is what happened.
> >
> > Step 1:
> > initialize db: (As postgres user)
> > initdb --locale=C -D /usr/local/pgsql/data/
> >
> > Note:
> > creating template1 database in /usr/local/pgsql/data//base/1... ok
> > It used to say this step failed (but still built the template1 db)
> > saying it couldn't locate something with LC_MESSAGES I set some perl
> > locale environment variables to equal "C" in my .profile and it works
> > now.
> >
> > Step 2:
> > Starting postgres: (As postgres user)
> > /sw/bin/pg_ctl-7.3 -D /usr/local/pgsql/data/ -l
> > /sw/var/postgresql/pgsql.log start
> >
> > Note;
> > Never any problems here.
> >
> > Step 3:
> > Trying to import (as root)
> > :/home/httpd/musicbrainz/mb_server root# ./admin/InitDb.pl --echo
> > --createdb --import --with-replication
> > --with-pending=/sw/lib/postgresql/pending.so
> > ~clhubert/MusicBrianz/mbdump*.tar.bz2
> >
> > Tue Oct 19 11:30:11 2004 : InitDb.pl starting
> > Use of uninitialized value in string eq at ./admin/InitDb.pl line 119.
> > Use of uninitialized value in concatenation (.) or string at
> > ./admin/InitDb.pl line 121.
> > It looks like your Postgres database cluster was created with locale ''.
> > MusicBrainz needs the "C" locale instead.  To rectify this, re-run "initdb"
> > with the option "--locale=C".
> > Tue Oct 19 11:30:11 2004 : InitDb.pl failed
> >
> > Bottom of postgresql.conf
> > LC_MESSAGES = 'C'
> > LC_MONETARY = 'C'
> > LC_NUMERIC = 'C'
> > LC_TIME = 'C'
> >
> > It's quite odd that the InitDb.pl script says locale isn't set but it
> > clearly is.  any ideas?
> >
>