![]() The codeBeamer database user ("cbroot") needs sufficient permissions to create stored procedures. It might be also necessary to change SELinux systems to permissive mode using: setenforce Permissive. " is necessary due to a bug in some MySQL versions, where ALL PRIVILEGES doesn't include FILE. GRANT FILE, PROCESS ON *.* TO PRIVILEGES GRANT ALL PRIVILEGES ON codebeamer.* TO IDENTIFIED BY 'cbpassword' When asked provide it with the password which was configured during installation.ĬREATE DATABASE codebeamer default character set 'utf8' default collate 'utf8_general_ci' Execute the command: mysql -u root -p.Open a command prompt (on Windows execute "cmd"), and go into your$MYSQL_HOME$/bin directory (for example in Windows it could be C:\Program Files\MySQL\MySQL Server 5.1\bin).You can use any username and password instead of the cbroot and cbpassword used below: In order for codeBeamer to access a MySQL database, an appropriate database schema and user have to be prepared. In the following examples, it is assumed that the database is running on the same machine as codeBeamer ( localhost) and listens to default port 3306, but this is not required. These steps are only necessary when upgrading or migrating codeBeamer, or when the database is created manually for any other reason. However if you use an earlier version for legacy reasons please make sure InnoDB is configured.Ĭreating the database Following the introduction of the post-installation wizard in version 7.6.0, the following steps are not required for new installations, because the database is created automatically. With MySQL 5.5 (and later), InnoDB becomes the default storage engine, therefore no transaction support configuration is required. From MySql 5.5.x the option below is required to avoid Thread stack overrun:. ![]() Allow using up to 128MB large attachments.in Windows: C:\Program Files\MySQL\MySQL Server 5.5, or Linux/Unix: /etc/mysql/my.cnf, or MAC-OS: /usr/local/mysql/my.cnf). You can find these settings in my.ini, that typically resides in the MySQL installation directory (e.g. Please ensure that the following settings are configured in your database. When installing MySQL, be sure to set and remember a sensible root password. Install MySql via your distribution's package manager. We recommend installing the latest recommended release for your platform. ![]() Please refer to the MySQL homepage for instructions. Windows, Unix, MAC-OSĭownloading and installing the MySQL database is not part of this document. Also ensure that during migration nobody uses the database, because it may cause loss of data. IMPORTANT: Backup your data! Before doing anything, backup your existing database. To use this document you should be familiar with MySQL database setup and administration. Currently MySQL 5.7.x is supported and InnoDB storage engine is required. This page describes how to setup a MySQL for codeBeamer. It is strongly recommend using codeBeamer with MySQL or Oracle because they are faster and more robust databases. Preparing the MySQL Database for InstallationĬodeBeamer is delivered with a Derby database that should be used only for evaluation purposes. IMPORTANT: This page is deprecated and will be removed soon because the user is now able to set up their databases during the installation processes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |