summaryrefslogtreecommitdiffstats
path: root/database/sqlite
Commit message (Collapse)AuthorAgeFilesLines
...
* edb-sqlite: Update openvpn_users.last_accessed = now() on successful loginDavid Sommerseth2008-12-081-0/+13
|
* Added eDBadminGetUserInfo(...) function, to retrieve user infoDavid Sommerseth2008-12-071-2/+46
|
* Extended sqlite.[ch] with sqlite_query_mapped(...)David Sommerseth2008-12-072-1/+35
| | | | | | | This functions does almost the same as sqlite_query(...), it takes an SQL statement without the WHERE clause. The where clause is built up based on the fields sent in via the eDBfieldMap struct, containing the fields and values to look for.
* Added missing copyright header, corrected another wrong file headDavid Sommerseth2008-12-061-0/+20
|
* Added missing shared source for edb-sqlite.soDavid Sommerseth2008-12-061-0/+1
|
* Moved over from earlier commit to use unified db translationDavid Sommerseth2008-12-063-9/+11
| | | | | | | In other words, rewrote commit 6d4373e026b3f12c5685e45e35f9f060379ed0f3. Moved over all functions from that commit which could take advantage of the new API for unified table/field translation.
* Added sorting in db driver in eDBadminGetUserList(...). Improved comments.David Sommerseth2008-12-062-6/+50
|
* Added admin function to give a list of usersDavid Sommerseth2008-12-062-1/+44
|
* Changed the sortkey type from int to const char *David Sommerseth2008-12-061-6/+10
|
* Changed admin functions to be prefixed with eDBadmin*, to unify the function ↵David Sommerseth2008-12-051-11/+11
| | | | name schema
* Moved administration functions (eDBadmin*) into adminstration.cDavid Sommerseth2008-12-033-364/+381
|
* Workaround to avoid getting existing eurephiadb template db block rebuildingDavid Sommerseth2008-12-031-1/+4
|
* Fixed wrong data type for the access variable in eDBadminAuth(...)David Sommerseth2008-12-031-2/+2
|
* BUGFIX: Logout works properly again and improved logout status changeDavid Sommerseth2008-12-031-7/+11
| | | | | | - cmd_Logout(...) used the wrong argv[] index for sessionkey. - Improved eDBadminValidateSession(...) to set status to '5' on sessions which are getting logged out due to missing privileges
* Changed the logout behaviour to avoid login and/or access control check when ↵David Sommerseth2008-12-031-5/+5
| | | | user is about to logout
* Enhanced the access control by introducing access levelsDavid Sommerseth2008-12-022-31/+73
|
* Added database functions for editing the openvpn_config tableDavid Sommerseth2008-12-021-0/+46
|
* Fixed memory leak. Was missing a sqlite_free_results(...)David Sommerseth2008-11-301-0/+1
|
* Added eDBadminLogout(...) function in database driverDavid Sommerseth2008-11-301-3/+42
| | | | | Added one more status code, for active sessions. Auto-logout will now also delete session variables
* eurephiadm can now use eDBadminValidateSession(...) to use open session. ↵David Sommerseth2008-11-301-1/+44
| | | | Auto-logout implemented as well
* Unified define flagsDavid Sommerseth2008-11-301-1/+0
|
* Completed the change of authentication model in database driverDavid Sommerseth2008-11-302-85/+49
| | | | | | Follow up of commit 103acd7c2e1467401f0795930be9140dc5ed47ff. Seems to work fine via both plugin mode and eurephiadm, regarding core dumping too.
* Fixed core dump issue with eDBstore_session_value(...) / ↵David Sommerseth2008-11-301-0/+1
| | | | (*eDBstore_session_value)(...)
* Merge branch 'master' into eurephiadmDavid Sommerseth2008-11-291-5/+8
|\
| * BUGFIX: Use hard coded default values when checking against openvpn_attempts ↵David Sommerseth2008-11-291-5/+8
| | | | | | | | if config parameters is not set
* | Login seems to work from database driver sideDavid Sommerseth2008-11-292-5/+253
| |
* | Added context_type into eurephiaCTX struct. Database queries limited due to ↵David Sommerseth2008-11-291-0/+4
| | | | | | | | context type.
* | Splitted plugin/eurephiadb_session.[ch] into two partsDavid Sommerseth2008-11-282-2/+2
| | | | | | | | | | | | | | | | | | One part is a generic session handling part (common/eurephiadb_session_common.[ch]) and the other part is left in the old plugin/eurephiadb_session.[ch]. This splitting should make it easiser to reuse some of the session handling functions for the admin utils.
* | Rough preparation of the db drivers for API ver 2David Sommerseth2008-11-281-3/+14
|/
* BUGFIX: Added missing linking against cryptoDavid Sommerseth2008-11-281-1/+1
|
* Code cleanup: Splitted all structures defined in eurephia_struct.h into ↵David Sommerseth2008-11-051-1/+1
| | | | separate include files
* Renamed eurephiadb-sqlite to edb-sqliteDavid Sommerseth2008-11-052-7/+7
|
* Code improvement - using already assigned (char *) pointer instead of ↵David Sommerseth2008-11-031-1/+1
| | | | calling sqlite_get_value(...) once again
* Added double check if ip address is NULL or notDavid Sommerseth2008-11-011-1/+4
|
* Fixed missing WHERE clause in SQL for extracting blacklisted IP addressesDavid Sommerseth2008-11-011-1/+1
|
* Fixed wrong registration of IP addresses in eDBget_blacklisted_ip(...)David Sommerseth2008-11-011-1/+1
|
* Added eDBget_blacklisted_ip(ctx) functions into db driversDavid Sommerseth2008-11-011-0/+22
|
* Created install rules via cmakeDavid Sommerseth2008-10-211-1/+6
|
* Reorganised the source codeDavid Sommerseth2008-10-151-6/+8
| | | | | | | | Moved all OpenVPN plug-in related things into ./plugins, including firewall Moved all shared code into ./common and moved the generic part of the database files into ./database Updated all CMakeLists.txt files and created a new one for the root directory
* Merge branch 'master' into cmakev0.9_betaDavid Sommerseth2008-10-081-13/+2
|\
| * Moved TLS authentication logging from database module to eurephia.cDavid Sommerseth2008-10-081-13/+2
| | | | | | | | Also differentiated log level from user certs (depth == 0) and other depths.
* | Merge branch 'master' into cmakeDavid Sommerseth2008-10-042-86/+86
|\|
| * Log review - last round for now. Recategorised a few errors and warnings.David Sommerseth2008-10-041-3/+3
| |
| * Log review - changed log levels for all DEBUG(...) callsDavid Sommerseth2008-10-042-23/+23
| |
| * Log review (part 1) - log categoriesDavid Sommerseth2008-10-031-61/+61
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Went through all parts of the code, and reorganised log categories. The following "rules" where used for categorisation: LOG_INFO - General info, should avoid log level higher than 5 LOG_DEBUG - Using DEBUG function only log level always > 10 LOG_WARNING - When something action fails, but not as severe that the process cannot continue. Log level never > 2 LOG_ERROR - API errors, but not severe, can continue LOG_FATAL - Action failed and we cannot continue in this function. Log level always < 2 LOG_PANIC - Action failed and eurephia-auth cannot continue to work any more (program restart needed). Log level always 0
* | Made cmake also create template databaseDavid Sommerseth2008-10-031-0/+10
| |
* | Improved cmake rulesDavid Sommerseth2008-10-031-6/+21
| | | | | | | | | | | | - Added checks for external libraries that we use - Linking now links in needed shared libraries - Added better check if OPENVPN_SRC_DIR is set
* | Adjusted to match new cmake regimeDavid Sommerseth2008-10-021-0/+3
| |
* | Added support for cmakeDavid Sommerseth2008-10-022-43/+14
|/
* BUGFIX: Changed SQLite database schema to allow mulitple identical sessionseedsDavid Sommerseth2008-09-261-1/+2
| | | | | | | | | This is to comply to the new behaviour after commit fc8a177bc86fc7e68b15045ba7a791e2504f4b5c. Now we might get several identical session seeds, but some of them might be connected to sessions getting destroyed, while one of them would be connected to an already active session. sessionkey is now the primary key.