"More SSH fun - tunneling mysql over ssh" written by Paul on estrip.org

06/08/09 06:40 - 62ºF - ID#48871

More SSH fun - tunneling mysql over ssh

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

Permalink: More_SSH_fun_tunneling_mysql_over_ssh.html
Words: 255
Location: Buffalo, NY

06/07/09 10:07 - ID#48860

Happy pride parade day

I hope the weather holds up.

Permalink: Happy_pride_parade_day.html
Words: 12
Location: Buffalo, NY

Category: random

06/06/09 07:48 - ID#48854

More pics - No relation to the last jour

Red snapper is so freakin' expensive at the coop, to be exact $30/fish. Its a whole fish. You have to clean it yourself, its not half as big as it looks in this picture. There is no such thing as organic fish - so really what is this. I could have it cooked and served to me at that price.

This bird died. Hop its not the avian flu or west nile.

People parked us in this morning and even left there car. Seriously, it makes me just want to slash their tires at this point.

Permalink: More_pics_No_relation_to_the_last_jour.html
Words: 111
Location: Buffalo, NY

Category: festivals

06/06/09 07:41 - ID#48852

Hellenic festival

we went to the Greek festival today. It's mostly a food festival.

The food is really just like Greek diner food and despite Greece being a land of seascapes, it includes no seafood. That made me sad. They even had all these historical picture of fish and fisherman.

The only thing I can think of is that the people who founded that church were mountain Greeks.

My favorite part is the loukoumi, which are also known as Turkish delights. I am obsessed with them. I decided to just learn to make them, although I bought a pack of rose flavored ones.

The really surprising parts were learning how the Greek orthodox felt about Catholics is how the Catholics feel about the Protestants. Also I learned there used to be five patriachs till the pope got power hungry. Well, at least that is their story.

On the way out the pig man christians were protesting the Greek festival with a similar furvour to the way they protest Thursday in the square. It's so weird now that they protest everything. I hope they protest the Italian festival and guidos beat the shit out of them.

This seems like a bad translation - "Our ancestor's once proved useful to humanity"

The ones in the white skirts were men.

Permalink: Hellenic_festival.html
Words: 255
Location: Buffalo, NY

Category: buffalo

06/05/09 02:04 - 73ºF - ID#48844

Being chemical bombed

This morning I was climbing in the pear tee when I heard these snake like noises coming under the fence from the parking lot behind us.

I climbed higher up in the tree so i had sight of a person back there and asked him what wad going on.

Turned out to be the noise of weed killer spray hitting the ground and draining into our garden and tortoise home. When matts babysitting the kids they play back there, and we have food plants growing there.

I am so angry that to keeps weeds off there freakin blacktop, they thought it would be cool to spray into my backyard. Matt says it's illegal without notification.

I just turned the hose on and sent the shot back in the other direction. I washed out the tortoise burrough but now I am still concerned. I wonder how often they do it.

The obvious answer is a brick mini wall. Like I don't have anything better to do.

It is like having my garden chemical bombed.

Permalink: Being_chemical_bombed.html
Words: 173
Location: Buffalo, NY

Category: buffalo

06/05/09 11:56 - 68ºF - ID#48843

Hundreds of People Moved Downtown!

This morning I was reading a Buffalo Rising article about Buffalo making a comeback

While I think Buffalo does seem to be making a comeback, one of the signs of change was "Hundreds of people have moved downtown in the past few years."

Seriously? I hope that number is wrong or you never use it as a positive statistic again. Anytime you measure the success of a fairly large downtown by saying hundreds of people have moved there in the course of several years, it sounds like you are being sarcastic.

heidi writes at 07:07:52 06/05/09 - Comment #48951: Really great critique of the Bass Pro development: :::link:::

metalpeter writes at 06:36:11 06/05/09 - Comment #48949: Bass Pro won't do it alone but it being by a waterfront that is improving will be a help. What hopefully base Pro will do it get other stores to come down down and other things to come to the waterfront area. Just think about this for a second or two The Galleria Mall ............ Now the the Galleria Mall around Christmas time..... I'm not going to say that Down Town could ever get that many people there Just for some shops, but the potential is there. In terms of how many people have started moving downtown who knows really? Yes there have been lofts and apartments built into places and there has been some growth, but if you want things you have in your hood and you move downtown then those things have to come someplace else, sorry Tops Niagara is down town to most people. I admit there are reasons I would like to live DT But the area needs more stuff to get thousands of people living down there instead of 100's well unless of course 998 people moved DT.

joshua writes at 02:27:45 06/05/09 - Comment #48942: I've been critical of BR since its inception - I've felt that it was redundant and acted primarily as an unofficial chamber of commerce for EV, in concert with EVA (another org I've been critical of in the past, but have softened on). BR has done a better job but I still feel it's redundant - it is a rare day that I find something of interest to me there. Lately I've gone just to read whatever (e:drew) is writing, to support his contribution.

EV alone has 30,000 residents - "hundreds" doesn't mean anything. I ranted to (e:james) at (e:dcoffee)'s party about along a similar theme - the Bass Pro store. The Bass Pro store is our area's marquis new business development, and they treat it as if it's as critical as getting Intel in here or something - how absurd! Wake me up when we have *real* economic progress going on here - of course Bass Pro is going to sound good when literally nothing else is going on or being done to bring jobs here. Our city's motto has been "Fuck it!" for some time.

james writes at 12:35:00 06/05/09 - Comment #48939: Why hundreds of people? Why not millions?

BR reports that millions of millionaires have moved downtown to restore the Statler tower.

They didn't cite any report or say "according to...". As such, I think they are full of shit.

And where is all this downtown development? Most new or restored housing is being built on the East side and lower West side in little suburban communities. Barf. Downtown got the Avanti and a new court house. That will pack in literally tens of new downtown residents! I am not sure what is going where the aud used to be. But a Bass Pro sure wont bring residents.

Buffalo Rising brings out the grump in me.

Permalink: Hundreds_of_People_Moved_Downtown_.html
Words: 97
Location: Buffalo, NY

Category: thursday

06/05/09 11:47 - 68ºF - ID#48842

Disco Biscuits at Thursday in the Square

We went to go see the Disco Biscuits

at Thursday in the square with (e:heidi), my coworker Sameer. It was so packed with hippies. I didn't like the song when we arrived but the music got pretty jamin by the time it ended. I can't decide if the music stepped it up a bunch (which I think happend) or if I had "beer headphones" on.

Either way it way an awesome thursday in the square. The crowd went crazy trying to get an ovation and finally after like 5 minutes they came back out. Somehow I forgot to take pictures from my phone so I stole this pic off their website for your viewing pleasure.

In general, the crowd was one of the most drugged and drunk crowds I have seen at the square but what do you expect from hippies. Then again I haven't been going as much as I used to, maybe its just like that now.

I love the four blocks of misanthropes and misguided youth that line main street, north of the venue and put on their own event. There were street performers, dancers, and of course the crazy militant christians were still there.

I realized for the first time last night that even though they are protesting, some of them probably secretly enjoy going and not just to "save souls." I mean imagine, you have the choice to protest reality at the mall, or at thursday in the square with all the people and music and craziness. Its probably the only concerts they get to "go to." okay, maybe besides Kingdom Bound but honestly I think those particular people would find Kingdom Bound blasphemous.

The best part was watching this 15 y/o inner city girl telling some adult protester that her slutty top didn't have any effect on her relationship with jesus because he forgave her.

Permalink: Disco_Biscuits_at_Thursday_in_the_Square.html
Words: 317
Location: Buffalo, NY

Category: work

06/04/09 12:29 - 53ºF - ID#48836

Working till midnight

No matter how far into the day I push my schedule I never come home on time. Today I got home now at 12:25am. Same on monday but then yesterday I left early for James' (Robert's not Jim's James') birthday so I guess it makes up and tomorrow I plan on attending Thursday in the square.

It all comes down to the fact that I really don't get a chance to program until after 5PM and then I get into a groove and don't want to stop. The time between 5-12am is when I get like 90% of the programming done and can really concentrate. Most of the rest of the day from 10:30-5:00 is documentation, meetings, politics and helping people.

Permalink: Working_till_midnight.html
Words: 121
Location: Buffalo, NY

06/02/09 09:04 - ID#48827

Seabar on Washington

We went to Seabar on washington for James' birthday. The food there is so delicious and beautiful.

The bright red one was "beef on weck" which is raw beef wrapped around rice and more beef, dipped in salt and caraway seeds. I also had marlin for the first time.

Permalink: Seabar_on_Washington.html
Words: 65
Location: Buffalo, NY

Category: government

06/01/09 02:23 - 62ºF - ID#48814

Workfare instead of welfare?

A continuation of (e:paul,48807) What about a workfare program? What if instead of paying people to stay home, we give them state job doing all the things that need being done.

Obviously, I am only talking about people who are physically capable. If childcare is an issue than they could pick child care providers out of the group and have them watch children while the parents took turns working.

I mean our society has so much stuff that need to be done, and a lot of people that "desperately want jobs but can't find them." We pay them either way, why not let society (the people themselves included) reap some benefit from the tax money spent.

Then their salaries can just show up with all the other state workers? Is that ok?

There were plenty of examples of this during the depression with public works projects.

metalpeter writes at 08:33:55 06/01/09 - Comment #48862: What (e:theecarey) says it correct. I think workfare is through the county. Maybe it could go through the state also. I remember hearing that one of the big problems with workfare was that a lot of the Jobs people could do they didn't have the education for. If you think about it that makes sense. See if they had the education then they could get a job and not abuse the system.

heidi writes at 08:31:43 06/01/09 - Comment #48861: Paul -

To give you some numbers, I need to know what kind of "welfare" you're objecting to/curious about... there multiple social programs that someone considers to be "welfare":

TANF: Temporary Assistance to Needy Families. This is the program that replaced AFDC (Aid to Families with Dependent Children) back in 1996 with Clinton's Personal Responsibility and Work Opportunity Act, which is the program that (e:James)' comment describes. As both names suggest, they're focused on kids and their parent(s). The exact program regulations and $ benefits vary by state, but it's the main program that is called "welfare"
:::link:::

Social Security (federal welfare for old people and kids who have lost a parent)
Social Security Disability (federal welfare for people w/disabilities, including HIV/AIDS)
Supplemental Security Income
Medicaid (state-administered federal health care for poor people)
Medicare (federal health care for seniors & disabled)
SCHIP (state-administered federal health care for poorer kids)
HEAP (heating/cooling assistance for poor people)
Food stamps
WIC (women, infants & children food assistance)
Title XX (funding for childcare for working parents)
Unemployment Compensation
Workers Compensation (workplace injury care)
Earned Income Tax Credit (returns earned income tax dollars to poor people)

Here's the NYS list of assistance programs:
:::link:::

In PA, the equivalent of the Safety Net Assistance program is "general assistance" and the benefit was approx. $197 per month. I'm pretty sure the recycling collectors along Allen St. make more than that.

I'd also like to contrast TANF expenditures, which in the Obama FY2010 budget would be approximately $19.3 billion with "corporate welfare": "According to the Cato Institute, the U.S. federal government spent $92 billion on corporate welfare during fiscal year 2006. Recipients included Boeing, Xerox, IBM, Motorola, Dow Chemical, and General Electric.[5]" (I don't particularly trust Cato, but it's a nice line for my purposes at the moment.)

FY2010 US Dept. of Health & Human Services budget
:::link:::
I couldn't find actual FY2008 TANF expenditures, but Bush's budget was approximately $15 billion - and let's not discuss all the "marriage promotion" activities that included.

ajay writes at 06:33:00 06/01/09 - Comment #48854: A few years ago, NYC decided that if you're physically capable of working and on welfare, then the City would require you to work cleaning up the streets, etc. IIRC, a lot of the folks affected protested. The protesters were all hefty guys who could have done the job easily; but they were protesting the fact that the jobs were "beneath" them....

I think if someone's on welfare and they're not (a) in school, bettering their sills, or (b) doing job interviews, then they should be required to do mundane tasks like cleaning up grafitti, sidewalks, abandoned houses, etc. Alternately: give preference to contractors who will take welfare people off the rolls.

theecarey writes at 04:21:25 06/01/09 - Comment #48850: Interesting, (e:jim). I forgot that many of the recipients are children only.
I wouldn't be opposed to giving them "government chores", though.
On that note (e:paul),as part of the welfare process, if an individual is physically capable of working,then they have to look for work and/or be expected to work an assigned amount of hours per month as part of being in the system, at a location predetermined for them. It could be shoveling public sidewalks, picking up garbage, clerical duties, farming, etc. So there is a workfare program in place. At first consideration, I do like your idea about childcare- choosing some qualified individuals from the mix to look over the others children (and that may already be in place?)
The amount "paid" to those in the workfare program is the absolute minimum. There are two things I am unsure on:
1. what the rate of pay actually is. It used to be much less than "minimum wage", with the idea that the individual would be better off finding independent employment that would likely pay much better. That "pay rate" may have changed to provide a minimum monetary expectation now. Anyone have data? and,
2. There has/had been much debate as to whether these people are considered "employees" of anyone, and if they have employee rights etc. Again, I haven't checked recent data to what, if anything has changed over the years. If they are still not classified as "employees" then their "wages" as per criteria would not be published based on this.

On a related note, to what degree would/does having low wage "workfare participants" benefit the state (and some private companies) more than if they hired out right workers? We may have people abusing the system, but that would also include the state and businesses that hire them- an initiative to keep people in the system, perhaps? Just thoughts..

deeglam writes at 03:07:10 06/01/09 - Comment #48847: fabulous idea.

paul writes at 02:53:11 06/01/09 - Comment #48846: James: I am curious about that plus total payouts.
Jim: I think plenty of people have additional dependents to stay on it. that is why I suggested the childcare part.

james writes at 02:45:25 06/01/09 - Comment #48845: This is from a 1994 report from the House Ways and Means Committee. Though, it would be very interesting to see more up to date information.

Race
--------------
White 38.8%
Black 37.2
Hispanic 17.8
Asian 2.8
Other 3.4

Time on AFDC
---------------------------
Less than 7 months 19.0%
7 to 12 months 15.2
One to two years 19.3
Two to five years 26.9
Over five years 19.6

Number of children
-------------------
One 43.2%
Two 30.7
Three 15.8
Four or more 10.3

Age of Mother
------------------
Teenager 7.6%
20 - 29 47.9
30 - 39 32.7
40 or older 11.8

Status of Father 1973 1992
-------------------------------------
Divorced or separated 46.5% 28.6
Deceased 5.0 1.6
Unemployed or Disabled 14.3 9.0
Not married to mother 31.5 55.3
Other or Unknown 2.7 5.5

jim writes at 02:44:13 06/01/09 - Comment #48844: If you are capable of working, and don't have dependents, you can't stay on welfare for very long already.

"About 44 percent of TANF households are not subject to federal or state time limits because they are â€œchild-only casesâ€ â€" typically, children living with a relative or families in which the parent is not eligible for benefits."

So, almost half the list would be names of children. That's not very awesome.

paul writes at 02:39:38 06/01/09 - Comment #48843: Ya, that part is true? Where are those numbers? That is kind of what I am asking for?

james writes at 02:37:38 06/01/09 - Comment #48842: But that, more or less, happens a lot already.

Last year I qualified for HEAP, food stamps, and medicare. I didn't have any of those and I worked almost all of last year except December. It wasn't for the government, but I worked like a lot of people who receive assistance do.

I think it would be important in this discussion if we had some actual facts and figures on welfare. How many people receive it, how many work, how long people are on it, etc. Otherwise this is just speculative.

Permalink: Workfare_instead_of_welfare_.html
Words: 147
Location: Buffalo, NY