bilak's questions

我想将 Keycloak 隐藏在 Spring Cloud Gateway 后面，但仍将其用作 OIDC 提供商。我已设法允许/auth（keycloak 的）端点，但现在我正在与 http basic auth 作斗争，我不知道如何禁用它。每次我尝试访问任何其他应受 keycloak 保护的端点时，我都会获得浏览器表单登录。使用以下配置

@Bean
@Order(1)
SecurityWebFilterChain publicEndpoints(final ServerHttpSecurity http) {
    return http.authorizeExchange(auth ->
                    auth.pathMatchers("/auth", "/auth/**").permitAll())
            .csrf(ServerHttpSecurity.CsrfSpec::disable)
            .cors(ServerHttpSecurity.CorsSpec::disable)
            .formLogin(ServerHttpSecurity.FormLoginSpec::disable)
            .headers(c -> c.frameOptions(ServerHttpSecurity.HeaderSpec.FrameOptionsSpec::disable))
            .httpBasic(basic ->
                    basic.authenticationEntryPoint(new HttpStatusServerEntryPoint(HttpStatus.UNAUTHORIZED)))
            .build();
}

@Bean
@Order(2)
SecurityWebFilterChain springSecurityFilterChain(final ServerHttpSecurity http) {
    return http.authorizeExchange(auth -> auth.anyExchange().authenticated())
            .oauth2Login(withDefaults())
            .oauth2ResourceServer((oauth2) -> oauth2.jwt(withDefaults()))
            .csrf(ServerHttpSecurity.CsrfSpec::disable)
            .cors(ServerHttpSecurity.CorsSpec::disable)
            .formLogin(ServerHttpSecurity.FormLoginSpec::disable)
            .headers(c -> c.frameOptions(ServerHttpSecurity.HeaderSpec.FrameOptionsSpec::disable))
            //.httpBasic(ServerHttpSecurity.HttpBasicSpec::disable)
            .build();

}

应用程序启动时出现错误：

Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.security.web.server.SecurityWebFilterChain]: Factory method 'publicEndpoints' threw exception with message: authenticationManager cannot be null
2025-03-06T15:35:01.907890843Z  at org.springframework.beans.factory.support.SimpleInstantiationStrategy.lambda$instantiate$0(SimpleInstantiationStrategy.java:199) ~[spring-beans-6.2.3.jar:6.2.3]
2025-03-06T15:35:01.907892426Z  at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiateWithFactoryMethod(SimpleInstantiationStrategy.java:88) ~[spring-beans-6.2.3.jar:6.2.3]
2025-03-06T15:35:01.907893385Z  at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:168) ~[spring-beans-6.2.3.jar:6.2.3]
2025-03-06T15:35:01.907894343Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-6.2.3.jar:6.2.3]
2025-03-06T15:35:01.907895260Z  ... 39 common frames omitted

因为我不想使用任何身份验证管理器，因为publicEndpoints我不知道如何配置它以禁用表单登录并使用 oauth

我正在尝试从 迁移cx_Oracle 8.1.0到oracledb 2.5.1库。之前这样的查询是有效的：

update command_center set 
            E_ID = :1,
            E_ASPECTS = :2,
            E_CREATED_TIMESTAMP = :3
WHERE e_id = :1

def bulk_insert_or_update_data_to_targets(self, sql, target_data, id_index=0):
    for target_connections, data in target_data:
        for con in target_connections:
            cursor = con.cursor()
            cursor.executemany(sql, data, batcherrors=True)
            if cursor.getbatcherrors():
                self.logger.debug("data: " + str(data))
            cursor.close()

但目前我有以下例外：

oracledb.exceptions.DatabaseError: DPY-4009: 4 positional bind values are required but 3 were provided

这是否有可能像以前一样工作cx_Oracle...所以我猜它是通过数组索引检索属性的？

首先，我对 PowerQuery 还很陌生...我有类似下面的 xml：

<root>
  <entries>
    <entry>
      <otherData>
        <id>1</id>
      </otherData>
      <images>
        <image>
          <url>http://example.com/1.img</url>
        </image>
        <image>
          <url>http://example.com/1.img</url>
        </image>
        <image>
          <url>http://example.com/1.img</url>
        </image>
      </images>
    </entry>
    <entry>
      <otherData>
        <id>2</id>
      </otherData>
      <images>
        <image>
          <url>http://example.com/4.img</url>
        </image>
        <image>
          <url>http://example.com/5.img</url>
        </image>
      </images>
    </entry>
  </entries>
<root>

我想要的是一张由id和 基于 的动态列数组成的表/images/image/url。我不知道是否可以动态添加列并以某种方式命名它们（带有数字后缀img1... imgN）