Difference between revisions of "SQLite: Instalasi SQLite Manager"

From OnnoWiki
Jump to navigation Jump to search
Line 9: Line 9:
 
  tar zxvf SQliteManager-1.2.4.tar.gz  
 
  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
 +
  
 
   
 
   

Revision as of 15:33, 12 February 2012

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

Pranala Menarik

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