HTTP_Request(2), Tough Times & Band To further the research in db2sql. I actually found built-in PHP modules for DB read access. So I could have in actuality written something to deal with the dbf files. It does not provide access for "note" fields, which is a rather important piece of information in the data set. It was a neat look inward, but it turns out this way is just easier. In developing this utility, I kept in mind future possibilities of others someday using it, so i could not create something specific to our in house setup. I wanted an easy way to push the converted SQL file up to the web server, but also know some things. Oh ... and lets not forget securely. This is when I discovered the PEAR module HTTP_Request, and HTTP_Request2 (rewrite in PHP5 class structures). Nifty little libray that implements the HTTP protocol. You can add GET / POST vars, and all sorts of other HTTPish things. I won't ruin your fun, but I do recommend you check it out here. This will come in handy for some other intranet features planned, like auto logins to all the different portals for staff. So they can just store username / passwords, and click a link to log them in. It supports basic auth, not sure about NTLM portals or anything. I have not investigated much.

So over the past few months, it's been some tough times in the industry. I'm not in a hot seat (AFAIK ... knock on wood). I have seen companies, and people I know around me close shop, lay-off, trim down. It can be a very stressful time for some. I've been lucky with some of the gigs I have been involved with over my career, that I'm fairly stable for now. My gut feeling is this will continue to be unstable for another 8 months or so. At least the end of the year. Not catastrophic, but up and down. If you have something going right now, I suggest you hang onto it.

Aside from work, all my spare attention has been on band. Our first contest was last weekend in Moose Jaw & Regina (Moosgina ... haha). We won 3 of 4 events over the 2 days. We won all 4 drumming events! It was my first contest and trip with the band (although I've played with and known several members for several years). I was personally extremely happy with my performances. As a group we all felt we could have performed better, leaving some of our better plays in the tuning circle, or at the legion in Calgary. That can only mean better things for us though. I did have some terrible back problems on the Sunday though. I could not even stand up straight that morning. There was no way I was going to let everyone down, and not play. So carefully (and frequently) timed intake of painkillers, and muscle relaxants. Along with leaving the drum off as much as possible, oh and a last minute back massage from Katey MacLean who is a massage therapist, I pulled it off. I was really proud of that. It's kinda like the NHL playoffs. Play through the pain, and do whatever it takes. we had this Thursday off from practice, but I'm kind of itchin to get back to it.

It was nice to go home, and spend time with family. Saw Ted & Tammy, hung out with Diana, and met her boyfriend Bill. Mom, Diana + Bill, Dolly + Scott watched me perform in MJ. Mom said it was the best band I've ever played with. Saw Kevin B, and Breanne for a while. I headed back later on Tues, and then took a few days off to recoup. Just moved everything from the car in on Fri, still not quite unpacked (but almost), and laundry is _almost_ done. I know I'm slow, but pffffffffffffft. My sis phoned my on the weekend, apparently shortly after she was in a car accident. She rear-ended someone, when her dog jumped and distracted her. Poor Diana, poor Georgia. She'd only had the car for a month. 2009 Corolla Sport. Ooops! At least she is not hurt.  ¶ 1:27:00 AM 0 comments

  db2sql, download quotes & the brier So really working on the Power Broker to Toolkit integration last week. Jeff did a bunch of the leg work, and produced a dump of the dbf file with a utility from whitetown. They seem to be dbf conversion specialists. Handy tools they provide. We switched to the conversion directly to Postges SQL format, instead of CSV. So now it is a direct import. I ran into a couple of small issues with escape characters, and how close to the SQL spec PG is with regards to string literals. I now have a working script that sets the proper options, and the right sequence of events. Also converts the encoding of the data to UTF-8. Which is required for the import to work properly. Onwards and upwards.

I also spent some time back in the world of bikes. I changed some of the navigation, and added some options to download a copy of the quote in PDF or email it to your address. Didn't take too much effort. It's nice to have handy libraries like FPDF. I also did some quick work with jpgraph for some of the statistics pages to get them going. Again ... nice to leverage existing work.

So the brier was in Calgary a couple of weeks ago. I had some tickets. I caught 1 draw, and our party never made it back from the brier patch for the evening draw. Ian, Scott, yaz and myself. TOTALLY SHITFACED! We were all gong-show drunk. It was such a great night ... well ... early night as it was. Kinda funny that happens when you start drinking at 2:00 P.M. Cheers to the Brier!  ¶ 1:22:00 AM 0 comments

  Romanians, Toolkit 3.0 & Alabama Slammers Back up a few weeks. Craziness ensues! So I was not even back from Montreal for a whole day before the crapola hits lots of different fans. :( We had some typical SPAM problems, although 350,000 SPAM messages from a single source is not really "typical". Yeah that took like 4 hours to clear up. Added some extra postfix options, but they still need a policy server to control the connection / bandwidth limits properly. Or something else entirely. Nothing heard since, so I am guessing it's all good.

Immediately following that debacle. I ended up dealing with a compromise. A pretty nasty one at that. I was shown some of what was going on after the fact. Some nasty passwords recording in clear text. Box was completely owned. Someone else was tracking them down outside the box, following them in IRC channels etc. Turned out to be some Romanians (not that I have anything against Romania ... that's just where they were from). Translate the IRC chats, and they are talking about Bank accounts, and Credit Cards. Some nasty folks. Box is since rebuilt, and deployed.

Right around this time is when I discovered OSSEC. Sweet IDS. Easy to install, nothing to configure, but insanely extensible. XML configs, and crazy options. it alerted me the other day when the # of log entries in mail.log, increased over the average entries for a time span. WOW ... that's what I like to see from an IDS. The active response to block IPs under certain conditions is really nice to see as well. Brute force on SSH ... See Ya!

So during, and after all of that craziness. We released the first Toolkit 3.0. Kevin and I were there all Sunday until the afternoon Monday. Do what you gotta do. It went exceptionally well considering the gravity of the changes. Of course there is some small noise from things, but nothing major. We were all quite pleased. So now we are onto 3.1 development. We have moved to roughly 2 month release cycles. So Early May is planned for 3.1. We are adding the "Opportunities", "Power Broker Data Integration", and some distribution changes. There's soo much needed to be done, and some things are simply going to be pushed back to 3.2

...
time passes
...

Looks like I forgot I had started a draft. :S oops.

I'll sum up this blog with my recolection that Jack Ass sized Alabama Slammers @ Jack Astors are super yummy, they taste like cool-aid, and when you pound back like 4 or 5 in the time the rest of your party has 1 drink ... you tend to get a little smashed. I'll just end on that note.  ¶ 9:24:00 AM 0 comments

  day2, night 3, day 3 MONTREAL! ... ctd. (Jan 20 / 21 - 2009)

So it turns out the next day that "ish" was not allowed in the morning. of all times we required 10:00 (ish), that was changed to 9:30 A.M. so AJ could meet with Serge (#1 ... that's also important later). Serge #1 was meeting with some other people we knew and wanted to speak with AJ before he left. So up we get, and Scott was understandingly a little sluggish. I was also wondering about the egregious amounts of snacks ground into the carpet of the hotel room. I could just see the boys last night : "mmmmmmm ... trail mix". Scott was like ... when did we get trail mix? I just laughed. I remember him disappearing when we got back, and walking in later with handfuls of things bought from the front desk.

On with the day. More "Follow Anouk". She had some very school girly business suit, with stockings and I remember she was very sassy! Well done! We lined up a meeting the day before with Serge Pronovost (Serge #2). We talked about boats. It was a _fantastic_ ... not fantastique (that's later in the night) ... fantastic meeting. It was exactly what we wanted. Serge was all business, in and out. He had a list of 6 things he wanted. Don't screw me, and I won't screw you ... shake the hands, and we're off. Great meeting, followed up with a great coffee, and some shmaggers (smokes) downstairs. Waited around a little bit for lunch. We went to the same Italian restaurant next door that we had been to in the past. We had lunch with Brigitte, and talked about everything with bikes. She had some requests, we had some questions. Everything is in the notes. AJ and I argued ... the good argue ... not a bad one. If forgot about the waiter. Turns out it was a kid who is from Estevan Saskatchewan. We started into the typical SK conversation. He might know a couple of people I know from Estevan. It was a strange coincidence.

So after lunch was finished up with Jevco for our trip. We said goodbye to Serge. He got called back into the doctor to look at his elbow, which was broken. Nothing they can do for him. AJ showed him the calendar pictures from the L&Y Beefcake calendar. I'm not sure if that made Serge feel better or not. Scotty tried get a Jevco cup, Anouk failed in her attempts to acquire one. She walked us out. Kiss Kiss (both cheeks). What a great business trip! Now onto the fun.

We took yet another scary cab ride back to the hotel. Stops for supplies, and then kick back and relax. Scott decided he wanted to take a nap. AJ and I sat in the common area and get right into the drinks.He had monster beer, and I was into the rye. Somehow we killed a couple of hours, and then Scott was awake and ready to go. We kept on the drinks, and decided we were going to hit "Solid Gold". So we cabbed it there. It was a little bit of a journey. We passed a road rage scenario, and then we were at the club.

When we arrived it was really early, and pretty dead at about 6:30. We sat on an elevated level in the comfy chairs. Our waitress could barely speak a lick of English. She apparently just moved to Montreal 2 days ago from Quebec City. So that lead to some interesting communication. We watched some of the girls dance, it appeared to be a shift change. There was this old guy who we saw disappear for hours at a time upstairs for private dances. Then the hockey game came on. Solid Gold has a deal where during the Canadiens games, if the habs score everyone gets a free shooter. If they win the game you get a free drink. They lost the game, but we had 3 free shots.

So after being there for a while. I met a girl named Nancy. She was from Montreal all her life, but could speak English very well. She said her school was bilingual, and it was just like that for her. So we went upstairs for a while. I can not release the private details. ;). She was kinda sad as her and her BF were on the outs, who also worked there, and it was "uncomfortable". We had a good time. I came back down, and we hung out for a while. We continued to step outside, and smoke, and have drinks. We order some food. Which turned out to be a big mistake ... for me anyways. It was great at the time, but food at a strip club ... no-no. We continued with the drinks and action. On a smoking trip I was not part of, some other guys who were there for every mtl game were telling AJ and Scott about how one girl was giving him a blowjob the night before, and stole his Iphone. He noticed it in her stuff later, and they busted her for it. Apprently she was there again earlier that night. Crazy tales.

So after a while this girl who looks like Jenny McCarthy comes and sits beside me. Shorter, and bigger boobs, but she was a Jenny! She's like "Hi how are you? Would you like me to dance for you?". Why yes ... yes I would. After my stint with Nancy I said to myself, alright enough dances, you spent your money, had some fun, all is good. That went right out the window with Crystal. Without giving away the details again. WOW! Holy Frack! I had to go or I'd be broke. I came back down. I remember AJ calling his wife, and was like "Hey honey, at the strippers, thinking about you". haha. I was sitting for a while, and then I realized I was not feeling good at all. I eventually went outside and found AJ and Scott talking with a couple of girls in the smoking hut. They were learning how to say french words for window, and floor. I sat with them, but was kinda out of it. I was really not feeling good. I needed to go. I said to them I was needing to go, and was leaving. AJ was like ... can you wait for like 20 minutes (which really meant like an hour) ... I was like ... no ... I think I'm going to puke on your shoes. His eyes opened, and he was like ... OK ... I get it. I said just stay ... I'll see you back at the hotel. And I left them. During the cab ride, my problems shifted their position to a little lower than the stomach. Could not get back to the hotel fast enough. Then my room key wouldn't work, and finally I got into the bathroom, and after I was somewhat relieved I crawled into bed. AJ checked on me when they got back. It's nice to have friends who care. :D

Scott got one of the girls "Lilly" to sign a card for Ian back in Calgary. Ian was famous to everyone there, cuz we kept telling everyone about him, and how he couldn't make this trip. Ian appreciated the present. It was a good laugh. The next morning was rather quick. We checked out, and headed to the airport. The flight was fine on the way back. We arrived in mid afternoon, and Ian picked us up. Dropped us all off, and that was the end of another French Adventure! Can't wait for the next one!  ¶ 11:54:00 PM 0 comments

  night 1, day 1 & night 2 MONTREAL! (Jan 18 / 19 - 2009)

So I drove down to AJ's and left my car there. The sponge bob coffee mugs I got from them were AWESOME! Robyn came and picked us up, we went and found Scott in his green (They are not green) condos and off we went. The flight down was alright, watched some TV, and "Hustle and Flow". We arrived around 12:30(ish) ... ish is important on this trip. Caught a cab to downtown. We discovered (again) that beer is sold at 7/11 and grocery stores, but not after 11:00 P.M. So we were out of luck. Checked into our hotel on Lincoln ... no one ever knows where Lincoln is. The joke of each trip. Crashed it out, and our trip had begun.

Our arrival was scheduled for 10:00 (ish). We got going in the morning, and had a totally scary cab ride to Jevco offices. Anouk greeted us and the adventure for the day was "Follow Anouk". That's what we did ... follow Anouk. We dropped some gear off, and began to separate. I had the morning to spend with Brian Harper. AJ and Scott met with Lisa Carbone. Time flew past and before I knew it Anouk was back ready to take us for lunch. AJ had lunch with Serge across the street at some restaurant that no one else seems to want to eat at. Apparently it is like the second best place for smoked meat in Montreal (next to Schwartz). We had lunch at cafe Solaris. It was one of Brian's team members birthday. So we had some shots. What a nice start to the trip. More meetings in the afternoon. AJ and I met with Dino Fontes, Scott met with Brigitte. We caught up with everyone later. Our brains were so jam packed full, we decided to call it a day, and take another scary cab ride back to the hotel. Stop for alcohol along the way.

Anouk was picking us up around 5:30 (ish). We had a few drinks, and when she arrived, we all headed down to crescent street. We hit a pub called Brutopia (right next to Hurleys). AJ had the Rocket Fuel, and we had a few (ish) rounds of shooters. The waitress brought me the rest of the shooters mixed when we were leaving in a glass ... alright ... let's shoot that as well. We headed off to a restaurant that ended up being closed. Stopped by the Bell Center for Scott to organism over the statues of Rocket Richard, and John Belliveau(sp). I continued being drunk in the car. I don't even know the name of the place we ended up (somewhere in old Montreal). It was a great place. Apparently the wine was excellent. I continued on the Rye and gingers. no shots, but the drinks were pouring smoothly. During the conversations we determined that the world requires a new website :http://www.whatsanoukgonnacook.com. AJ didn't even realize what he said, until we were all roaring in laughter. Finished the meal, and we were off for more escapades. Back to Winston's (our old haunt ;)). Winston's is the only constant in every Montreal trip AJ and I have been on. We had a short discussion with Anouk's fiancée on the phone ... drunks are always entertaining. The place was pretty dead "It's Monday!". So we sat at the bar. Our waitress, Tanya, not Tonya, was exceptionally beautiful ... and a total blast to boot! The drinks kept coming ... in a quicker fashion. Yagger bombs, Sicilian kiss shooters, ryes, beer, and Scott was on the double gin and tonics. The conversations were great, and we were having a blast. Anouk left us there ... then things started to derail. Scott was having popcorn containment issues. Every time he grabbed for the popcorn, more landed on the bar and floor than in his hand. We also had the drunken idea to talk to Anouk again. She can receive text messages, but can not reply (some company restriction). So we all started prank texting her. I got in a fight with Scott and was going to jail, Scott had aids, AJ didn't know what to do ... on and on. Yeah ... drinking is fun. We had smokes with Tanya on the patio under the heat lamps, and continued to bond. She says to Scott near the end of the night "I'm impressed by you, you can really hold your liquor". She turned around and not even 2 seconds later he bit it, and fell down on the floor. Me and Age were howling, uncontrolled laughter. Tanya leans over the bar and says "I take back what I said". At this point in the night we had a decision to make. Back to the hotel, or continue an adventure down St Catherine's Street. We opted for home, and thank God we did. AJ and Scott discovered microwave kraft dinner, and other munchies in the lobby. We all crashed out ... good thing we said we would arrive at 10:00 (ish). Good day 1.  ¶ 6:16:00 AM 0 comments