ISC Open Source Projects issueshttps://gitlab.isc.org/groups/isc-projects/-/issues2020-01-24T11:02:26Zhttps://gitlab.isc.org/isc-projects/kea/-/issues/963update documentation about mysql performance improvement2020-01-24T11:02:26ZWlodzimierz Wencelupdate documentation about mysql performance improvementnote about using `innodb_flush_log_at_trx_commit=2` is only in the source code - we should add this to basic mysql documentation in ARMnote about using `innodb_flush_log_at_trx_commit=2` is only in the source code - we should add this to basic mysql documentation in ARMkea1.7.4Wlodzimierz WencelWlodzimierz Wencelhttps://gitlab.isc.org/isc-projects/stork/-/issues/59Req 5.6 - View Query Activity2020-04-07T15:18:34ZVicky Riskvicky@isc.orgReq 5.6 - View Query ActivityAs an administrator I would like to be able to see the queries per second received and answered per server.
I would like to see a line chart so I can see time of day patterns, and trends, spikes or dips from the 'usual' level of activity...As an administrator I would like to be able to see the queries per second received and answered per server.
I would like to see a line chart so I can see time of day patterns, and trends, spikes or dips from the 'usual' level of activity. This will help identify the best times for maintenance activities (low usage times) and will help in capacity planning.0.7Vicky Riskvicky@isc.orgVicky Riskvicky@isc.orghttps://gitlab.isc.org/isc-projects/stork/-/issues/52Req 3.4 - Log viewer2020-08-05T22:50:03ZVicky Riskvicky@isc.orgReq 3.4 - Log viewerAs an administrator I would like to easily view the recent logs for a monitored service. I may do this when I see some indicator of a service degradation as a first step in identifying what the problem may be. This requirement is for a ...As an administrator I would like to easily view the recent logs for a monitored service. I may do this when I see some indicator of a service degradation as a first step in identifying what the problem may be. This requirement is for a simple log viewer. This is envisioned initially as a fairly simple display of the log file on an individual server. This is not a massive database of historical logs with analysis. For extensive log analysis I would be willing to go to a separate application to look at more voluminous historical logs and to get searching and sorting and aggregation.
1. It would be ideal if there is a default location for the log file for that service, if Stork can locate the log file. In any case, when initially setting up Stork to monitor the service I would expect to be prompted to optionally specify the location of the log file(s).
1. I am going to do this infrequently, so it is ok if I have to push a button or something to 'fetch the log' and wait a bit for the screen to populate. I would prefer not to have to leave the stork application to view the log, and after I have 'fetched the log' I would like to be able to click around and look at other information in Stork and come back to the log viewer without having to 'refetch' the log.
1. We expect to only fetch the most recent portion of the log (so -tail of say, the most recent 15 minutes or so).
1. If possible, include platform logs (e.g. platform restarts, OS updates...) and stork application logs.
1. It would be ideal if it is possible to display the last log for a service that has died, but this is 'extra credit.'
1. As far as the user interface, it is fine if the log itself is opened in a new separate window or tab.
1. It is understood that a single application may have multiple log channels, so these will be displayed in separate windows or tabs and not aggregated. 0.10Vicky Riskvicky@isc.orgVicky Riskvicky@isc.orghttps://gitlab.isc.org/isc-projects/stork/-/issues/51Req 2.6 - High Availability Status2020-01-14T16:41:14ZVicky Riskvicky@isc.orgReq 2.6 - High Availability StatusAs an administrator, I want to see a green light or other positive visual indicator showing that failover is set up and 'ready to work' if needed.
I also want to see the members of the HA pair and whether it is set up as load balancing ...As an administrator, I want to see a green light or other positive visual indicator showing that failover is set up and 'ready to work' if needed.
I also want to see the members of the HA pair and whether it is set up as load balancing or active/passive.Stork-0.3https://gitlab.isc.org/isc-projects/stork/-/issues/50Req 2.5.1 - Shared Networks Utilization %2020-03-24T17:08:13ZVicky Riskvicky@isc.orgReq 2.5.1 - Shared Networks Utilization %As an administrator I want to monitor address utilization % by shared networkAs an administrator I want to monitor address utilization % by shared network0.6https://gitlab.isc.org/isc-projects/stork/-/issues/49Req 2.5.0 - Shared Networks List2020-03-06T18:42:50ZVicky Riskvicky@isc.orgReq 2.5.0 - Shared Networks ListAs an user I can browse list of shared networks.
Per server, what shared networks are configured, with what ranges?
* [x] SubnetID, pools within the subnet - !72
* [x] How many addresses? (compute, some of our users have trouble figur...As an user I can browse list of shared networks.
Per server, what shared networks are configured, with what ranges?
* [x] SubnetID, pools within the subnet - !72
* [x] How many addresses? (compute, some of our users have trouble figuring this out!) !86
* [x] How many of these addresses are currently assigned, how many of these addresses are available for use? !86
Related requirement for pool utilization for shared networks0.5Vicky Riskvicky@isc.orgVicky Riskvicky@isc.orghttps://gitlab.isc.org/isc-projects/stork/-/issues/47Req 2.4 - Subnets List2020-03-09T20:34:28ZVicky Riskvicky@isc.orgReq 2.4 - Subnets ListAs an administrator I want to browse a list of subnets.
* [x] I would like to see for a specified server, what subnets are configured (with what subnetID), and with what address ranges? !63
* [x] For a specified subnet, I would like to...As an administrator I want to browse a list of subnets.
* [x] I would like to see for a specified server, what subnets are configured (with what subnetID), and with what address ranges? !63
* [x] For a specified subnet, I would like to see which servers can hand out addresses in that subnet (e.g. in case of HA overlapping pools)
* [x] For a given SubnetID, I would like to see the pools within the subnet. !63
* [x] How many addresses are included in each subnet and or pool? (Please compute this for me and display the # of addresses)
* [x] ~~For a given subnet and or pool, how many of the allocated addresses are currently assigned, and how many of these addresses are available for use? This is often graphically displayed with a visual indicator that permits me to quickly scan for highly-utilized subnets and pools.~~ (this is pool utilization, moved to req 2.4.1, see #156)
Details
This requirement overlaps somewhat with requirement 2.4.1, pool utilization.
* Max number of subnets we will display in Stork is 1024 subnets0.5Vicky Riskvicky@isc.orgVicky Riskvicky@isc.orghttps://gitlab.isc.org/isc-projects/stork/-/issues/45Req 2.2 - Host Reservations List2020-06-23T15:59:26ZVicky Riskvicky@isc.orgReq 2.2 - Host Reservations ListAs an administrator, I would like to be able to browse a list of host reservations.
* [ ] I would like to be able to sort this list by IP, ~~date the lease was assigned to a client,~~ or host name.
* [x] I would like to be able to searc...As an administrator, I would like to be able to browse a list of host reservations.
* [ ] I would like to be able to sort this list by IP, ~~date the lease was assigned to a client,~~ or host name.
* [x] I would like to be able to searching for a host reservation based on IP address
* [x] I would like to be able to searching for a host reservation based on hostname
* [ ] ~~I would like to be able to apply a filter to show either all addresses assigned, or all host reservations not claimed.~~
* [ ] ~~I would like to see if a lease for this reservation has actually been requested and assigned.~~
* [ ] ~~I would like to see the pxeboot file option value for each host.~~
* [x] Filter the reservations list by type (hw-address, duid, client-id, flex-id etc)
* [x] Search for a host reservation based on MAC address, client-id, duid, flex-id values.
There were several more requirements here that needed lease information. I moved them to #237.
Those related to displaying options were pushed back to #314.
Details:
* What additional options from the HR can we display?0.9https://gitlab.isc.org/isc-projects/stork/-/issues/43Req 1.8 - Dump Service Configuration2022-01-18T14:44:53ZVicky Riskvicky@isc.orgReq 1.8 - Dump Service ConfigurationAs an admin I am able to dump the running configuration of a specified service on a specified server.
I will want to save, open and review the configuration and I may want to email or upload the configuration file to ISC technical suppo...As an admin I am able to dump the running configuration of a specified service on a specified server.
I will want to save, open and review the configuration and I may want to email or upload the configuration file to ISC technical support for assistance.
I am sometimes confused about which configuration file a service is actually running if there is more than one on the server, so please dump the one that is actually running in the service at the time.
This is for debugging purposes. In later releases we would like to be able to parse and display some configuration elements, and to enable the user to alter the configuration and reload it.
Possible details:
I may have more than one of these files from the same or different servers and services, and if they are all named the same thing it won't help me when reviewing them later. If I have used the same filenames on each server (likely) I will need the file names to be more descriptive.
* enable me to specify a filename when saving the file
* possibly have a default filename including the server name and date/time?
* the file can be in the native format of the given service
* I would most often like to save this dump file on the centralized stork server, but if possible I would like to save it on any other network storage available to the stork application.1.0Slawek FigielSlawek Figielhttps://gitlab.isc.org/isc-projects/stork/-/issues/42Req 1.6 - Machine OS Status2019-11-05T18:06:13ZVicky Riskvicky@isc.orgReq 1.6 - Machine OS StatusAs an administrator I can check each machines OS, OS version and operational status. This is so I can tell if I have some servers that need a software update, or possibly I want to run multiple versions for software diversity.
In cases...As an administrator I can check each machines OS, OS version and operational status. This is so I can tell if I have some servers that need a software update, or possibly I want to run multiple versions for software diversity.
In cases where there may be a service that is not running, it would be useful to have a display that shows whether there is an apparent OS failure. In this case I would want the display to show the last known information about the server (presumably it cannot be contacted if the OS is not running.)
There may be overlap between this requirement and requirement 1.4. I need to be able to see the Operating system and running state of each server, in addition to seeing that information for each service on the server. I would definitely prefer not to have to enter this information into Stork myself so if it can be discovered by Stork that would be preferable.
Possible details:
* Operating system
* OS version
* uptime since last reload/restart/rebootStork-0.1https://gitlab.isc.org/isc-projects/stork/-/issues/41Req 1.5 - Application operational status2020-03-03T16:24:20ZVicky Riskvicky@isc.orgReq 1.5 - Application operational statusAs an administrator I need a dashboard that makes it easy to note the current running status of every service and application. This should be a prominent feature of the dashboard and should use clear visual cues to highlight systems with...As an administrator I need a dashboard that makes it easy to note the current running status of every service and application. This should be a prominent feature of the dashboard and should use clear visual cues to highlight systems with non-working applications.
It may also be good to incorporate an Alerts panel with logging of significant status changes.
Note that there may be some servers that I have configured into Stork that are still in the process of being fully deployed.
possible details:
* configured/not configured (?)
* ~~running/not running/running with significant fault condition(?)~~ (moved to separate reqs: #153, #154)
* date/time of last reload/restart
* uptime since last reload (computed)0.5Vicky Riskvicky@isc.orgVicky Riskvicky@isc.orghttps://gitlab.isc.org/isc-projects/stork/-/issues/40Req 1.4 - Application software versions2020-01-20T07:35:40ZVicky Riskvicky@isc.orgReq 1.4 - Application software versionsAs an admin, I would like to be able to quickly scan a list of applications and see the Application version, and optionally also a build#. This is so I can tell which machines may need to be updated, or perhaps I want to run multiple dif...As an admin, I would like to be able to quickly scan a list of applications and see the Application version, and optionally also a build#. This is so I can tell which machines may need to be updated, or perhaps I want to run multiple different software versions for diversity.
* Many users will have their own build systems, or use multiple OSes, so the 'version' field may need to include OS, build#, etc & we need to allow for version #s that do not match ISC version numbers in case of OS packages with different numbering systems.
* It could be useful to have a detail view showing config flags the image was built with.
* If possible, it would be ideal to also report the Hooks loaded (Kea hooks, BIND hooks, BIND RPZ plug-in). How do we report the Kea hook versions?Stork-0.4Vicky Riskvicky@isc.orgVicky Riskvicky@isc.orghttps://gitlab.isc.org/isc-projects/stork/-/issues/39Req 1.3 - Service Role2021-03-05T18:23:15ZVicky Riskvicky@isc.orgReq 1.3 - Service RoleAs an admin I would like to be able to quickly see what is the server's role in the network (Kea:failover primary, failover secondary, failover lb, lease backend, host backend, config backend, BIND: zone primary, secondary, hidden master...As an admin I would like to be able to quickly see what is the server's role in the network (Kea:failover primary, failover secondary, failover lb, lease backend, host backend, config backend, BIND: zone primary, secondary, hidden master.
It if is possible to discover this, that would save me entering it in, but if I must enter it as metadata, it is still valuable to save and display that information for other Stork users.
Where there is a relationship (e.g. primary-secondary, failover pairs) it would be good if Stork understands that so related services can be grouped together in some of the display screens. For example, you might like to see all the secondaries for a primary, or all of the primaries for a given secondary. In the case of Kea I would like to see the HA pairs group together and a clear indication of which is active and which passive, or whether they are lb.1.0-backloghttps://gitlab.isc.org/isc-projects/stork/-/issues/38Req: 1.2 - Application instances per machine2020-01-16T16:55:42ZVicky Riskvicky@isc.orgReq: 1.2 - Application instances per machineAdmin would like to see what applications are installed on each machine.
Applications include
* [ ] dhcpv4
* [ ] dhcpv6
* [ ] ddns
* [ ] Kea hooks
* [ ] BIND 9
* [ ] MySQL/Postgres/Cassandra backend (optional)
* It must be possibl...Admin would like to see what applications are installed on each machine.
Applications include
* [ ] dhcpv4
* [ ] dhcpv6
* [ ] ddns
* [ ] Kea hooks
* [ ] BIND 9
* [ ] MySQL/Postgres/Cassandra backend (optional)
* It must be possible to monitor more than one application per machine, such as multiple Kea machines running on the same machine. Certainly there can be multiple Kea hooks installed and configured.
* As the administrator, I would prefer to not have to enter this information manually if it can be discovered by Stork.Stork-0.4Vicky Riskvicky@isc.orgVicky Riskvicky@isc.orghttps://gitlab.isc.org/isc-projects/stork/-/issues/36Req 1.1: Server Addresses2019-12-03T18:10:49ZVicky Riskvicky@isc.orgReq 1.1: Server AddressesAs an admin I can add Kea, BIND and/or Prometheus servers (their addresses and some metadata) to the management console.
The management console will save that information, and then attempt to connect to them and will show whether that c...As an admin I can add Kea, BIND and/or Prometheus servers (their addresses and some metadata) to the management console.
The management console will save that information, and then attempt to connect to them and will show whether that connection is active and successful, or not.
I also can browse and search them by fields (discovered information and metadata I entered into the management console about the server).Stork-0.2https://gitlab.isc.org/isc-projects/stork/-/issues/35running unittest under the desk that requires Postgres should set up Postgres...2019-10-31T14:00:28ZMichal Nowikowskirunning unittest under the desk that requires Postgres should set up Postgres automaticallyStork-0.1Michal NowikowskiMichal Nowikowskihttps://gitlab.isc.org/isc-projects/kea/-/issues/962Implement the multi_threading_mgr.h idea2019-10-23T15:21:50ZFrancis DupontImplement the multi_threading_mgr.h ideaSee https://gitlab.isc.org/isc-projects/kea/wikis/designs/kea-multithreading-packet-processing
Note the design just gives a raw idea:
- a .cc file is required (no static initialization in a header)
- the constructor
- the class must...See https://gitlab.isc.org/isc-projects/kea/wikis/designs/kea-multithreading-packet-processing
Note the design just gives a raw idea:
- a .cc file is required (no static initialization in a header)
- the constructor
- the class must be split into one returned by the instance static method which has only the get and a second which has both set and get but requires a dynamic cast to be used.
- of course a lot of commentskea1.7.1Francis DupontFrancis Duponthttps://gitlab.isc.org/isc-projects/bind9/-/issues/1282Mysqldyn dlz compile failed2021-10-04T20:03:31ZGhost UserMysqldyn dlz compile failed### Summary
Can't compile **mysqldyn** dlz on Ubuntu 18.04.
```
Linux bind9-compile 4.15.0-65-generic #74-Ubuntu SMP Tue Sep 17 17:06:04 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
```
### BIND version used
```
root@bind9-compile:/opt/bin...### Summary
Can't compile **mysqldyn** dlz on Ubuntu 18.04.
```
Linux bind9-compile 4.15.0-65-generic #74-Ubuntu SMP Tue Sep 17 17:06:04 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
```
### BIND version used
```
root@bind9-compile:/opt/bind9# sbin/named -V
BIND 9.15.5 (Development Release) <id:87676a6ac0>
running on Linux x86_64 4.15.0-65-generic #74-Ubuntu SMP Tue Sep 17 17:06:04 UTC 2019
built by make with '--prefix=/opt/bind9/' '--with-dlz-mysql=yes'
compiled by GCC 7.4.0
compiled with OpenSSL version: OpenSSL 1.1.1 11 Sep 2018
linked to OpenSSL version: OpenSSL 1.1.1 11 Sep 2018
compiled with libxml2 version: 2.9.4
linked to libxml2 version: 20904
compiled with json-c version: 0.12.1
linked to json-c version: 0.12.1
compiled with zlib version: 1.2.11
linked to zlib version: 1.2.11
threads support is enabled
default paths:
named configuration: /opt/bind9/etc/named.conf
rndc configuration: /opt/bind9/etc/rndc.conf
DNSSEC root key: /opt/bind9/etc/bind.keys
nsupdate session key: /opt/bind9/var/run/named/session.key
named PID file: /opt/bind9/var/run/named/named.pid
named lock file: /opt/bind9/var/run/named/named.lock
```
### Steps to reproduce
```
cd bind9/contrib/dlz/modules/mysqldyn/
make
```
```
cc -fPIC -Wall -g -I../include -I/usr/include/mysql -shared -o dlz_mysqldyn_mod.so \
dlz_mysqldyn_mod.c dlz_dbi.o -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lz -lm -lrt -latomic -ldl
dlz_mysqldyn_mod.c: In function ‘makerecord’:
dlz_mysqldyn_mod.c:832:35: error: ‘saveptr’ undeclared (first use in this function)
real_name = strtok_r(buf, "\t", &saveptr);
^~~~~~~
dlz_mysqldyn_mod.c:832:35: note: each undeclared identifier is reported only once for each function it appears in
Makefile:13: recipe for target 'dlz_mysqldyn_mod.so' failed
make: *** [dlz_mysqldyn_mod.so] Error 1
```
### What is the current *bug* behavior?
Can't compile **mysqldyn** dlz.
### Possible fixes
Declare **saveptr** on line 832 in **dlz_mysqldyn_mod.c**.
```
char* saveptr = 0;
```
```
/*
* The format is:
* FULLNAME\tTTL\tDCLASS\tTYPE\tDATA
*
* The DATA field is space separated, and is in the data format
* for the type used by dig
*/
char* saveptr = 0;
real_name = strtok_r(buf, "\t", &saveptr);
if (real_name == NULL)
goto error;
ttlstr = strtok_r(NULL, "\t", &saveptr);
if (ttlstr == NULL || sscanf(ttlstr, "%d", &ttlvalue) != 1)
goto error;
dclass = strtok_r(NULL, "\t", &saveptr);
if (dclass == NULL)
goto error;
type = strtok_r(NULL, "\t", &saveptr);
if (type == NULL)
goto error;
data = strtok_r(NULL, "\t", &saveptr);
if (data == NULL)
goto error;
```https://gitlab.isc.org/isc-projects/stork/-/issues/34enable Danger to check commits2019-10-25T14:01:12ZMichal Nowikowskienable Danger to check commitshttps://danger.systems/guides/getting_started.htmlhttps://danger.systems/guides/getting_started.htmlStork-0.1Tomek MrugalskiTomek Mrugalskihttps://gitlab.isc.org/isc-projects/kea/-/issues/960MySQL connection pool2019-11-20T09:39:57ZFrancis DupontMySQL connection poolkea1.7.2Francis DupontFrancis Dupont