Setting up a mail server is covered in a previous post…<\/p>\n
Before starting I have created a copy of my VM to mitigate breaking everything and I recommend you do too, if you’re reading this.<\/p>\n
I have a unique installation – phpmyadmin is running on another server and I would like to enable access to the mysql server running on the mail server.<\/p>\n
On the mail server I commented out:
\nbind-address \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 = 127.0.0.1
\nfrom the file \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/p>\n
Then,\u00a0also\u00a0on the mail server entered the commands:
\n$ mysql -u root -h localhost -p
\nCREATE USER ‘myusername’@’localhost’ IDENTIFIED BY ‘mypassword’;
\nGRANT ALL PRIVILEGES ON *.* TO ‘myusername’@’localhost’ WITH GRANT OPTION;
\nCREATE USER ‘myusername’@’%’ IDENTIFIED BY ‘mypassword’;
\nGRANT ALL PRIVILEGES ON *.* TO ‘myusername’@’%’ WITH GRANT OPTION;
\nexit<\/p>\n
This created a new user with ‘myusernam’ and ‘mypassword’ that has remote access to the entire mysql installation.<\/p>\n
Back on the server, I edited the phpmyadmin config file\u00a0\/etc\/phpmyadmin\/config.inc.php and appended the following to the file (after backing up of course!):<\/p>\n
$i++;
\n$cfg[‘Servers’][$i][‘verbose’] = ‘Mail’;
\n$cfg[‘Servers’][$i][‘host’] = ‘mail.myhostname.net’;
\n$cfg[‘Servers’][$i][‘port’] = ”;
\n$cfg[‘Servers’][$i][‘socket’] = ”;
\n$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
\n$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
\n$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
\n$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;<\/p>\n
Then restarted the apache service on the server where phpmyadmin is running and voila! I can log into the remote mysql installation. To secure my installation and stop passwords from being sent in the clear, I forced ssl connections in owncloud. Googled and found instructions here<\/a>. Restart apache and it should force you to use the https rather than http access.<\/p>\n Configuration is not covered here. However you should be able to log in and continue.<\/p>\n","protected":false},"excerpt":{"rendered":" Setting up a mail server is covered in a previous post… Before starting I have created a copy of my VM to mitigate breaking everything and I recommend you do too, if you’re reading this. I have a unique installation … Continue reading
\nFrom there it was a simple matter of creating a new user for ownlcloud.\u00a0To do that I have been following the instructions I’ve found here<\/a>\u00a0and install instructions for Ubuntu 16.04 here<\/a>.<\/p>\n
\nIn short, edit the file \/var\/www\/owncloud\/.htaccess
\nIn the section <IfModule mod_rewrite.c> add two lines below ReWriteEngine on:
\nRewriteCond %{HTTPS} off
\nRewriteRule (.*) https:\/\/%{HTTP_HOST}%{REQUEST_URI}<\/p>\n