Lustenberger Michael
92fe447fe0
Merge pull request #154 from zwischenloesung/master
...
Merge Basin and EasyRSA
2025-09-07 21:19:56 +02:00
Michael Lustenberger
451403d552
EasyRSA: Concatenate Chain
...
Fix local file lookup to not trying sudo.
2025-09-07 21:11:19 +02:00
Michael Lustenberger
a47781aee8
EasyRSA: Concatenate Chain
...
Fix task to also work on remote end..
2025-09-04 10:56:57 +02:00
Michael Lustenberger
dae4188a28
EasyRSA: Deploy Fix
...
Fix content results processing in maestro deploy.
2025-09-03 10:58:05 +02:00
Michael Lustenberger
119dc58c4b
EasyRSA: Prepare
...
Fix permissions on local paths.
2025-09-02 23:08:57 +02:00
Michael Lustenberger
d972f66c30
EasyRSA: Sanity-Check
...
Only run on enabled certs anyway.
2025-09-02 22:46:31 +02:00
Michael Lustenberger
6ee93c00dc
EasyRSA: Deploy
...
Add maestro-style deployment path.
2025-09-01 17:26:26 +02:00
Michael Lustenberger
10ebb63d09
EasyRSA: Sanity Check
...
Do fail on wrong target app per cert.
2025-08-26 10:50:14 +02:00
Michael Lustenberger
454b8828c9
EasyRSA: Clean Up
...
Differentiate variable names, fix conditions.
2025-08-26 10:18:05 +02:00
Michael Lustenberger
84786f119c
EasyRSA Self-Signed-Certs: Chains
...
Download CA chain files.
2025-08-20 18:47:15 +02:00
Michael Lustenberger
6b982f5aa3
EasyRSA Self-Signed-Certs: Chains
...
Concatenate CA chain files.
2025-08-20 17:17:25 +02:00
Michael Lustenberger
2f5f221008
Data Basin: Cron
...
Make cron optional, e.g. for auto backup-restore mode etc.
2025-08-19 21:18:37 +02:00
Michael Lustenberger
575ba72432
EasyRSA Self-Signed-Certs
...
Add a role to set up a PKI and distribute trusted certs, e.g. for client
device authentication.
2025-08-19 21:15:36 +02:00
Michael Lustenberger
8796fa42a1
PostgreSQL-Basin: Clean Up
...
Use CURRENT_TIMESTAMP consistently everywhere.
2025-07-30 16:01:30 +02:00
Michael Lustenberger
47d040d30a
PostgreSQL-Basin
...
Add project_id for (project-)local and glbal scopes.
2025-07-29 01:02:29 +02:00
Michael Lustenberger
9e6377e982
PostgreSQL-Basin
...
Remove not strictly necessary constraints to allow for more user
control.
2025-07-28 00:40:48 +02:00
Michael Lustenberger
e084a6bdb1
PostgreSQL-Basin
...
Scope of uniqueness redefined for sources.
2025-07-26 22:40:34 +02:00
Michael Lustenberger
3209681fc7
PostgreSQL-Basin
...
Add a structured SQL template to simplify project initialization.
2025-07-26 22:35:48 +02:00
Michael Lustenberger
f8b202d5b3
PostgreSQL-Basin
...
Fix smaller issues and give more control to the user.
2025-07-26 22:34:34 +02:00
Michael Lustenberger
a9cf01d087
Consolidate Basin SQL: Trigger
...
Unify, useing newer syntax.
2025-07-16 02:58:04 +02:00
Michael Lustenberger
a0905bf3ca
Consolidate Basin SQL: Clean Up Functions
...
Clean up several small fixes, like shadow table calls, fixing missing
parameters in inserts, URI handling, and fk lookups.
2025-07-16 01:49:41 +02:00
Michael Lustenberger
0d46d33e1d
Consolidate Basin SQL: Roles
...
Make it 'more' idempotent.
2025-07-15 18:44:08 +02:00
Michael Lustenberger
3dc3d60d7e
Consolidate Basin SQL: Revoke Roles
...
Revoke anyway, even it the roles are not active yet..
2025-07-15 17:42:12 +02:00
Michael Lustenberger
93197b450b
Consolidate Basin SQL: Lastmodifieduser
...
Finish switch to text instead of id - see last commit. Change name in
project uuid.
2025-07-15 17:12:59 +02:00
Michael Lustenberger
7b5156fb23
Consolidate Basin SQL: Lastmodifieduser
...
Switch to text instead of id - this is a log and we only want to know
a name. To trace it back to an actual user is even bad at times,
imagine a user get's deleted, so there would not be any trace of it...
2025-07-15 15:03:10 +02:00
Michael Lustenberger
460ccf4814
Consolidate Basin SQL: Columns
...
Clean up main columns.
2025-07-15 14:59:59 +02:00
Michael Lustenberger
2e7c09bda9
Consolidate Basin SQL: LTREE
...
Handle the sources' path column.
2025-07-15 02:23:58 +02:00
Michael Lustenberger
94e5c934d7
Consolidate Basin SQL: View
...
Temp. disable the view(s) - we need views per project later..
2025-07-15 02:21:52 +02:00
Michael Lustenberger
eb0345c347
Consolidate Basin SQL: Fix Syntax
...
Fix the syntax problem, where there were nested function bodies with the
same delimiter...
2025-07-14 17:34:02 +02:00
Michael Lustenberger
c1c4780735
Consolidate Basin SQL
...
Fix wrong reference.
2025-07-14 12:57:05 +02:00
Michael Lustenberger
e7dcd0a2b4
Consolidate Basin SQL
...
Rename LTREE column 'tree' to 'path'.
2025-07-13 23:48:26 +02:00
Michael Lustenberger
a846b49017
Consolidate Basin SQL
...
Provide means to enforce shadow table consistency, if pg_cron job is
enabled.
2025-07-13 22:12:35 +02:00
Michael Lustenberger
7799ff6193
Consolidate Basin SQL
...
Fix the creation date.
2025-07-12 18:06:49 +02:00
Michael Lustenberger
3a64669368
Consolidate Basin SQL
...
Add shadow table functions and define responsibilies. Still missing is
the handling of the LTREE in sources and the created date fix.
2025-07-12 17:30:44 +02:00
Michael Lustenberger
9f859ff051
Consolidate Basin SQL
...
Add a passhash column to the user table.
2025-07-11 22:24:23 +02:00
Michael Lustenberger
fbab0fe449
Consolidate Basin SQL
...
Clean up and unify default values, constraints and such.
2025-07-11 15:12:01 +02:00
Michael Lustenberger
0e4fd7293f
Consolidate Basin SQL
...
Clean up formatting..
2025-07-11 14:21:13 +02:00
Michael Lustenberger
f03bf15724
Consolidate Basin SQL
...
Rename trigger function.
2025-07-11 13:12:08 +02:00
Michael Lustenberger
14fdcd32ac
Consolidate Basin SQL
...
Dropping those foreign keys again as they create circular dependencies..
A simple existence test should do the trick anyway.
2025-07-11 12:35:15 +02:00
Michael Lustenberger
440b2c5630
Consolidate Basin SQL
...
Add default projects, shadow tables and get a little closer to
idempotency..
2025-07-11 10:50:01 +02:00
Michael Lustenberger
c9d12cd45f
Clean Up
...
Fix wording..
2025-06-28 15:39:28 +02:00
Lustenberger Michael
2d327f0f1d
Merge pull request #153 from zwischenloesung/master
...
Measurement Data Pond
2025-06-28 02:30:40 +02:00
Michael Lustenberger
2817c21fee
Postgres Basin Working
...
Add the basic functionality, still missing are project/source infos.
2025-06-28 02:26:19 +02:00
Michael Lustenberger
85ce94872b
Postgres Basin Help
...
Add a little help text.
2025-06-28 01:23:08 +02:00
Michael Lustenberger
7452f00fda
Postgres Basin
...
Add a role to create a basic data pond for flexible measurements in a
multiproject environment.
2025-06-28 01:05:50 +02:00
Michael Lustenberger
4a94f84d3e
Postgres Packages
...
Move package logic down to the role level.
2025-06-28 00:41:48 +02:00
Lustenberger Michael
c432c72a2e
Merge pull request #152 from zwischenloesung/master
...
Ansible Upgrade
2025-06-03 01:09:59 +02:00
Michael Lustenberger
89640e695c
Ansible Upgrade
...
Ansible changed behavior how it treats list merging...
2025-06-03 01:05:19 +02:00
Michael Lustenberger
509b3d258a
Rsync Considered Basic
...
Having rsync on most systems will not hurt.
2025-04-28 22:51:52 +02:00
Michael Lustenberger
3811c719e5
'acme.sh': Finish Access Tasks
...
Add tasks to allow for the remote connection between signing and service
hosts.
2025-03-07 18:19:35 +01:00
