首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >我的h2工作,但我不能连接到h2-控制台内部。

我的h2工作,但我不能连接到h2-控制台内部。
EN

Stack Overflow用户
提问于 2022-03-14 18:28:23
回答 2查看 336关注 0票数 1

h2-console.When有一个问题--我从一开始就创建了一些实体,我的h2工作了,我可以打开H2-控制台并看到那里的表,但是过了一段时间,我想再次连接,不工作now.Meanwhile --我添加了一些行和类,但是我为什么不工作H2-控制台,因为我不碰应用程序属性。在点击conect或testconect之后,我得到了这个错误

代码语言:javascript
运行
复制
Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.
Mon Mar 14 19:12:33 CET 2022
There was an unexpected error (type=Forbidden, status=403).

我的github项目:https://github.com/Wynnyy/bookingdoctor-project.git

日志

代码语言:javascript
运行
复制
2022-03-14 19:12:16.222  INFO 23108 --- [           main] s.w.b.BookingdoctorApplication           : Starting BookingdoctorApplication using Java 17.0.2 on DESKTOP-K3O8I67 with PID 23108 (C:\Users\Patrik Severín\IdeaProjects\bookingdoctor\target\classes started by Wynny in C:\Users\Patrik Severín\IdeaProjects\bookingdoctor)
2022-03-14 19:12:16.224  INFO 23108 --- [           main] s.w.b.BookingdoctorApplication           : No active profile set, falling back to 1 default profile: "default"
2022-03-14 19:12:16.928  INFO 23108 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2022-03-14 19:12:16.986  INFO 23108 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 47 ms. Found 2 JPA repository interfaces.
2022-03-14 19:12:17.670  INFO 23108 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2022-03-14 19:12:17.682  INFO 23108 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-03-14 19:12:17.682  INFO 23108 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.58]
2022-03-14 19:12:17.780  INFO 23108 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2022-03-14 19:12:17.780  INFO 23108 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1503 ms
2022-03-14 19:12:17.829  INFO 23108 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2022-03-14 19:12:18.068  INFO 23108 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2022-03-14 19:12:18.080  INFO 23108 --- [           main] o.s.b.a.h2.H2ConsoleAutoConfiguration    : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:wynny'
2022-03-14 19:12:18.277  INFO 23108 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2022-03-14 19:12:18.331  INFO 23108 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.6.5.Final
2022-03-14 19:12:18.497  INFO 23108 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2022-03-14 19:12:18.627  INFO 23108 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
2022-03-14 19:12:19.225  INFO 23108 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2022-03-14 19:12:19.232  INFO 23108 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2022-03-14 19:12:19.540  WARN 23108 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2022-03-14 19:12:19.708  INFO 23108 --- [           main] o.s.s.web.DefaultSecurityFilterChain     : Will not secure any request
2022-03-14 19:12:20.112  INFO 23108 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2022-03-14 19:12:20.211  INFO 23108 --- [           main] s.w.b.BookingdoctorApplication           : Started BookingdoctorApplication in 4.362 seconds (JVM running for 4.745)
2022-03-14 19:12:24.415  INFO 23108 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
2022-03-14 19:12:24.415  INFO 23108 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2022-03-14 19:12:24.417  INFO 23108 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 2 ms
EN

回答 2

Stack Overflow用户

发布于 2022-03-17 16:30:04

默认情况下,spring安全性将保护每个端点,因此对于/error,您需要手动配置,如下所示-

代码语言:javascript
运行
复制
@EnableWebSecurity
public class AppSecurityConfig extends WebSecurityConfigurerAdapter {

    @Override
    public void configure(HttpSecurity auth) {
        auth.csrf().disable()
            .authorizeRequests()
            .antMatchers("/error/**").permitAll() // permit-all for /error  page
            .anyRequest().authenticated();
    }
}
票数 1
EN

Stack Overflow用户

发布于 2022-11-11 17:03:49

供日后参考:

在SpringBoot3.0/SpringSecurity6.0中,http.antMatcher()不再可用,取而代之的是http.securityMatcher()

所以Subham的回答应该是这样的:

代码语言:javascript
运行
复制
@Configuration
public class SecurityConfiguration {
    @Bean
    public SecurityFilterChain filterChain(HttpSecurity http) throws Exception {
        http.authorizeHttpRequests((authz) -> authz.anyRequest().permitAll())
                .csrf().disable()
                .securityMatcher("/error/**")
                .httpBasic(withDefaults());

        return http.build();
    }

}
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/71472558

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档