Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SD"

From OnnoWiki
Jump to navigation Jump to search
Line 6: Line 6:
 
Siapkan database
 
Siapkan database
  
−
  # mysql -u root -p
+
  # mysql -u root -p123456
−
password:
+
  create database sisfokol_sd;
−
  create database 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'@'localhost' IDENTIFIED BY 'sisfokol_SD_v2';
+
  GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
−
  GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2' IDENTIFIED BY 'sisfokol_SD_v2';
 
 
  exit
 
  exit
  
Line 32: Line 31:
  
 
  $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";
  
  
Line 41: Line 40:
 
Masukan isi database
 
Masukan isi database
  
−
  # mysql -u sisfokol_SD_v2 -psisfokol_SD_v2 sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.sql
+
  mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql
  
 
Restart MySQL
 
Restart MySQL
  
−
  # /etc/init.d/mysql restart
+
  /etc/init.d/mysql restart
  
  
Line 58: Line 57:
 
  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==

Revision as of 10:41, 25 January 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

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 ..

Masukan isi database 

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

Restart MySQL 

/etc/init.d/mysql restart


Login ke Sisfokol SD

http://192.168.0.254/sisfokol-sd

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

Retrieved from "https://onnocenter.or.id/wiki/index.php?title=SchoolOnffline:_Instalasi_SISFOKOL_SD&oldid=14550"