DigitalOcean 1-Click virtual server

DigitalOcean 1-Click virtual server

If you do not have a server to run a PostgreSQL server on, or just want a simple way to get stared, a DigitalOcean Droplet is a great way to go.

A droplet is a cloud based virtual server. On the DigitalOcean marketplace you will find a 1-Click application called ThePlanMinder PostgreSQL. It enables you to have a server up and running in a few minutes.

Running a droplet costs (at the time of writing) $5 / month, and a little extra for automatic backups. If you sign up with the referral code below DigitalOcean will let you try for free for two months (more precisely, at the time of writing, you get $100 to spend in two months. Check current detailed conditions when you sign up).

This matches the 60 day trial period of The PlanMinder, giving you plenty of time to evaluate before paying anything.

https://marketplace.digitalocean.com/apps/theplanminder-postgresql?refcode=6244be190a6f

If you do not have a server to run a PostgreSQL server on, or just want a simple way to get stared, a DigitalOcean Droplet is a great way to go.

A droplet is a cloud based virtual server. On the DigitalOcean marketplace you will find a 1-Click application called ThePlanMinder PostgreSQL. It enables you to have a server up and running in a few minutes.

Running a droplet costs (at the time of writing) $5 / month, and a little extra for automatic backups. If you sign up with the referral code below DigitalOcean will let you try for free for two months (more precisely, at the time of writing, you get $100 to spend in two months. Check current detailed conditions when you sign up).

This matches the 60 day trial period of The PlanMinder, giving you plenty of time to evaluate before paying anything. 

https://marketplace.digitalocean.com/apps
/theplanminder-postgresql?refcode=6244be190a6f

Step-by-step guide to installing DigitalOcean

1. You must first sign up with DigitalOcean (which includes registering a payment method, i.e. a credit card). Note that Auspicia and The PlanMinder are not affiliated with DigitalOcean, and this is a business transaction between you and DigitalOcean.

2. Go to the 1-Click application at

https://marketplace.digitalocean.com/apps/theplanminder-postgresql

and click “Create ThePlanMinder PostgreSQL Droplet”.

3. Select the Basic plan, and the cheapest 1 GB / 1 CPU option.

4. Chose a data center region close to you.

5. Create a root password. Make it secure, and remember it.

6. Optionally, check the Enable Backups option. This is the simplest way to have automatic backups of your server.

7. Click “Create Droplet” and wait for the droplet to be created.

8. Click on the droplet row to see details.

9. Connect to the droplet using SSH, or click on the “Console” link to open a web based console window.

10. Log in as root with your set password (type “root” and press enter, then type your password) 

11. Type

bash create_db.sh

12. The script asks you to enter a username. This is the user name for the database administrator, called service login in The PlanMinder. Use only lowercase letters.

13. The script asks you to enter a password for the service login, and then to repeat it. Make sure you select a secure password, and that you remember it.

14. The script asks you to enter a database name. Use only lowercase letters. This name will be visible in The PlanMinder title bar for all users.

15. The script creates the database and displays connection information. If you are using a SSH client you can copy the connection string and use the paste button on The PlanMinder login screen. This is not possible with the web based console window.

Start The PlanMinder, select the Service Login Tab, and enter the connection information. Then click Login.

16. If things are working, The PlanMinder will connect to the database, and will ask you if you want to create PlanMinder tables on the server. Click yes, and moments later, you will be logged in to your new The PlanMinder database.

It will be quite empty in there when you start, but before you start setting up The PlanMinder you should create a user.

17. Go to the settings page, and select the Users Tab.

18. Click the New User button and create a user for yourself.

Username is the name you use when you log in. Pair it up with a strong password.

19. Fill out the other fields and when you come to the checkboxes, make sure that the Administrator checkbox is checked. If you are going to use The PlanMinder you should also probably check Developer, Manager and Regular. If you are setting this up for others, as the IT administrator, Administrator will be enough.

20. Now you can close The PlanMinder, restart it and log in with your new user. The PlanMinder will remember the server settings, but you have to change the tab to User Login and enter your new user name and password.

21. When logged in with your own user, you should go to the Settings / Registration tab and register your database. Fill in the form, click Register, and enter a password when prompted. You will get a confirmation email, and must click the link in the email to confirm your registration. After that you can go to the License Key tab and click Download Keys to get your 60 day trial license.

For guidance on how to continue configuring your The PlanMinder instance, follow this guide.

and click “Create ThePlanMinder PostgreSQL Droplet”.

3. Select the Basic plan, and the cheapest 1 GB / 1 CPU option.

4. Chose a data center region close to you.

5. Create a root password. Make it secure, and remember it.

6. Optionally, check the Enable Backups option. This is the simplest way to have automatic backups of your server.

7. Click “Create Droplet” and wait for the droplet to be created.

8. Click on the droplet row to see details.

9. Connect to the droplet using SSH, or click on the “Console” link to open a web based console window.

10. Log in as root with your set password (type “root” and press enter, then type your password) 

11. Type

bash create_db.sh

12. The script asks you to enter a username. This is the user name for the database administrator, called service login in The PlanMinder. Use only lowercase letters.

13. The script asks you to enter a password for the service login, and then to repeat it. Make sure you select a secure password, and that you remember it.

14. The script asks you to enter a database name. Use only lowercase letters. This name will be visible in The PlanMinder title bar for all users.

15. The script creates the database and displays connection information. If you are using a SSH client you can copy the connection string and use the paste button on The PlanMinder login screen. This is not possible with the web based console window.

Start The PlanMinder, select the Service Login Tab, and enter the connection information. Then click Login.

16. If things are working, The PlanMinder will connect to the database, and will ask you if you want to create PlanMinder tables on the server. Click yes, and moments later, you will be logged in to your new The PlanMinder database.

It will be quite empty in there when you start, but before you start setting up The PlanMinder you should create a user.

17. Go to the settings page, and select the Users Tab.

18. Click the New User button and create a user for yourself.

Username is the name you use when you log in. Pair it up with a strong password.

19. Fill out the other fields and when you come to the checkboxes, make sure that the Administrator checkbox is checked. If you are going to use The PlanMinder you should also probably check Developer, Manager and Regular. If you are setting this up for others, as the IT administrator, Administrator will be enough.

20. Now you can close The PlanMinder, restart it and log in with your new user. The PlanMinder will remember the server settings, but you have to change the tab to User Login and enter your new user name and password.

21. When logged in with your own user, you should go to the Settings / Registration tab and register your database. Fill in the form, click Register, and enter a password when prompted. You will get a confirmation email, and must click the link in the email to confirm your registration. After that you can go to the License Key tab and click Download Keys to get your 60 day trial license.

For guidance on how to continue configuring your The PlanMinder instance, follow this guide.

Extra Security

If your team only will access The PlanMinder from known locations or from inside your corporate network, you can use the Restrict Inbound Connections option on DigitalOcean to increase security.

Who we are

The_PlanMinder_logo

by:

Who we are

The_PlanMinder_logo

by: