topic Saspy not finding authkey in _authinfo (windows, IOM) in SAS Programming

Saspy not finding authkey in _authinfo (windows, IOM)

ts3 — Wed, 28 Jul 2021 18:59:20 GMT

When I connect using

sas = saspy.SASsession(cfgname='winlocal')

I get

Did not find key AKEY in authinfo file:C:\Users\myuser\_authinfo

The format of _authinfo is correct, followed docs and is exactly this:

AKEY user <myuser> password <mypassword>

If I log in when prompted everything works, I am connected and can run queries, access tables etc. The only thing not working is the authkey. Permissions on _authinfo allow access as well.

Re: Saspy not finding authkey in _authinfo (windows, IOM)

jimbarbour — Wed, 28 Jul 2021 19:13:22 GMT

This may not be the issue, but let's eliminate one possible cause of this problem. Open a Windows Explorer session and navigate to

C:\Users\myuser

Click on "View", "Options", and then "Change Folder and Search Options".

The below pop-up should appear. Make sure that the indicated check box is NOT checked. If it is checked, un-check it, and click "OK".

Now look for the file _authinfo with no file extension in your Windows Explorer session. This is the file that is being used. Now look for _authinfo.txt. This possibly is the file you saved if you used something like Notepad.exe to add your ID and password to the file. Windows automatically adds .txt if you use Notepad. You won't see this unless the check box in the options shown above is un-checked.

If there is a _authinfo.txt that has the correct ID and password, rename _authinfo (with no file extension) to _authinfo.bak and rename _authinfo.txt to just _authinfo. Try running again.

Jim

Re: Saspy not finding authkey in _authinfo (windows, IOM)

ts3 — Wed, 28 Jul 2021 19:21:10 GMT

Nope no extension, and type is just plain `File` not txt or anything. I made it with a different text editor so I wouldn't have to deal with notepad adding extensions and it'd just save as normal plaintext.

Re: Saspy not finding authkey in _authinfo (windows, IOM)

jimbarbour — Wed, 28 Jul 2021 19:30:12 GMT

OK, worth a shot, and certainly one to eliminate up front.

And

Does it contain any special characters?
What is the encoding? Is it ASCII, Unicode, or ?

Jim

Re: Saspy not finding authkey in _authinfo (windows, IOM)

jimbarbour — Wed, 28 Jul 2021 19:36:13 GMT

If that's not the issue (again, just eliminating possibilities), then check this out and see if it sheds any light:

https://communities.sas.com/t5/SAS-Programming/Sas-Authkey/m-p/581062#M165112

Jim

Re: Saspy not finding authkey in _authinfo (windows, IOM)

ts3 — Wed, 28 Jul 2021 19:47:42 GMT

no special characters notepad++ encoding indicates UTF-8 LE BOM

Re: Saspy not finding authkey in _authinfo (windows, IOM)

ts3 — Wed, 28 Jul 2021 19:50:31 GMT

Yeah I've seen that post. My format is the one quoted from the docs there, and my _authinfo file *is* being found, so I do not believe it applies here.

Re: Saspy not finding authkey in _authinfo (windows, IOM)

jimbarbour — Wed, 28 Jul 2021 20:20:58 GMT

Well, crap. OK, see my response (will post in a few minutes) to my encoding response.

Jim

Re: Saspy not finding authkey in _authinfo (windows, IOM)

jimbarbour — Wed, 28 Jul 2021 20:23:09 GMT

Can you try just saving it as ASCII? Grasping at straws here, but let's eliminate all possibilities that it's some odd ball encoding issue. I think you could just cut and paste into a Notepad, taking care to delete the .txt extension afterwards (or saving as type *.*).

Jim

Re: Saspy not finding authkey in _authinfo (windows, IOM)

ts3 — Wed, 28 Jul 2021 20:30:22 GMT

That did it, well I guess its good to know that it requires ASCII.. Thanks! This is actually taking place on 1 of 2 computers I have this set up on, and on the first I believe I did use (regular) notepad and saved it w/o extension, and got the same result.

To clearly state what I did, I used the encoding drop-down menu in notepad++ to switch the encoding to ANSI.

Re: Saspy not finding authkey in _authinfo (windows, IOM)

jimbarbour — Wed, 28 Jul 2021 20:34:50 GMT

OK, cool. (about time, lol)

Everything you were doing sounded right to me, so I started looking for oddball stuff like file extensions and encodings that would keep correctly coded parameters from working. Glad I finally got it right. I was running out of hunches. 🙂

Jim

Re: Saspy not finding authkey in _authinfo (windows, IOM)

ts3 — Wed, 28 Jul 2021 20:36:15 GMT

It seems to work with plain UTF-8 as well, but not other variants. Yeah I was really at a loss because everything else worked haha.