seems no one can log into the console https://console.aws.amazon.com/console/home We’re seeing: 504 Gateway Time-out Comment if you learn why or hear an update Their status page claims all is up..
Best Caprese Salad Recipe
We call it the Leaning tower of Caprese Caprese salads can be made in many ways. Manipulations of the three key ingredients (tomatoes, mozzarella, basil) will result in different varieties of the salad – all being delicious. Here is my favourite version of the Caprese – it’s not really a leaning tower so much as… Continue reading Best Caprese Salad Recipe
Find the Perfect Rental Unit | How To
Searching for a rental unit can be tough, time-consuming, and stressful. Whether you’re desperate to move now or even looking well in advance, some tricks and tips can help ease the process so you can relax in your new home as soon as possible. 1. Know your limits and must-haves These limits should incorporate all… Continue reading Find the Perfect Rental Unit | How To
Installing Software on Ubuntu Server 14.04
Install Oracle Java 7 on Ubuntu: sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java7-set-default Install Glashfish 4 on Ubuntu: #Download Glassfish 4 wget download.java.net/glassfish/4.0/release/glassfish-4.0.zip #install the unzip program apt-get install unzip #unzip the glassfish zip to you /opt directory unzip glassfish-4.0.zip -d /opt #start glassfish app server /opt/glassfish4/bin/asadmin start-domain #change the admin password… Continue reading Installing Software on Ubuntu Server 14.04
Ignore Foreign Key Constraints During Truncate or Drop
If you are trying to drop/delete or empty/truncate a mysql table and you keep getting an error that you are violating a foreign key constraint, you may want to temporarily ignore that constraint. The code below demonstrates how you can tell mysql to ignore foreign key checks, delete/truncate the tables you need to, then re-enable… Continue reading Ignore Foreign Key Constraints During Truncate or Drop
Create new MySQL user and allow them to connect from any IP
If you are getting the error: user is not allowed to connect to this MySQL serverConnection closed by foreign host Or : Access denied for user ‘root’@’somehost.com’ (using password: YES)) Then you probably have not created your user properly in MySQL Here is how to create a new MySQL user and give him access to… Continue reading Create new MySQL user and allow them to connect from any IP
MySQL See all columns and tables that foreign key to a table or column
If you’re trying to understand how an existing database has been setup it can be very useful to see all of the tables/columns that foreign key into some other table/column. use INFORMATION_SCHEMA; select TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from KEY_COLUMN_USAGE where REFERENCED_TABLE_NAME = ‘your_table_name’ AND REFERENCED_COLUMN_NAME = ‘your_column_name’
Ruby MySQL Transaction Example
Here is a simple tutorial showing how to implement transactions in Ruby with MySQL. The code uses The MySQL2 Gem. We are showing the insert of 2 records into the customers table of a database. If either insert fails, both will be rolled back. require “mysql2” client_mysql = Mysql2::Client.new(:host =>; “localhost”, :username =>; “my_user”, :password… Continue reading Ruby MySQL Transaction Example
Setup a new GIT repository
Here is a quick reminder of how to setup a new git repository on your git server and check it out on your client machine. On The Server cd /opt/git mkdir newproject.git cd newproject.git git –bare init On the Client cd /home/user/projects git clone git@gitserver:/opt/git/newproject.git cd newproject vim README git add . git commit -m… Continue reading Setup a new GIT repository
Medical Alert Systems for 2013
As our loved ones age, their safety becomes of real concern to us, especially when they are living alone or have a disability or illness. These days, we all lead extremely busy lives and we don’t always have the time to call around and check in on our elderly friends and relatives as much as… Continue reading Medical Alert Systems for 2013