Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SMK"

From OnnoWiki
Jump to navigation Jump to search
 
(One intermediate revision 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
  
 
Siapkan [[database]]
 
Siapkan [[database]]
  
  # mysql -u root -p123456
+
  mysql -u root -p123456
 +
 
 
  create database sisfokol_smk;
 
  create database sisfokol_smk;
 
  GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk'@'localhost' IDENTIFIED BY 'sisfokol_smk';
 
  GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk'@'localhost' IDENTIFIED BY 'sisfokol_smk';
Line 18: Line 19:
 
  cd /var/www/sisfokol-smk
 
  cd /var/www/sisfokol-smk
 
  unzip sisfokol_v3_smk_free.zip
 
  unzip sisfokol_v3_smk_free.zip
 +
mv /usr/local/src/sisfokol_v3_sawahsiring_smk.tar.lzma /var/www/sisfokol-smk/
 +
cd /var/www/sisfokol-smk/
 +
tar xvf sisfokol_v3_sawahsiring_smk.tar.lzma
 +
cp -Rf sisfokol_v3_sawahsiring_smk/source/* /var/www/sisfokol-smk/
 +
rm -Rf sisfokol_v3_s*
  
 
Edit file
 
Edit file
Line 39: Line 45:
 
Masukan isi [[database]]
 
Masukan isi [[database]]
  
  mysql -u sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol.sql
+
  mysql -u sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol_v3_smk.sql
  
 
Restart MySQL
 
Restart MySQL

Latest revision as of 14:34, 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

Siapkan database

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

Copykan source code SISFOKOL ke folder Web

mkdir /var/www/sisfokol-smk
mv /usr/local/src/sisfokol_v3_smk_free.zip /var/www/sisfokol-smk
cd /var/www/sisfokol-smk
unzip sisfokol_v3_smk_free.zip
mv /usr/local/src/sisfokol_v3_sawahsiring_smk.tar.lzma /var/www/sisfokol-smk/
cd /var/www/sisfokol-smk/
tar xvf sisfokol_v3_sawahsiring_smk.tar.lzma 
cp -Rf sisfokol_v3_sawahsiring_smk/source/* /var/www/sisfokol-smk/
rm -Rf sisfokol_v3_s*

Edit file

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

Pastikan

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

Ubah sesuai dengan data sekolah anda ..

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

Masukan isi database

mysql -u sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol_v3_smk.sql

Restart MySQL

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

Login ke SISFOKOL SMK

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