This is a continuation of my virtual PeopleSoft installation. In this step, we will create the database in an already installed Oracle Database system. So, this assumes that the Oracle Database software is already installed. Loading the PeopleTools data will be covered in the next step. To see the complete list of steps, click here.
Author: digitaleagle
Step by Step PS Install: Load the Database
This is a continuation of my virtual PeopleSoft installation. In this step, we will run Data Mover to load the database. To see the complete list of steps, click here.
jQuery and PeopleSoft
I came across this link talking about storing Javascript libraries in PeopleTools to use with PeopleSoft applications. The interesting part is that I have been able to get it working by storing jQuery in an HTML definition. Application Designer did give me an error about it being too big, but it went ahead and saved it. Everything seems to work fine so far, and I haven’t had a need to look for another fix.
The solution to save the library in the message catalog sounds great, but the big problem with Message Catalogs is that they can’t be exported to a file.
Resources
Query Tool that includes Meta-SQL
Once I learned about SQL Developer, I switched from using Toad as my Query Tool. If I were to improve one thing though, it would be that the query tool understand Meta-SQL. Now, if I copy SQL from PeopleSoft, say from an Application Engine, I have to remove all of the Meta-SQL tags that PeopleTools understands before I can run it. Then, I have to replace them before copying back to PeopleTools.
I have thought about trying to write an extension for SQL Developer. Does anyone know of any documentation about writing extensions or plug-ins for SQL Developer? This might be a place to start. Another route I have thought about is an open source tool called Squirrel SQL hosted on Source Forge. It looks like it has a way to write plug-ins or extensions, but I haven’t been able to get it to connect to any of my databases yet. To be fair, I haven’t given it a thorough run-through yet.
If you have any ideas or information, please let me know.
Updated Resources
Tahiti Views just reported that Oracle has just put up the official PeopleBooks on their website.
The Internet Resources page now includes the official PeopleBooks:
http://psst0101.wordpress.com/resources-on-the-internetresources-on-the-internet/
Step By Step Virtual PS Install: Application Install
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