Day 6 without power in Lansing, Michigan

Le sigh. The same street intersections are being worked on for the past 4 days with one addition.

From yesterday:
Haslett / E. Saginaw
Willow / Waverly
Mt. Hope / MLK
Mt. Hope / Pleasant Grove
University / Grand River (E. Lansing)
Delta River / Grand River
Creyts / St. Joe
Tecumseh River / Grand River

From today:
Pleasant Grove/Mount Hope
Saginaw/MLK
Fairview/Heights < -- new Harrison/Lake Lansing University/Grand River Delta River/Grand River South Creyts/Saint Joseph Techumseh River/Grand River

Home > Advisory
Power Outage Update:

As of 5 a.m. Friday, Dec. 27, there are approximately 2,600 customers without power in the Lansing Board of Water & Light service territory, down from 3,000 outages Thursday at 10 p.m.

The current outage number represents less than 3 percent of BWL’s total customers without power. At the peak of the outage earlier this week, nearly 40,000 customers or 40 percent of BWL customers were without power

The BWL is projecting that fewer than 1,000 customers will be without power by the end of this Sunday, Dec. 29. The remaining outages are expected to be restored next week and reflect single homes with downed lines or small pockets of outages.

In order to assist the BWL to restore power to homes and businesses with downed lines, customers should please note the following:

BWL power lines

Lansing Board of Water & Light
connect to a home or business at the vertical pole or “mast” on the sides buildings, or “house knobs” – those little knobs attached to the building. If the mast or house knobs are damages or down, it’s the customers responsibility to hire an electrician to repair the items before the BWL can reattach the power line to the building. The meter – which records the amount of electricity used – is BWL equipment. The meter is the BWL’s responsibility to maintain or repair. Go to www.lbwl.com for more information.

Line crews are worked Thursday night to restore power along circuits in areas reflected by the following street intersections:

Pleasant Grove/Mount Hope
Saginaw/MLK
Fairview/Heights
Harrison/Lake Lansing
University/Grand River
Delta River/Grand River
South Creyts/Saint Joseph
Techumseh River/Grand River

Hundreds of downed power lines remain to be repaired. Residents are urged to stay 25 feet away from downed wires. Downed power lines are being prioritized for repair based on public health and safety facilities and circuits with the highest number of customers without power. BWL and other municipal utility crews will continue to work around the clock until all customer power has been restored.

The Board of Water & Light is aware of its outage areas. Residents can report a down power line by sending an email to custservice@lbwl.com, or by calling (517) 702-6006 or toll free at 877-295-5001. Residents may also post a downed line message on the BWL’s Facebook page or on SeeClickFlix. Please note that due to high call volumes, you may experience a busy signal and/or long wait times.

Share Button

Day 5 without power in Lansing, Michigan

The good folk at Consumers Energy and Lansing Board of Water & Light along with hundreds of linemen from around the US and Canada are working around the clock restoring power. There is hope yet for restoring power today! 🙂

Power Outage Update:

As of 5 a.m. Thursday, Dec. 26, there are approximately 4,400 customers without power in the Lansing Board of Water & Light service territory, down from 5,700 customer outages last night.

Line crews are working today to restore power along circuits in areas reflected by the following street intersections:

Pleasant Grove / Mt Hope
Haslett / E. Saginaw
Willow / Waverly
Mt. Hope / MLK
Mt. Hope / Pleasant Grove
University / Grand River (E. Lansing)
Delta River / Grand River
Creyts / St. Joe
Tecumseh River / Grand River

Hundreds of downed power lines remain to be repaired.

Lansing Board of Water & Light
Residents are urged to stay 25 feet away from downed wires. Downed power lines are being prioritized for repair based on public health and safety facilities and circuits with the highest number of customers without power. BWL and other municipal utility crews will continue to work around the clock until all customer power has been restored.

The Board of Water & Light is aware of its outage areas. Residents can report a down power line by sending an email to custservice@lbwl.com, or by calling (517) 702-6006 or toll free at 877-295-5001. Residents may also post a downed line message on the BWL’s Facebook page or on SeeClickFlix. Please note that due to high call volumes, you may experience a busy signal and/or long wait times.

Share Button

Start of Day 3 without electricity in Lansing, Michigan

For those of you that don’t know:

As we’re all aware, a portion of the greater Lansing area is without power to homes and businesses as a result of the storm that moved through this past weekend. To help provide shelter to those impacted, the following locations have been established as warming centers. Please share this information with your colleagues, friends, and family who are without power and need a place to warm up, charge their electronics, or grab a cup of coffee.

• Haslett High School – Located on Marsh Road just south of Haslett Road.
• Meridian Christian Church – Located on Bennett Road just west of Okemos Road. Open until 6 pm this evening.
• Trinity Church – Located on Dunckel Road just south of Jolly Road

You can look at the outage map:

Consumers Energy Outage Map
Share Button

FW: Hardening the Oracle 11g Database – Initial Steps (Kevin Sheehan)

Kevin Sheehan wrote how to harden the Oracle 11g RDBMS. I highly recommend it:

TheOracle following is a basic set of hardening guidelines for an Oracle 11g database along with some scripts you may find useful. This list is by no means complete. It does not cover file permissions, authentication controls and user profiles, encryption, grants or auditing but it is a good place to start.

Or perhaps takes Slavic’s advice from his comment on this post and start with Oracle’s Checklist for Database Security. It gives a broader, though perhaps less detailed view, and covers some of the topics I have left out (for now). Also check out Slavik’s Musings on Database Security Blog.

Read more on Kevin’s blog.

Share Button

HowTo: List locked, expired and to expire dates for Oracle logins query for sqlplus/scripting

Oracle

set pagesize 5000
set linesize 999
set trimspool on

column "Expire Date" format a20
column "Locked Date" format a20

select 
    gn.GLOBAL_NAME as "Instance",
    du.username, 
    du.expiry_date as "Expire Date",
    du.account_status,
    du.lock_date as "Locked Date",
    du.profile,
    dp.limit as "Profile Password Expiration"
from dba_users du, global_name gn, dba_profiles dp
where (du.account_status IN ( 'OPEN', 'LOCKED' )  OR du.account_status like '%EXPIRE%')
  and du.profile = dp.profile
  and dp.resource_name = 'PASSWORD_LIFE_TIME'
order by du.account_status, du.expiry_date, du.username

Updated to show which login profile is being by a user and what the password expiration interval is per the login profile.

Share Button

Connect to Microsoft SQL Server (including Azure instances) from Linux (x86/x86-64) using ODBC and JDBC

Connecting to Microsoft SQL Server from Linux can be done through two different methods: ODBC and JDBC. Unfortunately, FreeTDS doesn’t connect to the newest versions of SQL Server unless you want to enable legacy connections.

The Microsoft JDBC Driver 4.0 for SQL Server, a Type 4 JDBC driver provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5 and 6.

The Microsoft ODBC Driver (Linux) For SQL Server provides native connectivity from Windows to Microsoft SQL Server and Windows Azure SQL Database on Linux.

Share Button

Perl: Error “local: not found” from PerlBrew when running older BASH versions or compatible shells (Korn / ksh) SOLVED

If you’re getting the “local: not found” error when running PerlBrew, we have the answer 🙂 The problem is that “local” doesn’t work in older versions of BASH or some other shells you might be using. You simply need to replace “local” with “typeset” in your ~/perl5/perlbrew/etc/bashrc file. Note that whenever you run “perlbrew init” or update the script, you will need to make the change again:

$ perlbrew use perl-5.8.9

A sub-shell is launched with perl-5.8.9 as the activated perl. Run 'exit' to finish it.

/home/wdc1212/.kshrc[13]: .[36]: local: not found [No such file or directory]
/home/wdc1212/.kshrc[13]: .[37]: local: not found [No such file or directory]
$ diff ~/perl5/perlbrew/etc/bashrc.old ~/perl5/perlbrew/etc/bashrc
36,37c36,37
< local code="$($perlbrew_command env $@)"
<     local exit_status="$?"
---
>     typeset code="$($perlbrew_command env $@)"
>     typeset exit_status="$?"
67,68c67,68
< local exit_status
<     local short_option
---
>     typeset exit_status
>     typeset short_option
$ perlbrew use perl-5.8.9<a href="http://perl.org"><img src="http://froebe.net/blog/wp-content/uploads/2010/02/perl-276x300.jpg" alt="perl" width="276" height="300" class="alignright size-medium wp-image-1207" /></a>
$ which perl
~/perl5/perlbrew/perls/perl-5.8.9/bin/perl
Share Button