Difference between revisions of "Instalasi Sisfokol SD"

From OnnoWiki
Jump to navigation Jump to search
Line 20: Line 20:
 
  quit
 
  quit
  
Copykan [[source code]] SISFOKOL ke folder [[Web]]  
+
Jika masih belajar siapkan [[database]]
  
  cp SISFOKOL_SD_v2.tar.gz /var/www/
+
  # mysql -u root -p123456
  cd /var/www
+
  create database sisfokol_sd;
  tar zxvf SISFOKOL_SD_v2.tar.gz
+
  GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd'@'localhost' IDENTIFIED BY 'sisfokol_sd';
  mv source sisfokol_sd
+
  GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
  cd sisfokol_sd
+
  exit
 +
Copykan source code SISFOKOL ke folder Web
  
Edit file /var/www/sisfokol_sd/inc/config.php
+
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
 +
 
 +
Edit file
 +
 
 +
vi /var/www/sisfokol-sd/inc/config.php
 +
 
 +
Isi kurang lebih
  
 
  $sek_nama = "SD BIASAWAE...";
 
  $sek_nama = "SD BIASAWAE...";
 
  $sek_alamat = "Jl. Raya Biasawae... No... ";
 
  $sek_alamat = "Jl. Raya Biasawae... No... ";
 
  $sek_kontak = "Telp. . . . Fax. . . .";
 
  $sek_kontak = "Telp. . . . Fax. . . .";
  $sumber = "http://localhost/";
+
  $sumber = "http://ip-address-server/sisfokol-sd";
 +
 
 +
$xhostname = "localhost";
 +
$xdatabase = "sisfokol_sd";
 +
$xusername = "sisfokol_sd";
 +
$xpassword = "sisfokol_sd";
 +
 
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
  
Masukan isi [[database]]
+
Masukan isi database
  
  # mysql -u root -p sisfokol_SD_v2 < /var/www/sisfokol_sd/db/agust18_0855.sql
+
  mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql'''
Enter password: '''<TEKAN ENTER>'''
 
  
 
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==
  
  http://localhost/sisfokol_sd
+
  http://ip-address-server/sisfokol-sd
  
 
  tipe      administrator
 
  tipe      administrator
Line 55: Line 71:
 
  password  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
  
  

Revision as of 10:57, 9 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


Download source code SISFOKOL dari Web dari

http://sisfokol.wordpress.com/download/
http://tech.groups.yahoo.com/group/sisfokol/files (bagi anggota mailing list SISFOKOL)


Siapkan database

# mysql -u root -p
password:
create database sisfokol_SD_v2;
GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'root'@'localhost' IDENTIFIED BY ;
GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'root' IDENTIFIED BY ;
quit

Jika masih belajar 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

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

Masukan isi database

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