Commit Graph

63 Commits

Author SHA1 Message Date
3349ea882d kind of working 2025-04-11 11:06:01 +02:00
0b7f362c80 install/create.sql fix errors 2025-03-26 11:26:26 +01:00
www-data
ab8952feea Merge remote-tracking branch 'calcms/master'
492bc44 (calcms/master) lib/calcms/user_sessions.pm: always write session
80cbaf7 fixup! templates: fix javascript escaping
4689dee notify-events: show results
b7ff85f create-events.cgi: remove comments
0c7cf10 website/agenda/.htaccess: add route for running id
61405a2 install/create.sql: new index for events
6744123 calcms.css: use woff2 fonts only
f71d6e9 mail.pm: convert to ascii
642e739 fixup! lib/calcms: remove comments and shorten expressions
2024-07-28 23:46:59 +02:00
Milan
61405a2644 install/create.sql: new index for events 2024-07-26 21:33:49 +02:00
Milan
f71d6e9030 mail.pm: convert to ascii
use Text::Unidecode to decode unicode, to prevent spam filter ignoring
oddly encoded emails.
2024-07-26 21:33:48 +02:00
haffael
35c697a825 Merge branch 'rapilodev:master' into master 2024-05-23 11:46:01 +02:00
Milan
ea952a8021 studio-timeslot: add week in month 2024-04-21 00:14:03 +02:00
www-data
9e0ea0e09d fixup! apache config 2024-03-20 00:34:50 +01:00
www-data
f5611bacdd Merge remote-tracking branch 'calcms/master'
295faea lib/calcms/startup.pl: get include path from startup.pl directory
bd869a5 install/migrate.sql: remove paths from image entries
b01dd91 fixup! audio-recordings.cgi: set permissions to update event
220f9c9 apache2-sites/calcms.conf: add /images
976355e fixup! create.sql, migrate.sql: limit username length to 100
2024-03-20 00:31:40 +01:00
Milan
bd869a5c91 install/migrate.sql: remove paths from image entries 2024-03-20 00:07:40 +01:00
Milan
220f9c974d apache2-sites/calcms.conf: add /images 2024-03-20 00:04:35 +01:00
Milan
976355e901 fixup! create.sql, migrate.sql: limit username length to 100 2024-03-17 20:45:54 +01:00
www-data
9f834fd4f0 Merge remote-tracking branch 'calcms/master'
* INSTALL.md: add sox to calculate audio duration
* db.pm: output call stack on error
* audio-recordings.cgi: set permissions to update event
2024-02-17 20:59:57 +01:00
Milan
d56174f8d0 INSTALL.md: add sox to calculate audio duration 2024-02-17 20:57:39 +01:00
www-data
a45f2ab241 Merge remote-tracking branch 'calcms/master' 2024-02-01 21:53:40 +01:00
Milan
9bd5e6df60 add libauthen-sasl-perl
Email::Simple requires libauthen-sasl-perl for SMTP support.
2023-10-23 21:38:11 +02:00
Milan
f52f57e0d5 Merge remote-tracking branch 'calcms/master' 2023-09-23 09:31:59 +02:00
Milan
a1ca1daeb2 create.sql, migrate.sql: limit username length to 100 2023-09-23 09:23:48 +02:00
Milan
6f8f1a3f8b Merge remote-tracking branch 'calcms/master' 2023-09-23 01:05:15 +02:00
Milan
c95e3ac926 fixup! mail.pm: encode UTF-8 header 2023-05-31 20:26:35 +02:00
www-data
c1877ff18e Merge https://github.com/rapilodev/racalmas 2023-05-23 15:01:55 +00:00
Milan
3effdd6ef0 mail.pm: replace MIME::Lite by Email::Sender
* mail.pm uses Email:sender to use correct encoding on sending utf-8
encoded emails
* notify-events.cgi now uses mail.pm.
2023-04-23 12:15:18 +02:00
Milan
5295dfd173 apache config
adopt directories to following structure

/aganda
/programm
/media
/media/thumbs
/media/icons
/media/images
/media/internal
/media/internal/thumbs
/media/internal/images
/meida/internal/icons
/thumbs -> /media/thumbs
/icons  -> /media/icons
2023-03-28 21:12:59 +02:00
Milan
1709694d8e studios: remove google_calendar field 2023-03-22 00:09:26 +01:00
Milan
2c0bf5887b uac.pm: add admin permission
admin permission is no more dependent on the name
of the role, but can be assigned to any role.
Users assigned to admin role have all permissions.
2023-03-22 00:07:11 +01:00
Milan
4366922d76 fixup! category: remove 2023-03-21 21:56:33 +01:00
Milan
979377c31d help-texts: add
users with permission edit_help_texts are allowed to select edit help
texts from menu and enter texts for all event fields. Other users will
see help texts as tooltips. This allows to provide help to users
depending on your workflow. help texts are saved by project and studio.
2023-03-21 15:16:10 +01:00
Milan
f4c69f6191 drop unused column user_series.active 2023-03-20 05:42:41 +01:00
Milan
03c21de220 install/INSTALL.md: add some installation hints 2023-02-24 22:08:58 +01:00
Milan
f1618c2ddb apache2-sites/calcms.conf: add
move apache config to separate file
2023-02-24 22:08:58 +01:00
Milan
67df87cbbb apache2-sites/calcms.conf: add configuration 2023-02-24 22:05:31 +01:00
JohannesKuhfuss
9d42bf9016 scripted DB and user creation 2023-02-20 19:39:40 +01:00
Milan
b84ce1f60a create.sql: fresh update with some basic entries
A fresh basic database export with mysql8.
This comes with a basic setup containing a
project, a studio, a series, roles, time assignments.
2023-02-19 23:13:38 +01:00
Milan
885921c9b0 INSTALL.md: hint to connect to local mysql database 2023-02-19 23:13:02 +01:00
Milan
d3adec275b INSTALL.md: remove CPAN install hint for mod_perl 2023-02-19 17:56:52 +01:00
Milan
553f2cb72c INSTALL.md: hint to reset admin account
after update from legacy crypto to Blowfish an update is needed.
User still can let send them a link to change the password.
2023-02-19 17:54:01 +01:00
Milan
855b103e99 INSTALL.md: enable apache2 prefork mode 2023-02-18 23:36:15 +01:00
Milan
abd7815e1a install/INSTALL.md: add some missing packages
found with Ubuntu 20.04
2023-02-18 23:32:06 +01:00
JohannesKuhfuss
d050fc2826 added init script for DB and user creation. 2023-02-18 23:26:02 +01:00
johannes-kuhfuss
2c3e64b2a2 Update INSTALL.md
Adjusted GRANT statements
2023-02-18 23:26:02 +01:00
Johannes Kuhfuss
9d93791cfe fix some insert statements in create.sql (JKU, 2023-02-15) 2023-02-18 23:26:02 +01:00
Milan
873d546e13 category: remove
as not used for a long time by now
2021-04-11 13:13:00 +02:00
Milan
15708d951b calendar.js: save selected day start time
set the day start time to the last selecved value for each studio
the user is assigned to.
2021-04-11 13:10:42 +02:00
Milan
7ffc6914b9 audio-recordings.cgi: set upload status
on uploading and audio processing the status is updated
2021-04-11 13:10:42 +02:00
Milan
ef84ca07a3 copying events: save user selection
On copying events from another studio selection will be saved.
The next time one wants to copy saved presets are preselected.
This simplifies to frequently rebroadcast shows from another project.
2021-04-11 13:10:42 +02:00
Milan
fb5ad9efe9 calendar.cgi: remove undef warnings 2021-04-11 13:10:42 +02:00
Milan
5dbe801a11 install/create.sql: full schema dump
remove delta migrate.sql
2021-04-11 13:10:42 +02:00
Milan
e3c3991db6 audio_recordings.pm: active audio uploads
If audio files become inactive because a new file is uploaded, the new
file is marked as active and the old file is marked as not active.
This allows fastly querying events and their active upload file.
Before this change all event's audio files were found and needed to be
filtered afterwards to get a set of unique events.
2021-04-11 13:10:41 +02:00
Milan
25620ab1f5 listen to records
After the end of a show, the audio recordings are uploaded to a
directory "listen_dir" under a secret name, beginning with the
transmission date "yyyy-mm-dd hh_mm". The directory is available as URL
"listen_url", but must not be listable.  In order to gain access to the
recording for 7 days after the show, a check is done to determine
whether the file is available. A random key for the show is stored in
the database if a file matching the date is found in listen_dir.  With
this key as a name, a symbolic link to the original audio file is
created.  The random name can be used in public documents.  If the show
data is read again, the key will be retrieved from the database. File
access can be restricted by the Apache2 handler ListenerAccess.pm. With
it, access to the public symlink is possible for one week.
2020-11-15 20:29:17 +01:00
Milan
2a8906b598 update documentation
update configuration using variables
use markdown
2020-11-15 20:29:16 +01:00