You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by Lucky <wa...@163.com> on 2017/07/11 06:41:17 UTC

How to start up H2 Console

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.

Re:How to start up H2 Console

Posted by Lucky <wa...@163.com>.

OK，I understand.
Now is still do not support remote connection, just local.
Do it will be supported in the future?


Thanks .
Lucky









At 2017-07-12 15:51:46, "Humphrey" <hm...@gmail.com> wrote:
>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.

How to start up H2 Console

Posted by Humphrey <hm...@gmail.com>.

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:Re: Re:Re: How to start up H2 Console

Posted by Lucky <wa...@163.com>.

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" <hm...@gmail.com> 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.

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

Posted by Humphrey <hm...@gmail.com>.

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: How to start up H2 Console

Posted by Lucky <wa...@163.com>.

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 10000.
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" <hm...@gmail.com> 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: How to start up H2 Console

Posted by Humphrey <hm...@gmail.com>.

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.