관리-도구
편집 파일: foreman.pyc
� u��ec @ s� d d l m Z m Z m Z m Z m Z d d l m Z d d l m Z d e f d � � YZ d e e e f d � � YZ d e e e f d � � YZ d S( i����( t Plugint RedHatPlugint DebianPlugint UbuntuPlugint SCLPlugin( t quote( t matcht Foremanc B sP e Z d Z d Z d Z d Z d Z d g Z d � Z e d d � Z d � Z RS( s+ Foreman/Satellite 6 systems management t foremani t sysmgmts foreman-proxyt monthss# number of months for dynflow outputt fasti c * C s� t } d | _ d | _ y� x� t d � j � j � D]� } | s4 | d d k rW q4 n | j d � rr t } q4 n | r� t d | � r� | j � d | _ n | r� t d | � r� | j � d | _ n | j d � s4 t } q4 q4 WWn t k r� n X| j j d � r | j j d � sA| j j d � rW| j j d � rW| j d d !| _ n i | j d 6| _ | j d d g � | j d � d } | j � } | j d � d } | j � } | j d d j | j � g d d �| j d d d d d d d d d d d! d" d# d$ d% d& d' d( d) d* d+ d, d- d. d/ d0 d1 d2 d3 d4 j | � d5 j | � d6 j | j � d7 j | j � d8 j | j � d9 j | j � d: j | j � d; j | j � g% � | j d< d= d> d? d@ dA dB dC dD dE dF | dF | dG g � | j dH dI dJ �| j dK dI dL �| j dM dN � | j dO � } | j | dI dP dQ | j �dR | j dS � } dT } dU } dV t | � } dW t | � } dX t | � } dY } i | dZ 6| d[ 6d\ d] 6d^ d_ 6d` da 6db dc 6| dd 6de df dg dh di 6} i | dj 6| dk 6| dl 6} xI | D]A } | j | | � } | j | dI | dm dn d do dQ | j �qW| j dp � } xv | D]n } dq } | d_ k r�| r�dr } n | j | | ds t dt | �} | j | dI | dm dn d do dQ | j �qoW| j du dv g � d S(w Nt localhostt s /etc/foreman/database.ymli t #s production:s \s+host:\s+\S+i s \s+password:\s+\S+t t "s 'i����t PGPASSWORDs /etc/foreman*/*key.pems /etc/foreman*/encryption_key.rbt hostnamet outputs hostname -fs /var/log/foreman/production.logs" /var/log/{}*/foreman-ssl_*_ssl.logt sizelimits /etc/foreman/s /etc/foreman-proxy/s /etc/sysconfig/foremans /etc/sysconfig/dynflowds /etc/default/foremans /etc/foreman-installer/s& /var/log/foreman/dynflow_executor*log*s* /var/log/foreman/dynflow_executor*.output*s# /var/log/foreman/apipie_cache*.log*s /var/log/foreman/cron*.log*s /var/log/foreman/db_migrate*log*s /var/log/foreman/db_seed*log*s$ /var/log/foreman/production.log[.-]*s /var/log/foreman-proxy/cron*log*s, /var/log/foreman-proxy/migrate_settings*log*s! /var/log/foreman-proxy/proxy*log*s4 /var/log/foreman-proxy/smart_proxy_dynflow_core*log*s$ /var/log/foreman-selinux-install.logs& /var/log/foreman-proxy-certs-generate*s /var/log/foreman-installer/*s /var/log/foreman-maintain/*s /var/log/syslog*s /var/log/tomcat*/catalina*log*s" /var/log/tomcat*/host-manager*log*s /var/log/tomcat*/localhost*log*s /var/log/tomcat*/manager*log*s /usr/share/foreman/Gemfile*s /var/lib/puppet/ssl/certs/ca.pems' /etc/puppetlabs/puppet/ssl/certs/ca.pems' /etc/puppetlabs/puppet/ssl/certs/{}.pems /var/lib/puppet/ssl/certs/{}.pems /var/log/{}*/foreman*s2 /var/log/{}*/katello-reverse-proxy_access_ssl.log*s1 /var/log/{}*/katello-reverse-proxy_error_ssl.log*s /var/log/{}*/error_log*s /etc/{}*/conf/s /etc/{}*/conf.d/s4 bundle --local --gemfile=/usr/share/foreman/Gemfile*s hammer pings foreman-selinux-relabel -nvs foreman-maintain service statuss passenger-status --show pools passenger-status --show requestss" passenger-status --show backtracess passenger-memory-statss ls -lanR /root/ssl-builds( ls -lanR /usr/share/foreman/config/hookss ping -c1 -W1 %ss ping -c1 -W1 localhosts systemctl list-units dynflow*t suggest_filenamet dynflow_unitss! "system-dynflow\x2dsidekiq.slice"t dynflow_sidekiq_statust unitss dynflow-sidekiq@*s[ 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 DESCt foreman_db_tables_sizest envs %s monthsR sR select id,name,value from settings where name not similar to '%(pass|key|secret)%'s] select type,name,host,port,account,base_dn,attr_login,onthefly_register,tls from auth_sourcess� 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 %ss� 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 %ss� 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 %ss� 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 100t foreman_settings_tablet foreman_auth_tables! select * from dynflow_schema_infot dynflow_schema_infos! select * from foreman_tasks_taskst foreman_tasks_taskss select count(*) from auditst audits_table_counts select count(*) from logst logs_table_countt fact_names_prefixess select sp.name, sp.url, s+ sp.download_policy,n.ip from smart_proxies s- as sp left join hosts as h on h.name=sp.name s% left join nics as n on n.host_id=h.idt smart_proxiest dynflow_execution_planst dynflow_actionst dynflow_stepst timeoutiX id s dynflow-utilst psqls /usr/libexec/psql-msgpack-decodet csvt binaryt http_proxyt https_proxy( t Falset dbhostt dbpasswdt opent readt splitlinest startswitht TrueR t splitt IOErrort endswithR t add_forbidden_patht exec_cmdt stript add_copy_spect formatt apachepkgt add_cmd_outputt add_service_statust add_journalt build_query_cmdt get_optionR t is_installedt add_env_var( t selft production_scopet linet _hostnamet _host_ft _cmdR t scmdt authcmdt dyncmdt dactioncmdt dstepscmdt factnamescmdt foremandbt foremancsvt tablet dynutilst dynR) ( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyt setup s $$ R' c C s3 | r d | } n d } | | | j t | � f S( sI 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 s> COPY (%s) TO STDOUT WITH (FORMAT 'csv', DELIMITER ',', HEADER)s: %s --no-password -h %s -p 5432 -U foreman -d foreman -c %s( R- R ( RD t queryR( R) t _dbcmd( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyR@ s c C s� d } | j d | d � d } | j d | d � | j d d d � | j d d d � | j d d d � | j d d d � | j d d d � | j d | j d d � d S( Ns~ ((foreman.*)?(\"::(foreman(.*?)|katello).*)?((::(.*)::.*(passw|cred|token|secret|key).*(\")?:)|(storepass )|(password =)))(.*)s /var/log/foreman-installer/sat*s \1 ********sZ (\s)+(Found key: (\"(foreman(.*?)|katello)::(.*(token|secret|key|passw).*)\") value:) (.*)s \1 \2 ********s# (\.|_|-)password(=\'|=|\", \")(\w*)s \1password\2********s) /var/log/foreman-installer/foreman-proxy*s (\s*proxy_password\s=) (.*)s! /etc/foreman(.*)((yaml|yml)(.*)?)s5 ((\:|\s*)(passw|cred|token|secret|key).*(\:\s|=))(.*)s \1"********"s /etc/foreman(.*)((conf)(.*)?)s \1********s/ /var/log/foreman-maintain/foreman-maintain.log*s. (((passw|cred|token|secret)=)|(password ))(.*)s( /var/log/%s*/foreman-ssl_access_ssl.log*s7 (.*\?(passw|cred|token|secret|key).*=)(.*) (HTTP.*(.*))s \1******** \4( t do_path_regex_subR< ( RD t satregt sat_debug_reg( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyt postproc sD ( R ( R s foreman-proxy( s monthss# number of months for dynflow outputR i ( t __name__t __module__t __doc__t plugin_namet plugin_timeoutt profilest packagest option_listRU R, R@ R[ ( ( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyR s �t RedHatForemanc B s e Z d Z d � Z RS( t httpdc C s- t t | � j � | j d d d d �d S( Nt tfms gem listR s scl enable tfm gem list( t superRd RU t add_cmd_output_scl( RD ( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyRU H s ( R\ R] R< RU ( ( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyRd D s t DebianForemanc B s e Z d Z RS( t apache( R\ R] R< ( ( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyRi N s N( t sos.pluginsR R R R R t pipesR t reR R Rd Ri ( ( ( s7 /usr/lib/python2.7/site-packages/sos/plugins/foreman.pyt <module> s (� 3