Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SLTP"

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

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

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

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

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


Ubah sesuai dengan data sekolah anda ..

Masukan isi database

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


Restart MySQL

# /etc/init.d/mysql restart


Login ke Sisfokol SMP

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




Pranala Menarik