Error on Running Perl CGI on Tomcat

2005-05-20 Thread Robert Kerry
I know this has been asked for millions of time, but I searched google
for the entire day but did not get an answer, instead I found millions
of ppl who have the same problem as I am. The problem is simple:
1. The same code runs well on command line
2. When Running on Tomcat, the html file gives such error:
Software error:
Can't connect to MySQL database: Can't create TCP/IP socket (10106)
3. OS is Windows XP
4. I am pretty sure that Tomcat, Perl interpreter, MySQL runs well seperately.

I don't know what to do and since it is a joint question of 3
softwares, I'm gonna
send it to the three maillist and see finally if anybody could give
correct answers to it. Thanks

Regards,
Robert.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Error on Running Perl CGI on Tomcat

2005-05-20 Thread Jason Bainbridge
On 5/20/05, Robert Kerry [EMAIL PROTECTED] wrote:
 I know this has been asked for millions of time, but I searched google
 for the entire day but did not get an answer, instead I found millions
 of ppl who have the same problem as I am. The problem is simple:
 1. The same code runs well on command line
 2. When Running on Tomcat, the html file gives such error:
 Software error:
 Can't connect to MySQL database: Can't create TCP/IP socket (10106)
 3. OS is Windows XP
 4. I am pretty sure that Tomcat, Perl interpreter, MySQL runs well seperately.
 
 I don't know what to do and since it is a joint question of 3
 softwares, I'm gonna
 send it to the three maillist and see finally if anybody could give
 correct answers to it. Thanks

Look at the very bottom post on this page:

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Can_not_connect_to_server.html

I would say at a guess you are running XP SP2 and that just causes
headaches when trying to do anything server related, when you run the
app from the command line you run it as you but I would say your
Tomcat is installed as a service and is running as LocalSystem so it
has trouble opening the port.

You could also try running the Tomcat service as yourself and if that
works create a special Tomcat service account.

Regards.
-- 
Jason Bainbridge
http://kde.org - [EMAIL PROTECTED]
Personal Site - http://jasonbainbridge.com

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]