Connection to the server lost

[Santiago Baena]

Hello,

 My name is Santiago Baena, and I am trying to use Frontline SMS in a project carried out by my foundation in Peru. However, once I have installed the software in my computer, when I try to open the application, a window in my browser is opened but just for a few seconds and then this message is displayed: "Connection to the server has been lost. Please restart FrontlineSMS, or close the window." Do you know how can I deal with this?

I could not attach both documents "stacktrace.log" and "standard.log", but I believe there are empty...!

Thanks!

Santiago

[Vaneyck Seme]

Hi,

What is the url in the browser, at the time it fails

Thanks

[Santiago Baena]

Hi,

This is the URL:

http://localhost:8080/message/inbox?sort=date&order=desc&starred=false&failed=false&max=50&offset=0

Thanks!

[Vaneyck Seme]

Hi,

You may want to try and delete the database thats located in the same directory as the logs files: "C://Users/yourusername/.frontlinesms2/"

Then restart the software.

Thanks

[Santiago Baena]

Which files are the databases? Anyway, I have tried to delete all of them and still doesn't work...

Thanks

[Vaneyck Seme]

Hi,

The database file is "prodDb.h2.db". The other files are "prodDb.trace.db stacktrace.log standard.log". Which you can also delete.

Thanks

[Santiago Baena]

I have tried to delete .db files (by the way, that one ProdDb.trace.db, doesn't appear, instead there is one named ProdDb.lock.db) but the message displayed is still the same.

Thanks

[Sitati Kituyi]

Hi Santiago,

It sounds like there could be an issue here; I've attached a script that will increase your logging level, which might help us identify the problem. To use it, just drop this file in the same directory as the logs and database, then start the application.

Please also confirm that you are using version 2.0.3, which this custom logging script is tested against. Once you have the debugging logs (which will appear in the same directory), you can send these to us and we'll try to identify the issue.

Thanks,

Sitati

[Santiago Baena]

Hi,

I did what you said, but I don't know which are the debugging files (.db I guess) so find them attached. Version is 2.0.3.

Thanks!

[Sitati Kituyi]

Hi again,

Sorry, I should have been more clear about the logs to upload - in addition to standard.log and stacktrace.log, this should have created a file called 'fsms-debug.log'.

Please let me know if this file exists.

The files you uploaded are your database, which I will use to confirm that there is no corrupt data, but for privacy reasons we have removed these attachments (your contacts & messages are stored in them).

[Laura Walker Hudson]

Hi Santiago

We've deleted those attachments for security but have saved them here.

Thanks!

Laura

[Santiago Baena]

Hi,

(I start a new thread since it seems there cannot be more replies). I am afraid no file turns up when I drop "log4j.groovy" in the frontlinesms2 directory and start the software...

Thanks

[Sitati Kituyi]

Ok, we have one more option, but unfortunately it requires some steps involving the command prompt. Please try the following, which should give us some log files to investigate the issue.

Open your command prompt (Press Windows Button+R then type in 'cmd' and press enter). Type in the following commands, pressing enter at the end of each line.

• cd "c:\Program Files\frontlinesms2"
• FrontlineSMS2_Launcher.exe > "c:\Users\<your username>\Desktop\Log.txt" (replace <your username> with your windows account username)

FrontlineSMS should then launch, and create a Log.txt file on your desktop. Once the problem has repeated itself, please exit FrontlineSMS and send us this log file.

Please let us know if you need any help doing this. Also, please state the Windows version and the browser name & version that you are using.

Thanks,

Sitati.