Difference between revisions of "Instalasi Sisfokol SMA"

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 Download source code SI...)
 
 
(6 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
  
 +
Siapkan [[database]]
  
Download source code SISFOKOL dari Web dari
+
mysql -u root -p123456
  
  http://sisfokol.wordpress.com/download/
+
  create database sisfokol_slta;
  http://tech.groups.yahoo.com/group/sisfokol/files (bagi anggota mailing list SISFOKOL)
+
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta';
 +
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta';
 +
  exit
  
 +
Copykan [[source code]] SISFOKOL ke folder [[Web]]
  
Siapkan database
+
mkdir /var/www/sisfokol-sma
 +
cp sisfokol_v3_slta_free.tar.bz2 /var/www/sisfokol-sma
 +
cd /var/www/sisfokol-sma
 +
tar jxvf sisfokol_v3_slta_free.tar.bz2
  
  # mysql -u root -p
+
  cp sisfokol_v3_sawahsiring_slta.tar.lzma /var/www/sisfokol-sma/
  password:
+
  cd /var/www/sisfokol-sma/
  mysql> create database sisfokol_SD_v2;
+
  tar xvf sisfokol_v3_sawahsiring_slta.tar.lzma
  mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'root'@'localhost' IDENTIFIED BY '';
+
  cp -Rf /var/www/sisfokol-sma/sisfokol_v3_sawahsiring_slta/source/* /var/www/sisfokol-sma/
  mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'root' IDENTIFIED BY '';
+
  rm -Rf /var/www/sisfokol-sma/sisfokol_v3_s*
mysql> quit
 
  
Copykan source code SISFOKOL ke folder Web
+
Edit file
  
  # cp SISFOKOL_SD_v2.tar.gz /var/www/
+
  vi /var/www/sisfokol-sma/inc/config.php
# cd /var/www
 
# tar zxvf SISFOKOL_SD_v2.tar.gz
 
# mv source sisfokol_sd
 
# cd sisfokol_sd
 
  
Edit file /var/www/sisfokol_sd/inc/config.php
+
Pastikan
  
  $sek_nama = "SD BIASAWAE...";
+
  $sek_nama = "SMA 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://ip-address-server/sisfokol-sma";
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
  
Masukan isi database
+
$xhostname = "localhost";
 +
$xdatabase = "sisfokol_slta";
 +
$xusername = "sisfokol_slta";
 +
$xpassword = "sisfokol_slta";
  
  # mysql -u root -p sisfokol_SD_v2 < /var/www/sisfokol_sd/db/agust18_0855.sql
+
Masukan isi [[database]]
Enter password: '''<TEKAN ENTER>'''
+
 
 +
  mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol_v3_slta.sql
  
 
Restart MySQL
 
Restart MySQL
  
  # /etc/init.d/mysql restart
+
  /etc/init.d/mysql restart
 +
rm -Rf /var/www/sisfokol-sma/install
 +
rm -Rf /var/www/sisfokol-sma/db
  
  
==Login ke Sisfokol SD==
+
==Login ke Sisfokol SLTA==
  
  http://localhost/sisfokol_sd
+
  http://ip-address-server/sisfokol-sma
  
 
  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 66: Line 89:
 
* [[Instalasi Sisfokol SMA]]
 
* [[Instalasi Sisfokol SMA]]
 
* [[Instalasi Sisfokol SMK]]
 
* [[Instalasi Sisfokol SMK]]
 +
* [[Instalasi Sisfokol Janisari]]
 
* [[Linux Howto]]
 
* [[Linux Howto]]
 +
 +
[[Category: Linux]]

Latest revision as of 13:32, 4 January 2011

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 -p123456
create database sisfokol_slta;
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta';
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta';
exit

Copykan source code SISFOKOL ke folder Web

mkdir /var/www/sisfokol-sma
cp sisfokol_v3_slta_free.tar.bz2 /var/www/sisfokol-sma
cd /var/www/sisfokol-sma
tar jxvf sisfokol_v3_slta_free.tar.bz2 
cp sisfokol_v3_sawahsiring_slta.tar.lzma /var/www/sisfokol-sma/
cd /var/www/sisfokol-sma/
tar xvf sisfokol_v3_sawahsiring_slta.tar.lzma 
cp -Rf /var/www/sisfokol-sma/sisfokol_v3_sawahsiring_slta/source/* /var/www/sisfokol-sma/
rm -Rf /var/www/sisfokol-sma/sisfokol_v3_s*

Edit file

vi /var/www/sisfokol-sma/inc/config.php

Pastikan

$sek_nama = "SMA BIASAWAE...";
$sek_alamat = "Jl. Raya Biasawae... No... ";
$sek_kontak = "Telp. . . . Fax. . . .";
$sumber = "http://ip-address-server/sisfokol-sma";

Ubah sesuai dengan data sekolah anda ..

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

Masukan isi database

mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol_v3_slta.sql

Restart MySQL

/etc/init.d/mysql restart
rm -Rf /var/www/sisfokol-sma/install
rm -Rf /var/www/sisfokol-sma/db


Login ke Sisfokol SLTA

http://ip-address-server/sisfokol-sma
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