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/certificates.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/certificates.c')
-rw-r--r-- | database/sqlite/administration/certificates.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/database/sqlite/administration/certificates.c b/database/sqlite/administration/certificates.c index b64aa07..d8b7a23 100644 --- a/database/sqlite/administration/certificates.c +++ b/database/sqlite/administration/certificates.c @@ -86,7 +86,8 @@ static xmlDoc *certificate_list(eurephiaCTX *ctx, eDBfieldMap *srch_map, const c } res = sqlite_query_mapped(ctx, SQL_SELECT, - "SELECT depth, digest, common_name, organisation, email, registered, certid" + "SELECT depth, lower(digest), common_name, organisation, email, " + " registered, certid" " FROM openvpn_certificates", NULL, srch_map, sortkeys); if( res == NULL ) { eurephia_log(ctx, LOG_ERROR, 0, "Could not query the certificate table"); |