Hi Ben, I'm not sure what to make of those errors. It does appear that changing database ownership is the correct course of action: https://gitlab.isc.org/isc-projects/kea/-/issues/2773
I'd say perform some tests and make sure that leases are successfully stored in the database (perhaps use the API to retrieve some leases). Keep an eye on logs for any error messages. Thank you, Darren Ankney On Tue, Oct 17, 2023 at 2:35 PM Ben Bridges <bbrid...@springnet.net> wrote: > > Hi, > > > > I am trying to install the Kea DHCP4 server on Ubuntu 22.04 with PostgreSQL > v16. When I try to create the database tables with kea-admin, I get the > following error: > > > > psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:36: ERROR: permission > denied for schema public > > LINE 1: CREATE TABLE lease4 ( > > > > I had granted all privileges on the public schema (as well as all privileges > to the kea database) to the kea user. I read that in postgresql v16 only the > owner of a database can create objects in it, so I changed the owner of the > kea database to be the kea user and re-ran “kea-admin db-init” to initialize > the kea database. I did not get the above error, and the “kea-admin > db-version …” command now returns ’18.0’, but the “kea-admin db-init” command > did output the following NOTICEs: > > > > psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:140: NOTICE: function > lease4dumpheader() does not exist, skipping > > psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:148: NOTICE: function > lease4dumpdata() does not exist, skipping > > psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:178: NOTICE: function > lease6dumpheader() does not exist, skipping > > psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:186: NOTICE: function > lease6dumpdata() does not exist, skipping > > > > Are those message ok? Did I do the correct thing by changing the owner of > the kea database to be the kea user? Will that cause problems later when Kea > is upgraded to a newer version? Should the owner of the kea database be > changed back to the root user after it is initialized? Should the kea user > be granted all privileges on the public schema as I did? > > > > Thanks, > > .Ben Bridges. > > > > -- > ISC funds the development of this software with paid support subscriptions. > Contact us at https://www.isc.org/contact/ for more information. > > To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users. > > Kea-users mailing list > Kea-users@lists.isc.org > https://lists.isc.org/mailman/listinfo/kea-users -- ISC funds the development of this software with paid support subscriptions. Contact us at https://www.isc.org/contact/ for more information. To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users. Kea-users mailing list Kea-users@lists.isc.org https://lists.isc.org/mailman/listinfo/kea-users
