Re: [Slashcode-development] postgresql trouble

[Alessio B. <al...@al...>]

so...@sp... wrote:

> my problem with setting slash (1.1.1-bender) up on postgresql is what follows.

>                            'connect' => 'DBI:Pg:database=slash;host=localhost',

A connect string for PostgreSQL is slightly different. Reads
'DBI:Pg:dbname=slash;host=localhost;port=5432', cannot remember if the
port is needed if it's 5432.

> Can't call method "quote" on an undefined value at

I think the db connection doesn't get initialized.

> /usr/lib/perl5/site_perl/5.005/i386-linux/Slash/DB/MySQL.pm line 2817.

Why it's in MySQL.pm?

> oh, when i change 'driver' => 'PostgreSQL' it spits out:
> DRIVER Pg:slash
> Picking PostgreSQL
> Major Mojo Bad things
> Can't read $DBI::errstr, last handle unknown or destroyed at /usr/lib/perl5/site_perl/5.005/i386-linux/Slash/DB/Utility.pm line 44.
> unable to connect to MySQL: Can't connect(DBI:PostgreSQL slash kaparma.. HASH(0x821dcc8)), no database driver specified and DBI_DSN env var not set at /usr/lib/perl5/site_perl/5.005/DBIx/Password.pm line 31

This makes more sense, it should say anyway 'unable to connect to
PostgreSQL', but maybe it's hardwired in the code?

I will have a try, but I think you should change the connect string.

-- 
Alessio F. Bragadini		al...@al...
APL Financial Services		http://village.albourne.com
Nicosia, Cyprus		 	phone: +357-2-755750

"It is more complicated than you think"
		-- The Eighth Networking Truth from RFC 1925