SMS Server Tools 3
 Menu
Basic information:
Additional information:
Support:
Get SMS Server Tools 3:
Additional Options

 Sponsored links

 Search
Custom Search

 Visitor locations
 
 SMS Server Tools 3 Community
Welcome, Guest. The forum is currently read-only, but will open soon. Thu Mar 13, 2025 01:34
SMSTools3 Community » Search Bottom

Page:  1  2  Next

Keywords:
Mode: All keywords (AND)
almangkok: In the bash script, woud it be okay to include the failed directory like so: BASEDIR="/var/spool/sms" DIRS="failed sent report incoming"
almangkok: My bad :( I must have accidentally copied the version number from somewhere, when actually I am only running v3.1.6 instead of v3.1.11. My apologies. All other info are correct though. I inserted report_device_details = yes into smsd.conf and restart gave an error. So I just comment that settings and restart smsd. This is a production server. Would it be okay to upgrade by just overwriting the old files with the newer version ?
almangkok: Done that. Thank you Keke !
almangkok: Operating system name and version: CentOS 4.8 Version of smsd: 3.1.11 Smsd installed from: sources Name and model of a modem / phone: Wavecom Interface: serial Hi and thanks to Keke. I have been using smstools for almost a year. Overall a great and easy piece of software to use. About the files in /var/spool/sms/incoming and /var/spool/sms/sent, can I safely delete them? Is there some kind of cron job that can do that on, say, a weekly basis ? Please advise. TIA.
almangkok: Operating system name and version: CentOS 4.8 Version of smsd: 3.1.11 Smsd installed from: sources Name and model of a modem / phone: Wavecom Interface: serial Hi, I have a working SMSTools and Nagios. Nagios is currently only monitoring services such as HTTP, SSH and FTP. 1) I am currently using postpaid and at times have forgotten to pay my bills and as such, no SMS can be sent out. Would it be possible to configure Nagios to monitor such events ? Any examples ? 2) How would one normally monitor SMSTools with Nagios. I mean, how would you monitor whether SMSTools is running is the first place ? Does it make use of any port that Nagios can monitor ? TIA.
almangkok: So I just need to add that line, recompile and install ?
almangkok: Operating system name and version: CentOS 4.8 Version of smsd: 3.1.11 Smsd installed from: sources Name and model of a modem / phone: Wavecom Interface: serial 2011-01-05 08:56:56,7, GSM1: Done: eventhandler, execution time 0 sec., status: 0 (0) 2011-01-05 08:56:57,5, GSM1: Cannot convert 107. character 0x 9 to GSM, you might need to update the translation tables. 2011-01-05 08:56:57,5, GSM1: Cannot convert 169. character 0x 9 to GSM, you might need to update the translation tables. Sometimes I got this message in the log. What does it means and how do I go about updating the translation tables ? Please help.
almangkok: Keke, appreciate if you could give some info (make and model) on LAN modem that work well with SMSTools. TIA.
almangkok: Operating system name and version: CentOS 4.8 Version of smsd: 3.1.6 Smsd installed from: sources Name and model of a modem / phone: Wavecomm Fastrak Supreme 10 Interface: serial The FAQ at http://smstools3.kekekasvi.com/index.php?p=faq#2, noted that sending a single message will take between 5 to 10 seconds. How to increase this rate? But how many SMS can SMSTools3 HANDLE per second on an old 2GB DELL 1750 server? 80 SMSes? 100 SMSes ? TIA.
almangkok: Operating system name and version: Linux CentOS 4.8 Version of smsd: 3.1.6 Smsd installed from: sources Name and model of a modem / phone: Wavecomm Fastrak Supreme 10 Interface: Serial Would it be safe to compile and install 3.1.11 on top of my current 3.1.6? Would there be any changes needed in /etc/smsd.conf ? TIA.
almangkok: Operating system name and version: Linux CentOS 4.8 Version of smsd: 3.1.6 Smsd installed from: sources Name and model of a modem / phone: Wavecomm Fastrak Supreme 10 Interface: Serial Hi, What would be the PHP equivalent of these 2 lines that was written in Bash: #Extract data from the SMS file FROM=`formail -zx From: < $2` TEXT=`formail -I "" <$2 | sed -e"1d"` TIA.
almangkok: Is this problem still active? Hi Keke, Yes the problem is still active. I was outstation for 2 days to attend to some family problem. Hence I was offline during that time. If your database surely contains a ticket when it's queried, you have unstable installation of mysql. Yes I CONFIRMED that the database contain that ticket number. I am conducting more tests now actually. And thank you for your tips.
almangkok: I decided to try out and restart smsd every hour via cron: 0 * * * * /etc/init.d/sms3 restart Then got this mail Date: Thu, 5 Aug 2010 16:31:02 +0800 From: root@localhost.localdomain (Cron Daemon) To: root@localhost.localdomain Subject: Cron <root@lab> /etc/init.d/sms3 restart Content-Type: text/plain; charset=UTF-8 X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <HOME=/root> X-Cron-Env: <PATH=/usr/bin:/bin> X-Cron-Env: <LOGNAME=root> X-Cron-Env: <USER=root> Allowing smsd to terminate gracefully within 45 seconds . Starting SMS Daemon: smsd. BUT surprisingly, whenever I sent log 94 receive I got a reply saying that ticket 94 does not exist. I tried a few variant with cron like changing restart with reset and also stop followed by start, BUT they all gave identical result. BUT if I were to restart smsd thru the command line, everything works fine. I am running out of idea. Please please help. Dateline is nearing :(
almangkok: ... and this is my smsd.conf # Example smsd.conf. Read the manual for a description #devices = GSM1 #logfile = /var/log/smsd.log #sent = /var/spool/sms/sent #failed = /var/spool/sms/failed #loglevel = 7 eventhandler=/usr/local/bin/smsd_event.sh keep_filename=no #[GSM1] #device = /dev/ttyS0 #incoming = yes ##pin = 1111 devices = GSM1 infofile = /var/run/smsd/smsd.working pidfile = /var/run/smsd/smsd.pid outgoing = /var/spool/sms/outgoing checked = /var/spool/sms/checked failed = /var/spool/sms/failed incoming = /var/spool/sms/incoming report = /var/spool/sms/report stats = /var/log/smstools/smsd_stats sent = /var/spool/sms/sent logfile = /var/log/smsd.log loglevel = 7 receive_before_send = no autosplit = 3 #user = smsd #group = dialout [GSM1] device = /dev/ttyS0 incoming = yes cmgl_value = 0 check_memory_method = 31
almangkok: You had a message: 2010-08-03 10:54:19,6, GSM1: Wrote an incoming message file: /var/spool/sms/incoming/GSM1.aKjwsO Is this file still available and can you check if the syntax of message is correct? Yes it is still available and the syntax is correct. OK I came to office early today to run another test. To summarized: 1. Launch help desk system and fillup web form, hit Submit button 2. I received the SMS that was sent 3. I read the SMS, ticket number is 92 and decided to acknowledge receipt 4). I sent an SMS: log 92 receive 5. I received an SMS that notified me that ticket 92 does NOT exist 6. I ran mysql thru command line and confirmed that the ticket exist, the ticket status on help desk system showed Open (meaning update has NOT taken place in database) 7. I restarted smsd 8. I sent another SMS to acknowledge receipt of ticket 92: log 92 receive 9. This time round I received an SMS notifying me that I have acknowledged receipt of ticket 92. Help desk system showed ticket status as Acknowledged (meaning update has taken place in database) 10. I am now very confused :| Here are some truncated log messages from some of the steps above, and hope they can shed some light on the problem: After step 5), /var/log/smsd.log shows 2010-08-05 09:06:10,7, GSM1: <- +CMGL: 1,0,,32 07910691930000F0240B910631228791F70000018050906064230ECCF719949381E4E571396D2F03 OK 2010-08-05 09:06:10,6, GSM1: Used memory is 1, list: 1 2010-08-05 09:06:10,5, GSM1: SMS received, From: 60132278197 2010-08-05 09:06:10,6, GSM1: Wrote an incoming message file: /var/spool/sms/incoming/GSM1.NrON8S 2010-08-05 09:06:10,7, GSM1: Running eventhandler: /usr/local/bin/smsd_event.sh RECEIVED /var/spool/sms/incoming/GSM1.NrON8S 2010-08-05 09:06:10,7, GSM1: Done: eventhandler, execution time 0 sec., status: 0 (0) 2010-08-05 09:06:10,6, GSM1: Deleting message 1 and /var/log/smsd_eventhandler.log shows 2010-08-05 09:06:10,7, smsd_eventhandler: Ticket does not exist: select count(*) from tickets where id=92 . 60132278197. Log 92 receive Ran mysql to confirm that ticket 92 does exist: [root@lab sources]# mysql -uroot -pduplaplant24 ticket -s -e "select count(*) from tickets where id=92" count(*) 1 [root@lab sources]# Restarted smsd [root@lab bin]# /etc/init.d/sms3 restart Starting SMS Daemon: smsd. [root@lab bin]# Looks OK: 2010-08-05 09:08:42,2, smsd: Smsd mainprocess is awaiting the termination of all modem handlers. PID: 28381. 2010-08-05 09:08:42,2, GSM1: Modem handler 0 terminated. PID: 28382, was started 10-08-05 04:02:06. 2010-08-05 09:08:42,2, smsd: Smsd mainprocess terminated. PID 28381, was started 10-08-05 04:02:06. 2010-08-05 09:08:43,2, smsd: Smsd v3.1.6 started. 2010-08-05 09:08:43,2, smsd: Running as root:root. 2010-08-05 09:08:43,7, smsd: Running startup_check (shell): /tmp/smsd_script.hEcFAM /tmp/smsd_data.rl6RBX 2010-08-05 09:08:43,7, smsd: Done: startup_check (shell), execution time 0 sec., status: 0 (0) 2010-08-05 09:08:43,4, smsd: File mode creation mask: 022 (0644, rw-r--r--). 2010-08-05 09:08:43,5, GSM1: Modem handler 0 has started. PID: 31343. 2010-08-05 09:08:43,5, GSM1: Using check_memory_method 31: CMGL is used and messages are taken from the list. 2010-08-05 09:08:43,6, GSM1: Checking device for incoming SMS 2010-08-05 09:08:43,6, GSM1: Checking if modem is ready 2010-08-05 09:08:43,5, smsd: Outgoing file checker has started. PID: 31342. This is /var/log/smsd.log after step 9) 2010-08-05 09:11:27,5, GSM1: SMS received, From: 60132278197 2010-08-05 09:11:27,6, GSM1: Wrote an incoming message file: /var/spool/sms/incoming/GSM1.eSSd4g 2010-08-05 09:11:27,7, GSM1: Running eventhandler: /usr/local/bin/smsd_event.sh RECEIVED /var/spool/sms/incoming/GSM1.eSSd4g 2010-08-05 09:11:27,7, GSM1: Done: eventhandler, execution time 0 sec., status: 0 (0) 2010-08-05 09:11:27,6, GSM1: Deleting message 1 and /var/log/smsd_eventhandler.log shows: 2010-08-05 09:11:27,7, smsd_eventhandler: Acknowledged receipt of ticket number: 92 . 60132278197 Log 92 receive If there is/are anything wrong with my eventhandler script, then things should not have work out even if I restarted smsd. I was hoping that there is something that I can do to fix the eventhandler script. But I also agree with you that the idle time should not have any effect, yet after restarting smsd, things work the way they should. Here is my eventhandler script, just in case: #!/bin/bash # 1. Helpdesk admin fillup webform when there is a problem with a PC # 2. Information will be sent via SMS to a technician # 3. Then technician will acknowledge receipt of the SMS alert by replying with # log ticket-number receive # eg log 123 receive # # 4. When done, technician will send another SMS to close the ticket and also what action were taken with # log ticket-number done action-taken # eg log 123 done replace hard drive if [ "$1" != "RECEIVED" ]; then exit; fi; QAM="60193635577" #Quality Assurance Manager #general function to send SMS sendsms () { FILENAME=`mktemp /tmp/answerXXXXXX` echo "To: $1" >$FILENAME echo "" >> $FILENAME echo "** HELP DESK **" >>$FILENAME echo "" >> $FILENAME echo -n "$2" >>$FILENAME FILENAME2=`mktemp /var/spool/sms/outgoing/answerXXXXXX` mv $FILENAME $FILENAME2 } APPNAME="smsd_eventhandler" LOGFILENAME="/var/log/smsd_eventhandler.log" #-------------------------------------------------------------------------- write_log() { local DATE=`date +"%Y-%m-%d %T"` echo "$DATE,7, $APPNAME: $1" >> $LOGFILENAME } #-------------------------------------------------------------------------- #Extract data from the SMS file FROM=`formail -zx From: < $2` TEXT=`formail -I "" <$2 | sed -e"1d"` #put content of TEXT into an array named PARAM PARAM=($TEXT) ARGS=${#PARAM[@]} #convert to lowercase LOG_TEXT="$(echo ${PARAM[0]} | tr 'A-Z' 'a-z')" TICKET_NUMBER=${PARAM[1]} RECEIVE_OR_DONE_TEXT="$(echo ${PARAM[2]} | tr 'A-Z' 'a-z')" if [ $LOG_TEXT = 'log' ]; then #ticket MUST be integer if [ "$TICKET_NUMBER" -ge 0 -o "$TICKET_NUMBER" -lt 0 2>/dev/null ]; then #check if that ticket number exist in the first place EXIST=`mysql -uroot -pduplaplant24 ticket -s -e "select count(*) from tickets where id=$TICKET_NUMBER;"` if [ $EXIST -gt 0 ]; then case $RECEIVE_OR_DONE_TEXT in receive) ARR=`mysql -uroot -pduplaplant24 ticket -s -e "select t1.amid,t1.amname,t2.title from tickets as t1,members as t2 where t1.id=$TICKET_NUMBER and t1.amid=t2.id ;"` detail=($ARR) TECH_ID=${detail[0]} TECH_NAME=${detail[1]} TECH_MOBILE=${detail[2]} #update ticket status to Acknowledged (status = 7) TICKET_STATUS=$(mysql -uroot -pduplaplant24 ticket -sN -e "update tickets set status=7 where id=$TICKET_NUMBER;") #send technician a msg on how to close this ticket write_log "Acknowledged receipt of ticket number: ${TICKET_NUMBER} . ${FROM} ${TEXT}" sendsms "$FROM" "$TECH_NAME acknowledged receipt of ticket number: $TICKET_NUMBER After your job is done, pls close this ticket with log $TICKET_NUMBER done action-taken and send it to 0193522587" #remove comment when we go live #send QAM a copy #sendsms "$QAM" "$TECH_NAME acknowledged receipt of ticket number: $TICKET_NUMBER" exit ;; done) #Is this person have rights to close this particular ticket? ARR=`mysql -uroot -pduplaplant24 ticket -s -e "select t1.amid,t1.amname,t2.title from tickets as t1,members as t2 where t1.id=$TICKET_NUMBER and t1.amid=t2.id ;"` detail=($ARR) TECH_ID=${detail[0]} TECH_NAME=${detail[1]} TECH_MOBILE=${detail[2]} if [ $TECH_MOBILE -ne $FROM ] || [ ${#ARR} = 0 ]; then #No perm error write_log "No permission to close ticket ${TICKET_NUMBER} . ${FROM} ($TEXT"} sendsms "$FROM" "You have no permission to close ticket $TICKET_NUMBER" exit else #check number of arguments if [ $ARGS -lt 4 ]; then write_log "No description on what action(s) were taken to resolve ticket number ${TICKET_NUMBER} . ${FROM} ${TEXT}" sendsms "$FROM" "Please indicate what action(s) were taken to resolve ticket number $TICKET_NUMBER" exit else ACTION_TAKEN="" for ((i=3; i<=$ARGS ; i++)) # eg. log 123 done changed hard disk do ACTION_TAKEN=$ACTION_TAKEN"${PARAM[$i]} " #concatenation done fi result=$(mysql -uroot -pduplaplant24 ticket -sN -e "update tickets set status=6,close_mid=$TECH_ID,close_mname='$TECH_NAME' where id=$TICKET_NUMBER;") #Acknowlege the close ticket request write_log "${TECH_NAME} ${FROM} have successfully closed ticket number ${TICKET_NUMBER} , action: ${ACTION_TAKEN}" sendsms "$FROM" "$TECH_NAME have succssfully closed ticket number $TICKET_NUMBER action taken: $ACTION_TAKEN" #inform QAM #sendsms "$QAM" "$TECH_NAME have succssfully closed ticket number $TICKET_NUMBER #action taken: $ACTION_TAKEN" exit fi ;; *) #Must be an error at the 3rd parameter. No SMS sent, just silent write_log "Error at the 3rd parameter. ${FROM}. ${TEXT}" exit esac else write_log "Ticket does not exist: select count(*) from tickets where id=$TICKET_NUMBER . ${FROM}. ${TEXT}" sendsms "$FROM" "Directive Error: Ticket $TICKET_NUMBER does not exist" exit fi else #Ticket number was not an integer. No SMS sent, just silent write_log "Ticket number NOT an integer. ${FROM}. ${TEXT}" exit fi else #Must be an error at the 1st parameter. No SMS sent, just silent write_log "Error at the 1st parameter. ${FROM}. ${TEXT}" exit fi
almangkok: I noticed that, initially, the problem came when smsd was idle for several hours. I have incorporated all changes and will report here soon if things are stable.
almangkok: Man I learnt alot today. I will implement the changes asap. And thank you so much for your advises Keke.
almangkok: Perhaps you have "exit 1" somewhere in your eventhandler, which usually is not correct. I have a few of those actually. Wonder if I need to replace those with just exit ? Anyway, #!/bin/bash # 1. Helpdesk admin fillup webform when there is a problem with a PC # 2. Information will be sent via SMS to a technician # 3. Then technician will acknowledge receipt of the SMS alert by replying with # log ticket-number receive # eg log 123 receive # # 4. When done, technician will send another SMS to close the ticket and also what action were taken with # log ticket-number done action-taken # eg log 123 done replace hard drive if [ "$1" != "RECEIVED" ]; then exit; fi; #general function to send SMS sendsms () { FILENAME=`mktemp /var/spool/sms/outgoing/answerXXXXXX` echo "To: $1" >$FILENAME echo "" >> $FILENAME echo "** HELP DESK **" >>$FILENAME echo "" >> $FILENAME echo "$2" >>$FILENAME } #Extract data from the SMS file FROM=`formail -zx From: < $2` TEXT=`formail -I "" <$2 | sed -e"1d"` #put content of TEXT into an array named PARAM PARAM=($TEXT) ARGS=${#PARAM[@]} #convert to lowercase LOG_TEXT="$(echo ${PARAM[0]} | tr 'A-Z' 'a-z')" TICKET_NUMBER=${PARAM[1]} RECEIVE_OR_DONE_TEXT="$(echo ${PARAM[2]} | tr 'A-Z' 'a-z')" if [ $LOG_TEXT = 'log' ]; then #ticket MUST be integer if [ "$TICKET_NUMBER" -ge 0 -o "$TICKET_NUMBER" -lt 0 2>/dev/null ]; then #check if that ticket number exist in the first place EXIST=`mysql -uroot -pnosecret ticket -s -e "select count(*) from tickets where id=$TICKET_NUMBER;"` if [ $EXIST -gt 0 ]; then case $RECEIVE_OR_DONE_TEXT in receive) ARR=`mysql -uroot -pnosecret ticket -s -e "select t1.amid,t1.amname,t2.title from tickets as t1,members as t2 where t1.id=$TICKET_NUMBER and t1.amid=t2.id ;"` detail=($ARR) TECH_ID=${detail[0]} TECH_NAME=${detail[1]} TECH_MOBILE=${detail[2]} #send technician a msg on how to close this ticket sendsms "$FROM" "$TECH_NAME acknowledged receipt of ticket number: $TICKET_NUMBER After your job is done, pls close this ticket with log $TICKET_NUMBER done and send it to 60193522587" exit 0 ;; done) #Is this person have rights to close this particular ticket? ARR=`mysql -uroot -pnosecret ticket -s -e "select t1.amid,t1.amname,t2.title from tickets as t1,members as t2 where t1.id=$TICKET_NUMBER and t1.amid=t2.id ;"` detail=($ARR) TECH_ID=${detail[0]} TECH_NAME=${detail[1]} TECH_MOBILE=${detail[2]} if [ $TECH_MOBILE -ne $FROM ] || [ ${#ARR} = 0 ]; then #No perm error sendsms "$FROM" "You have no permission to close ticket $TICKET_NUMBER" exit 1 else #check number of arguments if [ $ARGS -lt 4 ]; then sendsms "$FROM" "arg = $ARGS Please indicate what action(s) were taken to resolve ticket number $TICKET_NUMBER" exit 1 else ACTION_TAKEN="" for ((i=3; i<=$ARGS ; i++)) # log 123 done changed hard disk do ACTION_TAKEN=$ACTION_TAKEN"${PARAM[$i]} " #concatenation done fi result=$(mysql -uroot -pnosecret ticket -sN -e "update tickets set status=6,close_mid=$TECH_ID,close_mname='$TECH_NAME' where id=$TICKET_NUMBER;") #Acknowlege the close ticket request sendsms "$FROM" "$TECH_NAME have succssfully closed ticket number $TICKET_NUMBER action taken: $ACTION_TAKEN" exit 0 fi ;; *) #Must be an error at the 3rd parameter. No SMS sent, just silent exit 1; esac else sendsms "$FROM" "Directive Error: Ticket $TICKET_NUMBER does not exist" exit 1; fi else #Ticket number was not an integer. No SMS sent, just silent exit 1; fi else #Must be an error at the 1st parameter. No SMS sent, just silent exit 1; fi
almangkok: Operating system name and version: Linux CentOS 4.8 Version of smsd: 3.1.6 Smsd installed from: sources Name and model of a modem / phone: Wavecomm Fastrak Supreme 10 Interface: Serial My eventhandler is written such that it processes RECEIVED messages. The script will then send me a text to confirm. Just now, I sent in a text message and I waited for several minutes (no confirmation received from my eventhandler) before deciding to open up my log and noticed this: 2010-08-03 10:54:19,5, GSM1: SMS received, From: 60132278197 2010-08-03 10:54:19,6, GSM1: Wrote an incoming message file: /var/spool/sms/incoming/GSM1.aKjwsO 2010-08-03 10:54:19,7, GSM1: Running eventhandler: /usr/local/bin/smsd_event.sh RECEIVED /var/spool/sms/incoming/GSM1.aKjwsO 2010-08-03 10:54:19,3, GSM1: Done: eventhandler, execution time 0 sec., status: 256 (1) 2010-08-03 10:54:19,6, GSM1: ALERT (continues, 2): problem with eventhandler, result 1 2010-08-03 10:54:19,6, GSM1: Deleting message 1 2010-08-03 10:54:19,7, GSM1: -> AT+CMGD=1 I restarted smsd (without any changes to eventhandler) and this time the eventhandler script confirmed that it processes the instruction and sent me a text msg that I have received. Here is the log: 2010-08-03 11:02:55,7, GSM1: <- > 2010-08-03 11:02:56,7, GSM1: -> 0011000B910631228791F70000FF9D2A150859644241C4E2740952A9140AFDDB0D0A8FD7EEF79D5D269FCB6490BC3C2EA7E174D0DB0CA2A7C7EB321DE4AEB7C565B90E748B29144133BD2C07E5DF753948FD1683D27310F9ED2EB34070F61C3466BFE765101D9D9E83E8E9F1BA4C07DDD3743448C17E9F41B718685E6697E7E1B422EC2683E665371994A683E86F102C969BD564B21AEEA600^Z 2010-08-03 11:02:57,7, GSM1: Command is sent, waiting for the answer 2010-08-03 11:03:03,7, GSM1: <- +CMGS: 229 OK 2010-08-03 11:03:03,5, GSM1: SMS sent, Message_id: 229, To: 60132278197, sending time 11 sec. 2010-08-03 11:03:03,6, GSM1: Moved file /var/spool/sms/checked/o4A4B6 to /var/spool/sms/sent/GSM1.Q8JQk5 2010-08-03 11:03:03,7, GSM1: Running eventhandler: /usr/local/bin/smsd_event.sh SENT /var/spool/sms/sent/GSM1.Q8JQk5 229 2010-08-03 11:03:03,7, GSM1: Done: eventhandler, execution time 0 sec., status: 0 (0) I wonder why I need to restart smsd. Would an upgrade to 3.1.11 be a good idea or am I missing something obvious here. Appreciate some thoughts. TIA.
almangkok: Thank you for the clarification.
almangkok: Operating system name and version: Linux CentOS 4.8 Version of smsd: 3.1.11 Smsd installed from: sources Name and model of a modem / phone: Wavecomm Fastrak Supreme 10 Interface: Serial I have successfully implemented smsd with our helpdesk system. I have also, with help from this forum, made use of eventhandler so that our technicians are able to close a ticket by sending an sms to the helpdesk system. I would like to move a step further and log all events into an SQL database. I have found the script here: http://smstools3.kekekasvi.com/topic.php?post=132#post132 Questions: 1) On the top part of the script, in the comment section, Keke wrote: # You need a MYSQL database as described in the documentation. # Please read the documentation before using this script. :| I tried browsing thru the ~/doc directory, but couldn't find any reference to mysql. Where can I get the database schema to do this ? 2) As stated earlier, I have an eventhandler script written in bash too, that handles incoming SM from our technicians. Can I just append the script at http://smstools3.kekekasvi.com/topic.php?post=132#post132 to my current script ? TIA.
almangkok: Fully understood . Thanks Keke.
almangkok: I just came across the Blacklist and Whitelist features of smsd. Are those in any way related and can be useful in my case ?
almangkok: ... or is there a way to configure smsd to receive sms ONLY from a set of mobile numbers?
almangkok: Operating system name and version: Linux CentOS 4.8 Version of smsd: 3.1.11 Smsd installed from: sources Name and model of a modem / phone: Wavecomm Fastrak Supreme 10 Interface: Serial Hi, I have implemented an eventhandler for my helpdesk system. So far things are looking great. And thanks for a superb piece of software Keke. In my eventhandler, I have included certain checks for errors. Whenever there is an error, smsd will send an SMS to that person. Problem is, the SIM also receives lots of promos that were sent by my telco. How do I make smsd reject those messages ?

Page:  1  2  Next

SMSTools3 Community » Search Top

 
Time in this board is UTC.  

Privacy Policy   SMS Server Tools 3 Copyright © Keijo Kasvi.