DBI Connect Failure to MySQL under Win32 with Tomcat 4.1

DBI Connect Failure to MySQL under Win32 with Tomcat 4.1

am 19.11.2004 16:01:00 von Robert Berman

I am trying to run a perl script that connects to MySQL on a Win XP box
running Tomcat 4.1.31. When the script runs, it fails to compile the DBI
connect statement:

$dbh = DBI->connect("dbi:mysql:dbname=$options{Database}",
$options{user}, '');

The error that tomcat logs is:

2004-11-18 00:03:32 cgi: findCGI calc: name=agg_fetch_xml.pcgi,
path=C:\Program Files\Apache Group\Tomcat
4.1\webapps\ROOT\WEB-INF\cgi\ai-cgitest\agg_fetch_xml.pcgi,
scriptname=/cgi-bin\ai-cgitest\agg_fetch_xml.pcgi,
cginame=\ai-cgitest\agg_fetch_xml.pcgi

2004-11-18 00:03:32 cgi: runCGI(envp=[{HTTP_USER_AGENT=Mozilla/5.0,
REQUEST_METHOD=HEAD, AUTH_TYPE=, HTTP_TIMEOUT=60,
SERVER_NAME=172.22.10.66, SERVER_SOFTWARE=TOMCAT,
HTTP_HOST=172.22.10.66, GATEWAY_INTERFACE=CGI/1.1,
X_TOMCAT_SCRIPT_PATH=C:\Program Files\Apache Group\Tomcat
4.1\webapps\ROOT\WEB-INF\cgi\ai-cgitest\agg_fetch_xml.pcgi,
REMOTE_ADDR=172.22.5.24, SERVER_PROTOCOL=HTTP/1.1, PATH_INFO=,
REMOTE_HOST=homer.reboot.loran.com, QUERY_STRING=type=checkconnection,
HTTP_CONNECTION=close, SERVER_PORT=80, CONTENT_TYPE=, CONTENT_LENGTH=,
SCRIPT_NAME=/cgi-bin\ai-cgitest\agg_fetch_xml.pcgi, REMOTE_USER=,
REMOTE_IDENT=}], command=C:\Program Files\Apache Group\Tomcat
4.1\webapps\ROOT\WEB-INF\cgi\ai-cgitest\agg_fetch_xml.pcgi)

2004-11-18 00:03:34 cgi: runCGI (stderr):DBI
connect('dbname=Rulebase','www',...) failed: Can't create TCP/IP socket
(10106) at C:/kinnetics/component/perllib/site_perl/Kinnetics/SQL.pm line 66

2004-11-18 00:03:34 cgi: runCGI (stderr):Connect failed (attempt 1):
Can't create TCP/IP socket (10106)

The script agg_fetch_xml.pcgi compiles fine manually. I tried using the
pure perl mysql driver "mysqlPP" with similar results. All mysql
connects are to the local host.

Anyone have any ideas?

Robert Berman

--
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