topic Re: fetchstats login failed in OpenDNS

fetchstats login failed

katsmeow — Fri, 09 Oct 2015 05:54:45 GMT

I've tried everything to get fetchstats to work but always get "login failed. check username and password."

Although I confirmed I can log into the website with this password, and that I'm not using any characters reserved for url encoding, I tried changing the password anyway. Same result.

My password does contain an exclamation point, which is not reserved but I tried escaping it anyway. Same result.

I tried running the script in an elevated command prompt. Same result.

I tried giving "full control" permission to administrators, and the username I'm logged in with. Same result.

I've tried variations on the command entered, eg :

cscript //NoLogo fetchstats.vbs myemail@domain.com 12345678 2015-10-08

cscript //NoLogo fetchstats.vbs myemail@domain.com 12345678 2015-10-08 2015-10-08

cscript //NoLogo fetchstats.vbs myemail@domain.com all 2015-10-08

cscript //NoLogo fetchstats.vbs myemail@domain.com networkname 2015-10-08

(The last one was found here in the forums : https://support.opendns.com/entries/70378300-fetchstats-throwing-Login-failed-error-with-correct-password)

Any other ideas?

Re: fetchstats login failed

katsmeow — Fri, 09 Oct 2015 05:59:18 GMT

wow - I just posted for the first time and now see that the forum is pulling my gravatar pic associated with my email address. How can I stop this other than changing my email address? I would not have posted here if I'd known it would be accompanied by my pic.

Re: fetchstats login failed

rotblitz — Fri, 09 Oct 2015 11:09:07 GMT

"I've tried everything"

That was too much and almost useless. This "login failed. check username and password." was unrelated to Windows security, so tampering with access rights, elevation and stuff had to be unsuccessful. The first version of your command lines should work. The second version is for use with a range of dates, so the dates should be different.

You may try the following to exclude the possibility that you unintended mistype the password (or the keyboard interprets it differently):

echo YourPasswordHere| cscript //NoLogo fetchstats.vbs myemail@domain.com 12345678 2015-10-08

(Note the | (pipe) character after the password.)

If it still does not help, check if your user name (e-mail address) could be the culprit. Or change your password at the Dyn website, e.g. without exclamation mark, and try again.

Here are even more hints around fetchstats: https://support.opendns.com/entries/21691004-opendns-fetchstats

Re: fetchstats login failed

rotblitz — Fri, 09 Oct 2015 11:13:06 GMT

"How can I stop this other than changing my email address?"

You visit gravatar.com and change or delete the picture for your e-mail address which you registered with OpenDNS.

Also...

"change your password at the Dyn website" - That was nonsense and should have read "OpenDNS website", of course!

Re: fetchstats login failed

katsmeow — Fri, 09 Oct 2015 14:57:12 GMT

Thanks for your reply. I tried

echo YourPasswordHere| cscript //NoLogo fetchstats.vbs myemail@domain.com 12345678 2015-10-08

Same result.

I know I'm entering the username and password correctly, since it logs me into the site just fine. I already tried changing password too - opendns requires a special character in the password, otherwise I would try without one, but I looked up the reserved characters and chose ( but this did not work either.

I'm at a loss.

Re: fetchstats login failed

rotblitz — Fri, 09 Oct 2015 14:58:19 GMT

Hmm, better don't change or delete the picture at gravatar.com, else it will disappear also in the blogs you have published at.
Your best bet is to change your e-mail address at OpenDNS to one which has no or another picture at gravatar.com assigned.

Re: fetchstats login failed

rotblitz — Fri, 09 Oct 2015 15:12:36 GMT

The special characters can be one or more of dot, dash or under-bar without problems.

Most likely your e-mail address is the culprit. Try with escaping the @ character with %40
Under certain CMD circumstances this may need to be %%40

Re: fetchstats login failed

katsmeow — Sat, 10 Oct 2015 00:47:27 GMT

Thanks again for your response, but I'm still getting nowhere.

I did go ahead and change the password to use a dot instead of the other characters, hoping that was the problem... nope.

I tried entering the password as myemail%40@domain.com and as myemail%%40@domain.com - nope.

Just to be sure, I re-downloaded the fetchstats.vbs code (which I pasted into notepad++ and saved as a vbs file)

One thing that I remembered when I did this - when I try to save this in the root (c:\) windows 7 tells me I don't have permission (maybe because I'm not running notepad++ with admin permissions?) so I saved it elsewhere and copied it to c:\ This is what initially made me think it may be a permission issue, although the script seems to run fine because it prompts me for my password.

Baffled.

Thanks again though.

Re: fetchstats login failed

rotblitz — Sat, 10 Oct 2015 10:07:28 GMT

URL escaping (or better encoding) means to replace a character, not to add something: myemail%40example.com
https://en.wikipedia.org/wiki/Percent-encoding

Re: fetchstats login failed

katsmeow — Sun, 11 Oct 2015 23:30:17 GMT

"URL escaping (or better encoding) means to replace a character, not to add something"

sorry, I was only familiar with escaping code, not urls.

so I tried replacing the @ with %40 and %%40 ... still no luck.

I'll try anything - exporting these page by page is getting old!

Re: fetchstats login failed

rotblitz — Mon, 12 Oct 2015 10:16:20 GMT

At this point I'm running out of ideas. I had to reproduce it with your details to get more insight which is not what you want, because you had to provide me with your credentials.

No matter, as you seem to be the only user reporting these issues here, it is most likely that you do something wrong. But I don't know what.
Hoping that somebody else may be able to help you. For example, you could try to reach out to the author Richard Crowley.

Re: fetchstats login failed

katsmeow — Mon, 12 Oct 2015 14:31:18 GMT

Thanks anyway. I would have to agree that it would seem I'm doing something wrong, but I cannot image what. It's a fairly simple process - and it appears the script IS working since it prompts for the password. And I've confirmed dozens of times that I'm using the same username and password that I log into the site with. Just for grins, I even changed my email (username) and password, but the script login failed with the new credentials also.

Hopefully someone else has experienced this and found a solution they will share..??

Re: fetchstats login failed

rotblitz — Mon, 12 Oct 2015 14:43:38 GMT

One last idea: did you ensure that your network ID is yours and not somebody else's?

You find your numeric network ID if you hover over it's IP address or stats icon at https://dashboard.opendns.com/settings/ as part of the link URL.

Re: fetchstats login failed

katsmeow — Mon, 12 Oct 2015 15:11:26 GMT

yep, copied it from the url. Visually checked it to make sure I copied it correctly (did this probably a dozen times)

also tried with "all" and with the network label.

thanks for trying rotblitz

Re: fetchstats login failed

katsmeow — Mon, 19 Oct 2015 01:04:12 GMT

Is there something that could be blocking my login? like my firewall or something on my router?

Re: fetchstats login failed

mattwilson9090 — Mon, 19 Oct 2015 06:09:00 GMT

It's possible, but since you are getting a "login failed" message that tends to indicate at least some communication with the server. You could try looking in your firewall/router logs to see what is being blocked.

I'm not sure what kind of device you are trying to make this work from, but for a test you could try bypassing the firewall somehow, or taking it to a different network.

Re: fetchstats login failed

uaruss — Mon, 17 Oct 2016 17:32:21 GMT

any luck with this? I'm stuck on the same issue. Why isn't there a download all button, instead of page by page on the web GUI??!?!?

Re: fetchstats login failed

rotblitz — Mon, 17 Oct 2016 18:42:53 GMT

What is this "same issue"? Can't you login? (This would be the "same issue".)

The "download all" button is missing, because OpenDNS have not foreseen this. But you can use the opendns-fetchstats tool to download all pages from a start date to an end date, no matter how many pages there are.

Re: fetchstats login failed

uaruss — Mon, 17 Oct 2016 19:43:06 GMT

Correct, I cannot login.

I've tried the following...

Changed my password multiple times and googled URL special character encoding (https://perishablepress.com/stop-using-unsafe-characters-in-urls/). I also reviewed your link to the percent encoding on wiki (good info)
Currently, my special character in my long-ish password is a ".", although I have tried others as well.
Using the number of the network (found in the dashboard URL) and the name of it.
Using both the %40 and %%40 for the "@" character
All of these in both the curl VBS and the bash script
Using the 'echo' command with the password in curl
Different wifi networks

Any help is greatly appreciated.

Re: fetchstats login failed

rotblitz — Tue, 18 Oct 2016 06:14:14 GMT

What is the exact error message? Or can you post a screen shot?