RE: [WEB400] CGI and SQL

[Justin Houchin <justin@xxxxxxxxxxxx>]

This is kind of odd. I was under the impression that QTMHHTTP profile was
used to access web pages on the IFS and QTMHHTTP1 was the profile used to
execute the CGI programs. Does QTMHHTTP1 have authority to SLS?

Justin Houchin
Programmer and Web Developer
www.reliatek.com
justin@reliatek.com


-----Original Message-----
From: web400-admin@midrange.com [mailto:web400-admin@midrange.com] On Behalf
Of David J. Smith
Sent: Wednesday, December 18, 2002 8:21 PM
To: web400@midrange.com
Subject: [WEB400] CGI and SQL

I recently changed one of my CGI programs to use SQL.  Based on my
change, it quit working!  Damn.

The program runs fine when I run it with my user ID and test it with
debug.  When I run it using CGI (User QTMHHTTP), I get the following
error:

Attempt to use permanent system object QSQRXLTR without authority.
Attempt to use permanent system object QSQRLEX without authority.

I also get a message saying I'm not authorized to the file I'm doing my
SELECT on.

Before: QTMHHTTP was authorized to SLS:

FSLS  IF   E           K DISK    ExtFile(wSLS)
F                                     USROPN

C                  EVAL      wSLS = 'LIBRARY/SLS'
C                  OPEN      SLS

After: QTMHHTTP is not authorized to SLS

C/Exec SQL
C+ SELECT.......FROM LIBRARY.SLS........

Running V5R1. Users have little authority, programs have lots.

David Smith
President
Advanced Information Solutions, Inc.
Email:  dsmith@ais400.com
Phone:  517.548.7170


_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/web400
or email: WEB400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.