perl with mysql problem
am 22.09.2003 18:37:44 von mark
Hi,
Anyone have a solution to this problem. Using following code:
#!E:\Perl\bin\perl.exe
print "Content-type: text/html\n\n";
use strict;
use DBI();
print "
Waitingroomsite";
print "";
print "|
FACE=\"Helvetica,Verdana,Arial\"> | ";
print " |
";
print "list of mysql databases:";
my $dbh =
DBI->connect("DBI:mysql:database=waitingroom;host=138.68.26. 210:3306",
"administrator", "admin",
{'RaiseError' => 1});
print "
";
print " | ";
print " | ";
print "
";
print "
";
getting error:
cgi: runCGI (stderr):DBI
connect('database=waitingroom;host=138.68.26.210:3306','admi nistrator',...)
failed: Can't create TCP/IP socket (10106) at
C:\jakarta-tomcat-4.1.24\webapps\pds\WEB-INF\cgi\example.pl line 39
I'm wondering about a number of things:
don't tcp/ip require porting code; io:socket code
Is it easier like a configuration issue . i.e. configuring my.ini.
Any help is much appreciated.
************************************************************ **********
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
Allied Irish Banks
************************************************************ **********
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
Re: perl with mysql problem
am 22.09.2003 21:53:43 von Carl Holm
mark wrote:
>Hi,
>Anyone have a solution to this problem. Using following code:
>#!E:\Perl\bin\perl.exe
>
>print "Content-type: text/html\n\n";
> use strict;
> use DBI();
>
> print "
Waitingroomsite";
> print "";
> print "|
>FACE=\"Helvetica,Verdana,Arial\"> | ";
> print " |
";
> print "list of mysql databases:";
>
> my $dbh =
>DBI->connect("DBI:mysql:database=waitingroom;host=138.68.26 .210:3306",
> "administrator", "admin",
> {'RaiseError' => 1});
>
>print "
";
>print " | ";
>print " | ";
>print "
";
>print "
";
>
>getting error:
>cgi: runCGI (stderr):DBI
>connect('database=waitingroom;host=138.68.26.210:3306','adm inistrator',...)
>failed: Can't create TCP/IP socket (10106) at
>C:\jakarta-tomcat-4.1.24\webapps\pds\WEB-INF\cgi\example.pl line 39
>
>I'm wondering about a number of things:
>don't tcp/ip require porting code; io:socket code
>Is it easier like a configuration issue . i.e. configuring my.ini.
>Any help is much appreciated.
>
>
>
>*********************************************************** ***********
>This document is strictly confidential and is intended for use by
> the addressee unless otherwise indicated.
>Allied Irish Banks
>*********************************************************** ***********
>
>
>
>
Did you try running your connect string outside of tomcat - with Apache
or another cgi enabled web server?
- Carl Holm
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
Re: perl with mysql problem
am 22.09.2003 21:53:43 von Carl Holm
mark wrote:
>Hi,
>Anyone have a solution to this problem. Using following code:
>#!E:\Perl\bin\perl.exe
>
>print "Content-type: text/html\n\n";
> use strict;
> use DBI();
>
> print "
Waitingroomsite";
> print "";
> print "|
>FACE=\"Helvetica,Verdana,Arial\"> | ";
> print " |
";
> print "list of mysql databases:";
>
> my $dbh =
>DBI->connect("DBI:mysql:database=waitingroom;host=138.68.26 .210:3306",
> "administrator", "admin",
> {'RaiseError' => 1});
>
>print "
";
>print " | ";
>print " | ";
>print "
";
>print "
";
>
>getting error:
>cgi: runCGI (stderr):DBI
>connect('database=waitingroom;host=138.68.26.210:3306','adm inistrator',...)
>failed: Can't create TCP/IP socket (10106) at
>C:\jakarta-tomcat-4.1.24\webapps\pds\WEB-INF\cgi\example.pl line 39
>
>I'm wondering about a number of things:
>don't tcp/ip require porting code; io:socket code
>Is it easier like a configuration issue . i.e. configuring my.ini.
>Any help is much appreciated.
>
>
>
>*********************************************************** ***********
>This document is strictly confidential and is intended for use by
> the addressee unless otherwise indicated.
>Allied Irish Banks
>*********************************************************** ***********
>
>
>
>
Did you try running your connect string outside of tomcat - with Apache
or another cgi enabled web server?
- Carl Holm
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org