Re: Safe DB Distribution

2007-01-30 Thread Ales Zoulek
On 1/30/07, Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Jan 29), Suhas Pharkute said: Ok, I will explain it again, I need a way so that if some body gets the DB files (.MYD and .MYI) from my distribution, they can put it in their DB engine and can read my DB. I would like to

Re: Safe DB Distribution

2007-01-30 Thread Felix Geerinckx
[EMAIL PROTECTED] (Suhas Pharkute) wrote in news:[EMAIL PROTECTED]: I want to distribute the MySQL DB to different user with an PHP web app. Make sure you have read and understood the MySQL licensing policy, if your app is not open source (as it seems to be). My biggest problem is MySQL

Re: Safe DB Distribution

2007-01-30 Thread peter lovatt
Hi You probably cant make it 100% secure, because php is not a fully compiled language, and as such an expert techie could probably add extra code to your app that wouild allow access to the database, BUT you can get pretty close. You will need to encrypt everything in the database using MySql

Re: Safe DB Distribution

2007-01-30 Thread Dotan Cohen
On 30/01/07, peter lovatt [EMAIL PROTECTED] wrote: Hi You probably cant make it 100% secure, because php is not a fully compiled language, and as such an expert techie could probably add extra code to your app that wouild allow access to the database, BUT you can get pretty close. You will

Re: Safe DB Distribution

2007-01-30 Thread Suhas Pharkute
Thank you everybody for your replies. Seems like I got an answer as no. Thank you again, Suhas On 1/30/07, Dotan Cohen [EMAIL PROTECTED] wrote: On 30/01/07, peter lovatt [EMAIL PROTECTED] wrote: Hi You probably cant make it 100% secure, because php is not a fully compiled language, and

Re: Safe DB Distribution

2007-01-30 Thread mizioumt
Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tue, 30 Jan 2007 4:08 AM Subject: Re: Safe DB Distribution [EMAIL PROTECTED] (Suhas Pharkute) wrote in news:[EMAIL PROTECTED]: I want to distribute the MySQL DB to different user with an PHP web app. Make sure you have read

Re: Safe DB Distribution

2007-01-30 Thread Gerald L. Clark
[EMAIL PROTECTED] wrote: Something like distributing files with encrypted data in most columns can be done, with the encryption key being a combination of some hardware-related stuff such as MAC address that the user will provide to you, and the key you generate and provide to the user. Of

Re: Safe DB Distribution

2007-01-30 Thread Felix Geerinckx
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED] R04.sysops.aol.com: Something like distributing files with encrypted data in most columns can be done I think the OP is more concerned with protecting his datamodel, and this cannot be done in my opinion. -- felix -- MySQL General Mailing

Re: Safe DB Distribution

2007-01-30 Thread mizioumt
Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tue, 30 Jan 2007 1:44 PM Subject: Re: Safe DB Distribution [EMAIL PROTECTED] wrote: Something like distributing files with encrypted data in most columns can be done, with the encryption key

Re: Safe DB Distribution

2007-01-30 Thread mizioumt
@lists.mysql.com Sent: Tue, 30 Jan 2007 1:52 PM Subject: Re: Safe DB Distribution [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED] R04.sysops.aol.com: Something like distributing files with encrypted data in most columns can be done I think the OP is more concerned with protecting his datamodel

Re: Safe DB Distribution

2007-01-30 Thread mos
You will not be able to search on encrypted fields. Sure you can. MySQL will also be able to use the index provided you are using an = when searching. But you can't use or on an encrypted field and still expect it to use an index. I've found talking to MySQL developers about the need to

Safe DB Distribution

2007-01-29 Thread Suhas Pharkute
HI, I want to distribute the MySQL DB to different user with an PHP web app. My biggest problem is MySQL data files. Is there anyway by which I can configure the MySQL so that only PHP script can read it and if you happen to copy the Data files and try to use it, that will be useless. I know,

Re: Safe DB Distribution

2007-01-29 Thread Ales Zoulek
@lists.mysql.com Date: Mon, 29 Jan 2007 11:48:27 -0700 Subject: Safe DB Distribution HI, I want to distribute the MySQL DB to different user with an PHP web app. My biggest problem is MySQL data files. Is there anyway by which I can configure the MySQL so that only PHP script can read it and if you

Re: Safe DB Distribution

2007-01-29 Thread Suhas Pharkute
and filesystem rights, so that only MySQL server can read them. Ales. -- Forwarded message -- From: Suhas Pharkute [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Mon, 29 Jan 2007 11:48:27 -0700 Subject: Safe DB Distribution HI, I want to distribute the MySQL DB to different user

RE: Safe DB Distribution

2007-01-29 Thread Logan, David (SST - Adelaide)
--- -Original Message- From: Suhas Pharkute [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 January 2007 1:55 PM To: Ales Zoulek Cc: mysql@lists.mysql.com Subject: Re: Safe DB Distribution Yep, I do understand that, but when I give DB

Re: Safe DB Distribution

2007-01-29 Thread Suhas Pharkute
--- -Original Message- From: Suhas Pharkute [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 January 2007 1:55 PM To: Ales Zoulek Cc: mysql@lists.mysql.com Subject: Re: Safe DB Distribution Yep, I do understand that, but when I give DB to someone, I do not want

Re: Safe DB Distribution

2007-01-29 Thread Suhas Pharkute
--- -Original Message- From: Suhas Pharkute [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 January 2007 1:55 PM To: Ales Zoulek Cc: mysql@lists.mysql.com Subject: Re: Safe DB Distribution Yep, I do understand that, but when I give DB to someone, I do not want

Re: Safe DB Distribution

2007-01-29 Thread Suhas Pharkute
Ok, I will explain it again, I need a way so that if some body gets the DB files (.MYD and .MYI) from my distribution, they can put it in their DB engine and can read my DB. I would like to STOP this stealing. Is there any way? Thanks Suhas

Re: Safe DB Distribution

2007-01-29 Thread Dan Nelson
In the last episode (Jan 29), Suhas Pharkute said: Ok, I will explain it again, I need a way so that if some body gets the DB files (.MYD and .MYI) from my distribution, they can put it in their DB engine and can read my DB. I would like to STOP this stealing. Is there any way? If you