Category: Server Management

Create a Database in Virtualmin Panel

  1. When logged in to VirtualMin Panel, select the site you want to add a database into and then click “Edit Databases.”
virtualmin edit database menu
  1. Click “Create a new database.”
virtualmin create database
  1. Enter the database name. In most cases, you won’t need to set the “Additional Options” but if you do, you can click that and set the Collation and Character set. Click “Create” when done.
virtualmin database details

Note:

Your database user is the server user. We recommend that you add additional users to the database and don’t use the main user for database access:

Create a Database User in Virtualmin Panel

Your database user is the server user. We recommend that you add additional users to the database and don’t use the main user for database access:

  • Navigate to “Edit Users”.
add ftp user virtualmin
  • Click “Add a user to this server”.
virtualmin server add user
  • After entering in the username and generating a password, click “Other user Permissions” . For “Login Permissions” choose “Email only”. Select the database you want them to have access to. Create the user.
virtualmin select database for user

Scheduling a Cron in Virtualmin Panel

Here’s how to set up a Cron in Virtualmin Control Panel as many scripts require. Cron is a service for executing scheduled commands. You’ll need to be logged in to Virtualmin in order to do the following.

  1. Navigate to Webmin > System > Scheduled Cron Jobs.
virtualmin schedule cron menu
  1. Click “Create a new scheduled cron job”.
virtualmin file manager upload
  1. Choose the user to run as for “Execute cron job as” . (See screenshot below for steps 3-6)
  2. Enter the command to run into the “Command” field. For example, if you want to receive a list of all running processes, enter ps auxw for the command. For more details on commands, please see your script developer.
  3. Normally, you can skip “Input to command.” That’s only used if your command requires input after it begins running.
  4. Description is optional but helps you to know what this cron does in case you have several crons.
  5. Choose how frequently to run your command. By default, it will execute Hourly, meaning it will execute at the top of the hour, every hour. The Run and Time would have been given by the script developer. Check with them if you don’t know.
  6. To enable the Cron job, click “Create.”
virtualmin file manager upload

Any output will be emailed to the root user.

Upload and Extract Files in Virtualmin Panel

Virtualmin Panel includes a file manager where you can upload and extract zip files or any other files.

We recommend uploading files via FTP. However, if you prefer to upload via the file manager, follow the steps below. Step 5 shows how to extract uploaded files, whether they were uploaded via FTP or by the file manager.

  1. When logged in to VirtualMin Panel, select the site you want to upload files into and then click “File Manager.”
virtualmin file manager menu
  1. To the right, you’ll see a list of files on the server, a list of domains, and various buttons at the top middle.
  2. Open the directory you want to upload to. Our screenshot shows the public_html folder open.
  3. At the top click File > Upload to Current Directory. Select the file from your computer then drag and drop it into the popup and click Upload.
virtualmin file manager upload
  1. If you’ve uploaded a compressed file (zip, tar, etc), to extract it click the ellipses to the left of the file and select “Extract.”
virtualmin file manager extract

Installing phpMyAdmin in Virtualmin Panel

If you want to install phpMyAdmin to manage your databases, here’s how.

Note: You first need to have created databases to manage.

  1. In the left menu, click “Install Scripts.”
virtualmin install phpmyadmin menu
  1. Select phpMyAdmin and click “Show Install Options” at the bottom.
virtualmin install phpmyadmin button
  1. Choose to manage all databases or to select databases to manage. Click “Install Now” when done.
virtualmin install phpmyadmin details

Add a Website in Virtualmin Panel

Here’s how to add a website or subdomain in the Virtualmin panel.

  1. Click “Create Virtual Server” in the menu on the left.
create virtualmin website
  1. Enter the domain name you want. If creating a subdomain, click the “Sub-server” button first and then enter the subdomain as you want it.
create website virtualmin domain name
  1. Click “Create Server” if you want to leave the default options as they are (recommended for those without advanced knowledge).

Tip:

If you want to see the IP of the server, for DNS and other things, you can click “IP Address and Forwarding” which will open to show the server IP.

create domain virtualmin ip address

Adding FTP Users in Virtualmin Panel

  1. When logged in to Virtualmin, select the domain you want to add an FTP user for and click “Edit Users” in the left menu.
add ftp user virtualmin
  1. Click “add a website ftp access user.”
add ftp user button
  1. Fill in the “username” and click the key icon next to the password input field. If you want, you can make your own password instead of using the secure password generator. You can leave the “Real name” field blank. If you want to set a password recovery email, fill that in, otherwise leave blank. You are now done unless you want to restrict this user’s access to specific directories. If so, continue with step 4.
add ftp user details
  1. Click “Other User Permissions” to restrict the user’s access. You can add directories that this user can access by clicking the one(s) on the left to add them to the allowed list.
add ftp user permissions
  1. When finished, click the Create button at the bottom. This FTP user will connect via FTP with the credentials you set.

Tips

  • If you can’t see directory listings with this FTP user, try changing your FTP program to Passive mode. If that doesn’t work, try Active mode.
  • In some cases, your ISP provider will block certain ports from access. If you cannot get the directory listing after trying the above, please contact our support.
  • A few FTP programs to try are FileZilla, Cyberduck, WinSCP, and there are many others.

ISPmanager Adding FTP Users

Your ISPmanager details were emailed to you when your server was created. That user and password can be used for FTP login as well, just follow this basic FTP guide.

However, if you would like to add more FTP users in order to give to developers or staff, here’s how to do that. This is best practice when having others work on your site as the main user has full server access.

  1. Log into your ISPmanager and navigate to FTP Users.
  2. Click “Add” at the top of the FTP user list.
    ISPmanager add user button
  3. Enter the FTP user name, password, confirm password, and the home directory that this user will have access to and click OK when done. Note that you can click the “Generate Password” button next to the question mark for the Password in order to have a more secure password.
    ISPmanager ftp user info

Suspending an FTP User

To suspend an FTP user, click the lightbulb to the right of the user.
ISPmanager suspend ftp user

Logging into PhpMyAdmin and Your Database in ISPmanager Control Panel

Once you’ve created a database, you may want to log into the database via PhpMyAdmin. You can easily do that in ISPmanager. Here’s how:

  1. When logged into ISPmanager, navigate to Dashboard > Databases.
    ISPmanager database menu
  2. Select the database that you want to log into and then click “Go.”
    ISPmanager open database
  3. You’ll now automatically be logged into the selected database.

If you prefer to log directly into your database in PhpMyAdmin, follow these steps:

  1. When you created the database, you would have received an email with the database details. In that email is a link to PhpMyAdmin which would be (yourserverIP)/phpmyadmin substituting “(yourserverIP)” with your own server’s IP.
  2. Once at PhpMyAdmin, log in with the same database user and password that you created when you made the database.

Note: Due to a bug in PhpMyAdmin and current PHP versions, you may see some warning notices when logged in to PhpMyAdmin. Once they have a fix for that, we’ll update it but for now please click “Ignore All” to not see the notices.

Scheduling a Cron in ISPmanager Control Panel

Here’s how to set up a Cron in ISPmanager Control Panel as many scripts require. You’ll need to be logged in to ISPmanager in order to do the following.

  1. Navigate to Dashboard > Scheduler (cron)
    ISPmanager cron menu
  2. Click “Add” at the top of the center column.
    ISPmanager add cron
  3. Fill in the fields for the cron. If you want a report sent, be sure to enter a good email address. This will send details of your cron jobs that you’ve added.
    ISPmanager cron fields
  4. The command would be whatever your script needs. You can get this from your script developer.
  5. Description is optional but helps you to know what this cron does in case you have several crons.
  6. You can use either Basic or Expert mode but if using Expert mode, you will need more details filled in. Only use that if you are familiar with setting up crons.
  7. The Run and Time would have been given by the script developer. Check with them if you don’t know.
  8. Click Ok when done.
%d bloggers like this: