SchoolOnffline: Instalasi SISFOKOL SLTA: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
No edit summary
Onnowpurbo (talk | contribs)
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
Siapkan dependencies
Siapkan dependencies


  # apt-get install apache2 mysql-server libmysqlclient15-dev libphp-adodb libgd2-xpm libgd2-xpm-dev \
  apt-get install apache2 mysql-server libmysqlclient15-dev libphp-adodb libgd2-xpm libgd2-xpm-dev \
  php5-mysql php5-gd php5-curl php-pear
  php5-mysql php5-gd php5-curl php-pear


Siapkan [[database]]
Siapkan [[database]]


  # mysql -u root -p
  mysql -u root -p123456
password:
 
  mysql> create database sisfokol_slta_v2;
  create database sisfokol_slta;
  mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2'@'localhost' IDENTIFIED BY 'sisfokol_slta_v2';
  GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta';
  mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2' IDENTIFIED BY 'sisfokol_slta_v2';
  GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta';
  mysql> exit
  exit


Copykan [[source code]] SISFOKOL ke folder [[Web]]  
Copykan [[source code]] SISFOKOL ke folder [[Web]]  


  # mv /usr/local/src/SISFOKOL_SLTA_v2.tar.gz /var/www/
  mkdir /var/www/sisfokol-sma
  # cd /var/www
mv /usr/local/src/sisfokol_v3_slta_free.tar.bz2 /var/www/sisfokol-sma
  # tar zxvf SISFOKOL_SLTA_v2.tar.gz
  cd /var/www/sisfokol-sma
  # mv source sisfokol-sma
  tar jxvf sisfokol_v3_slta_free.tar.bz2
  # cd sisfokol-sma
  mv /usr/local/src/sisfokol_v3_sawahsiring_slta.tar.lzma /var/www/sisfokol-sma/
cd /var/www/sisfokol-sma/
tar xvf sisfokol_v3_sawahsiring_slta.tar.lzma
cp -Rf /var/www/sisfokol-sma/sisfokol_v3_sawahsiring_slta/source/* /var/www/sisfokol-sma/
  rm -Rf /var/www/sisfokol-sma/sisfokol_v3_s*


Edit file
Edit file


  # vi /var/www/sisfokol-sma/inc/config.php
  vi /var/www/sisfokol-sma/inc/config.php


Pastikan
Pastikan
Line 35: Line 39:


  $xhostname = "localhost";
  $xhostname = "localhost";
  $xdatabase = "sisfokol_slta_v2";
  $xdatabase = "sisfokol_slta";
  $xusername = "sisfokol_slta_v2";
  $xusername = "sisfokol_slta";
  $xpassword = "sisfokol_slta_v2";
  $xpassword = "sisfokol_slta";


Masukan isi [[database]]


Masukan isi database
  mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol_v3_slta.sql
 
  # mysql -u sisfokol_slta_v2 -psisfokol_slta_v2 sisfokol_slta_v2 < /var/www/sisfokol-sma/db/agust15_1505.sql  


Restart MySQL
Restart MySQL


  # /etc/init.d/mysql restart
  /etc/init.d/mysql restart
rm -Rf /var/www/sisfokol-sma/install
rm -Rf /var/www/sisfokol-sma/db




Line 59: Line 64:
  tipe      guru
  tipe      guru
  username  120001
  username  120001
  password  7aa9eba
  password  120001


  tipe      siswa
  tipe      siswa
  username  81000234
  username  810001
  password  a7d38ff
  password  810001


  tipe      Wali Kelas
  tipe      Wali Kelas
  username  120001
  username  120001
  password  7aa9eba
  password  120001


  tipe      Tata Usaha
  tipe      Tata Usaha
  username  120386458
  username  1200017
  password  c9d7b16
  password  1200017


  tipe      Kepala Sekolah
  tipe      Kepala Sekolah
  username  12035464
  username  1200010
  password  c855ec8
  password  1200010


==Pranala Menarik==
==Pranala Menarik==
Line 92: Line 97:
* [[Instalasi Sisfokol SMK]]
* [[Instalasi Sisfokol SMK]]
* [[Linux Howto]]
* [[Linux Howto]]
[[Category: Linux]]
[[Category: Distro Linux]]
[[Category: SchoolOnffLine]]

Latest revision as of 11:36, 20 November 2010

Siapkan dependencies

apt-get install apache2 mysql-server libmysqlclient15-dev libphp-adodb libgd2-xpm libgd2-xpm-dev \
php5-mysql php5-gd php5-curl php-pear

Siapkan database

mysql -u root -p123456
create database sisfokol_slta;
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta';
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta';
exit

Copykan source code SISFOKOL ke folder Web

mkdir /var/www/sisfokol-sma
mv /usr/local/src/sisfokol_v3_slta_free.tar.bz2 /var/www/sisfokol-sma
cd /var/www/sisfokol-sma
tar jxvf sisfokol_v3_slta_free.tar.bz2 
mv /usr/local/src/sisfokol_v3_sawahsiring_slta.tar.lzma /var/www/sisfokol-sma/
cd /var/www/sisfokol-sma/
tar xvf sisfokol_v3_sawahsiring_slta.tar.lzma 
cp -Rf /var/www/sisfokol-sma/sisfokol_v3_sawahsiring_slta/source/* /var/www/sisfokol-sma/
rm -Rf /var/www/sisfokol-sma/sisfokol_v3_s*

Edit file

vi /var/www/sisfokol-sma/inc/config.php

Pastikan

$sek_nama = "SMA BIASAWAE...";
$sek_alamat = "Jl. Raya Biasawae... No... ";
$sek_kontak = "Telp. . . . Fax. . . .";
$sumber = "http://192.168.0.254/sisfokol-sma";

Ubah sesuai dengan data sekolah anda ..

$xhostname = "localhost";
$xdatabase = "sisfokol_slta";
$xusername = "sisfokol_slta";
$xpassword = "sisfokol_slta";

Masukan isi database

mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol_v3_slta.sql

Restart MySQL

/etc/init.d/mysql restart
rm -Rf /var/www/sisfokol-sma/install
rm -Rf /var/www/sisfokol-sma/db


Login ke Sisfokol SLTA

http://192.168.0.254/sisfokol-sma
tipe      administrator
username  admin
password  admin
tipe      guru
username  120001
password  120001
tipe      siswa
username  810001
password  810001
tipe      Wali Kelas
username  120001
password  120001
tipe      Tata Usaha
username  1200017
password  1200017
tipe      Kepala Sekolah
username  1200010
password  1200010

Pranala Menarik