Beide Seiten der vorigen Revision Vorhergehende Überarbeitung | Nächste ÜberarbeitungBeide Seiten der Revision |
centos:mail_c7:dovecot_8 [08.08.2014 18:42. ] – [Thunderbird] Display Quota Plugin django | centos:mail_c7:dovecot_8 [09.08.2014 16:27. ] – [Dovecot Quota] Farben im Beitrag gewechselt django |
---|
| |
Zum Testen, ob unser SQL-Statement das gewünschte Ergebnis liefert, verbinden wir uns von unserem Dovecot-Host aus mit unserer Datenbank. | Zum Testen, ob unser SQL-Statement das gewünschte Ergebnis liefert, verbinden wir uns von unserem Dovecot-Host aus mit unserer Datenbank. |
Die Eingaben am Client sind in der Farbe <html><font style="color: rgb(0, 0, 255)">blau</font></html> und die Rückmeldungen des MySQL-Servers in der Farbe <html><font style="color: rgb(0, 255, 0)">grün</font></html> gekennzeichnet. | Die Eingaben am Client sind in der Farbe <html><font style="color: rgb(0, 0, 255)"><b>blau</b></font></html> und die Rückmeldungen des MySQL-Servers in der Farbe <html><font style="color: rgb(66, 66, 66)"><b>hellgrau</b></font></html> gekennzeichnet. |
| |
<html><pre class="code"> | <html><pre class="code"> |
<font style="color: rgb(0, 0, 0)">$ </font><font style="color: rgb(0, 0, 255)">mysql -h mysql.dmz.nausch.org -D postfix -u dovecot_user -p</font> | <font style="color: rgb(0, 0, 0)">$ </font><font style="color: rgb(0, 0, 255)">mysql -h mysql.dmz.nausch.org -D postfix -u dovecot_user -p</font> |
<font style="color: rgb(0, 255, 0)">Enter password:</font><font style="color: rgb(0, 0, 255)">D45_157_5uP3r57r3n9_g3h31m!</font> | <font style="color: rgb(66, 66, 66)">Enter password:</font><font style="color: rgb(0, 0, 255)">D45_157_5uP3r57r3n9_g3h31m!</font> |
<font style="color: rgb(0, 255, 0)">Reading table information for completion of table and column names | <font style="color: rgb(66, 66, 55)">Reading table information for completion of table and column names |
You can turn off this feature to get a quicker startup with -A | You can turn off this feature to get a quicker startup with -A |
| |
| |
MySQL [postfix]> </font><font style="color: rgb(0, 0, 255)">SELECT CONCAT('/var/spool/mail/vmail/', maildir) AS home, 10000 AS uid, 10000 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = 'django@nausch.org' AND active='1';</font> | MySQL [postfix]> </font><font style="color: rgb(0, 0, 255)">SELECT CONCAT('/var/spool/mail/vmail/', maildir) AS home, 10000 AS uid, 10000 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = 'django@nausch.org' AND active='1';</font> |
<font style="color: rgb(0, 255, 0)">+-------------------------------+-------+-------+--------------------+ | <font style="color: rgb(66, 66, 66)">+-------------------------------+-------+-------+--------------------+ |
| home | uid | gid | quota_rule | | | home | uid | gid | quota_rule | |
+-------------------------------+-------+-------+--------------------+ | +-------------------------------+-------+-------+--------------------+ |
| |
MySQL [postfix]> </font><font style="color: rgb(0, 0, 255)">SELECT username AS user, password, 10000 AS userdb_uid, 10000 AS userdb_gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = 'django@nausch.org' AND active = '1';</font> | MySQL [postfix]> </font><font style="color: rgb(0, 0, 255)">SELECT username AS user, password, 10000 AS userdb_uid, 10000 AS userdb_gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = 'django@nausch.org' AND active = '1';</font> |
<font style="color: rgb(0, 255, 0)">+-------------------+------------------+------------+------------+--------------------+ | <font style="color: rgb(66, 66, 66)">+-------------------+------------------+------------+------------+--------------------+ |
| user | password | userdb_uid | userdb_gid | quota_rule | | | user | password | userdb_uid | userdb_gid | quota_rule | |
+-------------------+------------------+------------+------------+--------------------+ | +-------------------+------------------+------------+------------+--------------------+ |
| |
MySQL [postfix]> </font><font style="color: rgb(0, 0, 255)">quit;</font> | MySQL [postfix]> </font><font style="color: rgb(0, 0, 255)">quit;</font> |
<font style="color: rgb(0, 255, 0)">Bye</font> | <font style="color: rgb(66, 66, 66)">Bye</font> |
</pre></html> | </pre></html> |
| |