As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
We're funding a new Acquisitions Incorporated series on Kickstarter right now! Check it out at https://www.kickstarter.com/projects/pennyarcade/acquisitions-incorporated-the-series-2

[Sysadmin] Go to the new thread now, dog.

1192022242599

Posts

  • SeidkonaSeidkona Had an upgrade Registered User regular
    They. . .there's a. . .what?

    I think you just broke my brain.

    Mostly just huntin' monsters.
    XBL:Phenyhelm - 3DS:Phenyhelm
  • SeñorAmorSeñorAmor !!! Registered User regular
    Jeez.

    I have a bridge to sell you guys, too. :rotate:

  • SeidkonaSeidkona Had an upgrade Registered User regular
    SeñorAmor wrote: »
    Jeez.

    I have a bridge to sell you guys, too. :rotate:

    Is it made with Legos?

    Mostly just huntin' monsters.
    XBL:Phenyhelm - 3DS:Phenyhelm
  • bowenbowen How you doin'? Registered User regular
    I trusted you

    and you did this

    not a doctor, not a lawyer, examples I use may not be fully researched so don't take out of context plz, don't @ me
    SeidkonaAegisjungleroomx
  • SeidkonaSeidkona Had an upgrade Registered User regular
    bowen wrote: »
    I trusted you

    and you did this

    This is why we cannot have nice things.

    Mostly just huntin' monsters.
    XBL:Phenyhelm - 3DS:Phenyhelm
    bowenwunderbar
  • SeñorAmorSeñorAmor !!! Registered User regular
    bowen wrote: »
    I trusted you

    Mistake, the first...

  • SeidkonaSeidkona Had an upgrade Registered User regular
    edited January 2017
    I found this for you, @Cog

    https://www.scribd.com/document/336399802/MISys-Pre-Installation-Guide-6-3

    Edit: also it's a hilarious read. Especially the part about MS SQL Express licensing and the weird aside about accounting software.

    Seidkona on
    Mostly just huntin' monsters.
    XBL:Phenyhelm - 3DS:Phenyhelm
    wunderbar
  • bowenbowen How you doin'? Registered User regular
    That was a fun read.

    Dude knows how to run a business for sure, he's trying to lay down the law to make sure others aren't making dumb mistakes.

    not a doctor, not a lawyer, examples I use may not be fully researched so don't take out of context plz, don't @ me
  • SeidkonaSeidkona Had an upgrade Registered User regular
    edited January 2017
    I guess aside from very specifically saying Licensing? Who knows how that works? Probably like HTTP.


    Seidkona on
    Mostly just huntin' monsters.
    XBL:Phenyhelm - 3DS:Phenyhelm
  • donavannjdonavannj Registered User regular
    edited January 2017
    SeñorAmor wrote: »
    It may have worked years ago before telcos started switching everything to digital, but the security industry is so far behind in communications technology, it's staggering.

    Modern panels still have 2400 baud phone connections. If you're lucky enough to get a panel with an ethernet connection, it's 10mbit and still only an analog to digital converter so communication is still limited to 2400bps.

    The constant conversion between analog and digital and back wreaks havoc for reliable data transfer, both when trying to report an alarm (like a burglary alarm) and when trying to do remote programming to the panel.

    Shit, the #1 programming software for Honeywell alarm panels still doesn't support the scrollwheel on mice.

    Are we talking card access systems or other types of security systems? Because screw any of either of those that don't have Ethernet controllers built in.

    Also I'm starting to see some of your possible frustrations with Doors.Net, but I'm still finding most of these have some roots in user error.

    donavannj on
    steam_sig.png
  • TL DRTL DR Not at all confident in his reflexive opinions of thingsRegistered User regular
    A certain former mayor of NYC will join the Trump administration in order to 'share his expertise and insight on cyber-security matters.'

    Presented without comment:
    nwmdilR.png

    Seidkonawunderbar
  • bowenbowen How you doin'? Registered User regular
    the only two that seem exceptionally bad are ldap and mysql

    not a doctor, not a lawyer, examples I use may not be fully researched so don't take out of context plz, don't @ me
    TL DR
  • SeidkonaSeidkona Had an upgrade Registered User regular
    edited January 2017
    Look, anonymous binds are ok. If anonymous binds consider me and asset I think that's a win for all of us.

    I mean anonymous binds are very smart and what do we know when computers are involved anyway?

    Seidkona on
    Mostly just huntin' monsters.
    XBL:Phenyhelm - 3DS:Phenyhelm
    bowen
  • RandomHajileRandomHajile Not actually a Snatcher The New KremlinRegistered User regular
    About mid-way through my 12-year time in this job, I got an urgent call from one of the plants about a DOS machine running a homegrown QBasic program for river temperature tracking. Next to it, there was a sheet of instructions on how to back up the program/data to floppy disk weekly. Guess how often they had done that (spoiler, never). Now, a little bit on this program: it needs the average river temperature for the entire previous year, the average for the same month of the previous year, and the data for the same day of the previous year. Oh, did I mention that it is hourly data entered manually? "Luckily" I guess, they also saved the printed versions of this data just in case. Also luckily, I had previously taught a QB class at a local community college, so I fixed the program to save to a network drive and print to a network printer via LPT1 on an XP machine. (And a couple minor date bugs that the guy who wrote it--chemical engineer--left in.) Anyway, they paid a temp to come in and type in the entire previous year up to the current date. And I'm pretty sure that program is still running in an XP Mode VM on that clerk's Win 7 PC. Man, I'll have to check.

    Seidkona
  • That_GuyThat_Guy I don't wanna be that guy Registered User regular
    TL DR wrote: »
    A certain former mayor of NYC will join the Trump administration in order to 'share his expertise and insight on cyber-security matters.'

    Presented without comment:
    nwmdilR.png

    Let me just sit here and try domain passwords until something lets me in. Fucking brilliant.

    steam_sig.png
    Seidkonabowen
  • bowenbowen How you doin'? Registered User regular
    dollars to donuts the admin password is p4ssw0rd or some variation of that

    not a doctor, not a lawyer, examples I use may not be fully researched so don't take out of context plz, don't @ me
    SeidkonaCog
  • jungleroomxjungleroomx It's never too many graves, it's always not enough shovels Registered User regular
    edited January 2017
    Our software updates are a pain.

    It's like this: first we have to transfer the files via vpn tunnel. This is a security thing, I suppose.

    Then we have an installer system that uses a local and distant service to put the new files in place and NGEN the shit to death.

    Then, we run some scripts manually (they do need to be adjusted per bank, something that's thankfully going away soon).

    Then we turn on the services and test.

    It sucks but eh, I've had worse... except when some jackass decides they need to "hop on real quick" and screws the pooch on the entire process.

    Some guy, right after the banks sysop told everyone to log off, got back on the teller station to "check something out", and started an .exe that we needed to remain dormant until we were done.

    So, instead of 30 minutes, we had to spend 30 just restoring the database and then 30 minutes reconfiguring the components (mostly cfgs) and THEN 30 minutes installing it.

    Thankfully we got the guys name and reported him to the president of the bank. His tone told me everything I needed to hear about how it was about to be handled.

    Tl;dr: fuck users God I hate them

    jungleroomx on
    RandomHajile
  • a5ehrena5ehren AtlantaRegistered User regular
    edited January 2017
    bowen wrote: »
    the only two that seem exceptionally bad are ldap and mysql

    OpenSSH 4.7 is almost 10 years old, for one. They're also running a EOL'd version of PHP and a 9 year-old version of FreeBSD.

    You don't even have to *try* to find security holes in it, because you have 10 years of CVEs to basically tell you how.

    a5ehren on
  • SeñorAmorSeñorAmor !!! Registered User regular
    donavannj wrote: »
    SeñorAmor wrote: »
    It may have worked years ago before telcos started switching everything to digital, but the security industry is so far behind in communications technology, it's staggering.

    Modern panels still have 2400 baud phone connections. If you're lucky enough to get a panel with an ethernet connection, it's 10mbit and still only an analog to digital converter so communication is still limited to 2400bps.

    The constant conversion between analog and digital and back wreaks havoc for reliable data transfer, both when trying to report an alarm (like a burglary alarm) and when trying to do remote programming to the panel.

    Shit, the #1 programming software for Honeywell alarm panels still doesn't support the scrollwheel on mice.

    Are we talking card access systems or other types of security systems? Because screw any of either of those that don't have Ethernet controllers built in.

    Also I'm starting to see some of your possible frustrations with Doors.Net, but I'm still finding most of these have some roots in user error.

    Burglary alarm panels (and fire alarm panels, too).

    Doors.NET is passable if all you have to do is user management. If you have to do things like time schedules or anything mildly advanced, it's convoluted as fuck.

  • bowenbowen How you doin'? Registered User regular
    a5ehren wrote: »
    bowen wrote: »
    the only two that seem exceptionally bad are ldap and mysql

    OpenSSH 4.7 is almost 10 years old, for one. They're also running a EOL'd version of PHP and a 9 year-old version of FreeBSD.

    You don't even have to *try* to find security holes in it, because you have 10 years of CVEs to basically tell you how.

    What's reported my not necessarily be what's there, Open source is open source. But the BSD/PHP versions must be from another source.

    not a doctor, not a lawyer, examples I use may not be fully researched so don't take out of context plz, don't @ me
  • CogCog What'd you expect? Registered User regular
    Thursday came and went without the terminal services on my client's Citrix server dying or me getting fired, so, you know..

    Positive.

    jungleroomxLD50Bigity
  • DelzhandDelzhand Hard to miss. Registered User regular
    bowen wrote: »
    dollars to donuts the admin password is p4ssw0rd or some variation of that

    Eh, the bar for bad passwords seems to have been raised, albeit minutely. What I see most these days is <companyname><4 digit year>.

    somebody try "guilianisecurity2001"

    bowen
  • CogCog What'd you expect? Registered User regular
    Delzhand wrote: »
    bowen wrote: »
    dollars to donuts the admin password is p4ssw0rd or some variation of that

    Eh, the bar for bad passwords seems to have been raised, albeit minutely. What I see most these days is <companyname><4 digit year>.

    somebody try "guilianisecurity2001"

    Needs more 9/11

    SeñorAmorSeidkona
  • CogCog What'd you expect? Registered User regular
    Why is the default configuration on this server's Bios set for Serial Device 1 = Com2, Serial Device 2 = Com1?

    Little things like that bug the shit out of me.

  • TL DRTL DR Not at all confident in his reflexive opinions of thingsRegistered User regular
    Our software updates are a pain.

    It's like this: first we have to transfer the files via vpn tunnel. This is a security thing, I suppose.

    Then we have an installer system that uses a local and distant service to put the new files in place and NGEN the shit to death.

    Then, we run some scripts manually (they do need to be adjusted per bank, something that's thankfully going away soon).

    Then we turn on the services and test.

    It sucks but eh, I've had worse... except when some jackass decides they need to "hop on real quick" and screws the pooch on the entire process.

    Some guy, right after the banks sysop told everyone to log off, got back on the teller station to "check something out", and started an .exe that we needed to remain dormant until we were done.

    So, instead of 30 minutes, we had to spend 30 just restoring the database and then 30 minutes reconfiguring the components (mostly cfgs) and THEN 30 minutes installing it.

    Thankfully we got the guys name and reported him to the president of the bank. His tone told me everything I needed to hear about how it was about to be handled.

    Tl;dr: fuck users God I hate them

    tbf, if your process allows for user fuckup like that, it's your own fault.

  • CogCog What'd you expect? Registered User regular
    I get to do a 2016 server today. That's mildly exciting.

  • wunderbarwunderbar What Have I Done? Registered User regular
    Cog wrote: »
    I get to do a 2016 server today. That's mildly exciting.

    oooo, That actually interests me. I haven't had a chance to play with it yet.

    XBL: thewunderbar PSN: thewunderbar NNID: thewunderbar Steam: wunderbar87 Twitter: wunderbar
    Seidkona
  • jungleroomxjungleroomx It's never too many graves, it's always not enough shovels Registered User regular
    edited January 2017
    TL DR wrote: »
    Our software updates are a pain.

    It's like this: first we have to transfer the files via vpn tunnel. This is a security thing, I suppose.

    Then we have an installer system that uses a local and distant service to put the new files in place and NGEN the shit to death.

    Then, we run some scripts manually (they do need to be adjusted per bank, something that's thankfully going away soon).

    Then we turn on the services and test.

    It sucks but eh, I've had worse... except when some jackass decides they need to "hop on real quick" and screws the pooch on the entire process.

    Some guy, right after the banks sysop told everyone to log off, got back on the teller station to "check something out", and started an .exe that we needed to remain dormant until we were done.

    So, instead of 30 minutes, we had to spend 30 just restoring the database and then 30 minutes reconfiguring the components (mostly cfgs) and THEN 30 minutes installing it.

    Thankfully we got the guys name and reported him to the president of the bank. His tone told me everything I needed to hear about how it was about to be handled.

    Tl;dr: fuck users God I hate them

    tbf, if your process allows for user fuckup like that, it's your own fault.

    It's not my process, I just have to deal with it.

    I have equal amounts of vitriol for developers.

    jungleroomx on
  • CogCog What'd you expect? Registered User regular
    Microsoft's VLSC is poop from a butt.

    TL DRSeidkonawunderbarRandomHajilejungleroomx
  • CogCog What'd you expect? Registered User regular
    wunderbar wrote: »
    Cog wrote: »
    I get to do a 2016 server today. That's mildly exciting.

    oooo, That actually interests me. I haven't had a chance to play with it yet.

    Yeah I haven't even actually seen it yet. I get the first deployment of it at my company. It's for a tiny 3 user client of ours who just have a single 2011 SBS server doing DC, file, and print, so it's pretty much the best possible case scenario for a first deployment. No exchange, no SQL, they're not using sharepoint or anything crazy off the SBS. Just AD, file & print, DHCP and DNS, and a super small environment.

  • TL DRTL DR Not at all confident in his reflexive opinions of thingsRegistered User regular
    TL DR wrote: »
    Our software updates are a pain.

    It's like this: first we have to transfer the files via vpn tunnel. This is a security thing, I suppose.

    Then we have an installer system that uses a local and distant service to put the new files in place and NGEN the shit to death.

    Then, we run some scripts manually (they do need to be adjusted per bank, something that's thankfully going away soon).

    Then we turn on the services and test.

    It sucks but eh, I've had worse... except when some jackass decides they need to "hop on real quick" and screws the pooch on the entire process.

    Some guy, right after the banks sysop told everyone to log off, got back on the teller station to "check something out", and started an .exe that we needed to remain dormant until we were done.

    So, instead of 30 minutes, we had to spend 30 just restoring the database and then 30 minutes reconfiguring the components (mostly cfgs) and THEN 30 minutes installing it.

    Thankfully we got the guys name and reported him to the president of the bank. His tone told me everything I needed to hear about how it was about to be handled.

    Tl;dr: fuck users God I hate them

    tbf, if your process allows for user fuckup like that, it's your own fault.

    It's not my process, I just have to deal with it.

    I have equal amounts of vitriol for developers.

    Oh yeah, I meant that as the general 'you'

    society, i guess

    jungleroomx
  • SeñorAmorSeñorAmor !!! Registered User regular
    Went on site this morning to a client (apartment complex - distributed internet) because a resident didn't have internet access.

    Go into the data closet only to find my client switched internet providers and the ISP removed the existing equipment (router, switches) and put in their own. Called the ISP since I know many of the people there and they're like, "Yeah we did that back in early December. They never told you?"

    I checked to make sure the run from the apartment to the data closet was good but ultimately told the resident I couldn't help him. Gotta love clients making changes without letting you know.

    :rotate:

    bowenCog
  • wunderbarwunderbar What Have I Done? Registered User regular
    so after 6 weeks working the new job, I'm finally starting to implement things that were so desperately needed.

    - The barely working exchange server is now working properly (next up on that is building the second redundant exchange server)

    - Starting Monday I'm moving to differential backups instead of running a full backup of everything every day. Final straw on that was they got me to add a bunch of things to the backup, and the backups are now taking between 23 and 24 hours to complete. (currently backing up to tape). So the hand is kind of being forced there, but my god, not doing a full backup every single day is going to be so nice.

    -Win7 clients here haven't been patched, from what I can see, since last june. I implemented a test group, pushed all updates through November to them 2 weeks ago, and am pushing those updates to the rest of the organization on Monday. PC's will be much closer to up to date, and things will be much easier to manage going forward.


    Next up.... a proper system imaging solution. Currently it's 90% manual, with a basic ghost image sitting on a hard drive and most of the rest of things installed manually.

    XBL: thewunderbar PSN: thewunderbar NNID: thewunderbar Steam: wunderbar87 Twitter: wunderbar
    CogjungleroomxRandomHajileSeidkonalwt1973
  • CogCog What'd you expect? Registered User regular
    Neat. 2016 does look exactly like Win10. I approve.

  • SiliconStewSiliconStew Registered User regular
    About mid-way through my 12-year time in this job, I got an urgent call from one of the plants about a DOS machine running a homegrown QBasic program for river temperature tracking. Next to it, there was a sheet of instructions on how to back up the program/data to floppy disk weekly. Guess how often they had done that (spoiler, never). Now, a little bit on this program: it needs the average river temperature for the entire previous year, the average for the same month of the previous year, and the data for the same day of the previous year. Oh, did I mention that it is hourly data entered manually? "Luckily" I guess, they also saved the printed versions of this data just in case. Also luckily, I had previously taught a QB class at a local community college, so I fixed the program to save to a network drive and print to a network printer via LPT1 on an XP machine. (And a couple minor date bugs that the guy who wrote it--chemical engineer--left in.) Anyway, they paid a temp to come in and type in the entire previous year up to the current date. And I'm pretty sure that program is still running in an XP Mode VM on that clerk's Win 7 PC. Man, I'll have to check.

    It's all just manually entered data, that from your description only has some averaging calculations thrown on top, that doesn't tie into anything besides needing to print, right? Sounds like they should just be using a spreadsheet rather than relying a qbasic program running on an end-of-life OS, running as a VM, in a specialized hypervisor that only exists on an OS that's EOL in 3 years.

    Just remember that half the people you meet are below average intelligence.
    Aioua
  • jungleroomxjungleroomx It's never too many graves, it's always not enough shovels Registered User regular
    edited January 2017
    TL DR wrote: »
    TL DR wrote: »
    Our software updates are a pain.

    It's like this: first we have to transfer the files via vpn tunnel. This is a security thing, I suppose.

    Then we have an installer system that uses a local and distant service to put the new files in place and NGEN the shit to death.

    Then, we run some scripts manually (they do need to be adjusted per bank, something that's thankfully going away soon).

    Then we turn on the services and test.

    It sucks but eh, I've had worse... except when some jackass decides they need to "hop on real quick" and screws the pooch on the entire process.

    Some guy, right after the banks sysop told everyone to log off, got back on the teller station to "check something out", and started an .exe that we needed to remain dormant until we were done.

    So, instead of 30 minutes, we had to spend 30 just restoring the database and then 30 minutes reconfiguring the components (mostly cfgs) and THEN 30 minutes installing it.

    Thankfully we got the guys name and reported him to the president of the bank. His tone told me everything I needed to hear about how it was about to be handled.

    Tl;dr: fuck users God I hate them

    tbf, if your process allows for user fuckup like that, it's your own fault.

    It's not my process, I just have to deal with it.

    I have equal amounts of vitriol for developers.

    Oh yeah, I meant that as the general 'you'

    society, i guess

    In all fairness, it's just one set of developers engaging in this indulgence of their fathers sins.

    The other flagship product is run by a different group altogether, and they've spent the last year ripping out all the outdated/horrible stuff and building a brand new core so we can ditch DNN.

    Yes. DNN.

    Those guys are a-OK with me.

    jungleroomx on
  • RandomHajileRandomHajile Not actually a Snatcher The New KremlinRegistered User regular
    About mid-way through my 12-year time in this job, I got an urgent call from one of the plants about a DOS machine running a homegrown QBasic program for river temperature tracking. Next to it, there was a sheet of instructions on how to back up the program/data to floppy disk weekly. Guess how often they had done that (spoiler, never). Now, a little bit on this program: it needs the average river temperature for the entire previous year, the average for the same month of the previous year, and the data for the same day of the previous year. Oh, did I mention that it is hourly data entered manually? "Luckily" I guess, they also saved the printed versions of this data just in case. Also luckily, I had previously taught a QB class at a local community college, so I fixed the program to save to a network drive and print to a network printer via LPT1 on an XP machine. (And a couple minor date bugs that the guy who wrote it--chemical engineer--left in.) Anyway, they paid a temp to come in and type in the entire previous year up to the current date. And I'm pretty sure that program is still running in an XP Mode VM on that clerk's Win 7 PC. Man, I'll have to check.

    It's all just manually entered data, that from your description only has some averaging calculations thrown on top, that doesn't tie into anything besides needing to print, right? Sounds like they should just be using a spreadsheet rather than relying a qbasic program running on an end-of-life OS, running as a VM, in a specialized hypervisor that only exists on an OS that's EOL in 3 years.
    Yep! (The clerk is very set in her ways, though, and it works for now.)

  • RandomHajileRandomHajile Not actually a Snatcher The New KremlinRegistered User regular
    About mid-way through my 12-year time in this job, I got an urgent call from one of the plants about a DOS machine running a homegrown QBasic program for river temperature tracking. Next to it, there was a sheet of instructions on how to back up the program/data to floppy disk weekly. Guess how often they had done that (spoiler, never). Now, a little bit on this program: it needs the average river temperature for the entire previous year, the average for the same month of the previous year, and the data for the same day of the previous year. Oh, did I mention that it is hourly data entered manually? "Luckily" I guess, they also saved the printed versions of this data just in case. Also luckily, I had previously taught a QB class at a local community college, so I fixed the program to save to a network drive and print to a network printer via LPT1 on an XP machine. (And a couple minor date bugs that the guy who wrote it--chemical engineer--left in.) Anyway, they paid a temp to come in and type in the entire previous year up to the current date. And I'm pretty sure that program is still running in an XP Mode VM on that clerk's Win 7 PC. Man, I'll have to check.

    It's all just manually entered data, that from your description only has some averaging calculations thrown on top, that doesn't tie into anything besides needing to print, right? Sounds like they should just be using a spreadsheet rather than relying a qbasic program running on an end-of-life OS, running as a VM, in a specialized hypervisor that only exists on an OS that's EOL in 3 years.
    Yep! (The clerk is very set in her ways, though, and it works for now.)
    Welp, I checked. It looks like they quit using it in late 2014.

  • BlazeFireBlazeFire Registered User regular
    That sounds like something their control system should be taking care of. The measuring, data recording, and calculating.

  • SiliconStewSiliconStew Registered User regular
    About mid-way through my 12-year time in this job, I got an urgent call from one of the plants about a DOS machine running a homegrown QBasic program for river temperature tracking. Next to it, there was a sheet of instructions on how to back up the program/data to floppy disk weekly. Guess how often they had done that (spoiler, never). Now, a little bit on this program: it needs the average river temperature for the entire previous year, the average for the same month of the previous year, and the data for the same day of the previous year. Oh, did I mention that it is hourly data entered manually? "Luckily" I guess, they also saved the printed versions of this data just in case. Also luckily, I had previously taught a QB class at a local community college, so I fixed the program to save to a network drive and print to a network printer via LPT1 on an XP machine. (And a couple minor date bugs that the guy who wrote it--chemical engineer--left in.) Anyway, they paid a temp to come in and type in the entire previous year up to the current date. And I'm pretty sure that program is still running in an XP Mode VM on that clerk's Win 7 PC. Man, I'll have to check.

    It's all just manually entered data, that from your description only has some averaging calculations thrown on top, that doesn't tie into anything besides needing to print, right? Sounds like they should just be using a spreadsheet rather than relying a qbasic program running on an end-of-life OS, running as a VM, in a specialized hypervisor that only exists on an OS that's EOL in 3 years.
    Yep! (The clerk is very set in her ways, though, and it works for now.)
    Welp, I checked. It looks like they quit using it in late 2014.

    Hooray for small miracles!

    Just remember that half the people you meet are below average intelligence.
    RandomHajile
This discussion has been closed.