DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDB2 Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
  #1  
Old February 28th, 2007, 04:19 PM
Donboy's Avatar
Donboy Donboy is offline
The Evil Monkey
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Posts: 220 Donboy User rank is Private First Class (20 - 50 Reputation Level)Donboy User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 38 m 10 sec
Reputation Power: 6
Connecting perl/apache to db2

I've had apache and perl installed and running successfully for a while. I have successfully run perl scripts in apache and that is working fine. Now I want to connect my perl script to a db2 database on a remote machine. I don't know if its important or not, but I am running apache with suexec so it runs as the user "web" for my particular virtualhost.

I have installed the db2 client software. I have created a perl script that will test my connection to db2. I have added my db2 database information to the local catalog.

I have run my perl script at the command line and it connects to the db2 database and returns information that I know is stored in the database. Now the final step is getting my script to run in the browser. Running the same script in the browser gives me the following in my error logs...

[Wed Feb 28 15:08:20 2007] [error] [client 192.163.11.167] DBI connect('UDBTEST','user',...) failed: Total Environment allocation failure! Did you set up your DB2 client environment? at /home/web/www/pacmantest.pl line 6
[Wed Feb 28 15:08:20 2007] [error] [client 192.163.11.167] Couldn't connect to database: Total Environment allocation failure! Did you set up your DB2 client environment? at /home/web/www/pacmantest.pl line 6.
[Wed Feb 28 15:08:20 2007] [error] [client 192.163.11.167] Premature end of script headers: pacmantest.pl

I believe this error is trying to tell me that it cannot find the db2 client.

I have also tried disabling suexec (by commenting out the line beginning with SuexecUserGroup in my config file.) The error log still reports the same error.

I feel like I'm really close here. Can someone help me cross the last hurdle?

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDB2 Development > Connecting perl/apache to db2


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway