No Elasticsearch web host! Any point upgrading to CubeCart 6.5.x or are we stuck at 6.4.10?

[jasehead]

Are the recent versions of CubeCart usable if we don't have a web host that supports Elasticsearch? Will future versions of CubeCart work across the board, or will all future updates be dependent on Elasticsearch?

Does that mean that CubeCart merchants without access to Elasticsearch are stuck at 6.4.10?  Will a non-elastic branch of CubeCart continue to be developed and updated, or at least security patched occasionally?

To quote Al from 2017, considering adding Elasticsearch to CubeCart:

Quote

It will never happen because the vast majority of our merchants have generic shared web hosting which will never be compatible with ElasticSearch.

We could integrate it but only for merchants who have there own dedicated server or VPS and are happy configuring ElasticSearch.

Sadly this just doesn't fit our demographic and the development time required to implement this isn't worth while.

 

[Al Brookbanks]

Quote

Does that mean that CubeCart merchants without access to Elasticsearch are stuck at 6.4.10?

Not at all. This of it as just an extra (awesome) feature. Please upgrade to the latest version still there are a bunch of other bug fixes and smaller feature updates. 

[sack123]

Here in Setting > Advanceed > Elasticsearch,  it is not allowed to add index name.

If I saved by checking box, it gives highlighter.    "A unique index name is required"

I tried 6.5.2 and 6.5.3 as well.

 

 

 

[Al Brookbanks]

Do you have an ES server?

[sack123]

Yes, ES Application is installed.  If I checked box on enable and save then it uncheck automatically.

 

 

[Al Brookbanks]

Try setting the values in the includes/global.inc.php file (in most cases the last two can be ignored):

$glob['es_h']                      = '';               // Elasticsearch host e.g. https://localhost:9200

$glob['es_u']                      = '';               // Elasticserch username

$glob['es_p']                      = '';               // Elasticsearch password

$glob['es_i']                        = '';               // Elasticsearch index name

$glob['es_v']                      = '';               // Elasticsearch vertificate validation enum('1','0')

$glob['es_c']                       = '';               // Elasticsearch certificate path

[sack123]

Is the value same as database host name, username , password and specially index name ?

[bsmither]

I would think not.

What you refer to is the access credentials to the MySQL database server.

The mentioned $glob array elements for ElasticSearch would/should be different.

If your site is hosted, and your host gives you a site management tool (such as CPanel), and if ElasticSearch is installed by your host, the access credentials to the MySQL database and ElasticSearch engine should have been emailed to you in your new subscriber "Welcome" notice, or, at least, these connection details would be shown somewhere in the management tool.

 

 

[sack123]

I am using cyberpanel. In that manage, elastisearch is application, can be install and remove.

When I set $glob['es_h'] = 'localhost:9200';  it able to select enable check box.

username, password and index name I sed from the global $glob['dbdatabase'] similarly...

In maintainance -> elasticsearch tab, it shouws the count and size, But can not see result on search box.

 

Is there any way/command to know this ES engine credential from the root access ?

[bsmither]

Sorry, I would not know. We will need to wait for Al or HavenSwift to advise.

 

[Al Brookbanks]

Add these fields to the includes/global.inc.php file with correct values. Please note that your skin may need changes if you are not using the default Foundation theme. 

$glob['es_h']                      = '';               // Elasticsearch host e.g. https://localhost:9200
$glob['es_u']                      = '';               // Elasticserch username
$glob['es_p']                      = '';               // Elasticsearch password
$glob['es_i']                        = '';               // Elasticsearch index name
$glob['es_v']                      = '';               // Elasticsearch vertificate validation enum('1','0')
$glob['es_c']                       = '';               // Elasticsearch certificate path

The last two fields can probably remain empty. 

[sack123]

Great! Thank you very much. It is working, I used the database credential and host localhost:9200. In the search box, to get the drop down list product, need to use mouse cursor. Can we add keyboard up,down to reach to the downward list instead of mouse cursor. Even after click outside of the search box, ES search dropdown list wont disappear. Need to used ESC key. It would be good idea to add one click functionality to clear search dropdown list like ESC key.

[bsmither]

That's my question: where does the index name come from? Is it auto-generated the first time ElasticSearch builds the index? Does the hosting provider assign it?

sack123, where did you get the value for 'es_i'?

(Note: The forum will not let me use the '@' notifier -- it refuses to allow a post that was edited to use it get re-saved. I hope you see this.)

Edited Sunday at 03:13 AM by bsmither

[Al Brookbanks]

I use Kibana to manage this.

Create a user and pass. Assign a role to this user for all privileges on a specific index name.

I've not done it for a while so I might create the role first then the account and password.