MySQL Bugs: #13887: When I click on Startup Variables, I got an exception: Access violation...

Bug #13887	When I click on Startup Variables, I got an exception: Access violation...
Submitted:	10 Oct 2005 5:30	Modified:	10 Aug 2006 15:05
Reporter:	Ryan Liu	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.1.3/1.1.5	OS:	Windows (Win XP Professional SP2, Chinese)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any
Tags:	Server Configuration

Description:
When I click on Startup Variables, I got a pop up window:

MySQL Administrator Exception 

Access violation at address 00A01504 in module 'libmysqladmin.dll',. Read of address 00000010 

How to repeat:
Open My SQL administrator 1.1.3 and click on Startup Variables in left tree

Same behaviour on a Windows Server 2003 SP1 English with patches against MySQL 4.0.24 with MySQL Administrator 1.1.3.

I cannot reproduce this problem with the current code so it might already be fixed (we worked in this regard). I checked against 4.1 and 5.0.11RC on a german Windows XP. Please try the new version, which will soon be released and reopen this bug entry if the issue is not resolved for you. Please also provide precise steps how to provoke the access violation then.

Mike

I have the exact problem since 1.1.1, updated to 1.1.3 but error is still showing up

Running:
Windows XP Pro Spanish 512MB Ram Intel 2.4Ghz HT
Mysql 4.0.25nt

Connecting via TCP/IP with client version 5.0.4 with root user

Problem persists with 1.1.4.

I'm running against MySQL 4.0.24.

Can you please specify where exactly the 4.0 server is installed (e.g. C:\Program Files\MySQL\MySQL Server 4.0) and where the .cnf file is located (e.g. C:\Windows).

Can you also upload the .cnf file here?

Thanks a lot.

I cannot add files because no user group has no such rights. From the bolow contents of my.ini install and data location should be clear.
Full contents of C:\Windows\my.ini:
--------
[mysqld]
basedir=C:/MySQL/
datadir=D:/mysql/data
bind-address=127.0.0.1
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
max_connections= 300
--------

The same problem:

Windows 2003 server Spanish
Pentium 4 3.4
1.0 Gb RAM

Mysql 4.0.20a
Mysql Client version 5.0.4

Clean install. Windows 2003 -> Mysql -> mysql administrator. Nothing else.

Port changed to 33331

I have the same problem with a new install of 1.1.4 using Server MySQL 4.1.12 with Client MySQL 5.0.11

The libmysqladmin.dll exists at c:\Program Files\MySQL\MySQL Administrator 1.1

This error occurs when I select Service Control or Startup Variables.

Running on P4 2.80GHz 256 MB RAM using Windows XP SP2.

I'm experiencing the same problem with 1.1.4

I have two server instances running as services:
4.0.18 and 5.0.15 on Win XP SP2 512M RAM
4.0.18 service entry:
    \mysqld-max-nt --defaults-file="C:\WINDOWS\my.ini" "MySql"
5.0.15 service entry:
    C:\db\mysql5\bin\mysqld-max-nt --defaults-file="C:\db\mysql5\my.ini"
"MySQL5"

If I have "Service Control" selected and switch between each server in "Installed Servers", or switch to "Server Logs" everything works fine.
If I select "Startup Variables" and then try to switch between each server in "Installed Servers", I get the following error message:

"Access violation at address 00405068 in module 'MySQLAdministrator.exe'. Read of address 00000016"

Had the same problem with Admin1.1.4 and Server5.0.15 on a XPsp2-machine. I solved it by adding the string '--defaults-file="<path-to-my.ini>"' to the ImagePath-value in the registry under HKLM\CurrentControlSet\Services/MySQL.

recommendation from Rainer ophoven solved the problem one time. But when I stopped the service to restart ist, it failes. Error Message: Can't connect to the server. After deletion of the registry entry the service could be restarted. But then the the Mysqladmin showed the old error with "access violation".

I am running server 5.0.15 with client 5.0.11 on Windows XP SP2 fully patched to date.  I too am experiencing this error message From Mysql Administrator 1.1.4 upon clicking on "Server settings" or "Startup variables".

The registry key listed above is not correct (for XP-SP2) you will need to find it at HKLM\SYSTEM\CurrentControlSet\Services\MySQL.  In order to update your other profiles (that may have these settings) you will also need to update the keys in 'ControlSet001', etc. as required by your configuration.

Further to my last comment, adding the --defaults-file=<pathtomy.ini> as specified will not allow the server to start in a timely fashion.  I do have it stored in a non-default location (ie: Not C:\mysql\my.ini).  Removing this parameter allows the server to start normally.

[ name withheld ] is right about the registry-ptah; the "system"-part slipped thru. other than that I don't have any problems any more.

I adopted the "defaults-file" in all Control Sets. Unfortunately these recommendations do not work for my host (XP Pro SP 2, fully patched, Celeron 2,4 / MySql Srv 5.0.15 / MySQL Admin 1.1.4). I still encounter either the "access violation" or that the server is not able to restart...

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

This bug now shows as being automatically suspended while many others than the original reporter have given feedback and show, as far as I can see, a strong willingness to give any feedback required. Please re-open and re-assign a reporter if that may help in eventually solving this issue.

Now I was able to repeat that behavior with 1.1.5

I had this problem too, and here is what fixed it:

The Config Filename may read my.cnf instead of my.ini. Start MySQL Administrator, go to Service Control, and select the Configure Service tab. In the Configuration File area, check the value of Config Filename.

Others have posted a Registry entry fix. Mke sure you use the correct syntax for the value of ImagePath. Now that my problem is fixed, my HKLM\SYSTEM\CurrentControlSet\Services\MySQL\ImagePath value read:

"D:\program files\MySQL\MySQL Server 5.0\bin\mysqld-debug" --defaults-file="D:\program files\MySQL\MySQL Server 5.0\my.ini" "MySQL"

(Include the quotes.)

I had the same problem when I installed MySQL Ver 5.0 without installer and used MySQL Administrator 1.1.8. I can't fix it by editing registry because it's not a Windows service. So I switched back to an older version of MySQL Administrator 1.0.21. It worked perfectly.

I have fixed a number of bugs with the service and config file management. This bug should also be addressed now and the fix will be included in the next version of MA that will be included in the MySQL GUI Tools for 5.0 release 2 bundle.

Please open a new bug if other problems with the config file still exist.