suvozy

It seems that it does not matter what timezone is on the server as long as you have the time set right for the current timezone, know the timezone of the datetime columns that you store, and are aware of the issues with daylight savings time.

On the other hand if you have control of the timezones of the servers you work with then you can have everything set to UTC internally and never worry about timezones and DST.

Here are some notes I collected of how to work with timezones as a form of cheatsheet for myself and others which might influence what timezone the person will choose for his/her server and how he/she will store date and time.

MySQL Timezone Cheatsheet

suvozy

<?php

/*
 * Because we are removing the ending `=` padding we will have a string length of
 * md5 <= 24
 * sha1 <= 28
 *
 * Probably should just remove the code that trims the equal sign since it's kind of pointless....
 */

suvozy

Remove __MACOSX file from .zip

zip -d /Users/suvozit/Desktop/php-sample/Archive.zip "__MACOSX*"

Show / Hide hidden files on Mac OS X

To show hidden files on your mac launch Terminal and enter these commands:

defaults write com.apple.Finder AppleShowAllFiles TRUE

suvozy

sudo -i

#Build webapp key

sudo -Hu webapp ssh-keygen -t rsa # choose "no passphrase"

or

suvozy

Launch an instance

http://docs.aws.amazon.com/AmazonVPC/latest/GettingStartedGuide/GetStarted.html

Security group

phpMyAdmin

Inbound

Type	Protocol	Port Range	Destination
SSH	TCP	22	0.0.0.0/0