SchoolOnffline: Instalasi SISFOKOL Sabily SLTA: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
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...
 
Onnowpurbo (talk | contribs)
No edit summary
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 02: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