Ughh, I spoke too soon - I'm still getting the same error. :-( "django.db.utils.OperationalError: FATAL: password authentication failed for user "PyVarm"" when I run either "fab all" or just the "fab create" part.
Den söndag 13 januari 2019 kl. 17:45:51 UTC+1 skrev Christer Enfors: > > Never mind - this has now been solved by looking at Travis' excellent > video, as per suggested in another thread: https://youtu.be/snBBOv7F_k4 > > Thanks, Travis! > > Den söndag 13 januari 2019 kl. 12:54:50 UTC+1 skrev Christer Enfors: >> >> Thanks to the helpful nature of people on this list, I've come a bit >> further in my quest to deploy my website. >> >> I'm following along with the Deployment page of the documentation >> <http://mezzanine.jupo.org/docs/deployment.html>, and I'm now up to step >> 4 on "Tutorial - Case 1: deploying to a brand new server". I have set the >> database password in local_settings.py, the DB_PASS field. And "fab all" >> seems to be able to create the database. >> >> >>> $ CREATE USER PyVarm WITH ENCRYPTED PASSWORD '***************'; -> >>> [23.101.79.24] out: sudo password: >>> [23.101.79.24] out: CREATE DATABASE >>> [23.101.79.24] out: >>> $ CREATE DATABASE PyVarm WITH OWNER PyVarm ENCODING = 'UTF8' LC_CTYPE = >>> 'en_US.UTF-8' LC_COLLATE = 'en_US.UTF-8' TEMPLATE template0; -> >>> [23.101.79.24] put: <file obj> -> >>> /home/pyvarm/mezzanine/PyVarm/PyVarm/local_settings.py >> >> >> But then a little later, this section (with the error) comes up - it >> seems to be trying to create a database again, this time with "manage.py >> createdb": >> >> $ /home/pyvarm/.virtualenvs/PyVarm/bin/python >> /home/pyvarm/mezzanine/PyVarm/manage.py createdb --noinput --nodata -> >> >> [23.101.79.24] out: >> /home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/psycopg2/__init__.py:144: >> >> UserWarning: The psycopg2 wheel package will be renamed from release 2.8; >> in order to keep installing from binary please use "pip install >> psycopg2-binary" instead. For deta[23.101.79.24] out: >> td.org/psycopg/docs/install.html#binary-install-from-pypi>. >> [23.101.79.24] out: """) >> [23.101.79.24] out: Traceback (most recent call last): >> [23.101.79.24] out: File "/home/pyvarm/mezzanine/PyVarm/manage.py", >> line 14, in <module> >> [23.101.79.24] out: execute_from_command_line(sys.argv) >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: nt/__init__.py", line 364, in execute_from_command_line >> [23.101.79.24] out: utility.execute() >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: nt/__init__.py", line 356, in execute >> [23.101.79.24] out: >> self.fetch_command(subcommand).run_from_argv(self.argv) >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: nt/base.py", line 283, in run_from_argv >> [23.101.79.24] out: self.execute(*args, **cmd_options) >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: nt/base.py", line 330, in execute >> [23.101.79.24] out: output = self.handle(*args, **options) >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ement/commands/createdb.py", line 39, in handle >> [23.101.79.24] out: if "conf_setting" in >> connection.introspection.table_names(): >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ase/introspection.py", line 53, in table_names >> [23.101.79.24] out: with self.connection.cursor() as cursor: >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ase/base.py", line 254, in cursor >> [23.101.79.24] out: return self._cursor() >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ase/base.py", line 229, in _cursor >> [23.101.79.24] out: self.ensure_connection() >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ase/base.py", line 213, in ensure_connection >> [23.101.79.24] out: self.connect() >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: line 94, in __exit__ >> [23.101.79.24] out: six.reraise(dj_exc_type, dj_exc_value, traceback) >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ase/base.py", line 213, in ensure_connection >> [23.101.79.24] out: self.connect() >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ase/base.py", line 189, in connect >> [23.101.79.24] out: self.connection = >> self.get_new_connection(conn_params) >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ostgresql/base.py", line 176, in get_new_connection >> [23.101.79.24] out: connection = Database.connect(**conn_params) >> [23.101.79.24] out: File >> "/home/pyvarm/.virtualenvs/PyVarm/local/lib/python2.7/site-packages/[23.101.79.24] >> >> out: ", line 130, in connect >> [23.101.79.24] out: conn = _connect(dsn, >> connection_factory=connection_factory, **kwasync) >> [23.101.79.24] out: django.db.utils.OperationalError: FATAL: password >> authentication failed fo[23.101.79.24] out: >> [23.101.79.24] out: FATAL: password authentication failed for user >> "PyVarm" >> [23.101.79.24] out: >> [23.101.79.24] out: >> Fatal error: run() encountered an error (return code 1) while executing >> '/home/pyvarm/.virtualenvs/PyVarm/bin/python >> /home/pyvarm/mezzanine/PyVarm/manage.py createdb --noinput --nodata' >> >> Aborting. >> Disconnecting from 23.101.79.24... done. >> >> >> Given that there's only one place (local_settings.py) to enter the >> password, I don't understand how a mismatch can arise. Could it perhaps be >> that the password is correct, but something other than an incorrect >> password is giving the "password authentication failure" error? >> >> I've been running "fab all" many times now, and inbetween each time I >> completely uninstall all postgresql packages (apt remove --purge) to avoid >> conflicts ("the database already exists", etc, because it was created last >> time I ran "fab all". Perhaps in the future, I can help make "fab all" >> idempotent). Perhaps I should now try following the documentation >> <http://mezzanine.jupo.org/docs/deployment.html> for Case 2: Deploying >> to an existing server instead? But I'm hesitant to just try it, for fear >> that I might mess things up further. >> > -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
