Re: MySQL Delphi
Hi Well, I've no experience with ADO's, but I'm using Zeos components and I've not had any () problems. Here's the url http://www.zeoslib.org/. They're free and they don't use ODBC, but rather libmysql.dll which was described to me by my ISP as 'more secure' - whatever that means! They have a mailing list that you can join too, and the Delphi forums know quite a bit about Zeos as well. So support is good. Regards Elizabeth -Original Message- From: Ales Vaupotic [EMAIL PROTECTED] To: MySQL list (E-mail) [EMAIL PROTECTED] Date: 02 September 2001 09:49 Subject: MySQL Delphi Hello, I've got a problem with MySQL 3.23.41 on Solaris 8 and Delphi 5 Ent. on Windows 98. I installed the latest MyODBC a week ago and am using ADO components to connect to the server. The connection itself works but when I open the field editor of a table, char(50) is interpreted in Delphi as string with length of 12 or 16 characters. It happens for all char fields, lengths are from 1 to 20 chars (randomly). Should I try another set of components or can this be fixed? TIA, Ales Vaupotic Amanita Software - 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
Re: Data Encryption
Dear Chris I'm sorry to be really ignorant, but what is VPN? Any suggestions are welcome! Regards Elizabet -Original Message- From: Chris Lathem [EMAIL PROTECTED] To: Elizabeth Alderton [EMAIL PROTECTED] Date: 22 August 2001 21:21 Subject: Re: Data Encryption What about talking to the server through a VPN? If you have an extra IP address you can tunnel in to do this securely.Just a suggestion. Chris - Original Message - From: Elizabeth Alderton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 11:35 AM Subject: Data Encryption 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? We can't afford to use ssh - we would have to have a dedicated server. 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
Re: Data Encryption
Dear Chuck Your idea has given me an idea. How about: When we actually collect the data, we encrypt it so that it is actually held in mysql in an encrypted form? Then it can speed up and down the phone lines in the 'raw' so to speak, but it's still in code so no one can get it anyway? We wouldn't need SSH or SSL then would we? Or is that too simplistic? Regards Elizabeth -Original Message- From: Charles Williams [EMAIL PROTECTED] To: Elizabeth Alderton [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: 22 August 2001 21:30 Subject: Re: Data Encryption I use a random key generating SHA-1 js module for all my encryption for passwords. You could do something the same using a fixed key system so that once it's on the server you can decrypt it. However, I haven't tried it yet with SHA-1 so don't know how difficult or sane it would be to try. chuck - Original Message - From: Elizabeth Alderton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 6:11 PM Subject: Data Encryption 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
Re: Encryption of Data
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
Re: libmysql - secure connection
Hi thanks I'm glad there's hope! This is proving to be extremely difficult! Regards Elizabeth -Original Message- From: Jeremy Zawodny [EMAIL PROTECTED] To: Elizabeth Alderton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: 21 August 2001 23:31 Subject: Re: libmysql - secure connection On Mon, Aug 20, 2001 at 05:16:04PM +0100, Elizabeth Alderton wrote: If I'm using libmysql to connect from Delphi to mysql - does it automatically provide a secure connection then? It does not. To get a secure connection, you'll want to tunnel is thru stunnel, ssh, or something similar. There are details in the mailing list archives on these. MySQL 4.0 will have built in SSL support, though, so there's hope. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 4 days, processed 56,830,759 queries (141/sec. avg) - 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
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
Data Encryption
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
Data Encryption
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? We can't afford to use ssh - we would have to have a dedicated server. 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
Data Security
Hi everyone Does anyone know if a secure socket is automatically established when: 1.The server running my-sql (a unix box) is secure and 2.You use Delphi, via Zeus components, to connect to it and upload/download data ? Thanks everyone! Regards Elizabeth
libmysql - secure connection
If I'm using libmysql to connect from Delphi to mysql - does it automatically provide a secure connection then? Regards Elizabeth
Delphi and Mysql - Data Security
I am using Delphi to connect to and update data on a mysql server. Is there any problem with data security? Will it automatically establish a secure connection? Thanks everyone for all your help. Elizabeth
UPDATE QUERY
Can anyone give me a pointer as to whether an update query, similar to below, is possible - and if so how? (I've put it in caps since that's the way it is typed in mysql) UPDATE SUBCATEGORY SET CATID=CATEGORY.CATID WHERE SUBCATEGORY.ORGID=CATEGORY.ORGID SUBCATEGORY and CATEGORY are table names Thanks in advance! Regards Elizabeth