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

[Cory Hubert]

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