Troubleshooting

Troubleshooting

IntelliJ

• Open using gradle import (enable gradle plugin)
• Enable annotations (Preferences > Annotations)
• Enable Lombok plugin
• Link the JDK properly
• Settings → Editor → General → Ensure line feed at file end on Save

Closing port

Under Linux

lsof -i tcp:8180 | grep java | head -n 1 | awk '{print $2}' | xargs kill -9

Under Windows (yeah, I know...)

PS C:\Users\Hervé> netstat -ano | grep "8080" | head -1
  TCP    0.0.0.0:8080           0.0.0.0:0              LISTENING       14500
PS C:\Users\Hervé> taskkill /PID 14500 /F
SUCCESS: The process with PID 14500 has been terminated.

Travis

• gem install travis -v 1.8.8 --no-rdoc --no-ri
• travis encrypt $(heroku auth:token) --add deploy.api_key -r hahleung/ohnana-whats
• travis encrypt MY_VAR_ENV=S3Cr3t! --add -r hahleung/ohnana-whats => $MY_VAR_ENV

MySQL

MacOS installation

brew install mysql
brew services start mysql
mysql_secure_installation
mysql -uroot -ppassword
mysql>

Shell

mysql> create database db_ohnana
mysql> create user 'springuser'@'localhost' identified by 'password';
mysql> grant all on db_ohnana.* to 'springuser'@'localhost';

PostgreSQL

MacOS Installation

brew install postgresql

Is postrgresql service running?

Create postgres user:

# sudo mkdir /usr/local/var/postgres
# sudo chmod 775 /usr/local/var/postgres
# sudo chown construct /usr/local/var/postgres
# initdb /usr/local/var/postgres
sudo su - postgres
initdb -E UTF8
createuser -s -U postgres

Create springboot user and grant all privileges on db_ohnana:

psql -U postgres
> CREATE DATABASE db_ohnana;
> CREATE USER springboot WITH LOGIN PASSWORD password;
> GRANT ALL PRIVILEGES ON DATABASE db_ohnana TO springboot;
> \q

(alternative to enter in the psql console: psql -d postgres -U yourPrimaryUser)

Which DB are here?

psql -U postgres -l

(alternative, in the psql console: \l)

Exit the psql console: \q Connect to a database: \c db_ohnana Show table inside a connected database: \dt Simple thing: select * from session;