BowerStudios.com

A chronic disposition to inquiry deprives domestic felines of vital qualities

There's a difference between the two annotations which is nicely explained on stackoverflow

Postgres stores time in UTC, if you want to see the value of a date for a particular timezone, use one of the following:

SELECT now() AT TIME ZONE current_setting('TimeZone');
SELECT now() AT TIME ZONE 'EST5EDT';
SELECT now() AT TIME ZONE 'UTC';

From chili555 on stackoverflow:

sudo ifdown wlan0 && sudo ifup wlan0

I was digging around trying to figure out some strange error with a saml integration when I came across the verifyAudience Method of the spring-security-saml/core/src/main/java/org/springframework/security/saml/websso/WebSSOProfileConsumerImpl.java

I had never noticed this particular usage of Java in the wild with a loop inside a loop with a continue statement.

I've created an example in groovy because I'm lazy:

List restrictions = [1,2,3,4,5]
List selections = [3,5]

audience:
for(int a in restrictions){
for(int b in selections){
if(a==b){
println "skip"
continue audience
}
println "$a -- $b"
}
}

Here is the Output:
1 -- 3
1 -- 5
2 -- 3
2 -- 5
skip
4 -- 3
4 -- 5
5 -- 3
skip

Some info from Stackoverflow

Dbmmanage is no longer used. Need to use htdbm now:

You'll need to install php5 and apache utils:
sudo apt-get install apache2-utils

create a dbm file with:
sudo htdbm -cTDB .pwfilename username

Additional info:

• ubuntu.com

tags: htpwd htpasswd

First the layout. I have a Debian Linux desktop running Vmware Workstation. Within Vmware workstation, I have a Debian Linux server that I've named "VPN" for other purposes. I will use this VPN machine to supply one side of my ssh tunnel. On the other side of the tunnel is an ESX server with yet another Debian Linux server named "gateway" running inside of it. "gateway" has one network connection that is on the internet, and another that is on the ESX server's private network. Vmware Workstation will connect to the ESX server through this tunnel.

Machines:
1) "desktop": Runs Vmware Workstation on Debian. Exposes 172.16.1.1 on "Host Only Network" in Vmware Workstation
2) "vpn": Runs in Vmware Worksation as a Debian server. Attached to "Host Only Network" as 172.16.1.2. Also has a Bridged Connection to communicate with internet.
3) "gateway": Runs in ESX server. Has two network connections, one connection is on internet, and one is on the ESX server's management network.
4) ESX server: Our target. management network ip is 10.1.1.1

Illustrated:
Vmware Workstation --connectsTo--> vpn --tunnelStart--> gateway --tunnelEnd--> ESX server

There are two reasons why I'm using the "vpn" machine. One is that 3 common ports (443, 902, 903) are required for the forward. My desktop machine has those allocated, and it would be very inconvenient to move them. The second is that Vmware workstation will not connect to an ESX server at "localhost" because it is trying to run its own internals on those same ports.

Lets add a command line interface so we can login to the "vpn" machine. On my desktop, I've set up my .ssh/config file thus:
Host vpn
HostName 172.16.1.2

I've also added to my hosts file:
172.16.1.2 vpn

On the "vpn" machine, I've added an entry to my hosts file to speed up log in (avoid dns lookup):
172.16.1.1 desktop

That gives us a nice connection to our "vpn" machine. Test it with:
$ ssh vpn

Now, we setup the connection to "gateway" from "vpn". We need to use privileged ports (443, 902 and 903 which are all < 1024), so we'll have to setup this tunnel as the root user.
$ sudo bash

Modify /root/.ssh/config on "vpn"
# Access to ESX server
Host gateway
HostName gateway.publicIp.or.dns.here
LocalForward 172.16.1.2:443 10.1.1.1:443
LocalForward 172.16.1.2:902 10.1.1.1:902
LocalForward 172.16.1.2:903 10.1.1.1:903

You can then exit root access and try to login
$ sudo ssh gateway

Now, go back to Vmware Workstation
File > "Connect to Server..."
Server name: vpn
User name: "your esx username"
password: "your esx password"

You should be good to go now.

This can be done on windows as well with putty with this guide on mediarealm.com.au by Anthony Eden.

Know-it-all: "Hey God! Make a rock so big you can't pick it up."

God: "***OKAY***"
God turns ENTIRE Universe to rock.

God: "***There is no more up.***"
Somewhere in middle of rock is stone likeness of deceased Know-it-all.

-- Daniel Bower

Unfortunately, this isn't straightforward. Here is a question/answer from stackoverflow that may help.

A nice guide on how to verify the key you have for an ssl cert is the correct key is available from the University of Wisconsin