Doesn't look to me like the login for WINTOUCH was accepted. I don't see the
User WINTOUCH from client 10.8.2.134 connected to server.
Message that I expect to see on a successful connection.
Is there a security exit in place at this customer? We had a similar problem with a customer who was using a security product to filter all logins. The login attempt shows in QHST, but nothing else shows up, success or failure. The login is basically held like there was a QSYSOPR inquiry message waiting for a reply.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Friday, December 09, 2011 6:15 PM
To: Java Programming on and around the IBM i
Subject: Re: More, Re: Can anybody suggest any reasons why BIRT would be unable to establish a JDBC connection, when running on the same physical box?
Dan Kimmel wrote:
Forgot to mention, connection info goes into the system log. DSPLOG
QHST. You may find more information there.
I have no idea what all of this adds up to, but I don't see any error messages. And if I use QuestView to look at the SQL Views that BIRT accesses, there's plenty of data there.
From QHST:
*SIGNON server job 521265/QUSER/QZSOSIGN processing request for user WINTOUCH User WINTOUCH from client 127.0.0.1 connected to job 522161/QUSER/QZDASOINIT
From the job:
Job: QZDASOINIT User: QUSER Number: 522161
Status of job . . . . . . . . . . . . . . . : ACTIVE
Current user profile . . . . . . . . . . . : QUSER
Job user identity . . . . . . . . . . . . . : QUSER
Set by . . . . . . . . . . . . . . . . . : *DEFAULT
Entered system:
Date . . . . . . . . . . . . . . . . . . : 12/09/11
Time . . . . . . . . . . . . . . . . . . : 13:38:22
Started:
Date . . . . . . . . . . . . . . . . . . : 12/09/11
Time . . . . . . . . . . . . . . . . . . : 13:38:22
Subsystem . . . . . . . . . . . . . . . . . : QUSRWRK
Subsystem pool ID . . . . . . . . . . . . : 1
Type of job . . . . . . . . . . . . . . . . : PJ
Special environment . . . . . . . . . . . . : *NONE
Program return code . . . . . . . . . . . . : 0
Controlled end requested . . . . . . . . . : NO
System . . . . . . . . . . . . . . . . . . : <censored>
Job description . . . . . . . . . . . . . . . . . : QDFTSVR
Library . . . . . . . . . . . . . . . . . . . . : QGPL
ASP device . . . . . . . . . . . . . . . . . . : *SYSBAS
Job queue . . . . . . . . . . . . . . . . . . . . :
Library . . . . . . . . . . . . . . . . . . . . :
ASP device . . . . . . . . . . . . . . . . . . :
Job priority (on job queue) . . . . . . . . . . . : 5
Output priority (on output queue) . . . . . . . . : 5
End severity . . . . . . . . . . . . . . . . . . : 30
Message logging:
Level . . . . . . . . . . . . . . . . . . . . . : 4
Severity . . . . . . . . . . . . . . . . . . . : 0
Text . . . . . . . . . . . . . . . . . . . . . : *NOLIST
Log CL program commands . . . . . . . . . . . . . : *NO
Job log output . . . . . . . . . . . . . . . . . : *PND
Printer device . . . . . . . . . . . . . . . . . : PRTDUMMY
Default output queue . . . . . . . . . . . . . . : *DEV
Library . . . . . . . . . . . . . . . . . . . . :
Job date . . . . . . . . . . . . . . . . . . . . : 12/09/2011
Date format . . . . . . . . . . . . . . . . . . . : *MDY
Date separator . . . . . . . . . . . . . . . . . : /
Time separator . . . . . . . . . . . . . . . . . : :
Job time:
Current date . . . . . . . . . . . . . . . . . : 12/09/2011
Current time . . . . . . . . . . . . . . . . . : 18:04:15
Day of week . . . . . . . . . . . . . . . . . . . : *FRI
Time zone . . . . . . . . . . . . . . . . . . . . : QN0600CST2
Current offset . . . . . . . . . . . . . . . . : -06:00
Full name . . . . . . . . . . . . . . . . . . . : Central
Abbreviated name . . . . . . . . . . . . . . . : CST
Year offset . . . . . . . . . . . . . . . . . . . : 0
Decimal format . . . . . . . . . . . . . . . . . : *BLANK
Job switches . . . . . . . . . . . . . . . . . . : 00000000
Inquiry message reply . . . . . . . . . . . . . . : *RQD
Accounting code . . . . . . . . . . . . . . . . . : CCS
Print text . . . . . . . . . . . . . . . . . . . : '
'
DDM conversation . . . . . . . . . . . . . . . . : *KEEP
Break message handling . . . . . . . . . . . . . : *NORMAL
Status message . . . . . . . . . . . . . . . . . : *NORMAL
Device recovery action . . . . . . . . . . . . . : *MSG
Time slice end pool . . . . . . . . . . . . . . . : *NONE
Print key format . . . . . . . . . . . . . . . . : *PRTHDR
Sort sequence . . . . . . . . . . . . . . . . . . : *HEX
Library . . . . . . . . . . . . . . . . . . . . :
Language identifier . . . . . . . . . . . . . . . : ENU
Country or region identifier . . . . . . . . . . : US
Coded character set identifier . . . . . . . . . : 37
Default coded character set identifier . . . . . : 37
Character identifier control . . . . . . . . . . : *DEVD
Job message queue maximum size . . . . . . . . . : 4
Job message queue full action . . . . . . . . . . : *WRAP
Allow multiple threads . . . . . . . . . . . . . : *NO
Auxiliary storage pool group . . . . . . . . . . : *NONE
Spooled file action . . . . . . . . . . . . . . . : *KEEP
Run priority . . . . . . . . . . . . . . . . . . : 20
Time slice in milliseconds . . . . . . . . . . . : 3000
Eligible for purge . . . . . . . . . . . . . . . : *NO
Default wait time in seconds . . . . . . . . . . : 30
Maximum CPU time in milliseconds . . . . . . . . : *NOMAX
CPU time used . . . . . . . . . . . . . . . . . : 451
Maximum temporary storage in megabytes . . . . . : *NOMAX
Temporary storage used . . . . . . . . . . . . : 11
Maximum threads . . . . . . . . . . . . . . . . . : *NOMAX
Threads . . . . . . . . . . . . . . . . . . . . : 1
Thread resources affinity:
Group . . . . . . . . . . . . . . . . . . . . . : *NOGROUP
Level . . . . . . . . . . . . . . . . . . . . . : *NORMAL
Resources affinity group . . . . . . . . . . . . : *NO
Job 522161/QUSER/QZDASOINIT started on 12/09/11 at 13:38:22 in subsystem
QUSRWRK in QSYS. Job entered system on 12/09/11 at 13:38:22.
ACGDTA for 522161/QUSER/QZDASOINIT not journaled; reason 1.
******************
And the joblog for the Tomcat connection (for good measure):
Java Virtual Machine is IBM Technology for Java. PID(22928) JVM properties were loaded from a properties file.
Public write authority on "< /bin/bootstrap.jar".
Public write authority on "< in/tomcat-juli.jar".
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/java400-l.
midrange.com
