U

i��d':�@s�dd
lm
Z
mZmZmZmZmZ
ddlmZ
ddl	m
Z

ddlmZ
Gdd�de
�Z
Gdd�de
ee�ZGd	d
�d
e
ee�ZdS)�)�Plugin�RedHatPlugin�	SCLPlugin�DebianPlugin�UbuntuPlugin�	PluginOpt)
�quote)
�match)
�
is_executablec@sfeZ
dZd
ZdZdZdZdZedddd	�ed
ddd	�ed
ddd	�gZ	dZ
dd�Zddd�
Zdd�Z
dS)�Foremanz$Foreman/Satellite systems management�foremani)
Zsysmgmt)
r�months�
z#number of months for dynflow output)�defaultZdesc�
proxyfeaturesFz!collect features of smart proxies�puma-gczcollect Puma GC statsz/pumactl %s -S /usr/share/foreman/tmp/puma.statec
Cs�d
}
d|_d|_
z�td�
����D]l}|r"|ddkr8q"|�d�
rHd}
q"|
rdtd	|�rd|��d
|_|
r�td|�r�|��d
|_
|�d�
s"d
}
q"Wntk
r�


YnX|j
�d
�
r�|j
�	d
�
s�|j
�d�
r�|j
�	d�
r�|j
d
d�|_
d|j
i
|_
|�ddddd��

|�ddg�

|�
d�
d}|��}|�
d�
d}|��}|jdd�|j�
gdd�
|�dddd d!d"d#d$d%d&d'd(d)d*d+�|j�
d,�|j�
d-�|j�
d.�|j�
d/�|j�
d0�|j�
g�

|�d1d2d3d4d5d6d7d8|d8|d9g
�

|jd:d;d<�
|jd=d>d?�
|jd@dAd<�
|jdBdCd<�
|jdDdE�

|�dF�
�rH|j|jdGdHd<�
|j|jdIdJd<�
|�dK�

|�dL�
}|j|dM|j
dN�
dO|�dP�
}dQ}dR}dSt|�
}	dTt|�
}
dUt|�
}dV}||dWdXdY|dZd[�}
d\|	|
|d]�}|
D]*}|�|
|�
}|j||d^d_|j
d`�
�q�|�da�
}|D]H}db}|dck�r<|�r<dd}|j||d|de�}|j||d^d_|j
d`�
�q |�df�
�r�|jdgddh�}|j
||j
di�}|djdk�r�|d��d
d�D]2}|�dk�
}dl|d
}|j||ddmdndo�
�q�|�dpdqg�

dS)rNFZ	localhost�z/etc/foreman/database.ymlr
�
#zproduction:Tz\s+host:\s+\S+rz\s+password:\s+\S+�
 �
"�
'���Z
PGPASSWORDZforeman_production_logZforeman_tasks_configZforeman_ssl_access_ssl_log)z!/var/log/foreman/production.log.*z/etc/sysconfig/foreman-tasks�/etc/sysconfig/dynflowdz)/var/log/httpd/foreman-ssl_access_ssl.logz/etc/foreman/*key.pemz/etc/foreman/encryption_key.rbZhostname�outputzhostname -fz/var/log/foreman/production.logz"/var/log/{}*/foreman-ssl_*_ssl.log)
�	sizelimitz
/etc/foreman/z/etc/sysconfig/foremanrz/etc/default/foremanz&/var/log/foreman/dynflow_executor*log*z*/var/log/foreman/dynflow_executor*.output*z#/var/log/foreman/apipie_cache*.log*z/var/log/foreman/cron*.log*z /var/log/foreman/db_migrate*log*z/var/log/foreman/db_seed*log*z$/var/log/foreman/production.log[.-]*z$/var/log/foreman-selinux-install.logz&/var/log/foreman-proxy-certs-generate*z/usr/share/foreman/Gemfile*z/var/log/{}*/foreman*z2/var/log/{}*/katello-reverse-proxy_access_ssl.log*z1/var/log/{}*/katello-reverse-proxy_error_ssl.log*z/var/log/{}*/error_log*z/etc/{}*/conf/z/etc/{}*/conf.d/zforeman-selinux-relabel -nvzpassenger-status --show poolz passenger-status --show requestsz"passenger-status --show backtraceszpassenger-memory-statszls -lanR /root/ssl-buildz(ls -lanR /usr/share/foreman/config/hookszping -c1 -W1 %szping -c1 -W1 localhostz�qpid-stat -b amqps://localhost:5671 -q                     --ssl-certificate=/etc/pki/katello/qpid_router_client.crt                     --ssl-key=/etc/pki/katello/qpid_router_client.key                     --sasl-mechanism=ANONYMOUSzqpid-stat_-q�
�suggest_filenamezhammer pingZhammer_ping)
Ztagszsystemctl list-units dynflow*Z
dynflow_unitsz!"system-dynflow\x2dsidekiq.slice"Zdynflow_sidekiq_statuszdynflow-sidekiq@*)
Zunitsrzgc-statszpumactl_gc-statsZstatsZ
pumactl_statsz/usr/sbin/foreman-puma-statusa[SELECT table_name, pg_size_pretty(total_bytes) AS total, pg_size_pretty(index_bytes) AS INDEX , pg_size_pretty(toast_bytes) AS toast, pg_size_pretty(table_bytes) AS TABLE FROM ( SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM (SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME, c.reltuples AS row_estimate, pg_total_relation_size(c.oid) AS total_bytes, pg_indexes_size(c.oid) AS index_bytes, pg_total_relation_size(reltoastrelid) AS toast_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE relkind = 'r') a) a order by total_bytes DESCZforeman_db_tables_sizes)r�envz	%s monthsr
zRselect id,name,value from settings where name not similar to '%(pass|key|secret)%'z]select type,name,host,port,account,base_dn,attr_login,onthefly_register,tls from auth_sourcesz�select dynflow_execution_plans.* from foreman_tasks_tasks join dynflow_execution_plans on (foreman_tasks_tasks.external_id = dynflow_execution_plans.uuid::varchar) where foreman_tasks_tasks.started_at > NOW() - interval %sz�select dynflow_actions.* from foreman_tasks_tasks join dynflow_actions on (foreman_tasks_tasks.external_id = dynflow_actions.execution_plan_uuid::varchar) where foreman_tasks_tasks.started_at > NOW() - interval %sz�select dynflow_steps.* from foreman_tasks_tasks join dynflow_steps on (foreman_tasks_tasks.external_id = dynflow_steps.execution_plan_uuid::varchar) where foreman_tasks_tasks.started_at > NOW() - interval %sz�WITH prefix_counts AS (SELECT split_part(name,'::',1) FROM fact_names) SELECT COUNT(*), split_part AS "fact_name_prefix" FROM prefix_counts GROUP BY split_part ORDER BY count DESC LIMIT 100z!select * from dynflow_schema_infozselect count(*) from auditszselect count(*) from logsz2select name,url,download_policy from smart_proxies)Zforeman_settings_tableZforeman_auth_tableZdynflow_schema_infoZaudits_table_countZlogs_table_countZfact_names_prefixesZ
smart_proxiesz!select * from foreman_tasks_tasks)�foreman_tasks_tasksZdynflow_execution_plansZdynflow_actionsZ
dynflow_stepsiX�d)r�timeoutrrz
dynflow-utils�psqlrz /usr/libexec/psql-msgpack-decode)�csv�binaryrz"select name,url from smart_proxies)
r")
rZstatus�
,z\curl -s --key /etc/foreman/client_key.pem --cert /etc/foreman/client_cert.pem %s/v2/featuresZsmart_proxies_features�
)rZsubdirr Z
http_proxyZhttps_proxy)�dbhostZdbpasswd�open�read�
splitlines�
startswithr	�split�IOError�endswithr�
add_file_tagsZadd_forbidden_pathZexec_cmd�stripZ
add_copy_spec�format�	apachepkgZadd_cmd_outputZadd_service_statusZadd_journalZ
get_option�pumactl�build_query_cmdrZis_installedZadd_env_var)�selfZproduction_scope�lineZ	_hostnameZ_host_fZ_cmdr
ZscmdZauthcmdZdyncmdZ
dactioncmdZ	dstepscmdZfactnamescmdZ	foremandbZ
foremancsv�tableZdynutilsZdynr#Zproxies�proxy�r8�</usr/lib/python3/dist-packages/sos/report/plugins/foreman.py�setup%s^



















�

�


�

�





��

















�
�




�









�
�
�
�

�
�

�
�������	���





�


�



�







�

�

�


�

�
z
Foreman.setupr!cCs$|rd
|
}
d}|||jt
|
�
fS)aI

        Builds the command needed to invoke the pgsql query as the postgres
        user.
        The query requires significant quoting work to satisfy both the
        shell and postgres parsing requirements. Note that this will generate
        a large amount of quoting in sos logs referencing the command being run
        z>COPY (%s) TO STDOUT WITH (FORMAT 'csv', DELIMITER ',', HEADER)z:%s --no-password -h %s -p 5432 -U foreman -d foreman -c %s)r&r)r4Zqueryr"r#Z_dbcmdr8r8r9r3"
s

�
zForeman.build_query_cmdc

Cs4|�d
|j
dd�
|�ddd�
|�ddd�
dS)	Nz(/var/log/%s*/foreman-ssl_access_ssl.log*z7(.*\?(passw|cred|token|secret|key).*=)(.*) (HTTP.*(.*))z
\1******** \4z/etc/foreman/(.*)((conf)(.*)?)z5((\:|\s*)(passw|cred|token|secret|key).*(\:\s|=))(.*)z
\1********z"/etc/foreman/(.*)((yaml|yml)(.*)?)z\1"********")Zdo_path_regex_subr1�
r4r8r8r9�postproc0
s



�


�


�zForeman.postprocN)Fr!)�__name__�
__module__�__qualname__Z
short_descZplugin_nameZplugin_timeoutZprofilesZpackagesrZoption_listr2r:r3r<r8r8r8r9rs(



�
�
��~
rcs eZ
dZd
Z�f
dd�Z�ZS)�
RedHatForemanZhttpdc

sR|�d
di
�

|j
��dkr0td�
r0d|j|_tt|���
|jdddd	�
dS)
Nz"/usr/share/foreman/.ssh/ssh_configZssh_foreman_config�Zsclzscl enable tfm '%s'Ztfmzgem listzscl enable tfm gem listr)	r.ZpolicyZdist_versionr
r2�superr@r:Zadd_cmd_output_sclr;�
�	__class__r8r9r:G
s
�


�zRedHatForeman.setup)r=r>r?r1r:�
__classcell__r8r8rCr9r@C
sr@c
@seZ
dZd
ZdS)�
DebianForemanZapache2N)r=r>r?r1r8r8r8r9rFV
srFN)Zsos.report.pluginsrrrrrrZpipesr�rer	Z
sos.utilitiesr
rr@rFr8r8r8r9�<module>s 

2