Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help 
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  descrip-
       tion 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 di-
       alect.

       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>

1.42.0				 Oct 03, 2020		    GAMMU-SMSD-ODBC(7)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=gammu-smsd-odbc&sektion=7&manpath=FreeBSD+Ports+15.0>

home | help