An error has occurred！Status code = 401

[Veck Hsiao]

Hi,

I have a problem about using tweeql.

I install tweeql from github on Linux Mint.

I finished initially setting and typed tweeql-command-line.py to run the program

Then I try the example "SELECT text from twitter_sample;", the terminal shows the following error message:

"An error has occurred！Status code = 401"

How could it happen and how to solve it?

Thank,

  Veck

[Adam Marcus]

Veck,

Thanks for trying TweeQL!  According to:

https://dev.twitter.com/docs/error-codes-responses

error 401 suggests your authentication credentials are missing or incorrect.  Did you add a username/password to settings.py?

-Adam

--
You received this message because you are subscribed to the Google Groups "TweeQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tweeql+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Veck Hsiao]

Thanks for replying.

I didn't do that.

I only follow readme said: curl https://raw.github.com/marcua/tweeql/master/settings.py.template > settings.py

Then I can successfully running tweeql-command-line.py.

As you wrote in readme,  when running tweeql, the following messages appeared:

TWITTER_USERNAME and TWITTER_PASSWORD not defined in settings.py
Twitter username: (I typed mine correctly)
Twitter password: (I typed mine correctly)

and the prompt tweeql> appeared.

Do you mean I need to edit setting.py and put both username and password in it?

Adam Marcus於 2013年9月11日星期三UTC+8下午11時18分25秒寫道：

[Veck Hsiao]

I tried it, but still not work.

I'm thinking the possible might be the version of twitter API？

Because from version 1.1 (publish at 2013/03), all authentication should via OAuth?

Veck Hsiao於 2013年9月11日星期三UTC+8下午11時29分02秒寫道：

[Adam Marcus]

Veck,

That's right.  It looks like the fix is around 10 lines of code, but I don't have the time to push it out and test it now.  Would you be willing to give it a shot?  I can point you in the right direction:

We use tweepy for streaming API access.  Here's an example of how tweepy does OAuth authentication on the streaming API:

https://github.com/tweepy/tweepy/blob/master/examples/streaming.py

Based on that, we have to change the following file in TweeQL:

https://github.com/marcua/tweeql/blob/master/tweeql/query_runner.py

Specifically, on lines 24-29 we shouldn't be getting usernames/passwords, but instead getting keys/secrets from settings.py as in the tweepy example.  Then on line 38, we have to instantiate an OAuthHandler rather than a BasicAuthHandler.

Do you have the time to make the change and submit a pull request?  If you do, I'll push out a new version, give you credit, and tweet about it.  Thanks!:)

-Adam

[Veck Hsiao]

OK!

I'll try to do it.

Thanks you.

Veck

Adam Marcus於 2013年9月12日星期四UTC+8上午4時46分31秒寫道：

[Veck Hsiao]

I finished modifying and had made sure that it can work.

Please have a check.

Thanks for giving me a good chance to contribute your project.

Veck

Veck Hsiao於 2013年9月12日星期四UTC+8上午10時48分16秒寫道：