Difference between revisions of "Instalasi Sisfokol SD"

From OnnoWiki
Jump to navigation Jump to search
 
(4 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
  php5-mysql php5-gd php5-curl php-pear
 
  php5-mysql php5-gd php5-curl php-pear
  
 +
Siapkan [[database]]
  
Download source code SISFOKOL dari Web dari
+
mysql -u root -p123456
  
http://sisfokol.wordpress.com/download/
 
http://tech.groups.yahoo.com/group/sisfokol/files (bagi anggota mailing list SISFOKOL)
 
 
Jika masih belajar siapkan [[database]]
 
 
# mysql -u root -p123456
 
 
  create database sisfokol_sd;
 
  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'@'localhost' IDENTIFIED BY 'sisfokol_sd';
 
  GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
 
  GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
 
  exit
 
  exit
 +
 
Copykan source code SISFOKOL ke folder Web  
 
Copykan source code SISFOKOL ke folder Web  
  
 
  mkdir /var/www/sisfokol-sd
 
  mkdir /var/www/sisfokol-sd
  cp sisfokol_v3_sd_free.tar.bz2 /var/www/sisfokol-sd
+
  cp 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
 +
 +
cp 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
Line 39: Line 41:
 
  $xusername = "sisfokol_sd";
 
  $xusername = "sisfokol_sd";
 
  $xpassword = "sisfokol_sd";
 
  $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 -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql'''
 
  
 
Restart MySQL
 
Restart MySQL
Line 57: Line 56:
 
  http://ip-address-server/sisfokol-sd
 
  http://ip-address-server/sisfokol-sd
  
  tipe      administrator
+
  admin
  username  admin
+
  user : admin
  password  admin
+
  pass : admin
 
 
tipe      guru
 
username  120001
 
password  120001
 
  
  tipe      siswa
+
  guru
  username  810001
+
  user : 120001
  password  810001
+
  pass : 120001
  
  tipe      Wali Kelas
+
  siswa
  username  120001
+
  user : 810001
  password  120001
+
  pass : 810001
  
  tipe      Tata Usaha
+
  wali kelas
  username  1200017
+
  user : 120001
  password  1200017
+
  pass : 120001
  
  tipe      Kepala Sekolah
+
  tata usaha
  username  1200010
+
  user : 1200017
  password  1200010
+
  pass : 1200017
  
 +
kepala sekolah
 +
user : 1200010
 +
pass : 1200010
  
  

Latest revision as of 13:31, 4 January 2011

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
cp sisfokol_v3_sd_free.tar.bz2 /var/www/sisfokol-sd/
cd /var/www/sisfokol-sd
tar jxvf sisfokol_v3_sd_free.tar.bz2
cp 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://ip-address-server/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://ip-address-server/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