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:

Quote

# 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 wrote

1) On the top part of the script, in the comment section, Keke wrote:

Quote

# 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 ?

The schema could be like the following:

+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| type          | varchar(16)  | YES  |     | NULL    |                |
| sent          | datetime     | YES  |     | NULL    |                |
| received      | datetime     | YES  |     | NULL    |                |
| sender        | varchar(32)  | YES  |     | NULL    |                |
| receiver      | varchar(32)  | YES  |     | NULL    |                |
| status        | varchar(3)   | YES  |     | NULL    |                |
| msgid         | varchar(3)   | YES  |     | NULL    |                |
| text          | mediumtext   | YES  |     | NULL    |                |

...and some more fields, depending on the front-end application.

almangkok wrote

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 ?

Yes, you can append it. You can also store the script as a different file, and include it to your script:

Thank you for the clarification.