View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000413 | Hopper | MySQL | public | 2012-07-24 11:20 | 2012-08-01 16:08 |
Reporter | Jens Saathoff | Assigned To | Martijn Tonies | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.0.2 | ||||
Fixed in Version | 1.0.3 | ||||
Summary | 0000413: Hopper does not show Stored Procedures and Functions in tree on servers with no access to mysql.procs | ||||
Description | Hopper does not show Stored Procedures and Functions in tree on remote-server, but on localhost. Tried another product "dbForge" and it works, so i think they are no problems with my MySQL-Server. The permissions for the remote user are in mysql/db-Table and the user is allowed to create and modify procedures and functions in the database. | ||||
Steps To Reproduce | 1.Create a user on remote-server 2.Set permissions for a database(created user) 3.Connect 4.No stored procedures and functions are shown | ||||
Tags | No tags attached. | ||||
DBMS Version | |||||
related to | 0000414 | closed | Martijn Tonies | Database Workbench v4 | No procedures/functions listed in the treeview if there was no access to mysql.procs, or no parameters |
|
|
|
|
|
I test this on a remote server as well, what are the exact permissions? |
|
Jens, can you make sure the user has SELECT privileges to INFORMATION_SCHEMA? |
|
The user and database comibination is not set in table "db". The database information_schema, the user privilege for this user is "USAGE". It's a standard plesk-setup as you would find it in the wild... |
|
And...the setup does work with dbForge...so it should also work without refering information_schema... or not? |
|
Well, there's two ways to get Stored Procedure & Function info, only one way to get Trigger info. The first are available in the "mysql" database, but also in "information_schema". Triggers are only available in "information_schema". A user should have access to at least one of those. Are you using the same user with dbForge? |
|
Yes, same user. |
|
2nd way is to retrieve functions and procs from mysql-database, table "proc", right? |
|
I can create a trigger, modify the trigger. I can also create procs und funcs with the user. |
|
via table proc, correct. It first uses mysql.proc, then tries information_schema. The user should have access to at least one. Can you try and see if you can select from either of those, with the user? |
|
I logged on via ssh and tried directly via MySQL-Console. With the user i can select from information_schema.ROUTINES and information_schema.TRIGGERS. No empty set. I can't select from any table of the mysql-database (access denied). The configuration of the server is nothing special, just like a reseller for webspace would configure it. If you are interested i could setup a test-database and user for you. Hope it helps a bit... |
|
Hello Jens, If you can set up a test database, that would certainly help. |
|
Of course! You got mail. |
|
no access to mysql.procs, the fallback to information_schema failed. |
|
That being said, only MySQL 5.5 and up shows the full info in INFORMATION_SCHEMA, so 5 and 5.1 won't be supported for this. |
|
So...you won't fix it? |
|
If not, you should modify the information on your website: http://upscene.com/products.hopper.index.php Available Editions Hopper is available for InterBase, Firebird and MySQL. Firebird - supporting Firebird, including the new features of Firebird 3 once released. InterBase - supporting InterBase from version 6 onward. * MySQL - supporting MySQL from version 5 onward. * |
|
I'll fix it for MySQL 5.5, no problem. Earlier versions seem harder, see: http://dev.mysql.com/doc/refman/5.1/en/stored-routines-metadata.html I guess I'll have to resort to parsing to get parameter info. |
|
5.1.63-0+squeeze1 is installed on the server you're testing on. |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-07-24 11:20 | Jens Saathoff | New Issue | |
2012-07-24 11:20 | Jens Saathoff | File Added: hopper1.JPG | |
2012-07-24 11:20 | Jens Saathoff | File Added: dbforge1.JPG | |
2012-07-24 12:24 | Martijn Tonies | Note Added: 0000094 | |
2012-07-24 12:24 | Martijn Tonies | Status | new => feedback |
2012-07-24 13:01 | Martijn Tonies | Note Added: 0000096 | |
2012-07-24 13:11 | Jens Saathoff | Note Added: 0000097 | |
2012-07-24 13:11 | Jens Saathoff | Status | feedback => new |
2012-07-24 13:13 | Jens Saathoff | Note Added: 0000098 | |
2012-07-24 13:19 | Martijn Tonies | Note Added: 0000099 | |
2012-07-24 13:39 | Jens Saathoff | Note Added: 0000100 | |
2012-07-24 13:43 | Jens Saathoff | Note Added: 0000101 | |
2012-07-24 13:45 | Jens Saathoff | Note Added: 0000102 | |
2012-07-24 14:57 | Martijn Tonies | Note Added: 0000103 | |
2012-07-24 15:25 | Jens Saathoff | Note Added: 0000104 | |
2012-07-25 08:36 | Martijn Tonies | Note Added: 0000105 | |
2012-07-25 12:05 | Jens Saathoff | Note Added: 0000106 | |
2012-07-25 12:35 | Martijn Tonies | Assigned To | => Martijn Tonies |
2012-07-25 12:35 | Martijn Tonies | Status | new => assigned |
2012-07-25 12:35 | Martijn Tonies | Relationship added | related to 0000414 |
2012-07-25 12:36 | Martijn Tonies | Note Added: 0000107 | |
2012-07-25 12:36 | Martijn Tonies | Summary | Hopper does not show Stored Procedures and Functions in tree on remote-server => Hopper does not show Stored Procedures and Functions in tree on servers with no access to mysql.procs |
2012-07-25 12:45 | Martijn Tonies | Note Added: 0000108 | |
2012-07-25 13:01 | Jens Saathoff | Note Added: 0000109 | |
2012-07-25 13:06 | Jens Saathoff | Note Added: 0000110 | |
2012-07-25 13:11 | Martijn Tonies | Note Added: 0000111 | |
2012-07-25 14:05 | Jens Saathoff | Note Added: 0000112 | |
2012-07-31 12:22 | Martijn Tonies | Severity | minor => major |
2012-07-31 12:22 | Martijn Tonies | Status | assigned => resolved |
2012-07-31 12:22 | Martijn Tonies | Fixed in Version | => 1.0.3 |
2012-07-31 12:22 | Martijn Tonies | Resolution | open => fixed |
2012-08-01 16:08 | Martijn Tonies | Status | resolved => closed |