Host Sql plugin

[loudstil]

Repository URL

https://github.com/loudstil/jenkins-sql-plugin

New Repository Name

sql-plugin

Description

A Jenkins plugin that allows you to execute SQL queries and scripts from Jenkins pipelines using configured database connections.

Features

• Execute SQL statements and scripts from Jenkins pipelines
• Support for multiple database types (MySQL, PostgreSQL, SQL Server, Oracle, H2)
• Global configuration of database connections with connection pooling
• Secure password storage using Jenkins Secret management
• Return query results for use in subsequent pipeline steps
• Connection testing and validation
• Detailed logging and error reporting

GitHub users to have commit permission

@loudstil

Jenkins project users to have release permission

dlaettner

Issue tracker

GitHub issues

[jenkins-cert-app]

Security audit, information and commands

The security team is auditing all the hosting requests, to ensure a better security by default.

This message informs you that a Jenkins Security Scan was triggered on your repository.
It takes ~10 minutes to complete.

Commands

The bot will parse all comments, and it will check if any line start with a command.

Security team only:

• /audit-ok => the audit is complete, the hosting can continue 🎉.
• /audit-skip => the audit is not necessary, the hosting can continue 🎉.
• /audit-findings => the audit reveals some issues that require corrections ✏️.

Anyone:

• /request-security-scan => the findings from the Jenkins Security Scan were corrected, this command will re-scan your repository 🔍.
• /audit-review => the findings from the audit were corrected, this command will ping the security team to review the findings 👀. It's only applicable when the previous audit required changes.

Only one command can be requested per comment.

(automatically generated message, version: 1.34.6)

[github-actions]

Hello from your friendly Jenkins Hosting Checker

It appears you have some issues with your hosting request. Please see the list below and correct all issues marked Required. Your hosting request will not be approved until these issues are corrected. Issues marked with Warning or Info are just recommendations and will not stall the hosting process.

• ⛔ Required: Your baseline specified does not meet the minimum Jenkins version required, please update <jenkins.version>2.401.3</jenkins.version> to at least 2.479.3 in your pom.xml. Take a look at the baseline recommendations.
• ⛔ Required: The parent pom version '4.88' should be at least '5.24' or higher.
• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Jira: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Artifactory: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: The following issues have been identified related to plugin dependency management:
  ** The bom version 2543.vfb_1a_5fb_9496d of bom-2.401.x should be updated to the latest version 2745.vc7b_fe4c876fa_
• ⛔ Required: The dependency org.apache.commons:commons-lang3 should be replaced with a dependency to the api plugin io.jenkins.plugins:commons-lang3-api
• ⛔ Required: The 'artifactId' from the pom.xml (sql-plugin) is incorrect, it should be sql ('New Repository Name' field with "-plugin" removed)
• ⛔ Required: Please remove the developers tag from your pom.xml. This information is fetched from this repository on the update site.
• ⛔ Required: Please define the property jenkins.baseline and use this property in <jenkins.version>${jenkins.baseline}.3</jenkins.version> and the artifactId of the bom.
• ⛔ Required: Please define the property hpi.strictBundledArtifacts and set it to true. This should help prevent accidental library bundling when adding and updating dependencies.See Bundling third-party libraries.
• ⛔ Required: Please add a license file to your repo, GitHub provides an easy mechanism to do this from their user interface.
• ⛔ Required: No files found related to automatically updating the plugin dependencies. Please ensure that you have dependabot, renovate or updatecli configured in the repo. A suitable version for dependabot can be downloaded here
• ⛔ Required: Missing file .github/workflows/jenkins-security-scan.yml. This file helps to keep your plugin conform to security standards defined by the Jenkins project. A suitable version can be downloaded here
• ⛔ Required: Missing file .github/CODEOWNERS. Please add this file containing the line: * @jenkinsci/sql-plugin-developers
• ⛔ Required: It seems your Jenkinsfile is not calling buildPlugin.

You can re-trigger a check by editing your hosting request or by commenting /hosting re-check

[jenkins-cert-app]

❌ Jenkins Security Scan failed.
The Security team was notified about this.

[loudstil]

/hosting re-check

[github-actions]

Hello from your friendly Jenkins Hosting Checker

It appears you have some issues with your hosting request. Please see the list below and correct all issues marked Required. Your hosting request will not be approved until these issues are corrected. Issues marked with Warning or Info are just recommendations and will not stall the hosting process.

• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Jira: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Artifactory: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: The following issues have been identified related to plugin dependency management:
  ** The dependency io.jenkins.plugins:commons-lang3-api:3.12.0.0 is covered by the bom. The version should be removed.
  ** The bom version 4136.vca_c3202a_7fd1 of bom-${jenkins.baseline}.x should be updated to the latest version 5054.v620b_5d2b_d5e6
• ⛔ Required: It seems your Jenkinsfile is not calling buildPlugin.

You can re-trigger a check by editing your hosting request or by commenting /hosting re-check

[loudstil]

/hosting re-check

[github-actions]

Hello from your friendly Jenkins Hosting Checker

It appears you have some issues with your hosting request. Please see the list below and correct all issues marked Required. Your hosting request will not be approved until these issues are corrected. Issues marked with Warning or Info are just recommendations and will not stall the hosting process.

• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Jira: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Artifactory: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: It seems your Jenkinsfile is not calling buildPlugin.

You can re-trigger a check by editing your hosting request or by commenting /hosting re-check

[loudstil]

/hosting re-check

[github-actions]

Hello from your friendly Jenkins Hosting Checker

It appears you have some issues with your hosting request. Please see the list below and correct all issues marked Required. Your hosting request will not be approved until these issues are corrected. Issues marked with Warning or Info are just recommendations and will not stall the hosting process.

• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Jira: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: The following usernames in 'Jenkins project users to have release permission' need to log into Artifactory: dlaettner (reports are re-synced hourly, wait to re-check for a bit after logging in)
• ⛔ Required: It seems your Jenkinsfile is not calling buildPlugin.

You can re-trigger a check by editing your hosting request or by commenting /hosting re-check

[loudstil]

/hosting re-check

[github-actions]

Hello from your friendly Jenkins Hosting Checker

It appears you have some issues with your hosting request. Please see the list below and correct all issues marked Required. Your hosting request will not be approved until these issues are corrected. Issues marked with Warning or Info are just recommendations and will not stall the hosting process.

• ⛔ Required: It seems your Jenkinsfile is not calling buildPlugin.

You can re-trigger a check by editing your hosting request or by commenting /hosting re-check

[loudstil]

/hosting re-check