Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SD"

From OnnoWiki
Jump to navigation Jump to search
 
(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:
+
 
−
  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
  
Line 16: Line 16:
  
 
  mkdir /var/www/sisfokol-sd
 
  mkdir /var/www/sisfokol-sd
−
  mv /usr/local/src/sisfokol_v3_sd_free.tar.bz2 /var/www/sisfokol-sd
+
  mv /usr/local/src/sisfokol_v3_sd_free.tar.bz2 /var/www/sisfokol-sd/
 
  cd /var/www/sisfokol-sd
 
  cd /var/www/sisfokol-sd
 
  tar jxvf sisfokol_v3_sd_free.tar.bz2
 
  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
 
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 32: Line 37:
  
 
  $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 52: 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 91: Line 94:
 
* [[Instalasi Sisfokol SMK]]
 
* [[Instalasi Sisfokol SMK]]
 
* [[Linux Howto]]
 
* [[Linux Howto]]
 +
 +
[[Category: Linux]]
 +
[[Category: Distro Linux]]
 +
[[Category: SchoolOnffLine]]

Latest revision as of 18: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

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