View Issue Details

IDProjectCategoryView StatusLast Update
0000413HopperMySQLpublic2012-08-01 16:08
ReporterJens Saathoff Assigned ToMartijn Tonies  
Status closedResolutionfixed 
Product Version1.0.2 
Fixed in Version1.0.3 
Summary0000413: Hopper does not show Stored Procedures and Functions in tree on servers with no access to mysql.procs
DescriptionHopper 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 Reproduce1.Create a user on remote-server
2.Set permissions for a database(created user)
4.No stored procedures and functions are shown
TagsNo tags attached.
DBMS Version


related to 0000414 closedMartijn Tonies Database Workbench v4 No procedures/functions listed in the treeview if there was no access to mysql.procs, or no parameters 


Jens Saathoff

2012-07-24 11:20


hopper1.JPG (23,445 bytes)   
hopper1.JPG (23,445 bytes)   

Jens Saathoff

2012-07-24 11:20


dbforge1.JPG (44,393 bytes)   
dbforge1.JPG (44,393 bytes)   

Martijn Tonies

2012-07-24 12:24

administrator   ~0000094

I test this on a remote server as well, what are the exact permissions?

Martijn Tonies

2012-07-24 13:01

administrator   ~0000096

Jens, can you make sure the user has SELECT privileges to INFORMATION_SCHEMA?

Jens Saathoff

2012-07-24 13:11

reporter   ~0000097

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...

Jens Saathoff

2012-07-24 13:13

reporter   ~0000098

And...the setup does work with it should also work without refering information_schema... or not?

Martijn Tonies

2012-07-24 13:19

administrator   ~0000099

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?

Jens Saathoff

2012-07-24 13:39

reporter   ~0000100

Yes, same user.

Jens Saathoff

2012-07-24 13:43

reporter   ~0000101

2nd way is to retrieve functions and procs from mysql-database, table "proc", right?

Jens Saathoff

2012-07-24 13:45

reporter   ~0000102

I can create a trigger, modify the trigger. I can also create procs und funcs with the user.

Martijn Tonies

2012-07-24 14:57

administrator   ~0000103

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?

Jens Saathoff

2012-07-24 15:25

reporter   ~0000104

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...

Martijn Tonies

2012-07-25 08:36

administrator   ~0000105

Hello Jens,

If you can set up a test database, that would certainly help.

Jens Saathoff

2012-07-25 12:05

reporter   ~0000106

Of course! You got mail.

Martijn Tonies

2012-07-25 12:36

administrator   ~0000107

no access to mysql.procs, the fallback to information_schema failed.

Martijn Tonies

2012-07-25 12:45

administrator   ~0000108

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.

Jens Saathoff

2012-07-25 13:01

reporter   ~0000109 won't fix it?

Jens Saathoff

2012-07-25 13:06

reporter   ~0000110

If not, you should modify the information on your website:

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. *

Martijn Tonies

2012-07-25 13:11

administrator   ~0000111

I'll fix it for MySQL 5.5, no problem. Earlier versions seem harder, see:

I guess I'll have to resort to parsing to get parameter info.

Jens Saathoff

2012-07-25 14:05

reporter   ~0000112

5.1.63-0+squeeze1 is installed on the server you're testing on.

Issue History

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