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...)
 
 
(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 08: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

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