Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SLTP"

From OnnoWiki
Jump to navigation Jump to search
 
(2 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 unrar
  
 
Siapkan [[database]]
 
Siapkan [[database]]
  
  # mysql -u root -p123456
+
  mysql -u root -p123456
 +
 
 
  create database sisfokol_sltp;
 
  create database sisfokol_sltp;
 
  GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp';
 
  GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp';
Line 12: Line 13:
 
  exit
 
  exit
  
Copykan source code SISFOKOL ke folder Web  
+
Copykan [[source code]] SISFOKOL ke folder [[Web]]
  
 
  mkdir /var/www/sisfokol-smp
 
  mkdir /var/www/sisfokol-smp
Line 19: Line 20:
 
  unrar x sisfokol_v3_sltp_free.rar
 
  unrar x sisfokol_v3_sltp_free.rar
 
  mv sisfokol_v3_sltp_free/* .
 
  mv sisfokol_v3_sltp_free/* .
 
+
rm -Rf sisfokol_v3_sltp_free*
 +
mv /usr/local/src/sisfokol_v3_sawahsiring_sltp.tar.lzma /var/www/sisfokol-smp/
 +
cd /var/www/sisfokol-smp
 +
tar xvf sisfokol_v3_sawahsiring_sltp.tar.lzma
 +
cp -Rf sisfokol_v3_sawahsiring_sltp/source/* /var/www/sisfokol-smp/
 +
rm -Rf /var/www/sisfokol-smp/sisfokol_v3_sawahsiring_sltp*
  
 
Edit file  
 
Edit file  
Line 41: Line 47:
 
Masukan isi database
 
Masukan isi database
  
  mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol.sql  
+
  mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol_v3_sltp.sql
  
 
Restart MySQL
 
Restart MySQL

Latest revision as of 14:32, 17 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 unrar

Siapkan database

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

Copykan source code SISFOKOL ke folder Web

mkdir /var/www/sisfokol-smp
mv /usr/local/src/sisfokol_v3_sltp_free.rar /var/www/sisfokol-smp
cd /var/www/sisfokol-smp
unrar x sisfokol_v3_sltp_free.rar
mv sisfokol_v3_sltp_free/* .
rm -Rf sisfokol_v3_sltp_free*
mv /usr/local/src/sisfokol_v3_sawahsiring_sltp.tar.lzma /var/www/sisfokol-smp/
cd /var/www/sisfokol-smp
tar xvf sisfokol_v3_sawahsiring_sltp.tar.lzma 
cp -Rf sisfokol_v3_sawahsiring_sltp/source/* /var/www/sisfokol-smp/
rm -Rf /var/www/sisfokol-smp/sisfokol_v3_sawahsiring_sltp*

Edit file

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

Pastikan

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

Ubah sesuai dengan data sekolah anda ..

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

Masukan isi database

mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol_v3_sltp.sql

Restart MySQL

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

Login ke Sisfokol SMP

http://192.168.0.254/sisfokol-smp
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