Elasticsearch and web server control panels using

Elastic Stack Elasticsearch
1

Hi,

Can we use elasticsearch with web control panel on the server? For example, "vesta control panel" or "centos web panel" etc.

I have ip adres on server and I installed ES 2.3.3. I connected with my ip adress ES. (187.59.456.47:9200)

{
  "name" : "Tempus",
  "cluster_name" : "elasticsearch",
  "version" : {
    "number" : "2.3.3",
    "build_hash" : "218bdf10790eef486ff2c41a3df5cfa32dadcfde",
    "build_timestamp" : "2016-05-17T15:40:04Z",
    "build_snapshot" : false,
    "lucene_version" : "5.5.0"
  },
  "tagline" : "You Know, for Search"
}

After I installed Vesta panel but I can't connect ES. After I uninstall vesta panel and I install Centos web panel. I connect ES but I can't connect centos web panel.

I have to use web control panel for apache, php and mysql.
What can I do?

2

What is the problem?
Are Elasticsearch and Vesta Panel compatible?

3

Hi @Hilal,

to be honest, I do not know what you are trying to achieve exactly. Do you want to manage Elasticsearch via a browser UI?

I looked very briefly at the Vesta Control Panel and the CentOS web panel. I might be mistaken but both offer no integration with Elasticsearch so it's no wonder Elasticsearch does not show up in these UIs, no?

If you want to use a management UI for Elasticsearch you can install Marvel.

Daniel

4

Thank you for your answer. I want to index mysql data with elasticsearch. So I have to use php, mysql and apache.

Actually I did index on localhost with centos 6 and centos 7 OS last mount.(http://localhost:9200)
I installed vesta panel(for php,mysql and apache), elasticsearch(for indexing), marvel sense(for data mapping) and kibana. I indexed my database with elasticsearch and I did query.

Now I am working on server(putty server:187.59.456.47) not localhost. I want to try again indexing on server.
I installed ES 2.3.3. It work true with http://187.59.456.47:9200 on server. After I installed vesta panel. It work true with http://187.59.456.47:8083 on server. However Es can't connected.

I didn't understand.

5

Hi @Hilal,

I still don't understand what all of this has to do with the Vesta panel (which seems to be some kind of management UI).

Let me summarize what I've understood so far:

  • Elasticsearch 2.3.3. is running on IP 187.59.456.47 on port 9200 (btw, 187.59.456.47 is not a valid IP as each byte in an IP can only be between 0 and 255)
  • You have a MySQL database (somewhere else?)
  • You want to index data from MySQL in Elasticsearch via a PHP application

I don't understand what is exposed on port 8083 (the PHP application?) and from which machine you connect to Elasticsearch. Can you please show in more detail how you connect to Elasticsearch (e.g. configuration file)? Are you aware that you have to bind Elasticsearch to a network interface if you want to expose it to other machines (by default it only binds to localhost)? Have you tried to connect to Elasticsearch via curl, Sense or a browser?

Daniel

6

Ok. I'll explain more in detail.

Firstly, I have a website about my auctions(it was written with PHP). There are lots of data(85 GB) in mysql. I want to move my data mysql from elasticsearch. Actually I tried on localhost. I writed php codes and mapping for index. I did it last month

Now I am trying on server instead of localhost.

I have to use :

1. Centos 6 OS on server
2. Vesta Web panel(for mamagement php-mysql-apache)
3. Es 2.3.3.
4. Kibana
    -Marvel 
    -Sense (for mapping my data)

If I install these programs or platform, I will index mydata with php codes and mapping codes.
After I will query my data on API.

My problem is Elasticsearch connection. I installed these programs and I started ES 2.3.3. After I tried connection ES:

http://187.59.456.47:9200

not connection.

When I try to connection on curl:

`curl 'http://187.59.456.47:9200'

It connects.`

I think problem is my port:9200.

I hope that this time could duly told. Thank you for your interest.

7

Hi @Hilal,

187.59.456.47 is not a valid IPv4 address (it's the 456 that is impossible). Can you please check that this is really the IP address of your Elasticsearch server? Can you also please ping this IP and share the output with me?

From which machine (and how) do you connect?

I assume you have one web server where PHP (and maybe also MySQL) is installed. I call this machine now "WS". I also assume you have a developer workstation which I'll call "DEV". And I also assume that you have a separate machine where Elasticsearch is installed and I call this machine now "ES". So we have 3 machines that are involved.

As far as I understand: ES has the IP 187.59.456.47 (except that 456 is not possible..). I guess if you say "no connection", you try to connect from WS to ES. If you try with curl, you connect from DEV to ES. Correct?

Can you also show me the contents of the file config/elasticsearch.yml please?

Daniel

8

Yes you are right. I changed my server ip address. Also I changed again my ES configuration file(network.host:my server ip).
After I added my iptables.

-A INPUT -p tcp -m tcp --dport 9200 -j ACCEPT 
-A INPUT -p tcp -m udp --dport 9200 -j ACCEPT

...

service iptables restart
service iptables save

I had some error but I continued.

service elasticsearch restart

and it was work :slight_smile:

http://my ip number:9200/

result:

{
  "name" : "Crucible",
  "cluster_name" : "elasticsearch",
  "version" : {
    "number" : "2.3.3",
    "build_hash" : "218bdf10790eef486ff2c41a3df5cfa32dadcfde",
    "build_timestamp" : "2016-05-17T15:40:04Z",
    "build_snapshot" : false,
    "lucene_version" : "5.5.0"
  },
  "tagline" : "You Know, for Search"
}

Problem is 9200 port. I opened it and worked. Thanks again for the help

9

Hi @Hilal,

great that it's now working! :slight_smile:

Daniel