<div dir="ltr"><div>Yes we use a distributed version of postgres that works fine upto version 2.3.8 and is compatible . But with the migration of Ipv6 address to type inet is causing use an issue previously that was in varchar so it was working fine. Can you please help us to find a way forward on this issue?.</div><div><br></div>Thanks<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 22, 2024 at 5:00 PM <<a href="mailto:kea-users-request@lists.isc.org">kea-users-request@lists.isc.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send Kea-users mailing list submissions to<br>
<a href="mailto:kea-users@lists.isc.org" target="_blank">kea-users@lists.isc.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/kea-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:kea-users-request@lists.isc.org" target="_blank">kea-users-request@lists.isc.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:kea-users-owner@lists.isc.org" target="_blank">kea-users-owner@lists.isc.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Kea-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Query on KeaDHCP version 2.4.1 (Muhammad Zain)<br>
2. Re: Query on KeaDHCP version 2.4.1 (Kevin P. Fleming)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 22 Feb 2024 16:41:06 +0500<br>
From: Muhammad Zain <<a href="mailto:engr.zaiin@gmail.com" target="_blank">engr.zaiin@gmail.com</a>><br>
To: <a href="mailto:kea-users@lists.isc.org" target="_blank">kea-users@lists.isc.org</a><br>
Subject: [Kea-users] Query on KeaDHCP version 2.4.1<br>
Message-ID:<br>
<<a href="mailto:CAPg2VjZ9-%2BM-6NmXiEqtNv9ebT8efReiz%2BnE0nE0tJdHmDQRvQ@mail.gmail.com" target="_blank">CAPg2VjZ9-+M-6NmXiEqtNv9ebT8efReiz+nE0nE0tJdHmDQRvQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
<br>
I am working on kea stable release version 2.4.1. I am using postgres<br>
compatible database when i load the sql script given at link below<br>
<br>
*Link:*<br>
<a href="https://gitlab.isc.org/isc-projects/kea/-/blob/Kea-2.4.1/src/share/database/scripts/pgsql/dhcpdb_create.pgsql?ref_type=tags" rel="noreferrer" target="_blank">https://gitlab.isc.org/isc-projects/kea/-/blob/Kea-2.4.1/src/share/database/scripts/pgsql/dhcpdb_create.pgsql?ref_type=tags</a><br>
<br>
I am facing error in schema upgrade from<br>
<br>
*<a href="http://upgrade_017_to_018.sh.in" rel="noreferrer" target="_blank">upgrade_017_to_018.sh.in</a> <<a href="http://upgrade_017_to_018.sh.in" rel="noreferrer" target="_blank">http://upgrade_017_to_018.sh.in</a>>. *<br>
<br>
<br>
*Issue is the database I am working on doesn't support INET as primary key.*<br>
The work around is for this is to revert back changes in* issue 2909* given<br>
below<br>
<br>
<br>
*<a href="https://gitlab.isc.org/isc-projects/kea/-/issues/2909" rel="noreferrer" target="_blank">https://gitlab.isc.org/isc-projects/kea/-/issues/2909</a><br>
<<a href="https://gitlab.isc.org/isc-projects/kea/-/issues/2909" rel="noreferrer" target="_blank">https://gitlab.isc.org/isc-projects/kea/-/issues/2909</a>> *<br>
Is there any possible way to use the release 2.4.1 without Migrating IPv6<br>
address to type INET.<br>
<br>
I will be eagerly waiting for your kind remarks on this issue.<br>
<br>
<br>
Best Regards.<br>
Zayn<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="https://lists.isc.org/pipermail/kea-users/attachments/20240222/8ebe6245/attachment-0001.htm" rel="noreferrer" target="_blank">https://lists.isc.org/pipermail/kea-users/attachments/20240222/8ebe6245/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Thu, 22 Feb 2024 06:47:35 -0500<br>
From: "Kevin P. Fleming" <<a href="mailto:lists.kea-users@kevin.km6g.us" target="_blank">lists.kea-users@kevin.km6g.us</a>><br>
To: <a href="mailto:kea-users@lists.isc.org" target="_blank">kea-users@lists.isc.org</a><br>
Subject: Re: [Kea-users] Query on KeaDHCP version 2.4.1<br>
Message-ID: <<a href="mailto:8b5dd491-22a7-40e9-bed6-8b3856f72e08@app.fastmail.com" target="_blank">8b5dd491-22a7-40e9-bed6-8b3856f72e08@app.fastmail.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
On Thu, Feb 22, 2024, at 06:41, Muhammad Zain wrote:<br>
> Hi,<br>
> I am working on kea stable release version 2.4.1. I am using postgres compatible database when i load the sql script given at link below<br>
<br>
> *Issue is the database I am working on doesn't support INET as primary key.<br>
*<br>
> <br>
<br>
These statements contradict each other; if your database does not support using that column type as a primary key, then it's not compatible with the version of PostgreSQL required by Kea.<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="https://lists.isc.org/pipermail/kea-users/attachments/20240222/00cc9a74/attachment-0001.htm" rel="noreferrer" target="_blank">https://lists.isc.org/pipermail/kea-users/attachments/20240222/00cc9a74/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
<br>
ISC funds the development of this software with paid support subscriptions. Contact us at <a href="https://www.isc.org/contact/" rel="noreferrer" target="_blank">https://www.isc.org/contact/</a> for more information.<br>
<br>
Kea-users mailing list<br>
<a href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a><br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/kea-users</a><br>
<br>
<br>
------------------------------<br>
<br>
End of Kea-users Digest, Vol 116, Issue 11<br>
******************************************<br>
</blockquote></div>