How to start up H2 Console

[Lucky]

Hi:
I want to analysis sql explain and debug sql .
How to start up H2 Console?
My server OS is centos6. IP is 192.168.1.2 


Thanks.

How to start up H2 Console

[Humphrey]

I didn't get that error when I tried it out on my computer. It started Ignite
and opened the H2 web interface in my browser. It's suppose to open local on
your computer so it's not possible to have remote connections.

See also:
http://apache-ignite-users.70518.x6.nabble.com/Starting-H2-Debug-Console-On-Remote-Server-td6063.html

Humphrey




--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/How-to-start-up-H2-Console-tp14617p14707.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: How to start up H2 Console

[Humphrey]

Hi did you look here?

https://apacheignite.readme.io/docs/sql-performance-and-debugging

You can also use the web console to have it explain.

https://ignite.apache.org/addons.html#web-console



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/How-to-start-up-H2-Console-tp14617p14618.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re:Re: How to start up H2 Console

[Lucky]

Yes,I had study the document many times.
But the document is too simple.
I still have two question:
1.How to set the IGNITE_H2_DEBUG_CONSOLE property? modified ignite.sh ? Maybe a 
particular setting is perfect to me.
2.what is the URL if I open browser?


By the way,the web console is too heavy for us ,for our customer is more than 
1.
So too many  installing is impossible for us.
 I hope that a little setting can work.



Thanks.







At 2017-07-11 15:35:28, "Humphrey"  wrote:
>Hi did you look here?
>
>https://apacheignite.readme.io/docs/sql-performance-and-debugging
>
>You can also use the web console to have it explain.
>
>https://ignite.apache.org/addons.html#web-console
>
>
>
>--
>View this message in context: 
>http://apache-ignite-users.70518.x6.nabble.com/How-to-start-up-H2-Console-tp14617p14618.html
>Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Re:Re: How to start up H2 Console

[Humphrey]

Hi Lucky,

You can start the console by first executing the following command:

And then in the same console


It will open automatically a browser for you.

Cheers,

Humphrey



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/How-to-start-up-H2-Console-tp14617p14642.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re:Re: Re:Re: How to start up H2 Console

[Lucky]

Thank you for your reply.


I did as you suggested in the mail.


but on accessing the url I get an error "Sorry, remote connections 
('webAllowOthers') are disabled on this server.". 


How do I pass "webAllowOthers" parameter to h2 database through ignite? 

Thanks 


Lucky








At 2017-07-12 07:34:24, "Humphrey"  wrote:
>Hi Lucky,
>
>You can start the console by first executing the following command:
>
>And then in the same console
>
>
>It will open automatically a browser for you.
>
>Cheers,
>
>Humphrey
>
>
>
>--
>View this message in context: 
>http://apache-ignite-users.70518.x6.nabble.com/How-to-start-up-H2-Console-tp14617p14642.html
>Sent from the Apache Ignite Users mailing list archive at Nabble.com.