llamaCVEVulnerability Intelligence
/
Advisory · GitHub · RubyGems · activerecord

GHSA-HQ7P-J377-6V63

SQL Injection Vulnerability via ActiveRecord comments

Parche disponible
Descargar PNG JSON
CVSS
—
high
Fuente: —
ExplotaciónSin evidenciaNo figura en CISA KEV
Exploits públicos0Ninguno conocido
Parche3 versionesPrimer parche a -1 d de la divulgación
Exposición1.402 dDesde la divulgación, 18 ene 2023, 1:20 p. m.
Detección1.398 dDesde la divulgación hasta su ingreso al índice
Timeline

Ciclo de vida de la vulnerabilidad

Hoy
Divulgación
Publicada
Modificada
Explotación
Remediación
Parche 6.0.6.1 +2
Monitoreo
Detectada
17 ene 23
18 ene 23
21 feb 24
17 nov 26
20 nov 26
17 ene 23
3 ene 24
19 dic 24
5 dic 25
20 nov 26
FechaFaseEventoDetalle
Remediación Parche 6.0.6.1 activerecord · -1 d desde divulgación
Remediación Parche 6.1.7.1 activerecord · -1 d desde divulgación
Remediación Parche 7.0.4.1 activerecord · -1 d desde divulgación
Divulgación Publicada GHSA-HQ7P-J377-6V63 divulgada
Divulgación Modificada Última actualización del registro
Monitoreo Detectada Ingresó al índice
Resumen
Descripción del advisory
Texto original · GitHub · en inglés

There is a possible vulnerability in ActiveRecord related to the sanitization of comments. This vulnerability has been assigned the CVE identifier CVE-2023-22794.

Versions Affected: >= 6.0.0 Not affected: < 6.0.0 Fixed Versions: 6.0.6.1, 6.1.7.1, 7.0.4.1
Impact

Previously the implementation of escaping for comments was insufficient for

If malicious user input is passed to either the annotate query method, the optimizer_hints query method, or through the QueryLogs interface which automatically adds annotations, it may be sent to the database with insufficient sanitization and be able to inject SQL outside of the comment.

In most cases these interfaces won’t be used with user input and users should avoid doing so.

Example vulnerable code:

Post.where(id: 1).annotate("#{params[:user_input]}")

Post.where(id: 1).optimizer_hints("#{params[:user_input]}")

Example vulnerable QueryLogs configuration (the default configuration is not vulnerable):

config.active_record.query_log_tags = [
  {
    something: -> { <some value including user input> }
  }
]

All users running an affected release should either upgrade or use one of the workarounds immediately.
Releases

The FIXED releases are available at the normal locations.
Workarounds

Avoid passing user input to annotate and avoid using QueryLogs configuration which can include user input.
Patches

To aid users who aren’t able to upgrade immediately we have provided patches for the two supported release series. They are in git-am format and consist of a single changeset.

6-0-Make-sanitize_as_sql_comment-more-strict.patch - Patch for 6.0 series
6-1-Make-sanitize_as_sql_comment-more-strict.patch - Patch for 6.1 series
7-0-Make-sanitize_as_sql_comment-more-strict.patch - Patch for 7.0 series

Please note that only the 7.0.Z and 6.1.Z series are supported at present, and 6.0.Z for severe vulnerabilities. Users of earlier unsupported releases are advised to upgrade as soon as possible as we cannot guarantee the continued availability of security fixes for unsupported releases.

Versiones

Rangos afectados

Afectada Corregida Última
activerecord≥ 6.0.0 < 6.0.6.1
activerecord≥ 6.1.0 < 6.1.7.1
activerecord≥ 7.0.0 < 7.0.4.1
6.0.0
6.0.6.1
6.1.0
6.1.7.1
7.0.0
7.0.4.1
8.1.4.1
Remediación

Estado del parche por paquete

Paquete / productoEstadoCorregida enDesde divulgaciónÚltima versión
rubygemsactiverecord
Corregida 6.0.6.1, 6.1.7.1, 7.0.4.1 -1 d · -1 d · -1 d 8.1.4.1 no afectada
Versiones corregidas6.0.6.16.1.7.17.0.4.1
Explotación

Arsenal público

Sin exploits, módulos ni PoC públicos conocidos a la fecha de verificación.

Referencias
Advisoryhttps://nvd.nist.gov/vuln/detail/CVE-2023-22794
Otrahttps://github.com/rails/rails/commit/d7aba06953f9fa789c411676b941d20df8ef73de
Otrahttps://discuss.rubyonrails.org/t/cve-2023-22794-sql-injection-vulnerability-via-activerecord-comments/82117
Otrahttps://github.com/rails/rails
Otrahttps://github.com/rails/rails/releases/tag/v7.0.4.1
Otrahttps://github.com/rubysec/ruby-advisory-db/blob/master/gems/activerecord/CVE-2023-22794.yml
Otrahttps://security.netapp.com/advisory/ntap-20240202-0008
Otrahttps://www.debian.org/security/2023/dsa-5372

Las referencias externas se muestran para copiar: cve.llama.ec no lo redirige a otros sitios.