Software /
code /
prosody-modules
File
mod_alias/mod_alias_postfixadmin.sh @ 4789:f06d04cfea7d
mod_muc_restrict_media: Fix disco#info field (thanks mirux)
The default value for 'type' here is 'text-single', which does not
serialize boolean values.
author | Kim Alvefur <zash@zash.se> |
---|---|
date | Wed, 24 Nov 2021 16:28:35 +0100 |
parent | 1953:0c3ba5ff7a3b |
line wrap: on
line source
#!/bin/sh # Copyright (C) 2015 Travis Burtrum # This file is MIT/X11 licensed. # run like ./mod_alias_postfixadmin.sh "mysql -N -upostfixadmin -ppostfixadmin postfixadmin" > /etc/prosody/aliases.cfg.lua # then put: # Include "aliases.cfg.lua" # in prosody.cfg.lua mysql="$1" echo "-- alias plugin, generated by mod_alias_postfixadmin.sh" echo "aliases = {" echo "SELECT concat('["'"'"', address, '"'"'"] = "'"'"', goto, '"'"'";') FROM alias WHERE address != goto; SELECT concat('["'"'"', address, '"'"'"] = "'"'"', goto, '"'"'";') FROM ( select replace(address, concat('@', target_domain), concat('@', alias_domain)) as address, goto FROM alias JOIN alias_domain ON alias_domain.target_domain = SUBSTRING(alias.address, locate('@',alias.address) + 1, length(alias.address)) ) a WHERE a.address != a.goto;" | $mysql | sort | uniq echo "}"