summaryrefslogtreecommitdiffstats
path: root/database
Commit message (Collapse)AuthorAgeFilesLines
...
* Added a new database driver function: eDBregister_vpnclientaddr()David Sommerseth2012-09-132-4/+36
| | | | | | | | | | | | This function replaces eDBregister_vpnmacaddr(). This new function will in addition to the MAC address (if OpenVPN is running in TAP mode) also register the client's IPv4 VPN address. It's also prepared for logging the client's IPv6 VPN address. This function supports both TUN and TAP mode, while the old function only handled TAP mode. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Modified the whole edb-sqlite driver to use a better error handlingDavid Sommerseth2011-12-1910-192/+397
| | | | | | | | | | | 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>
* Implemented better error handling in the SQLite3 frameworkDavid Sommerseth2011-12-192-18/+133
| | | | | | | | | | | | | | | | The core sqlite_query() function will now always return a pointer to a dbresult structure. This structure now contains a query status and the error message from the sqlite3 backend if something went wrong. This means that error checking from now on should use the sqlite_query_status() macro and not to check if sqlite_query() returns NULL. Another fundamental change is that sqlite_free_results() must always be called on the dbresult structure now, to free the memory used by either data from the query or the error message. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* edb-sqlite: Fixed a typos and copyright noticesDavid Sommerseth2011-07-251-3/+4
| | | | 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>
* 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>
* 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-014-8/+8
| | | | Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* SQLite3 eurephiadm fix: sorting lastlog based on session status didn't workDavid Sommerseth2010-11-122-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>
* Updated wrong log entriesDavid Sommerseth2010-08-291-8/+8
| | | | | | Removed old and obsolete expressions used to reference the eurephia database driver. 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>
* Added install rules for man pagesDavid Sommerseth2010-07-301-0/+1
|
* Moved all man pages from section 8 to the more proper section 7.David Sommerseth2010-07-301-4/+4
|
* Added man pages for eurephia-auth.so and edb-sqlite.soDavid Sommerseth2010-07-301-0/+31
|
* Updated Copyright dates to include 2010David Sommerseth2010-07-3021-21/+21
|
* Merge branch 'master' into nextDavid Sommerseth2009-11-131-8/+14
|\
| * 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.
* | Cleaned up the driver/interface API for database and firewallDavid Sommerseth2009-11-121-40/+45
|/
* 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().
generated by cgit (git 2.34.1) at 2026-01-06 01:40:45 +0000