On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs. NOTE: We are in the process of modifying the configuration for many Bitnami stacks. Linux and macOS native installer users can identify which database server is used in the stack by running the command below: $ test -d installdir/mariadb & echo "MariaDB" || echo "MySQL" On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. Windows native installer users can identify which database server is used in the stack by checking for the presence of the installdir/mariadb directory. If present, the installer uses MariaDB and if not, it uses MySQL.ĭepending on which database server (MySQL or MariaDB) is used by the installation, use the appropriate guides in our documentation for database-related operations. IMPORTANT: Bitnami Native Installers do not modify the firewall configuration of your computer, therefore the Redmine ports could be open which is a significant security risk. To connect to your database server remotely using the MariaDB client, follow these steps: Windows, Mac OS X, Linux You are strongly advised to close the Redmine ports (refer to the FAQ for more information on this). #BITNAMI REDMINE EXTERNAL DATABASE MAC OS# Use the following command, remembering to replace PASSWORD with the application password from the first step: $ installdir/mariadb/bin/mariadb -u root -p -e "grant all privileges on *.* to identified by 'PASSWORD' with grant option" For example, if you are using ufw, you would run the following commands (on Linux only): $ sudo ufw allow 3306/tcpĮdit the MariaDB configuration file and find the line containing: bind-address=127.0.0.1Ĭomment out this line by placing a hash (#) symbol at the beginning, so that it looks like this: #bind-address=127.0.0.1Īt the server console, allow remote access to the database server using the command line client. When prompted for a password, enter the password you entered during the installation process. Restart the database server using the graphical manager ( Windows and macOS or by executing the following command at the server console (Linux): $ sudo installdir/ctlscript.sh restart mariadb #BITNAMI REDMINE EXTERNAL DATABASE PASSWORD# You can then connect to the database server using a command like the one below. This is the same as the application password. Select the “Network” tab, then click “Add”. On the resulting dialog, enter 3306 as local and remote port. Active the “Require local” and “Over SSH” checkboxes, and click “Ok” to save your changes. On the “Network” section, you will see an SSH tunnel to the 3306 port enabled. If the connection is successful, click “OK” to save the connection. You will be prompted to enter the root user password. This is the same as the application password.I am currently trying to upgrade our (old) redmine system to the latest version 2.6.1. #BITNAMI REDMINE EXTERNAL DATABASE UPGRADE# Our existing redmine solution is of version 1.2.0. (I know, this version is already somewhat "aged".until now there was no need and reason for us to update it.never change a running system). I already worked through different forum threads and the installation guides but still I need help.Įverywhere is mentioned to make a back up of the existing Mysql database.īut where is it located in version 1.2.0? What are the actual data base files that are used?Īnd listing all the databases, it shows me the following: #BITNAMI REDMINE EXTERNAL DATABASE UPDATE# usr/bin/mysqldump -u -p | gzip > /path/to/backup/db/redmine_`date +%y_%m_%d`.gz When I make a backup if this database using Now, I would think that the database redmine uses is "redmine". The resulting backup is only very small (>2kb) and is basically empty. #BITNAMI REDMINE EXTERNAL DATABASE PASSWORD#.#BITNAMI REDMINE EXTERNAL DATABASE UPGRADE#.#BITNAMI REDMINE EXTERNAL DATABASE UPDATE#.#BITNAMI REDMINE EXTERNAL DATABASE MAC OS#.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |