Skip to content

Instantly share code, notes, and snippets.

@kkarthee
kkarthee / README.md
Created January 16, 2019 01:58 — forked from hofmannsven/README.md
My simply MySQL Command Line Cheatsheet
@kkarthee
kkarthee / README.md
Created January 16, 2019 01:58 — forked from hofmannsven/README.md
My simply MySQL Command Line Cheatsheet
Facter.add(:local_users) do
setcode do
users = Array.new
File.open("/etc/passwd").each do |line|
next if line.match(/^\s|^#|^$/)
users << line.split(':').first
end
# users.join(',')
users
end
list user
curl https://$(puppet config print certname):4433/rbac-api/v1/users --cert $(puppet config print hostcert) --key $(puppet config print hostprivkey) --cacert $(puppet config print cacert) |python -m json.too
Create new user
curl -X POST -H 'Content-Type: application/json' --cert $(puppet config print hostcert) --key $(puppet config print hostprivkey) --cacert $(puppet config print cacert) https://$(head -n 1 /etc/puppetlabs/puppet/classifier.yaml |grep -oP "(?<=server: ).*"):4433/rbac-api/v1/users -d '{"login":"dbsadmin","email":"","display_name":"dbstestuser","role_ids": [1],"password":"dbstest"}'
Compile master /agent
`curl -k https://<MoM_HOSTNAME>:8140/packages/current/install.bash | sudo bash -s main:dns_alt_names=<COMMA-SEPARATED LIST OF ALT NAMES FOR THE COMPILE MASTER>`
`curl -k https://pe-201732-master.puppetdebug.vlan:8140/packages/current/install.bash | sudo bash -s main:dns_alt_names=compile-master1,compile-master-dev
su - pe-postgres -s '/bin/bash' -c '/opt/puppetlabs/server/bin/psql -d pe-puppetdb -c "select value,name,pg_column_size(value) from facts inner join fact_paths on fact_paths.id=facts.fact_path_id inner join fact_values on fact_values.id=facts.fact_value_id order by pg_column_size(value) desc limit 10;"' > /tmp/large_facts.txt