aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMartin Willi <martin@strongswan.org>2008-05-13 07:39:24 +0000
committerMartin Willi <martin@strongswan.org>2008-05-13 07:39:24 +0000
commit4d4fc2eaa18f2c643d95684022e424bd7441eef3 (patch)
treea9dba143618eaeb5397dabbbd4af4d0437de71f4
parent808ca43f927dfd2d89b55eb5bf84db6839d1ac14 (diff)
downloadstrongswan-4d4fc2eaa18f2c643d95684022e424bd7441eef3.tar.bz2
strongswan-4d4fc2eaa18f2c643d95684022e424bd7441eef3.tar.xz
fixed "pool --purge" on mysql
-rw-r--r--src/charon/plugins/sql/pool.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/charon/plugins/sql/pool.c b/src/charon/plugins/sql/pool.c
index 136c7e16f..709c18c12 100644
--- a/src/charon/plugins/sql/pool.c
+++ b/src/charon/plugins/sql/pool.c
@@ -308,7 +308,7 @@ static void purge(char *name)
{
purged = db->execute(db, NULL,
"DELETE FROM leases WHERE pool = ? "
- "AND released NOTNULL AND released < ?",
+ "AND released IS NOT NULL AND released < ?",
DB_UINT, id, DB_UINT, time(NULL) - timeout);
}
query->destroy(query);