Tags: confluenceConfluence's Installation Wizard will guide you step-by-stage in configuring the MySQL database in confluence.Using a JDBC connection (default)JDBC is the recommended way to connect your confluence to the database.The Confluence Installation Wizard will provide you with the following 2 connection options:
Simple --this is the simplest way
Tags: confluenceFor confluence installations that already exist, if the version of Confluence you installed is 6.4 or earlier, we did not check the character settings of your database when installing.If your database is not currently configured to use UTF-8 encoding (or the same encoding as UTF-8, for example, Al32utf8
Tag: Configure the Use ISP ATT page to follow the type any sub-category LSPThis section describes the tables used to store content in confluence. Content is information that users store and share in confluence.
attachmentdata
Binary data for the attachment file. This table is the only table used when the conflue
Tags: name home spl count contain include download TE mbed In order for your confluence to be used without any external databases after the installation is successful, confluence uses an embedded H2 database. When you choose to evaluate and test the confluence, the H2 database
Tags: confluenceDifferent databases typically require different SQL checksum queries. Validation queries often need to be as simple as possible, and this query is executed once when the link is removed from the database connection pool.For different database types, we recommend the first check query SQL:
Mysql
select 1
Microsoft SQL
The following table stores information about user authorization, in part through the Atlassian Crowd framework embedded in confluence.
cwd_user
Information for each user in the confluence.
cwd_group
The user group to which each user belongs.
cwd_membership
Mappings between users and groups of users.
Tags: confluenceIn your database setup interface, there is a test connection button to check:
Confluence can connect to your database server
Whether the encoding of the database character set is correct
Does your database user have the correct permissions to acce
Tags: confluenceLimitations of database ConsolidationNote: Confluence's own XML-mode export method does not apply to backing up and consolidating large datasets. Here are some third-party database tools you can use to help you back up and consolidate big data sets. If you need help choosing the right tool, or if you need help integrating the process, you can contact Atlassian experts for guidance.Database c
Tags: sort shared data RSA table clust how def www firThe following table contains information about using the cluster with the confluence site.
clustersafety
In the usual case, the table has only one record. safetynumberthe value of confluence is used to find other confluence sites, which are shared
Please check the supported Platforms page for the MySQL database version supported by the confluence system. You need to upgrade your MySQL database before installing confluence.
If you migrated from another database to a MySQL databa
Tags: confluenceYou can use the JDBC URL or a JNDI data source to connect confluence to your database.In the default Setup wizard, only the use of the JDBC database connection option is provided, which is also the recommended database connection option.If you want to use the Jdni data source, please refer to the content in configuring a DataSource connection for
Tags: BSP site System Information record SPL tables sort code nbspThese tables have information about the state in which the data is stored and the configuration of the confluence site.
confversion
Used to make sure that the version of the database should be used when upgrading the system, which only affects the database
After creating the user and assigning permissions:
Use sqlplus command line tools to access Oracle from the command line
sqlplus user/password
If your logged-in user is using ' sys ' you need to determine what SYSY permissions you want to use as SYSDBA or as Sysoper.
Creates a confluence user (for example, confluenceuser ) and gives the user only the following permissions:
Please review the supported Platforms page for an Oracle database version supported by the confluence system. You need to upgrade your Oracle database before installing confluence.If you are migrating from another database to using an Oracle database, including migrating fro
Tags: Isolation server CTI Isolation level href ase button www nextIn your database setup interface, there is a test connection button to check:
Confluence can connect to your database server
The database character set and isolation level are correct
Your database
Tags: ISP enc jar class sort href splay www. WwwThese tables have information about the state in which the data is stored and the configuration of the confluence site.
confversion
Used to make sure that the version of the database should be used when upgrading the system, which only affects the database
Tags: confluencePlease check the supported Platforms page for the MySQL database version supported by the confluence system. You need to upgrade your MySQL database before installing confluence.If you migrated from another database to a MySQL database, including migrating fr
; "title=" Image007.png "width=" "height=" "272" border= "0" hspace= "0" vspace= "0" alt= " Wkiol1igs-qwixeaaaathpvsd-0346.png "/>Save the configuration file and restart the system for the computer name to take effectModify the system timeRm-rf/etc/localtimeYum Install-y ntpdateNtpdate us.pool.ntp.orgLn-s/usr/share/zoneinfo/asia/shanghai/etc/localtimeInstalling the DatabaseYum install MySQL mysql-server mysql-devel-yConfiguration databaseService mysqld Startmysqladmin-u root password ' new passw
Database Character Set encodingYour database and JDBC data source connections must be configured to use UTF-8 encoding (or to develop the correct UTF-8 coded character set based on the database you have configured, such as Al32utf8 in Oracle). There are also multiple checks in confluence to make sure that your
Tags: splay port row Data tab Display WWW requires a lot of XMLNote: It usually takes a lot of time to select a suitable database. Also, Confluence's own XML data backup and recovery capabilities are often not suitable for merging and backing up databases with large amounts of data. If you want to merge data after the system is running, you usually need to use a third-party database management and Consolida
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.