From d0e2ac9ed2432e877e1a55f46752b614d29fafb9 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Micka=C3=ABl=20R=C3=A9mond?= Date: Sun, 3 Sep 2006 15:15:46 +0000 Subject: * src/odbc/odbc_queries.erl: Support for Microsoft SQL Server as a database backend (via ODBC). * src/odbc/ejabberd_odbc.erl: Likewise. * src/odbc/mssql.sql: Likewise. * src/odbc/Makefile.in: Likewise. * src/ejabberd_auth_odbc.erl: Likewise. * src/mod_offline_odbc.erl: Likewise. * src/mod_roster_odbc.erl: Likewise. * src/mod_last_odbc.erl: Likewise. * src/configure.ac: Likewise * doc/guide.tex: Likewise. * doc/introduction.tex: Likewise. * src/odbc/pg.sql: Minor fix. SVN Revision: 598 --- doc/dev.html | 1 + doc/guide.html | 214 ++++++++++++++++++++++++++++----------------------- doc/guide.tex | 20 +++++ doc/introduction.tex | 4 +- 4 files changed, 142 insertions(+), 97 deletions(-) (limited to 'doc') diff --git a/doc/dev.html b/doc/dev.html index 0daaf175b..8681b1521 100644 --- a/doc/dev.html +++ b/doc/dev.html @@ -153,6 +153,7 @@ Native MySQL support.
  • Native PostgreSQL support.
  • Mnesia.
  • ODBC data storage support. +
  • Microsoft SQL Server support (via ODBC).
  • Authentication
  • 3.2  Relational Database Support -
  • 3.3  Creating an Initial Administrator -
  • 3.4  Online Configuration and Monitoring +
  • 3.3  Creating an Initial Administrator +
  • 3.4  Online Configuration and Monitoring -
  • 4  Firewall Settings -
  • 5  SRV Records -
  • 6  Clustering +
  • 4  Firewall Settings +
  • 5  SRV Records +
  • 6  Clustering -
  • A  Built-in Modules +
  • A  Built-in Modules -
  • B  Internationalization and Localization -
  • C  Release Notes +
  • B  Internationalization and Localization +
  • C  Release Notes -
  • D  Acknowledgements +
  • D  Acknowledgements @@ -230,6 +231,7 @@ Native MySQL support.
  • Native PostgreSQL support.
  • Mnesia.
  • ODBC data storage support. +
  • Microsoft SQL Server support (via ODBC).
  • Authentication -

    3.3  Creating an Initial Administrator

    +

    3.3  Creating an Initial Administrator

    Before the web interface can be entered to perform administration tasks, an @@ -1079,12 +1101,12 @@ Register an account on your ejabberd deployment. An account can be -

    3.4  Online Configuration and Monitoring

    +

    3.4  Online Configuration and Monitoring

    -

    3.4.1  Web Interface

    +

    3.4.1  Web Interface

    @@ -1158,7 +1180,7 @@ You can serve the web interface on the same port as the -

    3.4.2  ejabberdctl

    +

    3.4.2  ejabberdctl

    It is possible to do some administration operations using the command @@ -1204,7 +1226,7 @@ Additional information: -

    4  Firewall Settings

    +

    4  Firewall Settings

    @@ -1233,7 +1255,7 @@ You need to take the following TCP ports in mind when configuring your firewall:
    -

    5  SRV Records

    +

    5  SRV Records

    @@ -1245,13 +1267,13 @@ General information: -

    6  Clustering

    +

    6  Clustering

    -

    6.1  How it Works

    +

    6.1  How it Works

    @@ -1272,7 +1294,7 @@ router, -

    6.1.1  Router

    +

    6.1.1  Router

    This module is the main router of Jabber packets on each node. It @@ -1283,7 +1305,7 @@ appropriate process. If not, it is sent to the s2s manager.

    -

    6.1.2  Local Router

    +

    6.1.2  Local Router

    This module routes packets which have a destination domain equal to @@ -1293,7 +1315,7 @@ on its content.

    -

    6.1.3  Session Manager

    +

    6.1.3  Session Manager

    This module routes packets to local users. It looks up to which user @@ -1303,7 +1325,7 @@ storage, or bounced back.

    -

    6.1.4  s2s Manager

    +

    6.1.4  s2s Manager

    This module routes packets to other Jabber servers. First, it @@ -1314,7 +1336,7 @@ serving this connection, otherwise a new connection is opened.

    -

    6.2  Clustering Setup

    +

    6.2  Clustering Setup

    @@ -1387,13 +1409,13 @@ domain.
    -

    A  Built-in Modules

    +

    A  Built-in Modules

    -

    A.1  Overview

    +

    A.1  Overview

    @@ -1605,7 +1627,7 @@ XMPP compliancy.

    -

    A.2  Common Options

    +

    A.2  Common Options

    The following options are used by many modules. Therefore, they are described in @@ -1613,7 +1635,7 @@ this separate section.

    -

    A.2.1  iqdisc

    +

    A.2.1  iqdisc

    @@ -1647,7 +1669,7 @@ Example: -

    A.2.2  hosts

    +

    A.2.2  hosts

    @@ -1686,7 +1708,7 @@ Serving the echo module on one domain: -

    A.3  mod_announce

    +

    A.3  mod_announce

    @@ -1752,7 +1774,7 @@ Only administrators can send announcements: -

    A.4  mod_disco

    +

    A.4  mod_disco

    @@ -1804,7 +1826,7 @@ To serve a link to the Jabber User Directory on jabber.org: -

    A.5  mod_echo

    +

    A.5  mod_echo

    @@ -1837,7 +1859,7 @@ Mirror, mirror, on the wall, who is the most beautiful -

    A.6  mod_irc

    +

    A.6  mod_irc

    @@ -1907,7 +1929,7 @@ In the first example, the IRC transport is available on (all) your -

    A.7  mod_last

    +

    A.7  mod_last

    @@ -1924,7 +1946,7 @@ the processing discipline for Last activity (jabber:iq:last) IQ queries -

    A.8  mod_muc

    +

    A.8  mod_muc

    @@ -2014,7 +2036,7 @@ In the first example everyone is allowed to use the Multi-User Chat -

    A.9  mod_muc_log

    +

    A.9  mod_muc_log

    @@ -2086,7 +2108,7 @@ Example configuration: -

    A.10  mod_offline

    +

    A.10  mod_offline

    @@ -2098,7 +2120,7 @@ online again. Thus it is very similar to how email works. Note that
    -

    A.11  mod_privacy

    +

    A.11  mod_privacy

    @@ -2133,7 +2155,7 @@ the processing discipline for Blocking Communication (jabber:iq:privacy -

    A.12  mod_private

    +

    A.12  mod_private

    @@ -2152,7 +2174,7 @@ the processing discipline for Private XML Storage (jabber:iq:private) I -

    A.13  mod_pubsub

    +

    A.13  mod_pubsub

    @@ -2205,7 +2227,7 @@ Example: -

    A.14  mod_register

    +

    A.14  mod_register

    @@ -2262,7 +2284,7 @@ Next example prohibits the registration of too short account names and of -

    A.15  mod_roster

    +

    A.15  mod_roster

    @@ -2276,7 +2298,7 @@ the processing discipline for Roster Management (jabber:iq:roster) IQ q -

    A.16  mod_service_log

    +

    A.16  mod_service_log

    @@ -2316,7 +2338,7 @@ To log all end user packets to the Bandersnatch service running on -

    A.17  mod_shared_roster

    +

    A.17  mod_shared_roster

    @@ -2443,7 +2465,7 @@ Take the case of a computer club that wants all its members seeing each -

    A.18  mod_stats

    +

    A.18  mod_stats

    @@ -2485,7 +2507,7 @@ You can request the number of online users on the current virtual host -

    A.19  mod_time

    +

    A.19  mod_time

    @@ -2500,7 +2522,7 @@ the processing discipline for Entity Time (jabber:iq:time) IQ queries -

    A.20  mod_vcard

    +

    A.20  mod_vcard

    @@ -2566,7 +2588,7 @@ In this first situation, search results are limited to twenty items, -

    A.21  mod_version

    +

    A.21  mod_version

    @@ -2581,7 +2603,7 @@ the processing discipline for Software Version (jabber:iq:version) IQ q -

    B  Internationalization and Localization

    +

    B  Internationalization and Localization

    @@ -2624,13 +2646,13 @@ figure 3 with figure 
    -

    C  Release Notes

    +

    C  Release Notes

    -

    C.1  ejabberd 0.9

    +

    C.1  ejabberd 0.9

            Release notes
@@ -2724,7 +2746,7 @@ Bugfixes
    -

    C.2  ejabberd 0.9.1

    +

    C.2  ejabberd 0.9.1

            Release notes
@@ -2792,7 +2814,7 @@ Bugfixes
    -

    C.3  ejabberd 0.9.8

    +

    C.3  ejabberd 0.9.8

            Release notes
@@ -2897,7 +2919,7 @@ END
    -

    C.4  ejabberd 1.0.0

    +

    C.4  ejabberd 1.0.0

            Release Notes
@@ -3023,7 +3045,7 @@ END
    -

    C.5  ejabberd 1.1.0

    +

    C.5  ejabberd 1.1.0

         Release Notes
@@ -3144,7 +3166,7 @@ END
    -

    C.6  ejabberd 1.1.1

    +

    C.6  ejabberd 1.1.1

         Release Notes
@@ -3269,7 +3291,7 @@ END
    -

    D  Acknowledgements

    +

    D  Acknowledgements

    diff --git a/doc/guide.tex b/doc/guide.tex index 99e2df91a..0a757ca58 100644 --- a/doc/guide.tex +++ b/doc/guide.tex @@ -860,6 +860,26 @@ available from: \subsection{Relational Database Support} \label{sec:relationaldatabase} +\subsubsection{Preliminary steps} +\label{sec:relationaldatabasecompilation} + +If you have installed ejabberd using a binary version, the compilation steps +are not needed as they have already been done correctly. + +Otherwise, to be able to use ejabberd with a relational database you need to +enable ODBC modules during compilation, even if you want to use ejabberd with +MySQL or PostgreSQL in native mode. The following \term{configure} command can +be used to enable the relational modules: +\begin{verbatim} +./configure --enable-odbc +\end{verbatim} + +If you are planning to use Microsoft SQL Server with ODBC, you need to specify +it from the \term{configure} command before compilation: +\begin{verbatim} +./configure --enable-odbc --enable-mssql +\end{verbatim} + \subsubsection{Authentication against a relational database} \label{sec:relationaldatabaseauth} diff --git a/doc/introduction.tex b/doc/introduction.tex index 7bf10db62..4ad14bc50 100644 --- a/doc/introduction.tex +++ b/doc/introduction.tex @@ -100,7 +100,9 @@ Besides common \Jabber{} server features, \ejabberd{} comes with a wide range of \item Native MySQL support.\new{} \item Native PostgreSQL support. \item Mnesia. -\item ODBC data storage support. \moreinfo{ --- ODBC requests can be load balanced between several connections.} +\item ODBC data storage support. \moreinfo{ --- ODBC requests can be load + balanced between several connections.} +\item Microsoft SQL Server support (via ODBC).\new{} \end{itemize} \item Authentication \begin{itemize} -- cgit v1.2.3