Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Current Connection: Is there an indicator on the GUI of my connection type and if secure?

dbb's profile image dbb posted 4 years ago in Creating a connection Permalink

Hi there;

I've been trying the portable version for a few weeks now and I'm beginning to like it. (Coming from Portable LibreOffice Base using MySQL direct connect).

I can't find for the life of me on the software any indication that my connection is indeed SSH secure. I figure it is - being that if the SSH tunnel fields are completed and I connect w/o errors - it must be, but I have now way of verifying for sure (and I'm transferring private data). Poked around in all the GUI features but can't find anything that indicates "Connection Type Status".

If this feature is not available (hard to believe), PLEASE INTEGRATE THIS SUGGESTION (as Putty, WinSSCP, and many others show on the "status bar" & on "connection details")

1 attachment(s):
  • HeidySQL-Capture
dbb's profile image dbb posted 4 years ago Permalink

Addendum: I also find no SSH status from mouse-hovering over the bottom MySQL status icon

1 attachment(s):
  • HeidySQL-Capture2
ansgar's profile image ansgar posted 4 years ago Permalink

Yes, confirmed. Would it be sufficient if I add the network type of the current session in that mouse-over tooltip? For example "Network type: MySQL (SSH tunnel)"

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
dbb's profile image dbb posted 4 years ago Permalink

I would just add the (browser style) padlock icon just stating the SSH-# and let them click on it for a popup with more info (see my winSCP attachment).

I take on you're the developer?

1 attachment(s):
  • WinSCP-Capture
dbb's profile image dbb posted 4 years ago Permalink

..or tooltip as you suggested if easier.

Code modification/commit 67a30de from ansgarbecker, 4 years ago, revision 5090
Display network type in tooltip over server status panel. See http://www.heidisql.com/forum.php?t=21556
ansgar's profile image ansgar posted 4 years ago Permalink

Added to the tooltip in r5090.

Yes, I am the developer of Heidi.

dbb's profile image dbb posted 4 years ago Permalink

Just upgraded (portable upgraded smoothly in-place!) and I see that added note in the TT.

I think the paddock icon idea would be best when you have the time: shown locked for SSH or SSL, shown unlocked for un-encrypted plaintext to promote security.

Thank you for taking quick action;

Dov

PS: I may have found a bug. Being unrelated, will LYK in a fresh post.

Josem's profile image Josem posted 1 week ago Permalink

It would be nice to allow copying the connection information from the server status panel. The current window does not allow it.

Thanks in advance.

ansgar's profile image ansgar posted 1 week ago Permalink

You can click on the status bar panel with the server version to get such a dialog:

Description

Pressing Ctrl+C then will copy it in such a way:

[Window Title]
SQLserver: Information

[Content]
Host: .\SQLExpress
Network type: Microsoft SQL Server (named pipe)
Connected: Yes
Real Hostname: .\SQLExpress
Server OS: Windows 10 Pro 10.0 <X64> (Build 18362: ) (Hypervisor)
Server version: Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2
Connection port: 0
Compressed protocol: No
Unicode enabled: Yes
SSL enabled: No
Connection string: Provider=SQLOLEDB.1;Integrated Security=SSPI;Password=******;Persist Security Info=True;User ID=SA;Data Source=.\SQLExpress;Network Library=DBNMPNTW;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Application Name=HeidiSQL;Workstation ID=DESKTOP-P7OHKGH;Use Encryption for Data=False;Tag with column collation when possible=False

[OK]
Josem's profile image Josem posted 1 week ago Permalink

Oh! Excellent. If there was a small warning text saying it can be copied, it would be very good because the cursor is not visible in that window.

Thank you.

Please login to leave a reply, or register at first.