This is a continuation of my virtual PeopleSoft installation. In this step, we will discuss how to install the Application into the PS Home. This is necessary for the client programs. To see the complete list of steps, click here.
Step By Step Virtual PS Install: Windows PS Home Install
This is a continuation of my virtual PeopleSoft installation. In this step, we will discuss how to install a Windows version of the PeopleSoft home. This is necessary for the client programs. To see the complete list of steps, click here.
Step By Step: Connecting the Windows Client
This is a continuation of my virtual PeopleSoft installation. To see the complete list of steps, click here.
This is more just documentation to document the settings that allow connecting a Windows virtual machine to the database to load the PS database.
Step by Step: Yum + Samba
I had trouble getting several things to work, and configuring yum would make it much, much easier. So, I found this article and figured it was time to give it a try.
All of this is done in the terminal window, and so, I will go skimpy on the screenshots for this post.
Uninstalling Yum
The article mentions removing yum. This made me a little worried, but I exported it nonetheless.
The following command will display the yum installed packages:
[pshr@hrdmosys ~]$ rpm -qa | grep yum
yum-metadata-parser-1.1.2-2.el5
yum-3.2.8-9.el5
yum-updatesd-0.9-2.el5
yum-security-1.1.10-9.el5
Removing yum makes me wary, and so, I ran a test uninstall first and found that it was not as simple as removing just yum. Several other packages depend on yum.
[pshr@hrdmosys ~]$ rpm -e --test `rpm -qa | grep yum`
error: Failed dependencies:
yum-metadata-parser is needed by (installed) createrepo-0.4.11-3.el5.noarch
yum >= 3.2.5-2 is needed by (installed) pirut-1.3.28-13.0.1.el5.noarch
yum is needed by (installed) system-config-kickstart-2.6.19.6-1.0.1.el5.noarch
yum >= 2.9.2 is needed by (installed) anaconda-11.1.2.113-1.0.1.i386
Then, I noticed that the yum version in the CentOS repository is the same version as what I have installed. So, I decided to skip the uninstall and reinstall process.
Creating the Repository
sudo vi /etc/yum.repos.d/CentOS-Base.repo
or
sudo gedit /etc/yum.repos.d/CentOS-Base.repo
Place this in the file:
[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos-5
priority=1
protect=1
enabled=1
[update]
name=CentOS-$releasever – Updates
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos-5
priority=1
protect=1
enabled=1
[addons]
name=CentOS-$releasever – Addons
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=addons
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos-5
priority=1
protect=1
enabled=1
[extras]
name=CentOS-$releasever – Extras
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos-5
priority=1
protect=1
enabled=1
[centosplus]
name=CentOS-$releasever – Plus
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
gpgcheck=1
enabled=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos-5
priority=2
protect=1
Now, here is the Repository List:
[pshr@hrdmosys ~]$ yum repolist
Loading "security" plugin
repo id repo name status
addons CentOS-5 - Addons enabled
base CentOS-5 - Base enabled
centosplus CentOS-5 - Plus enabled
extras CentOS-5 - Extras enabled
update CentOS-5 - Updates enabled
Then, update with
sudo yum update
Enterprise-Release issue
When I did the yum update I got this issue:
Error: Missing Dependency: enterprise-release is needed by package up2date
I did a few queries to find out more about the enterprise-release package:
[pshr@hrdmosys ~]$ rpm -q --whatrequires enterprise-release
up2date-5.10.1-41.8.el5
[pshr@hrdmosys ~]$ rpm -q --whatprovides enterprise-release
enterprise-release-5-0.0.9
[pshr@hrdmosys ~]$ man rpm
[pshr@hrdmosys ~]$ rpm -q --whatprovides enterprise-release --provides
config(enterprise-release) = 6:5-0.0.9
redhat-release
enterprise-release = 6:5-0.0.9
[pshr@hrdmosys ~]$ rpm -q --whatprovides enterprise-release --requires
/bin/sh
config(enterprise-release) = 6:5-0.0.9
rpmlib(CompressedFileNames) <= 3.0.4-1
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
I also checked on the up2date package. Here is what it provides:
[pshr@hrdmosys ~]$ rpm -q --whatprovides up2date --provides
config(up2date) = 5.10.1-41.8.el5
dmimodule.so
up2date = 5.10.1-41.8.el5
Here is what it requires:
[pshr@hrdmosys ~]$ rpm -q --whatprovides up2date --requires
/bin/bash
/bin/sh
/bin/sh
/bin/sh
/bin/sh
/bin/sh
/sbin/chkconfig
/usr/bin/env
/usr/bin/python
anaconda
anaconda-runtime
config(up2date) = 5.10.1-41.8.el5
e2fsprogs
enterprise-release
gnupg
libc.so.6
libc.so.6(GLIBC_2.0)
libc.so.6(GLIBC_2.1)
libc.so.6(GLIBC_2.1.3)
libxml2-python
mkinitrd >= 3.2.2
newt
oracle-logos
perl
pirut
policycoreutils >= 1.18.1-4.9
python >= 2.2.2
python(abi) = 2.4
python-optik
rhnlib >= 1.8.7
rhpl >= 0.194.1-1.0.1
rpm >= 4.2.3-24_nonptl
rpm-python
rpmlib(CompressedFileNames) <= 3.0.4-1
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
rtld(GNU_HASH)
sh-utils
system-config-kickstart
I don’t know what the solution is here. If you have any ideas, please let me know.
Installing Samba
Here is what the repository contains:
[pshr@hrdmosys ~]$ yum list | grep -i smb
gnome-vfs2-smb.i386 2.16.2-4.el5 installed
pam_smb.i386 1.1.7-7.2.1 installed
[pshr@hrdmosys ~]$ yum list | grep -i samba
samba-client.i386 3.0.28-0.el5.8 installed
samba-common.i386 3.0.28-0.el5.8 installed
samba.i386 3.0.28-1.el5_2.1 update
samba-client.i386 3.0.28-1.el5_2.1 update
samba-common.i386 3.0.28-1.el5_2.1 update
samba-swat.i386 3.0.28-1.el5_2.1 update
sblim-cmpi-samba.i386 0.5.2-31.el5 base
sblim-cmpi-samba-devel.i386 1-31.el5 base
sblim-cmpi-samba-test.i386 1-31.el5 base
system-config-samba.noarch 1.2.39-1.el5 base
Then, I installed the graphical configuration tool to make this easier.
sudo yum install system-config-samba
This installed the other programs as well:
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
system-config-samba noarch 1.2.39-1.el5 base 263 k
Updating:
samba-common i386 3.0.28-1.el5_2.1 update 8.7 M
Installing for dependencies:
samba i386 3.0.28-1.el5_2.1 update 16 M
Updating for dependencies:
samba-client i386 3.0.28-1.el5_2.1 update 4.9 M
Transaction Summary
=============================================================================
Install 2 Package(s)
Update 2 Package(s)
Remove 0 Package(s)
I did get this error message:
GPG key retrieval failed: [Errno 14] HTTP Error 404: Not Found
I didn’t take the time to troubleshoot it. I just wanted it installed, and so, I used the command
sudo yum install system-config-samba --nogpgcheck
Now, I can use the command system-config-samba to configure samba. Also, I can start the samba services with:
sudo /sbin/service smb start
Resources
PSPNLFIELD.FIELDTYPE
Update: These are the list of fields types in the PSPNLFIELD table.
This is a list of the Panel Field types:
- 0: Text
- 1: Frame
- 2: Group Box
- 3: Static Image
- 4: Edit Box
- 5: Drop Down List
- 6: Long Edit Box
- 7: Check Box
- 8: Radio Button
- 9: Image
- 10: Scroll Bar
- 11: Subpage
- 12: Push Btn/Link — PeopleCode (Thanks Robert)
- 13: Push Btn/Link — Scroll Action
- 14: Push Btn/Link — Toolbar Action
- 15: Push Btn/Link — External Link
- 16: Push Btn/Link — Internal Link
- 17: Push Btn/Link — Process
- 18: SecPage
- 19: Grid
- 20: Tree
- 21: Push Btn/Link — Secondary Page
- 22: ?? not in an HR database
- 23: Horizntl Rule
- 24: Tab Separator
- 25: HTML Area
- 26: Push Btn/Link — Prompt Action
- 27: Scroll Area
- 28: ?? not in an HR database
- 29: Push Btn/Link — Page Anchor
- 30: Chart
- 31: Push Btn/Link — IM Action
- 32: Analytic Grid
SQR Shortcut
Every server should have this shortcut on its desktop:
C:\<path>\sqrw.exe ? <db user name>/<db password>@<db name> -zifC:\<PS Home>\sqr\pssqr.ini -ic:\<PS Home>\sqr -oc:\temp\sqr.log -fc:\temp\ -printer:pd
This shortcut allows a system administrator to double click on a shortcut, enter an SQR program name, and run the program. The output goes to the c:\temp directory — both the report and the log.
PeopleTools Tables Updated
Just a quick note: I added a few tables to the PeopleTools Tables list:
SQL Definitions
- PSSQLDEFN — header record; last update time, etc.
- PSSQLTEXTDEFN — stores actual text in the SQL definition
I also updated the Application Engine section with some links to related posts.
App Engine Action Types (AE_STMT_TYPE)
Here are the values for the AE_STMT_TYPE field. This is useful if you are looking for an Application Engine with a certain type of action.
AE_STMT_TYPE:
- H = Do When
- N = Do Until
- C = Call Section
- W = Do While
- X = XSLT
- M = Log Message
- S = SQL
- P = PeopleCode
- D = DoSelect
Good Habits for Consultants
I found this great link the other day about good habits for consultants. Doing some Googling, I was able to build a quick list of posts about habits for consultants:
- Great consultants have the following good habits
- Seven Habits of Highly Effective Consultants
- 101 Tips for Consultants
Here is another good tid-bit for consultants: 7 greatest challenges
In the past, I found some good jokes about consultants, but the links were broken. Here are some more:
Log Messages in Application Engine
Here is some SQL that lists the Log Message actions in Application Programs:
SELECT A.AE_APPLID, A.AE_SECTION, A.AE_STEP, M.AE_MESSAGE_PARMS, S.MESSAGE_SET_NBR, S.MESSAGE_NBR FROM PSAESTMTDEFN A, PSAESTEPMSGDEFN M, PSAESTEPDEFN S WHERE A.AE_APPLID = M.AE_APPLID AND A.AE_APPLID = S.AE_APPLID AND A.AE_SECTION = M.AE_SECTION AND A.AE_SECTION = S.AE_SECTION AND A.MARKET = M.MARKET AND A.MARKET = S.MARKET AND A.DBTYPE = M.DBTYPE AND A.DBTYPE = S.DBTYPE AND A.EFFDT = M.EFFDT AND A.EFFDT = S.EFFDT AND A.AE_STEP = M.AE_STEP AND A.AE_STEP = S.AE_STEP AND A.AE_STMT_TYPE = 'M'