Accessing Databases Using Config Files in Reclaim Cloud

After you install an application to your environment, say through WordPress or Mattermost, you'll receive a few confirmation emails with passwords to various portions of the site. You'll want to save these credentials but delete the email. You can use this method as well to access your node through Reclaim Cloud. This article goes through working with WordPress and Mattermost, but it does work with most applications. 

Accessing the Database Node

First, however, the biggest step is to access the database node within your browser. You can access this a number of ways, first by going to the URL and using the specific port number. So for instance WordPress you can use env-3224720.us.reclaim.cloud:8443

You can also access it through a node if it is a separate instance within your environment like node9764-env-2948928.us.reclaim.cloud, you can use this when working with PostgreSQL too for Mattermost.

Once you've loaded the URL you should see a login screen:

Locating Credentials

If you don't have the credentials that were sent via email after the Jelastic, you can also locate the credentials within the site's configuration files.

You'll want to navigate to the file management system within your Cloud Dashboard, but you can also use WebSSH if you'd like. This will walk you through the file management system.

WordPress

For WordPress, you'll want to work through your wp-config.php file within /var/www/webroot/ROOT/wp-config.php

Connection settings should look like this:

// ** Database settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define( 'DB_NAME', 'wp_7698727' );

/** Database username */
define( 'DB_USER', 'jelastic-6599005' );

/** Database password */
define( 'DB_PASSWORD', 'vsecurepassword' );

/** Database hostname */
define( 'DB_HOST', '127.0.0.1' );

/** Database charset to use in creating database tables. */
define( 'DB_CHARSET', 'utf8' );

/** The database collate type. Don't change this if in doubt. */
define( 'DB_COLLATE', '' );

You'll use the DB_USER and the DB_PASSWORD to access cPanel from there to access PHPMyAdmin.

Mattermost

Mattermost is just a bit different! Since this is using PostgreSQL, the location varies on the file. You'll want to navigate to the /root/mattermost/congfig/config.jsonfile.

The username, password, and database name are located on the DataSource line under SqlSettings. Should look like:

"DataSource": "postgres://webadmin:nky9FicDb4@sqldb:5432/mattermost?sslmode=disable\u0026connect_timeout=10",

 

Once you're logged in you're good to go! You can make changes to the database like you would through the user interface, like changing a siteURL or homepageURL or grabbing an export of the database.

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Reclaim Hosting Support Hours
8:00 am - 5:00 pm ET, Monday through Friday
Submit a Ticket
Get a quick and helpful response from the pros.
Need Extra Support?
No problem, we're here to help! Talk to us about Professional Services.