The latest version of the README.win32.txt for DBD.Oracle has a faily
detailed tutorial on how to compile a DBD modual on windows.
http://svn.perl.org/modules/dbd-oracle/trunk/README.win32.txt
It is for DBD:Oracle but is should work much the same for DBI::Mysql
Sorry for the OT response but I couldn't let this go.
Anna K's fame has faded?? She still has a few fans :)
Ron, if you have any influence at the Australian Open, next year
try to get them to sign a tv contract with ABC, NBC, or CBS - instead
of ESPN2 which I don't get. Thanks.
Hardy Merrill
Dear Lois,
thank you for your help.
And sorry for forgotten my pg_hba.conf, that is really important.
Here it comes:
# Database administrative login by UNIX sockets
local all postgres ident sameuser
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
I tried this:
my $dbh = DBI-connect (DBI:Pg:dbname=test2, *host=localhost )
and got this:
Name main::host used only once: possible typo at ./postgre_test_1.pl line
9.
DBI connect('dbname=test2','*main::localhost',...) failed: konnte nicht mit
demServer verbinden: øÿø·xü·
Läuft der Server
what command are you using to start up postgreSQL?
Oh yes, this is an entry-script in init.d:
#!/bin/bash
. /usr/share/postgresql-common/init.d-functions
VERSION=8.1
case $1 in
start)
start $VERSION
;;
stop)
stop $VERSION
;;
restart)
I tried this:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=127.0.01;port=5432,
postgres) or die $DBI:errstr;
test2 is the name of the database.
and got this:
Global symbol $DBI requires explicit package name at ./postgre_test_1.pl
line12.
syntax error at ./postgre_test_1.pl line 12, near
I'm not being wise here, but did you do
use DBI;
at the top of your script?
Hardy Merrill
Christian Stalp [EMAIL PROTECTED] 1/23/2006 11:57 AM
I tried this:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=127.0.01;port=5432,
postgres) or die $DBI:errstr;
test2 is the name of the
Christian Stalp wrote:
I tried this:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=127.0.01;port=5432,
postgres) or die $DBI:errstr;
test2 is the name of the database.
and got this:
Global symbol $DBI requires explicit package name at ./postgre_test_1.pl
line12.
syntax error at
Christian Stalp [mailto:[EMAIL PROTECTED] wrote:
I tried this:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=127.0.01;port=5432,
postgres) or die $DBI:errstr;
^^^
$DBI::errstr, not $DBI:errstr. Note how the error messages call your
attention to this error:
Ronald J Kimball wrote:
Christian Stalp [mailto:[EMAIL PROTECTED] wrote:
I tried this:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=127.0.01;port=5432,
postgres) or die $DBI:errstr;
^^^
$DBI::errstr, not $DBI:errstr. Note how the error messages call
The whole script:
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
#my $dbh = DBI-connect (DBI:Pg:dbname=test2, postgres, sonderbar)
#my $dbh = DBI-connect (DBI:Pg:dbname=test2, *host=localhost )
# or die Keine Verbindung mit der DB!\n;
my $dbh =
Christian Stalp wrote:
The whole script:
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
#my $dbh = DBI-connect (DBI:Pg:dbname=test2, postgres, sonderbar)
#my $dbh = DBI-connect (DBI:Pg:dbname=test2, *host=localhost )
# or die Keine Verbindung mit der DB!\n;
my $dbh =
Christian,
what is the result of this:
netstat -an | grep 5432
nothing ;-) The server does not here on the net. But with pure DBI, can i
do it without IP? For the first connection I mean? I mean with an
UNIX-Socket or however DBI connects to a local server?
Gruss Christian
--
Have you got
tcpip_socket = true
in postgresql.conf?
Yea, exactly. This is funny. I allready tried this. See:
venus:/home/chris# pg_ctlcluster 8.1 main restart
The PostgreSQL server failed to start. Please check the log output:
FATAL: unbekannter Konfigurationsparameter »tcpip_connections«
Christian Stalp wrote:
Christian,
what is the result of this:
netstat -an | grep 5432
nothing ;-) The server does not here on the net. But with pure DBI, can i
do it without IP? For the first connection I mean? I mean with an
UNIX-Socket or however DBI connects to a local server?
Gruss
Christian Stalp wrote:
Christian,
what is the result of this:
netstat -an | grep 5432
nothing ;-) The server does not here on the net. But with pure DBI, can i
do it without IP? For the first connection I mean? I mean with an
UNIX-Socket or however DBI connects to a local server?
Gruss
Christian,
THIS WILL WORK:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=/tmp;port=5432,
postgres, ) or die $DBI:errstr;
Hello Lois,
I have to check my PostgreSQL-Server first. Now as it seems I have not only
a pure server but a cluster. And this means some changes in configuration. I
don't know if I have time today to solfe this. But I give you answer when Im
finished.
Thank you so far, until tomorrow.
Gruss
Jeff,
OK here is the output of perl Makefile.PL.
Thanks again for your help.
Mark.
On Fri, 20 Jan 2006 21:47:47 -0500, Jeff Urlwin [EMAIL PROTECTED]
wrote:
Can you please re-send the output of Makefile.PL?
Jeff
-Original Message-
From: Mark Nettleingham [mailto:[EMAIL
From DBI's pod:
This only works for methods which return a single value
and is hard to make reliable (avoiding infinite loops,
for example) and so isn't recommended for general use!
If you find a good use for it then please let me know.
The use of it would be returning a
Christian Stalp wrote:
Have you got
tcpip_socket = true
in postgresql.conf?
Yea, exactly. This is funny. I allready tried this. See:
venus:/home/chris# pg_ctlcluster 8.1 main restart
The PostgreSQL server failed to start. Please check the log output:
FATAL: unbekannter
On Mon, 23 Jan 2006 07:52:05 -0500, Hardy Merrill wrote:
Hi Hardy
Anna K's fame has faded?? She still has a few fans :)
Interest in her physical side of her database remains strong.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 24/01/2006
http://savage.net.au/index.html
Let the record show:
On Mon, Jan 23, 2006 at 02:37:24PM -0500, Steven Lembark wrote:
From DBI's pod:
This only works for methods which return a single value
and is hard to make reliable (avoiding infinite loops,
for example) and so isn't recommended for general use!
If you find a good use for
23 matches
Mail list logo