How to host SuiteCRM with digitalocean?

Heya,

Which is the MariaDB version on your droplet and also can you share the steps you’ve taken to create the database? You can check the installation guide in SuiteCRM’s docs:

https://docs.suitecrm.com/admin/installation-guide/downloading-installing/

Regards

Hi there,

The error that you are getting indicates that your database credentials are wrong. You need to update the main SuiteCRM config file with correct information like the database settings and the current SuiteCRM version:

https://docs.suitecrm.com/developer/config/

Alternatively, you could give this another try with a new Droplet, based on their official documentation here, you should be able to get this working with the 1-Click LAMP installation:

https://marketplace.digitalocean.com/apps/lamp

So what you should be able to do is:

1. Create a Droplet:

   • Use the 1-Click LAMP application from the DigitalOcean Marketplace: 1-Click LAMP.
   • Choose the appropriate configuration for your needs and create the Droplet.

2. Download SuiteCRM:

   • Download the latest SuiteCRM installer as described here: Downloading and Installing SuiteCRM.
   • Unzip the downloaded file and move it to your web server’s root directory (usually /var/www/html for Apache).

3. Set Permissions:

   • Set the required permissions for the SuiteCRM files:

     find . -type d -not -perm 2755 -exec chmod 2755 {} \;
     find . -type f -not -perm 0644 -exec chmod 0644 {} \;
     find . ! -user www-data -exec chown www-data:www-data {} \;
     chmod +x bin/console
     

4. Create your database and user:

   • Access the MySQL service and create your database user and password:

     CREATE DATABASE suitecrm_db;
     CREATE USER 'suitecrm_user'@'localhost' IDENTIFIED BY 'your_password';
     GRANT ALL PRIVILEGES ON suitecrm_db.* TO 'suitecrm_user'@'localhost';
     FLUSH PRIVILEGES;
     EXIT;
     

   Make sure to use a secure password!

5. Run the Installer:

   • Rather than running the installer via your browser, you can use the CLI installer by running the following command in your SuiteCRM directory:

     ./bin/console suitecrm:app:install -u "admin_username" -p "admin_password" -U "db_user" -P "db_password" -H "db_host" -N "db_name" -S "site_url" -d "demo_data"
     

     Adjust the database details accordingly!

Let me know how it goes!

- Bobby