access denied mysql exception

access denied mysql exception

Postby joelr » Fri 04 Apr 2014 17:58

I am getting the following exception from a .NET C# app that has been working for years. It is occurring on all 3 installations I tested today despite the fact that the underlying DB is fully accessible remotely via MysqlWorkbench with the connection parameters being used here.

This is an old version of a (possibly discontinued?) corelab mysql DLL.

CoreLab.MySql.MySqlException was unhandled
Message=Access denied for user ''@'71.77.26.52' (using password: NO)
Source=CoreLab.MySql
Code=1045
StackTrace:
at CoreLab.MySql.MySqlConnection.Open()
at Linscot.JdbcTemplate.query(String sql, RowCallbackHandler callbackHandler) in Z:\Projects\Linscot-original\JdbcTemplate.cs:line 45
at Linscot.DataBrowser.getCompanyList() in Z:\Projects\Linscot-original\DataBrowser.cs:line 1781
at Linscot.DataBrowser.setCompanyList() in Z:\Projects\Linscot-original\DataBrowser.cs:line 1787
at Linscot.DataBrowser..ctor() in Z:\Projects\Linscot-original\DataBrowser.cs:line 197
at Linscot.MainForm.openViewer(Object sender, EventArgs e) in Z:\Projects\Linscot-original\MainForm.cs:line 289
. . .

I'm pretty baffled at the moment as to how to best proceed with this.
Any clues, thoughts, etc are appreciated. I have full admin access to the DB, which is hosted at godaddy.

Thanks,
joel
joelr
 
Posts: 3
Joined: Fri 04 Apr 2014 17:48

Re: access denied mysql exception

Postby Pinturiccio » Mon 07 Apr 2014 16:58

joelr wrote:Access denied for user ''@'71.77.26.52' (using password: NO)

According to the exception message, you have not specified login and password for the connection that you try to open. Please check the connection string and make sure that the UserId property is specified.
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Re: access denied mysql exception

Postby joelr » Mon 07 Apr 2014 18:25

actually, the connection is correct, has been the same for years then stopped working for no reason.
I checked it with debugger - connection has right parameters AND wireshark shows wrong ones going out.
This narrows it down to the corelab DLL.

code has not changed in years.
joelr
 
Posts: 3
Joined: Fri 04 Apr 2014 17:48

Re: access denied mysql exception

Postby Pinturiccio » Tue 08 Apr 2014 15:09

Please try your application with the latest version of dotConnect for MySQL. According to your email your subscription has expired. You can download Trial version of dotConnect for MySQL from our site http://www.devart.com/dotconnect/mysql/download.html and try if the issue is reproduced with the latest version of dotConnect for MySQL.

Please note that after upgrading MySQLDirect .NET to dotConnect for MySQL, you will have to make certain changes to your project. For details please refer to http://www.devart.com/dotconnect/mysql/docs/FAQ.html#q19
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Re: access denied mysql exception

Postby joelr » Tue 08 Apr 2014 15:45

I had done this last night after realizing that I would not be getting any help in fixing the existing DLL with a freshly downloaded one from the archived product site.

I guessed correctly that dotConnect was the 'evolved' version of my coreLab.MySql DLL - I was able to get this program working again by making changes to the code to allow for the name changes and to allow for the additional reference assembly that is now required.

I guess you folks succeeded in squeezing another $100 from me - the irony is that I'm less than two months away from releasing the web application version of my program that works with the Play! framework and all open source code to access the mysql DB. Congratulations on that! After 10 years of use, your library is paying you dividends that might have escaped had I completed this project sooner (before the time bomb in your corelab product disabled it for me).

:D :( :shock: :roll: 8)
joelr
 
Posts: 3
Joined: Fri 04 Apr 2014 17:48

Re: access denied mysql exception

Postby Pinturiccio » Fri 11 Apr 2014 12:53

The information you have provided is not enough to reproduce the issue. Probably the MySQL server was updated or other environment parameters were changed.
Please describe the issue in more details and tell us the following:
1. MySQL database version;
2. CoreLab.MySql.dll version;
3. Visual Studio version;
4. .NET Framework with which you build the application.
5. Send us a small test project with the corresponding DDL/DML scripts.
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL