SMTP Authentication

If your SMTP server requires a userid and password in order to send emails which most do these days, you can configure your application server or process scheduler in the smtp section to handle this.

1. Determine what Authentication Username and Password to use that is known to the SMTP Server
2. Update the SMTP Section of Application Server and/or Process Scheduler’s configuration file, psappsrv.cfg and/or psprcs.cfg respectively, with the following variable values;

SMTPUserName = User who can log into SMTP Server, researched in #1 above.
SMTPUserPassword = * Password of the User who can log into SMTP Server, researched in #1 above.

SMTPUserName1 = Repeat value entered for SMTPUserName above.
SMTPUserPassword1 = Repeat value entered for SMTPUserPassword above.

3. Reconfigure the server, and restart.

*PT 8.50/8.51 – password is clear/plain text.
*PT 8.52/8.53 – password is encrypted using the PSCipher utility.

Oracle database 32bit to 64bit

I had a Oracle database built on a new environment, when I noticed that I had installed the 32bit database libraries instead of the 64bit.

So I installed the correct 64bit version of the Oracle database server, and I changed all the pointers to the 64bit version. I was able to start and stop the database without an issue, but when trying to access the database remotely, I got the following error:

ERROR:
ORA-06553: PLS-801: internal error [56327].

I found this solution:

shutdown immediate;
startup upgrade;
@$ORACLE_HOME/rdbms/admin/utlirp;
shutdown immediate;
startup;
@@$ORACLE_HOME/rdbms/admin/utlrp;

PeopleSoft Installer Linux_x86-64 fails

When trying to install the HRCS90 Revision 5 application on a new RHEL Linux x86-64 system I got the following error when running the setup.sh

[psoft@z4sp-ps2 Disk1]# ./setup.sh
Setting temporary directory /tmp/IA.27241
Executing setup.linux -DCOMP_NAME=sp-ps2 -DPS_UMASK=0022
Preparing to install…
Extracting the JRE from the installer archive…
Unpacking the JRE…
Extracting the installation resources from the installer archive…
Configuring the installer for this system’s environment…

Launching installer…

Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX)

Stack Trace:
java.lang.UnsatisfiedLinkError: /tmp/IA.27241/install.dir.27252/Linux/resource/jre/lib/amd64/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

This one seemed odd to me because the PeopleTools 8.53 installs worked fine. I checked the MOS and didn’t find anything that looked right, then I did the obvious and checked to see if the libXtst libraries existed on the server, and there it wasn’t! Installed the RPM and all was good in the world!

yum install libXtst

Rackspace Mount Data Disk

Rackspace now has data disks that need to be mounted in order to be used on the new performance servers. Follow these steps to mount the data drive on RHEL 6.5:

1. fdisk -l
2. mkfs -t ext3 /dev/xvde1
3. mkdir -p /pathtomountdirectory
4. vi /etc/fstab
/dev/xvde1 /u02 ext3 defaults,noatime 0 2
5. mount -a
6. df -h