summaryrefslogtreecommitdiffstats
path: root/database/sqlite/administration/lastlog.c
Commit message (Collapse)AuthorAgeFilesLines
* Update eurephiadm to extract VPN MAC and IP address info from the new placesDavid Sommerseth2012-12-261-6/+8
| | | | | | | As the lastlog table doesn't contain MAC or IP addresses of the VPN client any more, make the lastlog extraction gather the data from the vpnaddr_history table instead. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Updated copyright datesDavid Sommerseth2012-10-081-1/+1
| | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* sqlite/admin: Report all timestamp fields with localtime instead of UTC/GMTDavid Sommerseth2012-10-081-1/+2
| | | | | | | | Made all SELECT queries which is used for reports to use the new 'locdt' SQL function on timestamp fields. This converts the UTC/GMT timestamps stored in the database to the correct timezone of the running admin client. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Modified the whole edb-sqlite driver to use a better error handlingDavid Sommerseth2011-12-191-1/+3
| | | | | | | | | | | This will change the driver to use the new error routines made available in the SQLite3 framework. Some of the code is also restructured a little bit to simplify the code with these changes. The functionality should be the same as for, but better error messages are now sent back to the caller on the functions supporting XML. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Quick fix for typo 'Quering'Dario Minnucci2010-12-011-1/+1
| | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* SQLite3 eurephiadm fix: sorting lastlog based on session status didn't workDavid Sommerseth2010-11-121-1/+1
| | | | | | | | | The eDBadminGetLastlog(...) function didn't parse the sortkeys string to match the database layout. In addition the field mapping for the openvpn_lastlog.sessionstatus field was wrong. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Updated Copyright dates to include 2010David Sommerseth2010-07-301-1/+1
|
* Certificate digests are always lower case.David Sommerseth2009-11-121-1/+1
| | | | | This makes sure that all interactions with the database will convert the digest strings to lower case.
* Code clean up. Moved xmlReplaceChars() to eurephia_xml.cDavid Sommerseth2009-09-271-2/+0
|
* Moved eDBGetLastlog() function into sqlite/administration/lastlog.cDavid Sommerseth2009-09-131-0/+164