1 <?xml version="1.0" encoding="UTF-8"?>
2 <!DOCTYPE pkgmetadata SYSTEM "http://www.gentoo.org/dtd/metadata.dtd">
4 <maintainer type="person">
5 <email>mjo@gentoo.org</email>
6 <name>Michael Orlitzky</name>
8 <maintainer type="project">
9 <email>haskell@gentoo.org</email>
10 <name>Gentoo Haskell</name>
16 mailbox-count [OPTIONS]
19 Mailbox-count produces a simple count of mailboxes that exist
20 per-domain in some SQL database. The default queries are compatible
21 with the schema used by PostfixAdmin <http://postfixadmin.sourceforge.net/>,
22 but it is possible to supply your own queries via the @--summary-query@
23 and @--detail-query@ options.
25 The summary report lists each domain, along with the number of
26 mailboxes owned by that domain. The order is determined by the summary
27 query, which lists the domains alphabetically by default.
29 The default detail report shows the same, but also contains a list of
30 each individual mailbox (again in alphabetical order) belonging to the
39 Either a summary, or detailed report (with @--detail@) of the
40 number of mailboxes per-domain contained in the database.
48 The name of the database (or file, if SQLite) to which we should
51 Default: The name of the current user (Postgres only).
57 Produce a detailed report listing all mailboxes by domain.
63 SQL query used to produce the detail report. This should return the
64 set of all (domain, username) pairs. See the default value for an
67 Default: \"SELECT domain,username FROM mailbox ORDER BY domain;\"
73 Hostname where the database is located (Postgres-only).
75 Default: None, a UNIX domain socket connection is attempted (Postgres only)
81 Password used to connect to the database (Postgres-only).
83 Default: None (assumes passwordless authentication)
88 Port number used to connect to the database (Postgres-only).
90 Default: None, a UNIX domain socket connection is attempted (Postgres only)
96 SQL query used to produce the summary report. This should return
97 (domain, user count) pairs. See the default value for an
100 Default: \"SELECT domain,COUNT(username) FROM mailbox GROUP BY domain
107 Username used to connect to the database (Postgres-only).
109 Default: The current user
113 The default summary report:
116 $ mailbox-count --database=postfixadmin.sqlite3
117 Summary (number of mailboxes per domain)
118 \----------------------------------------
125 The more detailed report:
128 $ mailbox-count --detail --database=postfixadmin.sqlite3
129 Detail (list of all mailboxes by domain)
130 \----------------------------------------