[chbot] Web Hosting

[Andrew Errington]

I had precisely the same problem. My workaround was to have a PHP web
page which I could POST to, which would take the contents of the POST
and store it in the database.

In other words, the database and the web server are both 'inside' the
ISP network and can talk to each other. The webserver has an
'outwards' facing connection, but the database does not. But, the
webserver can talk to the database, and you can therefore do all
database operations at arms-length via the webserver.

If Delphi can call a URL then that might be sufficient. If it can't,
maybe it can call cURL (which will call a URL).

I'd love to know if there was a better solution, but what I have works.

Andrew

On 24/05/2021, Marshland Engineering <marshland at marshland.co.nz> wrote:
> Bugger Bugger Bugger.
>
> After nearly 2 days of migration and trying to get thinks to work, I've hit
> hit a brick wall.  1stDomains do not allow remote access to the SQL.
> Originally I though that would be ok as I could do a PHP page for backup and
> restore.
>
> However I have now discovered it will not allow my Windows Delphi program to
> connect at all. It is the management program for the clubs events and
> riders.
> This is a deal breaker.
>
> Any other NZ hosting solutions?
>
> Someone got spare processing power !!!!  How well will a PI work with this ?
> Total number of records about 10K.
>
> Thanks Wallace
>
>
> _______________________________________________
> Chchrobotics mailing list Chchrobotics at lists.ourshack.com
> https://lists.ourshack.com/mailman/listinfo/chchrobotics
> Mail Archives: http://lists.ourshack.com/pipermail/chchrobotics/
> Meetings usually 3rd Monday each month. See http://kiwibots.org for venue,
> directions and dates.
> When replying, please edit your Subject line to reflect new subjects.