Skip to main content

Defining tomcat and mysql server Amazon EC2 instance

-- Create new amazon ec2 instance
http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EC2_GetStarted.html

-- Give permisson to pem file
chmod 400 mycertificate.pem

-- Connect to EC2 instance
ssh -i mycertificate.pem ubuntu@ec2-51-51-51-51.eu-west-1.compute.amazonaws.com

-- Installation Oracle Java 1.8
$ wget --no-check-certificate --no-cookies --header "Cookie: oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u92-b14/jdk-8u92-linux-x64.tar.gz
$ tar -xzvf jdk-8u92-linux-x64.tar.gz
$ sudo mkdir -p /usr/java/
$ sudo mv jdk1.8.0_92/ /usr/java/
$ sudo vim  /etc/profile
        JAVA_HOME=/usr/java/jdk1.8.0_92
        PATH=$PATH:$HOME/bin:$JAVA_HOME/bin
        JRE_HOME=/usr/java/jdk1.8.0_92/jre
        PATH=$PATH:$HOME/bin:$JRE_HOME/bin
        export JAVA_HOME
        export JRE_HOME
        export PATH  
$ source /etc/profile

-- Installation to tomcat server
$ wget http://mirror.idealhosting.net.tr/Apache/tomcat/tomcat-8/v8.5.13/bin/apache-tomcat-8.5.13.tar.gz
$ tar -xzvf apache-tomcat-8.5.13.tar.gz
$ sudo mkdir /opt/server
$ sudo mv apache-tomcat-8.5.13/ /opt/server/
$ sh /opt/server/apache-tomcat-8.5.13/bin/catalina.sh start


-- Installing mysql server
$ sudo apt-get install mysql-server
root pass : ************

$ sudo mysql_secure_installation

$ sudo vim /etc/mysql/mysql.conf.d/myconf.cnf
    [mysqld]
    lower_case_table_names=1
    init_connect= 'SET NAMES utf8'
    init_connect= 'SET collation_connection = utf8_general_ci'
    collation-server        = utf8_general_ci
    character-set-server    = utf8
    bind-address            = 0.0.0.0
 
$ sudo service mysql restart

$ mysql -u root -p

mysql> CREATE DATABASE my_schema CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> CREATE USER 'my_schema_user'@'%' IDENTIFIED BY 'A*aBb*123-q';
mysql> GRANT ALL PRIVILEGES ON my_schema. * TO 'my_schema_user'@'%';
mysql> FLUSH PRIVILEGES;

-- Mysq db backup and restore
mysqldump -h ec2-51-51-51-51.eu-west-1.compute.amazonaws.com -u my_schema_user -p my_schema > my_schema_backup.sql
mysql -h ec2-51-51-51-51.eu-west-1.compute.amazonaws.com -u my_schema_user -p my_schema <  my_schema_backup.sql

-- Upload file
scp -i mycertificate.pem myapp.war ubuntu@ec2-51-51-51-51.eu-west-1.compute.amazonaws.com:/home/ubuntu/upload/

Comments

Popular posts from this blog

Offline AI Coding in VSCode: Continue + Ollama Complete Setup Guide

Want GitHub Copilot-level code assistance — but fully offline, air-gapped, and private? This guide walks you through setting up Continue (a VSCode extension) with Ollama (a local model runner) so you get chat, autocomplete, and inline editing powered entirely by models running on your own machine. No internet required at runtime. Table of Contents What Are Continue and Ollama? Prerequisites & Hardware Requirements Choosing the Right Models Step 1 — Installing Ollama & Pulling Models Step 2 — Installing Continue in VSCode (Offline) Step 3 — Configuring config.yaml Step 4 — Disabling Telemetry Step 5 — Usage & Shortcuts Troubleshooting What Are Continue and Ollama? Continue is an open-source VSCode (and JetBrains) extension that adds AI-powered coding features directly into your editor — think chat, inline edits, and tab autocomplete. By default it can connect to Claude, GPT-4, or any API. But it also supports local providers , which is exactly what we want here. Ollama i...

Local LLM on Ubuntu (CPU-Only): Ollama + Qwen Coder + Open WebUI + RAG Setup

Local LLM on Ubuntu (CPU-Only): Ollama + Qwen Coder + Open WebUI + RAG Run a private, high-performance internal AI coding assistant on your own hardware—no GPU required. Feb 13, 2026 Qwen 2.5 Coder RAG Enabled Enterprise Ready Keeping your code and documents on your own infrastructure is the gold standard for enterprise security. By combining Ollama , Qwen Coder , and Open WebUI , we can build a production-grade AI assistant that respects your privacy. Environment: CPU-only Ubuntu server (e.g., i9/Threadripper) with 64GB+ RAM for smooth 14B model inference. 1. System Preparation First, update your local environment and install necessary dependencies: sudo apt update && sudo apt upgrade -y sudo apt install -y curl git ca-certificates lscpu 2. Ollama & Model Tuning Install Ollama and optimize the configuration for CPU-only inference by setting the thread count: ...