diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2009-11-12 18:27:11 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2009-11-12 18:27:11 +0100 |
| commit | de7a3d88c78cdf400fcee78f71946da8b12ec74f (patch) | |
| tree | 5cbf8c6a48f4cc94f9af9fa7f564142dddd86bed /database/sqlite/administration/firewalladmin.c | |
| parent | 2a9cbc68a598a2e6fe5c4344509d9f09459b244c (diff) | |
| download | eurephia-de7a3d88c78cdf400fcee78f71946da8b12ec74f.tar.gz eurephia-de7a3d88c78cdf400fcee78f71946da8b12ec74f.tar.xz eurephia-de7a3d88c78cdf400fcee78f71946da8b12ec74f.zip | |
Certificate digests are always lower case.
This makes sure that all interactions with the database will convert
the digest strings to lower case.
Diffstat (limited to 'database/sqlite/administration/firewalladmin.c')
| -rw-r--r-- | database/sqlite/administration/firewalladmin.c | 2 |
1 files changed, 1 insertions, 1 deletions
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)" |