× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.