SchoolOnffline: Instalasi SISFOKOL SLTP: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
← Older editNewer edit →
Onnowpurbo (talk | contribs)
69,477 edits
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
Line 7: Line 7:
Siapkan database
Siapkan database


  # mysql -u root -p
  # mysql -u root -p123456
  password:
  create database sisfokol_sltp;
mysql> create database sisfokol_sltp_v2;
  GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp';
  mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2'@'localhost' IDENTIFIED BY 'sisfokol_sltp_v2';
  GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp' IDENTIFIED BY 'sisfokol_sltp';
  mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2' IDENTIFIED BY 'sisfokol_sltp_v2';
  exit
  mysql> 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
  mv /usr/local/src/sisfokol_v3_sltp_free.tar.bz2 /var/www/sisfokol-smp
  mv /usr/local/src/sisfokol_v3_sltp_free.zip /var/www/sisfokol-smp
  cd /var/www/sisfokol-smp
  cd /var/www/sisfokol-smp
  tar jxvf sisfokol_v3_sltp_free.tar.bz2
  unzip sisfokol_v3_sltp_free.zip


Edit file  
Edit file  
Line 35: Line 34:


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


Masukan isi database
Masukan isi database


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


Restart MySQL
Restart MySQL


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


==Login ke Sisfokol SMP==
==Login ke Sisfokol SMP==
Line 59: Line 58:
  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 03:49, 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_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.zip /var/www/sisfokol-smp
cd /var/www/sisfokol-smp
unzip sisfokol_v3_sltp_free.zip

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

Retrieved from "https://lms.onnocenter.or.id/wiki/index.php?title=SchoolOnffline:_Instalasi_SISFOKOL_SLTP&oldid=14553"