Kamis, 15 Februari 2018

Firebird isql shell command in Linux

- vim yourshellsql.sh

#!/bin/sh/usr/bin/isql-fb -user YOURUSERNAME -password YOURPASSWORD -database -x '/path/DATABASE.GDB' <<EOF

CONNECT /path/DATABASE.GDB;

SELECT * FROM YOURTABLE;

UPDATE YOURTABLE SET NAME = '';

COMMIT WORK;

go

QUIT

EXIT

EOF


- ./yourshellsql.sh


source:

- https://it.toolbox.com/question/how-to-invoke-sybase-commands-in-a-shell-script-040411

- https://www.unix.com/shell-programming-and-scripting/45212-isql-query-unix-shell-script.html

Rabu, 14 Februari 2018

SSL certificate problem: unable to get local issuer certificate

- config php.ini
- enable curl.cainfo=
- edit curl.cainfo= to curl.cainfo=/your/path/cacert.pem (i download from https://curl.haxx.se/ca/cacert.pem, <my development>)

install curl in Windows 10

- run Command Prompt as Administrator
- paste @"%SystemRoot%\System32\WindowsPowerShell\v1.0\powershell.exe" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin"
choco install curl

Source: https://chocolatey.org/install#installing-chocolatey

Rabu, 07 Februari 2018

virtual environment python in Windows

- pip install virtualenv
- pip install virtualenvwrapper-win
- mkvirtualenv virtualpython3

result:
C:\Users\webDev\Envs is not a directory, creating
Using base prefix 'c:\\python36'
New python executable in C:\Users\webDev\Envs\virtualpython3\Scripts\python.exe
Installing setuptools, pip, wheel...done.
(virtualpython3) webDev@WEBDEV-PC E:\doni\

source:
- https://virtualenv.pypa.io/en/stable/userguide/
- http://timmyreilly.azurewebsites.net/python-pip-virtualenv-installation-on-windows/
- https://stackoverflow.com/questions/46869528/install-python-3-6-3-in-virtualenv-using-pip-in-windows-10

Kamis, 01 Februari 2018

remote AWS using terminal on Mac OSX

- Convert .ppk to .pem

  • puttygen server.ppk -O private-openssh -o server.pem (if puttygen not installed, brew install putty)

- chmod go-rw server.pem
- ssh -i server.pem user@hostname

Source:

  • https://stackoverflow.com/questions/33273180/create-a-pem-from-a-ppk-file
  • https://www.ssh.com/ssh/putty/mac/
  • https://www.youtube.com/watch?v=q6Hm-JIzjT8