SchoolOnffline: Instalasi SISFOKOL SLTP

From OnnoWiki
Revision as of 09:21, 25 January 2010 by Onnowpurbo (talk | contribs)
Jump to navigation Jump to search

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 -p
password:
mysql> create database sisfokol_sltp_v2;
mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2'@'localhost' IDENTIFIED BY 'sisfokol_sltp_v2';
mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2' IDENTIFIED BY 'sisfokol_sltp_v2';
mysql> exit

Copykan source code SISFOKOL ke folder Web

mkdir /var/www/sisfokol-smp
mv /usr/local/src/sisfokol_v3_sltp_free.tar.bz2 /var/www/sisfokol-smp
cd /var/www/sisfokol-smp
tar jxvf sisfokol_v3_sltp_free.tar.bz2 

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_v2";
$xusername = "sisfokol_sltp_v2";
$xpassword = "sisfokol_sltp_v2";

Masukan isi database

# mysql -u sisfokol_sltp_v2 -psisfokol_sltp_v2 sisfokol_sltp_v2 < /var/www/sisfokol-smp/db/agust18_0929.sql 


Restart MySQL

# /etc/init.d/mysql restart


Login ke Sisfokol SMP

http://192.168.0.254/sisfokol-smp
tipe      administrator
username  admin
password  admin
tipe      guru
username  120001
password  7aa9eba
tipe      siswa
username  81000234
password  a7d38ff
tipe      Wali Kelas
username  120001
password  7aa9eba
tipe      Tata Usaha
username  120386458
password  c9d7b16
tipe      Kepala Sekolah
username  12035464
password  c855ec8

Pranala Menarik