2arunpmohan

network.host: 0
http.port: 9233
http.cors.enabled: true
http.cors.allow-origin: '*'

2arunpmohan

to change the default size limit change the max_result_window parameter to a suitable value: curl -XPUT "http://localhost:9200/my_index/_settings" -d '{ "index" : { "max_result_window" : 500000 } }'

2arunpmohan

start mysql in ubuntu mysql -u root -p (after entering this, we will be asked password. For office system it is "factweavers")

2arunpmohan

list all databases in database
  show databases;
  
create a database
  create databaseName

2arunpmohan

show the tables inside a database show tables;

create a table create table TableName(columndetails) eg: create table EmployeeDetails (PersonID int, LastName varchar(255), FirstName varchar(255), City varchar(255));

insert data to a table INSERT INTO EmployeeDetails (PersonID, LastName, FirstName, City) VALUES ('4005','Kallis','Jaques','Cape Town');

2arunpmohan

SCP operations

scp to factweavers

scp /var/www/html/teknion-ui.zip root@factweavers.com:~/../var/www/html

scp a file from factweavers

scp root@factweavers.com:/var/www/html/teknion-ui-new.zip /var/www/html/

2arunpmohan

#ZIP a folder zip -r new-name.zip folderName

2arunpmohan

#To know the ports and process utilisations																									
sudo netstat -ntlp																									

2arunpmohan

#!/bin/bash

if [ -z $1 ] ; then
    echo "Please enter hostname"
    exit
fi

hostname=$1

curl -XDELETE "http://$hostname:9175/pdf-attachment-04"

2arunpmohan

#!/bin/bash

if [ -z $1 ] ; then
    echo "Please enter hostname"
    exit
fi

hostname=$1

curl -XDELETE "http://$hostname:9200/suggest-simple"