From de7a3d88c78cdf400fcee78f71946da8b12ec74f Mon Sep 17 00:00:00 2001 From: David Sommerseth Date: Thu, 12 Nov 2009 18:27:11 +0100 Subject: Certificate digests are always lower case. This makes sure that all interactions with the database will convert the digest strings to lower case. --- database/sqlite/administration/firewalladmin.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'database/sqlite/administration/firewalladmin.c') diff --git a/database/sqlite/administration/firewalladmin.c b/database/sqlite/administration/firewalladmin.c index fdebccb..3ea2f28 100644 --- a/database/sqlite/administration/firewalladmin.c +++ b/database/sqlite/administration/firewalladmin.c @@ -89,7 +89,7 @@ xmlDoc *fwadmin_search(eurephiaCTX *ctx, eDBfieldMap *fmap) { "SELECT access_descr, fw_profile, accessprofile, " " uid, username, " " uac.certid, common_name, organisation, " - " email, digest, c.registered, uicid " + " email, lower(digest), c.registered, uicid " " FROM openvpn_accesses" " LEFT JOIN openvpn_usercerts uac USING (accessprofile)" " LEFT JOIN openvpn_users USING (uid)" -- cgit