Bug 495217

Can you please add this information to report produced by rhn plugin of sos? Thx.

+++ This bug was initially created as a clone of Bug #486526 +++

Description of problem:

Listed below would 3 useful additions to satellite-debug - I can break them out into separate bugs, if needed.

1. Usage information:

This is very useful information and frequently requested especially in cases of large deployments and/or performance problems.  The results from the following queries gives a general picture of the deployment size and usage of the Satellite, including the number of servers, packages, channels, etc.. -

select count(*) from rhnpackagename;
select count(*) from rhnpackage;
select count(*) from rhnchannelpackage;
select count(*) from rhnchannel;
select count(*) from rhnserverchannel;
select count(*) from rhnserver;
select count(*) from rhnservergroup;
select count(*) from rhnservergroupmembers;
select count(*) from rhnUserManagedServerGroups;
select count(*) from rhnUserDefaultSystemGroups; 

Additionally, in the case of users who for some reason cannot or prefer not to give this information to be queried, a "--no-usage" option can be added to not run these queries and include results in the satellite-debug tar.

2. The sudoers file and tomcat, apache, and oracle user/group information

There're a significant number and types of problems that are caused by incorrect/missing configuration in /etc/sudoers and/or user/group setup in the /etc/passwd and /etc/group files.  Including /etc/sudoers file, and the output of grepping for tomcat, apache, and oracle in /etc/passwd and /etc/group would be very useful.

3. Oracle configuration

Starting with Satellite 5.2.0, the supported/embedded oracle database version is 10g (from 9i), this in addition to some performance issues that are currently under investigation have resulted in some workaround being applied, to avoid future confusion, it would be very useful to query these configurations in the database for Satellites 5.2.0 and above:

select dbms_stats.get_param('METHOD_OPT') from dual;
select value from v$parameter where name='optimizer_mode';
select value from v$parameter where name='optimizer_index_cost_adj';
SELECT X.KSPPINM NAME, DECODE(BITAND(KSPPIFLG/256, 1), 1, 'TRUE', 'FALSE') SESMOD, DECODE( BITAND(KSPPIFLG/65536, 3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', 'FALSE' ) SYSMOD, KSPPDESC DESCRIPTION FROM SYS.X_$KSPPI X WHERE X.INST_ID = USERENV('INSTANCE') AND X.KSPPINM = '_optimizer_cost_based_transformation' ; 

Version-Release number of selected component (if applicable):
All.

How reproducible:
See above.

Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info:

--- Additional comment from cperry on 2009-02-20 11:56:33 EDT ---

Milan - I recently sent Jan an email similar to this. Would be great if you two could work together to review what makes sense above and anything missing. I noted as a concern we needed a way to capture and look for those customers running say role based vs cost and never change to the correct long term resolution. 

Thanks,
Cliff

--- Additional comment from mzazrivec on 2009-03-26 09:09:40 EDT ---

spacewlak.git master:
bf56c0495d6cfe4f59b7bc0ec15b9acb13148486
1766b8bb663b179c2ced25bb6b0dc19e9c852374
b8db0d49f6add0b6449243ecd56b4ef0ccb84f37

Additional data included into spacewalk-debug archive:
* /etc/sudoers
* apache, oracle, tomcat, nocpulse entries from /etc/{passwd,group}
* database: row counts for all rhnsat tables
* database: select dbms_stats.get_param('METHOD_OPT') from dual;
* database: show parameter

All database statistics are put into db-stats/db-stats.log

--- Additional comment from jpazdziora on 2009-04-06 06:33:39 EDT ---

Added 78bf864796b0612fb3e848138714ae2266622ce7 for db-stats/ to database/ rename, and 9067493f14e8c1505bf00b875fa2ef27677b7331 for alert.log backup.

--- Additional comment from mzazrivec on 2009-04-10 08:56:17 EDT ---

Created an attachment (id=339087)
example of schema upgrades history output

Commits dac2399e8a258e5122d781b054a29739f32c749c in spacewalk.git master
and 75fbc57c370d51bec64698515b4559b94fd4cd1c in spacewalk.git VADER
added history of schema upgrades to the debug output.