API tools faq
paste
Guest User

Untitled

a guest
Nov 4th, 2018
135
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.90 KB | None | 0 0
raw download clone embed print report
  1. >>> import airflow
  2. >>> from airflow import models, settings
  3. >>> from airflow.contrib.auth.backends.password_auth import PasswordUser
  4. >>> user = PasswordUser(models.User())
  5. >>> user.username = 'new_user_name'
  6. >>> user.email = 'new_user_email@example.com'
  7. >>> user._set_password = 'mypassword'
  8. >>> session = settings.Session()
  9. >>> session.add(user)
  10. >>> session.commit()
  11. >>> session.close()
  12. >>> exit()
  13.  
  14. Traceback (most recent call last):
  15. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
  16. context)
  17. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
  18. cursor.execute(statement, parameters)
  19. sqlite3.OperationalError: no such table: users
  20.  
  21. The above exception was the direct cause of the following exception:
  22.  
  23. Traceback (most recent call last):
  24. File "<stdin>", line 1, in <module>
  25. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 943, in commit
  26. self.transaction.commit()
  27. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 467, in commit
  28. self._prepare_impl()
  29. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 447, in _prepare_impl
  30. self.session.flush()
  31. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2254, in flush
  32. self._flush(objects)
  33. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2381, in _flush
  34. transaction.rollback(_capture_exception=True)
  35. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
  36. compat.reraise(exc_type, exc_value, exc_tb)
  37. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 249, in reraise
  38. raise value
  39. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2345, in _flush
  40. flush_context.execute()
  41. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 395, in execute
  42. rec.execute(self)
  43. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 560, in execute
  44. uow
  45. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
  46. mapper, table, insert)
  47. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 866, in _emit_insert_statements
  48. execute(statement, params)
  49. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute
  50. return meth(self, multiparams, params)
  51. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
  52. return connection._execute_clauseelement(self, multiparams, params)
  53. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
  54. compiled_sql, distilled_params
  55. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
  56. context)
  57. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
  58. exc_info
  59. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
  60. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  61. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
  62. raise value.with_traceback(tb)
  63. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
  64. context)
  65. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
  66. cursor.execute(statement, parameters)
  67. sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users [SQL: 'INSERT INTO users (username, email, password) VALUES (?, ?, ?)'] [parameters: ('[![czambrano', 'some@email.com', b'$2b$12$1r4vhFaJHJEvOssY/EuDMuPQtN26M2crNHRjFowxYSf189P9HRkju'][1]][1])] (Background on this error at: http://sqlalche.me/e/e3q8)
  68.  
  69. ____/ ( ( ) ) ___
  70. /( ( ( ) _ )) ) )
  71. (( ( )( ) ) ( ) )
  72. ((/ ( _( ) ( _) ) ( () ) )
  73. ( ( ( (_) (( ( ) .((_ ) . )_
  74. ( ( ) ( ( ) ) ) . ) ( )
  75. ( ( ( ( ) ( _ ( _) ). ) . ) ) ( )
  76. ( ( ( ) ( ) ( )) ) _)( ) ) )
  77. ( ( ( ) ( (_ ( ) ( ) ) ) ) )) ( )
  78. ( ( ( ( (_ ( ) ( _ ) ) ( ) ) )
  79. ( ( ( ( ( ) (_ ) ) ) _) ) _( ( )
  80. (( ( )( ( _ ) _) _(_ ( (_ )
  81. (_((__(_(__(( ( ( | ) ) ) )_))__))_)___)
  82. ((__) \||lll|l||/// _))
  83. ( /(/ ( ) ) ) )
  84. ( ( ( ( | | ) ) ) )
  85. ( /(| / ( )) ) ) )) )
  86. ( ( ((((_(|)_))))) )
  87. ( ||(|(|)|/|| )
  88. ( |(||(||)|||| )
  89. ( //|/l|||)|\ )
  90. (/ / // /|//||||\ _)
  91. -------------------------------------------------------------------------------
  92. Node: ip-10-7-0-242.ec2.internal
  93. -------------------------------------------------------------------------------
  94. Traceback (most recent call last):
  95. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask/app.py", line 1988, in wsgi_app
  96. response = self.full_dispatch_request()
  97. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask/app.py", line 1641, in full_dispatch_request
  98. rv = self.handle_user_exception(e)
  99. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask/app.py", line 1544, in handle_user_exception
  100. reraise(exc_type, exc_value, tb)
  101. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
  102. raise value
  103. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask/app.py", line 1639, in full_dispatch_request
  104. rv = self.dispatch_request()
  105. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask/app.py", line 1625, in dispatch_request
  106. return self.view_functions[rule.endpoint](**req.view_args)
  107. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask_admin/base.py", line 69, in inner
  108. return self._run_view(f, *args, **kwargs)
  109. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask_admin/base.py", line 368, in _run_view
  110. return fn(self, *args, **kwargs)
  111. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/airflow/www/views.py", line 645, in login
  112. return airflow.login.login(self, request)
  113. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/airflow/contrib/auth/backends/password_auth.py", line 135, in login
  114. if not user.authenticate(password):
  115. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/airflow/contrib/auth/backends/password_auth.py", line 66, in authenticate
  116. return check_password_hash(self._password, plaintext)
  117. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask_bcrypt.py", line 67, in check_password_hash
  118. return Bcrypt().check_password_hash(pw_hash, password)
  119. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/flask_bcrypt.py", line 193, in check_password_hash
  120. return safe_str_cmp(bcrypt.hashpw(password, pw_hash), pw_hash)
  121. File "/home/ubuntu/.local/share/virtualenvs/pampita-jFcteNag/lib/python3.6/site-packages/bcrypt/__init__.py", line 87, in hashpw
  122. ValueError: Invalid salt
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!