]>
git.proxmox.com Git - pmg-api.git/log
Dietmar Maurer [Thu, 27 Apr 2017 09:45:25 +0000 (11:45 +0200)]
spamreport-short.tt: new spamreport template
Dietmar Maurer [Thu, 27 Apr 2017 09:12:25 +0000 (11:12 +0200)]
remove spamreport style outlook
This style is now called 'verbose' and is the default.
Dietmar Maurer [Thu, 27 Apr 2017 09:09:06 +0000 (11:09 +0200)]
spamreport-verbose: new style - do not use forms
Because they do not work in most cases.
Dietmar Maurer [Thu, 27 Apr 2017 07:42:46 +0000 (09:42 +0200)]
pmgspamreport: create quarantine tickets
Dietmar Maurer [Thu, 27 Apr 2017 07:14:02 +0000 (09:14 +0200)]
add newline to errors returned by template toolkit
Dietmar Maurer [Thu, 27 Apr 2017 06:29:55 +0000 (08:29 +0200)]
use extemsion .tt for spamreport templates
tt => Template Toolkit
Dietmar Maurer [Thu, 27 Apr 2017 06:27:43 +0000 (08:27 +0200)]
pmgspamreport: fix error condition
Dietmar Maurer [Thu, 27 Apr 2017 05:52:07 +0000 (07:52 +0200)]
PMG::Cluster::sync_config_from_master - also sync /etc/pmg/templates
Onyl files and symlinks - not recursive.
Dietmar Maurer [Thu, 27 Apr 2017 04:58:28 +0000 (06:58 +0200)]
use one global template toolkit object
The user can now overwrite all templates in /etc/pmg/templates/
Dietmar Maurer [Thu, 27 Apr 2017 04:28:22 +0000 (06:28 +0200)]
pmgspamreport: pass filenames to template toolkit
So that TT correctly cache the template. Also make it possible
to overwrite all templates in /etc/pmg/templates.
Dietmar Maurer [Wed, 26 Apr 2017 16:29:24 +0000 (18:29 +0200)]
spamreport-verbose.tmpl: use button tag to get correct button text.
Dietmar Maurer [Wed, 26 Apr 2017 16:05:02 +0000 (18:05 +0200)]
pmgspamreport: do not escape character in tooltip - does not work with most browsers
Use template toolkit filter for hrefs.
Dietmar Maurer [Wed, 26 Apr 2017 15:30:27 +0000 (17:30 +0200)]
spamreport-verbose.tmpl: s/item.data/item.date/
Dietmar Maurer [Wed, 26 Apr 2017 15:26:48 +0000 (17:26 +0200)]
pmgspamreport/get_item_data() use uri_escape for tooltip (title)
Dietmar Maurer [Wed, 26 Apr 2017 15:12:11 +0000 (17:12 +0200)]
pmgspamreport: use default stype from configuration, add debug option
Dietmar Maurer [Wed, 26 Apr 2017 11:35:09 +0000 (13:35 +0200)]
PMG/Utils.pm: new helper bencode_header()
Dietmar Maurer [Wed, 26 Apr 2017 11:22:54 +0000 (13:22 +0200)]
pmgspamreport: tool to send spam reports per email
Dietmar Maurer [Wed, 26 Apr 2017 06:22:12 +0000 (08:22 +0200)]
pmgpolicy: use PMG::ClusterConfig->new()
Dietmar Maurer [Wed, 26 Apr 2017 06:20:43 +0000 (08:20 +0200)]
pmgpolicy: use new PVE::Tools::get_fqdn()
Dietmar Maurer [Wed, 26 Apr 2017 06:19:47 +0000 (08:19 +0200)]
PMG::DBTools::purge_quarantine_database - return number of removed files
Dietmar Maurer [Wed, 26 Apr 2017 05:40:42 +0000 (07:40 +0200)]
pmgcm: replace $cfg => $cinfo
Dietmar Maurer [Wed, 26 Apr 2017 05:39:25 +0000 (07:39 +0200)]
pmgcm: use PMG::ClusterConfig->new()
Dietmar Maurer [Wed, 26 Apr 2017 04:43:42 +0000 (06:43 +0200)]
PMG/DBTools.pm: new helper purge_quarantine_database()
Dietmar Maurer [Wed, 26 Apr 2017 04:36:19 +0000 (06:36 +0200)]
move cleanup_stats() to PMG::DBTools::purge_statistic_database()
Dietmar Maurer [Tue, 25 Apr 2017 09:06:45 +0000 (11:06 +0200)]
move code to correct cron scripts
run database cleanup and razor logrotate in pmg-daily.
Dietmar Maurer [Tue, 25 Apr 2017 08:59:26 +0000 (10:59 +0200)]
pmg-hourly: rotate razor log file
Dietmar Maurer [Tue, 25 Apr 2017 08:47:50 +0000 (10:47 +0200)]
pmg-hourly: cleanup statistic database
Dietmar Maurer [Tue, 25 Apr 2017 08:46:49 +0000 (10:46 +0200)]
pmg-smtp-filter: corretly run dequeue task all 2 minutes
Dietmar Maurer [Tue, 25 Apr 2017 06:18:23 +0000 (08:18 +0200)]
pmgconfig sync: call rewrite_config with $ruelcache
Dietmar Maurer [Tue, 25 Apr 2017 06:16:49 +0000 (08:16 +0200)]
pmgcm: rewrite config after sync
And rename $cfg to $cinfo
Dietmar Maurer [Tue, 25 Apr 2017 06:14:40 +0000 (08:14 +0200)]
PMG::API2::Cluster - rewrite config after join
And rename $cfg to $cinfo (for ClusterConfig).
Dietmar Maurer [Tue, 25 Apr 2017 06:13:40 +0000 (08:13 +0200)]
pmgmirror: rewrite config after sync from master
Dietmar Maurer [Tue, 25 Apr 2017 06:10:43 +0000 (08:10 +0200)]
PMG::Config::rewrite_config - pass $rulecache and rewrite smtp whitelist
Dietmar Maurer [Tue, 25 Apr 2017 06:09:17 +0000 (08:09 +0200)]
PMG::Cluster::sync_config_from_master - do not call rewrite_config
Dietmar Maurer [Tue, 25 Apr 2017 05:57:10 +0000 (07:57 +0200)]
debend on ${misc:Depends}
Dietmar Maurer [Tue, 25 Apr 2017 04:48:50 +0000 (06:48 +0200)]
PMG::Utils::quote_regex - new helper to quote all regex operators
Dietmar Maurer [Mon, 24 Apr 2017 10:41:11 +0000 (12:41 +0200)]
pmg-smtp-filter: code cleanups
Dietmar Maurer [Mon, 24 Apr 2017 08:32:38 +0000 (10:32 +0200)]
pmg-smtp-filter: fix memory usage test, correctly create spool dirs
Dietmar Maurer [Mon, 24 Apr 2017 07:39:15 +0000 (09:39 +0200)]
ClusterConfig: remove unused dbport
We only use unix sockets, so we do not longer need a port number.
Dietmar Maurer [Mon, 24 Apr 2017 06:55:55 +0000 (08:55 +0200)]
PMG::Cluster::sync_statistic_db - return count
Dietmar Maurer [Mon, 24 Apr 2017 06:41:26 +0000 (08:41 +0200)]
PMG/DBTools.pm: remove unused code
We do not support upgrading from very old versions ...
Dietmar Maurer [Sat, 22 Apr 2017 15:50:43 +0000 (17:50 +0200)]
PMG::Cluster::sync_generic_mtime_db - correctly start/commit transaction
No need to start transaction if there is no data
Dietmar Maurer [Sat, 22 Apr 2017 15:41:53 +0000 (17:41 +0200)]
PMG::DBTools::$cgreylist_merge_sql - use exact column names
Postgres complians without
Dietmar Maurer [Sat, 22 Apr 2017 15:36:44 +0000 (17:36 +0200)]
PMG::Cluster::sync_userprefs_db - fix sql statement
Dietmar Maurer [Sat, 22 Apr 2017 15:15:47 +0000 (17:15 +0200)]
remove plpgsql code
No longer required, because new postgres "ON CONFLICT" can do the same.
Dietmar Maurer [Sat, 22 Apr 2017 14:32:23 +0000 (16:32 +0200)]
PMG::Cluster - simplify code
Dietmar Maurer [Sat, 22 Apr 2017 14:25:57 +0000 (16:25 +0200)]
PMG::Cluster::sync_virusinfo_db - use single sql statement with ON CONFLICT
Dietmar Maurer [Sat, 22 Apr 2017 14:10:34 +0000 (16:10 +0200)]
PMG::Cluster::sync_userprefs_db - fix syntax
Dietmar Maurer [Sat, 22 Apr 2017 14:06:16 +0000 (16:06 +0200)]
PMG::Cluster::sync_dailystat_db - correctly use $merge_sth
Dietmar Maurer [Sat, 22 Apr 2017 14:04:37 +0000 (16:04 +0200)]
PMG::Cluster::sync_userprefs_db - use normal place holders
Only modify values if excluded.MTime >= UserPrefs.MTime
Dietmar Maurer [Sat, 22 Apr 2017 13:56:00 +0000 (15:56 +0200)]
PMG::Cluster::sync_dailystat_db - use singlw sql statement with ON CONFLICT
Dietmar Maurer [Sat, 22 Apr 2017 13:44:35 +0000 (15:44 +0200)]
PMG::Cluster::sync_domainstat_db - use single sql statement with ON CONFLICT
Dietmar Maurer [Sat, 22 Apr 2017 09:53:43 +0000 (11:53 +0200)]
PMG::Cluster::sync_userprefs_db - rename $update_sth to $merge_sth
Dietmar Maurer [Sat, 22 Apr 2017 09:47:20 +0000 (11:47 +0200)]
PMG::Cluster::sync_greylist_db - prepare outside loop
To speedup updates
Dietmar Maurer [Sat, 22 Apr 2017 09:42:39 +0000 (11:42 +0200)]
PMG::Cluster::sync_generic_mtime_db - do not cache data in $data
Dietmar Maurer [Sat, 22 Apr 2017 09:31:17 +0000 (11:31 +0200)]
PMG::Cluster::sync_userprefs_db - prepare outside loop, use ON CONFLICT
Dietmar Maurer [Fri, 21 Apr 2017 09:52:45 +0000 (11:52 +0200)]
PMG::Cluster::sync_deleted_nodes_from_master - fix $cinfo access
Dietmar Maurer [Fri, 21 Apr 2017 09:41:55 +0000 (11:41 +0200)]
pmgmirror: implement dartabase syncronization
Dietmar Maurer [Fri, 21 Apr 2017 09:35:40 +0000 (11:35 +0200)]
PMG::DBTools::copy_selected_data - correctly substitute $table
Dietmar Maurer [Fri, 21 Apr 2017 07:44:04 +0000 (09:44 +0200)]
PMG/MailQueue.pm: fix create_spooldirs
Dietmar Maurer [Fri, 21 Apr 2017 05:36:38 +0000 (07:36 +0200)]
PMG/DBTools.pm: new helper copy_selected_data()
Dietmar Maurer [Thu, 20 Apr 2017 15:17:53 +0000 (17:17 +0200)]
PMG/DBTools.pm: add helpers to manipulate clusterinfo table
Dietmar Maurer [Thu, 20 Apr 2017 07:34:46 +0000 (09:34 +0200)]
PMG::Cluster::sync_master_quar - do not pass $cinfo - not required
Dietmar Maurer [Thu, 20 Apr 2017 05:20:48 +0000 (07:20 +0200)]
PMG/API2/Cluster.pm: on join, sync all quarantine files from master
Dietmar Maurer [Thu, 20 Apr 2017 05:17:29 +0000 (07:17 +0200)]
PMG/Cluster.pm: add rsync helpers to sync quarantine files
Dietmar Maurer [Tue, 18 Apr 2017 09:40:33 +0000 (11:40 +0200)]
PMG/Cluster.pm: implement sync_ruledb_from_master()
Dietmar Maurer [Tue, 18 Apr 2017 09:37:42 +0000 (11:37 +0200)]
PMG/DBTools.pm: new helper copy_table()
Dietmar Maurer [Tue, 18 Apr 2017 09:36:20 +0000 (11:36 +0200)]
PMG/API2/RuleDB.pm: add API to query ruledb digest
To detect ruledb changes.
Dietmar Maurer [Tue, 18 Apr 2017 08:47:47 +0000 (10:47 +0200)]
PMG/RuleCache.pm: fix digest (use correct ordering)
Dietmar Maurer [Fri, 14 Apr 2017 13:08:28 +0000 (15:08 +0200)]
remove msgquote hack - syslog already work correctly
This was a workaround for a syslog bug, fixed long time ago ...
Dietmar Maurer [Fri, 14 Apr 2017 12:49:03 +0000 (14:49 +0200)]
PMG/API2/Cluster.pm: also start/stop pmgmirror on create/join
Dietmar Maurer [Fri, 14 Apr 2017 09:03:58 +0000 (11:03 +0200)]
PMG/Service/pmgmirror.pm: start implementing cluster_sync
Only copy config for now...
Dietmar Maurer [Fri, 14 Apr 2017 08:36:11 +0000 (10:36 +0200)]
debian/postinst: cleanup - use a loop
Dietmar Maurer [Fri, 14 Apr 2017 07:51:02 +0000 (09:51 +0200)]
debian/postinst: restart pmgmirror when triggered
Dietmar Maurer [Fri, 14 Apr 2017 07:48:31 +0000 (09:48 +0200)]
PMG/Service/pmgmirror.pm: restart when we detect increased memory usage
Dietmar Maurer [Fri, 14 Apr 2017 07:21:49 +0000 (09:21 +0200)]
pmgtunnel: cleanup
Dietmar Maurer [Fri, 14 Apr 2017 07:21:20 +0000 (09:21 +0200)]
pmgmirror: add dummy for pmgmirror service
Dietmar Maurer [Fri, 14 Apr 2017 05:28:47 +0000 (07:28 +0200)]
bump version to 5.0-5
Dietmar Maurer [Fri, 14 Apr 2017 05:20:03 +0000 (07:20 +0200)]
templates/postgresql.conf.in: use config from default installation
Dietmar Maurer [Fri, 14 Apr 2017 05:16:16 +0000 (07:16 +0200)]
templates/pg_hba.conf.in; use same config as postgres default installation
Dietmar Maurer [Fri, 14 Apr 2017 04:56:28 +0000 (06:56 +0200)]
PMG/API2/RuleDB.pm: do not use protected for read-only database access
Dietmar Maurer [Fri, 14 Apr 2017 04:55:10 +0000 (06:55 +0200)]
PMG/API2/Rules.pm: proxy delete rule to master
Dietmar Maurer [Fri, 14 Apr 2017 04:53:28 +0000 (06:53 +0200)]
PMG/API2/Action.pm: proxy write to master, set protected flag
Dietmar Maurer [Fri, 14 Apr 2017 04:50:48 +0000 (06:50 +0200)]
PMG/API2/ObjectGroupHelpers.pm: use protected flag for writes
Dietmar Maurer [Fri, 14 Apr 2017 04:34:42 +0000 (06:34 +0200)]
add postgres user www-data with read-only access to tables
Dietmar Maurer [Thu, 13 Apr 2017 15:39:35 +0000 (17:39 +0200)]
debian/control: depend on sudo
This is convenient to run postgres database commands as user postgres.
Dietmar Maurer [Thu, 13 Apr 2017 15:08:52 +0000 (17:08 +0200)]
pmgtunnel: use UPD socket, only root is allowed to access the socket
Dietmar Maurer [Thu, 13 Apr 2017 11:06:05 +0000 (13:06 +0200)]
create and use postgres user 'root' to improve security
Dietmar Maurer [Thu, 13 Apr 2017 05:00:23 +0000 (07:00 +0200)]
PMG/API2/Services.pm: add postgres to service list
Dietmar Maurer [Thu, 13 Apr 2017 04:25:11 +0000 (06:25 +0200)]
PMG/API2/Cluster.pm: add a separate status API
Dietmar Maurer [Wed, 12 Apr 2017 10:21:04 +0000 (12:21 +0200)]
PMG/API2/Cluster.pm: allways convert exceptions object to strings
Else the API result verification fails.
Dietmar Maurer [Wed, 12 Apr 2017 10:20:11 +0000 (12:20 +0200)]
pmgcm: use correct formula to compute disk percentage
Dietmar Maurer [Wed, 12 Apr 2017 08:39:16 +0000 (10:39 +0200)]
API get /config/cluster/nodes: inlude node status from other cluster members
Dietmar Maurer [Wed, 12 Apr 2017 05:44:28 +0000 (07:44 +0200)]
PMG/API2/Nodes.pm: add node status API
Dietmar Maurer [Wed, 12 Apr 2017 05:42:25 +0000 (07:42 +0200)]
PMG::DBTools::cluster_sync_status - new helper
Dietmar Maurer [Wed, 12 Apr 2017 05:08:20 +0000 (07:08 +0200)]
API get /nodes: list all nodes
Dietmar Maurer [Wed, 12 Apr 2017 05:07:31 +0000 (07:07 +0200)]
pmgsh: use new PMG::RESTEnvironment
Dietmar Maurer [Wed, 12 Apr 2017 04:10:15 +0000 (06:10 +0200)]
PMG/API2/Cluster.pm: stop/start pmgtunnel at create/join
Dietmar Maurer [Tue, 11 Apr 2017 15:20:29 +0000 (17:20 +0200)]
PMG::Cluster::sync_config_from_master - try to use HostKeyAlias when possible
Dietmar Maurer [Tue, 11 Apr 2017 15:09:41 +0000 (17:09 +0200)]
PMG/DBTools.pm: use HostKeyAlias for ssh connection