tosher/Mediawiker

Chrome cookie auth issue

Closed this issue · 6 comments

LunarTwilight commented

When trying to login to fandom.com wiki, using cookie login (using chrome), this error is thrown:

  >>> Traceback (most recent call last):
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\mwcommands\mw_utils.py", line 762, in get_connect
  >>>     cj = self.get_cookies(name=name) if site['authorization_type'] == self.AUTH_TYPE_COOKIES else None
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\mwcommands\mw_utils.py", line 897, in get_cookies
  >>>     return browser_cookie3.chrome(cookie_files=cookie_files, domain_name=site['host'])
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\lib\browser_cookie3\__init__.py", line 435, in chrome
  >>>     return Chrome(cookie_files, domain_name).load()
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\lib\browser_cookie3\__init__.py", line 250, in load
  >>>     for cookie in self.get_cookies():
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\lib\browser_cookie3\__init__.py", line 303, in get_cookies
  >>>     cur.execute(self.SQLREQ_DOMAIN, ('%%%s' % self.domain_name_tld,))
  >>> sqlite3.OperationalError: no such column: secure

which causes the request to not be authed, and for the saving of the page to abort.

tosher commented

Thank you! In last Chrome versions this column was renamed, i'll update the library.

  • 👍1
LunarTwilight commented

same error, different stack trace:

  >>> Traceback (most recent call last):
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\mwcommands\mw_utils.py", line 762, in get_connect
  >>>     site = self.get_site(name)
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\mwcommands\mw_utils.py", line 897, in get_cookies
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\lib\browser_cookie3\__init__.py", line 435, in chrome
  >>>     # epoch_start = datetime.datetime(1601, 1, 1)
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\lib\browser_cookie3\__init__.py", line 250, in load
  >>>     ]
  >>>   File "C:\Users\retracted\AppData\Roaming\Sublime Text 3\Packages\Mediawiker\lib\browser_cookie3\__init__.py", line 303, in get_cookies
  >>>     break
  >>> sqlite3.OperationalError: no such column: secure
tosher commented

Sublime Text require restart after this upgrade

LunarTwilight commented

Yeah apparently even through I didn't have sublime text open before, it still needed a restart before it worked, and now its working for me, thanks for the fix

tosher commented

Yep, upgrade process starting after ST starts, after that needs restart :)