Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SLTA"

From OnnoWiki
Jump to navigation Jump to search
Line 9: Line 9:
 
  password:
 
  password:
 
  mysql> create database sisfokol_slta_v2;
 
  mysql> create database sisfokol_slta_v2;
  mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'root'@'localhost' IDENTIFIED BY "";
+
  mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2'@'localhost' IDENTIFIED BY 'sisfokol_slta_v2';
  mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'root' IDENTIFIED BY "";
+
  mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2' IDENTIFIED BY 'sisfokol_slta_v2';
 
  mysql> exit
 
  mysql> exit
  
Line 29: Line 29:
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
 +
 +
$xhostname = "localhost";
 +
$xdatabase = "sisfokol_slta_v2";
 +
$xusername = "sisfokol_slta_v2";
 +
$xpassword = "sisfokol_slta_v2";
 +
  
 
Masukan isi database
 
Masukan isi database
  
  # mysql -u root -p sisfokol_slta_v2 < /var/www/sisfokol-slta/db/agust15_1505.sql  
+
  # mysql -u sisfokol_slta_v2 -psisfokol_slta_v2 sisfokol_slta_v2 < /var/www/sisfokol-slta/db/agust15_1505.sql  
Enter password: '''<TEKAN ENTER>'''
 
  
 
Restart MySQL
 
Restart MySQL

Revision as of 12:26, 4 August 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:
mysql> create database sisfokol_slta_v2;
mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2'@'localhost' IDENTIFIED BY 'sisfokol_slta_v2';
mysql> GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2' IDENTIFIED BY 'sisfokol_slta_v2';
mysql> exit

Copykan source code SISFOKOL ke folder Web

# mv /usr/local/src/SISFOKOL_SLTA_v2.tar.gz /var/www/
# cd /var/www
# tar zxvf SISFOKOL_SLTA_v2.tar.gz 
# mv source sisfokol-slta
# cd sisfokol-slta

Edit file /var/www/sisfokol_slta/inc/config.php

$sek_nama = "SMA BIASAWAE...";
$sek_alamat = "Jl. Raya Biasawae... No... ";
$sek_kontak = "Telp. . . . Fax. . . .";
$sumber = "http://localhost/";

Ubah sesuai dengan data sekolah anda ..

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


Masukan isi database

# mysql -u sisfokol_slta_v2 -psisfokol_slta_v2 sisfokol_slta_v2 < /var/www/sisfokol-slta/db/agust15_1505.sql 

Restart MySQL

# /etc/init.d/mysql restart


Login ke Sisfokol SLTA

http://192.168.0.254/sisfokol-slta
tipe      administrator
username  admin
password  admin




Pranala Menarik