Skip to main content

Notes PSQL, Apache X-Forwarded-Proto ...

 PSQL search column by name;
select t.table_schema,
       t.table_name
from information_schema.tables t
inner join information_schema.columns c on c.table_name = t.table_name
                                and c.table_schema = t.table_schema
where c.column_name = 'last_name'
      and t.table_schema not in ('information_schema', 'pg_catalog')
      and t.table_type = 'BASE TABLE'
order by t.table_schema;


oh detail ab flow request HTTP to HTTPS only
To understand X-Forwarded-Proto you have to understand the normal flow of communication when a client makes an HTTP request to a HTTPS-only resource.
https://community.pivotal.io/s/article/Purpose-of-the-X-Forwarded-Proto-HTTP-Header

 https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table

https://stackoverflow.com/questions/26620670/apache-httpx-forwarded-proto-in-htaccess-is-causing-redirect-loop-in-dev-envir
 It seem redirect first permanent broke later X-Forward rule ?

https://superuser.com/questions/1269319/how-to-get-proper-japanese-font-rendering-using-english-locale-under-windows

https://thesweetsetup.com/use-responsive-design-mode-safari/

http://www.web-tech-india.com/articles/php/compiling_php_apache/

http X-Forwarded-Proto https load balancer
https://stackoverflow.com/questions/26620670/apache-httpx-forwarded-proto-in-htaccess-is-causing-redirect-loop-in-dev-envir#
https://docs.aws.amazon.com/elasticloadbalancing/latest/classic/x-forwarded-headers.html
https://community.pivotal.io/s/article/Purpose-of-the-X-Forwarded-Proto-HTTP-Header

https://linux.die.net/man/8/sendmail.sendmail

https://www.freecodecamp.org/news/learn-linux-vim-basic-features-19134461ab85/
https://www.aleydasolis.com/htaccess-redirects-generator/https-vs-http/

https://aws.amazon.com/premiumsupport/knowledge-center/redirect-http-https-elb/
http://www.kompx.com/en/http-to-https-redirect-in-htaccess.htm

https://serverfault.com/questions/504603/reverse-proxy-and-load-balance-server-architecture
https://pdfs.loadbalancer.org/Web_Proxy_Deployment_Guide.pdf
https://laracasts.com/discuss/channels/forge/how-to-redirect-http-to-https-when-behind-load-balancer

https://www.digitalocean.com/community/tutorials/how-to-create-temporary-and-permanent-redirects-with-apache-and-nginx


It seem old PWG vbox camzink use port forwarding NAT ?
ssh -p 3022 or 2233 camzink@127.0.0.1
apache/node forward ...

https://stackoverflow.com/questions/11052199/convert-git-repository-file-encoding
#!/bin/sh

find . -type f -print | while read f; do
        mv -i "$f" "$f.recode.$$"
        iconv -f iso-8859-1 -t utf-8 < "$f.recode.$$" > "$f"
        rm -f "$f.recode.$$"
done

lambatest / blisk

https://unix.stackexchange.com/questions/43103/backspace-tab-not-working-in-terminal-using-ssh
https://blog.dallarosa.me/post/13278782524/a-tale-of-japanese-support-on-vim

// see file endcoding current buffer
:set fileencoding
fileencoding=utf8

https://superuser.com/questions/28779/how-do-i-find-the-encoding-of-the-current-buffer-in-vim

WTF php 5.1.6 :( no json_encode
https://stackoverflow.com/questions/7318191/enable-json-encode-in-php

https://www.electrictoolbox.com/rsync-ignore-existing-update-newer/
rsync --update -raz --progress /var/www 10.1.1.1:/var

charset is hard-coded in the file wtf

IDE n Project encoding
https://stackoverflow.com/questions/37805095/intellij-14-keeps-switching-encoding-to-utf-8
How can we work with mixed ? ie. html use UTF-8 and php use euc-jp ?

https://www.codediesel.com/php/7-essential-php-commandline-options/

IF((Test-Path -Path $FileOrFolderPath) -eq $false) {
    Write-Warning "File or directory does not exist."      
}
Else {
    $LockingProcess = CMD /C "openfiles /query /fo table | find /I ""$FileOrFolderPath"""
    Write-Host $LockingProcess
}

https://superuser.com/questions/117902/find-out-which-process-is-locking-a-file-or-folder-in-windows

http://blog.naver.com/PostView.nhn?blogId=ddakawar&logNo=60193288693&parentCategoryNo=&categoryNo=22&viewDate=&isShowPopularPosts=false&from=postView
link lib64 to lib in order to fix php 64bit install error.
cool from kor.

https://www.seroundtable.com/google-absolute-vs-relative-urls-26001.html
https://www.namecheap.com/support/knowledgebase/article.aspx/9821/38/apache-redirect-to-https

http://www.loadbalancer.org/blog/apache-and-x-forwarded-for-headers/
 https://www.trustwave.com/en-us/resources/blogs/spiderlabs-blog/intercepting-ssl-and-https-traffic-with-mitmproxy-and-sslsplit/

https://blog.lawrencemcdaniel.com/wordpress-aws-elb-ssl/
 

Comments

Popular posts from this blog

AWS Elasticache Memcached connection

https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/accessing-elasticache.html#access-from-outside-aws http://hourlyapps.blogspot.com/2010/06/examples-of-memcached-commands.html Access memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/GettingStarted.AuthorizeAccess.html Zip include hidden file https://stackoverflow.com/questions/12493206/zip-including-hidden-files phpmemcachedadmin ~ phpMyAdmin or phpPgAdmin ... telnet mycachecluster.eaogs8.0001.usw2.cache.amazonaws.com 11211 stats items stats cachedump 27 100 https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/VPCs.EC.html https://lzone.de/cheat-sheet/memcached VPC ID Security Group ID (sg-...) Cluster: The identifier for the cluster memcached1 Creation Time: The time (UTC) when the cluster was created January 9, 2019 at 11:47:16 AM UTC+7 Configuration Endpoint: The configuration endpoint of the cluster memcached1.ahgofe.cfg.usw1.cache.amazonaws.com:11211 St

Notes Windows 10 Virtualbox config, PHP Storm Japanese, custom PHP, Apache build, Postgresql

 cmd => Ctrl + Shift + Enter mklink "C:\Users\HauNT\Videos\host3" "C:\Windows\System32\drivers\etc\hosts" https://www.quora.com/How-to-create-a-router-in-php https://serverfault.com/questions/225155/virtualbox-how-to-set-up-networking-so-both-host-and-guest-can-access-internet 1 NAT + 1 host only config https://unix.stackexchange.com/questions/115464/how-to-properly-set-up-2-network-interfaces-in-centos-running-in-virtualbox DEVICE=eth0 TYPE=Ethernet #BOOTPROTO=dhcp BOOTPROTO=none #IPADDR=10.9.11.246 #PREFIX=24 #GATEWAY=10.9.11.1 #IPV4_FAILURE_FATAL=yes #HWADDR=08:00:27:CC:AC:AC ONBOOT=yes NAME="System eth0" [root@localhost www]# cat /etc/sysconfig/network-scripts/ifcfg-eth1 # Advanced Micro Devices, Inc. [AMD] 79c970 [PCnet32 LANCE] DEVICE=eth1 IPADDR=192.168.56.28 <= no eff => auto like DHCP #GATEWAY=192.168.56.1 #BOOTPROTO=dhcp BOOTPROTO=static <= no eff ONBOOT=yes HWADDR=08:00:27:b4:20:10 [root@localhost www]#

Rocket.Chat DB schema

_raix_push_notifications avatars.chunks avatars.files instances meteor_accounts_loginServiceConfiguration meteor_oauth_pendingCredentials meteor_oauth_pendingRequestTokens migrations rocketchat__trash rocketchat_cron_history rocketchat_custom_emoji rocketchat_custom_sounds rocketchat_import rocketchat_integration_history rocketchat_integrations rocketchat_livechat_custom_field rocketchat_livechat_department rocketchat_livechat_department_agents rocketchat_livechat_external_message rocketchat_livechat_inquiry rocketchat_livechat_office_hour rocketchat_livechat_page_visited rocketchat_livechat_trigger rocketchat_message rocketchat_oauth_apps rocketchat_oembed_cache rocketchat_permissions rocketchat_raw_imports rocketchat_reports rocketchat_roles rocketchat_room rocketchat_settings rocketchat_smarsh_history rocketchat_statistics rocketchat_subscription rocketchat_uploads system.indexes users usersSessions https://rocket.chat/docs/developer-guides/sc