Hi Jack,
are you sure that a database is running and accepting connections on that
host ip and port?
Greetings,
Oliver
Am Tue, Apr 01, 2025 at 12:01:20AM -0700 schrieb Jack:
> Hi Oliver,
> I added following lines in my playbook file:
> openwisp2_database:
> engine: django.contrib.gis.db.backends.postgis
> name: "openwisp"
> user: "admin"
> host: "192.168.1.20"
> password: "admin"
> port: 5432
> but when run the playbook file, I get these errors:
>
> TASK [openwisp.openwisp2 : Migrate]
> *****************************************************************
> fatal: [192.168.1.20]: FAILED! => {"changed": false, "cmd": ["./manage.py",
> "migrate", "--noinput"], "msg": "\n:stderr: Traceback (most recent call
> last):\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/base/base.py\",
>
> line 289, in ensure_connection\n self.connect()\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/utils/asyncio.py\",
> line 26, in inner\n return func(*args, **kwargs)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/base/base.py\",
>
> line 270, in connect\n self.connection =
> self.get_new_connection(conn_params)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/contrib/gis/db/backends/postgis/base.py\",
>
> line 112, in get_new_connection\n connection =
> super().get_new_connection(conn_params)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/utils/asyncio.py\",
> line 26, in inner\n return func(*args, **kwargs)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/postgresql/base.py\",
>
> line 275, in get_new_connection\n connection =
> self.Database.connect(**conn_params)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/psycopg2/__init__.py\",
> line 122, in connect\n conn = _connect(dsn,
> connection_factory=connection_factory,
> **kwasync)\npsycopg2.OperationalError: connection to server at
> \"192.168.1.20\", port 5432 failed: Connection refused\n\tIs the server
> running on that host and accepting TCP/IP connections?\n\n\nThe above
> exception was the direct cause of the following exception:\n\nTraceback
> (most recent call last):\n File \"/opt/openwisp2/./manage.py\", line 10,
> in <module>\n execute_from_command_line(sys.argv)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/core/management/__init__.py\",
>
> line 442, in execute_from_command_line\n utility.execute()\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/core/management/__init__.py\",
>
> line 436, in execute\n
> self.fetch_command(subcommand).run_from_argv(self.argv)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/core/management/base.py\",
>
> line 412, in run_from_argv\n self.execute(*args, **cmd_options)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/core/management/base.py\",
>
> line 458, in execute\n output = self.handle(*args, **options)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/core/management/base.py\",
>
> line 106, in wrapper\n res = handle_func(*args, **kwargs)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/core/management/commands/migrate.py\",
>
> line 115, in handle\n connection.prepare_database()\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/contrib/gis/db/backends/postgis/base.py\",
>
> line 101, in prepare_database\n with self.cursor() as cursor:\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/utils/asyncio.py\",
> line 26, in inner\n return func(*args, **kwargs)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/base/base.py\",
>
> line 330, in cursor\n return self._cursor()\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/base/base.py\",
>
> line 306, in _cursor\n self.ensure_connection()\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/utils/asyncio.py\",
> line 26, in inner\n return func(*args, **kwargs)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/base/base.py\",
>
> line 288, in ensure_connection\n with self.wrap_database_errors:\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/utils.py\",
> line 91, in __exit__\n raise dj_exc_value.with_traceback(traceback) from
> exc_value\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/base/base.py\",
>
> line 289, in ensure_connection\n self.connect()\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/utils/asyncio.py\",
> line 26, in inner\n return func(*args, **kwargs)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/base/base.py\",
>
> line 270, in connect\n self.connection =
> self.get_new_connection(conn_params)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/contrib/gis/db/backends/postgis/base.py\",
>
> line 112, in get_new_connection\n connection =
> super().get_new_connection(conn_params)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/utils/asyncio.py\",
> line 26, in inner\n return func(*args, **kwargs)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/django/db/backends/postgresql/base.py\",
>
> line 275, in get_new_connection\n connection =
> self.Database.connect(**conn_params)\n File
> \"/opt/openwisp2/env/lib/python3.10/site-packages/psycopg2/__init__.py\",
> line 122, in connect\n conn = _connect(dsn,
> connection_factory=connection_factory,
> **kwasync)\ndjango.db.utils.OperationalError: connection to server at
> \"192.168.1.20\", port 5432 failed: Connection refused\n\tIs the server
> running on that host and accepting TCP/IP connections?\n\n", "path":
> "/opt/openwisp2/env/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin",
>
> "syspath":
> ["/tmp/ansible_django_manage_payload_2clf00hl/ansible_django_manage_payload.zip",
>
> "/usr/lib/python310.zip", "/usr/lib/python3.10",
> "/usr/lib/python3.10/lib-dynload",
> "/usr/local/lib/python3.10/dist-packages",
> "/usr/lib/python3/dist-packages"]}
>
> can you hep me out?
> Greetings,
> Jack
>
> On Monday, 31 March 2025 at 19:18:55 UTC+5:30 Oliver Kraitschy wrote:
>
> > Hi Jack,
> >
> > have a look at the variable 'openwisp2_database' in the role variables:
> >
> > https://openwisp.io/docs/stable/ansible/user/role-variables.html
> >
> > Greetings,
> > Oliver
> >
> > Am Mon, Mar 31, 2025 at 03:44:50AM -0700 schrieb Jack:
> > > Hi,
> > > I have installed openwisp along with freeradius and by default it is
> > using
> > > sqlite database but I want to use PostgreSQL.
> > > Can anyone tell me how to do so and how to link PostgreSQL database with
> > > openwisp and freeradius?
> > > Also, is there any way to specify the database(PostgreSQL) that I want
> > to
> > > use at the time of openwisp installation?
> > > Regards,
> > > Jack
> > >
> > > --
> > > You received this message because you are subscribed to the Google
> > Groups "OpenWISP" group.
> > > To unsubscribe from this group and stop receiving emails from it, send
> > an email to [email protected].
> > > To view this discussion, visit
> > https://groups.google.com/d/msgid/openwisp/e324dc55-e129-4237-a5fb-5b0fbdc9aa14n%40googlegroups.com
> > .
> >
> >
>
> --
> You received this message because you are subscribed to the Google Groups
> "OpenWISP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion, visit
> https://groups.google.com/d/msgid/openwisp/40852f8e-9abe-4a4c-8c21-0532e27be17dn%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups
"OpenWISP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion, visit
https://groups.google.com/d/msgid/openwisp/Z-vxwh3mV8iB4w3y%40obelix.okraits.de.
