Re: Need help getting DBI to work under mod_perl

2005-02-07 Thread Boysenberry Payne
So I decided much to my chagrin to reinstall all of my DAMP system. I was able to get apache installed, without being able to start it, as a DSO using the layout=GNU and -enable-shared=max configure options. I probably need to be more selective but, I'll rebuild it once I get it working. The

Re: Need help getting DBI to work under mod_perl

2005-02-06 Thread Tom Schindl
Give it a try and add the hostname you are connecting to to the DSN. Tom Boysenberry Payne wrote: I'm able to run DBI-connect() fine when I run my .pl and .pm scripts as mod_cgi. Once I set up my httpd.conf and startup.pl files it no longer works. I get the following: Can't connect to MySQL

Re: Need help getting DBI to work under mod_perl

2005-02-06 Thread jonathan vanasco
On Feb 6, 2005, at 1:09 AM, Boysenberry Payne wrote: I running Mac OS X darwin, and get everything as showing correctly in the %ENV. my $dsn = DBI:mysql:database=test; my $test_db = eval{ DBI-connect( $dsn, ..., ..., { RaiseError = 1, PrintError = 1, AutoCommit = 1 } ) }; first off, i'd double

Re: Need help getting DBI to work under mod_perl

2005-02-06 Thread Jay Scherrer
It's trying to connect to port 49. By default MySQL listens to 3606. Somewhere it was changed. Jay Scherrer On Sunday 06 February 2005 06:24 am, Tom Schindl wrote: Give it a try and add the hostname you are connecting to to the DSN. Tom Boysenberry Payne wrote: I'm able to run

Re: Need help getting DBI to work under mod_perl

2005-02-06 Thread Boysenberry Payne
It's localhost, and I did. I'm developing on a local environment. On Feb 6, 2005, at 8:24 AM, Tom Schindl wrote: Give it a try and add the hostname you are connecting to to the DSN. Tom Boysenberry Payne wrote: I'm able to run DBI-connect() fine when I run my .pl and .pm scripts as mod_cgi. Once

Re: Need help getting DBI to work under mod_perl

2005-02-06 Thread Boysenberry Payne
I think I figured out what's wrong, but I don't know how to correct it. After reading a web-blog that said to rename any fink created conflicting directories namely /sw/lib/mysql or /sw/lib/perl5 I tried it. Nothing worked afterwords. So, I'm guessing I have conflicting modules being used. Try

Need help getting DBI to work under mod_perl

2005-02-05 Thread Boysenberry Payne
I'm able to run DBI->connect() fine when I run my .pl and .pm scripts as mod_cgi. Once I set up my httpd.conf and startup.pl files it no longer works. I get the following: Can't connect to MySQL server on 'localhost' (49) I can't find what (49) means anywhere... I've included my code below,

Re: Need help getting DBI to work under mod_perl

2005-02-05 Thread Boysenberry Payne
I surrounded the DBI-connect with an eval{} or confess() and got the following: Bad at /Users/WebRoot/perl/updater.pl line 19 Apache::ROOT::perl::updater_2epl::handler('Apache=SCALAR(0x8c7c10)') called at /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Apache/ Registry.pm line 143