Difference between revisions of "SchoolOnffline: Instalasi SISFOKOL SMK"

From OnnoWiki
Jump to navigation Jump to search
Line 9: Line 9:
 
  password:
 
  password:
 
  mysql> create database sisfokol_smk_v2;
 
  mysql> create database sisfokol_smk_v2;
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'root'@'localhost' IDENTIFIED BY "";
+
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2'@'localhost' IDENTIFIED BY 'sisfokol_smk_v2';
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'root' IDENTIFIED BY "";
+
  mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2' IDENTIFIED BY 'sisfokol_smk_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_smk_v2";
 +
$xusername = "sisfokol_smk_v2";
 +
$xpassword = "sisfokol_smk_v2";
  
 
Masukan isi database
 
Masukan isi database
  
  # mysql -u root -p sisfokol_smk_v2 < /var/www/sisfokol-smk/db/sept04_1155.sql
+
  # mysql -u sisfokol_smk_v2 -psisfokol_smk_v2 sisfokol_smk_v2 < /var/www/sisfokol-smk/db/sept04_1155.sql
Enter password: '''<TEKAN ENTER>'''
 
  
 
Restart MySQL
 
Restart MySQL

Revision as of 12:32, 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_smk_v2;
mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2'@'localhost' IDENTIFIED BY 'sisfokol_smk_v2';
mysql> GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2' IDENTIFIED BY 'sisfokol_smk_v2';
mysql> exit

Copykan source code SISFOKOL ke folder Web

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

Edit file /var/www/sisfokol-smk/inc/config.php

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

Ubah sesuai dengan data sekolah anda ..

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

Masukan isi database

# mysql -u sisfokol_smk_v2 -psisfokol_smk_v2 sisfokol_smk_v2 < /var/www/sisfokol-smk/db/sept04_1155.sql

Restart MySQL

# /etc/init.d/mysql restart


Login ke SISFOKOL SMK

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




Pranala Menarik