id: GO-2024-2606
modules:
    - module: github.com/jackc/pgproto3/v2
      versions:
        - fixed: 2.3.3
      vulnerable_at: 2.3.2
      packages:
        - package: github.com/jackc/pgproto3/v2
          symbols:
            - CloseComplete.Encode
            - AuthenticationSASLFinal.Encode
            - Terminate.Encode
            - NotificationResponse.Encode
            - AuthenticationGSSContinue.Encode
            - DataRow.Encode
            - CopyInResponse.Encode
            - FunctionCall.Encode
            - BackendKeyData.Encode
            - Query.Encode
            - CancelRequest.Encode
            - ParameterStatus.Encode
            - BindComplete.Encode
            - CopyBothResponse.Encode
            - CopyData.Encode
            - CopyOutResponse.Encode
            - AuthenticationGSS.Encode
            - Parse.Encode
            - PasswordMessage.Encode
            - AuthenticationCleartextPassword.Encode
            - ErrorResponse.Encode
            - SASLInitialResponse.Encode
            - Execute.Encode
            - FunctionCallResponse.Encode
            - ReadyForQuery.Encode
            - AuthenticationOk.Encode
            - SSLRequest.Encode
            - CopyDone.Encode
            - AuthenticationMD5Password.Encode
            - ParseComplete.Encode
            - EmptyQueryResponse.Encode
            - CommandComplete.Encode
            - AuthenticationSASL.Encode
            - NoData.Encode
            - Flush.Encode
            - GSSEncRequest.Encode
            - StartupMessage.Encode
            - Backend.Send
            - GSSResponse.Encode
            - CopyFail.Encode
            - Bind.Encode
            - AuthenticationSASLContinue.Encode
            - NoticeResponse.Encode
            - SASLResponse.Encode
            - Frontend.Send
            - Sync.Encode
            - ErrorResponse.marshalBinary
            - RowDescription.Encode
            - Close.Encode
            - ParameterDescription.Encode
            - PortalSuspended.Encode
            - Describe.Encode
        - package: github.com/jackc/pgproto3/v2/example/pgfortune
          symbols:
            - PgFortuneBackend.handleStartup
            - PgFortuneBackend.Run
          derived_symbols:
            - main
      fix_links:
        - https://github.com/jackc/pgproto3/commit/945c2126f6db8f3bea7eeebe307c01fe92bca007
    - module: github.com/jackc/pgx
      vulnerable_at: 3.6.2+incompatible
      packages:
        - package: github.com/jackc/pgx/internal/sanitize
          symbols:
            - Query.Sanitize
          derived_symbols:
            - SanitizeSQL
    - module: github.com/jackc/pgx/v4
      versions:
        - fixed: 4.18.2
      vulnerable_at: 4.18.1
      packages:
        - package: github.com/jackc/pgx/v4/internal/sanitize
          symbols:
            - Query.Sanitize
          derived_symbols:
            - SanitizeSQL
      fix_links:
        - https://github.com/jackc/pgx/commit/f94eb0e2f96782042c96801b5ac448f44f0a81df,
    - module: github.com/jackc/pgx/v5
      versions:
        - introduced: 5.0.0
        - fixed: 5.5.4
      vulnerable_at: 5.5.3
      packages:
        - package: github.com/jackc/pgx/v5/internal/sanitize
          symbols:
            - Query.Sanitize
          derived_symbols:
            - SanitizeSQL
        - package: github.com/jackc/pgx/v5/pgproto3
          symbols:
            - Frontend.SendSync
            - Backend.Flush
            - Frontend.SendDescribe
            - Parse.Encode
            - CopyBothResponse.Encode
            - CopyOutResponse.Encode
            - GSSResponse.Encode
            - DataRow.Encode
            - EmptyQueryResponse.Encode
            - PortalSuspended.Encode
            - Close.Encode
            - SASLInitialResponse.Encode
            - ReadyForQuery.Encode
            - Query.Encode
            - CopyFail.Encode
            - ParameterDescription.Encode
            - NoData.Encode
            - SSLRequest.Encode
            - AuthenticationMD5Password.Encode
            - Flush.Encode
            - StartupMessage.Encode
            - Frontend.SendParse
            - CloseComplete.Encode
            - Backend.Send
            - CopyInResponse.Encode
            - GSSEncRequest.Encode
            - Frontend.Send
            - Describe.Encode
            - AuthenticationOk.Encode
            - FunctionCallResponse.Encode
            - Bind.Encode
            - Frontend.SendClose
            - Terminate.Encode
            - Frontend.SendExecute
            - Sync.Encode
            - Execute.Encode
            - AuthenticationGSSContinue.Encode
            - FunctionCall.Encode
            - CancelRequest.Encode
            - AuthenticationSASLFinal.Encode
            - BackendKeyData.Encode
            - Frontend.Flush
            - NoticeResponse.Encode
            - AuthenticationSASL.Encode
            - Frontend.SendBind
            - AuthenticationSASLContinue.Encode
            - BindComplete.Encode
            - PasswordMessage.Encode
            - NotificationResponse.Encode
            - ErrorResponse.Encode
            - CopyData.Encode
            - ErrorResponse.marshalBinary
            - Frontend.SendQuery
            - ParameterStatus.Encode
            - AuthenticationCleartextPassword.Encode
            - AuthenticationGSS.Encode
            - RowDescription.Encode
            - CopyDone.Encode
            - CommandComplete.Encode
            - SASLResponse.Encode
            - ParseComplete.Encode
          derived_symbols:
            - Frontend.SendUnbufferedEncodedCopyData
        - package: github.com/jackc/pgx/v5/pgconn
          symbols:
            - Batch.ExecParams
            - PgConn.ExecBatch
            - Batch.ExecPrepared
          derived_symbols:
            - Connect
            - ConnectConfig
            - ConnectWithOptions
            - MultiResultReader.Close
            - MultiResultReader.NextResult
            - MultiResultReader.ReadAll
            - PgConn.CheckConn
            - PgConn.Close
            - PgConn.CopyFrom
            - PgConn.CopyTo
            - PgConn.Deallocate
            - PgConn.Exec
            - PgConn.ExecParams
            - PgConn.ExecPrepared
            - PgConn.Ping
            - PgConn.Prepare
            - PgConn.ReceiveMessage
            - PgConn.SyncConn
            - PgConn.WaitForNotification
            - Pipeline.Close
            - Pipeline.Flush
            - Pipeline.GetResults
            - Pipeline.SendDeallocate
            - Pipeline.SendPrepare
            - Pipeline.SendQueryParams
            - Pipeline.SendQueryPrepared
            - Pipeline.Sync
            - ResultReader.Close
            - ResultReader.NextRow
            - ResultReader.Read
            - ValidateConnectTargetSessionAttrsPreferStandby
            - ValidateConnectTargetSessionAttrsPrimary
            - ValidateConnectTargetSessionAttrsReadOnly
            - ValidateConnectTargetSessionAttrsReadWrite
            - ValidateConnectTargetSessionAttrsStandby
        - package: github.com/jackc/pgx/v5/pgproto3/example/pgfortune
          symbols:
            - PgFortuneBackend.handleStartup
            - PgFortuneBackend.Run
          derived_symbols:
            - main
      fix_links:
        - https://github.com/jackc/pgx/commit/c543134753a0c5d22881c12404025724cb05ffd8
        - https://github.com/jackc/pgx/commit/adbb38f298c76e283ffc7c7a3f571036fea47fd4
summary: SQL injection in github.com/jackc/pgproto3 and github.com/jackc/pgx
description: |-
    An integer overflow in the calculated message size of a query or bind message
    could allow a single large message to be sent as multiple messages under the
    attacker's control. This could lead to SQL injection if an attacker can cause a
    single query or bind message to exceed 4 GB in size.
cves:
    - CVE-2024-27304
ghsas:
    - GHSA-mrww-27vc-gghv
    - GHSA-7jwh-3vrq-q3m8
credits:
    - paul-gerste-sonarsource
references:
    - advisory: https://github.com/jackc/pgx/security/advisories/GHSA-mrww-27vc-gghv
    - fix: https://github.com/jackc/pgproto3/commit/945c2126f6db8f3bea7eeebe307c01fe92bca007
    - fix: https://github.com/jackc/pgx/commit/adbb38f298c76e283ffc7c7a3f571036fea47fd4
    - fix: https://github.com/jackc/pgx/commit/c543134753a0c5d22881c12404025724cb05ffd8
    - fix: https://github.com/jackc/pgx/commit/f94eb0e2f96782042c96801b5ac448f44f0a81df
review_status: REVIEWED