[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