SchoolOnffline: Instalasi SISFOKOL SLTP: Difference between revisions

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


Siapkan database
mysql -u root -p123456


  # mysql -u root -p
  create database sisfokol_sltp;
password:
  GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp';
mysql> create database sisfokol_sltp_v2;
  GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp' IDENTIFIED BY 'sisfokol_sltp';
  mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2'@'localhost' IDENTIFIED BY 'sisfokol_sltp_v2';
  exit
  mysql> GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2' IDENTIFIED BY 'sisfokol_sltp_v2';
  mysql> exit


Copykan source code SISFOKOL ke folder Web  
Copykan [[source code]] SISFOKOL ke folder [[Web]]


  # mv /usr/local/src/SISFOKOL_SLTP_v2.tar.gz /var/www/
  mkdir /var/www/sisfokol-smp
  # cd /var/www
mv /usr/local/src/sisfokol_v3_sltp_free.rar /var/www/sisfokol-smp
  # tar zxvf SISFOKOL_SLTP_v2.tar.gz
cd /var/www/sisfokol-smp
  # mv source sisfokol-sltp
unrar x sisfokol_v3_sltp_free.rar
  # cd sisfokol-sltp
mv sisfokol_v3_sltp_free/* .
rm -Rf sisfokol_v3_sltp_free*
mv /usr/local/src/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 /var/www/sisfokol_sd/inc/config.php
Edit file  
 
vi /var/www/sisfokol-smp/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://192.168.0.254/sisfokol-smp";
 
Ubah sesuai dengan data sekolah anda ..


  $xhostname = "localhost";
  $xhostname = "localhost";
  $xdatabase = "sisfokol_sltp_v2";
  $xdatabase = "sisfokol_sltp";
  $xusername = "sisfokol_sltp_v2";
  $xusername = "sisfokol_sltp";
  $xpassword = "sisfokol_sltp_v2";
  $xpassword = "sisfokol_sltp";
 
 
Ubah sesuai dengan data sekolah anda ..


Masukan isi database
Masukan isi database


  # mysql -u root -psisfokol_sltp_v2 sisfokol_sltp_v2 < /var/www/sisfokol-sltp/db/agust18_0929.sql  
  mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol_v3_sltp.sql
 


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://192.168.0.254/sisfokol-sltp
  http://192.168.0.254/sisfokol-smp


  tipe      administrator
  tipe      administrator
Line 55: Line 63:
  password  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==
==Pranala Menarik==
Line 65: Line 88:
* [[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 Server]]
* [[SchoolOnffLine: Server Wikipedia for School]]
* [[SchoolOnffLine: Server Wikipedia for School]]
* [[Remastering Ubuntu]]
* [[Remastering Ubuntu]]
Line 72: Line 97:
* [[Instalasi Sisfokol SMK]]
* [[Instalasi Sisfokol SMK]]
* [[Linux Howto]]
* [[Linux Howto]]
[[Category: Linux]]
[[Category: Distro Linux]]
[[Category: SchoolOnffLine]]

Latest revision as of 07:32, 17 November 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 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
mv /usr/local/src/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*
mv /usr/local/src/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://192.168.0.254/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://192.168.0.254/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