When dealing with large databases over 50Mb it is recommended to manage them via SSH. SiteGround customers can find more information on how to connect to and use SSH in our SSH Tutorial. In this article, we will cover exporting and importing a database via SSH. Make sure that you replace the following variables in the… read more »
3,774 total views
To increase it in DA to 16, for example, you can simply run:Code: /usr/local/directadmin/directadmin set max_username_length 16 restart * To make sure your MySQL username/database name is fine, I’d suggest upgrading your MySQL/MariaDB on the server (https://www.directadmin.com/features.php?id=2294), MySQL 5.7+ or MariaDB 10.x is recommended.* I’d suggest trying it with 1 account first, most preferably – the one… read more »
3,101 total views
cd /usr/local/directadmin/scripts./letsencrypt.sh request_single your.hostname.com 4096which will also install the new cert/key/ca files in all respective global places for apache, dovecot, exim, ftp, and DirectAdmin.NOTE The hostname value, eg: your.hostname.com must match the “servername” value set in the directadmin.conf, or it will not be in hostname mode, but User domain mode instead. You must then turn on SSL in DA and… read more »
3,005 total views
The new LetsEncrypt feature is a great way to easily secure your website connections at no cost. If you already have many website that you want to secure all at once, you can use the autoletsencrypt.sh script to do this. Make sure you’ve already enabled LetsEncrypt on the system: Then you can install certificate for all domains:cd… read more »
3,055 total views
LetsEncrypt is a free SSL tool that lets you install a very basic free SSL Certificate with 1 click. It supports multiple domains and sub-domains, and will auto-renew automatically before it expires after it’s ~90 day lifespan. To enable this feature in DirectAdmin, ensure you have DirectAdmin 1.50.1 or newer. If you’re running CentOS 6… read more »
2,988 total views
A: Just set the following settings in /usr/local/directadmin/conf/directadmin.conf and restart DirectAdmin:Code: port=2082 ssl_port=2083 If you would like to let customers use just the SSL on port 2083, set:Code: ssl=1 port=2083 Related: https://help.directadmin.com/item.php?id=2101 3,165 total views
3,165 total views
To upgrade MariaDB using the custombuild script, do the following: cd /usr/local/directadmin/custombuild./build set mariadb 10.3./build set mysql_inst mariadb./build set mysql_backup yes./build update./build mariadb ./build php n Where mariadb can be 5.5, 10.0, 10.1, 10.2 or 10.3 A full raw sql backup will be run prior to the upgrade if you have mysql_backup=yes set. It goes without saying, always make backups, either… read more »
3,519 total views
A hostname is simply the name a server goes by on the network. Setting a unique hostname is an excellent way to quickly find and identified different servers on your network. There are three 3 types of hostnames. The static hostname is the most important one, and it’s stored in the /etc/hostname file. This hostname is used among machines to identify… read more »
2,557 total views