Hello,

I have this idea wherein i would like to integrate SMS Server Tools3 with a phpBB Board so that my registered users can send and "hopefully" receive message from my discussion board.

Scenario1:
A user will register in my phpBB Board, on the registration page there will be a field that will ask for the users mobile number. He will be user1.

Another user will register in my phpBB Board, he will also register his mobile number. He will be user2.

So, user1 would like to send a text message, he will access this page in my phpBB Board, then compose a message and send it to any mobile number( even if the number is not a member of the board ). The receiving number will receive a message from my phpBB Board. The message goes like this: From myBoard.com: To reply type 1234 then send to this number your message: hello, how are you?

If the intended destination number belongs to network1, the SMS Server tools must select the network1 GSM Modem in sending the message. There will be three network gsm modem, network1, network2 and network3. All of these network modem are registered on unlimited texting service.

Scenario2:
user1 can directly send a message to other users of the phpBB Board by sending a message to the SMS Server tools GSM number.

Example: user2 hey, i'm perfectly fine, then send to SMS Server tools network1 mobile number.

Then SMS Server tools will query the database of the phpBB Board for user2's mobile number, then if found, SMS Server tools will determine as to what network does user2 belongs and then use the appropriate GSM Modem in sending the message to user2. (Is this what you call SMS forwarding?)


All three gsm modems are registered on unlimited texting service offered by the mobile operator.
It is already typical for every mobile network user to register for an unlimited texting service offered by a network operator.
By using the SMS Server tools, user can send text message without limits to other network without their regular load being deducted.


Question is:
Is this possible with SMS Server tools?
What steps or actions should i consider?
Any comments?
Any suggestion?
Any help from the community?


Thank you all in advance!



PS: If the above scenario's are not that clear to you, I will be glad to draw a flow chart of what I'm trying to tell here.

I haven't started working on the project yet, still waiting for the hardware to arrive....

I googled "number portability philippines" and it seems that you do not have it in use, right?

When number portability is not used, queue sorting of smstools will work perfectly for you.

In scenario1, if you include extra headers "User: user1" and "Reply_code: 1234" in the message headers (and probably database of sent messages), it might be easier to find the sent message and username when reply from unregistered number is received.

How much are you going to deliver messages per day? If only some hundreds, file based eventhandler will work with periodically cleaning of directories, but if you handle like 10000 messages per day, you need SQL based message tracking.

Quote

I googled "number portability philippines" and it seems that you do not have it in use, right?

When number portability is not used, queue sorting of smstools will work perfectly for you.

That's nice to know.

Quote

In scenario1, if you include extra headers "User: user1" and "Reply_code: 1234" in the message headers (and probably database of sent messages), it might be easier to find the sent message and username when reply from unregistered number is received.

Okay, thanks for the tip. Well, is retrieving mobile number from the phpbb database and inserting them to the outgoing message possible?

Quote

How much are you going to deliver messages per day? If only some hundreds, file based eventhandler will work with periodically cleaning of directories, but if you handle like 10000 messages per day, you need SQL based message tracking.

I think my board will be delivering around a hundred messages per day.



havent received the needed hardwares yet huhu

Hi keke,

keke wrote

maboo23 wrote

I like to ask, how to create a script?

By using your favorite editor.

Ok, you might want to visit this: Advanced Bash-Scripting Guide. It's very good.

Quote

Is it possible to use smsd to get data from MYSQL data base?

Currently there is no built in support for SQL based spooling. It may come to the some next version, probably in two or three months. While waiting it, you must use a script to poll MySQL database and to create outgoing files etc.

So, what i'm planning on doing is not possible? since I'm planning on getting the mobile numbers from a mysql database that the user registered.

So, i think, I'm gonna have to change my systems analysis and design.
Has anyone tried using SMS server tools to forward SMS from one network to another? So that users will be able to send SM from one network to another without their regular load getting deducted? Users must also be registered to the unlimited texting service of their provider to be able to send unlimited texts to other network.

does anyone have a script on this?

hi kaloyski,

Im also from philippines. If you are really serious on pushing this kind of project, we are happy to provide development service to you. You can reach me at my YM: druid_ccc.

Cheers

Hi kaloyski,

maboo23's question was about scripting without defining what kind of functionality was required, and about SQL where smsd get's data from SQL table. Inside the smsd there is not yet SQL support, it's coming later.

Scripting guides found on the internet are good. What you are planning on is possible to create with phpBB you are using as a front-end application. You are modifying pbpBB's database to include necessary fields and change registration form and create a page where message is composed. This new page will create an outgoing message like smstest.php does. If you create an unique "reply_code" and include extra headers "User: user1" and "Reply_code: 1234" in the message, tracking is easier later. When a reply is received, you can use eventhandler to do the following steps:

- Extract reply code from the message body.
- Get senders number from headers.
- From sent messages directory search a message which was sent to this number and has correct Reply_code header. From this message you can get User: header.
- With user detail you can search his/her number from phpBB's database. Look example eventhandlers to see how SQL data is retrieved.
- When you have user's number, you can create a new message which sends an answer.
- You can also add a new header to the original sent message file, to inform that reply was sent.

Message forwarding is possible and it will work perfectly in Philippines. I know that some users have made eventhandlers which make forwarding based on the number in the begin of a message body, but currently there is no sample script published. However, basically forwarding is simple: when a message is received, get the first word from the message body, it's a destination number. Create a new message with To: this number and with message body without the first word. After this, smsd's queue sorting will do the rest, correct provider is selected and message is sent without cost's. For setting up queues see this.

Example eventhandlers can be found from the scripts directory of a package. Also here in this board are some samples.

Hello keke,

I've already purchased Mr. Frings book and am reading it now.

I tried sending message and this is what i got:
Globe: Modem is not clear to send
2009-07-19 02:38:54,3, Globe: Modem is not clear to send
2009-07-19 02:39:07,3, Globe: Modem is not clear to send
2009-07-19 02:39:20,3, Globe: Modem is not clear to send
2009-07-19 02:39:34,3, Globe: Modem is not clear to send
2009-07-19 02:39:47,3, Globe: Modem is not clear to send
2009-07-19 02:40:01,3, Globe: Modem is not clear to send
2009-07-19 02:40:14,3, Globe: Modem is not clear to send
2009-07-19 02:40:22,5, smsd: Moved file /var/spool/sms/outgoing/send_gIfo0L to /var/spool/sms/Globe
2009-07-19 02:40:27,3, Globe: Modem is not clear to send
2009-07-19 02:40:40,3, Globe: Modem is not clear to send
2009-07-19 02:40:53,3, Globe: Modem is not clear to send
2009-07-19 02:41:07,3, Globe: Modem is not clear to send
2009-07-19 02:41:20,3, Globe: Modem is not clear to send
2009-07-19 02:41:33,3, Globe: Modem is not clear to send
2009-07-19 02:41:47,3, Globe: Modem is not clear to send
2009-07-19 02:42:00,3, Globe: Modem is not clear to send
2009-07-19 02:42:13,3, Globe: Modem is not clear to send
2009-07-19 02:42:27,3, Globe: Modem is not clear to send
2009-07-19 02:42:40,3, Globe: Modem is not clear to send
2009-07-19 02:42:53,3, Globe: Modem is not clear to send
2009-07-19 02:43:07,3, Globe: Modem is not clear to send
2009-07-19 02:43:20,3, Globe: Modem is not clear to send
2009-07-19 02:43:30,3, Globe: Modem is not ready to answer commands (Timeouts: 0)

What could be the reason? I'm using a nokia 6210 with DLR3p cable. Does this mean that the modem can't communicate with the phone? because i've tried many times communicating to the phone from hyperterminal but got no reply at all when i try entering at command. it just freezes and does nothing at all. i tried already so many combinations, researched over the net and found couple of dudes that experience same problem with hyperterminal + nokia 6210 + dlr3p cable.

I have used 6210's with DLR-3P, with original one and with a clone. They both have worked well using traditional RS-232 port and also using USB-RS232 converter. Latest try was yesterday when 6210 & DLR-3P worked well on FreeBSD 7.2 using smsd 3.1.3 and 3.1.5. There was no any setting changed.

First ensure that your port really is correct, then try with and without rtscts = no and with different baudrates. 115200 should work but try 19200 and 9600 too. If any combination does not work event when the port is correct, there should be something broken. Can you test communication using a different machine?

@keke, thanks for the assurance that 6210 + dlr3p works

Darn, it frustrates me. The very basic of making ans SMS application is not wokring. Ive already bought another cable from another seller, i think its an original since he told me that it comes with the phone when he bought it. But still, its not working. Ive already tried it with xp sp3 and on vmware linux using minicom, ive also setup the correct port for use by the vmware but still nothing happens.

I'm gonna try the phones and cables later on another machine. I really hope it will work.

he keke,

could you please check this out: http://www.electronicslab.ph/forum/index.php?topic=8235.0
according to the post above, was he able to send and receive? please see this screen shot: http://img10.imageshack.us/img10/9971/atcommandhypertrm.jpg

i was wondering if this device http://tattoo.globe.com.ph/ can be used as an alternative gsm modem?

i did tried using other computer, its a laptop with a serial port on it. and its still not working. hay. what am i to do.

i'm beginning to suspect that the cable i'm using is really not a dlr-3p cable. though it looks like one and fits perfectly and the seller says its a dlr-3p. huhuh

i've already asked someone to build me a DIY DLR-3P cable like the one on the link below. Hope it will work with sms server tools.
http://i37.tinypic.com/8xkhex.jpg

kaloyzki wrote

could you please check this out: ...
according to the post above, was he able to send and receive? please see this screen shot: ...

The picture only shows that command for message format was accepted and list of message was retrieved using ASCII mode. It cannot be said for sure that PDU mode is supported, but usually with new devices it is. Hopefully some user on the electronicslab forum can test this device.

Quote

i was wondering if this device ... can be used as an alternative gsm modem?

I did not find technical documentation for this device, so it's bad to say anything for sure.

About your 6210, can you test your adapters using another 6210 to check if your first 6210 is somehow limited or it's external interface is broken? In most cases, anyways, you will need a backup device, so it might be a good idea to search it now.

Well, as a matter of fact i've already tried 2 nokia 6210 over 4 different dlr3p cable with different settings. I'm gonna borrow from a friend and test whether the usb wireless broadband modem will work with sms server tools.

btw, i also tried using the dlr3p cable with a nokia 5110 and still it wont work. so i'm really suspecting that its the cable that's somehow faulty. all 4 of them!. geesh

So for now, i'm gonna wait for this home made cable: http://i37.tinypic.com/8xkhex.jpg and hopefully will work!

hello keke,

do you have an Entity Relationship Diagram and or Data Flow Diagram for SMS Server Tools?
I got a bit curious about SMS Server Tools for i've realized that there's a lot of application that could be developed with short messages.

thanks in advance!

You are right, lot of applications can be developed.

But there is no any diagrams available as I have never needed and made them. Sorry. (Slideshow has some pictures, but they are very simple).