fetchstats login failed

Follow
Avatar
katsmeow

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?

0

Comments

27 comments

Sort by Date Votes
  • Avatar
    katsmeow

    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.

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    "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

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    "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!

    0
    Comment actions Permalink
  • Avatar
    katsmeow

    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. 

     

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    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.

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    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

    0
    Comment actions Permalink
  • Avatar
    katsmeow

    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.

    0
    Comment actions Permalink
  • Avatar
    rotblitz

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

    0
    Comment actions Permalink
  • Avatar
    katsmeow

    "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!

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    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.

    0
    Comment actions Permalink
  • Avatar
    katsmeow

    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..??

     

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    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.

    0
    Comment actions Permalink
  • Avatar
    katsmeow

    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

    0
    Comment actions Permalink
  • Avatar
    katsmeow

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

     

    0
    Comment actions Permalink
  • Avatar
    mattwilson9090

    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.

    0
    Comment actions Permalink
  • Avatar
    uaruss

    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??!?!?

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    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.

    0
    Comment actions Permalink
  • Avatar
    uaruss (Edited )

    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.

    0
    Comment actions Permalink
  • Avatar
    rotblitz

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

    0
    Comment actions Permalink
  • Avatar
    uaruss

    Here's a screenshot.  The black box are the curl attempts.  The blue box is bash of course.  You'll see "Home" as the networkID on the last 2 bash attempts.  On all of the other attempts, I used the actual number that appears in the URL.  Thanks!

     

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    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.

    0
    Comment actions Permalink
  • Avatar
    uaruss

    I grabbed the code from github and was able to get it working.  FWIW, I used the "@" symbol in the email address and it worked successfully.  Thanks.

    0
    Comment actions Permalink
  • Avatar
    rotblitz (Edited )

    Interesting.  Where did you get the original script from which did not work?

    0
    Comment actions Permalink
  • Avatar
    khalma1r

    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 If

    Regards,

    Mohammad

    1
    Comment actions Permalink
  • Avatar
    starbus

    Mohammad's tip to comment out 4 lines worked for me!!!

    Now, please tell me: How can I pipe the massive CSV output dump to a text file on my hard drive?

    0
    Comment actions Permalink
  • Avatar
    rotblitz

    See https://support.opendns.com/hc/en-us/community/posts/220022787

    0
    Comment actions Permalink
  • Avatar
    emailzolder (Edited )

    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.vbs

    C:\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.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post