Please check this example: Sample eventhandler to store messages into SQL database.

You should adjust SQL_* variables and probably fields too if you want to use a different format of a database. I recommend to use the standard format because it contains many fields which you will need in the future.

Suitable database can be created using this kind of SQL statement:
CREATE TABLE `smsd`.`sms_log` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `type` varchar( 16 ) NOT NULL , `sent` datetime NOT NULL , `received` datetime NOT NULL , `sender` varchar( 32 ) NOT NULL , `receiver` varchar( 32 ) NOT NULL , `status` char( 3 ) NOT NULL , `msgid` char( 3 ) NOT NULL , `text` varchar( 255 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM ;

Your three scripts are not very handy, because you have to change the configuration and restart smsd before each run. Of course, you are just testing your system currently, but you can also call the required script from the "master" eventhandler if you want to. In this case, insert the following to the end of a given sample eventhandler:
if [ "$1" == "RECEIVED" ]; then if echo $TEXT | grep -qi "^get"; then /usr/local/bin/BUPB_GET_handler $1 "$2" fi if echo $TEXT | grep -qi "^reg"; then /usr/local/bin/BUPB_REG_handler $1 "$2" fi if echo $TEXT | grep -qi "^krm"; then /usr/local/bin/BUPB_KRM_handler $1 "$2" fi fi

These codes are not exactly what you have asked, but they will show how things can be done. Hopefully these examples will help you to move forward.

Hi Keke

Sorry for the late of reply, cause I've try my SMS gateway Server using this application (sms server tools) as your suggest too.

Ya, I know that 3 of my scripts aren't very handy. It just test in my sistem only. Let me keep learn about it using manual and also your example

And many thanks about your suggest at solution of that scripts. I'll try it now. ^_^

Regard