|
midrange.com
Thanks Matt, this was my last resort. I did search the archives here and
other places (ignite400, etc). I also used the Redbook TechNote Enabling
CGI programs and Net.Data for your IBM iSeries V5R2 HTTP Server (powered by
apache). After I wrote this email, i did get some of the net.data macros
working but not all of them. I have gotten 4 macros working. I get some
errors on others and some of them want to download it instead of display
it. ????
Here is the trace file from one that produces the error:
NET.DATA started using CGI
Using configuration file '/QSYS.LIB/NDSYSRQTST.LIB/INI.FILE/DB2WWW.MBR'
REQUEST_METHOD: GET
CONTENT_TYPE: NULL
CONTENT_LENGTH: 0
PATH_INFO: /zone.mac/home
QUERY_STRING: NULL
HTTP_COOKIE: NULL
CGI_ASCII_CCSID: 819
CGI_EBCDIC_CCSID: 37
CGI_MODE: %%MIXED%%
Searching MACRO_PATH for file '/zone.mac' and found
'/WWW/JKLTEST/HTDOCS/MACRO/
Searching cache for file '/WWW/JKLTEST/HTDOCS/MACRO/zone.mac'
Found file '/WWW/JKLTEST/HTDOCS/MACRO/zone.mac' in cache
Processing file '/WWW/JKLTEST/HTDOCS/MACRO/zone.mac'
NET.DATA will not set HTTP headers
Total bytes in cache is 249573'
Total number of bytes written to output stream is 1450
Total number of bytes written to output stream is 1450
Processing of file '/WWW/JKLTEST/HTDOCS/MACRO/zone.mac' has completed
Emptying entries from GLOBAL symbol table
Number of entries removed from symbol table is 32
Emptying entries from FUNCTION-LIST symbol table
Removing only non-persistent entries from symbol table
Number of entries removed from symbol table is 0
Emptying entries from CYCLE symbol table
Number of entries removed from symbol table is 0
I am guessing the error is the HTTP headers??? Any experience with that??
Here is the trace file for one that the browser wants to download:
NET.DATA started using CGI
Using configuration file '/QSYS.LIB/NDSYSRQTST.LIB/INI.FILE/DB2WWW.MBR'
REQUEST_METHOD: GET
CONTENT_TYPE: NULL
CONTENT_LENGTH: 0
PATH_INFO: /ucc.mac/ucc
QUERY_STRING: NULL
HTTP_COOKIE: NULL
CGI_ASCII_CCSID: 819
CGI_EBCDIC_CCSID: 37
CGI_MODE: %%MIXED%%
Searching MACRO_PATH for file '/ucc.mac' and found
'/WWW/JKLTEST/HTDOCS/MACRO/u
Searching cache for file '/WWW/JKLTEST/HTDOCS/MACRO/ucc.mac'
Found file '/WWW/JKLTEST/HTDOCS/MACRO/ucc.mac' in cache
Processing file '/WWW/JKLTEST/HTDOCS/MACRO/ucc.mac'
NET.DATA will not set HTTP headers
Calling function DTW_GETCOOKIE with 2 parameters
Parameter 1: Type=IN-STRING, Value='msg_text'
Parameter 1: Type=IN-STRING, Value='msg_text'
Parameter 2: Type=INOUT-STRING, Name=msg_text, Value=''
Function call completed with RETURN_CODE=8000 and
DTW_DEFAULT_ERROR_MSG='NET.DA
Searching MESSAGE block for 'RETURN_CODE=8000'
Found an exact MESSAGE block match
MESSAGE block action: CONTINUE
Exiting function DTW_GETCOOKIE
Calling function DTW_SETCOOKIE with 2 parameters
Parameter 1: Type=IN-STRING, Value='msg_text'
Parameter 2: Type=IN-STRING, Value=' '
Function call completed with RETURN_CODE=0
Parameter 1: Type=IN-STRING, Value='msg_text'
Parameter 2: Type=IN-STRING, Value=' '
Searching MESSAGE block for 'RETURN_CODE=0'
No MESSAGE block matches
MESSAGE block action: CONTINUE
Exiting function DTW_SETCOOKIE
Calling function DTW_GETCOOKIE with 2 parameters
Parameter 1: Type=IN-STRING, Value='debtor_name'
Parameter 1: Type=IN-STRING, Value='debtor_name'
Parameter 2: Type=INOUT-STRING, Name=debtor_name, Value=''
Function call completed with RETURN_CODE=8000 and
DTW_DEFAULT_ERROR_MSG='NET.DA
Searching MESSAGE block for 'RETURN_CODE=8000'
Found an exact MESSAGE block match
MESSAGE block action: CONTINUE
Exiting function DTW_GETCOOKIE
Calling function DTW_GETCOOKIE with 2 parameters
Parameter 1: Type=IN-STRING, Value='secured_name'
Parameter 2: Type=INOUT-STRING, Name=secured_name, Value=''
Function call completed with RETURN_CODE=8000 and
DTW_DEFAULT_ERROR_MSG='NET.DA
Searching MESSAGE block for 'RETURN_CODE=8000'
Found an exact MESSAGE block match
MESSAGE block action: CONTINUE
Exiting function DTW_GETCOOKIE
Calling function DTW_GETCOOKIE with 2 parameters
Parameter 1: Type=IN-STRING, Value='doc_id'
Parameter 2: Type=INOUT-STRING, Name=doc_id, Value=''
Function call completed with RETURN_CODE=8000 and
DTW_DEFAULT_ERROR_MSG='NET.DA
Function call completed with RETURN_CODE=8000 and
DTW_DEFAULT_ERROR_MSG='NET.DA
Searching MESSAGE block for 'RETURN_CODE=8000'
Found an exact MESSAGE block match
MESSAGE block action: CONTINUE
Exiting function DTW_GETCOOKIE
Calling function DTW_ASSIGN with 2 parameters
Parameter 1: Type=INOUT-STRING, Name=sql_operand, Value=''
Parameter 2: Type=IN-STRING, Value=''
Function call completed with RETURN_CODE=0
Parameter 1: Type=INOUT-STRING, Name=sql_operand, Value=''
Parameter 2: Type=IN-STRING, Value=''
Searching MESSAGE block for 'RETURN_CODE=0'
No MESSAGE block matches
MESSAGE block action: CONTINUE
Exiting function DTW_ASSIGN
Calling function DTW_ASSIGN with 2 parameters
Parameter 1: Type=INOUT-STRING, Name=sql_operand, Value=''
Parameter 2: Type=IN-STRING, Value=' WHERE '
Function call completed with RETURN_CODE=0
Function call completed with RETURN_CODE=0
Parameter 1: Type=INOUT-STRING, Name=sql_operand, Value=' WHERE '
Parameter 2: Type=IN-STRING, Value=''
Searching MESSAGE block for 'RETURN_CODE=0'
No MESSAGE block matches
MESSAGE block action: CONTINUE
Exiting function DTW_ASSIGN
Calling function DTW_ASSIGN with 2 parameters
Parameter 1: Type=INOUT-STRING, Name=sql_where, Value=''
Parameter 2: Type=IN-STRING, Value=' WHERE ucc_dname = 'ZzZzZzZzZz''
Function call completed with RETURN_CODE=0
Parameter 1: Type=INOUT-STRING, Name=sql_where, Value=' WHERE ucc_dname =
'Zz
Parameter 2: Type=IN-STRING, Value=''
Searching MESSAGE block for 'RETURN_CODE=0'
No MESSAGE block matches
MESSAGE block action: CONTINUE
Exiting function DTW_ASSIGN
Calling function DTW_ASSIGN with 2 parameters
Parameter 1: Type=INOUT-STRING, Name=sql_file, Value=''
Parameter 1: Type=INOUT-STRING, Name=sql_file, Value=''
Parameter 2: Type=IN-STRING, Value='uccmstp'
Function call completed with RETURN_CODE=0
Parameter 1: Type=INOUT-STRING, Name=sql_file, Value='uccmstp'
Parameter 2: Type=IN-STRING, Value=''
Searching MESSAGE block for 'RETURN_CODE=0'
No MESSAGE block matches
MESSAGE block action: CONTINUE
Exiting function DTW_ASSIGN
Calling function select_ucc with 0 parameters
The statements in the inline statement block are:
SELECT ucc_uccid, ucc_docid,
ucc_docdt, ucc_doctm, ucc_ampm,
ucc_dname, ucc_sname, ucc_doctyp
FROM uccmstp WHERE ucc_dname =
= 'ZzZzZzZzZz' ORDER BY ucc_dname
Calling DTW_SQL language environment routine dtw_initialize
Call to DTW_SQL language environment routine dtw_initialize completed
Calling DTW_SQL language environment routine dtw_execute
Any help is great!
Thanks!
Kara
web400-request@mi
drange.com
Sent by: To
web400-bounces@mi web400@xxxxxxxxxxxx
drange.com cc
Subject
03/01/2005 07:45 WEB400 Digest, Vol 3, Issue 54
AM
Please respond to
web400@xxxxxxxxxx
om
------------------------------
message: 4
date: Tue, 1 Mar 2005 08:45:27 -0500
from: "Haas, Matt" <Matt.Haas@xxxxxxxxxxx>
subject: RE: [WEB400] Need help trying to get Net.Data running on
Apache
Kara,
Check the mailing list archives both here and at http://www.ignite400.org.
I know I've posted solutions to both places on several occasions.
Before you give yourself a new hair doo, pick up the book "Professional
Apache 2.0". You can also look at the tutorial at
http://httpd.apache.org/docs-2.0/howto/cgi.html for setting up CGI programs
(Net.Data is a CGI program). The Apache.org documentation is also pretty
good but I felt that the book was easier to get started with. Finally, you
may want to pull down a copy of Apache 2.0 and take a look at it's
httpd.conf. It's full of examples of how to do things and is well
commented.
Matt
-----Original Message-----
From: Kara Burkhalter [mailto:kara.burkhalter@xxxxxxxxx]
Sent: Monday, February 28, 2005 2:39 PM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Need help trying to get Net.Data running on Apache
I have net.data running on our original webserver. I have created a new web
instance powered by apache. I can't seem to get net.data macros to run.
What am I doing wrong??
Right now, I am getting that I am not authorized to the page.
My macros are in the directory WWW/JKLTEST/HTDOCS/MACRO and my includes are
WWW/JKLTEST/HTDOCS/INCLUDE
I have *PUBLIC *RWX on WWW, JKLTEST, HTDOCS, MACRO and INCLUDE folders
Here is my INI file that is located in NDSYSRQ lib:
DTRW_CLOSE_REGISTRIES YES
MACRO_PATH /WWW/JKLTEST/HTDOCS/MACRO
INCLUDE_PATH /WWW/JKLTEST/HTDOCS/INCLUDE;/QSYS.LIB/
EXEC_PATH /QSYS.LIB
DTW_SMTP_SERVER MAILBAG.COM
SHOWSQL YES
DTW_ERROR_LOG_DIR /WWW/JKLTEST/LOGS
DTW_ERROR_LOG_LEVEL ALL
DTW_TRACE_LOG_DIR /WWW/JKLTEST/LOGS
DTW_TRACE_LOG_LEVEL SERVICE
DTW_TRACE_MERGE_RECORDS NO
Here is my Apache server config:
HTTP server: JKLTEST
Selected file:
/www/jkltest/conf/httpd.conf
#
Configuration originally created by Create HTTP Server wizard on
1 Thu Feb 03 17:12:50 UTC
2005
LoadModule
jk_module /QSYS.LIB/QHTTPSVR.LIB/QZTCJK.SRVPGM
2
ScriptAlias
/macro/ /QSYS.LIB/NDSYSRQTST.LIB/DB2WWW.PGM/
3
ScriptAlias
/cgi-bin/db2www/ /QSYS.LIB/NDSYSRQTST.LIB/DB2WWW.PGM/
4
ScriptAlias
/CGI-BIN/DB2WWW/ /QSYS.LIB/NDSYSRQTST.LIB/DB2WWW.PGM/
5
ScriptAlias
/MACRO/ /QSYS.LIB/NDSYSRQTST.LIB/DB2WWW.PGM/
6
ScriptAlias
/cgibin/ /QSYS.LIB/NDSYSRQTST.LIB/
7
Alias
/images/* /www/jkltest/htdocs/images/*
8
Alias
/IMAGES/* /www/jkltest/htdocs/images/*
9
Listen
192.168.0.3:8305
10
DocumentRoot
/www/jkltest/htdocs
11
Options
-ExecCGI -FollowSymLinks -SymLinksIfOwnerMatch -Includes
12 -IncludesNoExec -Indexes
-MultiViews
LogFormat
"%h %l %u %t \"%r\" %>s %b \"%{Referer}i\"
13 \"%{User-Agent}i\""
combined
LogFormat
"%{Cookie}n \"%r\" %t" cookie
14
LogFormat
"%{User-agent}i" agent
15
LogFormat
"%{Referer}i -> %U" referer
16
LogFormat
"%h %l %u %t \"%r\" %>s %b" common
17
CustomLog
logs/access_log combined
18
LogMaint
logs/access_log 7 0
19
LogMaint
logs/error_log 7 0
20
HotBackup
Off
21
SetEnvIf
"User-Agent" "Mozilla/2" nokeepalive
22
SetEnvIf
"User-Agent" "JDK/1\.0" force-response-1.0
23
SetEnvIf
"User-Agent" "Java/1\.0" force-response-1.0
24
SetEnvIf
"User-Agent" "RealPlayer 4\.0" force-response-1.0
25
SetEnvIf
"User-Agent" "MSIE 4\.0b2;" nokeepalive
26
SetEnvIf
"User-Agent" "MSIE 4\.0b2;" force-response-1.0
27
JkWorkersFile
/www/jkltest/conf/workers.properties
28
JkLogFile
/www/jkltest/logs/jk.log
29
JkLogLevel
Error
30
JkMount
/app1/* inprocess
31
JkMount
/servlet/* inprocess
32
DirectoryIndex
index.html index.htm
33
<Directory
/>
34
Order Deny,Allow
35
Allow From all
36
</Directory>
37
<Directory
/www/jkltest/htdocs>
38
Order Allow,Deny
39
Allow From all
40
Options +ExecCGI
41
</Directory>
42
<Directory
/QSYS.LIB/NDSYSRQTST.LIB/>
43
Order Allow,Deny
44
Allow From all
45
Options +ExecCGI
46
</Directory>
47
I am about ready to pull my hair out, I have been working on this for a
week now. Any help would be greatly appreciated!!
Thanks
Kara
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.
------------------------------
--
This is the Web Enabling the AS400 / iSeries (WEB400) digest list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.
End of WEB400 Digest, Vol 3, Issue 54
*************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
