Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Problem connect to DBD::PgPP <--> Perl

Posted on 2009-02-23
2
Medium Priority
?
560 Views
Last Modified: 2012-08-14
Hi
I am trying to connect via DBI to a PostgresPlus server.

I get the following error:
---------------------------
DBI->connect('dbname=$dbname; host=$host; port=$port','$username',...) failed:
Couldnt connect to /tmp/.s.PGSQL.5432: at C:/Perl/site/lib/DBD/PgPP.pm
------------------------------
I tried to connect PostgresPlus server both in winXP and linux using perl script.Both machines prompt me above error message.
My client pgAdminIII is in winXP.Using pgAdminIII i able to connect to server in both machine.
Here is code snippet:
---------------------------------------
I set up DBD-PgPP via PPM.
---------------------------------------
Any ideas as to what I am missing.

my $conn = DBI->connect("dbi:PgPP:dbname=$dbname; host=$host;port=$port" ,"$username", "password",{ RaiseError => 1, AutoCommit => 0});

Open in new window

0
Comment
Question by:tankergoblin
2 Comments
 
LVL 6

Expert Comment

by:msklizmantas
ID: 23719896
hello,

what data are you passing to $host? looks like script tries to use socket to connect to pg server..

best regards,
m
0
 
LVL 3

Accepted Solution

by:
Rawdust earned 2000 total points
ID: 23722967
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question