PeopleTools Mobile Book

Jim Marion is releasing a new book on writing mobile applications with PeopleTools.

Fluid and MAP have been out for about a year. If you guessed that a new PeopleTools mobile book would cover these mobile technologies, you guessed correctly. But I saw no reason to stop there. After describing how to use Fluid and MAP, the book moves on to building responsive mobile applications using standard HTML5 development tools and libraries including jQuery mobile and AngularJS.

I’m excited for this book. Jim is a great writer and knows PeopleTools inside and out. You can pre-order it now.

File Upload Listening Connector

Javier Delgado has a nice overview of building a custom File Upload Listening Connector for the Integration Broker:

One of my customers recently had the need of allowing a third party web application to attach files into PeopleSoft. After trying a number of different approaches (the integration had to be done at the web application client level, which significantly reduces the options to manipulate the request to PeopleSoft before sending it, particularly when dealing with old web browsers), I gave up and came to the conclusion that I needed a custom listening connector in Integration Broker to implement such integration.

PeopleSoft Instrumented Development Diagnostic Aid (IDDA)

I stumbled across this page about the PeopleSoft IDDA logger in PeopleBooks today. I haven’t seen this tool before, so I wanted to give it a quick test to see how it works. I wanted to know what type of data the IDDA logged and if the data would be useful for troubleshooting issues. After setting it up in a Development environment, I found that the PIA, Portal and Authentication traces would be helpful for sign on or cookie issues.

Enabling IDDA

You enabled the IDDA in a Web Profile Custom Property and by changing the IDDA log settings in on your web server.

Web Profile

Go to your active Profile and add this custom value:

  • Property Name: IDDA
  • Validation Type: Number
  • Property Value: The bit value, or sum of bit values, for the area you want to trace.

If you want to trace the PIA and Report Repository, enter a value of 5.

Bit Value Functional Category
1 PeopleSoft Internet Architecture
2 Integration Broker
4 Report repository
8 Portal
16 Web server caching
32 File processing (attachments)
64 Authentication
128 Performance Monitor
256 Web Services for Remote Portlets (WSRP)
512 Jolt

Save the Web Profile changes.

Logging Properties

Open the file under webserv\domain\piaconfig\properties and change the .LEVEL value. These are the possibles values:

  • OFF: Disables all IDDA logging.
  • SEVERE: Displays server issues, such as premature termination and failure.
  • WARNING: Displays less severe issues, such as configuration issues.
  • INFO: Displays basic operational information, such as starting and stopping.
  • FINE, FINER, FINEST: Displays internal non-critical informational messages.
  • ALL: Enables all logging levels. The default value is INFO.

I tried ALL, FINEST and INFO during my testing. I ended up sticking with FINER since I felt that gave the best detail without too much information.

PeopleBooks has the wrong path documented if you look there. You can find the location of the file by opening setEnv.cmd and looking at the PSLOGGING variable path. Save the changes and reboot your web server.

Viewing IDDA Data

IDDA output will write to webserv\domain\servers\PIA\logs\PIA_servlets.%u.log. The output is plain text so you view it in any text editor. The output is also tab-delimited, so importing the log files into Excel or another log view is easy.


From Kyle Benson: a servlet filter to remove PS_TOKEN from the response cookie:

One option is to simply disable the PS_TOKEN, and therefore prevent this vulnerability altogether! The problem is, PeopleSoft does not give us the option to disable it.

I decided to come up with a proof of concept for a custom solution to this issue. I wrote a Java servlet filter, called PSEatCookies, that will prevent a PS_TOKEN, or any other Cookie you specify, from being added to the ServletHttpResponse.

Download PeopleSoft Images on Windows using WGET

Downloading new PeopleSoft Images (PI) from Oracle Support every few months can get old. Oracle Support has a WGET script that will download the images for you, but it is written for Unix. After seeing this post from Duncan Davis, I copied his script and made few changes. First, I wanted the main script to be reusable. Second, I opted to use an input file so I could easily take the values from the Unix script and paste them into a text file. The input file has one line for each .zip file from the .sh script: the URL and the output filename. Now when I want to download a new image, I grab the Oracle script, copy the URLs and filenames, and then run this command:

wget-batch.bat LM92U009.txt [mosemail] [mospassword]

Install WGET for Windows

This script assumes that you have WGET for Windows installed to


You can download WGET for Windows here.

Getting URLs

You will need to download the script for the PI you want to download. In the script, there will be 10-11 lines toward the bottom that contains the URLs for each .zip file to download. Copy the URLs and output file name to a text file. Separate the two values by a comma (with no space). Here is an example:

The Script

Possible Improvements

  1. Have the script kick off 2-3 downloads at a time
  2. Parse the script instead of manually copying the URLs,Filename to an input file
  3. Eventually migrate this script to Windows.

There is a simpler way to download patches from Oracle Support – check out our post on getMOSPatch.


TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a sortable-grid display, allowing the user to quickly locate system performance issues.

TraceMagic is a great tool for reading .tracesql files. The ability to group SQL by SELECT statements and see all the tables queried in the trace are great for debugging issues.

Limit PeopleSoft Vulnerabilities

Last week a presentation at Hack in the Box, “Oracle PeopleSoft Applications are Under Attack”, focused on vulnerabilities in PeopleSoft applications. The presentation showed a number of ways that hackers could get access to a system. While some of the issues need to be fixed by Oracle (like poor encryption), there are a number of steps you can take to reduce the risk of someone gaining unauthorized access to your system.

For reference, here is the presentation and here is the white paper.

Database Security

The first part of the presentation talks about back-end attacks (gaining access to the database). For someone who is on the internal network, there are a few ways to grab the Access ID.

Access ID Attacks

First, the Connect ID and password are often left to the default people and peop1e. The Connect ID has access to the PSACCESSPRFL table (by design), but the values in PSACCESSPRFL are not securely encrypted. According to the presentation, PeopleSoft uses a simple XOR operation to encrypt the values. XOR encryption is fairly simple to decrypt compared with newer encryption technologies. Update 5/11/2016 I have been informed that this is incorrect. XOR is not used for the Access ID and Password. The encrypt is 3des-168-cfb, which means it requires a 24 byte key, and a 64bit Initialization Vector, which is far harder to decrypt. End update The presentation also mentions that people often choose a Connect ID password that is the same as the Access ID. DO NOT DO THAT! Passwords should be unique and complex (as possible) so that one account doesn’t compromise other accounts.

This attack vector does bring up a concern that Oracle should address in a future PeopleTools release. Starting with 8.53, PSORPDEFN added a OPERPWSDSALT field that increased the complexity of password encryption. This functionality should be extended to the Access ID Password. Additionally, the limitation of an 8 character password for the Access ID password needs to be fixed.

Second, if someone has access to a developer machine there a two ways to grab the Access ID and password. One is to grab the configuration from the Windows Registry and decrypt the password from there. The encryption in the config file appears to be XOR based. The other method is to connect App Designer via 3-Tier connection and grab the network packets because the Tuxedo protocol is a plain text protocol. When developer tools communicate with the application server, their User ID and password are sent with each request. Plain text SQL is also sent via Tuxedo, and also executed under the Access ID, which is another potential issue.

In reality, the second attack requires far more access that most users have because it requires a 3-Tier connection along with App Designer access. It would be good for Oracle to start updating the Tuxedo protocol, but addressing the issues in the first attack would be the top priority. Another way to grab the Connect ID, is to open the psappsrv.cfg or psprcs.cfg files used by the Tuxedo domains. If a user has file server access to the process scheduler (very common for developers), they often times have read access to the process scheduler domain directory. If an administrator does not encrypt the Connect ID password when building the domain, anyone with read access can find the password.

Locking Down Database Access

  • Stop using default passwords
    Change the Connect ID password for your environment. You can even change the Connect ID itself, but changing the password from peop1e is the most important step.
  • Make the Access ID password unique
    While we can only have an 8 character password, make the password unique and complex. Don’t use dictionary words to make it memorable. Passwords need to be secure and complexity helps make them more secure.
  • Encrypt all passwords in config files
    When creating Tuxedo domains (application servers and process schedulers), make sure to encrypt any passwords in the file. The psadmin utility can do this for you when you configure the domain.

Web Security

The second part of the presentation focused on front-end attacks, or attacks through the web server. Front-end attacks are targeted at WebLogic, the PIA and other servlets delivered by PeopleSoft.

WebLogic Security

Attacks When deploying a Single Server PeopleSoft site, the WebLogic console is accessible on the same server & port as the PIA. Using http://server:port/console, anyone can access the WebLogic console login page. The default user and password for the console is system and Passw0rd in newer PeopleTools versions. If you do not change the password, a quick Google search can let anyone into the WebLogic console.

If you create a multi-server site, the Admin server will run on a separate port (or even server). You should still change the default passwords, but external hackers will have to discover the admin server and port before they can attempt an attack. There are two more accounts in WebLogic that can also expose a vulnerability: monitor and operator. These accounts are used for monitoring your WebLogic instance, but they offer enough access to the console that a hacker could install a .war application to run.

Locking Down WebLogic Access

  • Use a complex system password
    When creating a new PIA site, use a complex password for the system account. This account has full access to WebLogic (and subsequently the server file system) so do not use the default password.
  • Disable monitor and operator accounts
    If you are not using these accounts for monitoring, it is best to disable them. No need to have active accounts if they are unused. If you are using the accounts, make sure you change their password. Give these accounts unique passwords too; you don’t want to make them the same as the system account either.
  • Restrict access to the WebLogic console
    This post has an overview on how to limit access to the WebLogic console. If you are using a load balancer or RPS for external access (which is a good idea), you can block the IP address for those devices from the console. To access the console, you can VPN into your network and access the console from inside the network.

Servlet Attacks

Next in the list of web-based attacks are the servlets installed on the web server. There are a number of servlets installed on the web server like PSIGW, xmllink, etc. If you open up your web server directory structure (or through the WebLogic console) you can see the default servlets.

Some servlets handle XML processing (like PSIGW) and are susceptible to XXE (XML External Entity) attacks. XXE vulnerabilities allow for external code to be run on your web server.

Another attack vector (via XXE) is to read config files for passwords stored on your web server, like the file for the PSIGW servlet. Passwords in this file can be encrypted, but the encryption uses the default 3DES key. You can tell this by looking at the beginning of the encrypted password string and seeing {V1.1}.

The last servlet attack mentioned is against the Integration Broker directly. The IB supports remote configuration (e.g, editing the file via the PIA) and with a specially crafted URL an external system could read or overwrite the IB config file. Many organizations don’t change the default password (administrator and password) for the file. This leaves the system vulnerable to an attack.

Locking Down Servlet Security

  • Patch WebLogic and PeopleTools
    The XXE vulnerability was fixed in WebLogic and also in these version of PeopleTools:

    • 8.51.24
    • 8.52.17
    • 8.53.05
  • Generate a new PSCipher key
    Before you encrypt values in the web server config files, run this command on the web server to generate a new key: pscipher -buildkey When you encrypt values on the web server, you’ll see {V1.2} at the beginning of the string. That will tell you that a new (and non-default) key was used to encrypt the password.
  • Give service accounts unique and complex passwords
    For accounts that you assign different parts of the application, like the Node Default User, or SES Callback User, give those accounts unique and complex passwords. (Have you picked up on a theme yet?)
  • Change the password IB Administrator password
    You can change the IB Administrator password by selecting the “Change Password” box under under the Gateway Setup Properties link on the IB Gateways page. You an also edit the gatewayUserProfile.xml file on the web server.

Single Signon Attacks

The last topic of the presentation focused on the Single Signon feature between PeopleSoft systems. PeopleSoft SSO is handled by the PS_TOKEN browser cookie. If a browser session contains a valid PS_TOKEN, and the issuing system is trusted by other PeopleSoft applications, users are considered authenticated and will have access to the application. The PS_TOKEN is generated using these values:

  • User ID
  • Language Code
  • Node Name
  • Date and Time
  • Signature (SHA1 Hash of User ID + Language Code + Node Name + Date and Time + Node Password)

By default, PeopleSoft uses standard node names for HR (PSFT_HR), FS (PSFT_EP) and the other applications. Since all but the Node Password are potentially known ahead of time, the SHA1 Hash can be calculated and compared against a PS_TOKEN to identify the Node Password.

While you could remove the trust from any nodes (PSTRUSTNODES table), that would break many features in the application (like the Report Repository and Single Signon). Removing node trust isn’t a great option.

Another way to get a PS_TOKEN is to open a page where the system automatically logs in as a public user. For example, a landing page or the PeopleSoft “Forgot My Password” page require the Web Profile to have a public user configured. If the public user has lots of security, any knowledge user can navigate into pages inside the application using the PS_TOKEN.

Locking Down SSO Access

  • Use a complex Node password
    Use a complex node password for your Default Local Node, and the other trusted nodes. The longer the password, the more time it will take to calculate the SHA1 hash.
  • Use unique node names for all environments
    Use a different node name for each application across all the environments (Development, Test, etc). For example, use HR92PRD for HR Production, HR92TST for HR Test, etc. Also, make your node passwords different between Dev, Test and Production. This will prevent someone from logging in to your Dev environment and using that valid PS_TOKEN to authenticate into Production.
  • Limit Public user security
    For the Public User on any Web Profiles, ensure they only have access to the fewest Components/WEBLIBS/etc needed to function. A PS_TOKEN generated by the user with limited security will prevent users from gaining unauthorized access to other parts of the application.
  • Implement Node Certificate Security
    Select Certificate for the node authentication method instead of Password. You will need to generate and load certificates for the Gateway URL for each node.
  • Use external authentication
    PeopleSoft can plug into different authentication methods, like LDAP and Kerberos. If you are using an external system for user authentication, you can reduce some of the risk with the PS_TOKEN issue by removing other applications’ nodes from the PSTRUSTNODES table.

GreyHeller has an excellent blog post with more details on the PS_TOKEN vulnerability and they show how their own tools can help with this security risk.

Recommendations for Oracle

With proper configuration, many of the vulnerabilities in this presentation can be properly mitigated. The main theme in the presentation, and in this article, is to not use default, shared or simple passwords.

There are some issues identified in the presentation that are out of our control. Oracle will need to make the changes in PeopleTools to address some of these vulnerabilities. To help bring visibility to the issues, filing a feature request SR with Oracle will show that there is user interest in making the product more secure. Here are three suggested SR’s to file:

  • Access ID Password needs to support complex passwords (more than 8 characters)
    The Access ID has an 8 character limit. To ensure the security of the database and its information, this password should only be limited by the RDBMS platform.
  • PSACCESSPRFL encryption support
    Like PSOPRDEFN, PSACCESSPRFL should support additional/newer encryption options (like using a SALT).
  • PS_TOKEN should generate a more secure hash
    The SHA1 hash used to create the PS_TOKEN signature should be updated to use a newer hashing algorithm, or find a more secure alternative. Utilizing the JSSE libraries on the web server would allow for stronger hashes to be built (albeit with some performance impacts).