How to deploy a web app on Digital Ocean ubuntu server

  1. ‹ Older
  2. 2 weeks ago

    Dirk C

    Sep 10 Pre-Release Testers, Xojo Pro Belgium, Zedelgem
    Edited 2 weeks ago

    @Alberto D;Poo I think there is other hosting service with Xojo support too.

    Yes, Server Warp also has Xojo support

  3. Dirk C

    Sep 10 Pre-Release Testers, Xojo Pro Belgium, Zedelgem
    Edited 2 weeks ago

    @NIKOSZACHARAKIS I really did not expect this when I purchased XOJO and especially working on its web IDE platform. This is the last chance I am giving it, because I have wasted numerous hours and the people who are expecting results from me are getting tired!

    Unfortunately it looks like you might be running into limited knowledge of Webserver deployment, rather than Xojo limitations.
    It is indeed not so simple if you want to run your own server. You need to set it up correctly to get it to run.
    My situation is even different than yours, since we deploy standalone executables for api use (so they never have sessions that I need to take into account.)
    The easiest might indeed be to let someone have a look (Alberto offered to have a look) at what might be wrong. It's probably some setting that isn't right, but if you are not experienced it might be like looking for a needle in a haystack.
    I understand your frustration at the learning curve which seems very unlike Xojo.

  4. Oliver O

    Sep 10 Pre-Release Testers, Xojo Pro https://udemy.seminar.pro
    Edited 2 weeks ago

    I also wrote some how-to guide, but it was for a Ubuntu 14.04 LTS virtual server, and some of the libs may have changed in the meantime...
    But maybe you find some help or hints anyway, here (chapters 11 or 12):
    https://osswald.com/koblenz16/vps_linux_setup.pdf

  5. Hi Dirk,

    I just purchased a service (Linux) from ServerWarp in order to try out my luck there. Is it the norm that the service initially gets a status of "Pending"? Furthermore, I tried to find out more documentation on how to use Serverwarp services and how to manage my uploads etc., but I have not found anything yet. Even the knowledgeable/FAQs has a 0(zero) number! Do you have any experience in using this service? I have already opened a ticket with them and I am on stand-by.

    Thank you.

  6. Paul B

    Sep 11 Pre-Release Testers, Xojo Pro Europe (UK, Somerset)
    Edited 2 weeks ago

    I use it and really happy with it. Phillip will make contact when server commissioned with full details of how to get everything up and running. Which OS are you developing on?

    I use Windows, compile as 64 bit Linux I use CGI. Upload all files using winscp with your server details. Once uploaded use winscp to make all directories and files 0755 executable. Your app will run, point your browser at it and away you go.

  7. Hi Paul,

    Great to hear this and thank you for the info.
    I am developing in Mac OS and I compile CGIs same like you. 64 bit Linux. I use FileZilla to transfer the files and change the permissions.

    Take care.

  8. Dirk C

    Sep 12 Pre-Release Testers, Xojo Pro Belgium, Zedelgem

    @NIKOSZACHARAKIS Do you have any experience in using this service?

    Yes, I have an account there as well.
    Let us know if you need more help.
    As you can see, several of us are trying to help. Don't lose hope, we'll get you to a solution.

  9. I just signed up for his service, and will be loading my SaaS application there over the next couple of weeks.

  10. Phillip Z

    Sep 12 Pre-Release Testers, Xojo Pro Florence, SC

    @NIKOSZACHARAKIS Hi Dirk,

    I just purchased a service (Linux) from ServerWarp in order to try out my luck there. Is it the norm that the service initially gets a status of "Pending"? Furthermore, I tried to find out more documentation on how to use Serverwarp services and how to manage my uploads etc., but I have not found anything yet. Even the knowledgeable/FAQs has a 0(zero) number! Do you have any experience in using this service? I have already opened a ticket with them and I am on stand-by.

    Thank you.

    Hi Nikos,

    Thanks for your order.

    Our staff is in South Carolina and impacted by the hurricane coming in. Your server was auto-deployed (all orders are) but we do manual tests to verify Xojo applications run smoothly and everything is operating correctly. I will make sure you get sent your server details today.

  11. Dirk C

    Sep 13 Pre-Release Testers, Xojo Pro Belgium, Zedelgem

    @Phillip Z Our staff is in South Carolina and impacted by the hurricane coming in

    Be safe.

  12. Hi Paul, Dirk, Robert and Phillip,

    Thank you all for your valuable efforts and feedback. Sure thing Dirk, I will not lose hope, thanks to your willingness to help me :) I will wait for any updated info and proceed accordingly. Take care all of you and thank you once more.

    Nikos

  13. last week

    Hi to all again,

    I purchased yesterday a XOJO Cloud account and I deployed my web app. Finally, I can see some light!!! Using my XOJO cloud web server IP address, I can see my web app in any browser. Now my new issue is that I cannot seem to connect to MySQL using SSH. I received MySQL, SSH and Tunnel credentials from the XOJO Cloud account. I have transferred my MySQL database under the folder "/Shared_Documents" using FileZilla. What is the right process to connect it to XOJO MySQL in order for my web app to run the db connection that I have developed?

    Thank you.
    Nikos

  14. Paul L

    Sep 16 Xojo Inc http://developer.xojo.com

    MySQL is not a file-based database. You'd need to import your DB into the server on Xojo Cloud. You can connect to MySQL on Xojo Cloud using the tunnel and your favorite MySQL client of choice.

    Instructions are here:

    http://developer.xojo.com/xojo-cloud-control-panel$postgresql-and-mysql-usage

  15. Hi Paul,

    Thank you for your reply.
    I have already tried a number of times to use SSH Tunnel with Mac OS Terminal and after I enter the command
    ssh -L 3306:localhost:3306 dbadmin@178.128.226.123 -N
    I get the below error msg:

    bind: Address already in use
    channel_setup_fwd_listener_tcpip: cannot listen to port: 3306
    Could not request local forwarding.

    I also tried to connect with MySQL Workbench again using Mysql and SSH connection and I get another error msg:

    Failed to Connect to MySQL at localhost:3306 through SSH tunnel at dbadmin@178.128.226.123 with user dbadmin
    Can't connect to MySQL server on '127.0.0.1'

    The reason why I placed mysql database under "/Shared_Documents" was in case XOJO Cloud MySQL server can locate it better when I can manage to Terminal SSH.

  16. Greg O

    Sep 16 Xojo Inc Somewhere near Raleigh, NC

    @NIKOSZACHARAKIS bind: Address already in use
    channel_setup_fwd_listener_tcpip: cannot listen to port: 3306
    Could not request local forwarding.

    This error means that you already have an app using port 3306 locally.

  17. 5 days ago

    Hi Greg,

    I have managed to free my 3306 port, because, as you correctly mentioned, it was used by my local MySQL service.
    Now I am using port 3307, so port 3306 is available.
    However when I execute the "ssh..." command the terminal just stays idle! I also cannot connect with MySQL Workbench.

    Thank you.

  18. Jason P

    Sep 18 Xojo Inc http://xojo.com/

    Hi Nikos - It sounds like you need instructions on how to connect with MySQL Workbench. I will send those to you.

  19. Hi Jason,

    The info I enter in MySQL Workbench is:

    SSH Hostname: 178.128.226.123
    SSH Username: dbadmin
    some SSH password (given by XOJO Cloud)
    MySQL Hostname: localhost
    MySQL Server Port: 3306
    Username: dbadmin
    some MySQL password (given by XOJO Cloud)

    If you can tell me where my mistake is I will try it a.s.a.p.
    Thank you for your reply Jason.

    Take care.

  20. John A

    Sep 18 Pre-Release Testers, Xojo Pro Answer Las Vegas, Nevada

    @NIKOSZACHARAKIS However when I execute the "ssh..." command the terminal just stays idle! I also cannot connect with MySQL Workbench.

    A tunnel is just a pipeline between the two computers, that forwards a local connection securely to the remote computer.
    It won't do anything visible.

    The -L option is local_port:remote_address:remote_port
    So this command:

    ssh -L 3306:localhost:3306 dbadmin@178.128.226.123 -N

    creates a tunnel to 'localhost', looping back to yourself.

    Try this one:

    ssh -L 3306:178.128.226.123:3306 dbadmin@178.128.226.123 -N

    Then your workbench connection should work.

  21. Hi John,

    WOW!!! My Workbench finally works.
    Thank you very much for the enlightening info.

    I would like to thank all of you guys for the informative replies and your time spent to help me.
    Take care to you all.

    Nikos

or Sign Up to reply!