Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL Sabily SLTA"

From OnnoWiki
Jump to navigation Jump to search
(New page: 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 # mys...)
 
Line 8: Line 8:
 
  # mysql -u root -p
 
  # mysql -u root -p
 
  password:
 
  password:
−
  mysql> create database sisfokol_smk_v2;
+
 
−
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2'@'localhost' IDENTIFIED BY 'sisfokol_smk_v2';
+
  create database sisfokol_sabily_slta;
−
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2' IDENTIFIED BY 'sisfokol_smk_v2';
+
  GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta'@'localhost' IDENTIFIED BY 'sisfokol_sabily_slta';
−
  mysql> exit
+
  GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta' IDENTIFIED BY 'sisfokol_sabily_slta';
 +
  exit
  
 
Copykan [[source code]] SISFOKOL ke folder [[Web]]  
 
Copykan [[source code]] SISFOKOL ke folder [[Web]]  
Line 30: Line 31:
 
  $sek_alamat = "Jl. Raya Biasawae... No... ";
 
  $sek_alamat = "Jl. Raya Biasawae... No... ";
 
  $sek_kontak = "Telp. . . . Fax. . . .";
 
  $sek_kontak = "Telp. . . . Fax. . . .";
−
  $sumber = "http://192.168.0.254/sisfokol-smk/";
+
  $sumber = "http://192.168.0.254/sisfokol-sabily-slta/";
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
  
 
  $xhostname = "localhost";
 
  $xhostname = "localhost";
−
  $xdatabase = "sisfokol_smk_v2";
+
  $xdatabase = "sisfokol_sabily_slta";
−
  $xusername = "sisfokol_smk_v2";
+
  $xusername = "sabily_slta";
−
  $xpassword = "sisfokol_smk_v2";
+
  $xpassword = "sisfokol_sabily_slta";
  
−
Masukan isi database
+
Masukan isi [[database]]
  
−
  # mysql -u sisfokol_smk_v2 -psisfokol_smk_v2 sisfokol_smk_v2 < /var/www/sisfokol-smk/db/sept04_1155.sql
+
  # mysql -u sabily_slta -psisfokol_sabily_slta sisfokol_sabily_slta < /var/www/sisfokol-sabily-slta/db/sep01_1158.sql
  
−
Restart MySQL
+
Restart [[MySQL]]
  
 
  # /etc/init.d/mysql restart
 
  # /etc/init.d/mysql restart
Line 50: Line 51:
 
==Login ke SISFOKOL SMK==
 
==Login ke SISFOKOL SMK==
  
−
  http://192.168.0.254/sisfokol-smk
+
  http://192.168.0.254/sisfokol-sabily-slta
  
 
  tipe      administrator
 
  tipe      administrator

Revision as of 09:18, 7 September 2009

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 -p
password:

create database sisfokol_sabily_slta;
GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta'@'localhost' IDENTIFIED BY 'sisfokol_sabily_slta';
GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta' IDENTIFIED BY 'sisfokol_sabily_slta';
exit

Copykan source code SISFOKOL ke folder Web 

# mv /usr/local/src/SISFOKOL_SMK_v2.tar.gz /var/www/
# cd /var/www
# tar zxvf SISFOKOL_SMK_v2.tar.gz 
# mv source sisfokol-smk
# cd sisfokol-smk

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-sabily-slta/";

Ubah sesuai dengan data sekolah anda .. 

$xhostname = "localhost";
$xdatabase = "sisfokol_sabily_slta";
$xusername = "sabily_slta";
$xpassword = "sisfokol_sabily_slta";

Masukan isi database 

# mysql -u sabily_slta -psisfokol_sabily_slta sisfokol_sabily_slta < /var/www/sisfokol-sabily-slta/db/sep01_1158.sql

Restart MySQL 

# /etc/init.d/mysql restart


Login ke SISFOKOL SMK

http://192.168.0.254/sisfokol-sabily-slta

tipe      administrator
username  admin
password  admin

tipe      guru
username  120001
password  7aa9eba

tipe      siswa
username  81000234
password  a7d38ff

tipe      Wali Kelas
username  120001
password  7aa9eba

tipe      Tata Usaha
username  120386458
password  c9d7b16

tipe      Kepala Sekolah
username  12035464
password  c855ec8

Pranala Menarik

Retrieved from "https://onnocenter.or.id/wiki/index.php?title=SchoolOnffline:_Instalasi_SISFOKOL_Sabily_SLTA&oldid=8468"