# kill 15
# bash iRedMail.sh
. . .
[ INFO ] Total time of ports compiling: 0 seconds, ~= 0 minute(s)
< SKIP > Function: post_install_cleanup.

********************************************************************
* Start iRedMail Configurations
********************************************************************
< SKIP > Function: generate_ssl_keys.
[ INFO ] Create required system accounts.
< SKIP > Function: add_user_vmail.
< SKIP > Function: add_user_mlmmj.
< SKIP > Function: add_user_iredadmin.
< SKIP > Function: add_user_iredapd.
[ INFO ] Configure PostgreSQL database server.
< SKIP > Function: pgsql_initialize.


# = = = = = = = = = = .runtime/install.log
[ INFO ] Total time of ports compiling: 0 seconds, ~= 0 minute(s)
< SKIP > Function: post_install_cleanup.
< SKIP > Function: generate_ssl_keys.
[ INFO ] Create required system accounts.
< SKIP > Function: add_user_vmail.
< SKIP > Function: add_user_mlmmj.
< SKIP > Function: add_user_iredadmin.
< SKIP > Function: add_user_iredapd.
[ INFO ] Configure PostgreSQL database server.
< SKIP > Function: pgsql_initialize.
 + < DEBUG > Generate sample SQL templates.
 + < DEBUG > Create roles (vmail, vmailadmin) and database: vmail.
psql:/var/db/postgres/data12/init_vmail_db.sql:2: ERROR:  role "vmail" already exists
psql:/var/db/postgres/data12/init_vmail_db.sql:5: ERROR:  role "vmailadmin" already exists
psql:/var/db/postgres/data12/init_vmail_db.sql:8: ERROR:  database "vmail" already exists
ALTER DATABASE
 + < DEBUG > Create tables in vmail database.


# = = = = = = = = = = ./runtime/install.status
Nothing new!


# = = = = = = = = = = /var/log/messages
Oct  9 20:51:25 server postgres[11878]: [6-1] 2020-10-09 20:51:25.088 AEDT [11878] ERROR:  role "vmail" already exists
Oct  9 20:51:25 server postgres[11878]: [6-2] 2020-10-09 20:51:25.088 AEDT [11878] STATEMENT:  CREATE USER vmail WITH ENCRYPTED PA
SSWORD '' NOSUPERUSER NOCREATEDB NOCREATEROLE;
Oct  9 20:51:25 server postgres[11878]: [7-1] 2020-10-09 20:51:25.090 AEDT [11878] ERROR:  role "vmailadmin" already exists
Oct  9 20:51:25 server postgres[11878]: [7-2] 2020-10-09 20:51:25.090 AEDT [11878] STATEMENT:  CREATE USER vmailadmin WITH ENCRYPT
ED PASSWORD '' NOSUPERUSER NOCREATEDB NOCREATEROLE;
Oct  9 20:51:25 server postgres[11878]: [8-1] 2020-10-09 20:51:25.092 AEDT [11878] ERROR:  database "vmail" already exists
Oct  9 20:51:25 server postgres[11878]: [8-2] 2020-10-09 20:51:25.092 AEDT [11878] STATEMENT:  CREATE DATABASE vmail WITH TEMPLATE
 template0 ENCODING 'UTF8';
Oct  9 20:52:25 server postgres[12845]: [6-1] 2020-10-09 20:52:25.151 AEDT [12845] FATAL:  canceling authentication due to timeout

# = = = = = = = = = =
# bash -xv iRedMail.sh
+ echo 'export status_add_user_iredapd="DONE"'
+ '[' X == XYES ']'
check_status_before_run backend_install
+ check_status_before_run backend_install
+ function_name=backend_install
+ function_status_name=status_backend_install
++ eval echo '$status_backend_install'
+++ echo
+ function_status_value=
+ '[' X == XDONE ']'
+ backend_install
+ '[' XPGSQL == XOPENLDAP -o XPGSQL == XMYSQL ']'
+ '[' XPGSQL == XPGSQL ']'
+ export SQL_SERVER_ADDRESS=127.0.0.1
+ SQL_SERVER_ADDRESS=127.0.0.1
+ export SQL_SERVER_PORT=5432
+ SQL_SERVER_PORT=5432
+ export SQL_ROOT_USER=postgres
+ SQL_ROOT_USER=postgres
+ export SQL_ROOT_PASSWD=pass
+ SQL_ROOT_PASSWD=pass
+ SQL_SERVER_ADDRESS_IS_IPV6=NO
+ echo 127.0.0.1
+ grep :
+ '[' XFREEBSD == XFREEBSD ']'
+ '[' '!' -f /usr/local/etc/dovecot/dovecot.conf ']'
+ cp -rf /usr/local/etc/dovecot/example-config/dovecot.conf /usr/local/etc/dovecot/example-config/conf.d /usr/local/etc/dovecot/
+ rm -f /usr/local/etc/dovecot/conf.d/10-ssl.conf
++ generate_password_hash BCRYPT pass
++ _scheme=BCRYPT
++ _password=pass
++ '[' XBCRYPT == XBCRYPT ']'
++ _scheme=BLF-CRYPT
++ doveadm pw -s BLF-CRYPT -p pass
+ export 'DOMAIN_ADMIN_PASSWD_HASH={BLF-CRYPT}$2y$05$GMh5A8gfn10H1V66F2iES.g6Fw0y9apzBflR5/pdXy4ADDqj30pdG'
+ DOMAIN_ADMIN_PASSWD_HASH='{BLF-CRYPT}$2y$05$GMh5A8gfn10H1V66F2iES.g6Fw0y9apzBflR5/pdXy4ADDqj30pdG'
+ '[' XPGSQL == XOPENLDAP ']'
+ '[' XPGSQL == XMYSQL ']'
+ '[' XPGSQL == XPGSQL ']'
+ check_status_before_run pgsql_setup
+ function_name=pgsql_setup
+ function_status_name=status_pgsql_setup
++ eval echo '$status_pgsql_setup'
+++ echo
+ function_status_value=
+ '[' X == XDONE ']'
+ pgsql_setup
+ ECHO_INFO 'Configure PostgreSQL database server.'
+ '[' 'XConfigure PostgreSQL database server.' == X-n ']'
+ echo -e '[ INFO ] Configure PostgreSQL database server.'
[ INFO ] Configure PostgreSQL database server.
+ echo -e '[ INFO ] Configure PostgreSQL database server.'
+ check_status_before_run pgsql_initialize
+ function_name=pgsql_initialize
+ function_status_name=status_pgsql_initialize
++ eval echo '$status_pgsql_initialize'
+++ echo
+ function_status_value=
+ '[' X == XDONE ']'
+ pgsql_initialize
+ ECHO_DEBUG 'Initialize PostgreSQL databases.'
+ echo -e ' + < DEBUG > Initialize PostgreSQL databases.'
+ '[' XFREEBSD == XRHEL ']'
+ '[' XFREEBSD == XFREEBSD ']'
+ service_control enable postgresql_enable YES
+ action=enable
+ shift 1
+ service=postgresql_enable
+ services='postgresql_enable YES'
+ '[' XFREEBSD == XLINUX ']'
+ '[' XFREEBSD == XFREEBSD ']'
+ '[' Xenable == Xenable ']'
+ '[' X2 == X2 ']'
+ /usr/sbin/sysrc -f /etc/rc.conf.local postgresql_enable=YES
+ /usr/local/etc/rc.d/postgresql initdb
+ backup_file /var/db/postgres/data12/pg_hba.conf /var/db/postgres/data12/postgresql.conf
+ '[' X2 '!=' X0 ']'
+ for f in $@
+ '[' -f /var/db/postgres/data12/pg_hba.conf ']'
+ '[' XNO == XYES ']'
+ cp -f /var/db/postgres/data12/pg_hba.conf /var/db/postgres/data12/pg_hba.conf.2020.10.10.20.33.27
+ for f in $@
+ '[' -f /var/db/postgres/data12/postgresql.conf ']'
+ '[' XNO == XYES ']'
+ cp -f /var/db/postgres/data12/postgresql.conf /var/db/postgres/data12/postgresql.conf.2020.10.10.20.33.27
+ '[' -f /var/db/postgres/data12/postgresql.conf ']'
+ ECHO_DEBUG 'Make sure PostgreSQL binds to local address: 127.0.0.1.'
+ echo -e ' + < DEBUG > Make sure PostgreSQL binds to local address: 127.0.0.1.'
+ perl -pi -e 's#.*(listen_addresses.=.)(.).*#${1}${2}$ENV{LOCAL_ADDRESS}${2}#' /var/db/postgres/data12/postgresql.conf
+ ECHO_DEBUG 'Set client_min_messages to ERROR.'
+ echo -e ' + < DEBUG > Set client_min_messages to ERROR.'
+ perl -pi -e 's#.*(client_min_messages =).*#${1} error#' /var/db/postgres/data12/postgresql.conf
+ '[' XFREEBSD == XFREEBSD ']'
+ perl -pi -e 's/^#(ssl.=.)off(.*)/${1}on${2}/' /var/db/postgres/data12/postgresql.conf
+ ECHO_DEBUG 'Copy iRedMail SSL cert/key with strict permission.'
+ echo -e ' + < DEBUG > Copy iRedMail SSL cert/key with strict permission.'
+ backup_file /var/db/postgres/data12/server.crt /var/db/postgres/data12/server.key
+ '[' X2 '!=' X0 ']'
+ for f in $@
+ '[' -f /var/db/postgres/data12/server.crt ']'
+ for f in $@
+ '[' -f /var/db/postgres/data12/server.key ']'
+ rm -f /var/db/postgres/data12/server.crt /var/db/postgres/data12/server.key
+ cp -f /etc/ssl/certs/iRedMail.crt /etc/ssl/certs/iRedMail_CA_PostgreSQL.pem
+ cp -f /etc/ssl/private/iRedMail.key /etc/ssl/private/iRedMail_PostgreSQL.key
+ chown postgres:postgres /etc/ssl/certs/iRedMail_CA_PostgreSQL.pem /etc/ssl/private/iRedMail_PostgreSQL.key
+ chmod 0600 /etc/ssl/certs/iRedMail_CA_PostgreSQL.pem /etc/ssl/private/iRedMail_PostgreSQL.key
+ ln -s /etc/ssl/certs/iRedMail_CA_PostgreSQL.pem /var/db/postgres/data12/server.crt
+ ln -s /etc/ssl/private/iRedMail_PostgreSQL.key /var/db/postgres/data12/server.key
+ ECHO_DEBUG 'Start PostgreSQL server and sleep 5 seconds for initialization'
+ echo -e ' + < DEBUG > Start PostgreSQL server and sleep 5 seconds for initialization'
+ service_control stop postgresql
+ sleep 5
+ service_control start postgresql
+ sleep 5
+ ECHO_DEBUG 'Setting password for PostgreSQL admin: (postgres).'
+ echo -e ' + < DEBUG > Setting password for PostgreSQL admin: (postgres).'
+ su - postgres -c 'psql -d template1'
+ ECHO_DEBUG 'Update pg_hba.conf to force local users to authenticate with md5.'
+ echo -e ' + < DEBUG > Update pg_hba.conf to force local users to authenticate with md5.'
+ perl -pi -e 's/^(local.*)/#${1}/g' /var/db/postgres/data12/pg_hba.conf
+ perl -pi -e 's/^(host.*)/#${1}/g' /var/db/postgres/data12/pg_hba.conf
+ '[' X12 == X8 ']'
+ echo 'local all     postgres   peer'
+ echo 'local all     all                 md5'
+ echo 'host  all     all     0.0.0.0/0   md5'
+ ECHO_DEBUG 'Restart PostgreSQL server and sleeping for 5 seconds.'
+ echo -e ' + < DEBUG > Restart PostgreSQL server and sleeping for 5 seconds.'
+ service_control stop postgresql
+ sleep 5
+ service_control start postgresql
+ sleep 5
+ ECHO_DEBUG 'Generate /var/db/postgres/.pgpass.'
+ echo -e ' + < DEBUG > Generate /var/db/postgres/.pgpass.'
+ cat
+ chown postgres:postgres /var/db/postgres/.pgpass
+ chmod 0600 /var/db/postgres/.pgpass
+ cat
+ echo 'export status_pgsql_initialize="DONE"'
+ check_status_before_run pgsql_import_vmail_users
+ function_name=pgsql_import_vmail_users
+ function_status_name=status_pgsql_import_vmail_users
++ eval echo '$status_pgsql_import_vmail_users'
+++ echo
+ function_status_value=
+ '[' X == XDONE ']'
+ pgsql_import_vmail_users
+ ECHO_DEBUG 'Generate sample SQL templates.'
+ echo -e ' + < DEBUG > Generate sample SQL templates.'
+ cp -f /root/iRedMail-1.3.1/samples/postgresql/sql/init_vmail_db.sql /var/db/postgres/data12/
+ cp -f /root/iRedMail-1.3.1/samples/iredmail/iredmail.pgsql /var/db/postgres/data12/iredmail.sql
+ cp -f /root/iRedMail-1.3.1/samples/postgresql/sql/add_first_domain_and_user.sql /var/db/postgres/data12/
+ cp -f /root/iRedMail-1.3.1/samples/postgresql/sql/grant_permissions.sql /var/db/postgres/data12/
+ perl -pi -e 's#PH_VMAIL_DB_NAME#$ENV{VMAIL_DB_NAME}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_VMAIL_DB_BIND_USER#$ENV{VMAIL_DB_BIND_USER}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_VMAIL_DB_BIND_PASSWD#$ENV{VMAIL_DB_BIND_PASSWD}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_VMAIL_DB_ADMIN_USER#$ENV{VMAIL_DB_ADMIN_USER}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_VMAIL_DB_ADMIN_PASSWD#$ENV{VMAIL_DB_ADMIN_PASSWD}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_DOMAIN_ADMIN_EMAIL#$ENV{DOMAIN_ADMIN_EMAIL}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_FIRST_DOMAIN#$ENV{FIRST_DOMAIN}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_TRANSPORT#$ENV{TRANSPORT}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_DOMAIN_ADMIN_PASSWD_HASH#$ENV{DOMAIN_ADMIN_PASSWD_HASH}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_DOMAIN_ADMIN_MAILDIR_HASH_PART#$ENV{DOMAIN_ADMIN_MAILDIR_HASH_PART}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#PH_DOMAIN_ADMIN_NAME#$ENV{DOMAIN_ADMIN_NAME}#g' /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ '[' X12 == X8 ']'
+ perl -pi -e 's#^-- \\c#\\c#g' /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#(.*storagebasedirectory.*DEFAULT..)(.*)#${1}$ENV{STORAGE_BASE_DIR}${2}#' /var/db/postgres/data12/iredmail.sql
+ perl -pi -e 's#(.*storagenode.*DEFAULT..)(.*)#${1}$ENV{STORAGE_NODE}${2}#' /var/db/postgres/data12/iredmail.sql
+ chmod 0755 /var/db/postgres/data12/add_first_domain_and_user.sql /var/db/postgres/data12/grant_permissions.sql /var/db/postgres/data12/init_vmail_db.sql /var/db/postgres/data12/iredmail.sql
+ ECHO_DEBUG 'Create roles (vmail, vmailadmin) and database: vmail.'
+ echo -e ' + < DEBUG > Create roles (vmail, vmailadmin) and database: vmail.'
+ su - postgres -c 'psql -d template1 -f /var/db/postgres/data12/init_vmail_db.sql'
+ ECHO_DEBUG 'Create tables in vmail database.'
+ echo -e ' + < DEBUG > Create tables in vmail database.'
+ su - postgres -c 'psql -d template1 -f /var/db/postgres/data12/iredmail.sql'
(( Hangs Here ))

# = = = = = = = = = =
# ./runtime/install.log
creating directory /var/db/postgres/data12 ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Australia/Victoria
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /usr/local/bin/pg_ctl -D /var/db/postgres/data12 -l logfile start

 + < DEBUG > Make sure PostgreSQL binds to local address: 127.0.0.1.
 + < DEBUG > Set client_min_messages to ERROR.
 + < DEBUG > Copy iRedMail SSL cert/key with strict permission.
 + < DEBUG > Start PostgreSQL server and sleep 5 seconds for initialization
+ action=stop
+ shift 1
+ service=postgresql
+ services=postgresql
+ '[' XFREEBSD == XLINUX ']'
+ '[' XFREEBSD == XFREEBSD ']'
+ '[' Xstop == Xenable ']'
+ '[' Xstop == Xdisable ']'
+ /usr/local/etc/rc.d/postgresql stop
pg_ctl: PID file "/var/db/postgres/data12/postmaster.pid" does not exist
Is server running?
+ action=start
+ shift 1
+ service=postgresql
+ services=postgresql
+ '[' XFREEBSD == XLINUX ']'
+ '[' XFREEBSD == XFREEBSD ']'
+ '[' Xstart == Xenable ']'
+ '[' Xstart == Xdisable ']'
+ /usr/local/etc/rc.d/postgresql start
 + < DEBUG > Setting password for PostgreSQL admin: (postgres).
ALTER ROLE
 + < DEBUG > Update pg_hba.conf to force local users to authenticate with md5.
 + < DEBUG > Restart PostgreSQL server and sleeping for 5 seconds.
+ action=stop
+ shift 1
+ service=postgresql
+ services=postgresql
+ '[' XFREEBSD == XLINUX ']'
+ '[' XFREEBSD == XFREEBSD ']'
+ '[' Xstop == Xenable ']'
+ '[' Xstop == Xdisable ']'
+ /usr/local/etc/rc.d/postgresql stop
+ action=start
+ shift 1
+ service=postgresql
+ services=postgresql
+ '[' XFREEBSD == XLINUX ']'
+ '[' XFREEBSD == XFREEBSD ']'
+ '[' Xstart == Xenable ']'
+ '[' Xstart == Xdisable ']'
+ /usr/local/etc/rc.d/postgresql start
 + < DEBUG > Generate /var/db/postgres/.pgpass.
 + < DEBUG > Generate sample SQL templates.
 + < DEBUG > Create roles (vmail, vmailadmin) and database: vmail.
CREATE ROLE
CREATE ROLE
CREATE DATABASE
ALTER DATABASE
 + < DEBUG > Create tables in vmail database.
(( Hangs Here ))

# = = = = = = = = = =
# ./runtime/install.status
export status_install_port_www_webpy='processing'
export status_install_port_www_webpy='DONE'  # 3 seconds, ~= 0 minute(s).
export status_install_port_devel_pysimplejson='processing'
export status_install_port_devel_pysimplejson='DONE'  # 5 seconds, ~= 0 minute(s).
export status_install_port_security_pyfail2ban='processing'
export status_install_port_security_pyfail2ban='DONE'  # 26 seconds, ~= 0 minute(s).
export status_install_port_sysutils_logwatch='processing'
export status_install_port_sysutils_logwatch='DONE'  # 2 seconds, ~= 0 minute(s).
export status_post_install_cleanup='DONE'
export status_generate_ssl_keys="DONE"
export status_add_user_vmail="DONE"
export status_add_user_mlmmj="DONE"
export status_add_user_iredadmin="DONE"
export status_add_user_iredapd="DONE"
export status_pgsql_initialize="DONE"
(( Hangs Here ))

# = = = = = = = = = =
# /var/log/messages
Oct 11 00:10:19 server pkg-static[20874]: roundcube-php74-1.4.9,1 installed
Oct 11 00:10:44 server pkg-static[25634]: py38-psycopg2-2.8.6 installed
Oct 11 00:11:30 server pkg-static[27311]: py38-sqlite3-3.8.6_7 installed
Oct 11 00:11:32 server pkg-static[27438]: py38-sqlalchemy10-1.0.14 installed
Oct 11 00:12:31 server pkg-static[29214]: py38-cython-0.29.15 installed
Oct 11 00:12:49 server pkg-static[29878]: py38-pycryptodome-3.9.8 installed
Oct 11 00:12:50 server pkg-static[30019]: py38-dnspython-1.16.0 installed
Oct 11 00:12:54 server pkg-static[31354]: py38-webpy-0.61 installed
Oct 11 00:12:59 server pkg-static[32450]: py38-simplejson-3.17.2 installed
Oct 11 00:13:22 server pkg-static[36994]: libinotify-20180201_2 installed
Oct 11 00:13:24 server pkg-static[37187]: py38-pyinotify-0.9.6 installed
Oct 11 00:13:25 server pkg-static[37351]: py38-fail2ban-0.11.1_1 installed
Oct 11 00:13:28 server pkg-static[38803]: logwatch-7.5.1 installed
Oct 11 00:15:24 server postgres[39236]: [6-1] 2020-10-11 00:15:24.733 AEDT [39236] FATAL:  canceling authentication due to timeout
(( Hangs Here ))

# = = = = = = = = = =
# top
last pid: 41181;  load averages:  0.60,  0.54,  0.46    up 0+13:51:22  10:19:57
53 processes:  1 running, 50 sleeping, 2 stopped
CPU: 18.7% user,  0.0% nice,  3.8% system,  0.1% interrupt, 77.4% idle
Mem: 10M Active, 2499M Inact, 1648K Laundry, 901M Wired, 395M Buf, 776M Free
Swap: 4096M Total, 4096M Free

  PID USERNAME    THR PRI NICE   SIZE    RES STATE    TIME    WCPU COMMAND
  735 sysadmin      1  20    0    20M  8464K select   1:26   0.00% sshd
  643 ntpd          1  20    0    16M    16M select   0:03   0.00% ntpd
39197 postgres      1  20    0   172M    31M select   0:01   0.00% postgres
  812 root          1  52    0    15M  6468K wait     0:01   0.00% bash
39203 postgres      1  20    0    30M    21M select   0:00   0.00% postgres
39200 postgres      1  20    0   172M    31M select   0:00   0.00% postgres
39202 postgres      1  20    0   173M    32M select   0:00   0.00% postgres
39201 postgres      1  20    0   172M    31M select   0:00   0.00% postgres
  676 root          1  20    0    11M  2784K nanslp   0:00   0.00% cron
  471 root          1  20    0    11M  2656K select   0:00   0.00% syslogd
39199 postgres      1  20    0   172M    32M select   0:00   0.00% postgres
39204 postgres      1  20    0   173M    32M select   0:00   0.00% postgres

# = = = = = = = = = =
# ps aux
USER       PID  %CPU %MEM    VSZ   RSS TT  STAT STARTED      TIME COMMAND
root        11 100.0  0.0      0    16  -  RNL  20:28   644:26.80 [idle]
root         0   0.0  0.0      0   240  -  DLs  20:28     3:54.86 [kernel]
root         1   0.0  0.0   9960   656  -  ILs  20:28     0:00.01 /sbin/init --
root         2   0.0  0.0      0    16  -  DL   20:28     0:00.00 [crypto]
root         3   0.0  0.0      0    16  -  DL   20:28     0:00.00 [crypto returns 0]
root        18   0.0  0.0      0    48  -  DL   20:28     0:04.56 [pagedaemon]
root        19   0.0  0.0      0    16  -  DL   20:28     0:00.00 [vmdaemon]
root        20   0.0  0.0      0    64  -  DL   20:28     0:40.38 [bufdaemon]
root        21   0.0  0.0      0    16  -  DL   20:28     0:00.59 [vnlru]
root        22   0.0  0.0      0    16  -  DL   20:28     0:46.72 [syncer]
root       400   0.0  0.0  10456   960  -  Is   20:28     0:00.02 /sbin/devd
root       471   0.0  0.1  11400  2656  -  Is   20:28     0:00.12 /usr/sbin/syslogd -s
root       676   0.0  0.1  11400  2784  -  Is   20:28     0:00.19 /usr/sbin/cron -s
postgres 39197   0.0  0.8 176356 32168  -  Ss   00:14     0:00.70 /usr/local/bin/postgres -D /var/db/postgres/data12
postgres 39199   0.0  0.8 176388 32444  -  Is   00:14     0:00.03 postgres: checkpointer    (postgres)
postgres 39200   0.0  0.8 176356 32168  -  Ss   00:14     0:00.31 postgres: background writer    (postgres)
postgres 39201   0.0  0.8 176356 32168  -  Ss   00:14     0:00.28 postgres: walwriter    (postgres)
postgres 39202   0.0  0.8 176868 32472  -  Ss   00:14     0:00.30 postgres: autovacuum launcher    (postgres)
postgres 39203   0.0  0.5  30780 21168  -  Ss   00:14     0:00.43 postgres: stats collector    (postgres)
postgres 39204   0.0  0.8 176756 32364  -  Ss   00:14     0:00.03 postgres: logical replication launcher    (postgres)
postgres 39235   0.0  0.8 177288 33300  -  Is   00:14     0:00.00 postgres: postgres template1 [local]  (postgres)
root       812   0.0  0.2  15648  6468  0  I+   20:33     0:00.57 bash -xv iRedMail.sh
root     39233   0.0  0.1  12084  3312  0  T+   00:14     0:00.00 su - postgres -c psql -d template1 -f /var/db/postgres/data12/i
postgres 39234   0.0  0.2  17496  8360  0  T    00:14     0:00.00 psql -d template1 -f /var/db/postgres/data12/iredmail.sql

# = = = = = = = = = =
# postgres
postgres=# SELECT * FROM pg_stat_activity ORDER BY backend_start;
 datid |  datname  |  pid  | usesysid | usename  | application_name | client_addr | client_hostname | client_port |         backend_start         |          xact_start           |          query_start          |         state_change          | wait_event_type |     wait_event      | state  | backend_xid | backend_xmin |                         query                          |         backend_type         
-------+-----------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+--------------------------------------------------------+------------------------------
       |           | 39199 |          |          |                  |             |                 |             | 2020-10-11 00:14:19.403791+11 |                               |                               |                               | Activity        | CheckpointerMain    |        |             |              |                                                        | checkpointer
       |           | 39200 |          |          |                  |             |                 |             | 2020-10-11 00:14:19.403882+11 |                               |                               |                               | Activity        | BgWriterHibernate   |        |             |              |                                                        | background writer
       |           | 39201 |          |          |                  |             |                 |             | 2020-10-11 00:14:19.40397+11  |                               |                               |                               | Activity        | WalWriterMain       |        |             |              |                                                        | walwriter
       |           | 39202 |          |          |                  |             |                 |             | 2020-10-11 00:14:19.404058+11 |                               |                               |                               | Activity        | AutoVacuumMain      |        |             |              |                                                        | autovacuum launcher
       |           | 39204 |       10 | postgres |                  |             |                 |             | 2020-10-11 00:14:19.404295+11 |                               |                               |                               | Activity        | LogicalLauncherMain |        |             |              |                                                        | logical replication launcher
     1 | template1 | 39235 |       10 | postgres | psql             |             |                 |          -1 | 2020-10-11 00:14:24.715003+11 |                               |                               | 2020-10-11 00:14:24.716797+11 | Client          | ClientRead          | idle   |             |              |                                                        | client backend
 13810 | postgres  | 41234 |       10 | postgres | psql             |             |                 |          -1 | 2020-10-11 10:35:03.200239+11 | 2020-10-11 10:37:25.306975+11 | 2020-10-11 10:37:25.306975+11 | 2020-10-11 10:37:25.306977+11 |                 |                     | active |             |          491 | SELECT * FROM pg_stat_activity ORDER BY backend_start; | client backend
(7 rows)


postgres=# select state, wait_event, wait_event_type, count(*) from pg_stat_activity group by 1,2,3 order by wait_event;
 state  |     wait_event      | wait_event_type | count 
--------+---------------------+-----------------+-------
        | AutoVacuumMain      | Activity        |     1
        | BgWriterMain        | Activity        |     1
        | CheckpointerMain    | Activity        |     1
 idle   | ClientRead          | Client          |     1
        | LogicalLauncherMain | Activity        |     1
        | WalWriterMain       | Activity        |     1
 active |                     |                 |     1
(7 rows)

$ su - root
Password:
root@server:~ # ps aux | grep post
postgres 684  0.0  0.5 176356 22720  -  Is   14:57   0:00.21 /usr/local/bin/postgres -D /var/db/postgres/data12
postgres 686  0.0  0.5 176356 22784  -  Is   14:57   0:00.00 postgres: checkpointer    (postgres)
postgres 687  0.0  0.5 176356 22772  -  Ss   14:57   0:00.03 postgres: background writer    (postgres)
postgres 688  0.0  0.5 176356 22772  -  Ss   14:57   0:00.01 postgres: walwriter    (postgres)
postgres 689  0.0  0.6 176868 23464  -  Is   14:57   0:00.01 postgres: autovacuum launcher    (postgres)
postgres 690  0.0  0.3  30800 11732  -  Is   14:57   0:00.01 postgres: stats collector    (postgres)
postgres 691  0.0  0.6 176756 23356  -  Ss   14:57   0:00.01 postgres: logical replication launcher    (postgres)
root     824  0.0  0.1  11532  2876  1  S+   15:00   0:00.00 grep post

root@server:~ # su - postgres -c 'psql -d template1 -f /var/db/postgres/data12/iredmail.sql'
Password for user vmailadmin: 
psql:/var/db/postgres/data12/iredmail.sql:20: error: \connect: FATAL:  password authentication failed for user "vmailadmin"


# = = = = = = = = = =
# /var/log/messages
Oct 11 15:00:53 server postgres[830]: [6-1] 2020-10-11 15:00:53.325 AEDT [830] FATAL:  password authentication failed for user "vmailadmin"
Oct 11 15:00:53 server postgres[830]: [6-2] 2020-10-11 15:00:53.325 AEDT [830] DETAIL:  User "vmailadmin" has no password assigned.
Oct 11 15:00:53 server postgres[830]: [6-3]   Connection matched pg_hba.conf line 99: "local all     all                 md5"
Oct 11 15:00:53 server postgres[831]: [6-1] 2020-10-11 15:00:53.336 AEDT [831] FATAL:  password authentication failed for user "vmailadmin"
Oct 11 15:00:53 server postgres[831]: [6-2] 2020-10-11 15:00:53.336 AEDT [831] DETAIL:  User "vmailadmin" has no password assigned.
Oct 11 15:00:53 server postgres[831]: [6-3]   Connection matched pg_hba.conf line 99: "local all     all                 md5"


# = = = = = = = = = =
root@server:~ # ls -l /var/db/postgres/data12/init_vmail_db.sql 
-rwxr-xr-x  1 root  postgres  413 11 Oct 00:14 /var/db/postgres/data12/init_vmail_db.sql


# = = = = = = = = = =
root@server:~ # cat /var/db/postgres/data12/init_vmail_db.sql
-- Crete role: vmail, read-only.
CREATE USER vmail WITH ENCRYPTED PASSWORD '' NOSUPERUSER NOCREATEDB NOCREATEROLE;

-- Create role: vmailadmin, read + write.
CREATE USER vmailadmin WITH ENCRYPTED PASSWORD '' NOSUPERUSER NOCREATEDB NOCREATEROLE;

-- Create database to store mail accounts
CREATE DATABASE vmail WITH TEMPLATE template0 ENCODING 'UTF8';

-- Grant privilege
ALTER DATABASE vmail OWNER TO vmailadmin;

root@server:~ # cd /var/db/postgres/
root@server:/var/db/postgres # ls -lA
total 12
-rw-------   1 postgres  postgres   149 11 Oct 00:14 .pgpass
-rw-------   1 postgres  postgres  1067 11 Oct 13:19 .psql_history
drwx------  19 postgres  postgres  1024 13 Oct 23:54 data12

root@server:/var/db/postgres # cat .pgpass 
*:*:*:postgres:pass
*:*:*:vmail:
*:*:*:vmailadmin:
*:*:*:iredapd:
*:*:*:iredadmin:
*:*:*:sogo:hSm
*:*:*:roundcube:rNf
*:*:*:amavisd:
*:*:*:fail2ban:

root@server:/var/db/postgres # cd ~/iRedMail-1.3.1
root@server:~/iRedMail-1.3.1 # ls -l 
-rwxr-xr-x   1 root  wheel  84276 10 Oct 01:40 ChangeLog
drwxr-xr-x   2 root  wheel    512 10 Oct 20:30 conf
-r--------   1 root  wheel    638 10 Oct 20:34 config
drwxr-xr-x   2 root  wheel    512 10 Oct 20:30 dialog
-rwxr-xr-x   1 root  wheel    307 10 Oct 01:40 Documentations
drwxr-xr-x   2 root  wheel   1024 10 Oct 20:30 functions
-rwxr-xr-x   1 root  wheel   5244 10 Oct 01:40 iRedMail.sh
-rw-r--r--   1 root  wheel   1252 11 Oct 00:14 iRedMail.tips
drwxr-xr-x   4 root  wheel    512 10 Oct 20:33 pkgs
-rwxr-xr-x   1 root  wheel   1291 10 Oct 01:40 README.md
drwxr-xr-x   2 root  wheel    512 10 Oct 20:34 runtime
drwxr-xr-x  24 root  wheel    512 10 Oct 20:30 samples
drwxr-xr-x   2 root  wheel   1024 10 Oct 20:30 tools
drwxr-xr-x   7 root  wheel    512 10 Oct 20:30 update
root@server:~/iRedMail-1.3.1 # cat config 

export STORAGE_BASE_DIR='/var/vmail'
export WEB_SERVER='NGINX'
export BACKEND_ORIG='PGSQL'
export BACKEND='PGSQL'
export VMAIL_DB_BIND_PASSWD=''
export VMAIL_DB_ADMIN_PASSWD=''
export MLMMJADMIN_API_AUTH_TOKEN=''
export NETDATA_DB_PASSWD=''
export PGSQL_ROOT_PASSWD='pass'
export FIRST_DOMAIN='katra.local'
export DOMAIN_ADMIN_PASSWD_PLAIN='pass'
export USE_IREDADMIN='YES'
export USE_ROUNDCUBE='YES'
export USE_FAIL2BAN='YES'
export AMAVISD_DB_PASSWD=''
export IREDADMIN_DB_PASSWD=''
export RCM_DB_PASSWD='rNf'
export SOGO_DB_PASSWD='hSm'
export SOGO_SIEVE_MASTER_PASSWD=''
export IREDAPD_DB_PASSWD=''
export FAIL2BAN_DB_PASSWD=''
#EOF

root@server:~ # eval </dev/urandom tr -dc A-Za-z0-9 | (head -c $1 &>/dev/null || head -c 32)
Invalid null command.

root@server:~ # ls -l /dev/urandom 
lrwxr-xr-x  1 root  wheel  6 13 Oct 23:54 /dev/urandom -> random

root@server:~ # ls -l /dev/random
crw-r--r--  1 root  wheel  0x8 13 Oct 23:54 /dev/random

root@server:~ # eval < /dev/urandom tr -dc A-Za-z0-9 
^C

root@server:~ # dd if=/dev/random bs=128 count=1
?ӇI?O=}?>D??R?Cd???_???W??'????J??įÉ]e?*?1?[x!^???>ޤ4?r??U?? ????FҾYoQ??e?ww0F??G?5?]1+0 records in
1+0 records out
128 bytes transferred in 0.000067 secs (1914649 bytes/sec)

cat /dev/random

dd if=/dev/random bs=128 count=1

root@server:~ # bash
[root@server ~]# eval </dev/urandom tr -dc A-Za-z0-9 | (head -c $1 &>/dev/null || head -c 32)
tr: Illegal byte sequence
exit

root@server:~ # cat > x.sh << EOF
? eval </dev/urandom tr -dc A-Za-z0-9 | (head -c $1 &>/dev/null || head -c 32)
? EOF

root@server:~ # bash -xv x.sh 
eval </dev/urandom tr -dc A-Za-z0-9 | (head -c  &>/dev/null || head -c 32)
+ eval tr -dc A-Za-z0-9
tr -dc A-Za-z0-9
++ tr -dc A-Za-z0-9
+ head -c
tr: Illegal byte sequence
+ head -c 32

root@server:~ # bash
[root@server ~]# openssl rand -base64 32
kRQTirNSZZZUcJiFnO8pq11NcsK927kIhGVlSr1AmaI=

[root@server ~]# openssl rand -hex 32
1da0fe4f215b0718b2fe80eb2b01a304f83ebea6aa6bee0b2c49bddfa112313f