Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×Hi, I want to know about connector. We have mysql-connector-java-5.1.46-bin.jar. Will it be supported by default for 9.2.1? Do I need to download separately new one? I also saw rpm package but c...
I want a list of jiras created against each issue type under all the project from jan 2024. I am using below sql but it doesn't return list of those issue types where no jira was created from above m...
Hi! I'd like to know if Jira Data Center can run with a 8.4 version of MySQL. Thanks
Hi, We’ve reached the end of support for Confluence 7.18.1, so we are planning to upgrade to Confluence 8.9.6. During the upgrade process, we discovered that we need to upgrade MySQL from version 5...
My company is redoing a JSM DC instance to a Debian 12 machine, we're having BIG trouble trying to get it to work. (atlassian-servicedesk-5.17.1-x64.bin) Whenever we try to setup the DB (Mysql...
I use a 8.0 MySQL databases with data. I would like to recover data into ASSETS because I would like to create links between some data and have a graphical schema. I saw that we can use External S...
Hello Atlassian Community, I am currently developing a web application that integrates with Bamboo. The application needs to programmatically determine which projects and plans a specific user has a...
Im looking a sequel query in mysql to fetch the below listed feilds in confluence spaces and pages . created by last modified /last updated date last viewed number of views incoming and o...
We are using Jira and Confluence Data Center and we want to find the list of Users that have a failed login in a certain time period (For exp: from 01-12-2020 to 20.02.2024) I found this query that ...
Hi we would like to automate several SSO/SAML configuration, to export from and re-import to the SQL database (MySQL). Do you know which data (tables/columns/values) to export to get the c...
I am looking for database query to get a list of all users based on internal groups who has access to restricted pages and also to list of all users who has access to unrestricted pages. So what woul...
Team, we have a requirement to find 400 users associated date like no of projects user has access, assigned issue, reported issues, account active or not, user last login
I am trying to build out a query that counts the number of users who can access each Space in Confluence. So far I have the following: SELECT DISTINCT s.spacename as Space, COUNT(u.di...
...essage: /bin/mysql: Argument list too long update BODYCONTENT from body = '[all xhtml code]' where contentid = XXXXX; Do you know how to do it? I am using Confluence 7.19.9 and MySQL 8.&n...
I'm looking for a solution that would help me wo get all the JIRA Cloud data into my local MySQL. Expectations It should periodically automatically refresh/update the data in the local database.&n...
...onnect to msyql and create those databases, but I thought it might be easier to define multiple containers with mysql databases for each up to N processes. Is there a way to to use more t...
Hi all, Similar issue that i am also facing from long time. Error message is: The table collation: 'Latin1_General_CS_AS' is unsupported by Jira. The Database collation: 'SQL_Latin1_General_CP437_C...
Hi I want to get list of attachments with author names and labels, but I can't find necessary attribute to get this info. As a start I have use this information https://confluence.atlassian.com/con...
I am a new user of pipeline. I really don't understand why I get the error "bash: mysql: command not found" with my pipeline script. The mysql client is well installed ?! Is there someone to help m...
....querySpecification(MySqlParser.java:29764) \n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.selectStatement(MySqlParser.java:25248) \n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser...
....JIRASQLPerformance \ YOUR_DB_USERNAME YOUR_DB_PASSWORD \ JDBC_CONNECTION_STRING JDBC_DRIVER_CLASS \ > db-perf-test.txt I am on Red Hat Enterprise Linux Server release 6.5 (Santiago) mysql5.7 I...
Since this is reported as a generic 'something-is-wrong' error message, I suspect it may be related to the errors that I see in the catalina.out: https://opencalaccess.org/misc/atlassian_error_20220...
Upgrading MySQL database from 5.6 to 5.7 to 8.0 for the most recent Confluence version (7.19). The setup of the database, confluence installation and the database connection are all s...
Hi, I'm developing an app for our cloud hosted Jira instance using Forge. I'm trying to connect the app to a MySQL database and pull + display some relevant information next to our tickets. I have MySQL...
...est --coverage script and the error is mysql connection refused on all of the failed test cases. My application framework is Laravel. I scoured the internet looking for answer before posting this q...
Copied to clipboard