diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2012-12-25 22:08:53 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2012-12-26 01:32:20 +0100 |
| commit | 40e66aed101e5a448fe012f24abe33d15a68cee9 (patch) | |
| tree | 0ba4005d5d55740015c079e03d03fd033708d7e2 /database/sqlite/sql-schema.sql | |
| parent | 242ba8893bef1fe05d71959afc5273af021b8537 (diff) | |
| download | eurephia-40e66aed101e5a448fe012f24abe33d15a68cee9.tar.gz eurephia-40e66aed101e5a448fe012f24abe33d15a68cee9.tar.xz eurephia-40e66aed101e5a448fe012f24abe33d15a68cee9.zip | |
Added a new eDBregister_login2() to replace eDBregister_login() database function
This will save the access profile in the lastlog table. However, it will not save
the VPN IP address and netmask any more. This should be saved in the vpnaddr_history
table, using the eDBregister_vpnclientaddr() function.
eDBregister_login() is now just a wrapper around the eDBregister_login2(), ignoring
the access profile id and VPN addresses. This exists purely as a compatibility layer
if the updated driver is used against an older eurephia-auth.so plug-in.
Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
Diffstat (limited to 'database/sqlite/sql-schema.sql')
| -rw-r--r-- | database/sqlite/sql-schema.sql | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql index 6d2befb..4d05222 100644 --- a/database/sqlite/sql-schema.sql +++ b/database/sqlite/sql-schema.sql @@ -66,13 +66,10 @@ CREATE TABLE openvpn_accesses ( CREATE TABLE openvpn_lastlog ( uid integer , certid integer , + accessprofile integer , protocol varchar(4) NOT NULL, remotehost varchar(128) NOT NULL, remoteport integer NOT NULL, - macaddr varchar(20) , - vpnipaddr varchar(32) NOT NULL, - vpnipmask varchar(32) NOT NULL, - vpnipv6addr varchar(48) , sessionstatus integer NOT NULL DEFAULT 0, sessionkey varchar(128) , login timestamp , |