summaryrefslogtreecommitdiffstats
path: root/database/sqlite/administration
Commit message (Collapse)AuthorAgeFilesLines
* eurephiadm/usercerts: Add support for setting up auth-pluginsDavid Sommerseth2013-05-291-2/+12
| | | | | | | This enables setting authentication plug-in and the alternative authentication username for user-certificate links. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Merge auth-plugin workDavid Sommerseth2013-05-281-0/+344
|\ | | | | | | | | | | | | | | | | | | | | This implements a authentication plug-in framework which can be used to do username/password authentication against another backend per user/certificate. Conflicts: database/eurephiadb.c Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
| * sqlite3: Enable support for managing plug-in modulesDavid Sommerseth2013-05-281-0/+344
| | | | | | | | | | | | | | This enables plug-in support management via the eDBadminPlugins() function, used by eurephiadm. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* | Update eurephiadm to extract VPN MAC and IP address info from the new placesDavid Sommerseth2012-12-262-12/+15
|/ | | | | | | 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-089-9/+9
| | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* sqlite/admin: Report all timestamp fields with localtime instead of UTC/GMTDavid Sommerseth2012-10-087-12/+15
| | | | | | | | 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-199-106/+257
| | | | | | | | | | | 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>
* Fixed several memleaks in the eurephiadm related code pathsDavid Sommerseth2011-01-101-0/+1
| | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* eurephiadm users: Revoke all admin access privileges when deleting a user ↵David Sommerseth2010-12-141-6/+14
| | | | | | | | | | account Matthew Gyurgyik noticed that when deleting a user account, the users granted access levels was still present. This resulted in a rather odd looking list when showing granted access levels. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Quick fix for typo 'Unkown'Dario Minnucci2010-12-011-1/+1
| | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Quick fix for typo 'Quering'Dario Minnucci2010-12-012-4/+4
| | | | 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>
* Fixed Doxygen complaintsDavid Sommerseth2010-08-264-32/+0
| | | | | | Removed some #defines which was not needed and added missing comments. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Updated Copyright dates to include 2010David Sommerseth2010-07-309-9/+9
|
* Certificate digests are always lower case.David Sommerseth2009-11-127-8/+9
| | | | | This makes sure that all interactions with the database will convert the digest strings to lower case.
* sqlite: Did not retrieve all certificate information correctlyDavid Sommerseth2009-11-031-10/+10
| | | | | On user accounts with several certificates associated, it did only list up one certificate several times.
* Corrected some new Doxygen issuesDavid Sommerseth2009-09-281-1/+2
|
* Reworked and unified admin authentication and registration functions to ↵David Sommerseth2009-09-281-60/+194
| | | | | | | | eDBadminAuthenticate() eDBadminAuth(), eDBadminValidateSession(), eDBadminRegisterLogin() and eDBadminLogout() are now unfied into one admin function, eDBadminAuthenticate(). This function receives all input as eurephia XML documents.
* Moved the remainings of administration.c into administration/authentication.cDavid Sommerseth2009-09-271-0/+364
|
* Code clean up. Moved xmlReplaceChars() to eurephia_xml.cDavid Sommerseth2009-09-275-10/+0
|
* Moved user creation info from log level 0 to log level 1David Sommerseth2009-09-271-1/+1
| | | | | This is to avoid the console programs to report to stderr if log file is not setup. Console applications use stderr in these situations.
* Fixed a memory leak when updating user accounts in eDBadminUserAccount()David Sommerseth2009-09-271-0/+1
|
* Removed a memory leakDavid Sommerseth2009-09-261-0/+1
|
* Renamed some variables to have a more meaningful nameDavid Sommerseth2009-09-251-5/+7
|
* Added better error handling in eDBadminUserAccount() view mode (useracc_list())David Sommerseth2009-09-251-4/+7
|
* Made the sortkeys work in eDBadminUserAccount() view modeDavid Sommerseth2009-09-251-7/+8
|
* Rewrote the eDBmkSortKeys() function to use the eDBfieldMap returned from ↵David Sommerseth2009-09-252-4/+4
| | | | eDBxmlMapping()
* dded support for <sortkeys> tag in eDBadminUserAccount()David Sommerseth2009-09-251-3/+6
|
* Fixed some issues with the useracc_list() functionDavid Sommerseth2009-09-251-32/+28
|
* Unified eDBadminUser*() functions into one eDBadminUserAccount() functionDavid Sommerseth2009-09-241-185/+200
| | | | | | Rewritten the database API and the SQLite3 database driver. This code has yet not been tested.
* Unified eDBadminGetCertificateInfo(), eDBadminAddCertificate() and ↵David Sommerseth2009-09-221-93/+119
| | | | | | eDBadminDeleteCertificate() into eDBadminCertificate() Updated eurephiadm utility to make use of this new unified API
* Rewrote eurephiaXML_ResultMsg() to also support adding an xmlNode* with more ↵David Sommerseth2009-09-216-48/+52
| | | | | | | | info The eurephia result XML document is also changed, and all parsing of the result must be rewritten. To simplify this parsing, a new function is introduced, eurephiaXML_ParseResultMsg().
* Unified eDBadminGetAdminAccess() and eDBadminEditAdminAccess() into ↵David Sommerseth2009-09-211-13/+88
| | | | eDBadminAccessLevel()
* Unified database driver functions eDBadminConfigSet() and ↵David Sommerseth2009-09-141-6/+133
| | | | eDBadminConfigDelete() into eDBadminConfiguration()
* Moved eDBGetLastlog() function into sqlite/administration/lastlog.cDavid Sommerseth2009-09-131-0/+164
|
* Moved eDBadminGetAdminAccess() into sqlite/administration/useraccount.cDavid Sommerseth2009-09-131-0/+60
|
* Moved certificate functions into sqlite/administration/certificates.cDavid Sommerseth2009-09-131-0/+256
|
* Moved user account functions into administration/useraccount.cDavid Sommerseth2009-09-131-0/+554
|
* Moved eDBadminBlacklist() function into administration/blacklist.cDavid Sommerseth2009-09-131-0/+54
|
* Moved eDBadminAttemptsLog() function into administration/attempts.cDavid Sommerseth2009-09-131-0/+52
|
* Moved eDBadminConfigSet() and eDBadminConfigDelete() into its own fileDavid Sommerseth2009-09-131-0/+110
|
* Added doxygen comments on the last missing filesDavid Sommerseth2009-09-114-33/+153
|
* Removed header file which is no longer neededDavid Sommerseth2009-09-054-4/+0
|
* Rearranged some files in the sqlite3 driverDavid Sommerseth2009-09-024-0/+871