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:

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

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

1.41.0				 Sep 27, 2019		    GAMMU-SMSD-ODBC(7)

NAME | DESCRIPTION | SUPPORTED DRIVERS | LIMITATIONS | CONFIGURATION | CREATING TABLES | EXAMPLE | AUTHOR | COPYRIGHT

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

home | help