|
|
hopper1.JPG (23,445 bytes) |
|
|
dbforge1.JPG (44,393 bytes) |
|
|
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. |
- Anonymous
