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:Microsoft Windows (Windows XP)
Assigned to: CPU Architecture:Any

[17 Nov 2003 11:22] [ name withheld ]
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.
[17 Nov 2003 11:36] Mike Hillyer
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.
[21 Nov 2003 11:52] Miguel Solorzano
This is maybe some OS configuration issue.
[21 Nov 2003 16:14] [ name withheld ]
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.
[8 Dec 2003 16:27] Jorge del Conde
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