Greater Lansing Real Estate

Canada Creek Ribs

I had blogged this a number of years back, but due to changes it managed to disappear from the interwebs. Back for everyone’s benefit…

Anyone who knows me knows that I’m not the cook in our family, but every so often I come across a recipe that becomes a staple. I think I found another one…

While hanging out at my college buddy’s cabin in Canada Creek (near Atlanta, MI) he made the most delicious, fall off the bone baby back ribs I’ve probably ever had. Naturally, I had to get the recipe.

Go to the store and get…

– Baby Back Ribs
– Sweet Baby Rays BBQ Sauce
– Garlic Salt
– Paprika
– Hickory Salt (I used Hickory Bacon Salt)

The morning of (or the night before), sprinkle the Garlic Salt, Hickory Salt, and Paprika on the ribs, wrap them in aluminum foil, and stick them back in the fridge.

Appox 5-6 hours before dinner, put the ribs (still wrapped in aluminum foil – I’d also suggest on a cookie sheet) in the oven at 300. Let them cook for 4-6 hours (I did 5.5).

Once they have cooked for 4-6 hours, fire up the grill. Put the ribs on the grill (no cookie sheet) leaving the aluminum foil under them (but opened up). Slather with BBQ sauce and let cook for another 10 minutes or so.

Enjoy!

DB2 Ownership Transfer

If you ever get an error in DB2 along the lines of…

SQLCODE=-727, SQLSTATE=56098, SQLERRMC=1;-551;42501;MARKJ|EXECUTE|XX.PROC_P

…but in your code are executing the proc as another user (say “USR1”) instead of MARKJ, it may be that MARKJ created the proc and until recently still had the necessary access for executing everything in XX.PROC_P. Subsequently permissions were “fixed” and now stuff starts blowing up all over because MARKJ no longer has access. How to fix? Well, like all things I’m sure there are a million ways to do it, but the easiest in this situation was to have MARKJ transfer the ownership on everything he owned. To determine that, the following SQL was run to generate the commands, then the commands were run…


SELECT 
CASE ROUTINETYPE WHEN 'F' THEN
    'TRANSFER OWNERSHIP OF FUNCTION  '||
    RTRIM(ROUTINESCHEMA)||'.'|| ROUTINENAME ||
    ' TO USER DB2DBA PRESERVE PRIVILEGES; '
ELSE
    'TRANSFER OWNERSHIP OF PROCEDURE  '||
    RTRIM(ROUTINESCHEMA)||'.'|| ROUTINENAME ||
    ' TO USER DB2DBA PRESERVE PRIVILEGES; '
END
FROM SYSCAT.ROUTINES 
WHERE OWNER = 'MARKJ' 
WITH UR;

Weekly Challenge 9: Stretch

Weekly challenge 9 will be structured slightly different than previous challenges. Because I’m trying to reduce the number of apps and things to update as well as to schedule things on my calendar, I’m dropping my personal use of coach.me. That said, if it works for you please keep using it to motive yourself!

This weeks challenge is a simple one, but one we probably all forget about. I want you to simply stretch every day. From what I’ve read our bodies start to tighten up as we get older and that can lead to other problems or at least make them worse.

So add stretching to your habit tracker, calendar, or task list of choice. If you still want accountability or to chat, just use this blog’s commenting features.

We Believe

There’s no reason in today’s day and age that everyone shouldn’t have access to safe and clean water. Today I’ve recommitted myself by setting up a recurring contribution to charity:water. Will you join in? Donate today.

It’s Time to Grow Up and Figure this Out

“These are weapons of war”. “Nobody I know or have ever met in my entire life should have access to a weapon that can kill so many people so quickly”

OwnCloud webapp not reflecting true list of files

If you’re using OwnCloud and have a process whereby your add or remove files from directories via some sort of server process, you may find that you need to force OwnCloud to update/rescan the file listing. To do so you can manually run the following command…

sudo -u username php /path/to/owncloud/console.php files:scan --all

You may also want to consider adding it to the crontab for “username” on a daily basis.

Thanks to this site for pointing me in the right direction.

Sendmail isn’t sending to domain.com : Linux

Say you’re using sendmail to relay email on a web server that you own that’s named “domain.com”, and email is being delivered fine to any domain except domain.com. What could be the problem?

  1. Rename your server. No server should be named with an actual domain name.
  2. Change /etc/hostname to the new name for your server
  3. Update /etc/hosts to remove the domain name and replace with the new hostname
  4. Remove the domain name from /etc/mail/local-host-names
  5. Restart sendmail “sudo service sendmail restart”
  6. Restart your server “sudo reboot”

Once you’ve done that test sendmail out like so…

echo "command line test" | mail -s "Sendmail test" me@domain.com

Improved Linux command history

With four lines setup one time you can type the beginning of a command (ex: “ls”) then press the up and down arrows to see the most recent commands containing the text you typed (ex: “ls ~/scripts”) making it much easier to find what you’re looking for. To make this happen, create a text file called .inputrc in your home folder and put the following four lines inside:

"\e[A": history-search-backward
"\e[B": history-search-forward
set show-all-if-ambiguous on
set completion-ignore-case on

Weekly Challenge 8: Go to Bed!

Weekly challenge 8 is the compliment to what we were trying to achieve in the week 1 and week 4 weekly challenges.

Numerous studies have shown how important the amount of sleep we get is. It affects important things like our mood, memory, and ability to control ourselves/impulses. Take a minute to read this article by the National Sleep Foundation, this article by Sleepdex, and the info-graphic at the bottom of this post. Then, set a timer/alarm that’s at least 7 hours before the alarm you set in week 4 (which you’re still doing, right?). You may even consider setting an alarm for the amount of sleep you want plus a buffer so that you can wrap up what you’re doing or prep the next day so you’re ready to go when your alarm goes off in the morning.

Personally, I’ve come to the conclusion that I’m more of a night owl than a super early morning person so I’m getting up at 6:15. From what I can tell I need about 6.5-7 hours of sleep so that means I need to be asleep by 11:15 to 11:45 (asleep, not just getting into bed). Based on that I’ll be setting an alarm for 10:30 as a reminder that it’s time to start wrapping things up. What about you? What’s your schedule? How much sleep do you need?

To join the challenge follow this link or go to my goal page where you can find it and join in. Each day when you went to be at your scheduled time be sure to “check in” on coach.me.

Suggested Sleep Time

Weekly Challenge 7: Be Present

Sorry for the delay, so hopping right to it… Here’s to the lucky #7 weekly challenge!

This weeks challenge is all about being present in our daily interactions. About taking the time for our loved ones. Let’s start with getting acquainted with the “do not disturb” function on our phone. Look it up if you don’t know how it works. Now, everyday before you go to work and when you come home I want you to turn “do not disturb” on. Maybe even consider setting your phone somewhere you’re not going to look at it.

Don’t like that idea? Then turn off notifications. I’ll be doing a mix of the two. Might even turn off sound/vibrate on sms/messaging. The point here is to help get rid of that temptation to always be checking your phone, and it does not help if it’s always nagging you for your attention.

So, needless to say, if you have a job where you’re on-call and responsible for any sort of critical function you should either wait on this challenge or not participate (though I’d recommend waiting). Outside of that, I hope you’ll join me in giving your family and loved ones more attention.

To join the challenge follow this link or go to my goal page where you can find it and join in. Each day when you’ve ate nice and clean without any junk be sure to “check in” on coach.me.