summaryrefslogtreecommitdiffstats
path: root/database
Commit message (Collapse)AuthorAgeFilesLines
...
* Implemented the eDBadminGetLastLog(...) function in the SQLite3 driverDavid Sommerseth2009-03-243-4/+102
|
* Added more fields to the global field mapping tableDavid Sommerseth2009-03-241-30/+37
| | | | | Had to also extend the FIELD_* assignments to allow two new fields to be mapped
* Extended the database driver with eDBadminGetAdminAccess(...)David Sommerseth2009-03-243-0/+64
| | | | | | This function will return an XML document with data extracted from the eurephia_adminaccess table. Search criterias are defined by the search XML doc given as input.
* Added support for editing the eurephia_adminaccess tableDavid Sommerseth2009-03-226-6/+98
| | | | Implemented eDBadminEditAdminAccess(...) function in db driver
* Rewrote database driver (SQLite) to use eurephia_pwd_crypt(...)David Sommerseth2009-03-223-23/+44
| | | | Follow up from commit 062a3c92343a5fa371f8637f8bca88aacca14cc4
* Added missing source in edb-sqlite driver after reorg with randstr.cDavid Sommerseth2009-03-211-0/+1
|
* Compile fix: Use sqlite_int64 instead of sqlite3_int64David Sommerseth2009-03-021-1/+1
| | | | | This makes it possible to compile it on some older versions of the SQLite3 library
* Introduced password caching on authenticated sessionsDavid Sommerseth2009-01-032-20/+44
| | | | | | | | | | | | | | | | | | | | | | This is to prepare eurephia-auth plugin to use other and more CPU intensive hashing algorithms for passwords. In addition, open sessions will now not be rejected/closed due to wrong password if the user changes the password with an open session running. The patch adds a new server_salt attribute in the eurephiaCTX structure. This is used as a temporary salt and is created of random data when OpenVPN is started. When a user is being authenticated (eurephia.c/eurephia_userauth) a authentication session (not the same as a 'normal' session) is opened and checked for a cached password. If it does not exist or match, normal password check will be done against the user database. If a cached password is found and matches, it is considered to be authenticated. The cached password uses the SHA512 algorithm, together with the eurephiaCTX->server_salt.
* Prepared passwdhash function to allow salting and be prepared for other ↵David Sommerseth2009-01-023-3/+4
| | | | hashing algorithms
* Make it possible to compile plug-in again without eurephiadm enabledDavid Sommerseth2009-01-023-7/+11
|
* sqlite3 - compile in common/eurephia_xml.c when admin mode is enabledv0.9.3_betaDavid Sommerseth2008-12-291-1/+1
|
* Added db driver function: eDBadminGetUserCertsList(...) - to get user ↵David Sommerseth2008-12-283-0/+74
| | | | account/certs links
* Simplified some certificate field names for internal useDavid Sommerseth2008-12-261-2/+2
|
* sqlite3: Make sqlite_query_mapped(...) work with empty WHERE clauseDavid Sommerseth2008-12-261-3/+10
|
* sqlite3 - admin: Added DEBUG statements on all function callsDavid Sommerseth2008-12-261-1/+18
|
* sqlite3 db driver: Added eDBadminUpdateUserCertLink(...) function to add and ↵David Sommerseth2008-12-253-1/+51
| | | | delete records in openvpn_usercerts
* BUGFIX: Fixed missing 'break' statements in switch for the ↵David Sommerseth2008-12-251-1/+4
| | | | eDBgetTableFieldMapping(...) function
* Added usercerts to the table name mapping tableDavid Sommerseth2008-12-251-0/+1
|
* Added check if fieldMapping node's table attribute is setDavid Sommerseth2008-12-251-0/+5
|
* Added field mapping for the openvpn_usercerts tableDavid Sommerseth2008-12-253-3/+28
|
* Fixed spelling mistake in XML attribute for certificatesDavid Sommerseth2008-12-221-1/+1
|
* sqlite3 - Return uid or certid of newly registered users or certificatesDavid Sommerseth2008-12-221-9/+12
|
* sqlite3 - Added saving last_insert_id on INSERT INTO queriesDavid Sommerseth2008-12-223-1/+9
|
* Moved all replace_char(...) calls into SQLite3 driver as xmlReplaceChars(...)David Sommerseth2008-12-211-5/+37
|
* sqlite3 - Added eDBadminGetCertificateInfo(...)David Sommerseth2008-12-202-3/+93
|
* sqlite3 - Added sortkeys as argument to sqlite_query_mapped(...)David Sommerseth2008-12-203-8/+14
| | | | | The last argument to the function can contain a list over field names which will be used in the ORDER BY clause when doing SELECT queries.
* Added eDBadminDeleteCertificate(...) function in SQLite3 driverDavid Sommerseth2008-12-202-3/+53
|
* Corrected wrong field name (org->organisation) in field mappingDavid Sommerseth2008-12-201-1/+1
|
* sqlite3: Corrected some compiler warningsDavid Sommerseth2008-12-201-2/+2
|
* sqlite3: Added eDBadminAddCertificate(...) functionDavid Sommerseth2008-12-201-2/+51
|
* Added field mapping for the certificates tableDavid Sommerseth2008-12-202-27/+39
|
* Changed from numeric session status code to text in eDBadminGetUserInfo(...) ↵David Sommerseth2008-12-193-1/+14
| | | | - lastlog
* sqlite - admin: Added fetching blacklist info for user account.David Sommerseth2008-12-191-0/+24
|
* sqlite - admin: Added fetching login attempt for user. Fixed a memory leak ↵David Sommerseth2008-12-191-4/+30
| | | | and removed XML dump for debug
* Added extraction of lastlog info in eDBadminGetUserInfo(...)David Sommerseth2008-12-191-43/+104
|
* Fixed more memory leaks and missing memory initialisation.David Sommerseth2008-12-191-2/+4
|
* sqlite - BUGFIX: Fixed INSERT INTO statements when using ↵David Sommerseth2008-12-181-2/+8
| | | | sqlite_query_mapped(...)
* Fixed segfault and wrong XML node extraction in eDBxmlMapping(...)David Sommerseth2008-12-181-2/+2
|
* sqlite: Fixed segfault int SQLreservedWord(...)David Sommerseth2008-12-181-1/+1
|
* Added SQLite3 admin functions for adding and deleting usersDavid Sommerseth2008-12-181-2/+90
|
* Added pwhash attribute in fieldMapping XML for password fields.David Sommerseth2008-12-181-5/+19
| | | | | | | This attribute can be "sha512" if the contents of the field is already hashed with SHA512. The other official value is "none", which will then tell eDBxmlMapping(...) to hash the value. Unknown values will be treated like 'none'.
* Added more comments and some XML format documentationDavid Sommerseth2008-12-181-4/+28
|
* Removed all other eurephia admin structs which can be replaced by XMLDavid Sommerseth2008-12-182-12/+12
|
* Removed everything which was connected to the eurephiaUSERINFO struct.David Sommerseth2008-12-183-11/+10
|
* Rewrote eDBadminUpdateUser(...) to use XML instead of eurephiaUSERINFODavid Sommerseth2008-12-182-15/+34
|
* eDBxmlMapping(...) did not honor the setnull attribute correctly.David Sommerseth2008-12-181-10/+17
|
* Updated eAdminGetUserInfo(...) work after commitDavid Sommerseth2008-12-171-2/+4
| | | | 31911812e53a8fda5ce8fa8e9d45254053a580c5
* Rewrote eDBxmlMapping(...) to take an XML node instead of a complete XML ↵David Sommerseth2008-12-172-17/+38
| | | | | | | | document as input. The node name of the input node must be <fieldMapping/>. In addition this node must have an attribute called "table" which must match the eDBfieldMap* structure given as input.
* Changed eDBxmlMapping(...) function to make use of the new ↵David Sommerseth2008-12-171-1/+3
| | | | eurephiaXML_getRoot(...) function
* Using the new eurephiaXML_* functions for creating and parsing XMLDavid Sommerseth2008-12-171-6/+2
| | | | | | | | | | | Also rebased the XML file to always have a document root which is <eurephia/>. This tag must contain a "format" attribute, which should be 1 for the moment. When parsing the XML, the eurephiaXML_getRoot(...) function will return a pointer to the requested XML node inside the <eurephia/> document root. The format version in the root element will also be checked automatically.
generated by cgit (git 2.34.1) at 2025-09-26 12:04:03 +0000