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
1 - Unpack your download file into your 'DocumentRoot' folder (/usr/local/apache/htdocs/ ) we are in /usr/src/ directory
chown -R apache:apache SQLiteManager-*/
chmod -R 600 SQLiteManager-*/
mkdir /usr/local/apache/sqliteDb/ chown -R apache:apache /usr/local/apache/sqliteDb/
3 - move config database to another directory -Create a new directory, for example:
-Move config database : mv /usr/local/apache/htdocs/SQLiteManager-*/include/config.db /usr/local/apache/ sqliteDb/
-Set it writable: chmod -R 700 /usr/local/apache/sqliteDb/
-Now you must edit the define file with your favorite editor: vi /usr/local/apache/htdocs/SQLiteManager-*/include/user_defined.inc.php set define("SQLiteDb", "/usr/local/apache/sqliteDb/config.db"); define("DEFAULT_DB_PATH", "/usr/local/apache/sqliteDb/config.db" );
- Remove useless files rm INSTALL TODO CHANGES LICENCE test.sqlite
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