DBI Connect Failure to MySQL under Win32 with Tomcat 4.1

Robert Berman <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
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/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.