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, you might have to tweak SQL queries to work in used SQL server, see SQL Queries for more details.
Partially this can be configured using SQL.
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.
On Microsoft Windows, you can find instructions on Microsoft website: http://support.microsoft.com/kb/305599
For unixODBC this is documented in the user manual: http://www.unixodbc.org/doc/UserManual/
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-2012, Michal iha <michal@cihar.com>
1.31.90 February 24, 2012 GAMMU-SMSD-ODBC(7)
Check Out this Related Man Page
GAMMU-SMSD-MONITOR(1) Gammu GAMMU-SMSD-MONITOR(1)NAME
gammu-smsd-monitor - Monitor state of SMS daemon for Gammu
SYNOPSIS
gammu-smsd-monitor [OPTION]...
DESCRIPTION
This manual page documents briefly the gammu-smsd-monitor command.
gammu-smsd-monitor is a program that monitors state of Gammu SMS Daemon. It periodically displays information about phone and number of
processed messages.
Program accepts following options (please note that long options might be not accepted on some platforms):
-h, --help
Shows help.
-v, --version
Shows version information and compiled in features.
-c, --config=file
Configuration file to use, default is /etc/gammu-smsdrc, on Windows there is no default and configuration file path has to be always
specified.
-n, --loops=count
Number of loops, by default monitor loops infinitely.
-d, --delay=seconds
Delay betwen polling SMSD state, default is 20 seconds.
-C, --csv
Print output in comma separated values format:
client;phone ID;IMEI;sent;received;failed;battery;signal
-l, --use-log
Use logging as configured in config file.
-L, --no-use-log
Do not use logging as configured in config file (default).
AUTHOR
Michal iha <michal@cihar.com>
COPYRIGHT
2009-2012, Michal iha <michal@cihar.com>
1.31.90 February 24, 2012 GAMMU-SMSD-MONITOR(1)
Hey all,
I'm trying to locate a good sql forum - similar in nature to this, where I can can get some quick responses to questions I have.
I've tried a few but they are either no longer running - or have one visitor every month.... just wanting to see if anyone uses a forum that is of the... (6 Replies)
I installed the unixODBC driver but when I execute isql, returns the following error:
----- ERROR -----
Can't open lib '/usr/local/lib/libmyodbc3.sl' : Call to mmap() failed - TEXT /usr/local/lib/libmyodbc3.sl
ERROR: Could not SQLConnect
----- DRIVER -----
/usr/local/lib
usrv45: ls -la... (11 Replies)
Hi GURUs,
I have following queries:
1) If its possible to configure Microsoft SQL Server database on a UNIX machine, if yes, can any body pls point me to the guide to acheive the same.
2) I know Oracle runs perfectly on UNIX based machines, can any body point me to the guide to achieve the... (6 Replies)
My sql file xyz_abc.sql in this file there are multiple sql block in this block I need to find the following block
rem Subset Rows (&&tempName.*)
CREATE VIEW &&tempName.* AS
SELECT *
FROM &&tempName.*
WHERE f is not null
and replace with following code
rem Subset Rows... (9 Replies)
Hi everyone,
when i run ;
sqlplus -s username/password@TTTEST @umt.sql
i take "ORA-12154: TNS:could not resolve service name"
i want to run "umt.sql" query and also see result.
thanx for your helping. (6 Replies)
Hello all,
I have a shell script that uses multiple .sql files. These .sql files mainly contain Oracle SQL queries to pull fields from the database. I want to place all the contents of these .sql files in one .sql file and have some parameter sent based on which the respective block or query... (6 Replies)
output of Unix & sql in same file
hi all,
am working on shell script, i need to format data in such a way
that both my Unix commands output & my sql output should be in a same file.
I am able to redirect both output in separate files.
for sql output: sqlplus -s... (6 Replies)
Hi
I am trying to write a script to extract information from a database and save that info to a csv file.
I am using sql, an oracle database
I have no idea how to even begin this.
Can somebody please help. (8 Replies)
I have two queries
query1
select IDW_SITE_NAME REGION,a.location_sid,a.CALENDAR_SID,count(*) from idw.vod_stream a, IDW_REF_DATA b
where a.location_sid = b.location_sid and a.calendar_sid between 20110901 and 20110915 --this is start date parameter and end date
parameter
and... (5 Replies)
Dear Experts,
I have a scenario where I have to form sql queries in a file using echo command.
I have file1 which has more than 10 lac numbers. For each Number in file 1, I need to create 5 sql queries resulting in 50 lac queries totally.
For doing this I use the below simple method,
for i... (5 Replies)
i have 3 sqls , sql 1 and sql 2 shuld run in parallel , but sql 3 should run after completion f sql1 nd sql2, my code is as below, please suggest the changes
sqlplus username1/password1@DB1 @sql >> log1 &
sqlplus username2/password2@DB2 @sql2 >> log1 &
how can i execute the... (7 Replies)
Hi,
I need to somehow pipe the password to a command and run some SQL, for example, something like echo $password | sqlplus -s system @query01.sql
To make it not so obvious, I decided to try out writing a small C program that basically just do echo $password. So now I just do x9.out | sqlplus... (8 Replies)