[Mifos-developer] SMS Gateway failing to run
Mexina Daniel
Hi devs
I hope you are all doing well.
I would like to ask if someone have encountered the issue or can understand what is an issue and help.
Our SMS gateway was running okay with configurations of Infobip and was sending sms just fine. But after some days it stopped to run (SMS wasn't sent and the dropdown for service provider wasn't available)
We decide to restart the tomcat server so that it can restart the messagegateway but now it throwing an error (attached the catalina.out)
I have also attached the server.xml file and application.yml file for message-gateway to see the configurations.
Thank you in advance.
|
Mexina Daniel
Chief Executive Officer
Singo Africa Limited
|
||||||||||||||||
|
|
|||||||||||||||
    |
||||||||||||||||
James Dailey
Mexina Daniel
Hi James
We have been using tomcat 7 even when the SMS was working.
The MaxSpareThreads is provided in the connector that runs the platform and I tried to remove the variable and the result is the same, SMS gateways gives the same errors.
Kind Regards
Mexina Daniel
Hi Arnold
Thank you for your response.
The URL has not changed from the time it was working, and I have checked it is still correct.
Regarding to their services, the same service is used in another server which use the same platform and it is working fine, I have tested even in my local computer and the messagegateway ran successfully.
Kind Regards
|
Mexina Daniel
Chief Executive Officer
Singo Africa Limited
|
||||||||||||||||
|
|
|||||||||||||||
    |
||||||||||||||||
On 04-03-2022 12:50, Arnold Galovics wrote:
Hi Mexina,Which fineract version are you running?I took a quick look at the logs you attached and there's this piece:Exception in thread "pool-6-thread-1" org.springframework.web.client.HttpClientErrorException$NotFound: 404 Not Found: [<html><head><title>Apache Tomcat/7.0.82 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans... (1003 bytes)]
at org.springframework.web.client.HttpClientErrorException.create(HttpClientErrorException.java:113)
at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:170)
at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:112)
at org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63)
at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:785)
at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:743)
at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:717)
at org.springframework.web.client.RestTemplate.exchange(RestTemplate.java:635)
at org.apache.fineract.infrastructure.sms.scheduler.SmsMessageScheduledJobServiceImpl.connectAndSendToIntermediateServer(SmsMessageScheduledJobServiceImpl.java:179)This suggests that either the Gateway URL is misconfigured (which I assume is not the case) or that the Gateway is responding with a 404 - i.e. it's an issue with their service.Can you please double-check if the URL is 100% correct? If it is, it's probably worth reaching out to them and asking if they have changed anything.Best,Arnold
Mexina Daniel
Hello team
We were able to identify the cause of SMS gateway failing to run. The issue was with the connection to the datasource. It seems there were already enough connections so the gateway was not connected.
One thing which is strange is when we checked to "show processlist" on the database to see how many connections are in use, we saw databases (tenants) made five connections each which are in sleep state and this lead to many connections.
Can anyone help to understand why more than one connection made in one database and how to fix this?