Paul's Journal

06/13/2009 00:32 #48920

Upside down photos from iphone 3.0 paste
Category: mobile

I was so excited that you could copy and paste more than one picture into an iphone 3.0 email. But unfortunately, they come out upside down.

In gmail, the thumbnail looks fine but the actual image is upside down. This only happens when the image is copied from my gallery and pasted into an email. Argh. Hopefully, they fix that before the real GM?

Quartz does interpret it properly but here is the image, directly transfered from the iphone, dragged to firefox. I image that will be a problem for a lot of people.

paul - 06/13/09 10:26
It's weird that it's only when copied. Normal send photo via email works.

zobar - 06/13/09 10:08
Check the Exif data on the original image - I bet the Orientation (0x0112) is either 90Â°cw (0x0006) or 90Â°ccw (0x0008). iPhone saves the JPEG file with (0, 0) at the top-left relative to the phone, and the rotation of the phone itself in the Exif data [I believe other cameras do this too]. Quartz interprets the Exif data, but IJG's libjpeg does not.

:::link::: p.36

- dpk

06/12/2009 23:01 #48915

Twins birthdays

My dad and my uncle had their birthday today. Here they are with a
yummy Oreo cake. My mom also got cherries. It was the first of the
season. They were only $2.99/lb at tops. I wish we had a cherry tree
so bad. I would trade half the pears for cherries.

tinypliny - 06/13/09 17:58
Man, I am so dumb I didn't even notice the title! *embarrassment*

tinypliny - 06/12/09 23:18
Are they twins?

Cherries were $2.99/lb at PriceRite as well.

06/12/2009 22:55 #48914

Mistakes

It all works now and we have a hose in the backyard. I think we might
finally be good at soldering.

06/12/2009 12:27 #48895

American lunch
Category: food

Before you condemn me, its all organic even the hotdogs. I was in the mood for a red white and blue lunch.

paul - 06/12/09 16:32
Not just olives but garlic stuffed olives. The whole thing was covered in olive oil and salt. I forgot to mention that part before.

tinypliny - 06/12/09 16:11
OOOOOOOHhh!!!!!!! Colourful! I love it! I like all of it (except the hot dogs of course)

mike - 06/12/09 15:48
looks yumm o to me

joshua - 06/12/09 14:53
I obviously support your patriotism, but I wonder what olives and blueberries taste like together?

paul - 06/12/09 14:32
Its american because it is red, white and blue.

hodown - 06/12/09 14:23

1 Rice is not american
2 Do you dip everything in the ketchup?

joshua - 06/12/09 12:49
Whoa. I won't condemn you but I have to ask - is this a product of just combining whatever is in the fridge? Hot dogs, watermelon, olives, blueberries, rice and a squirt of ketchup - I know you're not pregnant. I'll admit that I've been guilty of odd combinations of food as well. It seems that even a speck of ketchup on a piece of watermelon would spoil it for me.

06/08/2009 18:40 #48871

More SSH fun - tunneling mysql over ssh
Category: computers

I use ssh for port forwarding a lot. One of the most frequent uses is to allow for secure local access to a remote mysql server over ssh. In order for this to work you must have ssh accesss to the mysql box.

This is the format of the command. You must replace LOCAL_PORT and REMOTE_PORT with the ports you wish to use. Mysql is normally on 3306. Also replace user@remote_server with your login info.

ssh -L LOCAL_PORT:127.0.0.1:REMOTE_PORT user@remote_server

While you can forward directly from 3306 to 3306, lets say you already had a local mysql server running on 3306 and wanted to port foward you server's mysql on port 3306 to your localhost at port 3307.

ssh -L 3307:127.0.0.1:3306 user@remote_server

Also if you have ssh running on another port you can specify that with the -p argument

ssh -p 1506 -L 3307:127.0.0.1:3306 user@remote_server

Once you have established the connection, open a new local terminal session and type:

mysql -u YOUR_MYSQL_USER -p -h 127.0.0.1 -P=LOCAL_PORT

Enter the password and you are set to go

Make sure to replace YOUR_MYSQL_USER with your mysql user
account and LOCAL_PORT with the LOCAL_PORT you chose above, say 3306 or 3307.

If you want to have the connection debugged an not end up at the remote terminal you can add these additional arguments

ssh -v -f -N -L 3307:127.0.0.1:3306 user@remote_server

Remember to change the remote ssh port if you need it.
ssh -p 1506 -v -f -N -L 3307:127.0.0.1:3306 user@remote_server