How to launch MySQL, PostgreSQL, MongoDB, Cassandra, & Apache Airflow in your Course using SN Labs
The Skills Network Toolbox is a built-in extension that helps you efficiently and easily interact with a number of technologies inside the Skills Network Cloud IDE. Some of these features include the ability to launch MySQL, PostgreSQL, MongoDB, Cassandra, & Apache Airflow from the click of a button. Additionally, the admin tools phpMyAdmin (for MySQL), pgAdmin (for PostgreSQL), mongo-express (for MongoDB), and Airflow Webserver (for Apache Airflow) are available in these environments.
To open the Toolbox, click the Skills Network logo on the left sidebar. You will see a number of dropdowns that you can explore. Click on your selected database or application within the dropdown and hit the Start button to launch it.
Troubleshooting
- Stop all your applications with the Stop button, until every application has an Inactive or Error status. Close all the tabs in the main area of the IDE. Refresh your browser tab and try again.
- Start your applications manually with the following instructions under Launching Manually.
- Submit a support ticket using the blue Support/Feedback button on the right of your window.
Launching Manually
1. Open the Terminal
From the Menu at the top, select Terminal > New Terminal. This will open a Terminal at the bottom of the screen.
2. Enter the "start" command in the Terminal
In the terminal enter one of the following commands:
start_postgres
- Starts postgres database and pgadminstart_mysql
- Starts mysql database and phpmyadminstart_mongo
- Starts mongo database and mongostart_cassandra
- Starts cassandra database- start_airflow - Starts airflow services (This will boot up airflow and an accompanying PostgresSQL container for you to use)
3. Read and follow the outputting instructions
- Username
- Password (this is randomized everytime you launch a new Theia tool)
- URL for admin console
- CommandLine example to connect to the database