Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
Judge Schnoopy
Nov 2, 2005

dont even TRY it, pal

Bob Morales posted:

Aaaand he turned in his resignation in today.

Congrats on your promotion to AS/400 guy.

Adbot
ADBOT LOVES YOU

Bob Morales
Aug 18, 2006


Just wear the fucking mask, Bob

I don't care how many people I probably infected with COVID-19 while refusing to wear a mask, my comfort is far more important than the health and safety of everyone around me!

Judge Schnoopy posted:

Congrats on your promotion to AS/400 guy.

We have 3 of our 6 internal companies switched over to NetSuite so in a few months we can bury the IBM

incoherent
Apr 24, 2004

01010100011010000111001
00110100101101100011011
000110010101110010

Agrikk posted:

poo poo not pissing me off: ButtFormation and Powershell and scripting

I'm working on a proof of concept involving SQL Server 2016 on AWS EC2, so last night I decided to upgrade an existing SQL 2012 server to 2016 by flattening the instance and building a new one:

- script to shut down SQL server services
- AWS CLI to shutdown and terminate instance without terminating EBS volumes
- Buttformation script to launch new Windows Server 2012r2 box, configure it, re-add existing EBS volumes, launch powershell script to online volumes in the OS, rename instance and add it to existing AD domain, install datadog agent
- log onto the box
- run unattended installation script to install SQL 2016
- launch SSMS to attach databases
- import scheduled tasks from backup

Total elapsed time the server registered as unhealthy in SQL Server load balancer pool: 47 minutes.

Sometimes poo poo just works, folks.

All I think about when someone talks a full instance of SQL in AWS is $$$$$$$

Bigass Moth
Mar 6, 2004

I joined the #RXT REVOLUTION.
:boom:
he knows...
Communication at the place I am stationed is terrible. An actual conversation I had:

:) Hey I got an alert that X device at Y building is offline. I can't ssh into it. Something going on with that buildings connection?

:P Oh that building is being demolished today, we pulled the gear out of there.

Thanks for the heads up.

pixaal
Jan 8, 2004

All ice cream is now for all beings, no matter how many legs.


Bigass Moth posted:

Communication at the place I am stationed is terrible. An actual conversation I had:

:) Hey I got an alert that X device at Y building is offline. I can't ssh into it. Something going on with that buildings connection?

:P Oh that building is being demolished today, we pulled the gear out of there.

Thanks for the heads up.

Better than
Oh that building was demolished last night, was stuff still in it?

Agrikk
Oct 17, 2003

Take care with that! We have not fully ascertained its function, and the ticking is accelerating.

incoherent posted:

All I think about when someone talks a full instance of SQL in AWS is $$$$$$$

Well yeah. :)

There's a billion better/cheaper ways to do things, but SQL Server on Windows is what I know best so...

Sheep
Jul 24, 2003
We bought a company a couple of years ago, and they had a bunch of equipment (mostly wireless APs) in the ceilings, presumably sitting on top of the ceiling tiles.

No one told us but we cancelled our lease on that facility and moved offices, leaving the wireless equipment behind sitting in the ceiling.

Welp.

Edit: no one bothered to ask why we had an extra WLAN controller but no APs.

Sheep fucked around with this message at 19:11 on Aug 24, 2016

Judge Schnoopy
Nov 2, 2005

dont even TRY it, pal
A request came in from VP of tech to "investigate using Sharepoint". I explained that sharepoint is delivered as an empty shell and has to be built from the ground up, so sharepoint is exactly what you put into it. I then asked what goals were we looking to accomplish with Sharepoint.

"Well another VP said we should try it, and my son uses it at his workplace and says it's really good. But I don't know much about it, what does it do?"

I got him to back off by telling him Sharepoint Development is an entire tech industry and he would have to hire somebody to do it, because gently caress all that noise if they're going to drop sharepoint on me and expect whimsical wondrous things to automagically appear for them.

Thanks Ants
May 21, 2004

#essereFerrari


Agrikk posted:

poo poo not pissing me off: CloudFormation and Powershell and scripting

I'm working on a proof of concept involving SQL Server 2016 on AWS EC2, so last night I decided to upgrade an existing SQL 2012 server to 2016 by flattening the instance and building a new one:

- script to shut down SQL server services
- AWS CLI to shutdown and terminate instance without terminating EBS volumes
- Cloudformation script to launch new Windows Server 2012r2 box, configure it, re-add existing EBS volumes, launch powershell script to online volumes in the OS, rename instance and add it to existing AD domain, install datadog agent
- log onto the box
- run unattended installation script to install SQL 2016
- launch SSMS to attach databases
- import scheduled tasks from backup

Total elapsed time the server registered as unhealthy in SQL Server load balancer pool: 47 minutes.

Sometimes poo poo just works, folks.

I need to clear some time out to get in on this.

xzzy
Mar 5, 2009

I've been a unix admin for around 20 years now, and every time I poke at PowerShell I get more impressed by it. I worry that it's going to end up being too clever for its own good which means scripts will suck to maintain years down the road, but the things you can do with the pipeline are a mindfuck for someone that's been dealing with text only pipes for a while. Output is passed as an object that you can run selects and conversions on it? :psyduck:

Polio Vax Scene
Apr 5, 2009



Judge Schnoopy posted:

A request came in from VP of tech to "investigate using Sharepoint". I explained that sharepoint is delivered as an empty shell and has to be built from the ground up, so sharepoint is exactly what you put into it. I then asked what goals were we looking to accomplish with Sharepoint.

"Well another VP said we should try it, and my son uses it at his workplace and says it's really good. But I don't know much about it, what does it do?"

I got him to back off by telling him Sharepoint Development is an entire tech industry and he would have to hire somebody to do it, because gently caress all that noise if they're going to drop sharepoint on me and expect whimsical wondrous things to automagically appear for them.

A major component of our core product is integration with Sharepoint, and we use a plethora of features, all of them listed here:

- Document storage
- ???

Thanks Ants
May 21, 2004

#essereFerrari


I'm not saying that Google Apps is particularly good, but use Word Online and then use Docs and compare the versioning features in both.

Collateral Damage
Jun 13, 2009

Bob Morales posted:

Aaaand he turned in his resignation in today.
Time to learn OS/400.


Thanks Ants posted:

I'm not saying that Google Apps is particularly good, but use Word Online and then use Docs and compare the versioning features in both.
I like how Word Online can't open Word documents if the they use certain features, but Google Docs will happily open and edit them. Also Excel Online is horribly slow compared to Google Sheets.

Thanks Ants
May 21, 2004

#essereFerrari


I love ISPs that run shithouse email services and don't reply to postmaster@ and have a first-line support that can't understand that when you say you're having issues sending email to their domain that you aren't calling for a password reset. But of course it's vital that an employee can email this particular account!

wolrah
May 8, 2006
what?

xzzy posted:

I've been a unix admin for around 20 years now, and every time I poke at PowerShell I get more impressed by it. I worry that it's going to end up being too clever for its own good which means scripts will suck to maintain years down the road, but the things you can do with the pipeline are a mindfuck for someone that's been dealing with text only pipes for a while. Output is passed as an object that you can run selects and conversions on it? :psyduck:

The fact that its pipeline is based on .Net objects is a huge double-edged sword. As you've seen it's extremely powerful, but it also has the effect of sometimes resulting in a huge memory usage increase compared to the *nix-style plaintext pipeline. I recall seeing an example where doing something with I think a few hundred KB CSV file ended up somehow using hundreds of megs of RAM.

If you're aware of this and are keeping it in mind it's generally possible to avoid problems so it's not like it's a critical flaw, but it's not the sort of thing you'd generally be expecting to have as a problem when writing a shell script.

porkface
Dec 29, 2000

Judge Schnoopy posted:

"Well another VP said we should try it, and my son uses it at his workplace and says it's really good. But I don't know much about it, what does it do?"

Me: Your son is an inbred halfwit
You: Massive hidden costs

This is why you get paid the big bucks.

FlapYoJacks
Feb 12, 2009

xzzy posted:

I've been a unix admin for around 20 years now, and every time I poke at PowerShell I get more impressed by it. I worry that it's going to end up being too clever for its own good which means scripts will suck to maintain years down the road, but the things you can do with the pipeline are a mindfuck for someone that's been dealing with text only pipes for a while. Output is passed as an object that you can run selects and conversions on it? :psyduck:

If you want that fanciness you could use python or Perl.

22 Eargesplitten
Oct 10, 2010



Yeah, I loving love Powershell. I use it whenever it's remotely practical. I've also been teaching myself Python in my downtime for webdev and linux.

incoherent
Apr 24, 2004

01010100011010000111001
00110100101101100011011
000110010101110010

Thanks Ants posted:

I need to clear some time out to get in on this.

Cloud formation is some neat poo poo. Spring up an entire zone with your active directory extended to your own VPC on demand and having things come online.

xzzy
Mar 5, 2009

ratbert90 posted:

If you want that fanciness you could use python or Perl.

If I'm writing a script that's going to get used a lot, sure. But doing day to day system maintenance? No way.

Being able to stack commands together with pipes to parse output and figure out why poo poo's busted is the whole reason shells are cool.

RFC2324
Jun 7, 2012

http 418

Thanks Ants posted:

I love ISPs that run shithouse email services and don't reply to postmaster@ and have a first-line support that can't understand that when you say you're having issues sending email to their domain that you aren't calling for a password reset. But of course it's vital that an employee can email this particular account!

So, all of them?

Inspector_666
Oct 7, 2003

benny with the good hair

22 Eargesplitten posted:

Yeah, I loving love Powershell. I use it whenever it's remotely practical. I've also been teaching myself Python in my downtime for webdev and linux.

Powershell is the best. I assume a large chunk of my love is that it was the first language I really sat down and learned to the point where I can write scripts I actually need in it, but something about the verbosity and syntax really clicked with me in a way other stuff doesn't.

It certainly helps that the modules MS made for all things Windows environment are loving great and make life so goddamn easy.

Thanks Ants
May 21, 2004

#essereFerrari


RFC2324 posted:

So, all of them?

:smith:

FlapYoJacks
Feb 12, 2009

xzzy posted:

If I'm writing a script that's going to get used a lot, sure. But doing day to day system maintenance? No way.

Being able to stack commands together with pipes to parse output and figure out why poo poo's busted is the whole reason shells are cool.

Why not? There are a bajillion libraries and it works fine with stacking output from popen.

CitizenKain
May 27, 2001

That was Gary Cooper, asshole.

Nap Ghost
Had a meeting at work today that showed that not only is the number of projects and things we cover increasing soon, but we aren't going to get any more people to help. We've been trying to move some of our responsibilities to another group because they don't really fit with our department, but no one else wants to take them.

Our department was a dumping ground for random projects and tasks in the past, but we can never seem to give them up. For some reason, our networking department handles routing, switching, some firewalls, cabling, wireless, video conferencing, 2 secure file transfer products, UPS systems, televisions, external DNS servers, management and diagnostic tool servers, network taps, a bunch of linux servers, some windows servers for some reason. Also we sometimes have to work with external customers. All this in a department of 3 people. Plus we work closely with the telephony/voip department, and manage all of their servers.

Earlier this year, I thought we had hit the bottom on this place dealing with our previous manager, now I have a feeling it is simply going to get just as bad, but from a different direction, and I'm not sure how much I want to deal with it. I really wish it didn't feel like our department was singled out to be poo poo on.

mllaneza
Apr 28, 2007

Veteran, Bermuda Triangle Expeditionary Force, 1993-1952




RFC2324 posted:

So, all of them?

It's a legacy system left over from an acquisition years ago, but it turns out my mother's ISP still stores email passwords in plaintext. I found this out when a third level support rep asked me to confirm my identity by verifying my password over the phone. I had him read it back to me and sure enough….

Urit
Oct 22, 2010

incoherent posted:

Cloud formation is some neat poo poo. Spring up an entire zone with your active directory extended to your own VPC on demand and having things come online.

If you think that's neat, try Terraform. Unlike Buttformation, it isn't a single 1000-line monolithic json file when you get to doing complex really neat stuff with it, and it actually lets you preview changes before mashing them in. CloudFormation and Elastic Beanstalk have got to be some of the most hacked-together-feeling software that I've ever used, and I say this as an (ex, thankfully) 5 year SharePoint admin.

Urit fucked around with this message at 06:21 on Aug 25, 2016

DONT TOUCH THE PC
Jul 15, 2001

You should try it, it's a real buzz.

xzzy posted:

I've been a unix admin for around 20 years now, and every time I poke at PowerShell I get more impressed by it. I worry that it's going to end up being too clever for its own good which means scripts will suck to maintain years down the road, but the things you can do with the pipeline are a mindfuck for someone that's been dealing with text only pipes for a while. Output is passed as an object that you can run selects and conversions on it? :psyduck:

Both my Windows and Linux-sysadmin colleagues start snorting when I open Powershell, once I heard "Is that still used?", this place is weird.

Humbug Scoolbus
Apr 25, 2008

The scarlet letter was her passport into regions where other women dared not tread. Shame, Despair, Solitude! These had been her teachers, stern and wild ones, and they had made her strong, but taught her much amiss.
Clapping Larry
And Windows 10 just killed part of Powershell

https://blogs.msdn.microsoft.com/powershell/2016/08/23/powershell-dsc-broken-in-kb3176932/

Crowley
Mar 13, 2003

IndustrialApe posted:

Both my Windows and Linux-sysadmin colleagues start snorting when I open Powershell, once I heard "Is that still used?", this place is weird.

Your colleagues are idiots who won't last long unless they turn that attitude around. PowerShell is in everything MS is doing in the foreseeable future.

Manslaughter posted:

A major component of our core product is integration with Sharepoint, and we use a plethora of features, all of them listed here:

- Document storage
- ???
We use O365 for all schools in the municipality, and while it's a bit slow (you know.. "Sharepoint slow") it's brilliant. Students and staff are members of groups for their respective classes, courses, and schools. They receive and hand in homework through it, use it for file sharing, making impromptu work groups, etc.

Crowley fucked around with this message at 10:04 on Aug 25, 2016

DONT TOUCH THE PC
Jul 15, 2001

You should try it, it's a real buzz.

Crowley posted:

Your colleagues are idiots who won't last long unless they turn that attitude around. PowerShell is in everything MS is doing in the foreseeable future.

They're set until their pensions or until the institute folds and happy as a clam. I'm gone within 2 years no matter what (new hiring policy).

peter banana
Sep 2, 2008

Feminism is a socialist, anti-family, political movement that encourages women to leave their husbands, kill their children, practice witchcraft, destroy capitalism and become lesbians.

Judge Schnoopy posted:

A request came in from VP of tech to "investigate using Sharepoint". I explained that sharepoint is delivered as an empty shell and has to be built from the ground up, so sharepoint is exactly what you put into it. I then asked what goals were we looking to accomplish with Sharepoint.

"Well another VP said we should try it, and my son uses it at his workplace and says it's really good. But I don't know much about it, what does it do?"

I got him to back off by telling him Sharepoint Development is an entire tech industry and he would have to hire somebody to do it, because gently caress all that noise if they're going to drop sharepoint on me and expect whimsical wondrous things to automagically appear for them.

About 70% of the projects I take on at my job are "Hey someone on the senior leadership said this would be cool. Let's do it."

This is a hospital that is apparently "lean." Or at least it's lean whenever we ask for resources.

Woogles
Mar 23, 2007

hello
Bossman's asked me to find some way to get a toll free number (for as much of Asia as possible) that we can forward into our PBX.

Where the hell am I going to get a number like that?

Super-NintendoUser
Jan 16, 2004

COWABUNGERDER COMPADRES
Soiled Meat

Woogles posted:

Bossman's asked me to find some way to get a toll free number (for as much of Asia as possible) that we can forward into our PBX.

Where the hell am I going to get a number like that?

There's a ton of providers that will you give you an inbound toll free number that forwards over SIP to a local number. We used Junction Networks at my last job. The service wasn't great, but it was workable.

Thanks Ants
May 21, 2004

#essereFerrari


Woogles posted:

Bossman's asked me to find some way to get a toll free number (for as much of Asia as possible) that we can forward into our PBX.

Where the hell am I going to get a number like that?

https://www.voxbone.com/coverage/voip-coverage

22 Eargesplitten
Oct 10, 2010



No, gently caress you consultant guy, you don't get to drag your feet on giving me information that I said I need before I do something and then complain at 10PM that I haven't done it and say that I "disappeared."

Thankfully I sent the CYA emails to my boss, who is just as tired of these guys being so much quicker to bill us than to do work.

Now he's complaining that I set up a SQL server instance wrong when I have been doing it that way without a problem for almost two months. Even better, there were never any instructions on how to set it up, so he's expecting me to be a mind reader.

OWLS!
Sep 17, 2009

by LITERALLY AN ADMIN
Walk into the office today, bleary eyed, and straight into a multi-site outage.

On the plus side, whee, fixing things!

On the minus side, the things are fixed, but now Support is claiming that customers are having issues (whereas my logs are clearly showing that they are not.) When pressed to provide a list of customers experiencing an urgent issue, we are now at 30 minutes of complete silence from support in our slack channel. People, you gotta learn that when an outage is over you gotta recheck if customers are still experiecing any issues, not just assume that the problem is still ongoing .

OWLS! fucked around with this message at 16:47 on Aug 25, 2016

Woogles
Mar 23, 2007

hello
Thanks guys, that's given me some great leads. I hate being the only person in the company who has half a clue about Asterisk.

Neddy Seagoon
Oct 12, 2012

"Hi Everybody!"

OWLS! posted:

Walk into the office today, bleary eyed, and straight into a multi-site outage.

On the plus side, whee, fixing things!

On the minus side, the things are fixed, but now Support is claiming that customers are having issues (whereas my logs are clearly showing that they are not.) When pressed to provide a list of customers experiencing an urgent issue, we are now at 30 minutes of complete silence from support in our slack channel. People, you gotta learn that when an outage is over you gotta recheck if customers are still experiencing any issues, not just assume that the problem is still ongoing .

First thing I do once alarms clear is give affected customers a courtesy call to make sure it's all good on their end before going anywhere near closing their tickets. They always appreciate it even if everything's working fine.

Adbot
ADBOT LOVES YOU

xzzy
Mar 5, 2009

I typically add a "things looking better now, please let me know if your problem is gone now" line to any open tickets too.

Then let it sit for a day and when they don't respond (because why would they, the problem is gone and tickets are only for problems!), resolve it.

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply