Difference between revisions of "SQLite: Instalasi SQLite Manager"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| (11 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== | ||
| Line 12: | 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 SQLiteManager-*/ | + | chown -R www-data:www-data /var/www/SQLiteManager-*/ |
| − | chmod -R 600 SQLiteManager-*/ | + | chmod -R 600 /var/www/SQLiteManager-*/ |
Buat database untuk Apache | Buat database untuk Apache | ||
| Line 19: | Line 23: | ||
mkdir /usr/local/apache | mkdir /usr/local/apache | ||
mkdir /usr/local/apache/sqliteDb/ | mkdir /usr/local/apache/sqliteDb/ | ||
| − | chown - | + | chown -Rf www-data:www-data /usr/local/apache/sqliteDb/ |
Isi database | Isi database | ||
| Line 38: | Line 42: | ||
rm INSTALL TODO CHANGES LICENCE test.sqlite | rm INSTALL TODO CHANGES LICENCE test.sqlite | ||
| − | |||
==Membatasi Akses== | ==Membatasi Akses== | ||
| Line 52: | Line 55: | ||
isi | isi | ||
| − | <Directory / | + | <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> | </Directory> | ||
| Line 85: | Line 88: | ||
==Menggunakan SQLiteManager dengan SQLite database versi 3== | ==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 | set | ||
| Line 121: | 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 20: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
- http://sourceforge.net/projects/sqlitemanager/
- http://sourceforge.net/projects/sqlitemanager/files/latest/download