Red Hat Bugzilla – Bug 146937
Satellite entitlement certificate tool should pull company name from Oracle account not web info
Last modified: 2007-04-18 13:19:07 EDT
Currently, the tool pulls the customer name from the web contact "Company"
field. This information has proven to be less reliable than the "Oracle Customer
Name" field from the Oracle account.
Joe, can you elaborate on what field you'd like? It looks like the tool is
pulling the owner field in a satellite cert from the web_customer.name column.
Updated rhn-svn/trunk/eng/web/modules/sniglets/Sniglets/Org.pm and
rhn-svn/trunk/eng/web/modules/rhn/RHN/DB/Org.pm in svn to pull company name from
web_user_personal_info instead of web_customer.
This is still kind of a dirty process. web_user_personal_info are actually
login records, not org records. However, the company name there is what is most
commonly reflected in Supportable. This is b/c a user will log into WWW, update
their company name, it's then saved in web_user_personal_info, and then the www
proc sync_customer pulls from web_user_personal_info and syncs to the Oracle
So, pulling from web_user_personal_info is much more accurate of a company name
instead of web_customer.name.
1. web_user_personal_info.company is a nullable field. In the case where it's
null, the cert code will still have to pull from web_customer.name. It is
rarely null for orgs with satellite.
2. Folks in support can actually manually overwrite the customer name from the
backend side. In which case the web, is not aware of the change, and if
sync_customer is ever called again for that org, the changes made by support
would be then be overwritten. RHN has no aware of being aware of these manual
changes, unless it connected to predhi to query them, or an api was built to get
After talking with Bobby T and Kathi Bean, this is one of the items that is
going to be eventually cleaned up in the OCS project.
1. Login to an account on qa that has the ability to create/view certs through
the RHN Support Tools tab. If you don't have an account with these privileges,
let me know and I'll create one or add the privileges to an existing account.
2. Click on the RHN Support Tools tab.
3. Search by Org(id), and enter org id 2758802.
4. Click on the Entitlements tab.
5. Click on Create new Satellite certificate in the upper right corner.
6. On the next screen the Owner field should say Iron Mountain, as opposed to
7. Scroll to the bottom and click View cert.
8. In the text box, the owner field should be Iron Mountain.
9. Scroll to the bottom and click Back.
10. Click Download cert at the bottom.
11. Download the cert to your local machine and verify that in the saved cert
file, the owner field is Iron Mountain.
If all steps pass, the bug passes.