Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Mikel King chortled: Hi Rich, Just so I understand you correctly; 1. Are you trying to use the replication features of MySql for this communication? Or 2. Are you talking on the client side application, like PHP, Java, Perl...? How about encrypting the data itself and skipping the whole channel issue? cheers, Mikel Sorry, Mike, been busy and haven't checked the messages. Just wanted to take records in MySQL and send to SQL Server over the net. Decided a vpn would be best implementation. Cheers @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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
TCP/IP Security for Remote Access of MySQL DBs...for newbie
Hi there. I have a need to reach into a remote database and write to their tables from my tables. Or have them reach into my tables and read from mine. Either way, data will travel over the net. I need that data secure and I don't know how I can make that secure. It's not a permissions thing, because that's straight forward...it's the communications I'm worried about. Can anybody comment on how remote security can be established between SQL databases? Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Hi Rich, Just so I understand you correctly; 1. Are you trying to use the replication features of MySql for this communication? Or 2. Are you talking on the client side application, like PHP, Java, Perl...? How about encrypting the data itself and skipping the whole channel issue? cheers, Mikel Rich Fortnum wrote: Hi there. I have a need to reach into a remote database and write to their tables from my tables. Or have them reach into my tables and read from mine. Either way, data will travel over the net. I need that data secure and I don't know how I can make that secure. It's not a permissions thing, because that's straight forward...it's the communications I'm worried about. Can anybody comment on how remote security can be established between SQL databases? Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Mikel King chortled: Hi Rich, Hey there. Thanks for the response. Just so I understand you correctly; 1. Are you trying to use the replication features of MySql for this communication? Nope. Or 2. Are you talking on the client side application, like PHP, Java, Perl...? How about encrypting the data itself and skipping the whole channel issue? I will have local tables or local processing on my server, that will have to write to a remote table. Where can I read up on encryption? They will have to translate on their end, but they are on a M$ SQL Server. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
04.02.02 15:11:30, Rich Fortnum [EMAIL PROTECTED] wrote: Hi there. I have a need to reach into a remote database and write to their tables from my tables. Or have them reach into my tables and read from mine. Either way, data will travel over the net. I need that data secure and I don't know how I can make that secure. It's not a permissions thing, because that's straight forward...it's the communications I'm worried about. Can anybody comment on how remote security can be established between SQL databases? How about using a VPN (virtual private network) ? regards Andreas sql,select,mysql - 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
On Mon, 4 Feb 2002 at 18:06:34 +0100, Andreas Schoelver wrote: 04.02.02 15:11:30, Rich Fortnum [EMAIL PROTECTED] wrote: Hi there. I have a need to reach into a remote database and write to their tables from my tables. Or have them reach into my tables and read from mine. Either way, data will travel over the net. I need that data secure and I don't know how I can make that secure. It's not a permissions thing, because that's straight forward...it's the communications I'm worried about. Can anybody comment on how remote security can be established between SQL databases? How about using a VPN (virtual private network) ? (sorry; missed the original post) If you have admin access to both machines, then how about using stunnel URL:http://www.stunnel.org/ to set up an SSL-encrypted connection between both machines on the ports on which mysqld communicates? There's an example for MySQL at URL:http://www.stunnel.org/examples/mysql.html Cheers! -- Marcus - 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Andreas Schoelver chortled: How about using a VPN (virtual private network) ? regards Andreas sql,select,mysql I want to minimize the network structure on their part because they will have a minimal DSL system as they are on the outskirts of town. As well, I don't want the bulk of the cost for them going to infastructure. There's got to be a way of throwing SQL records around without creating a whole new layer. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Marcus Collins chortled: (sorry; missed the original post) If you have admin access to both machines, then how about using stunnel URL:http://www.stunnel.org/ to set up an SSL-encrypted connection between both machines on the ports on which mysqld communicates? There's an example for MySQL at URL:http://www.stunnel.org/examples/mysql.html Cheers! -- Marcus Ah, very good. I'll take a look. I won't have admin on the far machine, but will be in touch with their admin there. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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