About Bamboo download
This page describes how to connect Bamboo to a MySQL database.On this page: The JDBC driver for MySQL 5.1 (JDBC Connector/J 5.1) is no longer bundled with Bamboo. You must download and install the driver yourself.See Supported platforms for other information about the versions of MySQL supported by Bamboo.1. Creating and Configuring the MySQL databaseFor your external MySQL database to work well with Bamboo, it must be able to use the following:utf8 or utf8mb4 character set encoding instead of latin1utf8_bin or utf8mb4_bin collationthe InnoDB storage engine(recommended, not required) lower_case_table_names=1 Setting lower_case_table_names=1 might break other Atlassian applications. For more information, see the steps.global transaction isolation level as READ_COMMITTEDDisable NO_AUTO_VALUE_ON_ZERO mode.We also recommend that your MySQL database server is configured to use an InnoDB storage engine. Alternatively, you can configure Bamboo's JDBC connection to your MySQL database so that any tables that Bamboo creates in this database will be done using the InnoDB database engine.A MySQL database administrator can easily create and configure a MySQL database for Bamboo by running the following MySQL commands: Create a MySQL 8.0 database with utf8 character encoding... mysql> CREATE DATABASE bamboo CHARACTER SET utf8 COLLATE utf8_bin;mysql> CREATE USER 'bamboouser'@'localhost' IDENTIFIED BY 'password';mysql> GRANT ALL PRIVILEGES ON bamboo.* TO 'bamboouser'@'localhost' WITH GRANT OPTION;mysql> FLUSH PRIVILEGES;mysql> QUIT Create a MySQL 8.0 database with utf8mb4 character encoding... mysql> CREATE DATABASE bamboo CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;mysql> CREATE USER 'bamboouser'@'localhost' IDENTIFIED BY 'password';mysql> GRANT ALL PRIVILEGES ON bamboo.* TO 'bamboouser'@'localhost' WITH GRANT OPTION;mysql> FLUSH PRIVILEGES;mysql> QUIT bamboouser — the user account name for the Bamboo MySQL database. This creates an empty MySQL database for Bamboo named bamboo, where:localhost — the host name of the MySQL database serverpassword — the password for this user accountFor more information about configuring character set encoding and collation for Bamboo MySQL databases, refer to the MySQL 5 documentation — Specifying Character Sets and Collations. To verify if the NO_AUTO_VALUE_ON_ZERO mode is disabled, run this query on your MySQL server: SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; The first mode is the mode for the session, the second is the global settings for MySQL. If the global mode contains NO_AUTO_VALUE_ON_ZERO, it has to be removed as explained in the MySQL documentation.2. Connecting Bamboo to the MySQL databaseYou can connect Bamboo to the MySQL in one of the following ways:using JDBCusing a datasource JDBC is generally simpler and we recommend using it.Connect using JDBC1. Download and install the JDBC driverThe JDBC drivers for MySQL Enterprise Server are no longer bundled with Bamboo (due to licensing restrictions). You need to download and install the driver yourself.Download the MySQL Connector/J JDBC driver 5.1 or 8 from the download site. In MySQL 8, the com.mysql.jdbc.Driver class implementing java.sql.Driver in MySQL Connector/J was deprecated. Instead, you should use the com.mysql.cj.jdbc.Driver class.Extract the downloaded zip/tar.gz file.Copy the mysql-connector-java-XX.XX-bin.jar file from the extracted directory to the /lib directory (create the lib/ directory if it doesn't already exist). If you are using the Java Service Wrapper to start your Bamboo instance (Bamboo/wrapper/run-bamboo start), copy the mysql-connector-java-XX.XX-bin.jar file to
Key features of the Bamboo download that are enabled through these drivers include:
- Log in as a Bamboo user - Corel Bamboo
- Amazon.com: Bamboo Roman Shades - Bamboo
- What is Bamboo and use cases of Bamboo?
- Bamboo Paper - Bamboo Renewable Resource
- Bamboo Toilet Paper - EcoPlanet Bamboo
- What is Bamboo? – American Bamboo Society
- Bamboo Trivet Kitchen Bamboo Hot Pads Trivet Natural Bamboo
A separate home directory for each agent installation. 1. Enable remote agent supportFrom the Bamboo header select > Build resources > Agents.Select either Enable Remote Agent Support or Disable Remote Agent Support.Read more about enabling and disabling remote agent support here. 2. Download and install the remote agentCreate a directory on the agent machine (e.g. bamboo-agent-home) to serve as the Bamboo agent home for the remote agent.From the Bamboo header select > Build resources > Agents.The Agents screen displays showing the lists of all local agents and all remote agents that currently exist on your Bamboo system.If not already enabled, select the Enable remote agent support link.Select Install remote agent. The Installing a remote agent screen will display.Select DOWNLOAD Remote Agent JAR and save the JAR file to the directory on the agent machine that you created above.Copy the command under Running a Remote Agent to the clipboard for use in Step 3 that follows.3. Launch the remote agentOnce installed, run the remote agent by executing the command line obtained above. This command will look something like this: java -jar atlassian-bamboo-agent-installer-X.X-SNAPSHOT.jar Where X.X represents your Bamboo version number. The name of the jar file, for example, atlassian-bamboo-agent-installer-5.4-SNAPSHOT.jar, will vary depending on the version of Bamboo you are running.You can run the remote agent with a number of additional command line parameters. Configuration options include remote agent data storage, capability detection and logging, suppression of self-signed certificate and running without the Remote Agent Supervisor or with different start-up commands.See Additional remote agent options for more information.4. Configure the remote agent's capabilitiesAll remote agents feature a capability that can be defined. Examples include an executable, such as Maven, a JDK, a DVCS client or a custom capability. They typically define the path to an executable that has already been installed, and must be defined in Bamboo before Bamboo or its agents can make use of them.Capabilities can be defined specifically for an agent, or shared between all local or all remote agents.See Configuring capabilities for more on defining capabilities.
