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
Error: No gateway available
sp_NewPost Add Reply sp_NewTopic Add Topic
March 20, 2012
10:35 am
ramirez
Guest
Guests

ok, solution for this situation is two tables for outgoing messages

March 20, 2012
9:51 am
Henk Helmantel
Guest
Guests

The SQL Connector reads all messages from the SQL database, Diafaan SMS Server then assigns a (list of) gateway(s) to each message and if there is no gateway that can be assigned to send the messages it is flagged as failed with the error "No gateway available".

The actual SQL statement is something like "SELECT * FROM database_name WHERE isRead'1' AND Scheduled<NOW() LIMIT 500;"

In your situation, Diafaan SMS Server reads the messages from the SQL database, finds that it cannot assign the messages to the gateway that you specify in the database record and flags the messages as failed.

Regards, Henk

March 20, 2012
7:49 am
ramirez
Guest
Guests

Thank you Henk,
but it is not possible, for clarity I have 2 questions

1. How to read SQL connector data in database table:

SELECT * FROM database_name WHERE isRead=0 AND gateway = 'name_gateway'

In this scenario connector must ignored sms message for other gateway …

2. name_gateway is name from Gateway properties in Diafaan SMS server

Config:

March 19, 2012
2:23 pm
Henk Helmantel
Guest
Guests

Hi Ramirez,

Most likely, the gateway name that you provide does not match an actual gateway that the SQL Connector is allowed to use, hence the "No gateway available" error. This error can also mean that the gateway is down (for instance if the mobile network is out of reach) but in this case I think it is just a configuration error.

The SQL Connector can set the IsRead database field to "1" when it reads the message from the SQL database. This does not imply that the messages was sent, only that it was picked up by Diafaan SMS Server.

Regards, Henk

March 19, 2012
2:06 pm
ramirez
Guest
Guests

I have same problem.

2x instalation Diafaan SMS Server with GSM Gateway and SQL connector
1x MS SQL 2008 R2 with shared table in database for booth Diafaan

For sending sms from Diafaan1 i set in to table phone number GSM in Diafan1 and gateway name from this instalation. Sms message not sending and in Diafaan2 in SQL connector Events is "No Gateway Available", but in message table parameter isRead set to 1 isRead=1

March 19, 2012
1:55 pm
ramirez
Guest
Guests

same problem for me. I have two instalation Diafaan with GSM gateway and reading sms from SQL database over SQL connector.

For send sms over Diafaan1 i set in to table:
MessageFrom: number GSM in Diafaan1
Gateway: GSM1

SMS message not sending and in SQL connector Diafaan2 is this message

300 Error: No gateway available

But in SQL database isRead = 1 why ?

Sorry for my bad english

If I send sms over Email connector everything working ok.

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

Hi Arief,

This error means that there was no active Gateway available at the time when the message was sent. If a gateway is down for more than 10 minutes it is flagged as unavailable and when no other gateways are assigned to the SQL Connector, new messages are rejected with the error "No Gateway Available". You should see an error in the event log about the GSM Modem Gateway at the time that the message was sent (or earlier).

If the error is persistent and there are no indications in the event log that the GSM modem did not work properly at the time of sending the message, then it is also possible that there is an error in the configuration of the message routing. `

Regards, Henk

February 22, 2012
7:46 am
Arief
Guest
Guests

When I send SMS with SQL Connector, in MessageLog table , StatusText column, there is following error message "Error:No Gateway Available".I used diafaan SMS Server trial version for 3 weeks and there are no problems with it.

I think my modem is working well. I have 2 Wavecom GSM modem, I have tried both, and still there is the error.

Anybody can help me?

REgards,
Arief

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 365

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 533

Posts: 1849

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 554