The following steps describe the procedure to reset the MySQL root password on Linux. The same procedure works for MariaDB too. 1) Stop the MySQL server service mysql stop 2) Start the MySQL server manually without permission tables which allows us to login as root user without password: mysqld_safe --skip-grant-tables & 3) Login into MySQL ... Read more
HTTP connections can be redirected to HTTPS using the apache mod_rewrite module. Mod_rewrite should be available in every apache installation. Apache HTTP to HTTPS Redirect Create a file with the name .htaccess in the website root directory which contains the following lines: RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} If you use ISPConfig 3, ... Read more
This tutorial shows you how to use redirect rules in the Apache web server. If you want to redirect a subdomain like sub.domain.tld into a subdirectory of the website and keep the original URL in the browser location bar, you may use the following apache directive. RewriteEngine on RewriteCond %{HTTP_HOST} ^sub.domain.tld [NC] RewriteRule ^/(.*)$ /sub/$1 ... Read more
If you want to access a name-based website that you created e.g. in ISPConfig before the DNS records are set up, edit the hosts file on your workstation computer and add a line like this: 192.168.0.100 www.mydomain.com mydomain.com Edit hosts file on macOS X To edit the hosts file on a computer running macOS X, ... Read more
If you get an error like: Apr 15 12:41:03 webb4 postfix/sendmail[11234]: fatal: web1_user(12967): queue file write error in your mail log, then the value for message_size_limit in postfix main.cf is too low. Solve Postfix queue file write error Edit postfix main.cf: nano /etc/postfix/main.cf and set the message size limit to a higher value. E.g. message_size_limit ... Read more
If you experience problems with slow logins in pure-ftpd, this is often caused by a problem with the resolving of the client's hostname. This happens e.g. when you run an FTP server in your intranet and the hostname of the client computer does not exist in DNS. Disable PureFTPD name resolver To disable name resolving ... Read more
To turn on verbose logging (e.g. to debug FTP connection or authentication problems) in pure-ftpd FTP server on Debian and Ubuntu Linux. Enable debug log in pure-ftpd Execute the following command as root user in the shell to enable verbose logging: echo 'yes' > /etc/pure-ftpd/conf/VerboseLog and then restart pure-ftpd, for init based systems: service pure-ftpd-mysql ... Read more
One way to create a backup of a MySQL database on the shell is to use the mysqldump command. Mysqldump creates a dump of the database in form of sql commands, which can be easily restored using the mysql command or PHPMyAdmin. Backup a MySQL Database mysqldump -u root -p mydatabase > /tmp/backup_mydatabase.sql This command ... Read more
If all your visitors shall access your website with a URL like www.domain.com and not without www, use the following apache rewrite rule for redirecting them. RewriteEngine On RewriteCond %{HTTP_HOST} !^www RewriteRule (.*) http://www.%{HTTP_HOST}$1 [L,R] The apache rewrite rule can be added in a .htaccess file in the website root directory or if you use ... Read more
When a server has more than one IP address, then postfix will use all IP addresses randomly to send out emails. This can cause your emails to be listed as SPAM on other servers because the sending IP does not match the reverse IP of the server hostname. The solution is to bind postfix to ... Read more