Standalone Web App and SSL

Targets Web
1

Just wondering does a standalone web app support SSL/TLS?

Thanks

2

sorry, no.

3

You can have SSL using nginx in front of your web standalone app.

4

You can use sslproxy or stunnel to get it working as well. I do this routinely. Stunnel is easy and effective.

5

Stunnel home page: https://www.stunnel.org/index.html

6

Hi,

I created a simple stand alone application that uses SSL (following this instructions).
My SSL is a Comondo SSL. My app connects to a MySQLDatabase (Community Edition) and runs a simple select query when pressing a button. I call my web application with this url https://myWebsite.com:24900. (my website shares the same ssl and uses apache web server).

8 to 10 times my application crashes on loading, with the following error:

Runtime Error
Please report what caused this error along with the information below.
Universal\REALstring.cpp: 134
Failure Condition: usageCount

The web application starts with the command: Myapp.exe --secureport=24900.

My Session.Open event code is:

dbControl = New DatabaseControl

And the constructor of DatabaseControl is:

Try
Me.db = New MySQLCommunityServer

Me.db.Host = "127.0.0.1"
Me.db.DatabaseName ="mydb"
Me.db.UserName = "username"
Me.db.Password = "pass"

If Me.db.Connect Then
  Me.db.SQLExecute("SET CHARACTER SET 'utf8'")
  Me.db.SQLExecute("SET NAMES 'utf8'")
  Me.dbConnected = True
Else
  Me.dbConnected = False
  MsgBox "Error connecting to MySQL : " + db.ErrorMessage
End If

Catch e As RunTimeException
MsgBox(“Error:”+Str(e))
End Try

I can’t find the source that causes this exceptions. Any help or demo will be appreciated.

My application runs fine without SSL or as CGI.

Thank You

7

You might have stumbled across a similar bug as I have. I only see it in debug though.
<https://xojo.com/issue/33421>
The ticket is closed as I could not find the steps to reproduce it :confused:

8

[quote=88611:@Albin Kiland]You might have stumbled across a similar bug as I have. I only see it in debug though.
<https://xojo.com/issue/33421>
The ticket is closed as I could not find the steps to reproduce it :/[/quote]
Could you please send me some more info because i can not open the link?

9

You need the Feedback app from Xojo, then the link will work :slight_smile:
https://xojo.com/download/extras.php

10

I realized that those commands crashes my app:

Me.db.SQLExecute(“SET CHARACTER SET ‘utf8’”)
Me.db.SQLExecute(“SET NAMES ‘utf8’”)

Any suggestions?

11

if you have a crash, you can figure out which command causes it.