MySQL Bugs: #1864: mysqlcc fails if net access blocked by firewall

Bug #1864	mysqlcc fails if net access blocked by firewall
Submitted:	17 Nov 2003 11:22	Modified:	8 Dec 2003 16:27
Reporter:	[ name withheld ]	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQLCC	Severity:	S3 (Non-critical)
Version:	0.9.3	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
If PC connected to internet, mysqlcc wants to "phone home"
or something! But, stopped by firewall from accessing
the net, it fails (abends). However, if PC not connected
to the net, mysqlcc doesn't try to phone home and does
not fail. Therefore, since we're not allowing mysqlcc
to phone home or talk to anyone on the net, we must disconnect
our PC from the internet before running the program -- and
then it works fine.

P.S. change of subject: when editing the data rows of a table,
would like to be able to copy a row and 'paste-append' as is
featured in Microsoft Access. (When row is selected, Alt-Edit-Copy
and then Alt-Edit-PasteAppend) -- and row appears at end of screen
with cursor placed in first column, and data not yet saved because
it would probably have a duplicate key.) This is a very important
feature. 

P.P.S. Keep up good work. Thank you.

How to repeat:
see above

Suggested fix:
see above.

I do not believe that MyCC "phones home", I have experienced the issue, but it is usually from MyCC trying to access a server behind a firewall or a server that is not online.

This is maybe some OS configuration issue.

MySQLCC starts up and a window appears on the screen but then it attempts to access the server using the PC's internet connection IP address rather than the local address, 127.0.0.1. My firewall detects this and since MySQLCC is not authorized, the access is rejected. Then Windows XP brings up an error report prompt, send or don't send? The error report shows remote address xxx.xxx.xxx.xxx:3306 (where xxx.xxx.xxx.xxx is my dynamic IP address when logged onto my ISP), and local address service port 3222. Furthermore the dump shows mysqlcc.exe, mod name qt-mt312.dll, offset 001e1142.

The telling anomaly here is that, for example, WinMySQLAdmin.exe has no problem, whether the PC is connected to the internet or not. There is something different in MySQLCC where it doesn't go to the local MYSQL server at 127.0.0.1 -- and this is the default behavior, I haven't configured it at all, just setup and double-click on the icon.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html