SQLite: Instalasi SQLite Manager
Download dari
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 SQLiteManager-*/ chmod -R 600 SQLiteManager-*/
Buat database untuk Apache
mkdir /usr/local/apache mkdir /usr/local/apache/sqliteDb/ chown -R 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
4 - Restricted access First you can edit you httpd.conf and add <Directory /usr/local/apache/htdocs/SQLiteManager-*/>
DirectoryIndex index.php
order deny,allow
deny from all
allow from 127.0.0.1 192.168.0.0/24
</Directory> You can authorize only access to computer or/and network
-By default authenticate is disable To set it edit define file: vi /usr/local/apache/htdocs/SQLiteManager-*/include/user_defined.inc.php
set 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
Referensi
- http://sourceforge.net/projects/sqlitemanager/
- http://sourceforge.net/projects/sqlitemanager/files/latest/download