[surferjon2]

Hi,

Thank you, Ritesh for answering all my questions! I am out for the moment! The future for SQLyog looks bright! Can't wait! 😆

>> peterlaursen

I have read over your proposal on integrating proper support for managing views in SQLyog! Thank you for taking the time to write up such a document! I like the picture you created too showing the new features integrated into the object browser. What to DO with them? I have some ideas but I will detail them later.

As far as proposals go, I dont have any crafted up at the moment.

However, I would be happy to write something as to what I know about stored procedures/triggers and suggestions on how I think they could be efficiently integrated into a SQLyog GUI. Give me a little time to do some brainstorming and formatting, and I will post a link on the forum or start a new thread when I have completed it.

Cheers!

Jonathan

[surferjon2]

Nice! Thanks for the info and update, Ritesh! 😀

Interested to see the cross platform query builder and DB designer.

Can't wait for the second beta release of SQLyog Max!

I know this is like pulling teeth but I have two more questions…

Since the unix version of the mysql C api doesn't have ssl restrictions like its microsoft counterpart…

Will the cross platform release in 6 months be able to specify a CA cert/client certificate and key to [SQLyog Max BETA2] thus enabling a ssl connection to a mysql database in the unix environment?

AND

Will the cross platform release in 6 months have support for mysql 5.x including stored procedures/triggers (assuming 5.x is out of beta at that time)?

Cheers!

Jonathan

[surferjon2]

Hi,

Maybe 3rd time is the charm?

Quote:

Also, I wanted to check in and see how the development is coming along for the Unix/Linux version of sqlyog?! Whats the status, Ritesh?

Quote:

Finally could you please drop a hint as to how the development of Unix/Linux SQLyog is coming along? Still brainstorming? All UML'ed out? Coding away? Beta Testing? Whats up?

Is the information too secret to let out about how the development is coming along? You keep dodging the question.

Cheers!

Jonathan

[surferjon2]

A summary and opinion of US crypto export laws from qmail creator, Daniel Bernstein.

http://cr.yp.to/export/problem.html

Just a followup link. Interesting read! 🙂

[surferjon2]

Hi Ritesh,

Thanks for your reply. Bummer about the crypto export laws. It seems that others have had issues with ssl connections on the win32 platform…

http://bugs.mysql.com/bug.php?id=7575

This guy was failing to create a mysql-ssl connection using mysqlAdministrator.

Another poster 'Jorge' replied,

“You won't be able to run SSL in Windows OS, because MySQL doesn't support SSL

under Windows. I'm not sure what Navicat actually does, but I'm certain it

doesn't actually use MySQL's SSL options; these only work under non Win32

platforms.”

So what is it? I'm as confused as Jorge. This leads me to ask, Ritesh do you have any idea as to how Navicat implements the ssl connection in their program? Any ideas?

OAN: I noticed you already use plink as a means for working out backend ssh connections….I guess there is no similar means for backending ssl encryption. sure there is stunnel, but that again requires openssl libraries to be installed on the client…not to mention stunnel would have to be installed and configured on the server side as well (something that not all admins have permission to do)…in all not a feasible choice.

So how the hell did navicat do that? 😡

I have to tell you I have made a successful win32 mysql-ssl connection (using my own specified certificates/key) using Navicat (30-day trial only!) and have verified the connection is indeed encrypted (using mysql SHOW STATUS; and analyzing tcpdump output). A funny thing to note is that Navicat DOESNT support ssl/ssh connections on their linux client (wtf?), and no support for ssh connections on their mac client (doh! one can get around it with port forwarding in macSSH)! This all seems so bass ackwards to me!

For the win32 issue, maybe they hacked their own TLS tunnel with JSSE? ( http://java.sun.com/products/jsse/ ) and then linked it up to their app?

I dunno but the only thing is: using another gui tool other than SQLyog makes me cringe! 😀

Finally could you please drop a hint as to how the development of Unix/Linux SQLyog is coming along? Still brainstorming? All UML'ed out? Coding away? Beta Testing? Whats up?

Keep up the GOOD work, Ritesh!

[surferjon2]

Hi Peter,

I did a little checking up on the mysql c api and found this stuff…

Looking at the mysql c api functions overview in the mysql docs ( http://dev.mysql.com/doc/mysql/en/c-api-fu…n-overview.html )

There seem to be 3 functions that are of particular interest…

mysql_ssl_set() – http://dev.mysql.com/doc/mysql/en/mysql-ssl-set.html

mysql_real_connect() – http://dev.mysql.com/doc/mysql/en/mysql-re…al-connect.html

mysql_options() – http://dev.mysql.com/doc/mysql/en/mysql-options.html

These functions seem to provide access to the use of SSL to encrypt mysql transactions.

I'm confused…how did these api's “go away” ?

If these are indeed the apis to use, why did we not use them in the latest version of sqlyog?

Cheers!

Jonathan

[Author]

Posts