summaryrefslogtreecommitdiffstats
path: root/database
Commit message (Collapse)AuthorAgeFilesLines
* edb-sqlite: Fixed a typos and copyright noticesrelease/1.0David Sommerseth2011-07-251-3/+4
| | | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net> (cherry picked from commit 331d3ff806f4d1b146d8599b1e226e7962f7d7b2)
* Fixed several memleaks in the eurephiadm related code pathsDavid Sommerseth2011-01-101-0/+1
| | | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net> (cherry picked from commit 44bcb3e74a85b4a53a0dc626db13c3d03d925538)
* Add paths and libaries for SQLite3 which pkg-config returnsDavid Sommerseth2010-12-311-1/+3
| | | | | | | | | If SQLite3 was not installed in system paths, it would not be possible to compile the edb-sqlite driver due to include and library paths not being set. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net> (cherry picked from commit 0c85e6f1f43d2b432a024d7da88ddfc429f0bba1)
* eurephiadm users: Revoke all admin access privileges when deleting a user ↵David Sommerseth2010-12-311-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> (cherry picked from commit e4ea19989e97fbecd1b22997cadb8fc5f54ade4a)
* Quick fix for typo 'Unkown'Dario Minnucci2010-12-011-1/+1
| | | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net> (cherry picked from commit b23272cf33ac858384e4f970dd214bd3ee79d81b)
* Quick fix for typo 'Quering'Dario Minnucci2010-12-014-8/+8
| | | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net> (cherry picked from commit 35d84a44f2bec3754fca0604d8bb6a3a598b8441)
* SQLite3 eurephiadm fix: sorting lastlog based on session status didn't workDavid Sommerseth2010-11-262-2/+2
| | | | | | | | | | 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> (cherry picked from commit 5581ba10af35b94e750596312a9782255084aaeb)
* Fixed Doxygen complaintsDavid Sommerseth2010-08-274-32/+0
| | | | | | Removed some #defines which was not needed Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Added install rules for man pagesv1.0.0David Sommerseth2010-07-061-0/+1
|
* Moved all man pages from section 8 to the more proper section 7.David Sommerseth2010-07-051-4/+4
|
* Added man pages for eurephia-auth.so and edb-sqlite.soDavid Sommerseth2010-07-051-0/+31
|
* Updated Copyright dates to include 2010David Sommerseth2010-05-2521-21/+21
|
* Fixed wrong usage of lower(digest) in eDBregister_attempts()David Sommerseth2009-11-131-8/+14
| | | | | | | This is a follow up of commit de7a3d88c78cdf400fcee78f71946da8b12ec74f.That commit introduced an SQL error when eDBregister_attempts() was attempting to update certificate digest attempt records. Overhauled and fixed the complete eDBregister_attempts() function.
* Certificate digests are always lower case.David Sommerseth2009-11-128-25/+31
| | | | | This makes sure that all interactions with the database will convert the digest strings to lower case.
* Add support for ft_STRING_LOWER in the sqlite3 driverDavid Sommerseth2009-11-121-7/+17
| | | | Also fixed some wrong tab/space issues
* Define certificate digests as ft_STRING_LOWERDavid Sommerseth2009-11-122-63/+63
| | | | This means this field will always be processed with 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.
* Always process certificate depth as integerDavid Sommerseth2009-10-132-4/+4
|
* Restrict input data length for plug-in arguments from openvpnDavid Sommerseth2009-10-041-2/+2
| | | | This only affects functions related to MAC address and certificate depth
* Corrected some new Doxygen issuesDavid Sommerseth2009-09-282-3/+4
|
* Reworked and unified admin authentication and registration functions to ↵David Sommerseth2009-09-283-114/+235
| | | | | | | | 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-272-2/+2
|
* Code clean up. Moved xmlReplaceChars() to eurephia_xml.cDavid Sommerseth2009-09-276-31/+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 missing check in eDBadminValidateSession() against interface typeDavid Sommerseth2009-09-271-2/+3
|
* Cosmetic cleanupDavid Sommerseth2009-09-271-8/+4
|
* Fixed a memory leak when updating user accounts in eDBadminUserAccount()David Sommerseth2009-09-271-0/+1
|
* Fixed memory leak when sqlite_query() failsDavid Sommerseth2009-09-261-0/+1
|
* Rewrote sqlite_get_num_tuples() and sqlite_get_affected_rows() as macrosDavid Sommerseth2009-09-262-26/+21
|
* Fixed SEGV error when calling sqlite_dump_result() on dbresults from other ↵David Sommerseth2009-09-261-2/+3
| | | | queries than SELECT
* Removed a memory leakDavid Sommerseth2009-09-261-0/+1
|
* Only add table alias in SQL 'WHERE' sectionsDavid Sommerseth2009-09-261-1/+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
|
* eDBmkSortKeyString() will now return NULL if the result is emptyDavid Sommerseth2009-09-251-1/+1
|
* 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-254-12/+15
| | | | eDBxmlMapping()
* Moved the useful append_str() macro from sqlite.c to eurephia_nullsafe.hDavid Sommerseth2009-09-251-11/+0
|
* 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-243-303/+236
| | | | | | Rewritten the database API and the SQLite3 database driver. This code has yet not been tested.
* Fixed and cleaned up Doxygen commentsDavid Sommerseth2009-09-221-69/+13
|
* Unified eDBadminGetCertificateInfo(), eDBadminAddCertificate() and ↵David Sommerseth2009-09-223-99/+126
| | | | | | 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-214-113/+116
| | | | eDBadminAccessLevel()
* Added eDBmappingGetValue() to retrieve field values from a eDBfieldMap structDavid Sommerseth2009-09-212-0/+27
|
* Improved some doxygen commentsDavid Sommerseth2009-09-201-1/+3
|
* Removed usage of a global result pointerDavid Sommerseth2009-09-171-54/+50
| | | | | | | | The callback function do now get a pointer to the query results directly instead of using a global result pointer. This makes queries done in parallel a lot safer. Made the SQLITE_DEBUG main() function more generic and removed memwatch references which is no longer in use, as valgrind is much better and easier to use.
* Unified database driver functions eDBadminConfigSet() and ↵David Sommerseth2009-09-143-29/+151
| | | | eDBadminConfigDelete() into eDBadminConfiguration()
* Corrected some doxygen issues after rearranging the sqlite3 db driver codeDavid Sommerseth2009-09-131-1/+2
|