Errors on running Perl CGI scripts on Tomcat

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 seperate=
ly.

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.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Errors on running Perl CGI scripts on Tomcat

I don't know how to really solve your problem, after a while searching
couldn't find anything (just like you), but since I'm not sitting at
your machine to test, I can tell you, it could be a MySQL problem if a
bad GRANT section was used, run mysql at command line, using the same
user perl uses and do a 'show grants;', check if you are granted
permissions to access from anywere, that would look like:

GRANT SELECT ON `test`.* TO 'usert'@'%'

Pay attention to the part after the '@' signal!!! '%' is a wildcard,
meaning any host. If its not set as %, set it!!! This way you can be
sure there are no GRANTs problems (althought I doubt this because you
would get an error from the MySQL Server, something like "couldn't
connect from").

I sincerely believe its more of a web server problem! Maybe lack of a modul=
e?!

On 5/20/05, Robert Kerry 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 sepera=
tely.
>=20
> 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
>=20
> Regards,
> Robert.
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Errors on running Perl CGI scripts on Tomcat

Sounds like apermissions issue.
Can you caonnect to the MySQL server via localhost?
Post your connect line so we can have a look at it, it might give us a clue.

----- Original Message -----
From: "Robert Kerry"
To:
Sent: Saturday, May 21, 2005 6:49 AM
Subject: Errors on running Perl CGI scripts on Tomcat


> 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.
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless.c om.au
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org