Outreachy: Treeherder Environment SetUp for Backend Issue

[Carla-Moz]

Outreachy Final: Set up environment for fullstack tasks

Project requirements

• Docker & docker-compose
• Dbeaver (an SQL database admin tool - optional)

Clone this treeherder repo from GitHub.

Follow the documentation:

Treeherder docs for server and fullstack development

The following provides a basic set up walk-through. Please use the docs for more detailed information.

Running treeherder and perfcompare:

Run: docker-compose up --build Run: Import query for data (See sample database setup) Then, change this line: https://github.com/mozilla/perfcompare/blob/main/src/logic/treeherder.ts#L9 To: 0.0.0.0:5000 Rerun:docker-compose up

Database setup

Connection for postgresql: Serverhost: localhost Port: 5432 Database: treeherder User=postgres Password: mozilla1234

Link to Julien’s SQL: https://drive.google.com/file/d/12Yx1llWDFEtq957Ck8sLFBkZp10sKJyt/view?usp=drive_link

Command to load Julien’s SQL: step 1: gunzip treeherder.sql.gz

You'll need to install psql for that:

• MacOS: brew install libpq
• Linux Debian or Ubuntu: apt install postgresql-client
• Linux Fedora: dnf install postgresql-client

Loading using Dbeaver: step 1: download the SQL script above step 2: After you've downloaded Dbeaver and established a connection, go to SQL Editor in the menu bar step 3: Go down to Import SQL script and click it step 4: Open the downloaded SQL script

[FatumaA]

Hi, The command here should be docker-compose up --build with two dashes 😊

Edit: In case anyone is having trouble at this part:

Command to load Julien’s SQL: step 1: gunzip -c treeherder.sql.gz or gunzip zcat treeherder.sql.gz step2: psql -h localhost -U postgres -W < treeherder.sql

You should drag the decompressed sql file to the root of the Treeherder before running step two