SSH

How do I connect via SSH using 2FA?

It's only recommended that you connect to your package via SSH if you're familiar with the command-line interface. Here is how to connect using two-factor authentication (2FA). Windows If you're using Windows you will want to download an SSH client to access SSH.  You can download PuTTY from the following page: https://www.putty.org/ ⦁    You will want to first download the Google Authenticator app , which is available for both iOS and Android devices  ⦁    Log in via cpanel.yourdomain.com, and head to Manage Hosting and select the package that you require SSH access for. Then select SSH Access from under the Security section Or if you have one account, head directly to SSH Access ⦁    Under Set SSH password, set the password and make note of this for later on. Then select Set up Authenticator and proceed to scan the QR code on your iOS or Android device Note: You will need to wait 30 minutes before making any connection attempts. ⦁    Open PuTTY. Enter the hostname 'ssh.stackcp.com' and select Open.   ⦁    The command-line interface will request you for a login. Log in with your domain (e.g. example.com)  ⦁    You will then be prompted for a verification code. Open Google Authenticator and enter your code. ⦁    Enter the SSH password which was set-up earlier.   ⦁    You'll now have access to SSH through 2FA.

How do I connect via SSH?

It's only recommended that you connect to your package via SSH if you're familiar with the command line interface. Windows If you're using Windows, you'll need to download an SSH Client to access SSH. This guide uses PuTTY, which is a free SSH client and can be downloaded here: https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html 1. Once you have downloaded PuTTY, search for and open PuTTY Key Generator on your computer. 2. Select Generate and move the mouse around in the gray box to generate some Randomness. This will generate a public key. 3. Add a passphrase (password). This is what you'll need to put into the command line interface. 4. Log in tocpanel.yourdomain.com, head to Manage Hosting and select the package that you want SSH access for. Then select, SSH Access from under the Security section, or if you have one account, head directly to SSH Access 5. Then input the public key that was generated from PuTTYgen into the Public Key box. A handle will be generated automatically. Then select Add Public Key. 6. Head back to PuTTY Gen and select Save private key. Save this as any name you want. 7. Open PuTTY. Down the left-hand side, select to expand the SSH menu and then select Auth. 8. Select Browse and add the private key you have just saved. 9. Head back to Session using the left-hand menu and add the host name ‘ssh.****cpanel.yourdomain.com’ and select Open**** 10. The command line interface will be show. Then login with your domain (e.g. domain.co.uk). 11. You'll then be prompted for the passphrase that you set earlier. Enter this. 12. You'll now have access to SSH for your site

How do I import a .sql file via the command-line?

If you've set up SSH access for a hosting account, then you can run the following command-line instructions to import a MySQL database: mysql -h hostname -u username -p username < databasefile.sql The above command connects to your database with the -h (hostname) -u (username) -p (database name in this case), then the unzipped file < databasefile.sql You will then be prompted to enter a password for the database. Input the password and press Enter. Compressed files If the database file is zipped, then you will need to unzip it first, and then you can use one of the following commands: For a .zip file, you can use the unzip command: - unzip databasefile.sql.zip - mysql -h hostname -u username -p username < databasefile.sql For a .gz file, you can use the gunzip command: - gunzip databasefile.sql.gz - mysql -h hostname -u username -p username < databasefile.sql

How do I connect via SSH on an Apple Mac?

To connect via SSH on a Mac, you can follow the instructions below: 1. Log in tocpanel.yourdomain.com. 2. Head to Manage Hostingand select Manageon the hosting package you want to connect to Or if you have one account, head directly to SSH Access. 3. Select the SSH Accessicon. 4. You’ll now need to generate a public key; on a Mac, this is done via the Terminalutility. Open Terminalon the Mac. 5. Enter the following command into the Terminal: ssh-keygen 1. Press Enter 2. You’ll be prompted to enter the locationthat you want the public and private keys saving. In this case, we’ll keep this as the default location. Press Enter 3. You’ll be prompted for a passphrase, in this guide we’ll just leave this empty. If you enter one, make sure you remember this as you’ll be prompted for this later. Press Enter. 4. You’ll be asked to confirm the passphrase - since we’ve left this empty just press Enter. 5. Your keys will have been generated and the public key will have been saved in a specified location, in our example, it has been saved in: /Users/user/.ssh/id_rsa.pub. 1. Copy the path and enter the following command: cat /Users/user/.ssh/id_rsa.pub. 1. The key will be outputted, copy the whole key from the start to the end. 2. Paste the key back into the Public Key field in the SSH Access section. The handle should be added automatically. Press Add Public Key. 3. Please note that can take up to 5 minutes. 4. Head back to Terminal and enter the SSH username and hostname found at the top of the SSH Access section, it should be something like domain.com@ssh.stackcp.comYou’ll need to prefix it with the ssh command as follows: ssh domain.com@ssh.stackcp.com 1. You’ll be prompted to confirm you would like to connect, simply type yesand press enter. You should have successfully connected via SSH from your Mac to your hosting package at MegabitCloud | Web Hosting.

How do I run Composer via SSH?

At MegabitCloud Web Hosting, we run multiple different versions of PHP. On our SSH servers, the execution of commands like “composer” will run with our default, system-level PHP that is also used for internal tools at MegabitCloud  Web Hosting. This is a thin version of PHP without all the modules you may be used-to on your website. To enable use of this command, you need to specify the full path to the version of PHP that you wish to run the script as. You can do this on the command line itself. Here's an example of using PHP 7.1 to execute Composer: /usr/bin/php71 -f /usr/bin/composer So the complete command would become: /usr/bin/php71 -f /usr/bin/composer install A list of available PHP versions is presented to you in the message of the day (MOTD) once you login to SSH.