1GAMMU-SMSD-ODBC(7)                   Gammu                  GAMMU-SMSD-ODBC(7)
2
3
4

NAME

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

DESCRIPTION

10       New in version 1.29.92.
11
12
13       ODBC backend stores all data in any database supported by  ODBC,  which
14       parameters  are defined by configuration (see gammu-smsdrc for descrip‐
15       tion of configuration options).
16
17       For tables description see gammu-smsd-tables.
18
19       This backend is based on gammu-smsd-sql.
20

SUPPORTED DRIVERS

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

LIMITATIONS

26       Due  to  limits  of  the  ODBC interface, Gammu can not reliably detect
27       which SQL engine it is connected to.
28
29       In most cases this can be solved by  setting  SQL  setting  to  correct
30       dialect.
31
32       If  that  fails, you can also tweak the SQL queries to work in used SQL
33       server, see SQL Queries for more details. Still you should set  SQL  to
34       closest matching SQL dialect.
35

CONFIGURATION

37       Before  running  gammu-smsd  you need to create necessary tables in the
38       database. You can use examples  given  in  database  specific  backends
39       parts of this manual to do that.
40
41       You  specify  data  source name (DSN) as Host in gammu-smsdrc. The data
42       source is configured depending on your platform.
43
44       NOTE:
45          Please remember that SMSD might be running in different context than
46          your  user  (separate account on Linux or as as service on Windows),
47          so the ODBC DSN needs to be configured as system wide in  this  case
48          (system DSN on Windows or in global configuration on Linux).
49
50       On  Microsoft  Windows, you can find instructions on Microsoft website:
51       https://support.microsoft.com/kb/305599
52
53       For   unixODBC   this   is   documented    in    the    user    manual:
54       http://www.unixodbc.org/doc/UserManual/
55

CREATING TABLES

57       Prior  to  starting  SMSD  you have to create tables it will use. Gammu
58       ships SQL scripts for several databases to do that:
59
60       · mysql-create
61
62       · pgsql-create
63
64       · sqlite-create
65

EXAMPLE

67       Example configuration:
68
69          [smsd]
70          service = sql
71          driver = odbc
72          host = dsn_of_your_database
73          sql = sql_variant_to_use
74          user = username
75          password = password
76
77       SEE ALSO:
78          gammu-smsdrc
79

AUTHOR

81       Michal Čihař <michal@cihar.com>
82
84       2009-2015, Michal Čihař <michal@cihar.com>
85
86
87
88
891.42.0                           Oct 03, 2020               GAMMU-SMSD-ODBC(7)
Impressum