GAMMU-SMSD-ODBC(7)                   Gammu                  GAMMU-SMSD-ODBC(7)

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:

       o mysql-create

       o pgsql-create

       o 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 Cihar <michal@cihar.com>

COPYRIGHT
       2009-2015, Michal Cihar <michal@cihar.com>

1.42.0                          October 3, 2020             GAMMU-SMSD-ODBC(7)