... | @@ -15,7 +15,7 @@ of MariaDB, attempts to create or update the database will fail with the error ` |
... | @@ -15,7 +15,7 @@ of MariaDB, attempts to create or update the database will fail with the error ` |
|
|
|
|
|
## Kea 1.9.4
|
|
## Kea 1.9.4
|
|
|
|
|
|
The ``kea-admin`` command may fail to upgrade database schema due to missing execute permission on the upgrade scripts. This can be fixed by setting the execute flag. e.g.
|
|
* The ``kea-admin`` command may fail to upgrade database schema due to missing execute permission on the upgrade scripts. This can be fixed by setting the execute flag. e.g.
|
|
|
|
|
|
```
|
|
```
|
|
chmod u+x {prefix}/share/kea/scripts/mysql/*.sh
|
|
chmod u+x {prefix}/share/kea/scripts/mysql/*.sh
|
... | @@ -25,6 +25,32 @@ chmod u+x {prefix}/share/kea/scripts/cql/*.sh |
... | @@ -25,6 +25,32 @@ chmod u+x {prefix}/share/kea/scripts/cql/*.sh |
|
|
|
|
|
The fix for this is already available in #1681 and will be included in the upcoming 1.9.5 release.
|
|
The fix for this is already available in #1681 and will be included in the upcoming 1.9.5 release.
|
|
|
|
|
|
|
|
* If upgrading from 1.9.2 or 1.9.3 the MySQL schema upgrade will fail. This is a bug in the upgrade script that will be fixed in upcoming 1.9.5 release. See #1698 for details. Alternatively, the schema can be fixed manually, but issuing the following SQL commands:
|
|
|
|
|
|
|
|
```
|
|
|
|
ALTER TABLE dhcp4_subnet
|
|
|
|
ADD COLUMN cache_threshold FLOAT DEFAULT NULL,
|
|
|
|
ADD COLUMN cache_max_age INT(10) DEFAULT NULL;
|
|
|
|
|
|
|
|
ALTER TABLE dhcp4_shared_network
|
|
|
|
ADD COLUMN cache_threshold FLOAT DEFAULT NULL,
|
|
|
|
ADD COLUMN cache_max_age INT(10) DEFAULT NULL;
|
|
|
|
|
|
|
|
ALTER TABLE dhcp6_subnet
|
|
|
|
ADD COLUMN cache_threshold FLOAT DEFAULT NULL,
|
|
|
|
ADD COLUMN cache_max_age INT(10) DEFAULT NULL;
|
|
|
|
|
|
|
|
ALTER TABLE dhcp6_shared_network
|
|
|
|
ADD COLUMN cache_threshold FLOAT DEFAULT NULL,
|
|
|
|
ADD COLUMN cache_max_age INT(10) DEFAULT NULL;
|
|
|
|
```
|
|
|
|
|
|
|
|
The above snippet can be written to a kea1.9.4-schema-fix.mysql file and then applied using the following command:
|
|
|
|
|
|
|
|
```
|
|
|
|
$ mysql -u DBUSER -p DBNAME < kea1.9.4-schema-fix.mysql
|
|
|
|
```
|
|
|
|
|
|
## Kea 1.8.0, 1.8.1
|
|
## Kea 1.8.0, 1.8.1
|
|
|
|
|
|
* MariaDB issues listed above in Master also apply to 1.8.
|
|
* MariaDB issues listed above in Master also apply to 1.8.
|
... | | ... | |