No results found

Your search did not match any results.

We suggest you try the following to help find what you're looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try "application" instead of "software."
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
 

Deploying Joomla! on OCI and MDS

The easiest way to deploy Joomla! on Oracle Cloud Infrastructure and MySQL Database Service, is to use OCI Resource Manager’s stack.

Author: Frédéric Descamps

Updated:

About Frédéric Descamps



@lefred has been consulting OpenSource and MySQL for 20+ years. After graduating in Management Information Technology, Frédéric started his career as a developer for an ERP under HPUX.

More tutorials from this author:
Deploy Moodle on OCI with MDS
Use Matomo Website Analytics on OCI with MDS
How to import data from Microsoft SQL Server to MySQL Database Service
Deploying Joomla! on OCI and MDS

Tags

oci mysql

Back to tutorials

The easiest way to deploy Joomla! on Oracle Cloud Infrastructure and MySQL Database Service, is to use OCI Resource Manager’s stack.

Let’s see how easy it is to deploy such solution.

If you don’t already have an OCI account, you can get started for free.

The easiest way to deploy all the required resources (vcn, subnets, gateways, compute and MySQL instances, security lists, …) is to use a stack for Resource Manager. It consists in Terraform modules and information to easily deploy the architecture on OCI.

To deploy Joomla! and a MDS instance, visit this GitHub repo and click on the button to deploy on OCI:

A callout highlighting the deploy button for Joola found in the OCI-Joomla repo

The Oracle Cloud Dashboard will be open and the stack creation form will be loaded like this:

OCI's Create Stack page, with a callout highlighting to the user to accept Oracle's terms of use

As soon as we accept the Oracle Terms of Use, the form will be automatically filled with the stack’s information:

The form to create a stack automatically completes with information to create your stack with Joomla. A callout displays highlighting the page's Next button

We can click on Next to reach the second form dedicated to the variables:

A secondary form in the stack-creation process to configure the stack's variables

As you can see some variables are already pre-filled. We need to enter some mandatory ones like the password the MDS admin password.

We also have the possibility to enable HA for the MySQL Database Service instance, to have multiple webservers in case we want to have multiple Joomla! in front on the same database or multiple Joomla! with multiple dedicated databases… there are different possibilities.

We also have the possibility to use existing resources in case you already created an architecture in OCI and you want to use it for Joomla! too.

The form to use existing variables to use with your Joomla-equipped stack

When we are ready, we click Next and the review summary screen appears:

The review summary screen for creating the stack

When we apply the stack, OCI will create a job to create all the resources and deploy everything that we need. This will take some minutes (+/- 10min):

Job details after creating the stack with a banner communicating the only partial logs may appear while the stack is being created

When everything is created and deployed, the job will return a status:

Job Information panel with complete job status message

All the required information to finish the installation is reported in the Outputs section:

Information to complete Joomla installation can be found in the Outputs tab

Now we can paste the public IP (joomla_public_ip) in our Internet browser:

Browser with partially obscured IP address in the address bar and Joomla displaying in the main browser window

After we enter the required information, we click Next to reach the database configuration form:

Joomla's Database Configuration window with complete forms, including database name and table prefix, and username, among other fields

We enter all the information from the stack’s outputs section. As the database is not local to Joomla!, we also need to delete a file for security reasons.

To connect to the Joomla! server, we need to use the generate ssh key (you can get it from the Outputs section) and connect to the public IP with the opc user. Then we need to remove the file generated by Joomla!’s installation wizard:

Terminal highlighting SSH key needed to connect with Joomla

When this is done, we can continue with Joomla!’s installation:

Third step in Joomla configuration process, specifying FTP details Success message in Joomla after installing it

To finish the installation, we need to delete the installation folder:

Terminal with command to delete Joomla's installation folder

And here we go, Joomla! is installed:

Joomla succcess message for installation

The administration dashboard is also available on /administrator/:

Obscured IP address with /administrator/ in its path, Joola dashboard in main browser window

As you can see, deploying Joomla! on OCI to use MySQL Database Service is very easy. The most complicate operation if to remove the files and folders during the installation.

Enjoy MySQL!