nik/davical
1
0
Fork 0
mirror of https://gitlab.com/davical-project/davical.git synced 2026-01-27 00:33:34 +00:00
Code Issues Actions Packages Projects Releases Wiki Activity
3,744 Commits 11 Branches 58 Tags 14 MiB
Commit Graph

307 Commits

Author SHA1 Message Date
Andrew Ruthven
1977e9f283 Update initial SQL to create usr_emails table. 
I much prefer running patches to update the schema, but ah well.
 2021-02-26 00:23:00 +13:00
Florian Schlichting
0a6d34a929 make db upgrade work 
to use this branch:
===================

- git co master
- ./run_regression -> abort during tests
- git co multiple_email
- ./dba/update-davical-database --dbname=regression
 2021-02-05 16:20:00 +08:00
Andrew Ruthven
ee8a751add WIP: Multiple emails for principles 2021-02-05 14:52:00 +08:00
Jamie McClymont
0c006b5c7c Make the recurrence range columns in the database tz-aware 2019-01-03 16:04:28 +13:00
Antoine
c2254d7682 Allow user to define awl_appuser and awl_dbauser on create-database script 2018-02-21 12:36:03 +01:00
Florian Schlichting
7674fe9831 'perl update-davical-database' did not find the intended config file / patchdir 
people may use that invocation in addition to calling
/usr/share/davical/dba/update-debian-database, and happen upon a
cryptic error when YAML tries to parse dba/update-davical-database
instead of config/administration.yml
 2017-10-09 10:17:03 +02:00
Florian Schlichting
39001794a3 Update caldav_functions.sql for Postgresql 10 
From version 10, Postgresql does not allow set-returning functions in
CASE statements. As we're using the functions recursively, we cannot
use LATERAL as suggested in the error message, but we can switch the
condition inside-out with only a limited amount of repetition.
 2017-10-04 22:36:29 +02:00
Florian Schlichting
69ef196730 create-database.sh: call update-davical-database with --dbuser instead of just --owner (see #124) 2017-09-20 17:02:57 +02:00
Florian Schlichting
2a84694331 Unbreak locale selection in admin interface 
http://php.net/manual/en/function.setlocale.php says "Different systems
have different naming schemes for locales." This seems to be true for
platforms (eg Win vs. Linux), but on Debian AFAIR locales were always at
least two-part (de_DE), never just one (de). This seems to have been
broken in 504651a3, likely by mistake.

Also, switch locale immediately, even before writing to the database.

BTW, what happens when system default locale is configured to e.g. fr_FR
and the user selects "English" - does that work?
 2017-01-17 23:40:26 +01:00
Florian Schlichting
2c11535eb0 use secure URIs where possible 2017-01-08 15:48:52 +01:00
Andrew McMillan
c5c0421caf Add /metrics.php to be scraped by Prometheus for monitoring. 2016-06-22 23:53:22 +01:00
Andrew McMillan
1ab66a70b5 Some database changes for server-side attendee handling. 2016-06-22 23:44:10 +01:00
Florian Schlichting
af1707ef1d prepare for 1.1.4 2016-01-03 19:09:56 +01:00
Andrew McMillan
9580da622a Support regression testing with postgres on non-default port 
[from github handle-remote-attendees branch]
 2015-12-27 13:02:38 +01:00
Florian Schlichting
8895aac2bf replace a few remaining instances of the old name "rscds" 2015-10-02 22:22:10 +02:00
Florian Schlichting
0cdcce0a6c Do not throw postgres errors when views/types/functions to be dropped do not exist (yet). Fixes #43 2015-10-02 22:09:34 +02:00
Mark Davies
0797e8233e First batch of database indexes 
Added in support of Issue #31, Database Performance Improvements. Note
creation of 1.2.12 db patch script - may need renaming or other special
treatment when merging this branch.
 2014-12-16 21:29:26 +01:00
Mark Davies
1fe5d24d9f Fix up Windows create-database.bat - see Issue #32. 2014-12-16 21:07:38 +01:00
Aaron W. Swenson
cfd5fd7555 Loop Over AWL Directory Candidates 
Using this method we're able to loop over the candidate directories
until we find what should be suitable AWL location. Further, adding
additional locations is as simple as adding a new line to ${awldirs}.

It does have the limitation that if the path has a new line in it
(/some/ridic
ulous/path), it'll treat it as two different paths. However, if
somebody seriously has that, they deserve the pain.
 2014-11-14 13:44:39 -05:00
“Paul
931651ca32 Remove quoted SQL language identifiers 2014-09-02 20:01:28 +02:00
Ján Máté
b5e409f7da fix to rename/delete the collection properties during the collection renaming/deleting 2013-10-25 12:16:27 +13:00
Andrew McMillan
8f3175248a A corrected change to fix the case of the language name everywhere. 2013-03-06 23:56:40 +13:00
Andrew McMillan
25c9fca4b8 Correct capitalisation of 'plpgsql' language for Postgres 9.2. 2013-03-06 20:22:55 +13:00
Andrew McMillan
5e195b151e A function which can expand collections inside collections. 
Including through bindings.
 2012-05-05 23:00:28 +12:00
Andrew McMillan
7c15051f84 Further fixes to WebDAV synchronization. 
This should be fully reliable now and also cleans out all sync
changes more than one week old.  update-database is needed to pull
the new function.
 2012-04-17 15:44:09 +12:00
Andrew McMillan
c6b95bc3f6 Do a bit_or() among multiple privilege settings. 2012-04-05 13:22:47 +12:00
Andrew McMillan
7140963e49 Allow user_no, created and modified to be set on create. 2012-01-15 20:44:10 +13:00
Andrew McMillan
d86132ed54 Current locales. 2011-11-21 10:57:10 +13:00
Andrew McMillan
3198191462 New Spanish(Spain) translation, updated French translations. 2011-10-26 12:36:01 +13:00
Andrew McMillan
c41f4071e4 Get rid of unsightly error due to removal of time_zone table. 2011-09-30 11:56:35 +02:00
Andrew McMillan
6d89db58d0 Fix setting of PG password from administration.yml during upgrade. 2011-09-24 14:29:41 +12:00
Andrew McMillan
cd7f8c35f2 Update to version 1.2.11 2011-09-24 12:56:11 +12:00
Andrew McMillan
5104ca25a4 Provide an alternative 1.2.10 with the check_db_revision() function fixed. 2011-09-20 08:55:26 +12:00
Andrew McMillan
cdc23ea732 Add etag to timezone table. 2011-09-19 08:42:28 +12:00
Andrew McMillan
f9ad324ba1 Adjustments to timezones representation in the database to support timezone protocol. 2011-09-17 23:40:04 +12:00
Andrew McMillan
05d42557d7 Update davical.sql to 1.2.10. 2011-09-12 09:49:32 +12:00
Andrew McMillan
1c965d4cdf Removed these outdated files. 2011-09-11 00:56:16 +12:00
Andrew McMillan
b4364fb999 Fix for the following error: 
davical: LOG: principals/users/cars/hilux/: Query: QF: SQL error "42804" - ERROR: column "changed_by" is of type integer but expression is of type name LINE 1: ...on, property_name, property_value ) VALUES( path, user, curr... ^ HINT: You will need to rewrite or cast the expression. QUERY: INSE
davical: LOG: principals/users/cars/hilux/: Query: QF: RT INTO property ( dav_name, changed_by, changed_on, property_name, property_value ) VALUES( path, user, current_timestamp, key, value ) CONTEXT: PL/pgSQL function "set_dav_property" line 16 at SQL statement"
davical: LOG: principals/users/cars/hilux/: Query: QF: SELECT set_dav_property( :dav_name, :user_no, :tag::text, :value::text)
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":dav_name" => "/cars/hilux/"
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":user_no" => "1023"
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":tag" => "http://apple.com/ns/ical/:calendar-color"
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":value" => "#711A76"

From 'mate' on IRC.
 2011-08-28 16:38:14 +12:00
Andrew McMillan
05badd4d3a New SQL patch file, and fix comment in the last one also. 2011-08-25 15:05:28 +12:00
Rob Ostensen
b2ef0b0bf2 Add the required fields to dav_binding and clean up the SQL to better match the rest of the source. 
Add a header/last-modified check to skip the import on calendars that haven't changed.
 2011-08-25 14:17:28 +12:00
Andrew McMillan
504651a3f5 Add new locales and restructure how they are handled. 
We now build the dba/supported_locales.sql file from po/locale.values
files for each locale, and we are also fetching the translations from
transifex.net in order to build them.

This commit also adds support for some new locales, especially
Brazilian Portuguese and Mexican Spanish.
 2011-08-25 12:45:33 +12:00
Andrew McMillan
8743238952 Ensure dav_id_seq is initialized to a non-colliding value. 
Signed-off-by: Andrew McMillan <andrew@morphoss.com>
 2011-04-03 21:36:45 +12:00
Andrew McMillan
5dbe73f709 Set the correct DBA username. 
Signed-off-by: Andrew McMillan <andrew@morphoss.com>
 2011-03-31 11:40:34 +13:00
Andrew McMillan
ed7ffea332 Updated strings for localisation. 2011-01-14 16:20:16 +13:00
Andrew McMillan
493ec64cba Extend default_privileges to members of a group. 
Signed-off-by: Andrew McMillan <andrew@morphoss.com>
 2011-01-03 10:10:52 +13:00
Leho Kraav
904f3069ab add et_EE to support locales 2010-12-27 12:37:16 +13:00
Andrew McMillan
4e12eb82e4 Update sync-collection REPORT to match -04 of draft. 2010-11-30 12:31:25 +13:00
Andrew McMillan
5788a5b62d Changes to IDs due to minor regression process change. 2010-11-06 22:35:31 +13:00
Andrew McMillan
6533a89b7e Change regression runner to look for sample data with tests. 2010-11-06 18:05:04 +13:00
Andrew McMillan
ccf332d912 Remove unneeded double-quote. 2010-11-04 08:43:29 +13:00