Sponsored Content
Full Discussion: sms
Top Forums Shell Programming and Scripting sms Post 20325 by udi on Wednesday 24th of April 2002 02:47:35 PM
Old 04-24-2002
Hi again

Well as i was searching a way to do it , i started searching some

old directories , hoping someone tried doing it before i.

I was happy to find out that actually someone did , i found an app

that is doing just what i needed , you enter the message and the

the mobile number and it sends the sms.

I am sure some configuration was needed when it was first

installed , if someone needs information on how it was done ,

I will be happy to try and find out how.

bye for now

Udi
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SMS from Perl?

What exactly does the SMS module do i Perl? Can you send free sms messages from Perl ???? (1 Reply)
Discussion started by: perleo
1 Replies

2. IP Networking

sms application

actually i need this sms application ,to gain some knowledge in linux platform. if possible post to (1 Reply)
Discussion started by: parvathy
1 Replies

3. Shell Programming and Scripting

sms using mailx

the mailx command can be used to send mails. can i use the mailx command for sending sms to my mobile number in india?? Is it possible? If yes how? If its not mailx then wht is the command for that? (6 Replies)
Discussion started by: vikasduhan
6 Replies

4. UNIX for Advanced & Expert Users

Sending SMS

Hi, Can any one tell me how to send SMS using Unix shell scripting. My scenario is whenever my count on particular tables exceeds beyond certain limit i need to trigger out an sms to the client. It could be better if there is no third party tools involved in it. Thanks in advance... (9 Replies)
Discussion started by: sarojadevi
9 Replies

5. Shell Programming and Scripting

Mail and SMS

Hi friends, I have a question related to UNIX mail issue. Let me explain the scenario. I am working in HP UNIX system and we are having some shell scripts those are already scheduled. Whenever the scripts are failed to run. I got an auto generated mail from UNIX administrator. To read the mail I... (4 Replies)
Discussion started by: rdhaprakasam
4 Replies

6. Solaris

sms alerts

how to configure sms alerts in SUN SPARC servers to notify file system , cpu, memory and disk errors. (2 Replies)
Discussion started by: phani.madiraju
2 Replies

7. Shell Programming and Scripting

Need help with SMS script...

I use the SMS script on this page: http://www.prescriptionpc.com/TEST_newpage1.html#section=sms The “functions” work fine, but after clicking “submit” and receiving the “thank you” message, nothing happens. I find it odd that I can send a text message to myself choosing my carrier (Virgin... (0 Replies)
Discussion started by: Bruce1969
0 Replies

8. Solaris

Help with SMS sending Script

I would like assistance on a script that could send a text message to my mobile phone when I run a command and the text should be send only if a condition is met. I want to have a cron-job running every 10 minutes to check the system for overload conditons with a command: more logfile.log | grep... (5 Replies)
Discussion started by: thinktank
5 Replies

9. UNIX for Advanced & Expert Users

Send SMS to mobile

Hello Folks, I need to send the output from shell script to range of mobile phones based on their msisdn . Is there any open source solution could help me to do so from CentOS or redhat ?? (11 Replies)
Discussion started by: arm
11 Replies
GAMMU-SMSD-SQL(7)						       Gammu							 GAMMU-SMSD-SQL(7)

NAME
gammu-smsd-sql - gammu-smsd(1) backend using SQL abstraction layer to use any supported database as a message storage DESCRIPTION
SQL service stores all its data in database. It can use one of these SQL backends (configuration option Driver in smsd section): o native_mysql for gammu-smsd-mysql o native_pgsql for gammu-smsd-pgsql o odbc for gammu-smsd-odbc o drivers supported by DBI for gammu-smsd-dbi, which include: o sqlite3 - for SQLite 3 o mysql - for MySQL o pgsql - for PostgeSQL o freetds - for MS SQL Server or Sybase SQL CONNECTION PARAMETERS
Common for all backends: o User - user connecting to database o Password - password for connecting to database o Host - database host or data source name o Database - database name o Driver - native_mysql, native_pgsql, odbc or DBI one o SQL - SQL dialect to use Specific for DBI: o DriversPath - path to DBI drivers o DBDir - sqlite/sqlite3 directory with database See also The variables are fully described in gammurc documentation. SQL QUERIES
Almost all queries are configurable. You can edit them in [sql] section. There are several variables used in SQL queries. We can separate them into three groups: o phone specific, which can be used in every query, see Phone Specific Parameters o SMS specific, which can be used in queries which works with SMS messages, see SMS Specific Parameters o query specific, which are numeric and are specific only for given query (or set of queries), see Configurable queries Phone Specific Parameters %I IMEI of phone %P PHONE ID (hostname) %N client name (eg. Gammu 1.12.3) SMS Specific Parameters %R remote number [1] %C delivery datetime %e delivery status on receiving or status error on sending %t message reference %d receiving datetime for received sms %E encoded text of SMS %c SMS coding (ie 8bit or UnicodeNoCompression) %F sms centre number %u UDH header %x class %T decoded SMS text %A CreatorID of SMS (sending sms) %V relative validity [1] Sender number for received messages (insert to inbox or delivery notifications), destination otherwise. CONFIGURABLE QUERIES
All configurable queries can be set in [sql] section. Sequence of rows in selects are mandatory. All default queries noted here are noted for MySQL. Actual time and time addition are selected for default queries during initialization. delete_phone Deletes phone from database. Default value: DELETE FROM phones WHERE IMEI = %I insert_phone Inserts phone to database. Default value: INSERT INTO phones (IMEI, ID, Send, Receive, InsertIntoDB, TimeOut, Client, Battery, SignalStrength) VALUES (%I, %P, %1, %2, NOW(), (NOW() + INTERVAL 10 SECOND) + 0, %N, -1, -1) Query specific parameters: %1 enable send (yes or no) - configuration option Send %2 enable receive (yes or no) - configuration option Receive save_inbox_sms_select Select message for update delivery status. Default value: SELECT ID, Status, SendingDateTime, DeliveryDateTime, SMSCNumber FROM sentitems WHERE DeliveryDateTime IS NULL AND SenderID = %P AND TPMR = %t AND DestinationNumber = %R save_inbox_sms_update_delivered Update message delivery status if message was delivered. Default value: UPDATE sentitems SET DeliveryDateTime = %C, Status = %1, StatusError = %e WHERE ID = %2 AND TPMR = %t Query specific parameters: %1 delivery status returned by GSM network %2 ID of message save_inbox_sms_update Update message if there is an delivery error. Default value: UPDATE sentitems SET Status = %1, StatusError = %e WHERE ID = %2 AND TPMR = %t Query specific parameters: %1 delivery status returned by GSM network %2 ID of message save_inbox_sms_insert Insert received message. Default value: INSERT INTO inbox (ReceivingDateTime, Text, SenderNumber, Coding, SMSCNumber, UDH, Class, TextDecoded, RecipientID) VALUES (%d, %E, %R, %c, %F, %u, %x, %T, %P) update_received Update statistics after receiving message. Default value: UPDATE phones SET Received = Received + 1 WHERE IMEI = %I refresh_send_status Update messages in outbox. Default value: UPDATE outbox SET SendingTimeOut = (NOW() + INTERVAL locktime SECOND) + 0 WHERE ID = %1 AND (SendingTimeOut < NOW() OR SendingTimeOut IS NULL) Query specific parameters: %1 ID of message find_outbox_sms_id Find sms messages for sending. Default value: SELECT ID, InsertIntoDB, SendingDateTime, SenderID FROM outbox WHERE SendingDateTime < NOW() AND SendingTimeOut < NOW() AND SendBefore >= CURTIME() AND SendAfter <= CURTIME() AND ( SenderID is NULL OR SenderID = '' OR SenderID = %P ) ORDER BY InsertIntoDB ASC LIMIT %1 Query specific parameters: %1 limit of sms messages sended in one walk in loop find_outbox_body Select body of message. Default value: SELECT Text, Coding, UDH, Class, TextDecoded, ID, DestinationNumber, MultiPart, RelativeValidity, DeliveryReport, CreatorID FROM outbox WHERE ID=%1 Query specific parameters: %1 ID of message find_outbox_multipart Select remaining parts of sms message. Default value: SELECT Text, Coding, UDH, Class, TextDecoded, ID, SequencePosition FROM outbox_multipart WHERE ID=%1 AND SequencePosition=%2 Query specific parameters: %1 ID of message %2 Number of multipart message delete_outbox Remove messages from outbox after threir successful send. Default value: DELETE FROM outbox WHERE ID=%1 Query specific parameters: %1 ID of message delete_outbox_multipart Remove messages from outbox_multipart after threir successful send. Default value: DELETE FROM outbox_multipart WHERE ID=%1 Query specific parameters: %1 ID of message create_outbox Create message (insert to outbox). Default value: INSERT INTO outbox (CreatorID, SenderID, DeliveryReport, MultiPart, InsertIntoDB, Text, DestinationNumber, RelativeValidity, Coding, UDH, Class, TextDecoded) VALUES (%1, %P, %2, %3, NOW(), %E, %R, %V, %c, %u, %x, %T) Query specific parameters: %1 creator of message %2 delivery status report - yes/default %3 multipart - FALSE/TRUE %4 Part (part number) %5 ID of message create_outbox_multipart Create message remaining parts. Default value: INSERT INTO outbox_multipart (SequencePosition, Text, Coding, UDH, Class, TextDecoded, ID) VALUES (%4, %E, %c, %u, %x, %T, %5) Query specific parameters: %1 creator of message %2 delivery status report - yes/default %3 multipart - FALSE/TRUE %4 Part (part number) %5 ID of message add_sent_info Insert to sentitems. Default value: INSERT INTO sentitems (CreatorID,ID,SequencePosition,Status,SendingDateTime, SMSCNumber, TPMR, SenderID,Text,DestinationNumber,Coding,UDH,Class,TextDecoded, InsertIntoDB,RelativeValidity) VALUES (%A, %1, %2, %3, NOW(), %F, %4, %P, %E, %R, %c, %u, %x, %T, %5, %V) Query specific parameters: %1 ID of sms message %2 part number (for multipart sms) %3 message state (SendingError, Error, SendingOK, SendingOKNoReport) %4 message reference (TPMR) %5 time when inserted in db update_sent Update sent statistics after sending message. Default value: UPDATE phones SET Sent= Sent + 1 WHERE IMEI = %I refresh_phone_status Update phone status (battery, signal). Default value: UPDATE phones SET TimeOut= (NOW() + INTERVAL 10 SECOND) + 0, Battery = %1, SignalStrength = %2 WHERE IMEI = %I Query specific parameters: %1 battery percent %2 signal percent AUTHOR
Michal iha <michal@cihar.com> COPYRIGHT
2009-2012, Michal iha <michal@cihar.com> 1.31.90 February 24, 2012 GAMMU-SMSD-SQL(7)

Featured Tech Videos

All times are GMT -4. The time now is 04:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy