Elizabeth,
Last conversation i recommended tools like ssh (you could also succesfully use stunnel
(http://www.stunnel.org), i tried and it works well).. but.. there is an easier way.
Guess that it depends on the mysql version your ISP is running, elsewise ask them to
upgrade.. Also make sure you have a recent libmysql dll/so.
Then use the function mysql_real_connect (see manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect
) :
mysql_init(MyDB); //you must call mysql_init first
mysql_real_connect(MyDB,PChar(your_isp), PChar(User), PChar(Passw), PChar(Database),
3306, nil, CLIENT_SSL);
This would, if available, use a SSL layer to connect to the MySQL server.
I'm not too sure since which version SSL is available, the changelog mentions you can
check for 'have_ssl' with "show variables" in version 3.23.30 so at least from this
version and up, but maybe functionality is there much longer. Also afaik the binary
rpm is compiled with ssl.
Also i'm not too sure what happens if ssl is not available (cannot test that now!),
maybe it just refuses to connect (desired behavior) or maybe it just connects w/o ssl,
i cannot tell.
hope this helps.
regards,
rene
On Thu, 23 Aug 2001 08:44:36 +0100
"Elizabeth Alderton" <[EMAIL PROTECTED]> wrote:
> Dear Jeremy, Gregor
>
> Thanks and sorry for not being more specific.
>
> First of all we use an ISP who runs a Unix server. They won't give us ssh
> without a dedicate server - too expensive for us.
> Then we use Windows clients (95, 98) not on a network.
>
> We transfer the data down a phone line from the server -> client and from
> client - > server.
>
> Thanks for suggesting cron - can you tell me what it is?
>
> Regards
>
> Elizabeth
> -----Original Message-----
> From: Jeremy Falcon <[EMAIL PROTECTED]>
> To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
> <[EMAIL PROTECTED]>
> Date: 22 August 2001 20:26
> Subject: Re: Encryption of Data
>
>
> >What do you mean by "bring data down?" Would this be over a network? If
> >so, what OS would the other machine be running? I'll assume it's Unix
> >because that's my favorite. Seeing that mysql prints to STDOUT you could
> >write a script to interface with MySQL, get the output, encrypt it, and
> then
> >send it across the line.
> >
> >Your application could send encrypted data to the server. For security
> >reasons I wouldn't suggest trying to pull off some Telnet/SSH schema to run
> >a script from your program. I'd use something like cron to run the script
> >at intervals to import what you uploaded. The script could then decrypt
> the
> >data and run mysql to send it whatever.
> >
> >If you are looking for a more specific solution, then be more detailed in
> >your question.
> >
> >Cheers,
> >
> >Jeremy
> >
> >----- Original Message -----
> >From: "Elizabeth Alderton" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Wednesday, August 22, 2001 10:00 AM
> >Subject: Encryption of Data
> >
> >
> >If I do a SELECT query to bring data down to a PC (this is being done
> >through Delphi) how can I encrypt the data so that it comes safely?
> >
> >Equally when doing UPDATE and INSERT in the other direction I would want to
> >encrypt the data.
> >
> >Can anyone help please?
> >
> >Regards
> >
> >Elizabeth
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
