{"id":9820,"date":"2019-07-23T14:35:58","date_gmt":"2019-07-23T14:35:58","guid":{"rendered":"http:\/\/blog.bachi.net\/?p=9820"},"modified":"2019-12-01T09:56:25","modified_gmt":"2019-12-01T09:56:25","slug":"freebsd-12-mail-server-installation","status":"publish","type":"post","link":"https:\/\/blog.bachi.net\/?p=9820","title":{"rendered":"FreeBSD 12: Mail Server Installation"},"content":{"rendered":"

blog.bachi.net
\nFreeBSD Ports<\/a>
\nfreebsd-update<\/a><\/p>\n

QMail HOWTO<\/a> (2016)<\/p>\n

\r\n$ pkg install mysql57-server\r\nUpdating FreeBSD repository catalogue...\r\nFreeBSD repository is up to date.\r\nAll repositories are up to date.\r\nThe following 11 package(s) will be affected (of 0 checked):\r\n\r\nNew packages to be INSTALLED:\r\n        mysql57-server: 5.7.26_1\r\n        perl5: 5.28.2\r\n        curl: 7.65.1\r\n        libnghttp2: 1.39.1\r\n        ca_root_nss: 3.45\r\n        protobuf: 3.7.1,1\r\n        libevent: 2.1.10\r\n        libedit: 3.1.20190324,1\r\n        mysql57-client: 5.7.26\r\n        cyrus-sasl: 2.1.27\r\n        liblz4: 1.9.1,1\r\n\r\nNumber of packages to be installed: 11\r\n\r\nThe process will require 285 MiB more space.\r\n35 MiB to be downloaded.\r\n\r\nProceed with this action? [y\/N]:\r\n\r\n[...]\r\n\r\nMessage from ca_root_nss-3.45:\r\n\r\n********************************* WARNING *********************************\r\n\r\nFreeBSD does not, and can not warrant that the certification authorities\r\nwhose certificates are included in this package have in any way been\r\naudited for trustworthiness or RFC 3647 compliance.\r\n\r\nAssessment and verification of trust is the complete responsibility of the\r\nsystem administrator.\r\n\r\n*********************************** NOTE **********************************\r\n\r\nThis package installs symlinks to support root certificates discovery by\r\ndefault for software that uses OpenSSL.\r\n\r\nThis enables SSL Certificate Verification by client software without manual\r\nintervention.\r\n\r\nIf you prefer to do this manually, replace the following symlinks with\r\neither an empty file or your site-local certificate bundle.\r\n\r\n  * \/etc\/ssl\/cert.pem\r\n  * \/usr\/local\/etc\/ssl\/cert.pem\r\n  * \/usr\/local\/openssl\/cert.pem\r\n\r\n***************************************************************************\r\nMessage from perl5-5.28.2:\r\n\r\nThe \/usr\/bin\/perl symlink has been removed starting with Perl 5.20.\r\nFor shebangs, you should either use:\r\n\r\n#!\/usr\/local\/bin\/perl\r\n\r\nor\r\n\r\n#!\/usr\/bin\/env perl\r\n\r\nThe first one will only work if you have a \/usr\/local\/bin\/perl,\r\nthe second will work as long as perl is in PATH.\r\nMessage from cyrus-sasl-2.1.27:\r\n\r\nYou can use sasldb2 for authentication, to add users use:\r\n\r\n        saslpasswd2 -c username\r\n\r\nIf you want to enable SMTP AUTH with the system Sendmail, read\r\nSendmail.README\r\n\r\nNOTE: This port has been compiled with a default pwcheck_method of\r\n      auxprop.  If you want to authenticate your user by \/etc\/passwd,\r\n      PAM or LDAP, install ports\/security\/cyrus-sasl2-saslauthd and\r\n      set sasl_pwcheck_method to saslauthd after installing the\r\n      Cyrus-IMAPd 2.X port.  You should also check the\r\n      \/usr\/local\/lib\/sasl2\/*.conf files for the correct\r\n      pwcheck_method.\r\n      If you want to use GSSAPI mechanism, install\r\n      ports\/security\/cyrus-sasl2-gssapi.\r\n      If you want to use SRP mechanism, install\r\n      ports\/security\/cyrus-sasl2-srp.\r\n      If you want to use LDAP auxprop plugin, install\r\n      ports\/security\/cyrus-sasl2-ldapdb.\r\nMessage from mysql57-client-5.7.26:\r\n\r\n* * * * * * * * * * * * * * * * * * * * * * * *\r\n\r\nThis is the mysql CLIENT without the server.\r\nfor complete server and client, please install databases\/mysql57-server\r\n\r\n* * * * * * * * * * * * * * * * * * * * * * * *\r\nMessage from mysql57-server-5.7.26_1:\r\n\r\n*****************************************************************************\r\n\r\nRemember to run mysql_upgrade the first time you start the MySQL server\r\nafter an upgrade from an earlier version.\r\n\r\nInitial password for first time use of MySQL is saved in $HOME\/.mysql_secret\r\nie. when you want to use "mysql -u root -p" first you should see password\r\nin \/root\/.mysql_secret\r\n\r\nMySQL57 has a default %%ETCDIR%%\/my.cnf,\r\nremember to replace it wit your own\r\nor set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.\r\n\r\n*****************************************************************************\r\n\r\n\r\n$ cat \/etc\/rc.conf\r\n[...]\r\nmysql_enable="YES"\r\nmysql_dbdir="\/db\/mysql"\r\n[...]\r\n\r\n$ service mysql-server start\r\n\/usr\/local\/etc\/rc.d\/mysql-server: WARNING: failed precmd routine for mysql\r\n$ mkdir \/db\r\n$ mkdir \/db\/mysql\r\n$ service mysql-server start\r\nStarting mysql.\r\n\r\n<\/pre>\n
How to Install MariaDB 10.3 on FreeBSD 12<\/a>
\nMySQL unter FreeBSD: Installation<\/a><\/p>\n
\r\n===> Creating groups.\r\nUsing existing group 'mysql'.\r\n===> Creating users\r\nUsing existing user 'mysql'.\r\n[5\/5] Extracting mariadb104-server-10.4.6: 100%\r\nMessage from mariadb104-client-10.4.6:\r\n\r\n************************************************************************\r\n\r\nMariaDB respects hier(7) and doesn't check \/etc and \/etc\/mysql for\r\nmy.cnf. Please move existing my.cnf files from those paths to\r\n\/usr\/local\/etc and \/usr\/local\/etc\/mysql.\r\n\r\n************************************************************************\r\nMessage from mariadb104-server-10.4.6:\r\n\r\n************************************************************************\r\n\r\nRemember to run mysql_upgrade (with the optional --datadir=<dbdir> flag)\r\nthe first time you start the MySQL server after an upgrade from an\r\nearlier version.\r\n\r\nMariaDB respects hier(7) and doesn't check \/etc and \/etc\/mysql for\r\nmy.cnf. Please move existing my.cnf files from those paths to\r\n\/usr\/local\/etc and \/usr\/local\/etc\/mysql.\r\n\r\nThis port does NOT include the mytop perl script, this is included in\r\nthe MariaDB tarball but the most recent version can be found in the\r\ndatabases\/mytop port\r\n\r\n************************************************************************\r\n\r\n service mysql-server start\r\nInstalling MariaDB\/MySQL system tables in '\/var\/db\/mysql' ...\r\nOK\r\n\r\nTo start mysqld at boot time you have to copy\r\nsupport-files\/mysql.server to the right place for your system\r\n\r\n\r\nTwo all-privilege accounts were created.\r\nOne is root@localhost, it has no password, but you need to\r\nbe system 'root' user to connect. Use, for example, sudo mysql\r\nThe second is root@localhost, it has no password either, but\r\nyou need to be the system 'root' user to connect.\r\nAfter connecting you can set the password, if you would need to be\r\nable to connect as any of these users with a password and without sudo\r\n\r\nSee the MariaDB Knowledgebase at http:\/\/mariadb.com\/kb or the\r\nMySQL manual for more instructions.\r\n\r\nYou can start the MariaDB daemon with:\r\ncd '\/usr\/local' ; \/usr\/local\/bin\/mysqld_safe --datadir='\/var\/db\/mysql'\r\n\r\nYou can test the MariaDB daemon with mysql-test-run.pl\r\ncd '\/usr\/local\/mysql-test' ; perl mysql-test-run.pl\r\n\r\nPlease report any problems at http:\/\/mariadb.org\/jira\r\n\r\nThe latest information about MariaDB is available at http:\/\/mariadb.org\/.\r\nYou can find additional information about the MySQL part at:\r\nhttp:\/\/dev.mysql.com\r\nConsider joining MariaDB's strong and vibrant community:\r\n
Get Involved<\/a><\/blockquote>