ok, solution for this situation is two tables for outgoing messages
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.
Thank you Henk,
but it is not possible, for clarity I have 2 questions
1. How to read SQL connector data in database table:
In this scenario connector must ignored sms message for other gateway …
2. name_gateway is name from Gateway properties in Diafaan SMS server
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.
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
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
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.
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. `
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?
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 594
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1259