SchoolOnffline: Instalasi SISFOKOL SD: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
Onnowpurbo (talk | contribs)
No edit summary
 
(10 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:
 
  create database sisfokol_SD_v2;
  create database sisfokol_sd;
  GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2'@'localhost' IDENTIFIED BY 'sisfokol_SD_v2';
  GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd'@'localhost' IDENTIFIED BY 'sisfokol_sd';
  GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2' IDENTIFIED BY 'sisfokol_SD_v2';
  GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
  exit
  exit


Copykan source code SISFOKOL ke folder Web  
Copykan source code SISFOKOL ke folder Web  


  mv /usr/local/src/SISFOKOL_SD_v2.tar.gz /var/www/
mkdir /var/www/sisfokol-sd
  cd /var/www
  mv /usr/local/src/sisfokol_v3_sd_free.tar.bz2 /var/www/sisfokol-sd/
  tar zxvf SISFOKOL_SD_v2.tar.gz
  cd /var/www/sisfokol-sd
  mv source sisfokol-sd
  tar jxvf sisfokol_v3_sd_free.tar.bz2
  cd sisfokol-sd
  mv /usr/local/src/sisfokol_v3_sawahsiring_sd.tar.lzma /var/www/sisfokol-sd/
cd /var/www/sisfokol-sd
tar xvf sisfokol_v3_sawahsiring_sd.tar.lzma
cp -Rf /var/www/sisfokol-sd/sisfokol_v3_sawahsiring_sd/source/* /var/www/sisfokol-sd/
  rm -Rf /var/www/sisfokol-sd/sisfokol*


Edit file
Edit file


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


Isi kurang lebih
Isi kurang lebih
Line 30: Line 34:
  $sek_alamat = "Jl. Raya Biasawae... No... ";
  $sek_alamat = "Jl. Raya Biasawae... No... ";
  $sek_kontak = "Telp. . . . Fax. . . .";
  $sek_kontak = "Telp. . . . Fax. . . .";
  $sumber = "http://192.168.0.254/sisfokol-sd/";
  $sumber = "http://192.168.0.254/sisfokol-sd";


  $xhostname = "localhost";
  $xhostname = "localhost";
  $xdatabase = "sisfokol_SD_v2";
  $xdatabase = "sisfokol_sd";
  $xusername = "sisfokol_SD_v2";
  $xusername = "sisfokol_sd";
  $xpassword = "sisfokol_SD_v2";
  $xpassword = "sisfokol_sd";
 


Ubah sesuai dengan data sekolah anda ..
Ubah sesuai dengan data sekolah anda ..


Masukan isi database
  mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql
 
  # mysql -u sisfokol_SD_v2 -psisfokol_SD_v2 sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.sql


Restart MySQL
Restart MySQL


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


==Login ke Sisfokol SD==
==Login ke Sisfokol SD==
Line 53: Line 55:
  http://192.168.0.254/sisfokol-sd
  http://192.168.0.254/sisfokol-sd


  tipe      administrator
  admin
  username  admin
  user : admin
  password  admin
  pass : admin


  tipe      guru
  guru
  username  120001
  user : 120001
  password  7aa9eba
  pass : 120001


  tipe      siswa
  siswa
  username  81000234
  user : 810001
  password  a7d38ff
  pass : 810001


  tipe      Wali Kelas
  wali kelas
  username  120001
  user : 120001
  password  7aa9eba
  pass : 120001


  tipe      Tata Usaha
  tata usaha
  username  120386458
  user : 1200017
  password  c9d7b16
  pass : 1200017


  tipe      Kepala Sekolah
  kepala sekolah
  username  12035464
  user : 1200010
  password  c855ec8
  pass : 1200010


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

Latest revision as of 11:08, 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_sd;
GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd'@'localhost' IDENTIFIED BY 'sisfokol_sd';
GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
exit

Copykan source code SISFOKOL ke folder Web

mkdir /var/www/sisfokol-sd
mv /usr/local/src/sisfokol_v3_sd_free.tar.bz2 /var/www/sisfokol-sd/
cd /var/www/sisfokol-sd
tar jxvf sisfokol_v3_sd_free.tar.bz2
mv /usr/local/src/sisfokol_v3_sawahsiring_sd.tar.lzma /var/www/sisfokol-sd/
cd /var/www/sisfokol-sd
tar xvf sisfokol_v3_sawahsiring_sd.tar.lzma
cp -Rf /var/www/sisfokol-sd/sisfokol_v3_sawahsiring_sd/source/* /var/www/sisfokol-sd/
rm -Rf /var/www/sisfokol-sd/sisfokol*

Edit file

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

Isi kurang lebih

$sek_nama = "SD BIASAWAE...";
$sek_alamat = "Jl. Raya Biasawae... No... ";
$sek_kontak = "Telp. . . . Fax. . . .";
$sumber = "http://192.168.0.254/sisfokol-sd";
$xhostname = "localhost";
$xdatabase = "sisfokol_sd";
$xusername = "sisfokol_sd";
$xpassword = "sisfokol_sd";

Ubah sesuai dengan data sekolah anda ..

mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql

Restart MySQL

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

Login ke Sisfokol SD

http://192.168.0.254/sisfokol-sd
admin
user : admin
pass : admin
guru
user : 120001
pass : 120001
siswa
user : 810001
pass : 810001
wali kelas
user : 120001
pass : 120001
tata usaha
user : 1200017
pass : 1200017
kepala sekolah
user : 1200010
pass : 1200010

Pranala Menarik