I'm using zeosdbo-5.3.0-beta5 in my project.
I would use SSL connection to MySQL 4.0 server.
So, I've patched zeosdbo with directmysql objects. But I still don't know how to make zeos to work with directmysql's SSL support.
How can I use it with my zeos tables and queries?
Thanx,
Peter
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You can do it by enabling the {.$Define HAVE_SSL}
directive (remove the . in front of it) .. then you need to change zeos components (eg database) to publish the properties required for ssl (ssl_key,ssl_cert,ssl_ca,ssl_capath,ssl_cipher) and eventually you will have to request ssl for the direct-mysql objects (UseSSL set to true before connect)
After that everything is just normal (no need to change anything else in queryes and so on)
Let me know how you got on with it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I've added the patch again (As I did it for the first time and as you wrote) . But still my TZMysqlDatabase object does not have any ssl like property. How do I create a Database Object using SSL? If anybody has a demo project please send me to wee-lee@freemail.hu.
If anyvody can write the exact openssl commands for genereating all required keys, please let me know.
Many thanx again,
Peter
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Unfortunatelly i do not have time to make the necessary changes to incorporate the SSL in Zeos. I actually still wait for an answer from them whenever i could join their development side so this direct stuff could be integrated in their package, but in the mean time as you probably noticed i didnt even got a chance to update the freepascal and the virtual pascal version.
As about the openssl command you could read the mysql site for details on generating them: http://www.mysql.com/doc/S/e/Secure_basics.html http://www.mysql.com/doc/S/e/Secure_GRANT.html
also i would recommend you to read this: http://www.octaldream.com/~scottm/talks/ssl/opensslca.html
Regards,
Cristian Nicola
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
as I understood there is no possibility to use zeodbo by this time. I think this is a very important feature which would great if it would have implemented.
Thanx.
Kind regards,
Peter
PS: I'm using Delphi 6 Professional
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well .. it is not my package .. so i guess you should ask for it in their home site .. As i personally liked their components i did the patch for it to work without libmysql.dll. As of now i will create another patch which actually adds a new compiler directive so there won't be any changes required if you want or not to use the library
( eg {$Define USEDLL} and your exe will use the dll and disableing this will include direct-mysql lib in your code - so no dll needed).
As about using ssl you can use it from the direct-mysql objects without any problems (at least as far as i know) and to enable this in zeos should be fairly easy : you just map some properties from the client to zeos database connection :
eg add this in the database connection
property Use_SSL:boolean read fhandle.use_ssl write fhandle.write_ssl;
Then follow the same rule adding this line until you get to TMysqlClient ..
Should not take more than half an hour to patch it.
I am currently in the office and i can't make these changes, but if there is an interest for it i could do it over the weekend ...
ps: what you need to "propagate" is:
property UseSSL : Boolean ;
property SSLKey : string ;
property SSLCert : string ;
property SSLCa : string ;
property SSLCaPath : string ;
property SSLCipher : string ;
All of them being properties of tmysqlclient...
Regards and good luck,
Cristian Nicola
ps: don't forget to enable HAVE_SSL :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm quite new to delphi, but I've tried to patch it (during this weekend) without success.
As you wrote if there is an interest for it...
So, if you have time and if you feel like doing it it will be great.
Thanx,
Peter
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry for late answer but i've been very busy with some other things.. i've finally got a chance this morning to create a sample "patch" for using the SSL, but unfortunatelly i can't test it as i don't have a secure mysql around.
I hope you will get a chance to download/use it and please do let us know if any problems.
Regards,
Cristian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2002-08-09
I have patched DirectSQL with ZEOS, but I didn't quite follow the explaination of how to use SSL with mysql 4 with DirectSQL.
Maybe you can make something like a walktrough with every step of making a SSL connection explained?
Thanks anyway, i really like not having to use the dll, but it would be suberb if i can use SSL :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I will look into creating a tutorial for SSL+ mysql, but it won't be very soon. I've been very ill during the last few weeks and i'm still recovering so it may be delayed a bit (plus i'm very keen to have TSwfObjects release as soon as possible).
Regards,
Cristian Nicola
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi everyone,
I'm using zeosdbo-5.3.0-beta5 in my project.
I would use SSL connection to MySQL 4.0 server.
So, I've patched zeosdbo with directmysql objects. But I still don't know how to make zeos to work with directmysql's SSL support.
How can I use it with my zeos tables and queries?
Thanx,
Peter
You can do it by enabling the {.$Define HAVE_SSL}
directive (remove the . in front of it) .. then you need to change zeos components (eg database) to publish the properties required for ssl (ssl_key,ssl_cert,ssl_ca,ssl_capath,ssl_cipher) and eventually you will have to request ssl for the direct-mysql objects (UseSSL set to true before connect)
After that everything is just normal (no need to change anything else in queryes and so on)
Let me know how you got on with it.
Hi,
I've added the patch again (As I did it for the first time and as you wrote) . But still my TZMysqlDatabase object does not have any ssl like property. How do I create a Database Object using SSL? If anybody has a demo project please send me to wee-lee@freemail.hu.
If anyvody can write the exact openssl commands for genereating all required keys, please let me know.
Many thanx again,
Peter
Unfortunatelly i do not have time to make the necessary changes to incorporate the SSL in Zeos. I actually still wait for an answer from them whenever i could join their development side so this direct stuff could be integrated in their package, but in the mean time as you probably noticed i didnt even got a chance to update the freepascal and the virtual pascal version.
As about the openssl command you could read the mysql site for details on generating them:
http://www.mysql.com/doc/S/e/Secure_basics.html
http://www.mysql.com/doc/S/e/Secure_GRANT.html
also i would recommend you to read this:
http://www.octaldream.com/~scottm/talks/ssl/opensslca.html
Regards,
Cristian Nicola
Dear Cristian,
as I understood there is no possibility to use zeodbo by this time. I think this is a very important feature which would great if it would have implemented.
Thanx.
Kind regards,
Peter
PS: I'm using Delphi 6 Professional
Well .. it is not my package .. so i guess you should ask for it in their home site .. As i personally liked their components i did the patch for it to work without libmysql.dll. As of now i will create another patch which actually adds a new compiler directive so there won't be any changes required if you want or not to use the library
( eg {$Define USEDLL} and your exe will use the dll and disableing this will include direct-mysql lib in your code - so no dll needed).
As about using ssl you can use it from the direct-mysql objects without any problems (at least as far as i know) and to enable this in zeos should be fairly easy : you just map some properties from the client to zeos database connection :
eg add this in the database connection
property Use_SSL:boolean read fhandle.use_ssl write fhandle.write_ssl;
Then follow the same rule adding this line until you get to TMysqlClient ..
Should not take more than half an hour to patch it.
I am currently in the office and i can't make these changes, but if there is an interest for it i could do it over the weekend ...
ps: what you need to "propagate" is:
property UseSSL : Boolean ;
property SSLKey : string ;
property SSLCert : string ;
property SSLCa : string ;
property SSLCaPath : string ;
property SSLCipher : string ;
All of them being properties of tmysqlclient...
Regards and good luck,
Cristian Nicola
ps: don't forget to enable HAVE_SSL :)
Hi Cristian,
I'm quite new to delphi, but I've tried to patch it (during this weekend) without success.
As you wrote if there is an interest for it...
So, if you have time and if you feel like doing it it will be great.
Thanx,
Peter
Sorry for late answer but i've been very busy with some other things.. i've finally got a chance this morning to create a sample "patch" for using the SSL, but unfortunatelly i can't test it as i don't have a secure mysql around.
I hope you will get a chance to download/use it and please do let us know if any problems.
Regards,
Cristian
I have patched DirectSQL with ZEOS, but I didn't quite follow the explaination of how to use SSL with mysql 4 with DirectSQL.
Maybe you can make something like a walktrough with every step of making a SSL connection explained?
Thanks anyway, i really like not having to use the dll, but it would be suberb if i can use SSL :)
I will look into creating a tutorial for SSL+ mysql, but it won't be very soon. I've been very ill during the last few weeks and i'm still recovering so it may be delayed a bit (plus i'm very keen to have TSwfObjects release as soon as possible).
Regards,
Cristian Nicola