Bug 128589 - adding exec on rhn_exception for web
adding exec on rhn_exception for web
Status: CLOSED CURRENTRELEASE
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Other (Show other bugs)
unspecified
All Linux
medium Severity medium
: ---
: ---
Assigned To: Peter Jones
Fanny Augustin
:
Depends On:
Blocks: 128151
  Show dependency treegraph
 
Reported: 2004-07-26 16:29 EDT by Shannon Hughes
Modified: 2007-10-23 22:10 EDT (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2004-08-19 09:09:37 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Shannon Hughes 2004-07-26 16:29:11 EDT
Description of problem:


<pjones> can you do me a favor and file a bug asking for exec on
rhn_exception to be granted to web_dml_r ?
<pjones> (just because the dbchange system requires a bug ID...)
Comment 1 Shannon Hughes 2004-07-28 14:26:11 EDT
also need the following added to the rhn_exception tables for this to
work:

label, msg

webreg_duplicate, Registration number already registered
webreg_not_active, Registration number is not active
webreg_sync_error, Synchronization error with sync_registration_uber
webreg_invalid, Registration number is invalid
webreg_unknown_error, Unknown registration error
Comment 2 Bret McMillan 2004-08-05 17:35:34 EDT
according to pjones, ON_DEV.

Test Plan:

will be tested by successful runs of bz #128392 and #128396
Comment 3 Bret McMillan 2004-08-06 13:57:25 EDT
Not done:

rhnuser@webdev> select
web.web_api.register_product('fd78-b3a5-2489-87bf', 37586 08) from dual;
 
ORA-20001: Unable to lookup exception with label (webreg_invalid)
ORA-06512: at "RHN.RHN_EXCEPTION", line 31
ORA-06512: at "WEB.WEB_API", line 70
Comment 4 Bret McMillan 2004-08-06 14:02:18 EDT
rhnuser@webdev> select id, label from rhnexception where label like
'web%';
 
0 rows selected (0.01 seconds)

So, we're missing all of these.
Comment 5 Peter Jones 2004-08-06 15:08:04 EDT
Exceptions are on dev now, sorry.
Comment 6 Fanny Augustin 2004-08-12 12:35:18 EDT
Looks good on Dev
Comment 7 Fanny Augustin 2004-08-12 15:52:33 EDT
Looks good on QA.

Note You need to log in before you can comment on or make changes to this bug.