[Pangloss] pg_admin shell basics, creating a pixie store

Bruno Postle bruno at mkdoc.com
Fri Feb 20 13:25:18 GMT 2004


I'm trying to create the initial Pixie store using the pg_admin
tool.

I've created a test mysql database called pangloss1 and a
user/password pair: pangloss1/pangloss1.

I figured out that the syntax for connecting with these details is
something like this:

    connect 'dbi:mysql:dbname=pangloss1:pass=pangloss1:user=pangloss1'

..but before that, I can't even create a Pixie store by following
the instructions in the INSTALL file:

    create store 'dbi:mysql:dbname=pangloss1:password=pangloss1:user=pangloss1'

    String found where operator expected at (eval 29) line 1, near "store 'dbi:mysql:dbname=pangloss1:password=pangloss1:user=pangloss1'"
        (Do you need to predeclare store?)
    syntax error at (eval 29) line 1, near "store 'dbi:mysql:dbname=pangloss1:password=pangloss1:user=pangloss1'"

The Pixie documentation isn't much use, if I follow the
instructions:

    #!/usr/bin/perl
    use Pixie;
    my $pixie = Pixie->new->connect ('dbi:mysql:dbname=pangloss1',
    user => 'pangloss1', pass => 'pangloss1');

I get an error because the Pixie store doesn't already exist:

DBD::mysql::st execute failed: Table 'pangloss1.px_object' doesn't exist at /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi/Pixie/Store/DBI/Default.pm line 217.

-- 
Bruno


More information about the Pangloss mailing list