Catatan Robbi: problem solving

Thursday, 9 March 2017

install library php oci8 di linux

untuk mendukung php dapat membuat koneksi ke database oracle, dibutuhkan library dan plugins tambahan.

pertama, download instant client dari official website oracle instantclient for linux x86/64. instant client yang saya gunakan adalah instantclient-basic-linux.x64-12.1.0.2.0.zip dan jangan lupa download juga sdknya instantclient-sdk-linux.x64-12.1.0.2.0.zip

langkah diatas untuk membuat oracle client siap untuk digunakan. setelah berhasil maka install oci 8 (library php untuk fungsi-fungsi oracle di php). berikut link untuk unduh librarynya oci8 list package

instantclient, /opt/oracle/instantclient diisi saat muncul prompt untuk oracle home director.

terakhir edit file php.ini dan tambahkan extension oci8.so di file tersebut.
restart web server dan tes koneksi ke oracle.
semoga bermanfaat.

Integrasi nginx dan php-5 fpm

Tidak seperti apache yang telah satu package dengan php, nginx merupakan web server yang beridiri sendiri. Sehingga diperlukan konfigurasi manual untuk integrasi nginx dengan php.

Sebelumnya pastikan web server nginx dan php-fpm telah terinstall.
edit file konfigurasi nginx di /etc/nginx/sites-available/default

##
# You should look at the following URL's in order to grasp a solid understanding
# of Nginx configuration files in order to fully unleash the power of Nginx.
# http://wiki.nginx.org/Pitfalls
# http://wiki.nginx.org/QuickStart
# http://wiki.nginx.org/Configuration
#
# Generally, you will want to move this file somewhere, and start with a clean
# file but keep this around for reference. Or just disable in sites-enabled.
#
# Please see /usr/share/doc/nginx-doc/examples/ for more detailed examples.
##

# Default server configuration
#
server {
 listen 80 default_server;
 listen [::]:80 default_server;

# SSL configuration
 #
 # listen 443 ssl default_server;
 # listen [::]:443 ssl default_server;
 #
 # Self signed certs generated by the ssl-cert package
 # Don't use them in a production server!
 #
 # include snippets/snakeoil.conf;

root /var/www/html;

# Add index.php to the list if you are using PHP
 index index.html index.htm index.nginx-debian.html index.php;

server_name localhost;

location / {
  # First attempt to serve request as file, then
  # as directory, then fall back to displaying a 404.
  try_files $uri $uri/ =404;
 }

# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
 #
 location ~ \.php$ {
 # include snippets/fastcgi-php.conf;
 #
 # # With php5-cgi alone:
 # fastcgi_pass 127.0.0.1:9000;
 # # With php5-fpm:
  fastcgi_pass unix:/var/run/php5-fpm.sock;
  fastcgi_index index.php;
  fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
  fastcgi_param  REQUEST_URI      $request_uri;
  include fastcgi_params;
 }

# deny access to .htaccess files, if Apache's document root
 # concurs with nginx's one
 #
 #location ~ /\.ht {
 # deny all;
 #}
}

# Virtual Host configuration for example.com
#
# You can move that to a different file under sites-available/ and symlink that
# to sites-enabled/ to enable it.
#
#server {
# listen 80;
# listen [::]:80;
#
# server_name example.com;
#
# root /var/www/example.com;
# index index.html;
#
# location / {
#  try_files $uri $uri/ =404;
# }
#}

server {
 listen 80;
 listen [::]:80;

server_name dev.cms;

root /var/www/html/cms/;
 index index.html index.php;

location / {
  try_files $uri $uri/ /index.php;
 }

location ~ \.php$ {
 # include snippets/fastcgi-php.conf;
 #
 # # With php5-cgi alone:
 # fastcgi_pass 127.0.0.1:9000;
 # # With php5-fpm:
  fastcgi_pass unix:/var/run/php5-fpm.sock;
  fastcgi_index index.php;
  fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
  fastcgi_param  REQUEST_URI      $request_uri;
  include fastcgi_params;
 }
}

save file tersebut, kemudian restart service nginx. buatlah file php dan kemudian coba akses. jika berhasil maka akan muncul result dari script php tersebut .

Pages

Thursday, 9 March 2017

install library php oci8 di linux

Integrasi nginx dan php-5 fpm