Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SD"

From OnnoWiki
Jump to navigation Jump to search
Line 9: Line 9:
 
  password:
 
  password:
 
  mysql> create database sisfokol_SD_v2;
 
  mysql> create database sisfokol_SD_v2;
  mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'root'@'localhost' IDENTIFIED BY "";
+
  mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2'@'localhost' IDENTIFIED BY 'sisfokol_SD_v2';
  mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'root' IDENTIFIED BY "";
+
  mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2' IDENTIFIED BY 'sisfokol_SD_v2';
 
  mysql> exit
 
  mysql> exit
  
Line 27: Line 27:
 
  $sek_kontak = "Telp. . . . Fax. . . .";
 
  $sek_kontak = "Telp. . . . Fax. . . .";
 
  $sumber = "http://localhost/";
 
  $sumber = "http://localhost/";
 +
 +
$xhostname = "localhost";
 +
$xdatabase = "sisfokol_SD_v2";
 +
$xusername = "sisfokol_SD_v2";
 +
$xpassword = "sisfokol_SD_v2";
 +
  
 
Ubah sesuai dengan data sekolah anda ..
 
Ubah sesuai dengan data sekolah anda ..
Line 32: Line 38:
 
Masukan isi database
 
Masukan isi database
  
  # mysql -u root -p sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.sql
+
  # mysql -u sisfokol_SD_v2 -psisfokol_SD_v2 sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.sql
Enter password: '''<TEKAN ENTER>'''
 
  
 
Restart MySQL
 
Restart MySQL

Revision as of 11:44, 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_SD_v2;
mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2'@'localhost' IDENTIFIED BY 'sisfokol_SD_v2';
mysql> GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2' IDENTIFIED BY 'sisfokol_SD_v2';
mysql> exit

Copykan source code SISFOKOL ke folder Web

# mv /usr/local/src/SISFOKOL_SD_v2.tar.gz /var/www/
# 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

$sek_nama = "SD BIASAWAE...";
$sek_alamat = "Jl. Raya Biasawae... No... ";
$sek_kontak = "Telp. . . . Fax. . . .";
$sumber = "http://localhost/";
$xhostname = "localhost";
$xdatabase = "sisfokol_SD_v2";
$xusername = "sisfokol_SD_v2";
$xpassword = "sisfokol_SD_v2";


Ubah sesuai dengan data sekolah anda ..

Masukan isi database

# mysql -u sisfokol_SD_v2 -psisfokol_SD_v2 sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.sql

Restart MySQL

# /etc/init.d/mysql restart


Login ke Sisfokol SD

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




Pranala Menarik