Difference between revisions of "Instalasi Sisfokol SMP"

From OnnoWiki
Jump to navigation Jump to search
 
(7 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 unrar
  
 +
Siapkan [[database]]
  
−
Download source code SISFOKOL dari Web dari
+
mysql -u root -p123456
  
−
  http://sisfokol.wordpress.com/download/
+
  create database sisfokol_sltp;
−
  http://tech.groups.yahoo.com/group/sisfokol/files (bagi anggota mailing list SISFOKOL)
+
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]]
  
−
Siapkan database
+
mkdir /var/www/sisfokol-smp
 +
cp sisfokol_v3_sltp_free.rar /var/www/sisfokol-smp
 +
cd /var/www/sisfokol-smp
 +
unrar x sisfokol_v3_sltp_free.rar
 +
mv sisfokol_v3_sltp_free/* .
 +
rm -Rf sisfokol_v3_sltp_free*
  
−
  # mysql -u root -p
+
  cp sisfokol_v3_sawahsiring_sltp.tar.lzma /var/www/sisfokol-smp/
−
  password:
+
  cd /var/www/sisfokol-smp
−
  mysql> create database sisfokol_sltp_v2;
+
  tar xvf sisfokol_v3_sawahsiring_sltp.tar.lzma
−
  mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'root'@'localhost' IDENTIFIED BY '';
+
  cp -Rf sisfokol_v3_sawahsiring_sltp/source/* /var/www/sisfokol-smp/
−
  mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'root' IDENTIFIED BY '';
+
  rm -Rf /var/www/sisfokol-smp/sisfokol_v3_sawahsiring_sltp*
−
mysql> quit
 
  
−
Copykan source code SISFOKOL ke folder Web
+
Edit file
  
−
  # cp SISFOKOL_SLTP_v2.tar.gz /var/www/
+
  vi /var/www/sisfokol-smp/inc/config.php
−
# cd /var/www
 
−
# tar zxvf SISFOKOL_SLTP_v2.tar.gz
 
−
# mv source sisfokol_smp
 
−
# cd sisfokol_smp
 
  
−
Edit file /var/www/sisfokol_sd/inc/config.php
+
Pastikan
  
 
  $sek_nama = "SMP BIASAWAE...";
 
  $sek_nama = "SMP 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-smp";
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
 +
 +
$xhostname = "localhost";
 +
$xdatabase = "sisfokol_sltp";
 +
$xusername = "sisfokol_sltp";
 +
$xpassword = "sisfokol_sltp";
  
 
Masukan isi database
 
Masukan isi database
  
−
  # mysql -u root -p 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_v3_sltp.sql
−
Enter password: '''<TEKAN ENTER>'''
 
  
 
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==
  
−
  http://localhost/sisfokol_smp
+
  http://ip-address-server/sisfokol-smp
  
 
  tipe      administrator
 
  tipe      administrator
Line 57: Line 66:
 
  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:30, 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 unrar

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
cp sisfokol_v3_sltp_free.rar /var/www/sisfokol-smp
cd /var/www/sisfokol-smp
unrar x sisfokol_v3_sltp_free.rar
mv sisfokol_v3_sltp_free/* .
rm -Rf sisfokol_v3_sltp_free*

cp sisfokol_v3_sawahsiring_sltp.tar.lzma /var/www/sisfokol-smp/
cd /var/www/sisfokol-smp
tar xvf sisfokol_v3_sawahsiring_sltp.tar.lzma 
cp -Rf sisfokol_v3_sawahsiring_sltp/source/* /var/www/sisfokol-smp/
rm -Rf /var/www/sisfokol-smp/sisfokol_v3_sawahsiring_sltp*

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://ip-address-server/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_v3_sltp.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://ip-address-server/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://onnocenter.or.id/wiki/index.php?title=Instalasi_Sisfokol_SMP&oldid=24188"