NAME

       gammu-smsd-odbc  -  gammu-smsd(1) backend using ODBC abstraction layer to use any supported database as a
       message storage

DESCRIPTION

       New in version 1.29.92.

       ODBC backend stores all data in  any  database  supported  by  ODBC,  which  parameters  are  defined  by
       configuration (see gammu-smsdrc for description of configuration options).

       For tables description see gammu-smsd-tables.

       This backend is based on gammu-smsd-sql.

SUPPORTED DRIVERS

       On Microsoft Windows, Gammu uses native ODBC, on other platforms, unixODBC can be used.

LIMITATIONS

       Due to limits of the ODBC interface, Gammu can not reliably detect which SQL engine it is connected to.

       In most cases this can be solved by setting SQL setting to correct dialect.

       If  that  fails,  you can also tweak the SQL queries to work in used SQL server, see SQL Queries for more
       details. Still you should set SQL to closest matching SQL dialect.

CONFIGURATION

       Before running gammu-smsd you need to create necessary tables in the database. You can use examples given
       in database specific backends parts of this manual to do that.

       You  specify  data  source name (DSN) as Host in gammu-smsdrc. The data source is configured depending on
       your platform.

       NOTE:
          Please remember that SMSD might be running in different context than your user  (separate  account  on
          Linux or as as service on Windows), so the ODBC DSN needs to be configured as system wide in this case
          (system DSN on Windows or in global configuration on Linux).

       On     Microsoft     Windows,     you     can     find     instructions     on     Microsoft     website:
       https://support.microsoft.com/kb/305599

       For unixODBC this is documented in the user manual: http://www.unixodbc.org/doc/UserManual/

CREATING TABLES

       Prior  to  starting  SMSD  you  have  to  create  tables it will use. Gammu ships SQL scripts for several
       databases to do that:

       • mysql-create

       • pgsql-create

       • sqlite-create

EXAMPLE

       Example configuration:

          [smsd]
          service = sql
          driver = odbc
          host = dsn_of_your_database
          sql = sql_variant_to_use
          user = username
          password = password

       SEE ALSO:
          gammu-smsdrc

AUTHOR

       Michal Čihař <michal@cihar.com>

COPYRIGHT

       2009-2015, Michal Čihař <michal@cihar.com>