Skip to main content

Rand mm 04


if (intval($http_status / 100) == 4) {
            throw new AlgoliaException(isset($answer['message']) ? $answer['message'] : $http_status.' error', $http_status);
        } elseif (intval($http_status / 100) != 2) {
            throw new \Exception($http_status.': '.$response, $http_status);
        }


Keep an eye on EFS WP


dump

noted that guide for ubuntu 16 not work since gpg key or something else that caused it not work.

query
limit

https://stackoverflow.com/questions/9755841/how-can-i-change-the-version-of-npm-using-nvm

Find unused AWS SG
https://stackoverflow.com/questions/24685508/how-to-find-unused-amazon-ec2-security-groups

https://new.abb.com/high-voltage/AIS/dcb

https://blog.gruntwork.io/authenticating-to-aws-with-the-credentials-file-d16c0fbcbf9e

https://stackoverflow.com/questions/28795531/ebextensions-yum-does-not-install-package
https://stackoverflow.com/questions/33920414/how-to-install-composer-dependencies-on-elastic-beanstalk-multicontainer-docker

https://aws.amazon.com/vpc/faqs/
https://javawithravi.com/ssh-tunnel-to-remote-mongodb/

SSH tunnel and mongodb access outside VPC
https://docs.aws.amazon.com/documentdb/latest/developerguide/connect-from-outside-a-vpc.html
https://docs.aws.amazon.com/documentdb/latest/developerguide/getting-started.connect.html
Your docdb
https://console.aws.amazon.com/docdb/home?region=us-east-1#cluster-details/...

Yeah Invalid hostname as mentioned in mongo doc
https://github.com/Studio3T/robomongo/issues/1189
> mongo --sslAllowInvalidHostnames --ssl --sslCAFile rds-combined-ca-bundle.pem --username <yourUsername> --password <yourPassword>

After a lot of pain, I finally achieved connection with Robo 3T through SSH Tunnel.

The SO post that helped me was [this one](https://stackoverflow.com/a/24143976/1058172)

Basically, you should use a private key generated through `openssl` instead of `ssh-keygen` (why? IDK)

Generate the private key:

`openssl genpkey -algorithm RSA -out private.pem`

Then, get the public key to add to your server `.ssh/authorized_keys` file with:

`ssh-keygen -y -f private.pem`

Then, finally connect Robo 3T using this `private.pem` key file and voilá

Seem not as my problem, but cool topic ab openssl vs ssh-keygen.

https://docs.aws.amazon.com/cli/latest/userguide/cli-services-s3-commands.html

https://github.com/jenssegers/laravel-mongodb/issues/1204

Use 'dsn' key in config/database.php as shown below to mention the complete cluster url.

```
'mongodb_conn' => [
         'driver' => 'mongodb',
         'dsn'=>'mongodb://username:password@hosts/database?ssl=true&replicaSet=replicaSet&authSource=admin',
         'database' => 'my_data',
     ]
```
yeah yeah !


And remember. remove username, password in .env
I have tried user/pass empty but not work => remove or comment out parameter that not need is an option for trial n errors.

https://docs.atlas.mongodb.com/driver-connection/#driver-examples

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...