Skip to main content

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]#

 https://www.tecmint.com/install-virtualbox-guest-additions-in-centos-rhel-fedora/
https://www.if-not-true-then-false.com/2010/install-virtualbox-guest-additions-on-fedora-centos-red-hat-rhel/ => this one is working perfectly.
previous link seem wrong uname -r (miss uname -a) for x64

 sudo iptables -I INPUT -p tcp --dport 80 -j ACCEPT
$ sudo iptables -A INPUT -p tcp -m tcp --dport 80 -j ACCEPT
$ sudo /etc/init.d/iptables save

https://support.rackspace.com/how-to/centos-6-apache-and-php-install/
 sudo /sbin/chkconfig httpd on

https://stackoverflow.com/questions/19904083/how-to-fix-error-with-xml2-config-not-found-when-installing-php-from-sources

iconv -f ISO-8859-1 -t UTF-8 in.txt > out_utf-8.txt
encoding on git diff https://stackoverflow.com/questions/19435071/make-git-diff-show-utf8-encoded-characters-properly

https://serverfault.com/questions/106801/recommended-method-to-upgrade-php-5-1-6-to-5-2-x-on-centos-5-4
seem not work

aha https://www.liquidweb.com/kb/what-is-the-default-password-for-postgresql/
why postgres messing with linux username.


https://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html
damn listen *
https://serverfault.com/questions/106168/cant-connect-to-postgresql-on-virtualbox-guest

resize vdi
http://derekmolloy.ie/resize-a-virtualbox-disk/
not think that damn DB quite big.

http://httpd.apache.org/docs/current/rewrite/intro.html

https://serverfault.com/questions/428800/how-do-i-tell-apache-which-php-to-use/469849

 https://www.jetbrains.com/help/phpstorm/remote-debugging-via-ssh-tunnel.html

 https://www.elliotblackburn.com/psql-pg_dump-via-ssh-tunnel/

 https://stackoverflow.com/questions/10821974/how-to-make-geoip-country-name-by-name-work

geoip


https://stackoverflow.com/questions/2593803/how-to-generate-the-create-table-sql-statement-for-an-existing-table-in-postgr
pg_dump -t 'aschema.atable' --schema-only database-name

https://stackoverflow.com/questions/50085286/postgresql-fatal-ident-authentication-failed-for-user

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

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