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/usercerts.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/usercerts.c')
| -rw-r--r-- | database/sqlite/administration/usercerts.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration/usercerts.c b/database/sqlite/administration/usercerts.c index 8e235c5..abc0b40 100644 --- a/database/sqlite/administration/usercerts.c +++ b/database/sqlite/administration/usercerts.c @@ -92,7 +92,7 @@ xmlDoc *usercerts_search(eurephiaCTX *ctx, eDBfieldMap *where_m, const char *sor "SELECT uicid, ucs.uid AS uid, certid, ucs.registered AS registered," " ucs.accessprofile AS accessprofile, access_descr," " username, " - " common_name, organisation, email, digest, depth " + " common_name, organisation, email, lower(digest), depth " " FROM openvpn_usercerts ucs" " LEFT JOIN openvpn_certificates USING(certid)" " LEFT JOIN openvpn_accesses acc ON(ucs.accessprofile = acc.accessprofile)" |