]> git.ipfire.org Git - thirdparty/freeradius-server.git/log
thirdparty/freeradius-server.git
5 years agomake 'utc = yes' works for converting strings into unix timestamp
Boris Lytochkin [Mon, 23 Nov 2020 20:21:42 +0000 (23:21 +0300)] 
make 'utc = yes' works for converting strings into unix timestamp
as well.

5 years agodon't error when we see the data that LD_PRELOAD added
Matthew Newton [Fri, 20 Nov 2020 12:30:25 +0000 (12:30 +0000)] 
don't error when we see the data that LD_PRELOAD added

5 years agoupdate documentation
Alan T. DeKok [Thu, 19 Nov 2020 19:37:26 +0000 (14:37 -0500)] 
update documentation

to make it excruciatingly clear what to do

5 years agoSatisfy clang scan
Terry Burton [Wed, 18 Nov 2020 21:25:31 +0000 (21:25 +0000)] 
Satisfy clang scan

5 years agoremove unnecessary assignment to satisfy clang
Terry Burton [Wed, 18 Nov 2020 20:12:07 +0000 (20:12 +0000)] 
remove unnecessary assignment to satisfy clang

Backport 71376698999b17dc7b0d289086966a2b0c84d2dc

5 years agoAdd a GitHub Actions workflow
Terry Burton [Wed, 18 Nov 2020 01:22:09 +0000 (01:22 +0000)] 
Add a GitHub Actions workflow

.travis.yml retained for the time being

5 years agoadd wrapper function
Alan T. DeKok [Wed, 18 Nov 2020 16:26:23 +0000 (11:26 -0500)] 
add wrapper function

5 years agoget the session ID only if we're caching it
Alan T. DeKok [Wed, 18 Nov 2020 16:15:37 +0000 (11:15 -0500)] 
get the session ID only if we're caching it

5 years agomove "cache save" so that it runs after the tls success has been seen
Alan T. DeKok [Wed, 18 Nov 2020 15:51:05 +0000 (10:51 -0500)] 
move "cache save" so that it runs after the tls success has been seen

5 years agoadded "cache refresh" method
Alan T. DeKok [Wed, 18 Nov 2020 15:37:55 +0000 (10:37 -0500)] 
added "cache refresh" method

so that the cache lifetime can be extended when a session is
resumed.

5 years agorename config item to be more standard
Alan T. DeKok [Mon, 16 Nov 2020 21:28:38 +0000 (16:28 -0500)] 
rename config item to be more standard

5 years agoAdd TLS cache wrappers.
Alan T. DeKok [Mon, 16 Nov 2020 21:18:54 +0000 (16:18 -0500)] 
Add TLS cache wrappers.

5 years agoupdate readme for 2020.
Alan T. DeKok [Sun, 15 Nov 2020 14:49:35 +0000 (09:49 -0500)] 
update readme for 2020.

Modern systems can do 10K+ RSA 2048 per second, not dozens

5 years agoadd some notes on CoA for TLS
Alan T. DeKok [Thu, 12 Nov 2020 12:47:29 +0000 (07:47 -0500)] 
add some notes on CoA for TLS

5 years agoupdate Oracle for changes as per commit 42229e776
Alan T. DeKok [Sun, 8 Nov 2020 12:47:16 +0000 (07:47 -0500)] 
update Oracle for changes as per commit 42229e776

5 years agoadd "SELECT true" as fail-over for on/off queries
Alan T. DeKok [Fri, 6 Nov 2020 16:00:17 +0000 (11:00 -0500)] 
add "SELECT true" as fail-over for on/off queries

If there are no rows to update, then the on/off queries will
return "no rows updated".  The server will then fail over to the
next query, which says "that's fine"

5 years agocopied from v4 with edits to make it appropriate for v3
Alan T. DeKok [Wed, 4 Nov 2020 15:22:59 +0000 (10:22 -0500)] 
copied from v4 with edits to make it appropriate for v3

5 years agocopied from v4 with edits to make it appropriate for v3
Alan T. DeKok [Wed, 4 Nov 2020 14:13:42 +0000 (09:13 -0500)] 
copied from v4 with edits to make it appropriate for v3

5 years agorlm_sql: Use the non-xlat escape function for the group membership query
Terry Burton [Mon, 2 Nov 2020 23:46:10 +0000 (23:46 +0000)] 
rlm_sql: Use the non-xlat escape function for the group membership query

Use the basic sql_escape_func when expanding the group membership query that
uses our existing SQL handle.

If we use sql_escape_for_xlat_func, which reserves a connection, then when the
connection pool is exhausted we erroneously conclude that the user is not a
member of any groups.

5 years agoadd some better examples
Alan T. DeKok [Thu, 29 Oct 2020 18:08:22 +0000 (14:08 -0400)] 
add some better examples

5 years agoadd tests for ascend data filters
Alan T. DeKok [Tue, 27 Oct 2020 15:05:08 +0000 (11:05 -0400)] 
add tests for ascend data filters

5 years agoalso allow $-INCLUDE
Alan T. DeKok [Mon, 26 Oct 2020 13:25:10 +0000 (09:25 -0400)] 
also allow $-INCLUDE

because that's what the config file reader uses

5 years agoprintf is more portable than "echo -n"
Alan T. DeKok [Fri, 23 Oct 2020 19:22:55 +0000 (15:22 -0400)] 
printf is more portable than "echo -n"

5 years agoMake sure we never merge flags by mistake
Matthew Newton [Fri, 23 Oct 2020 11:54:30 +0000 (12:54 +0100)] 
Make sure we never merge flags by mistake

5 years agouse "text" instead of "varchar".
Alan T. DeKok [Thu, 22 Oct 2020 14:37:02 +0000 (10:37 -0400)] 
use "text" instead of "varchar".

there's no reason to fix these fields at a small size

5 years agoAnchor with a space so we don't mangle the middle of flags
Matthew Newton [Thu, 22 Oct 2020 09:07:58 +0000 (10:07 +0100)] 
Anchor with a space so we don't mangle the middle of flags

Fixes #3693

5 years agorlm_python3: Strip out -frecord-gcc-switches #3693 (#3699)
Jorge Pereira [Wed, 21 Oct 2020 23:53:02 +0000 (20:53 -0300)] 
rlm_python3: Strip out -frecord-gcc-switches #3693 (#3699)

We decide if enable that yes or no.

5 years agowe don't use this nonsense, or libtool garbage any more
Alan T. DeKok [Fri, 16 Oct 2020 13:15:21 +0000 (09:15 -0400)] 
we don't use this nonsense, or libtool garbage any more

5 years agoDHCP: Dedicated rlm_sql instance to support option lookup
Terry Burton [Sun, 11 Oct 2020 03:47:02 +0000 (04:47 +0100)] 
DHCP: Dedicated rlm_sql instance to support option lookup

New dhcp_sql instance of rlm_sql for use with DHCP:

  - Separate queries.conf and schema.sql, etc. for DHCP vs RADIUS.
  - Group lookup is disabled by default and there are no check queries provided
    to reduce query load for typical use cases.
  - No accounting-related configuration items and queries.

The schema provides dhcpreply, dhcpgroupreply and dhcpgroup (née "usergroup")
tables as per corresponding RADIUS authorize schema, except:

  - Rename column Username -> Identifier since the lookup key varies based on
    "contexts". There will typically be multiple option merges from different
    context to set network-specific options, device-specific options, classes,
    etc.
    - Set Identifier for lookup using the DHCP-SQL-Option-Identifier internal
      attribute (which gets escaped into SQL-User-Name, as usual).
  - Add a Context column ("network", "subnet", "group", "class-abc", etc.) to
    support lookups using the same tables but with the options data partitioned
    between contexts.
    - Set current Context using the DHCP-SQL-Option-Context internal attribute.
      This is not SQL escaped, however it is not set from tainted data.

Example policy for performing SQL options lookup from SQL provided in
policy.d/dhcp.

5 years agoCorrect test unlang
Nick Porter [Mon, 5 Oct 2020 13:24:25 +0000 (14:24 +0100)] 
Correct test unlang

5 years agoAdd test for prepend operator
Nick Porter [Mon, 5 Oct 2020 13:01:46 +0000 (14:01 +0100)] 
Add test for prepend operator

5 years agoCorrect sequence of operators in token.c
Nick Porter [Thu, 1 Oct 2020 11:31:44 +0000 (12:31 +0100)] 
Correct sequence of operators in token.c

5 years agoAdd prepend handling for whole list copying
Nick Porter [Fri, 25 Sep 2020 13:47:19 +0000 (14:47 +0100)] 
Add prepend handling for whole list copying

Allows for
    update {
        &reply: ^= &request
    }
which would insert all entry from request at the beginning of reply

5 years agoAdd an operator parameter to fr_pair_list_move
Nick Porter [Fri, 25 Sep 2020 13:45:19 +0000 (14:45 +0100)] 
Add an operator parameter to fr_pair_list_move

If the passed in operator is T_OP_PREPEND then any added attributes are
prepended to the "to" list rather than appended.

Existing calls to fr_pair_list_move are updated to call with T_OP_ADD to
preserve existing behaviour.

5 years agoUse fr_pair_prepend in map_to_request
Nick Porter [Fri, 25 Sep 2020 10:48:29 +0000 (11:48 +0100)] 
Use fr_pair_prepend in map_to_request

5 years agoAdd fr_pair_prepend to prepend a list onto another
Nick Porter [Fri, 25 Sep 2020 10:45:42 +0000 (11:45 +0100)] 
Add fr_pair_prepend to prepend a list onto another

5 years agoAllow parsing of prepend operator ^= in config and correct comment
Nick Porter [Fri, 25 Sep 2020 10:44:19 +0000 (11:44 +0100)] 
Allow parsing of prepend operator ^= in config and correct comment

5 years agoAdd "prepend" functionality to radius_pairmove
Nick Porter [Thu, 24 Sep 2020 16:40:12 +0000 (17:40 +0100)] 
Add "prepend" functionality to radius_pairmove

radis_pairmove is used by rlm_files for adding attributes to the reply
list.  This allows for syntax such as:

<match key>
<attribute> ^= <value>

which will insert <attribute> = <value> at the top of the reply list.

Intended for DHCP use where, for example, the sequence that search
domains are returned is significant.

5 years agoAdd prepend operator ^=
Nick Porter [Thu, 24 Sep 2020 16:34:13 +0000 (17:34 +0100)] 
Add prepend operator ^=

To be used in attribute assignement to get the new attribute prepended
to the list.

Beneficial in DHCP where the order of multiple instances of an attribute
is significant.

5 years agoDHCP: Batch ADSL Forum vendor-specific options so they are encoded together
Terry Burton [Wed, 14 Oct 2020 01:17:51 +0000 (02:17 +0100)] 
DHCP: Batch ADSL Forum vendor-specific options so they are encoded together

5 years agoaccount for the option header, too
Alan T. DeKok [Tue, 13 Oct 2020 23:40:15 +0000 (19:40 -0400)] 
account for the option header, too

5 years agoAdd test for substring request longer than input
Nick Porter [Mon, 12 Oct 2020 13:42:02 +0000 (14:42 +0100)] 
Add test for substring request longer than input

5 years agoTests for substring xlat
Nick Porter [Wed, 7 Oct 2020 11:33:58 +0000 (12:33 +0100)] 
Tests for substring xlat

5 years agoAdd a "substring" xlat function
Nick Porter [Wed, 7 Oct 2020 10:19:57 +0000 (11:19 +0100)] 
Add a "substring" xlat function

Return a substring of the string representation of a string or attribute
using the syntax:
"%{substring:<string:attribute> <start> <len>}"

Negative `start` or `len` values count from the end of the string

5 years agos/DHCP-Network-IP-Address/DHCP-Network-Subnet/g
Terry Burton [Thu, 8 Oct 2020 12:03:37 +0000 (12:03 +0000)] 
s/DHCP-Network-IP-Address/DHCP-Network-Subnet/g

5 years agoDHCP: Lookup device's group memberships before network/pool lookup
Terry Burton [Wed, 7 Oct 2020 22:14:04 +0000 (23:14 +0100)] 
DHCP: Lookup device's group memberships before network/pool lookup

This allows group membership to be used to guard access to the pool,
akin to "allow members of" in other DHCP servers.

5 years agoDHCP: Add DHCP-Group-Name to request list rather than control
Terry Burton [Wed, 7 Oct 2020 22:11:43 +0000 (23:11 +0100)] 
DHCP: Add DHCP-Group-Name to request list rather than control

This means that it is available in as a membership guard for the pools
defined using rlm_files.

5 years agoDHCP: Clarify comments to ensure that the dhcp_subnet policy is enabled
Terry Burton [Tue, 6 Oct 2020 23:19:18 +0000 (00:19 +0100)] 
DHCP: Clarify comments to ensure that the dhcp_subnet policy is enabled

5 years agoDHCP: Refer to the the term "multinet", equivalent to a "shared-network"
Terry Burton [Wed, 30 Sep 2020 14:56:32 +0000 (15:56 +0100)] 
DHCP: Refer to the the term "multinet", equivalent to a "shared-network"

This seems to be used most frequently in the context of Microsoft DHCP.

5 years agoDHCP: Reference to DOCSIS cable modems as a scenario for using subnet override
Terry Burton [Wed, 30 Sep 2020 12:42:17 +0000 (13:42 +0100)] 
DHCP: Reference to DOCSIS cable modems as a scenario for using subnet override

5 years agoDHCP: Policy support for shared-network: Layer 2 with multiple subnets
Terry Burton [Fri, 25 Sep 2020 12:55:09 +0000 (13:55 +0100)] 
DHCP: Policy support for shared-network: Layer 2 with multiple subnets

Many networks support multiple co-existing subnets without VLAN separation,
i.e. we have one pool containing equally valid IP addresses from each subnet.

To support this configuration we differentiate selecting a pool based on the
default or overriden DHCP-Network-IP-Address (indicating the Layer 2 network
originating the request) versus setting the reply options for the subnet to
which the allocated IP address belongs, in particular DHCP-Subnet-Mask,
DHCP-Router-Address and DHCP-Broadcast-Address.

5 years agoDHCP: Add dhcp_override_network to DECLINE and RELEASE processing
Terry Burton [Fri, 25 Sep 2020 12:54:44 +0000 (13:54 +0100)] 
DHCP: Add dhcp_override_network to DECLINE and RELEASE processing

5 years agoDHCP: Fix non-existent DHCP option
Terry Burton [Thu, 24 Sep 2020 23:25:47 +0000 (00:25 +0100)] 
DHCP: Fix non-existent DHCP option

5 years agohelps to add this
Alan T. DeKok [Wed, 7 Oct 2020 17:00:10 +0000 (13:00 -0400)] 
helps to add this

5 years agocheck "version" for the Antora pages, too
Alan T. DeKok [Mon, 28 Sep 2020 20:04:17 +0000 (16:04 -0400)] 
check "version" for the Antora pages, too

5 years agov3: Remove requirement for Perl Template::Toolkit (#3668)
Nick Porter [Mon, 28 Sep 2020 16:41:08 +0000 (17:41 +0100)] 
v3: Remove requirement for Perl Template::Toolkit (#3668)

* Remove requirement for Perl Template::Toolkit

Template Toolkit is only needed if the perl IP pool tools are to produce
SQL output rather than directly operate on the database - so it is not a
hard requirement.

* Split perl utils into new package for .deb

Remove Perl dependencies from freeradius-utils and create a new
freeradius-perl-util for helper Perl scripts

* Split perl utils into new package for .rpm

Remove Perl dependencies from freeradius-utils and create a new
freeradius-perl-util for helper Perl scripts

5 years agolistener may be NULL when originating CoA packets
Alan T. DeKok [Sun, 27 Sep 2020 13:34:04 +0000 (09:34 -0400)] 
listener may be NULL when originating CoA packets

5 years agouse the correct version
Alan T. DeKok [Thu, 24 Sep 2020 18:29:11 +0000 (14:29 -0400)] 
use the correct version

5 years agoadd base antora site
Alan T. DeKok [Thu, 24 Sep 2020 15:17:03 +0000 (11:17 -0400)] 
add base antora site

taken from v4 with some edits.  We need to go through all of the
v4 pages, and back-port them one by one to v3

5 years agoport antora, etc. checks from master
Alan T. DeKok [Thu, 24 Sep 2020 15:07:28 +0000 (11:07 -0400)] 
port antora, etc. checks from master

5 years agoTLS 1.3: send 0x00 only when there's no application data
Alan T. DeKok [Wed, 23 Sep 2020 20:03:14 +0000 (16:03 -0400)] 
TLS 1.3: send 0x00 only when there's no application data

5 years agoeap-tls: fix Session Id for non-TLSv1.3 introduced by e8b4d28e140cd354ec3f72619bb4dd9...
Alexander Clouter [Wed, 16 Sep 2020 19:10:06 +0000 (20:10 +0100)] 
eap-tls: fix Session Id for non-TLSv1.3 introduced by e8b4d28e140cd354ec3f72619bb4dd9ed4f261cc

5 years agoRevert "add configuration flag for EAP-TLS 1.3"
Alan T. DeKok [Wed, 23 Sep 2020 12:47:12 +0000 (08:47 -0400)] 
Revert "add configuration flag for EAP-TLS 1.3"

This reverts commit 00fa072c05eecd41e5f4b6f61a46c28a35644975.

After discussion in the IETF, 0x00 is much preferred to close_notify

5 years agoUpdate Mikrotik dictionary
Jorge Pereira [Fri, 7 Aug 2020 01:13:26 +0000 (22:13 -0300)] 
Update Mikrotik dictionary

Based on https://wiki.mikrotik.com/wiki/Manual:RADIUS_Client/reference_dictionary

5 years agoImprove comments
Nick Porter [Tue, 22 Sep 2020 13:37:51 +0000 (14:37 +0100)] 
Improve comments

Better explanation of overriding DHCP-Network-IP-Address

5 years agoTidy up and improve comments
Nick Porter [Tue, 22 Sep 2020 11:33:51 +0000 (12:33 +0100)] 
Tidy up and improve comments

Explain how DHCP-Network-IP-Address is derrived and give an example of
how to override it for shared network setups.

Simplify the group options policy / files module

Correct name of dhcp_network policy

5 years agoSample config to allow for DHCP group options
Nick Porter [Tue, 22 Sep 2020 09:51:18 +0000 (10:51 +0100)] 
Sample config to allow for DHCP group options

Defines an internal attribute of DHCP-Group-Name.  Clients are then
looked up in a "passwd" style file to determine group membership,
followed by a lookup into a "files" instance to add appropriate options.

5 years agoTidy DHCP site config from previous merge error
Nick Porter [Mon, 21 Sep 2020 15:13:12 +0000 (16:13 +0100)] 
Tidy DHCP site config from previous merge error

5 years agoAdd files module instance to lookup host specific options
Nick Porter [Mon, 21 Sep 2020 15:07:58 +0000 (16:07 +0100)] 
Add files module instance to lookup host specific options

5 years agoRemove remaining calls to dhcp_determine_subnet
Nick Porter [Mon, 21 Sep 2020 15:05:58 +0000 (16:05 +0100)] 
Remove remaining calls to dhcp_determine_subnet

5 years agoMove subnet test to instance of rlm_files
Nick Porter [Mon, 21 Sep 2020 15:00:00 +0000 (16:00 +0100)] 
Move subnet test to instance of rlm_files

To keep config in config files as much as possible, replace
determine_subnet with an instance of the rlm_files module.  This
instance can set global DHCP options along with subnet specific options
and the Pool-Name for SQL ippool lookups.

5 years agoMake DHCP-Network-IP-Address an IPv4 prefix
Nick Porter [Fri, 18 Sep 2020 15:14:48 +0000 (16:14 +0100)] 
Make DHCP-Network-IP-Address an IPv4 prefix

Allows "closest containing subnet" matching in rlm_files

5 years agoAdd tests for PBKDF2 passwords. ref #2649
Jorge Pereira [Tue, 22 Sep 2020 23:48:56 +0000 (20:48 -0300)] 
Add tests for PBKDF2 passwords. ref #2649

5 years agoAdd support for PBKDF2 passwords. ref #2649
Jorge Pereira [Tue, 22 Sep 2020 23:48:42 +0000 (20:48 -0300)] 
Add support for PBKDF2 passwords. ref #2649

5 years agoAdd attributes for PBKFD2/SSHA3 passwords. ref #2649
Jorge Pereira [Tue, 22 Sep 2020 23:47:54 +0000 (20:47 -0300)] 
Add attributes for PBKFD2/SSHA3 passwords. ref #2649

5 years agoUpdate fr_base64_decode() to process 24bits
Jorge Pereira [Wed, 23 Sep 2020 00:50:52 +0000 (21:50 -0300)] 
Update fr_base64_decode() to process 24bits

5 years agoFix DIAG_{ON,OFF} for external includes
Jorge Pereira [Tue, 22 Sep 2020 23:28:09 +0000 (20:28 -0300)] 
Fix DIAG_{ON,OFF} for external includes

Just to mute warnings with external headers.

5 years agoCorrect behaviour of allow_muliple_keys in rlm_passwd
Nick Porter [Mon, 21 Sep 2020 18:12:55 +0000 (19:12 +0100)] 
Correct behaviour of allow_muliple_keys in rlm_passwd

Amend rlm_passwd so the allow_mulitple_keys behaviour matches
documentation - only using the first matching record in the data file.

5 years agodon't use for (init ... next_by_num)
Alan T. DeKok [Tue, 22 Sep 2020 12:59:06 +0000 (08:59 -0400)] 
don't use for (init ... next_by_num)

fr_cursor_next_by_* functions start at the current cursor position
unless they have been previously called.  This resulted in the first key
attribute value being looked up twice - once as a result of
fr_cursor_init and once after the first call to fr_cursor_next_by_num

5 years agoallow "-", as with "-eap", in the "authenticate" section
Alan T. DeKok [Sun, 20 Sep 2020 13:43:50 +0000 (09:43 -0400)] 
allow "-", as with "-eap", in the "authenticate" section

5 years agoSupport in-network tests for ipv{4,6}prefix types when comparing lists
Terry Burton [Thu, 17 Sep 2020 23:30:43 +0000 (00:30 +0100)] 
Support in-network tests for ipv{4,6}prefix types when comparing lists

5 years agoadd missing brace
Alan T. DeKok [Wed, 16 Sep 2020 19:56:19 +0000 (15:56 -0400)] 
add missing brace

5 years agoCalculate DHCP-Network-IP-Address as the basis of identifying a client's subnet ...
Nick Porter [Wed, 16 Sep 2020 13:08:54 +0000 (14:08 +0100)] 
Calculate DHCP-Network-IP-Address as the basis of identifying a client's subnet (#3650)

* Add new internal attributes to DHCP dictionary

DHCP-Network-IP-Address - used to store the address to be used in
determining the subnet a client belongs to
DHCP-Subnet-Name - an internal name for the selected subnet.

Also, correct the type for option 118.

* Determine the address to be used to identify client subnet

After parsing the DHCP packet, check Relay-Link-Selection option,
Subnet-Selection-Option option then giaddr and finally ciaddr to
determine address to lookup client's subnet.

* Add sample config for looking up DHCP subnet name

Create a policy that maps DHCP-Network-IP-Address to DHCP-Subnet-Name
and then call that from each processing section.

5 years agoExtend comment regarding alive_update query
Nick Porter [Mon, 14 Sep 2020 08:23:46 +0000 (09:23 +0100)] 
Extend comment regarding alive_update query

5 years agoAdd explanitory comment for alive_update query
Nick Porter [Mon, 14 Sep 2020 08:00:37 +0000 (09:00 +0100)] 
Add explanitory comment for alive_update query

5 years agoAdd counter to DHCP ippool schema
Nick Porter [Fri, 11 Sep 2020 12:36:10 +0000 (13:36 +0100)] 
Add counter to DHCP ippool schema

By updating a counter every time a REQUEST is responded to sucessfully
we ensure that records are changed, thus all database engines return an
affected row count of 1 for successful matches.  This safeguards the new
DHCP site config which uses the affected row count to determine between
ACK and NAK responses.

5 years agoRemove allocate_clear queries
Nick Porter [Wed, 16 Sep 2020 10:14:57 +0000 (11:14 +0100)] 
Remove allocate_clear queries

5 years agoSQLite ippool schema / query tidy up
Nick Porter [Wed, 16 Sep 2020 10:09:12 +0000 (11:09 +0100)] 
SQLite ippool schema / query tidy up

5 years agoPostgreSQL ippool schema / query tidy up
Nick Porter [Wed, 16 Sep 2020 10:05:45 +0000 (11:05 +0100)] 
PostgreSQL ippool schema / query tidy up

5 years agoOracle ippool schema / query tidy up
Nick Porter [Wed, 16 Sep 2020 10:00:29 +0000 (11:00 +0100)] 
Oracle ippool schema / query tidy up

5 years agoMySQL ippool schema / query tidy up
Nick Porter [Wed, 16 Sep 2020 09:54:11 +0000 (10:54 +0100)] 
MySQL ippool schema / query tidy up

5 years agoMS SQL ippool schema / query tidying
Nick Porter [Wed, 16 Sep 2020 09:51:32 +0000 (10:51 +0100)] 
MS SQL ippool schema / query tidying

5 years agoMove common DHCP reply attributes to a single policy
Nick Porter [Fri, 11 Sep 2020 08:35:34 +0000 (09:35 +0100)] 
Move common DHCP reply attributes to a single policy

DISCOVER, REQUEST and INFORM all have a common set of reply attributes.
Rather than explicity set them in each section, call a common policy to
set them in one place.

Also, move the commented out setting of reply packet type for DISCOVER
so it reads more clearly.

5 years agomod_perl: Print out the version
Jorge Pereira [Thu, 3 Sep 2020 17:43:41 +0000 (14:43 -0300)] 
mod_perl: Print out the version

5 years agonote recent changes
Alan T. DeKok [Thu, 10 Sep 2020 13:08:03 +0000 (09:08 -0400)] 
note recent changes

5 years agoMinor fixes following detailed testing
Nick Porter [Wed, 9 Sep 2020 18:23:07 +0000 (19:23 +0100)] 
Minor fixes following detailed testing

5 years agoDefault _begin and _commit queries to blank
Nick Porter [Wed, 9 Sep 2020 14:19:40 +0000 (15:19 +0100)] 
Default _begin and _commit queries to blank

Most databases are autocommit, so where a method only calls a single
update there is no need to wrap in "START TRANSACTION" and "COMMIT".
Also different databases have different syntax for this.  Safer to have
blank and only explicitly add transaction commands where needed (Oracle)

5 years agosqlippools: allocate_requested queries for SQLite
Terry Burton [Tue, 8 Sep 2020 18:08:37 +0000 (19:08 +0100)] 
sqlippools: allocate_requested queries for SQLite

5 years agosqlippools: allocate_requested queries for Oracle
Terry Burton [Tue, 8 Sep 2020 18:08:10 +0000 (19:08 +0100)] 
sqlippools: allocate_requested queries for Oracle

5 years agosqlippools: allocate_requested queries for MySQL
Terry Burton [Tue, 8 Sep 2020 18:06:30 +0000 (19:06 +0100)] 
sqlippools: allocate_requested queries for MySQL