fetchstats login failed
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?
-
"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
-
"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!
-
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.
-
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.
-
URL escaping (or better encoding) means to replace a character, not to add something: myemail%40example.com
https://en.wikipedia.org/wiki/Percent-encoding -
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. -
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..??
-
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.
-
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.
-
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.
-
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.
-
Well, the command syntax is as follows:
cscript //NoLogo fetchstats.vbs UserName network_ID YYYY-MM-DD [YYYY-MM-DD]
The [...] indicates an optional parameter, and the square brackets must not appear.
Do I see a ";" before your %40gmail.com or %%40gmail.com? There shouldn't be a semicolon.
Re network ID, best is to use the numeric network ID. Label name like "Home" definitely cannot work.Also, the opendns-fetchstats tool is not OpenDNS', but from an individual (R. Crowley). You better raise related issues with the author at https://github.com/opendns/opendns-fetchstats or at https://github.com/rcrowley/opendns-fetchstats
Alternatively, if you know how to debug VBS, you can do so to see what username and password is actually submitted in the HTTPS request of the scripts, so that you see what's wrong.
-
Despite it worked for me in 2018, whereas last post in this thread was in 2016, for some reason the original script stopped working now.
Anyways, a workaround that worked for me is to remove the following block from the code (or comment it):
If loginMatches.Count = 0 Then
Wscript.StdErr.Write "Login Failed. Check username and password" & vbCrLf
WScript.Quit 1
End IfRegards,
Mohammad
-
-
Work around fetchstats.vbs
Goto: https://github.com/opendns/opendns-fetchstats/blob/master/fetchstats.vbs
Copy the 106 lines
Open write and paste the 106 lines.
Safe as fetchstats.vbs. change the *.TXT to *.*
Change line 78: regEx.Pattern = ".*Login*"Open DOSpromt with: CMD
Goto DIR where located the fetchstats.vbsC:\Users\name\openDNS>
cscript /NoLogo fetchstats.vbs <username> <network-id> <YYYY-MM-DD> [<YYYY-MM-DD>]
Type: cscript //NoLogo fetchstats.vbs email@xyzmail.com 123459876 2020-03-19 >20200319.csv
Entering
Asking for password and Type your password
Enter And wait a while for data
Goto your DIR where the fetchstats.vbs file is located.
And there is new file whith 20200319.csv
Done.
Please sign in to leave a comment.
Comments
27 comments