List databases problematic on 4.1 in direct mode

List databases problematic on 4.1 in direct mode

Postby ramajana » Thu 25 Nov 2004 19:47

I drop TMyConnection on form. Now I would like simply to see all databases on server. I have two mysql servers (4.0 on Linux/network and 4.1 on Windows/localhost).
I have granted all on testdb.* to my_user@localhost identified by 'pwd';
Properties are set like this: username=my_user, password=pwd, server='', direct=true.
Connect fails with 'Access denied for user...'
Setting property direct to false.
Connect succeeds and I am able to select database from drop-down list box.
At my 4.0 Linux machine works with direct mode, too.
ramajana
 
Posts: 10
Joined: Tue 23 Nov 2004 17:22

Re: List databases problematic on 4.1 in direct mode

Postby Ikar » Fri 26 Nov 2004 08:53

Thank you for information.
It's known problem and we've already fixed it.
Please download the last MyDAC version (3.30.1.13).
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Not fixed in 3.30.1.13

Postby ramajana » Fri 26 Nov 2004 09:03

Ikar, I am using 3.30.1.13 and this bug is happening.
Switching direct on/off is different in fail/success of connection.
ramajana
 
Posts: 10
Joined: Tue 23 Nov 2004 17:22

Post subject: List databases problematic on 4.1 in direct mode

Postby Ikar » Fri 26 Nov 2004 09:38

We couldn't reproduce the problem.
Please send us TMyConnection definition and script to create my_user
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Reproducing

Postby ramajana » Fri 26 Nov 2004 11:22

C:\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 91 to server version: 4.1.7-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| infiko |
| mysql |
| t |
| test |
| voda |
+----------+
5 rows in set (0.00 sec)

mysql> grant all on t.* to testuser@localhost identified by 'testpwd';
Query OK, 0 rows affected (0.08 sec)

----------------------------------

object MyConnection1: TMyConnection
Options.Direct = False
Username = 'testuser'
Password = 'testpwd'
Left = 112
Top = 32
end

Database dropdown shows t, test.
Connecting using Connected property works, too.

object MyConnection1: TMyConnection
Username = 'testuser'
Password = 'testpwd'
Left = 112
Top = 32
end

Database dropdown raises exception "Access denied for user 'testuser@localhost' (using password: YES)"
Connecting using Connected property switching raises the same exception.

object MyConnection1: TMyConnection
Database = 't'
Options.Direct = False
Username = 'testuser'
Password = 'testpwd'
LoginPrompt = False
Left = 112
Top = 32
end

Database dropdown shows t, test.
Connecting using Connected property works, too.

object MyConnection1: TMyConnection
Database = 't'
Username = 'testuser'
Password = 'testpwd'
LoginPrompt = False
Left = 112
Top = 32
end

Database dropdown raises exception "Access denied for user 'testuser@localhost' (using password: YES)"
Connecting using Connected works, and, if I connect first, then database dropdown works fine and shows t, test.
ramajana
 
Posts: 10
Joined: Tue 23 Nov 2004 17:22

Re: Reproducing

Postby Ikar » Fri 26 Nov 2004 15:42

Thank you for your sample. It does help us very much.
We reproduced your problem and fixed it. This fix will be included in the next MyDAC build.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Great

Postby ramajana » Fri 26 Nov 2004 15:48

Thanks, glad to help. When will it be available?
ramajana
 
Posts: 10
Joined: Tue 23 Nov 2004 17:22

Re: List databases problematic on 4.1 in direct mode

Postby viggo » Fri 26 Nov 2004 16:18

Ikar wrote:Thank you for information.
It's known problem and we've already fixed it.
Please download the last MyDAC version (3.30.1.13).

I have read your answer , and therefore I imidiately downloaded (3.30.1.13), but it still does not work. If I remove user and password from connectiondialog, I am alowed to see the databasenames in the combobox, also if I choose "root" without password, but not if I use my own username and password. I use the trialversion, but if this will work, I intend to buy the Mydac-component.

mvh
Viggo Denmark
viggo
 

Re: Great

Postby Ikar » Mon 29 Nov 2004 12:01

In about three weeks.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components