ENDJOBABN: September, 2009 archives

ENDJOBABN:

September, 2009

Sep 19 2009   2:22PM GMT

Rocking the Boat - Part 1: Preview



Posted by: Steve Pitcher

I’ll be doing a few things on Wednesday, September 23rd that will surely provide blog content.

  • Updating Domino 8.0.2 to 8.0.2 Fix Pack 2 on our System i as well as our Windows server that hosts our Blackberry Enterprise Server.

If that goes fine (hey, it’s a snap!):

  • Installing a new Domino server instance on System i.
  • Installing Quickr on System i.
  • I’m going to try really hard to get up to date on PTF’s as we’re about a year behind.  Not too bad, but it should be done soon.

This machine hosts two 24×7 companies so it’s not often I get to shut her down, open up the hood and tinker about.  I’m going to make the most of it.

Stay tuned.

Sep 19 2009   2:03PM GMT

Automatic Software Key Installation



Posted by: Steve Pitcher

I came across these instructions I posted a few years ago.  It’s still relevant and beats the heck out of typing in your software keys.

 http://search400.techtarget.com/tip/0,28…


Sep 3 2009   3:36AM GMT

Your vendors DON’T need QSECOFR authority!



Posted by: Steve Pitcher
AS/400, qsecofr, authority, iseries

Well, 99% of the time they don’t.  They probably don’t need any special authorities either.  Here are a few examples of vendors trying to break the rules.

XYZ Software

I’m working with a new application vendor (we’ll call them XYZ Software) and they need access to our system to do some custom programming and software configuration.

Here’s what they asked for right off the bat:

1. Telnet port opened up on our firewall in order to access our iSeries

2. A new user profile with QSECOFR authority.

Well, the 1st request wasn’t going to happen…period.  We use other methods to allow external parties secure access to our network.

The 2nd request I would allow only if the vendor could supply detailed reasons why they would need such excessive authority.  As well, this profile would most certainly be audited.  Not surprisingly, what they need to do (restoring objects to the XYZ software libraries and compiling programs) doesn’t require QSECOFR authority at all.  Actually, it’s not even close.  In reality the XYZ profile would just need proper access to the XYZ library in order for them to compile programs and restore objects to that library.

Vendors attempt to gain much more authority than they need in order to minimize your IT staff getting in their way in the future.  They don’t want the hassle of asking for authority to a command or a library so they go for broke and tell you they “need” QSECOFR authority.

ABC ERP Software

Another vendor I’ve dealt with, I’ll call them ABC ERP Software, really gets away with murder in terms of going against industry security standards.  I’m sure I could make a fortune going to their customer sites and plugging the security holes, but that’s another story.

ABC Software, sadly, was given a profile called ABC which was a copy of the QSECOFR profile.  Let’s say it was somewhat “needed” at the time as they were given the entire task of setting up a new iSeries server, restoring licensed programs, installing ptf’s, etc., so we let it fly.  Once we got the new ERP up and running I wanted to scale that profile back to a less dangerous set of authorities.

This vendor had a fit.  I was told by their Senior iSeries guru in a very curt email that if I changed anything about the profile then the ERP system would fall apart at the seams.  I called his bluff and asked how and why each special authority was needed.  He then displayed either true ignorance towards system security or a barrage of BS that would silence most iSeries techs afraid stand up to the scary senior analyst.

I was told the ABC profile needed *SERVICE and *JOBCTL special authorities to run a STRDBG command.  Untrue!  To debug a program, you only need *change authority to the object.  If you don’t have *change, you need *use on the object AND *service special authority.

Also, they wanted *SERVICE so that they could access the System Service Tools.  No thank you.

I was also told that they have to have *SPLCTL as they “need” to view all user’s spooled files.  Again with the “need.”  Sure buddy.  On our payroll server.  Right.

In the end I successfully debunked the necessity of 5 of the 8 special authorities ABC company wanted, including *ALLOBJ.

A few months later this “guru” stated that any user that wanted to use Fax/400 needed to have *SPLCTL.  Also, I remember him stating that all users should have their MAXSTG set to *NOMAX to compensate for the lack up garbage collection in their ERP.  You see, they have a GUI spooled file viewer that creates temporary PDF files in QDLS…but these files would stay there forever. Unbelievable.

Always question anyone who doesn’t have a vested interest in your company.  You hold the responsibility for the security of your system, not them.


Sep 3 2009   12:28AM GMT

System/Message Monitoring on the AS/400



Posted by: Steve Pitcher

I’ve submitted an article that’s hopefully going to be published in System i News magazine in the next little while.

The article focuses on how to use Management Central to perform just about any kind of monitoring for messages or system events and how to alert administrators about them.  Once the article is published I’ll post the link here and discuss any questions you may have.   I believe you have to register at systeminetwork.com in order to view their issues online.  It’s a great magazine, so I’ll suggest you join up as it’s a great resource for all things i.