Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Sql Connector Web Services
sp_NewPost Add Reply sp_NewTopic Add Topic
March 5, 2012
5:00 pm
Henk Helmantel
Guest
Guests

Diafaan SMS Server has an internal database to store the messages while they waiting to be sent. After the messages are sent (or failed after a number of retries), they are stored in a separate internal log database.

The log items can be automatically removed after a certain time, but if you want to keep all log items than this is also possible. It is not recommended though for situation with high message traffic .

March 5, 2012
3:57 pm
Roger
Guest
Guests

But using some other connector than the Sql Connector, then the message isn't stored in a database-table, but somehow internally in the SMS Server?

Somehow I'm so database oriented that for me it would be natural that all connectors would use a database-table to store messages.

Having sent a message to the SMS-Server (with other than Sql Connector), for how long a period after that can I request the status of the message, ie. for how long time is the message stored on the server?

Regards Roger.

March 5, 2012
2:01 pm
Henk Helmantel
Guest
Guests

Absolutely. By default, Diafaan SMS Server tries to send the message 3 times per GSM modem when the first send attempt(s) fails. If desired, his can be increased to a higher number of retries.

It is also possible to assign one or more backup gateway(s) in case (one of) the primary gateway(s) cannot send the message.

Regards, Henk

March 5, 2012
12:56 pm
Roger
Guest
Guests

Hi Henk,

You already have some kind of built-in HTTP web service in Diafaan SMS Server. Doesn't this in any way store the message, eg. to a database-table. Doesn't the server try to send a failed message again?
I mean, isn't there any reoccurring of failed messages until they have been sent or until som maxtry-counter has been reached?

Regards Roger.

PS. Sorry for not have yet had time to test Diafaan. But we will probably test it.

February 27, 2012
5:03 pm
Henk Helmantel
Guest
Guests

Hi Roger,

Using the SQL database directly from Diafaan SMS Server locally or over a network connection is the most reliable way to add SMS to an Internet service. If you do not want to expose the database connection to the Internet then you will have to build the necessary interface yourself.

Since this is outside the scope of the functionality in Diafaan SMS Server, I am afraid I am not able to give any examples on how to create such an interface.

Regards, Henk

February 27, 2012
3:57 pm
Roger
Guest
Guests

Hi Henk,

You usually want to protect your Sql-Server by using some kind of data-access layer, eg. by using web-services. By using web-services it's also possible to make business rules that all application-programmers should be aware of, ie. not letting programmers access tables directly, writing and interpreting data wrong.

On the other hand, using SSL you should perhaps not need any further encryption, just some kind of username and password for the web-service. And it's of course a problem of ours to install and protect the server.

Regards Roger.

February 24, 2012
11:22 am
Henk Helmantel
Guest
Guests

Hi Roger,

I am not sure what you want to achieve. Most SQL servers have the ability to be used over the Internet and most are also able to use an encrypted connection like SSL.

If you have a web service with a (MySQL) database that is accessible over the Internet then you can use the SQL Connector to retrieve messages to send from the database and to store incoming SMS messages without the need to encrypt/decrypt anything in the web service.

Regards, Henk

February 24, 2012
9:58 am
RogerW
Guest
Guests

Hi,

Suppose that I would like to use the "Sql Connector" and send records to the Sql Server over internet (https I suppose). The best way would perhaps be to build a Web Service that inserts records into the "database-table that is being polled for messages to be sent". And web-services checking the status of the log-table etc.

Considering all kind of encrypting/decrypting that should be done in such web-services, are there any prebuilt example web-services considering this kind of problems? Or should one consider another connector than the Sql Connector?

Regards Roger.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 680

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1155

Posts: 3945

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1510