Gecko [ www.thearyasamaj.org ]

Name	Size	Permission
ftpasswd.html	14.61 KB	-rw-r--r--
ftpmail.html	8 KB	-rw-r--r--
ftpquota.html	10.9 KB	-rw-r--r--
index.html	9.04 KB	-rw-r--r--
mod_auth_otp.html	16.5 KB	-rw-r--r--
mod_ban.html	22.53 KB	-rw-r--r--
mod_copy.html	4.85 KB	-rw-r--r--
mod_ctrls_admin.html	15.05 KB	-rw-r--r--
mod_deflate.html	6.89 KB	-rw-r--r--
mod_digest.html	12.92 KB	-rw-r--r--
mod_dnsbl.html	6.1 KB	-rw-r--r--
mod_dynmasq.html	3.26 KB	-rw-r--r--
mod_exec.html	23.89 KB	-rw-r--r--
mod_geoip.html	17.06 KB	-rw-r--r--
mod_ifsession.html	11.02 KB	-rw-r--r--
mod_ifversion.html	4.96 KB	-rw-r--r--
mod_ldap.html	32.32 KB	-rw-r--r--
mod_load.html	2.97 KB	-rw-r--r--
mod_log_forensic.html	9.78 KB	-rw-r--r--
mod_qos.html	2.62 KB	-rw-r--r--
mod_quotatab.html	25.02 KB	-rw-r--r--
mod_quotatab_file.html	2.23 KB	-rw-r--r--
mod_quotatab_ldap.html	2.63 KB	-rw-r--r--
mod_quotatab_radius.html	2.08 KB	-rw-r--r--
mod_quotatab_sql.html	10.93 KB	-rw-r--r--
mod_radius.html	22.11 KB	-rw-r--r--
mod_ratio.html	6.99 KB	-rw-r--r--
mod_readme.html	2.69 KB	-rw-r--r--
mod_rewrite.html	30.06 KB	-rw-r--r--
mod_sftp.html	93.71 KB	-rw-r--r--
mod_sftp_pam.html	5.47 KB	-rw-r--r--
mod_sftp_sql.html	5.63 KB	-rw-r--r--
mod_shaper.html	23.28 KB	-rw-r--r--
mod_site_misc.html	5.81 KB	-rw-r--r--
mod_snmp.html	42.38 KB	-rw-r--r--
mod_sql.html	62.81 KB	-rw-r--r--
mod_sql_odbc.html	10.2 KB	-rw-r--r--
mod_sql_passwd.html	24.44 KB	-rw-r--r--
mod_sql_sqlite.html	2.95 KB	-rw-r--r--
mod_statcache.html	8.29 KB	-rw-r--r--
mod_tls.html	85.34 KB	-rw-r--r--
mod_tls_fscache.html	2.73 KB	-rw-r--r--
mod_tls_memcache.html	3.91 KB	-rw-r--r--
mod_tls_redis.html	3.6 KB	-rw-r--r--
mod_tls_shmcache.html	6.78 KB	-rw-r--r--
mod_unique_id.html	3.54 KB	-rw-r--r--
mod_wrap.html	12.38 KB	-rw-r--r--
mod_wrap2.html	24.83 KB	-rw-r--r--
mod_wrap2_file.html	4.69 KB	-rw-r--r--
mod_wrap2_redis.html	5.33 KB	-rw-r--r--
mod_wrap2_sql.html	8.33 KB	-rw-r--r--

Code Editor : mod_sql_sqlite.html

<!DOCTYPE html>
<html>
<head>
<title>ProFTPD module mod_sql_sqlite</title>
</head>

<hr><br>
<center>
<h2><b>ProFTPD module <code>mod_sql_sqlite</code></b></h2>
</center>
<hr><br>

<p>
SQLite is a lightweight embeddable database system that is gaining in
popularity.  More details can be found here:
<pre>
  <a href="http://www.sqlite.org/">http://www.sqlite.org</a>
</pre>

<p>
The <code>mod_sql_sqlite</code> module is designed to let ProFTPD's
<code>mod_sql</code> module connect to and use a SQLite database.  This module
is contained in the <code>mod_sql_sqlite.c</code> file for ProFTPD 1.3.<i>x</i>,
and is not compiled by default.  Installation instructions are discussed
<a href="#Installation">here</a>.

<p>
The most current version of <code>mod_sql_sqlite</code> is distributed with
ProFTPD.

<h2>Author</h2>
<p>
Please contact TJ Saunders &lt;tj <i>at</i> castaglia.org&gt; with any
questions, concerns, or suggestions regarding this module.

<p>
<hr>
<h2><a name="Installation">Installation</a></h2>
The <code>mod_sql_sqlite</code> modules requires that SQLite be installed.

<p>
After installing SQLite, follow the usual steps for using contrib modules in
ProFTPD, making sure to list <code>mod_sql</code>:
<pre>
  $ ./configure --with-modules=mod_sql:mod_sql_sqlite
  $ make
  $ make install
</pre>
You may need to specify the location of the SQLite header and library files in
your <code>configure</code> command, <i>e.g.</i>:
<pre>
  $ ./configure --with-modules=mod_sql:mod_sql_sqlite \
    --with-includes=/usr/local/sqlite/include \
    --with-libraries=/usr/local/sqlite/lib
</pre>

<p>
Alternatively, if your <code>proftpd</code> was compiled with DSO support, you
can use the <code>prxs</code> tool to build <code>mod_sql_sqlite</code> as
a shared module:
<pre>
  $ prxs -c -i -d mod_sql_sqlite.c
</pre>

<p>
<hr>
<h2><a name="Usage">Usage</a></h2>
For the most part, <code>mod_sql_sqlite</code> requires little configuration.
In the <code>SQLConnectInfo</code> directive, simply use the full path
to the SQLite database file; no username or password are required.  The
<code>SQLBackend</code> provided by <code>mod_sql_sqlite</code> is "sqlite3".

<p>
For example:
<pre>
  &lt;IfModule mod_sql_sqlite.c&gt;
    SQLBackend sqlite3
    SQLConnectInfo /path/to/ftpd.db
  &lt;/IfModule&gt;
</pre>

<p>
Note that due to the way that <code>mod_sql_sqlite</code> implements database
transactions (e.g. <code>INSERT</code> and <code>UPDATE</code> SQL statements
for <code>SQLLog</code> directives), SQLite-3.6.5 or later is <b>required</b>
in order for <code>mod_sql_sqlite</code> to support <code>SQLLog</code>
directives if <code>DefaultRoot</code> or <code>&lt;Anonymous&gt;</code> are
used.  (SQLite-3.6.5 and later support the MEMORY journal mode, which is
needed for supporting the <code>SQLLog</code> directives in a chrooted
process.)

</body>
</html>

${this.title}

Code Editor : mod_sql_sqlite.html