If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Aug 2019
    Member #

    Don't know how to implement this project

    I want to make a project that will access a database. As the db will be accessed by many computers, not all in the same physical building, the db must be on a server. In my profession, we use some servers for mail, hosting, etc. Those servers, running Linux (RedHat x64) offer db hosting that can be accessed only by php and edited by phpmyadmin, no other way "for security reasons" as it is written in one help page. There are two solutions:

    1) make a php project that will access the db and do all the work (authentication, show data, forms for input, etc).

    2) make a desktop app which will communicate with a web service that will read/write from/to the db.

    In both cases, security is needed. The server supports TLS but pages are shown via http, no https support. So my php files will have no security (or at least I think so). On the other hand, the web service needs to run 24/7. I don't think I have the right to do it. I don't know how to do it. I have tried to contact with the server stuff with no success. I prefer the second one as it is easier to make the client and the web service (don't know how to connect with TLS but I know how to use AES).
    Also, in some cases, Joomla is used in web page construction.

    So, if you were me, what would you do?


  3. #2
    Senior Member sarahswansea's Avatar
    Join Date
    Oct 2015
    Swansea, UK
    Member #
    69 times
    It's fairly easy to expose a database on a server for secure remote use. And you can set up permissions and roles so that remote users can only do certain things.

    However, a minimal web service that has an API, and you make a desktop app to communicate with it, is totally viable. It seems like this is where you're most comfortable and have expertise and confident in what you're doing so I'd go with it.

    It's very professional of you to recognise areas of security you aren't comfortable in
    Tawesoft <-- hire me here if you need a Go or Python webdev

  4. #3
    Junior Member
    Join Date
    Aug 2019
    Member #
    6 times
    Quote Originally Posted by Doctorized View Post
    So, if you were me, what would you do?
    I am also struggling with similar questions. But I have chosen to test another path. Instead of php that 80% of the world uses and hackers are familiar with, I selected to work in Golang. Nearly as fast as C++ and are a compiled language compared to php that is a interpreted language wide open.

    Golang is both a webserver (instead of Apache & co) and a tool to build API for accessing databases.

    This is a rough path I have chosen. I do recommend it for speed and security, but not for quick up-and-running solution.

    I have finished the first of my goal. To create a simple website. Next step is to fetch data from Postgresql.

  5. #4
    WDF Staff m3n0tu18's Avatar
    Join Date
    Jul 2011
    Hampshire, UK
    Member #
    265 times
    You could try migrating to an AWS server. Amazon servers support Sslssh access and the ability to choose what specific ports you want open... So for instance if port 3306 is not a preferred dB access port you can change it to EG 3376 and make sure your Joomla instance can read it (usually there is an option to choose the port you want in the config file, alternatively look for the database and code it like so - localhost:3376)

    AWS also support a plesk instance (if you don't know how to install a GUI) out of the box you literally just choose it and follow the instructions and that will allow you to install your SSL Certificate into your domain setup. (NOTE: This is only suggested if you don't know how to fully use Terminal)

    Hope that helps.

    Sent from my Pixel 2 using Tapatalk
    If you like my comments to your thread please click the LIKE button

    Check out my portfolio: Here!
    View my company Facebook Page
    View my company Website

    <<Plrease ignoer my typo's I have isdexlyia>>

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
All times are GMT -6. The time now is 11:36 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2022 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: