I'm sorry to keep spamming, but I'm frustrated with not being able to solve this, so I can get my website up and running. I'm starting a local Python community, and we've already gotten some members, so it feels silly (and a little embarassing :-/ ) not to have the site running. The command that fails is this:
$ /home/pyvarm/.virtualenvs/PyVarm/bin/python > /home/pyvarm/mezzanine/PyVarm/manage.py createdb --noinput --nodata I've tried running it manually on the production server as well, but it produces the same error then, as it does when I run it through "fab create" (or "fab all") from the development server. It says that the password is wrong (I suppose?), but I have no idea where it's getting the password from, if not from local_settings.py (which I would say is the correct password by definition): $ /home/pyvarm/.virtualenvs/PyVarm/bin/python > /home/pyvarm/mezzanine/PyVarm/manage.py createdb --noinput --nodata > /home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/psycopg2/__init__.py:144: > > UserWarning: The psycopg2 wheel package will be renamed from release 2.8; > in order to keep installing fr > om binary please use "pip install psycopg2-binary" instead. For details > see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>. > """) > Traceback (most recent call last): > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/base.py", > > line 213, in ensure_connection > self.connect() > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/base.py", > > line 189, in connect > self.connection = self.get_new_connection(conn_params) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", > > line 176, in get_new_connection > connection = Database.connect(**conn_params) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/psycopg2/__init__.py", > > line 130, in connect > conn = _connect(dsn, connection_factory=connection_factory, **kwasync) > *psycopg2.OperationalError: FATAL: password authentication failed for > user "PyVarm"* > *FATAL: password authentication failed for user "PyVarm"* > > The above exception was the direct cause of the following exception: > Traceback (most recent call last): > File "/home/pyvarm/mezzanine/PyVarm/manage.py", line 14, in <module> > execute_from_command_line(sys.argv) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/core/management/__init__.py", > > line 364, in execute_from_command_line > utility.execute() > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/core/management/__init__.py", > > line 356, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/core/management/base.py", > > line 283, in run_from_argv > self.execute(*args, **cmd_options) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/core/management/base.py", > > line 330, in execute > output = self.handle(*args, **options) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/mezzanine/core/management/commands/createdb.py", > > line 39, in handle > if "conf_setting" in connection.introspection.table_names(): > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/introspection.py", > > line 53, in table_names > with self.connection.cursor() as cursor: > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/base.py", > > line 254, in cursor > return self._cursor() > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/base.py", > > line 229, in _cursor > self.ensure_connection() > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/base.py", > > line 213, in ensure_connection > self.connect() > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/utils.py", > > line 94, in __exit__ > six.reraise(dj_exc_type, dj_exc_value, traceback) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/utils/six.py", > > line 685, in reraise > raise value.with_traceback(tb) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/base.py", > > line 213, in ensure_connection > self.connect() > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/base/base.py", > > line 189, in connect > self.connection = self.get_new_connection(conn_params) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", > > line 176, in get_new_connection > connection = Database.connect(**conn_params) > File > "/home/pyvarm/.virtualenvs/PyVarm/lib/python3.6/site-packages/psycopg2/__init__.py", > > line 130, in connect > conn = _connect(dsn, connection_factory=connection_factory, **kwasync) > > *django.db.utils.OperationalError: FATAL: password authentication failed > for user "PyVarm"FATAL: password authentication failed for user "PyVarm"* Den söndag 13 januari 2019 kl. 18:23:12 UTC+1 skrev Christer Enfors: > > 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.
