Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Windows single sign-on / NTLM question

by talexb (Canon)
on Jan 02, 2019 at 14:50 UTC ( #1227926=note: print w/replies, xml ) Need Help??


in reply to Windows single sign-on / NTLM question

Wow - off the top of my head, that seems like a really clunky solution.

If it's at all possible, I'd see about setting up a read-only account to SQL Server, so that you could at least use DBI, perhaps through ODBC (that's how I'm accessing a SQL Server right now).

Alex / talexb / Toronto

Thanks PJ. We owe you so much. Groklaw -- RIP -- 2003 to 2013.

  • Comment on Re: Windows single sign-on / NTLM question

Replies are listed 'Best First'.
Re^2: Windows single sign-on / NTLM question
by DamnitAddie (Novice) on Jan 02, 2019 at 15:59 UTC

    Indeed, that would be ideal. However, exceptionally unlikely.

    The even clunkier solution was to throw the URL at chrome via a system call and then look for the file in the end user's download directory. I have a working proof of concept of this, but woo buddy that's taking serious liberties with the TIMTOWTDI idea.

    I've got a couple other ideas that are slightly less bush league, but I using native windows auth would be ideal.

      The even clunkier solution was to throw the URL at chrome via a system call and then look for the file in the end user's download directory.

      There are some modules to easily drive Firefox/Chrome on CPAN: chrome, chromium ...

        As a follow-up, in case any other sad sad person wants to do something silly like me.... It appears that the least clunky, but still not 100% Perl solution is to use PowerShell to grab the file. This works for my situation because most of the desktops have PowerShell installed as part of my company's default image and for those who don't, it's approved software on our internal Software Center. In any event, the relevant PS code snip is:

        Invoke-WebRequest -Uri $REMOTE -OutFile $LOCAL -UseDefaultCredentials

        Specifically, that "UseDefaultCredentials" will tell PS to throw your windows login info to the server. I've not actually integrated into my scripts, but as a proof of concept, it works.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1227926]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2019-07-18 02:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?