Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

H2 Console throwing a error webAllowOthers in H2 database

Tags:

I am using heruko to deploy my application when i am trying to load my h2 console using heruko it is throwing an error saying.

H2 Console Sorry, remote connections ('webAllowOthers') are disabled on this server.

i am using the below settings in my application.properties file

jdbc:h2:tcp://localhost/~/test spring.datasource.platform=h2 spring.datasource.url=jdbc:h2:mem:Roomy;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE spring.datasource.driverClassName=org.h2.Driver spring.datasource.username=sa spring.datasource.password= spring.jpa.database-platform=org.hibernate.dialect.H2Dialect spring.h2.console.enabled = true  spring.h2.console.settings.trace=true  spring.h2.console.settings.web-allow-others=true 

I done some google and added .h2.server.properties

#H2 Server Properties 1=Generic H2 (Memory)|org.h2.Driver|jdbc:h2:mem:Roomy;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE|sa webAllowOthers=true tcpAllowOthers=true webPort=8082 webSSL=false 

Please mention what i have done wrong and i am unable to view the h2 console could someone help on this.The cosole is working fine in the local and in the heroku the DB is working with no issues but unable to view the console .Any help would be greatly appreciable.

Thanks Chaitanya

like image 261
chaitanya Avatar asked Jul 02 '17 03:07

chaitanya


People also ask

How do I check my H2 database console?

Access the H2 Console You can access the console at the following URL: http://localhost:8080/h2-console/. You need to enter the JDBC URL, and credentials. To access the test database that the greeter quickstart uses, enter these details: JDBC URL: jdbc:h2:mem:greeter-quickstart;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1.


2 Answers

In application.properties, add following setting.

spring.h2.console.settings.web-allow-others=true 

In my case, it works.

like image 131
Peter Chang Avatar answered Nov 16 '22 23:11

Peter Chang


for those who use application.yml format

spring:   h2:     console:       enabled: true       settings:         web-allow-others: true 
like image 24
Semir Umut Kurt Avatar answered Nov 16 '22 21:11

Semir Umut Kurt