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)
 
(10 intermediate revisions by the same user not shown)
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]]  


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


Edit file
Edit file


  # vi /var/www/sisfokol-smk/inc/config.php
  vi /var/www/sisfokol-sabily-sma/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/sisfokol-sabily-sma";


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-sma/db/sep01_1158.sql


Restart MySQL
Restart [[MySQL]]


  # /etc/init.d/mysql restart
  # /etc/init.d/mysql restart




==Login ke SISFOKOL SMK==
==Login ke SISFOKOL Sabily SMA==


  http://192.168.0.254/sisfokol-smk
  http://192.168.0.254/sisfokol-sabily-sma


  tipe      administrator
  Admin :
  username  admin
  Username/Password : admin
password  admin


  tipe      guru
  Guru :
  username  120001
  Username/Password : 120004
password  7aa9eba


  tipe      siswa
  Siswa :
  username  81000234
  Username/Password : 8100233
password  a7d38ff


  tipe      Wali Kelas
  Wali Kelas :
  username  120001
  Username/Password : 120001
password  7aa9eba


  tipe      Tata Usaha
  Tata Usaha :
  username  120386458
  Username/Password : 120386458
password  c9d7b16


  tipe      Kepala Sekolah
  Kepala Sekolah :
  username  12035464
  Username/Password : 12035464
password  c855ec8


==Pranala Menarik==
==Pranala Menarik==
Line 81: Line 75:
* [[SchoolOnffLine: Server Berbasis Sabily 9.04]]
* [[SchoolOnffLine: Server Berbasis Sabily 9.04]]
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04]]
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04]]
* [[SchoolOnffLine: Server Berbasis Ubuntu]]
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04 Alternate]]
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04 Alternate]]
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04 Server]]
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04 Server]]
Line 90: Line 85:
* [[Instalasi Sisfokol SMK]]
* [[Instalasi Sisfokol SMK]]
* [[Linux Howto]]
* [[Linux Howto]]
[[Category: Linux]]
[[Category: Distro Linux]]
[[Category: SchoolOnffLine]]

Latest revision as of 01:30, 11 May 2010

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

mkdir /var/www/sisfokol-sabily-sma
mv /usr/local/src/sisfokol_sabily_slta.tar.gz  /var/www/sisfokol-sabily-sma
cd /var/www/sisfokol-sabily-sma
tar zxvf sisfokol_sabily_slta.tar.gz 

Edit file

vi /var/www/sisfokol-sabily-sma/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-sma";

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-sma/db/sep01_1158.sql

Restart MySQL

# /etc/init.d/mysql restart


Login ke SISFOKOL Sabily SMA

http://192.168.0.254/sisfokol-sabily-sma
Admin :
Username/Password : admin
Guru :
Username/Password : 120004
Siswa :
Username/Password : 8100233
Wali Kelas :
Username/Password : 120001
Tata Usaha :
Username/Password : 120386458
Kepala Sekolah :
Username/Password : 12035464

Pranala Menarik