Убрать символы "&" из пароля базы данных Sonar (main, develop) и LuckPerms (main) #402

New issue

Closed

opened 2026-04-30 19:48:40 +00:00 by cuqmbr · 0 comments

cuqmbr commented

2026-04-30 19:48:40 +00:00

Owner

Ошибка в консоли:

> sonar reload
[19:46:12 INFO]: Bebrashield Bot Protection » Reloading Sonar...
[19:46:12 INFO] [sonar]: Using system language (EN) for translations.
[19:46:12 INFO] [sonar]: Taking cached snapshots of all packets...
[19:46:12 INFO] [sonar]: Preloading all registered packets...
[19:46:12 WARN] [net.skinsrestorer.shadow.mariadb.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES)
[19:46:12 WARN] [xyz.jonesdev.sonar.libs.mariadb.jdbc.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES)
[19:46:12 INFO]: Bebrashield Bot Protection » Successfully reloaded (89ms)
[19:46:12 WARN] [net.skinsrestorer.shadow.mariadb.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES)
[19:46:12 WARN] [xyz.jonesdev.sonar.libs.mariadb.jdbc.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES)
[19:46:12 ERROR]: java.sql.SQLInvalidAuthorizationSpecException: (conn=13234) Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.export.ExceptionFactory.createException(ExceptionFactory.java:313)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.export.ExceptionFactory.create(ExceptionFactory.java:402)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.authenticationHandler(StandardClient.java:513)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.handleAuthentication(StandardClient.java:395)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.setupConnection(StandardClient.java:189)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.<init>(StandardClient.java:157)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.Driver.connect(Driver.java:75)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.Driver.connect(Driver.java:104)
[19:46:12 ERROR]:       at net.skinsrestorer.shadow.mariadb.Driver.connect(Driver.java:29)
[19:46:12 ERROR]:       at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
[19:46:12 ERROR]:       at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConnectionSource.java:139)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.jdbc.JdbcPooledConnectionSource.getReadWriteConnection(JdbcPooledConnectionSource.java:139)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.jdbc.JdbcPooledConnectionSource.getReadOnlyConnection(JdbcPooledConnectionSource.java:114)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:249)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:286)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:384)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.libs.ormlite.stmt.Where.query(Where.java:519)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.api.database.controller.VerifiedPlayerController.clearOld(VerifiedPlayerController.java:161)
[19:46:12 ERROR]:       at xyz.jonesdev.sonar.api.database.controller.VerifiedPlayerController.lambda$new$1(VerifiedPlayerController.java:121)
[19:46:12 ERROR]:       at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[19:46:12 ERROR]:       at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[19:46:12 ERROR]:       at java.base/java.lang.Thread.run(Unknown Source)
>

Вместо символов "&" в пароле вставлены строки "_SONAR_DB_PASSWORD_".

Из мануала к sed:

s/regexp/replacement/
       Attempt  to match regexp against the pattern space.  If successful, replace that por‐
       tion matched with replacement.  The replacement may contain the special  character  &
       to  refer to that portion of the pattern space which matched, and the special escapes
       \1 through \9 to refer to the corresponding matching sub-expressions in the regexp.

sed -i "s/_SONAR_DB_PASSWORD_/${SONAR_DB_PASSWORD}/g" plugins/sonar/config.yml && \

Ошибка в консоли: ``` > sonar reload [19:46:12 INFO]: Bebrashield Bot Protection » Reloading Sonar... [19:46:12 INFO] [sonar]: Using system language (EN) for translations. [19:46:12 INFO] [sonar]: Taking cached snapshots of all packets... [19:46:12 INFO] [sonar]: Preloading all registered packets... [19:46:12 WARN] [net.skinsrestorer.shadow.mariadb.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES) [19:46:12 WARN] [xyz.jonesdev.sonar.libs.mariadb.jdbc.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES) [19:46:12 INFO]: Bebrashield Bot Protection » Successfully reloaded (89ms) [19:46:12 WARN] [net.skinsrestorer.shadow.mariadb.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES) [19:46:12 WARN] [xyz.jonesdev.sonar.libs.mariadb.jdbc.message.server.ErrorPacket]: Error: 1045-28000: Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES) [19:46:12 ERROR]: java.sql.SQLInvalidAuthorizationSpecException: (conn=13234) Access denied for user 'proxy_sonar'@'172.18.0.15' (using password: YES) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.export.ExceptionFactory.createException(ExceptionFactory.java:313) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.export.ExceptionFactory.create(ExceptionFactory.java:402) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.authenticationHandler(StandardClient.java:513) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.handleAuthentication(StandardClient.java:395) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.setupConnection(StandardClient.java:189) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.client.impl.StandardClient.<init>(StandardClient.java:157) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.Driver.connect(Driver.java:75) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.Driver.connect(Driver.java:104) [19:46:12 ERROR]: at net.skinsrestorer.shadow.mariadb.Driver.connect(Driver.java:29) [19:46:12 ERROR]: at java.sql/java.sql.DriverManager.getConnection(Unknown Source) [19:46:12 ERROR]: at java.sql/java.sql.DriverManager.getConnection(Unknown Source) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConnectionSource.java:139) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.jdbc.JdbcPooledConnectionSource.getReadWriteConnection(JdbcPooledConnectionSource.java:139) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.jdbc.JdbcPooledConnectionSource.getReadOnlyConnection(JdbcPooledConnectionSource.java:114) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:249) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:286) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:384) [19:46:12 ERROR]: at xyz.jonesdev.sonar.libs.ormlite.stmt.Where.query(Where.java:519) [19:46:12 ERROR]: at xyz.jonesdev.sonar.api.database.controller.VerifiedPlayerController.clearOld(VerifiedPlayerController.java:161) [19:46:12 ERROR]: at xyz.jonesdev.sonar.api.database.controller.VerifiedPlayerController.lambda$new$1(VerifiedPlayerController.java:121) [19:46:12 ERROR]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [19:46:12 ERROR]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [19:46:12 ERROR]: at java.base/java.lang.Thread.run(Unknown Source) > ``` Вместо символов "&" в пароле вставлены строки "\_SONAR_DB_PASSWORD\_". Из мануала к sed: ``` s/regexp/replacement/ Attempt to match regexp against the pattern space. If successful, replace that por‐ tion matched with replacement. The replacement may contain the special character & to refer to that portion of the pattern space which matched, and the special escapes \1 through \9 to refer to the corresponding matching sub-expressions in the regexp. ``` --- https://git.cuqmbr.xyz/bebrashield/server-proxy/src/commit/c1b2c33e335f4a6ff39059c5fcaf191f1c50c28e/Dockerfile#L157

cuqmbr added the

labels

2026-04-30 19:48:40 +00:00

cuqmbr changed title from ~~Убрать символы "&" из пароля базы данных Sonar~~ to Убрать символы "&" из пароля базы данных Sonar (main, develop) и LuckPerms (main)

2026-04-30 19:52:59 +00:00

cuqmbr referenced this issue from bebrashield/infra

2026-05-01 13:38:06 +00:00

bug-402-mariadb-passwords-ampersand-fix #34

cuqmbr added this to the Сезон 2 project

2026-05-01 14:21:15 +00:00

cuqmbr closed this issue

2026-05-01 14:21:21 +00:00