eurephia.git/database/sqlite, branch release/1.1

sqlite3: Improve error handling if memory alloc fails for SQL query string

2012-10-19T16:25:01+00:00

Signed-off-by: David Sommerseth 
(cherry picked from commit 2613675111387fb0753d31be74b5e0a362389ef8)

SQLite: Move default installation path from /etc/openvpn to /var/lib/eurephia

2012-10-08T22:32:28+00:00

Using /var/lib is more appropriate for the kind of database file eurephia uses
and will also avoid other security restrictions on hardened installations as well.

Signed-off-by: David Sommerseth

Updated copyright dates

2012-10-08T00:18:14+00:00

Signed-off-by: David Sommerseth

sqlite/admin: Report all timestamp fields with localtime instead of UTC/GMT

2012-10-08T00:18:14+00:00

Made all SELECT queries which is used for reports to use the new 'locdt' SQL
function on timestamp fields.  This converts the UTC/GMT timestamps stored in
the database to the correct timezone of the running admin client.

Signed-off-by: David Sommerseth

sqlite: Added SQL function to convert datetime timestamps from UTC/GMT to localtime

2012-10-08T00:17:51+00:00

All CURRENT_TIMESTAMP calls are returned in UTC/GMT, and this value is stored in the
database.  When using eurephiadm to look at these datetime fields the UTC/GMT value
is used, and needs to be taken in consideration when looking at the reports.  This
patch is the first step to handle the local time zone better.

This patch also fixes the 'debug' program in sqlite.c, making use of the
eurephia_log_init() and eurephia_log_close() calls for log preparations.

Signed-off-by: David Sommerseth

sqlite3: Implement eDBregister_vpnclientaddr()

2012-09-13T15:56:45+00:00

This commit implements the eDBregister_vpnclientaddr() needed by the
newer eurephia-auth plug-in.  This is needed to improve the tun support
in eurephia.

In addition, this also updates the SQL schema to include IPv4 and in
the future IPv6 addresses in the lastlog and VPN address history
(openvpn_vpnaddr_history).  The old openvpn_macaddr_history table
is deprecated.

Signed-off-by: David Sommerseth

Modified the whole edb-sqlite driver to use a better error handling

2011-12-19T10:05:38+00:00

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

Implemented better error handling in the SQLite3 framework

2011-12-19T10:05:35+00:00

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

edb-sqlite: Fixed a typos and copyright notices

2011-07-25T10:51:03+00:00

Signed-off-by: David Sommerseth

Fixed several memleaks in the eurephiadm related code paths

2011-01-10T00:19:22+00:00

Signed-off-by: David Sommerseth