Thread: connect from perl: error in Carp.pm

Hello,


When I try to connect as following, I get an error in Carp.pm:

use DBI;

# connecting to database

my $username = 'marc';
my $password = 'marc';

$dbh = DBI->connect("DBI:Pg:dbname=my_db", $username, $password,{AutoCommit
=> 1, RaiseError => }) || die "Unable to connect to database $DBI::errstr";


 => Not a CODE reference at /usr/lib/perl5/5.8.3/Carp.pm line 178.

Any idea what this error means?

Maybe there are some right issue; I installed DBI and DBD as root, I'm
calling the script as root, but postgres runs under its own user.

cpan>  install DBI
cpan>  install DBD::pg

Thanks,

Marc

--
+++ Sparen beginnt mit GMX DSL: http://www.gmx.net/de/go/dsl

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> When I try to connect as following, I get an error in Carp.pm:
>
> $dbh = DBI->connect("DBI:Pg:dbname=my_db", $username, $password,{AutoCommit
> => 1, RaiseError => }) || die "Unable to connect to database $DBI::errstr";
>
> => Not a CODE reference at /usr/lib/perl5/5.8.3/Carp.pm line 178.

> Maybe there are some right issue; I installed DBI and DBD as root, I'm
> calling the script as root, but postgres runs under its own user.

I doubt that's it, but I am not sure what is going on. Can you tell us more
about the circumstances: is this a standalone script. Perhaps an Apache
cgi script? What version of DBI, DBD::Pg, PostgreSQL, and (if applicable)
Apache?

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200505040730
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCeLJ8vJuQZxSWSsgRAtJjAJ9nt32BwOR0w2+++lRbq6vOxpidFwCg2J8v
09LIIY04dj+ymCWZp6yj7o8=
=UyEq
-----END PGP SIGNATURE-----

Greg Sabino Mullane wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>
>
>
>>When I try to connect as following, I get an error in Carp.pm:
>>
>>$dbh = DBI->connect("DBI:Pg:dbname=my_db", $username, $password,{AutoCommit
>>=> 1, RaiseError => }) || die "Unable to connect to database $DBI::errstr";
>>
>>=> Not a CODE reference at /usr/lib/perl5/5.8.3/Carp.pm line 178.
>>
>>
>
>
>
>>Maybe there are some right issue; I installed DBI and DBD as root, I'm
>>calling the script as root, but postgres runs under its own user.
>>
>>
>
>I doubt that's it, but I am not sure what is going on. Can you tell us more
>about the circumstances: is this a standalone script. Perhaps an Apache
>cgi script? What version of DBI, DBD::Pg, PostgreSQL, and (if applicable)
>Apache?
>
>

I'm going to go out on a limb here and guess that the problem is the
missing value for RaiseError in your connect statement.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.