summaryrefslogtreecommitdiffstats
path: root/database/sqlite
Commit message (Collapse)AuthorAgeFilesLines
...
* Prepared for building with libxml2David Sommerseth2008-12-131-2/+11
|
* Modified flags againDavid Sommerseth2008-12-121-4/+17
| | | | | | Added RSETLASTUSED (last_accessed is set to NULL) and RSETLOGINCNT (lastlog table has been modified). NEVERUSED flag will only be set if last_accessed is NULL and login count == 0.
* Fixed yet another strange SQLite3 parsing issueDavid Sommerseth2008-12-111-1/+1
|
* Added ACCFLAG_ERRATTEMPT for flagging if the attempt counter > 0David Sommerseth2008-12-111-1/+4
|
* Corrected a lot of small errors, setting wrong flag and SQL mistakesDavid Sommerseth2008-12-111-4/+9
|
* Added logincount and setting user account flagsDavid Sommerseth2008-12-111-5/+17
|
* Enhanced table/field mapping and eDBmkMapping_USERINFO(...) to include ↵David Sommerseth2008-12-112-7/+11
| | | | possibility for table aliases
* Added functions for processing eurephiaACCESSINFO/eurephiaACCESSLISTDavid Sommerseth2008-12-112-3/+20
| | | | | | | | | | Implemented saving VPN access profile to the eurephiaCERTINFO struct and filling the eurephiaACCESSINFO with the proper information needed in the eDBadminGetUserInfo(...) function. The special thing about eurephiaACCESSINFO, is that it will not register duplicate records. And when the eurephiaCERTINFO is free'd, the eurephiaACCESSLIST will automatically be free'd as well.
* Updated eDBadminGetUserInfo(...) to take filtering parameterDavid Sommerseth2008-12-101-35/+48
|
* eDBadminGetUserList(...): Added certificate info into the eurephiaUSERINFO ↵David Sommerseth2008-12-091-2/+31
| | | | struct
* Fixed wrong assert criteriaDavid Sommerseth2008-12-081-1/+1
|
* Do not encapsulate key-value pairs with () in UPDATE modeDavid Sommerseth2008-12-081-3/+13
| | | | | And added support for setting fields to NULL if flagged via the field type value ft_SETNULL
* Fixed a couple of memory leaks in eDBadminUpdateUser(...)David Sommerseth2008-12-081-0/+4
|
* edb-sqlite: Added update user functionDavid Sommerseth2008-12-081-3/+23
|
* Added possibility to also set NULL values in UPDATEDavid Sommerseth2008-12-081-1/+2
|
* Update field mapping to include data type. Improved ↵David Sommerseth2008-12-083-30/+162
| | | | | | | | | | | | | | sqlite_query_mapped(...) function The new sqlite_query_mapped(...) function will now consider the field type when formatting the data values for SQLite. In addition reserved words on the DATETIME data type will be preserved without quote encapsulation. Improved the sqlite_query_mapped(...) to also handle UPDATE, INSERT and DELETE in addition to SELECT. The function now needs two eDBfieldMap mappings. The first one will contain update/insert values, while the last one defines search criteria.
* 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
|
generated by cgit (git 2.34.1) at 2025-09-27 06:29:29 +0000