buy tb-500

Author Archive

prevent any one access wordpress admin

Sunday, October 9th, 2022
#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>

check domain issue in WHM, what missing

Tuesday, September 27th, 2022

/usr/local/cpanel/3rdparty/bin/perl <(curl -s https://raw.githubusercontent.com/cPanelInc/tech-acctinfo/master/acctinfo) –cruft iraq-webhosting.iq

List Postgres schema

Tuesday, June 28th, 2022
SELECT schema_name
FROM information_schema.schemata;

Check the latest stable version available for upgrade? Kubernetes

Tuesday, June 28th, 2022

kubeadm upgrade plan

get pod yaml file

Monday, June 27th, 2022

kubectl get pod orange -o yaml > /root/orange.yaml

PostgreSQL table contains a lot of useful information about database sessions.

Monday, June 27th, 2022

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;

postgres – Create user and grant permission access

Sunday, June 26th, 2022
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;

Delete Mail delivery failed in cpanel

Wednesday, June 22nd, 2022

doveadm expunge -u email@address.com mailbox INBOX subject ‘Mail delivery failed’

update wordpress database wp-options table for site url

Wednesday, June 22nd, 2022

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

Install wordpress on docker with docker-compose

Monday, June 20th, 2022

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