Summary
This update fixes the following issues:
bind-formula:
- Temporarily disable dnssec-validation as hotfix for bsc#1177790
- Update to version 0.1.1603299886.60e4bcf
grafana-formula:
- Use variable for product name
- Add support for system groups in Client Systems dashboard
postgresql-jdbc:
- Address CVE-2020-13692 (bsc#1172079)
- Add patch:
- Major changes since 9.4-1200:
* License changed to BSD-2-Clause and BSD-3-Clause and Apache-2.0
* Support PostgreSQL 9.5, 9.6, 10 11 and 12 added
* Support for PostgreSQL versions below 8.2 was dropped
* Support for JDK8, JDK9, JDK10, JDK11 and JDK12
* Support for JDK 1.4 and 1.5 was dropped
* Support for JDBC 4.2 added
* Add maxResultBuffer property
* Add caller push of binary data
* Read only transactions
* pkcs12 key functionality
* New 'escapeSyntaxCallMode' connection property
* Connection property to limit server error detail in exception
exceptions
* CancelQuery() to PGConnection public interface
* Support for large update counts (JDBC 4.2)
* Add Binary Support for Oid.NUMERIC and Oid.NUMERIC_ARRAY
* Expose parameter status messages (GUC_REPORT) to the user
* Log ignoring rollback when no transaction in progress
* Map inet type to InetAddress
* Change ISGENERATED to ISGENERATEDCOLUMN as per spec
* Support temporary replication slots in ReplicationCreateSlotBuilder
* Return function (PostgreSQL 11) columns in PgDatabaseMetaData#getFunctionColumns
* Return information on create replication slot, now the snapshot_name
is exported to allow a consistent snapshot in some uses cases
* `ssl=true` implies `sslmode=verify-full`, that is it requires valid
server certificate
* Support for `sslmode=allow/prefer/require`
* Added server hostname verification for non-default SSL factories in
`sslmode=verify-full` (CVE-2018-10936)
* PreparedStatement.setNull(int parameterIndex, int t, String typeName)
no longer ignores the typeName argument if it is not setNull
* Reduce the severity of the error log messages when an exception is
re-thrown. The error will be thrown to caller to be dealt with so no need
to log at this verbosity by pgjdbc
* Deprecate Fastpath API PR 903
* Support parenthesis in {oj ...} JDBC escape syntax
* socksProxyHost is ignored in case it contains empty string
* Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+)
using the Ongres SCRAM library
* Make SELECT INTO and CREATE TABLE AS return row counts to the client in
their command tags
* Support Subject Alternative Names for SSL connections
* Support isAutoIncrement metadata for PostgreSQL 10 IDENTITY column
* Support for primitive arrays PR 887 3e0491a
* Implement support for get/setNetworkTimeout() in connections
* Make GSS JAAS login optional, add an option 'jaasLogin'
* Improve behaviour of ResultSet.getObject(int, Class)
* Parse CommandComplete message using a regular expression, allows complete
catch of server returned commands for INSERT, UPDATE, DELETE, SELECT,
FETCH, MOVE,COPY and future commands.
* Use 'time with timezone' and 'timestamp with timezone' as is and ignore the
user provided Calendars, 'time' and 'timestamp' work as earlier except
'00:00:00' now maps to 1970-01-01 and '24:00:00' uses the system provided
Calendar ignoring the user-provided one
* Change behaviour of multihost connection. The new behaviour is to try all
secondaries first before trying the master
* Drop support for the (insecure) crypt authentication method
* slave and preferSlave values for the targetServerType connection property
have been deprecated in favour of secondary and preferSecondary
respectively
* Statements with non-zero fetchSize no longer require server-side
named handle. This might cause issues when using old PostgreSQL versions
(pre-8.4)+fetchSize+interleaved ResultSet processing combo
* Better logic for returning keyword detection. Previously, pgjdbc could be
defeated by column names that contain returning, so pgjdbc failed to
'return generated keys' as it considered statement as already having
returning keyword
* Use server-prepared statements for batch inserts when prepareThreshold>0.
This enables batch to use server-prepared from the first executeBatch()
execution (previously it waited for prepareThreshold executeBatch() calls)
* Replication protocol API was added: replication API documentation
* java.util.logging is now used for logging: logging documentation
* Add support for PreparedStatement.setCharacterStream(int, Reader)
* Ensure executeBatch() can be used with pgbouncer. Previously pgjdbc could
use server-prepared statements for batch execution even with
prepareThreshold=0
* Error position is displayed when SQL has unterminated literals,
comments, etc
* Strict handling of accepted values in getBoolean and setObject(BOOLEAN),
now it follows PostgreSQL accepted values, only 1 and 0 for numeric types
are acepted (previusly !=0 was true)
* Deprecated PGPoolingDataSource, instead of this class you should use a
fully featured connection pool like HikariCP, vibur-dbcp, commons-dbcp,
c3p0, etc
* 'current transaction is aborted' exception includes the original exception
via caused-by chain
* Better support for RETURNGENERATEDKEYS, statements with RETURNING clause
* Avoid user-visible prepared-statement errors if client uses
DEALLOCATE/DISCARD statements (invalidate cache when those statements
detected)
* Avoid user-visible prepared-statement errors if client changes searchpath
(invalidate cache when set searchpath detected)
* Support comments when replacing {fn ...} JDBC syntax
* Support for Types.REF_CURSOR
* Performance optimization for timestamps (~TimeZone.getDefault optimization)
* Ability to customize socket factory (e.g. for unix domain sockets)
* Ignore empty sub-queries in composite queries
*
Fixed packages 13
| Release | Package | Fixed in |
|---|---|---|
| SUSE · Manager Server Module 4.0 | bind-formula | 0.1.1603299886.60e4bcf-3.11.1 |
| SUSE · Manager Server Module 4.0 | grafana-formula | 0.2.2-4.13.1 |
| SUSE · Manager Server Module 4.0 | postgresql-jdbc | 42.2.10-3.3.1 |
| SUSE · Manager Server Module 4.0 | prometheus-exporters-formula | 0.7.5-3.16.1 |
| SUSE · Manager Server Module 4.0 | prometheus-formula | 0.2.3-4.16.1 |
| SUSE · Manager Server Module 4.0 | salt-netapi-client | 0.18.0-4.12.1 |
| SUSE · Manager Server Module 4.0 | spacewalk-admin | 4.0.12-3.15.1 |
| SUSE · Manager Server Module 4.0 | spacewalk-backend | 4.0.35-3.38.1 |
| SUSE · Manager Server Module 4.0 | spacewalk-java | 4.0.40-3.48.2 |
| SUSE · Manager Server Module 4.0 | spacewalk-web | 4.0.25-3.36.1 |
| SUSE · Manager Server Module 4.0 | susemanager | 4.0.32-3.46.1 |
| SUSE · Manager Server Module 4.0 | susemanager-schema | 4.0.23-3.32.1 |
| SUSE · Manager Server Module 4.0 | susemanager-sls | 4.0.31-3.37.1 |
Vulnerabilities 2
-
High 8.1CVE-2018-10936 Public exploit
Moderate severity vulnerability that affects org.postgresql:pgjdbc-aggregate
A weakness was found in postgresql-jdbc before version 42.2.5. It was possible to provide an SSL Factory and not check the host name if a host name verifier was not provided to the driver. This could lead to a condition where a man-in-the-middle attacker coul…
-
High 7.7
Improper Restriction of XML External Entity Reference
PostgreSQL JDBC Driver (aka PgJDBC) before 42.2.13 allows XXE.
References
-
report
https://bugzilla.suse.com/1144447
-
report
https://bugzilla.suse.com/1172079
-
report
https://bugzilla.suse.com/1173199
-
report
https://bugzilla.suse.com/1175739
-
report
https://bugzilla.suse.com/1175876
-
report
https://bugzilla.suse.com/1175987
-
report
https://bugzilla.suse.com/1176074
-
report
https://bugzilla.suse.com/1176172
-
report
https://bugzilla.suse.com/1177336
-
report
https://bugzilla.suse.com/1177435
-
report
https://bugzilla.suse.com/1177790
-
report
https://bugzilla.suse.com/1178060
-
report
https://bugzilla.suse.com/1178145
-
report
https://bugzilla.suse.com/1178195
-
web
https://www.suse.com/security/cve/CVE-2018-10936
-
web
https://www.suse.com/security/cve/CVE-2020-13692