On Fri, 31 Jul 2004, Igor Pechtchanski wrote:
>> [david] I have a snippet of perl code that runs fine at the bash prompt but fails >> when run under apache as a cgi app. Hello Igor and David I have had also the same problem one month ago and I was unable to solve it and ended using the windows IIS. I guess that David is using mysql (port 3306 by default). In my case (and probably david if he is using mysql) the problem is not the apache itself. My apache works ok and the cgi also. ONLY fails trying to connect to the mysql. My scripts run ok outside the apache but fail inside the cygwin apache (in my unix machines run ok). I am using the cygwin mysql client with the w32 mysql server. The same happens if I am using the w32 apache using the cygwin perl->cygwin mysql client. ERROR: ------------- EXCEPTION ------------- MSG: Could not connect to database xx user yy using [DBI:mysql:database=xx;host=127.0.0.1;port=3306] as a locator ** Can't create TCP/IP socket (1) ** -------------------------------------- >At a guess, you're getting this because Apache runs as a service (i.e., >the user, "nobody" by default, may not have enough rights). > Igor >-- > In my case, I am NOT running httpd as as service. It has been started from a shell login as windows admin user. From ps, the httpd is running with my user UID I would apreciate if someone could point me out where I could found useful info to try to solve this problem. should I have to add mysql and apache usr and group to my password and group files as in unix? Apart of the cygwin utilities section in the user guide, someone knows where can i learn more about setting privilegies in cygwin in order to run services in a safe mode (or at least not quite unsafe). regards. ------- versions: perl 5.8.2-1 apache 1.3.29-2 mysql Ver 12.22 Distrib 4.0.20, for pc-cygwin (i686) Server version: 4.0.20a-debug 653k 2004/05/17 c:\mysql\bin\cygwinb19.dll - os=4.0 img=1.0 sys=4.0 "cygwinb19.dll" v0.0 ts=1998/7/15 18:50 $ uname -a CYGWIN_NT-5.1 argyrodes 1.5.10(0.116/4/2) 2004-05-25 22:07 i686 unknown unknown Cygwin . / __ \ / __ \ \ | ///\\\ | / \ | ///\\\ | / \ \_((####))_/ / \ \_((####))_/ / \__ ((##)) __/ \__ ((##)) __/ / |||| \ / |||| \ / | oo | \ / | oo | \ | | !! | | | | !! | | \ / \\|// \ / (o o) . .-. .-. .-. .-. .-. .-oOOo~(_)~oOOo-. .-. .-. .-. .-. |X|||\ /|||X|||\ /|||X|||\ /|||X|||\ /|||X|||\ /|||X|||\ /|||X|||\ / \|||X|||/ \|||X|||/ \|||X|||/ \|||X|||/ \|||X|||/ \|||X|||/ \||| `-' `-' `-' `-' `-' `-' `-' `-' `-' `-' `-' `-' `-' -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/