summaryrefslogtreecommitdiffstats
path: root/database/sqlite/administration/attempts.c
diff options
context:
space:
mode:
authorDavid Sommerseth <dazo@users.sourceforge.net>2009-11-12 18:27:11 +0100
committerDavid Sommerseth <dazo@users.sourceforge.net>2009-11-12 18:27:11 +0100
commitde7a3d88c78cdf400fcee78f71946da8b12ec74f (patch)
tree5cbf8c6a48f4cc94f9af9fa7f564142dddd86bed /database/sqlite/administration/attempts.c
parent2a9cbc68a598a2e6fe5c4344509d9f09459b244c (diff)
downloadeurephia-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/attempts.c')
-rw-r--r--database/sqlite/administration/attempts.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration/attempts.c b/database/sqlite/administration/attempts.c
index e94878a..b35b386 100644
--- a/database/sqlite/administration/attempts.c
+++ b/database/sqlite/administration/attempts.c
@@ -74,7 +74,7 @@ xmlDoc *attempts_list(eurephiaCTX *ctx, eDBfieldMap *fmap) {
// Query the database for registered attempts
res = sqlite_query_mapped(ctx, SQL_SELECT,
- "SELECT username, digest, remoteip, attempts,"
+ "SELECT username, lower(digest), remoteip, attempts,"
" registered, last_attempt, atpid"
" FROM openvpn_attempts",
NULL, fmap, "atpid");