public
nobgit
read
NobMail
Based on mailcow: dockerized
Languages
Repository composition by tracked source files.
PHP
49%
JavaScript
35%
HTML
9%
CSS
4%
Shell
2%
Python
1%
Lua
0%
Perl
0%
Ruby
0%
SCSS
0%
Create file
Wiki Documentation
Clone
https://nobgit.com/orgs/nobgit/nobmail.git
ssh://[email protected]:2222/orgs/nobgit/nobmail.git
Trace
data/Dockerfiles/sogo/bootstrap-sogo.sh
Trace helps you understand code history line by line. See who changed each line, when it changed, and which commit introduced it.
Author
Date
Commit
Line
Code
1
#!/bin/bash
3
# Wait for MySQL to warm-up
4
while ! mariadb-admin status --ssl=false --socket=/var/run/mysqld/mysqld.sock -u${DBUSER} -p${DBPASS} --silent; do
5
echo "Waiting for database to come up..."
6
sleep 2
7
done
9
# Wait until port becomes free and send sig
10
until ! nc -z sogo-mailcow 20000;
11
do
12
killall -TERM sogod
13
sleep 3
14
done
16
# Wait for updated schema
17
DBV_NOW=$(mariadb --skip-ssl --socket=/var/run/mysqld/mysqld.sock -u ${DBUSER} -p${DBPASS} ${DBNAME} -e "SELECT version FROM versions WHERE application = 'db_schema';" -BN)
18
DBV_NEW=$(grep -oE '\$db_version = .*;' init_db.inc.php | sed 's/$db_version = //g;s/;//g' | cut -d \" -f2)
19
while [[ "${DBV_NOW}" != "${DBV_NEW}" ]]; do
20
echo "Waiting for schema update..."
21
DBV_NOW=$(mariadb --skip-ssl --socket=/var/run/mysqld/mysqld.sock -u ${DBUSER} -p${DBPASS} ${DBNAME} -e "SELECT version FROM versions WHERE application = 'db_schema';" -BN)
22
DBV_NEW=$(grep -oE '\$db_version = .*;' init_db.inc.php | sed 's/$db_version = //g;s/;//g' | cut -d \" -f2)
23
sleep 5
24
done
25
echo "DB schema is ${DBV_NOW}"
27
if [[ "${MASTER}" =~ ^([yY][eE][sS]|[yY])+$ ]]; then
28
mariadb --skip-ssl --socket=/var/run/mysqld/mysqld.sock -u ${DBUSER} -p${DBPASS} ${DBNAME} -e "DROP TRIGGER IF EXISTS sogo_update_password"
29
fi
31
# cat /dev/urandom seems to hang here occasionally and is not recommended anyway, better use openssl
32
RAND_PASS=$(openssl rand -base64 16 | tr -dc _A-Z-a-z-0-9)
34
# Generate plist header with timezone data
35
mkdir -p /var/lib/sogo/GNUstep/Defaults/
36
cat <<EOF > /var/lib/sogo/GNUstep/Defaults/sogod.plist
37
<?xml version="1.0" encoding="UTF-8"?>
38
<!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml">
39
<plist version="0.9">
40
<dict>
41
<key>OCSAclURL</key>
42
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_acl</string>
43
<key>SOGoIMAPServer</key>
44
<string>imap://${IPV4_NETWORK}.250:143/?TLS=YES&tlsVerifyMode=none</string>
45
<key>SOGoSieveServer</key>
46
<string>sieve://${IPV4_NETWORK}.250:4190/?TLS=YES&tlsVerifyMode=none</string>
47
<key>SOGoSMTPServer</key>
48
<string>smtp://${IPV4_NETWORK}.253:588/?TLS=YES&tlsVerifyMode=none</string>
49
<key>SOGoTrustProxyAuthentication</key>
50
<string>YES</string>
51
<key>SOGoEncryptionKey</key>
52
<string>${RAND_PASS}</string>
53
<key>OCSAdminURL</key>
54
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_admin</string>
55
<key>OCSCacheFolderURL</key>
56
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_cache_folder</string>
57
<key>OCSEMailAlarmsFolderURL</key>
58
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_alarms_folder</string>
59
<key>OCSFolderInfoURL</key>
60
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_folder_info</string>
61
<key>OCSSessionsFolderURL</key>
62
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_sessions_folder</string>
63
<key>OCSStoreURL</key>
64
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_store</string>
65
<key>SOGoProfileURL</key>
66
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/sogo_user_profile</string>
67
<key>SOGoTimeZone</key>
68
<string>${TZ}</string>
69
<key>domains</key>
70
<dict>
71
EOF
73
# Generate multi-domain setup
74
while read -r line gal
75
do
76
echo " <key>${line}</key>
77
<dict>
78
<key>SOGoMailDomain</key>
79
<string>${line}</string>
80
<key>SOGoUserSources</key>
81
<array>
82
<dict>
83
<key>MailFieldNames</key>
84
<array>
85
<string>aliases</string>
86
<string>ad_aliases</string>
87
<string>ext_acl</string>
88
</array>
89
<key>KindFieldName</key>
90
<string>kind</string>
91
<key>DomainFieldName</key>
92
<string>domain</string>
93
<key>MultipleBookingsFieldName</key>
94
<string>multiple_bookings</string>
95
<key>listRequiresDot</key>
96
<string>NO</string>
97
<key>canAuthenticate</key>
98
<string>YES</string>
99
<key>displayName</key>
100
<string>GAL ${line}</string>
101
<key>id</key>
102
<string>${line}</string>
103
<key>isAddressBook</key>
104
<string>${gal}</string>
105
<key>type</key>
106
<string>sql</string>
107
<key>userPasswordAlgorithm</key>
108
<string>${MAILCOW_PASS_SCHEME}</string>
109
<key>prependPasswordScheme</key>
110
<string>YES</string>
111
<key>viewURL</key>
112
<string>mysql://${DBUSER}:${DBPASS}@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/${DBNAME}/_sogo_static_view</string>
113
</dict>" >> /var/lib/sogo/GNUstep/Defaults/sogod.plist
114
# Generate alternative LDAP authentication dict, when SQL authentication fails
115
# This will nevertheless read attributes from LDAP
116
/etc/sogo/plist_ldap.sh ${line} ${gal} >> /var/lib/sogo/GNUstep/Defaults/sogod.plist
117
echo " </array>
118
</dict>" >> /var/lib/sogo/GNUstep/Defaults/sogod.plist
119
done < <(mariadb --skip-ssl --socket=/var/run/mysqld/mysqld.sock -u ${DBUSER} -p${DBPASS} ${DBNAME} -e "SELECT domain, CASE gal WHEN '1' THEN 'YES' ELSE 'NO' END AS gal FROM domain;" -B -N)
121
# Generate footer
122
echo ' </dict>
123
</dict>
124
</plist>' >> /var/lib/sogo/GNUstep/Defaults/sogod.plist
126
# Fix permissions
127
chown sogo:sogo -R /var/lib/sogo/
128
chmod 600 /var/lib/sogo/GNUstep/Defaults/sogod.plist
130
# Patch ACLs
131
#if [[ ${ACL_ANYONE} == 'allow' ]]; then
132
# #enable any or authenticated targets for ACL
133
# if patch -R -sfN --dry-run /usr/local/lib/GNUstep/SOGo/Templates/UIxAclEditor.wox < /acl.diff > /dev/null; then
134
# patch -R /usr/local/lib/GNUstep/SOGo/Templates/UIxAclEditor.wox < /acl.diff;
135
# fi
136
#else
137
# #disable any or authenticated targets for ACL
138
# if patch -sfN --dry-run /usr/local/lib/GNUstep/SOGo/Templates/UIxAclEditor.wox < /acl.diff > /dev/null; then
139
# patch /usr/local/lib/GNUstep/SOGo/Templates/UIxAclEditor.wox < /acl.diff;
140
# fi
141
#fi
143
# Apply custom UI patch (reverse patch to ADD buttons)
144
if patch -R -sfN --dry-run /usr/local/lib/GNUstep/SOGo/Templates/UIxTopnavToolbar.wox < /navMailcowBtns.diff > /dev/null; then
145
echo "Applying navMailcowBtns patch (reverse to add buttons)..."
146
patch -R /usr/local/lib/GNUstep/SOGo/Templates/UIxTopnavToolbar.wox < /navMailcowBtns.diff;
147
else
148
echo "navMailcowBtns patch already applied or cannot be applied"
149
fi
151
# Rename custom logo, if any
152
[[ -f /etc/sogo/sogo-full.svg ]] && mv /etc/sogo/sogo-full.svg /etc/sogo/custom-fulllogo.svg
154
# Rsync web content
155
echo "Syncing web content with named volume"
156
rsync -a /usr/local/lib/GNUstep/SOGo/. /sogo_web/
158
# Chown backup path
159
chown -R sogo:sogo /sogo_backup
161
exec gosu sogo /usr/sbin/sogod