Network Managment
You are currently browsing the articles from datapoohbah.com matching the category Network Managment.
I’ve been struggling a bit with the response time and general availability of my new host. It seems to be a problem more with the admin tools (and ftp) than the general web services.
Of course they say; “The server is fine”. So I’m looking for some good tools to prove them wrong when I can’tget to it.
I stumbled on host-tracker.com tonight and it’s pretty sweet.
It’s not fast, but the data they give you for free is pretty cool.
So yeah, currently, as in right now, the server is doing just fine.
Give it a look…
I guess it’s kind of slow if you’re viewing this from Iran or Germany, but that’s not our biggest target audience…
If you know of other good testing tools please post them in the comments.
Written by datapoohbah on April 11th, 2008 with no comments.
Read more articles on Commentary and IT and Network Managment and Utilities.
Nearly all technology companies have some sort of access control system in place. From bio-metric finger print scanners to simply proximity key cards or key fobs, maybe even the cheaper magnetic strip cards. But something is usually used to identify you and let you in or out of the building.
Generally when you start at a company they issue you this right away. After all they want you to be able to show up for work right?
I’ve dealt with these things in various flavors for years and on the back end they all pretty much suck. They are archaic, crappy applications usually still built using Visual Basic by wanna be programmers who obviously have never taken a class or read a book on computer interfaces. These applications are just terrible.
They don’t have to do much though. They also talk to some pretty unsophisticated equipment over serial interfaces, or serial equipment that has been network enabled.
The applications basically allow you to create access entries, set up time schedules and they log ‘alarms’ to a database. Hell some don’t even use a real database.
So apart from sending some binary or text to set up alarm panels, logging the alarms from said panels, any other functionality is pretty much fluff. Some might allow you to run reports though they are usually pretty poor. Most will sell you ‘optional add-on’ modules to create picture based ID cards, etc, etc. But again, I have still never seen a quality Access Control back-end package.
Now granted, the market here isn’t huge. It’s something you buy once every 10 years and maybe upgrade now and again. But that’s no excuse for publishing crap and charging and arm and a leg for it.
We’re now going to beat up on one of my favorites, KeyScan.
My biggest problem with Keyscan and a lot of companies just like them is that they take your data, yes your access and alarm data, and log it into a SQL database, MSDE to be exact, and hold it hostage.
First that’s not exactly true, you can get to it, if you use their report engine. But heaven forbid you want a report that they can’t deliver. You’re only hope then is to send in a feature request. Since we’ve had the product, they’ve only released a couple 0.x releases so I don’t see our report request as being a high priority.
Oh, and they did tell me that the can ‘Sell’ me yet another add on that will intercept the data from the controllers or alarm panels and I could take that data and put it into my own SQL database or data store.
And lastly I could run a report detailing everything and dump that via CSV and import into something else. (nice)
What they wouldn’t give me was access to the data in the already existing MSDE database, or let me redirect the application to use a SQL server that I already had so that I could (a) absorb the licensing cost of said SQL server and (b) right my own damn reports as I need and want them.
After all it’s MY DATA.
What was their reason for this? They actually didn’t have one other than, “It’s a security application and we can’t share the password that we use†As much as I tried to explain to them I didn’t want their password, only a READ ONLY username/password to the data, they stuck to their guns, “Even that is a security problem, and we’re not going to do that, everâ€
Hello? I can already (a) dump it all, so where’s the security risk? What I can’t do is get up-to-date information unless I manually dump it and re-import it every time I want to run my report.
So basically let me translate for you, what they were really saying was; “We don’t know how to do it, and if we did we wouldn’t now how to charge you for it.â€
The fine folks at KeyScan can bite me.
You deserve access to your data, and the ability to use far better tools for reporting than what they give you.
Here’s how you can do it.
Take your KeyScan System Off Line So that it’s not communicating with any devices (so it stops logging)
Backup your KeyScan Database using the utility; this should contain all of your latest data.
Then Uninstall MSDE (from add/remove software).
Then kindly reinstall from KeyScan from your CD. At that point KeyScan will see that it’s installed and prompt you to do a repair which will only reinstall MSDE.
When the install finishes it will ask you to reboot but DO NOT REBOOT.
Keyscan puts a registry entry in the system that will create the MSDE SA user and password with their utility so you need to create your user account here and now.
Open a command line and use osql to create another user in the database or MSDE environment for you to connect to using the following commands:
use osql to add a login and make that login a sysadmin, (sysadmin role has superpowers).
osql -U sa
passwd:<blank>
>exec sp_addlogin ‘admin’
>go
>exec sp_password NULL,’password’,'admin’
>go
>exec sp_addsrvrolemember ‘admin’,’sysadmin’
>go
close the command prompt and you’re done.
Finish rebooting and you should still be able to login with your created admin login using SQL 2000 tools or earlier. (basically anything you want. Create an ODBC connection and have fun) The database Schema is very easy to follow.
Everything you want is in the ALARM table.
Written by datapoohbah on September 14th, 2006 with 3 comments.
Read more articles on IT and Network Managment and The Truth Hurts.
Just when I thought I had seen it all.
We networking types, we tend to be a bit anal about some things and documentation is usually at the top of the list.
When we’re asked to come in and fix stuff one of the first things we ask is; “Do you have a network diagram?†or “Is this documented?â€
Generally the answer is no. Which is just as good, because most of the time the documentation is wrong anyway.
But when there is documentation, it comes in all forms, and just when you think you’ve seen it all.
I’ve seen:
- Really well done Visio drawing as well as really bad Visio drawings.
- Diagrams done in Raster Paint programs like Photoshop or MS Paint.
- Hand drawn or sketched diagrams that were pretty accurate and very detailed.
- I have even seen them done in ASCII or plain text, which is better than nothing at all.
But this, well, this is new. Someone was recently asked for a network diagram, and without skipping a beat, and proud as a Peacock said, yes, their network was indeed documented, and then turned over the following:
Yes, that’s it, a network diagram in Excel, clearly marking all the networks, routers, switches, etc, in great detail. It’s awesome.
Of all the tools you have available. Heck if you have Excel, you have a draw layer. People will never cease to amaze me.
Tags: network, diagram, wtf, Excel
Written by datapoohbah on September 1st, 2006 with 1 comment.
Read more articles on Funny and IT and Network Managment.
All you companies out there that write software that expires, listen up.
If your software expires, and actually ceases to function, then you better have a plan to take care of the customer when that happens.
In 2006 the idea or renting software year over year is not a new one. So when your customer reaches the end of a year and their stuff stops and they realize they need it, chances are really good that they need it yesterday.
In 1986, when the web was slow and everyone connected with 9600 baud modems and mostly used AOL, web enabled customer support was mostly manual to no existent. I understand 20 years ago why you might not be able to give a customer a new license or temporary license right away even though email still worked pretty well back then.
Actually back then you could call someone and get them on the phone so chances of solving your problem were actually better than they are today, but that's a different subject entirely.
Let me give you a clear example of how not to do things.
We use a product called MailFrontier for Spam prevention and email Anti-virus. We've used it now for almost 3 years. By all accounts this has been an outstanding product. Support has been pretty good too.
This year however, MailFrontier was purchased by SonicWALL. That in by itself should have been a sign.
Towards the end of May I got a nice marketing SPAM welcoming me to SonicWALL, with instructions for using my; mysonicwall account. The instruction read:
SonicWALL also offers a registration and management tool that gives you the ability to download updates and upgrades, manage subscriptions and track revisions. An account on www.mysonicwall.com has been created for you.
Your serial number, username and password is:
It is a pleasure to welcome you into the SonicWALL customer community. We appreciate your business and look forward to supporting you in the future.
Note how complete this email was:
SonicWALL also offers a registration and management tool that gives you the ability to download updates and upgrades, manage subscriptions and track revisions. An account on www.mysonicwall.com has been created for you.
Your serial number, username and password is:
It is a pleasure to welcome you into the SonicWALL customer community. We appreciate your business and look forward to supporting you in the future.
There was also no mention that our licenses were about to expire. You see Mailfrontier is a pretty much set it and forget it server. It works that well.
Well low and behold about 5 days after the expiration date, on a FRIDAY evening no less, all hell breaks loose. SPAM everywhere, email Viruses everywhere. If we weren't running Trend on our back end Exchange servers "just in case" we'd have been hosed big time.
First we thought, crap, someone setup an open relay. So I spent about an hour looking for that. Then I realized, that no, our licenses had expired.
So, certainly, we share in some blame here for not keeping tabs on this. But I'm going to point some fingers too.
- SonicWALL/MailFrontier: WTF? Where was my notification? We had the server properly configured to send to the administration group. We get other notices, why not a notice about licensing? Oh but there was a notice, where was it? Written to the NT event log. How nice. Everyone looks there on a daily basis.
- What about your sales department? Didn't they want us to renew?
- CDW: My Rep. You let me down man. You guys have this wiz bang software license product that totally stinks. Nothing ever gets in there right. Not even the stuff you say you automatically put in there. So it's basically useless. You'd think you'd want to sell me more software too to support your new Race Car.
So here we are on Saturday night now (the day I actually figured out MailFrontier was screwed up or expired). I figured I'd try out Sonic's world class support.
It is our intention to renew this product, and since we've been a long standing customer, the least they could do is give us a temporary 30-day key to get us going. Right?
So I open a ticket, its 10pm on a Saturday night.
I get an auto-response that says; to talk to someone call the numbers on their website, I figure they have all these global locations, someone in some time zone should be awake, why not?
So I call in and low and behold someone answers.
Sonic: Good evening SonicWALL.
Me: Holly crap, someone's there.
Sonic: Why yes, we're always here.
Me: That's good to know, I need tech support, I have spam and viruses running amuck all over my network.
Sonic: Is this a new case or an existing case.
Me: Existing, case number XXXXXXXXX
Sonic: Thank you I'll transfer you.
Me: Stunned and astonished.
Me: …Waiting…
Me: Jamming to hold Music
Sonic: Still trying to transfer you sir…
Me: OK
Me: …Waiting…
Me: …Waiting…
Me: …Waiting…
Sonic: Sir, did you know our tech support was only 10:am to 6pm ?
Me: Nope, you said you were always there a few minutes ago.
Sonic: Well someone's always here, I can transfer you into voice mail.
Me: Is that 10-6 on weekends too? Can I talk to someone at 10am tomorrow?
Sonic: No sir it will be 10am on Monday, would you like the support voicemail?
Me: I already have a 'network down' ticket, what's the point?
Sonic: A voice mail is better than that, you should leave one.
Me: OK then.
Me: Leaves voice mail explaining problem.
At that point I figure I'm hosed.
Not 10 minutes later my cell rings. It's a Tech from Sonic. He explains he listened to my voice mail but he doesn't have the ability to generate keys. A sales person has to do that. I said; "OK, get a sales person."
Tech: Well, they are all sleeping.
Me: Wake one of them up.
Tech: Let me see if I can get my manager.
Me: Look, you have all of these sites listed on your website. You guys are global, get me a sales guy in Australia, New Zealand, Italy, I don't care.
Tech: Let me see what I can do.
Me: Can I set the clock back on my server to buy me some time?
Tech: No that won't work.
Me: OK
That was the last time I heard from that guy.
About two hours later I decide to try the clock thing. It works by the way, just know that your reports will be screwed up and if your server is part of active directory, AD will reset the clock for you so you need a batch file to keep the clock turned back. Something like this:
Make a simple .vbs script name it something like date.vbs and run it in a command line by typing:
cscript filename.vbs
Script:
Set WshShell = WScript.CreateObject("WScript.Shell")
do while true = true
wscript.sleep 10000
WshShell.Run ("date 05/05/2006")
wscript.echo "date reset to 05052006"
loop
Of course kill this when you get your new licenses.
Fast forward to Monday, because Sunday Sonic support was useless.
Monday we ordered our renewal from CDW, which as it turns out doesn't buy directly from SonicWALL, so getting our keys today still might not be possible.
Again, the yahoo's at Sonic don't seem to get it. I get another email from them asking me to open a case so they can help me.
We've been on the phone now for two hours today (Monday) and still we've accomplished nothing. All we want at the least is a temporary key (or better yet the keys for our renewal) but they are too incompetent to furnish that. This is something MailFrontier would gladly and easily handle before the merger.
I think it's time to find a new solution.
Tags: SonicWALL, MailFrontier, incompetent, support, license_renewal, IT, software, expired, Truth, SPAM, date_time, CDW
Written by datapoohbah on June 5th, 2006 with no comments.
Read more articles on Commentary and IT and Network Managment and The Truth Hurts.
While you're at it, this is just a hell of a blog if you're dependant upon Exchange like most of us are.
You Had Me At EHLO! The Microsoft Exchange Team Blog
and really all things considered, Exchange doesn't completely suck anymore. Just remember it could be aleays worse, you could be running Notes/Domino.
Technorati Tags: Microsoft, Exchange, Blog
Written by datapoohbah on May 19th, 2006 with no comments.
Read more articles on IT and Network Managment.
We’ve been hard on Dell before, but they should get Kudo’s when they get something right. Last week I needed to deploy a new laptop fast. We have fleet of latitude d-series laptops, and I often switch hard drives around when one gets a. infected with virii and spyware, or b. goes bad (which laptop drives do often).
Anyway I pulled out a d600 that I had kept back and found that the hard drive carrier and hd was missing. HD’s are no problem, I had a couple of spares and one hd carrier, but it was for a d800 and not a d600, and they don’t mix and match. doh!
I remembered that we had completecare on these. Highly recommended. You can run over the laptop with a truck and they will send you a new one, no questions asked.
So I called them up, told them the situation and asked if they would ship me out a new hd carrier. Well, completecare does not cover loss or stupidity, so they would have been entirely in the right to tell me to go pound sand. But instead, the tech, on his own authority, without clearance from anyone, takes the initiative and ships me out the carrier. The whole phone conversation lasted ten minutes.
That’s how you keep loyal customers. Dell gets it right most of the time. I should also note that I’ve called Dell a couple of other times on questions about poweredge servers and each time got a quick response plus an answer to a question.
Written by CmdrChalupa on February 28th, 2006 with no comments.
Read more articles on IT and Network Managment.
« Older articles
No newer articles
