SQLite: Instalasi SQLite Manager: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
← Older edit
Onnowpurbo (talk | contribs)
69,477 edits
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
Onnowpurbo (talk | contribs)
69,477 edits
 
(18 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''CATATAN:''' Masih Belum Berhasil. Tidak keluar apa-apa saat di browse. Entah salah dimana.
==Download==
Download dari
Download dari


* http://sourceforge.net/projects/sqlitemanager/files/latest/download
* http://sourceforge.net/projects/sqlitemanager/files/latest/download
==Instalasi==


Lakukan
Lakukan
Line 8: Line 16:
  cd /var/www
  cd /var/www
  tar zxvf SQliteManager-1.2.4.tar.gz  
  tar zxvf SQliteManager-1.2.4.tar.gz  
chown -R www-data:www-data /var/www/SQLiteManager-*/
chmod -R 600 /var/www/SQLiteManager-*/


Buat database untuk Apache


--------------
mkdir /usr/local/apache
1 - Unpack your download file into your 'DocumentRoot' folder (/usr/local/apache/htdocs/
mkdir /usr/local/apache/sqliteDb/
)
chown -Rf www-data:www-data /usr/local/apache/sqliteDb/
we are in /usr/src/ directory


Isi database


chown -R apache:apache SQLiteManager-*/
mv /var/www/SQLiteManager-*/include/config.db /usr/local/apache/sqliteDb/
chmod -R 600 SQLiteManager-*/
chmod -R 700 /usr/local/apache/sqliteDb/


mkdir /usr/local/apache/sqliteDb/
Edit
chown -R apache:apache /usr/local/apache/sqliteDb/


3 - move config database to another directory
vi /var/www/SQLiteManager-*/include/user_defined.inc.php
-Create a new directory, for example:


Set agar


define("SQLiteDb", "/usr/local/apache/sqliteDb/config.db");
define("DEFAULT_DB_PATH", "/usr/local/apache/sqliteDb/config.db");
Buang file


-Move config database :
rm INSTALL TODO CHANGES LICENCE test.sqlite
mv /usr/local/apache/htdocs/SQLiteManager-*/include/config.db /usr/local/apache/
 
sqliteDb/
==Membatasi Akses==
 
-Set it writable:
Untuk membatasi akses kita perlu mengedit httpd.conf bisa melalui
chmod -R 700 /usr/local/apache/sqliteDb/
 
cd /etc/apache2/sites-available
-Now you must edit the define file with your favorite editor:
 
vi /usr/local/apache/htdocs/SQLiteManager-*/include/user_defined.inc.php
Buat file
set
 
define("SQLiteDb", "/usr/local/apache/sqliteDb/config.db");
vi /etc/apache2/sites-available/SQLiteManager
define("DEFAULT_DB_PATH", "/usr/local/apache/sqliteDb/config.db"
 
);
isi
 
- Remove useless files
<Directory /var/www/SQLiteManager-*/>
rm INSTALL TODO CHANGES LICENCE test.sqlite
  DirectoryIndex index.php
  order deny,allow
4 - Restricted access
  deny from all
First you can edit you httpd.conf and add
  allow from 127.0.0.1 192.168.0.0/24
<Directory /usr/local/apache/htdocs/SQLiteManager-*/>
</Directory>
        DirectoryIndex index.php
 
        order deny,allow
Melalui cara ini kita dapat mengatur komputer pada jaringan mana yang bisa akses.
        deny from all
 
        allow from 127.0.0.1 192.168.0.0/24
Kita juga dapat mengauthentikasi user yang akan login.
</Directory>
Default fasilitas ini sebetulnya di disable. Untuk mengaktifkan, edit,
You can authorize only access to computer or/and network
 
vi /var/www/SQLiteManager-*/include/user_defined.inc.php
-By default authenticate is disable
 
To set it edit define file:
set
vi /usr/local/apache/htdocs/SQLiteManager-*/include/user_defined.inc.php
 
define("WITH_AUTH", true);
 
Akses berlaku untuk
 
login : admin passwd : admin
login : data passwd : data
login : guest passwd : guest
 
Untuk memanage semua user & group kita perlu login melalui account 'admin'.
 
 
Restart Web Server
 
/etc/init.d/apache2 restart
 
==Menggunakan SQLiteManager dengan SQLite database versi 3==
 
Install aplikasi  yang dibutuhkan
 
sudo apt-get install libmysqlclient16-dev php-pear php5-dev libsqlite3-dev
sudo pecl install pdo
sudo pecl install pdo_sqlite
sudo pecl install pdo_mysql
 
*ENTAH KENAPA PECL install PDO GAGAL*
 
Edit
 
vi /etc/php5/apache2/php.ini
 
Set
 
memory_limit = 60M
# tambahkan kalimat berikut
extension=php_pdo_sqlite.so 
extension=php_pdo.so
 
buka file konfigurasi user :
 
vi /var/www/SQLiteManager-1.2.4/include/user_defined.inc.php  
 
set
 
define('SQLITE3', true);
 
Sekarang semua database harus dalam versi 3.
Konfigurasi database juga dalam versi 3.


set
==Akses Melalui Web==
define("WITH_AUTH", true);
Now you can login with the default user:
login : admin passwd : admin
login : data passwd : data
login : guest passwd : guest
You can manage all user and groupes where you are logged with 'Admin' ac
count
5 - Use SQLiteManager with SQLite database version 3
Your php must load at startup the extension : 'php_pdo' and 'php_pdo_sqlite' fro
m PECL
open the user configuration file : user_defined.inc.php
and set
define('SQLITE3', true);
Now all the database must be in version 3
The configuration database is in version 3 too


Akses melalui web dengan alamat


http://<ip-adddress-sqlite-database>/SQLiteManager-1.2.4/
http://localhost/SQLiteManager-1.2.4/
http://192.168.0.3/SQLiteManager-1.2.4/


==Referensi==
==Referensi==
Line 92: Line 137:
* [[SQLite: Cara Cepat Menggunakan SQLite]]
* [[SQLite: Cara Cepat Menggunakan SQLite]]
* [[SQLite: Command Line Shell]]
* [[SQLite: Command Line Shell]]
* [[SQLite: Tutorial]]
* [[SQLite: Instalasi SQLite Manager]]
* [[SQLite: Instalasi SQLite Manager]]
* [[SQLite: Instalasi SQLite Database Browser]]

Latest revision as of 13:11, 12 February 2012

CATATAN: Masih Belum Berhasil. Tidak keluar apa-apa saat di browse. Entah salah dimana.


Download

Download dari

Instalasi

Lakukan 

mv SQliteManager-1.2.4.tar.gz /var/www
cd /var/www
tar zxvf SQliteManager-1.2.4.tar.gz 
chown -R www-data:www-data /var/www/SQLiteManager-*/
chmod -R 600 /var/www/SQLiteManager-*/

Buat database untuk Apache 

mkdir /usr/local/apache
mkdir /usr/local/apache/sqliteDb/
chown -Rf www-data:www-data /usr/local/apache/sqliteDb/

Isi database 

mv /var/www/SQLiteManager-*/include/config.db /usr/local/apache/sqliteDb/
chmod -R 700 /usr/local/apache/sqliteDb/

Edit 

vi /var/www/SQLiteManager-*/include/user_defined.inc.php

Set agar 

define("SQLiteDb", "/usr/local/apache/sqliteDb/config.db");
define("DEFAULT_DB_PATH", "/usr/local/apache/sqliteDb/config.db");

Buang file 

rm INSTALL TODO CHANGES LICENCE test.sqlite

Membatasi Akses

Untuk membatasi akses kita perlu mengedit httpd.conf bisa melalui 

cd /etc/apache2/sites-available

Buat file 

vi /etc/apache2/sites-available/SQLiteManager

isi 

<Directory /var/www/SQLiteManager-*/>
  DirectoryIndex index.php
  order deny,allow
  deny from all
  allow from 127.0.0.1 192.168.0.0/24
</Directory>

Melalui cara ini kita dapat mengatur komputer pada jaringan mana yang bisa akses.

Kita juga dapat mengauthentikasi user yang akan login. Default fasilitas ini sebetulnya di disable. Untuk mengaktifkan, edit, 

vi /var/www/SQLiteManager-*/include/user_defined.inc.php

set 

define("WITH_AUTH", true);

Akses berlaku untuk 

login : admin	passwd : admin
login : data	passwd : data
login : guest	passwd : guest

Untuk memanage semua user & group kita perlu login melalui account 'admin'.


Restart Web Server 

/etc/init.d/apache2 restart

Menggunakan SQLiteManager dengan SQLite database versi 3

Install aplikasi yang dibutuhkan 

sudo apt-get install libmysqlclient16-dev php-pear php5-dev libsqlite3-dev
sudo pecl install pdo
sudo pecl install pdo_sqlite
sudo pecl install pdo_mysql
  • ENTAH KENAPA PECL install PDO GAGAL*

Edit 

vi /etc/php5/apache2/php.ini

Set 

memory_limit = 60M
# tambahkan kalimat berikut
extension=php_pdo_sqlite.so  
extension=php_pdo.so

buka file konfigurasi user : 

vi /var/www/SQLiteManager-1.2.4/include/user_defined.inc.php

set 

define('SQLITE3', true);

Sekarang semua database harus dalam versi 3. Konfigurasi database juga dalam versi 3.

Akses Melalui Web

Akses melalui web dengan alamat 

http://<ip-adddress-sqlite-database>/SQLiteManager-1.2.4/
http://localhost/SQLiteManager-1.2.4/
http://192.168.0.3/SQLiteManager-1.2.4/

Referensi

Pranala Menarik

Retrieved from "https://lms.onnocenter.or.id/wiki/index.php?title=SQLite:_Instalasi_SQLite_Manager&oldid=29727"