SchoolOnffline: Instalasi SISFOKOL SLTP: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
Onnowpurbo (talk | contribs)
No edit summary
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 04: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