October 9th, 2022 by ayad
#AuthName "Admins Only"
# ALLOW USER BY IP
<Limit GET POST>
order deny,allow
deny from all
allow from 1.2.3.4
allow from 5.6.7.8
</Limit>
# PREVENT VIEWING OF .HTACCESS
<Files .htaccess>
order allow,deny
deny from all
</Files>
Posted in Linux |
September 27th, 2022 by ayad
/usr/local/cpanel/3rdparty/bin/perl <(curl -s https://raw.githubusercontent.com/cPanelInc/tech-acctinfo/master/acctinfo) –cruft iraq-webhosting.iq
Posted in cPanel |
June 28th, 2022 by ayad
SELECT schema_name
FROM information_schema.schemata;
Posted in PostgreSQL |
June 27th, 2022 by ayad
kubectl get pod orange -o yaml > /root/orange.yaml
Posted in Kubernetes |
June 27th, 2022 by ayad
select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_name, backend_start, state, state_change from pg_stat_activity;
Posted in Uncategorized |
June 26th, 2022 by ayad
CREATE USER username WITH PASSWORD 'your_password';
GRANT USAGE ON SCHEMA schema_name TO username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;
Posted in DataBase |
June 22nd, 2022 by ayad
doveadm expunge -u email@address.com mailbox INBOX subject ‘Mail delivery failed’
Posted in cPanel |
June 22nd, 2022 by ayad
PDATE el_options SET option_value = replace(option_value, ‘https://ayad.iq/’, ‘https://henry.com/’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
note: ayad.com is the source and will be henry.com after the change
Posted in DataBase |
June 20th, 2022 by ayad
wordpress:
image: wordpress
links:
– mariadb:mysql
environment:
– WORDPRESS_DB_PASSWORD=1qa2ws3ed
– WORDPRESS_DB_USER=root
ports:
– “10.4.17.163:80:80”
volumes:
– ./html:/var/www/html
mariadb:
image: mariadb:10.8.2
environment:
– MYSQL_ROOT_PASSWORD=1qa2ws3ed
– MYSQL_DATABASE=wordpress
volumes:
– ./database:/var/lib/mysql
Posted in Uncategorized |