Grommunio Mail Server - Revision history

Midas: /* Create MariaDB User */

2025-01-31T09:16:35Z

Create MariaDB User

← Older revision		Revision as of 09:16, 31 January 2025
Line 65:		Line 65:
	echo "DELETE FROM mysql.user WHERE User='';" >> /tmp/sql		echo "DELETE FROM mysql.user WHERE User='';" >> /tmp/sql
	echo "FLUSH PRIVILEGES;" >> /tmp/sql		echo "FLUSH PRIVILEGES;" >> /tmp/sql
	cat /tmp/sql \| ~~mysql~~ -u root --password="${DB_ROOT_PASS}"		cat /tmp/sql \| mariadb -u root --password="${DB_ROOT_PASS}"


	=== Configure MariaDB ===		=== Configure MariaDB ===

2025-01-31T09:16:12Z

Create Grommunio Database

← Older revision		Revision as of 09:16, 31 January 2025
Line 137:		Line 137:
	echo "grant select, insert, update, delete, create, drop, index, alter, create temporary tables, lock tables on $MYSQL_DB.* TO $MYSQL_USER@$MYSQL_HOST identified by '$MYSQL_PASS';" >> /tmp/sql		echo "grant select, insert, update, delete, create, drop, index, alter, create temporary tables, lock tables on $MYSQL_DB.* TO $MYSQL_USER@$MYSQL_HOST identified by '$MYSQL_PASS';" >> /tmp/sql
	echo "flush privileges;" >> /tmp/sql		echo "flush privileges;" >> /tmp/sql
	cat /tmp/sql \| ~~mysql~~ -u admin --password="${DB_PASS}"		cat /tmp/sql \| mariadb -u admin --password="${DB_PASS}"


	Test the database connection:		Test the database connection:

	~~mysql~~ -hlocalhost -u grommunio -p${MYSQL_PASS} grommunio		mariadb -hlocalhost -u grommunio -p${MYSQL_PASS} grommunio



	== 2. Install and Configure Nginx ==		== 2. Install and Configure Nginx ==

2025-01-31T09:14:06Z

9. Finalize and Verify

2025-01-31T09:13:59Z

8. Install and Configure Rspamd

← Older revision		Revision as of 09:13, 31 January 2025
Line 592:		Line 592:
	valkey-cli ping # Expected result: 'PONG'		valkey-cli ping # Expected result: 'PONG'

	== 8. Install and Configure Rspamd ==		== 7. Install and Configure Rspamd ==

	=== Install Rspamd ===		=== Install Rspamd ===
Line 837:		Line 837:
	#rspamc -h /run/rspamd/worker-controller.sock stat		#rspamc -h /run/rspamd/worker-controller.sock stat
	rspamc stat		rspamc stat



	== 9. Finalize and Verify ==		== 9. Finalize and Verify ==

2025-01-31T09:13:52Z

7. Configure Valkey

2025-01-31T09:13:44Z

6. Install and Configure Grommunio

← Older revision		Revision as of 09:13, 31 January 2025
Line 314:		Line 314:
	tail -f /var/log/maillog		tail -f /var/log/maillog

	== 6. Install and Configure Grommunio ==		== 5. Install and Configure Grommunio ==

	=== Enable IPv6 ===		=== Enable IPv6 ===
Line 542:		Line 542:
	8080/tcp		8080/tcp
	8443/tcp		8443/tcp



	== 7. Configure Valkey ==		== 7. Configure Valkey ==

2025-01-31T09:13:32Z

5. Install and Configure Postfix

← Older revision		Revision as of 09:13, 31 January 2025
Line 265:		Line 265:
	sed 's/^;\?$session.cookie_httponly$.*/\1 = 1/' -i /etc/php83/php.ini		sed 's/^;\?$session.cookie_httponly$.*/\1 = 1/' -i /etc/php83/php.ini

	== 5. Install and Configure Postfix ==		== 4. Install and Configure Postfix ==

	=== Install Postfix ===		=== Install Postfix ===
Line 313:		Line 313:

	tail -f /var/log/maillog		tail -f /var/log/maillog



	== 6. Install and Configure Grommunio ==		== 6. Install and Configure Grommunio ==

2025-01-31T09:13:19Z

4. Install and Configure PHP

2025-01-31T09:13:07Z

3. Install and Configure Nginx

2025-01-31T09:12:46Z

2. MariaDB Performance Tuning (Optional)

← Older revision		Revision as of 09:12, 31 January 2025
Line 143:		Line 143:

	mysql -hlocalhost -u grommunio -p${MYSQL_PASS} grommunio		mysql -hlocalhost -u grommunio -p${MYSQL_PASS} grommunio



	~~== 2. MariaDB Performance Tuning (Optional) ==~~

	To assist us in checking and tuning the configuration as per our specific needs, we can install mysqltuner, a script that will provide suggestions to improve the performance of our database server and increase its stability

	~~=== Download MySQLTuner ===~~

	~~wget -v https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl -O /tmp/mysqltuner.pl~~


	~~Move it to the correct directory and set permissions:~~

	~~mv /tmp/mysqltuner.pl /usr/local/bin/mysqltuner.pl~~
	~~chmod 755 /usr/local/bin/mysqltuner.pl~~


	~~=== Install perl ===~~

	~~'''NOTE:''' The perl-doc package is installed because it's the only one containing the perldiag.pod required by mysqltuner.pl~~

	~~apk add perl perl-doc~~

	~~=== Execute the script ===~~

	~~You will be prompted to enter the credentials of your administrative MariaDB account:~~

	~~/usr/local/bin/mysqltuner.pl --user admin --pass ${DB_PASS}~~