Difference between revisions of "Instalasi Sisfokol SMK"

From OnnoWiki
Jump to navigation Jump to search
 
(3 intermediate revisions 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]]
  
Download source code SISFOKOL dari Web dari
+
mysql -u root -p123456
  
  http://sisfokol.wordpress.com/download/
+
  create database sisfokol_smk;
  http://tech.groups.yahoo.com/group/sisfokol/files (bagi anggota mailing list SISFOKOL)
+
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]]
  
Siapkan database
+
mkdir /var/www/sisfokol-smk
 +
cp sisfokol_v3_smk_free.zip /var/www/sisfokol-smk
 +
cd /var/www/sisfokol-smk
 +
unzip sisfokol_v3_smk_free.zip
  
  # mysql -u root -p
+
  cp sisfokol_v3_sawahsiring_smk.tar.lzma /var/www/sisfokol-smk/
  password:
+
  cd /var/www/sisfokol-smk/
  mysql> create database sisfokol_smk_v2;
+
  tar xvf sisfokol_v3_sawahsiring_smk.tar.lzma
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'root'@'localhost' IDENTIFIED BY '';
+
  cp -Rf sisfokol_v3_sawahsiring_smk/source/* /var/www/sisfokol-smk/
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'root' IDENTIFIED BY '';
+
  rm -Rf sisfokol_v3_s*
mysql> quit
 
  
Copykan source code SISFOKOL ke folder Web
+
Edit file
  
  # cp SISFOKOL_SMK_v2.tar.gz /var/www/
+
  vi /var/www/sisfokol-smk/inc/config.php
# cd /var/www
 
# tar zxvf SISFOKOL_SMK_v2.tar.gz
 
# mv source sisfokol_smk
 
# cd sisfokol_smk
 
  
Edit file /var/www/sisfokol_sd/inc/config.php
+
Pastikan
  
 
  $sek_nama = "SMK BIASAWAE...";
 
  $sek_nama = "SMK 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-smk";
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
  
Masukan isi database
+
$xhostname = "localhost";
 +
$xdatabase = "sisfokol_smk";
 +
$xusername = "sisfokol_smk";
 +
$xpassword = "sisfokol_smk";
  
  # mysql -u root -p sisfokol_smk_v2 < /var/www/sisfokol_smk/db/sept04_1155.sql
+
Masukan isi [[database]]
Enter password: '''<TEKAN ENTER>'''
+
 
 +
  mysql -u sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol_v3_smk.sql
  
 
Restart MySQL
 
Restart MySQL
  
  # /etc/init.d/mysql restart
+
  /etc/init.d/mysql restart
 
+
rm -Rf /var/www/sisfokol-smk/install
 +
rm -Rf /var/www/sisfokol-smk/db
  
==Login ke Sisfokol SMK==
+
==Login ke SISFOKOL SMK==
  
  http://localhost/sisfokol_smk
+
  http://ip-address-server/sisfokol-smk
  
 
  tipe      administrator
 
  tipe      administrator
Line 57: Line 64:
 
  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==

Latest revision as of 13:44, 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_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
cp sisfokol_v3_smk_free.zip /var/www/sisfokol-smk
cd /var/www/sisfokol-smk
unzip sisfokol_v3_smk_free.zip
cp 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://ip-address-server/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://ip-address-server/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