Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL Janissari"

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 4: Line 4:
 
  php5-mysql php5-gd php5-curl php-pear
 
  php5-mysql php5-gd php5-curl php-pear
  
Siapkan database
+
Siapkan [[database]]
  
 
  # 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_janissari_v1;
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2' IDENTIFIED BY 'sisfokol_smk_v2';
+
  GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari'@'localhost' IDENTIFIED BY 'sisfokol_janissari_v1';
  mysql> exit
+
  GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari' IDENTIFIED BY 'sisfokol_janissari_v1';
 +
  exit
  
 
Copykan [[source code]] SISFOKOL ke folder [[Web]]  
 
Copykan [[source code]] SISFOKOL ke folder [[Web]]  
  
  # mv /usr/local/src/SISFOKOL_SMK_v2.tar.gz /var/www/
+
  mkdir /var/www/janissari
  # cd /var/www
+
mv /usr/local/src/sisfokol_janissari.tar.gz /var/www/janissari
  # tar zxvf SISFOKOL_SMK_v2.tar.gz  
+
  cd /var/www/janissari
# mv source sisfokol-smk
+
  tar zxvf sisfokol_janissari.tar.gz
# cd sisfokol-smk
 
  
 
Edit file
 
Edit file
  
  # vi /var/www/sisfokol-smk/inc/config.php
+
  # vi /var/www/janissari/inc/config.php
  
 
Pastikan
 
Pastikan
Line 30: Line 30:
 
  $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/janissari/";
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
  
 
  $xhostname = "localhost";
 
  $xhostname = "localhost";
  $xdatabase = "sisfokol_smk_v2";
+
  $xdatabase = "sisfokol_janissari_v1";
  $xusername = "sisfokol_smk_v2";
+
  $xusername = "sisfokol_janissari_v1";
  $xpassword = "sisfokol_smk_v2";
+
  $xpassword = "sisfokol_janissari_v1";
 +
 
 +
Masukan isi [[database]]
  
Masukan isi database
+
# mysql -u janissari -psisfokol_janissari_v1 sisfokol_janissari_v1 < /var/www/janissari/db/agust26_1307.sql
  
# mysql -u sisfokol_smk_v2 -psisfokol_smk_v2 sisfokol_smk_v2 < /var/www/sisfokol-smk/db/sept04_1155.sql
 
  
Restart MySQL
+
Restart [[MySQL]]
  
 
  # /etc/init.d/mysql restart
 
  # /etc/init.d/mysql restart
  
  
==Login ke SISFOKOL SMK==
+
==Login ke SISFOKOL Janissari==
  
  http://192.168.0.254/sisfokol-smk
+
  http://192.168.0.254/janissari/
  
 
  tipe      administrator
 
  tipe      administrator

Revision as of 09:11, 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_janissari_v1;
GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari'@'localhost' IDENTIFIED BY 'sisfokol_janissari_v1';
GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari' IDENTIFIED BY 'sisfokol_janissari_v1';
exit

Copykan source code SISFOKOL ke folder Web

mkdir /var/www/janissari
mv /usr/local/src/sisfokol_janissari.tar.gz /var/www/janissari
cd /var/www/janissari
tar zxvf sisfokol_janissari.tar.gz

Edit file

# vi /var/www/janissari/inc/config.php

Pastikan

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

Ubah sesuai dengan data sekolah anda ..

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

Masukan isi database

# mysql -u janissari -psisfokol_janissari_v1 sisfokol_janissari_v1 < /var/www/janissari/db/agust26_1307.sql


Restart MySQL

# /etc/init.d/mysql restart


Login ke SISFOKOL Janissari

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