Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box.
I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that.
Overall looks like an issue with accessing the system table `sys.environment`, not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started. Any help or thought on where to start?
Thanks!
Sandy
-------- Errors
* DBeaver 4.0.8
On inspection of some of the logs I see things like -
`Error loading object metadata from database`
`SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment' java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'`
* SQuirreL SQL Client 3.7.1
java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'
-------- Driver and DB versions
I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15)
MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc'
Hi Sandy,
Take a look at the permission documentation.
https://www.monetdb.org/Documentation/SQLreference/Permissions
Regards,
Brian Hood
On Sat, Jun 24, 2017 at 12:46 AM, Sandy sandy@carlabs.com wrote:
Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box.
I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that.
Overall looks like an issue with accessing the system table `sys.environment`, not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started. Any help or thought on where to start?
Thanks!
Sandy
-------- Errors
- DBeaver 4.0.8
On inspection of some of the logs I see things like -
`Error loading object metadata from database`
`SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment' java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'`
- SQuirreL SQL Client 3.7.1
java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'
-------- Driver and DB versions
I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15)
MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc'
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks Bryan!
Will take a look, seems like something simple like rights. Will post back results in the next day or so when I can jump on it.
Sandy
On 6/24/2017 5:13 AM, Brian Hood wrote:
Hi Sandy,
Take a look at the permission documentation.
https://www.monetdb.org/Documentation/SQLreference/Permissions
Regards,
Brian Hood
On Sat, Jun 24, 2017 at 12:46 AM, Sandy <sandy@carlabs.com mailto:sandy@carlabs.com> wrote:
Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box. I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that. Overall looks like an issue with accessing the system table `sys.environment`, not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started. Any help or thought on where to start? Thanks! Sandy -------- Errors * DBeaver 4.0.8 On inspection of some of the logs I see things like - `Error loading object metadata from database` `SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment' java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'` * SQuirreL SQL Client 3.7.1 java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment' -------- Driver and DB versions I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15) MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc' _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list <https://www.monetdb.org/mailman/listinfo/users-list>
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Brian -
Executed this as monetdb user on the voc database -
grant all on sys.environment to voc; grant all on sys.tables to voc; grant all on sys.table_types to voc;
Not sure if `all` is needed or just `select` but I can try that.
Seems to now allow DBeaver and the SQuirreL SQL tools to pull the meta data now, inching forward ;)
Thanks again for the simple and obvious.
Sandy
On 6/24/2017 5:13 AM, Brian Hood wrote:
Hi Sandy,
Take a look at the permission documentation.
https://www.monetdb.org/Documentation/SQLreference/Permissions
Regards,
Brian Hood
On Sat, Jun 24, 2017 at 12:46 AM, Sandy <sandy@carlabs.com mailto:sandy@carlabs.com> wrote:
Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box. I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that. Overall looks like an issue with accessing the system table `sys.environment`, not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started. Any help or thought on where to start? Thanks! Sandy -------- Errors * DBeaver 4.0.8 On inspection of some of the logs I see things like - `Error loading object metadata from database` `SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment' java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'` * SQuirreL SQL Client 3.7.1 java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment' -------- Driver and DB versions I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15) MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc' _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list <https://www.monetdb.org/mailman/listinfo/users-list>
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
FYI: New JDBC driver monetdb-jdbc-2.27.jar has been released which includes fixes for below mentioned errors.
See https://www.monetdb.org/downloads/Java/
It also includes a fix for reading and displaying CLOB data in DBeaver.
Regards,
Martin
On 24-06-17 01:46, Sandy wrote:
Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box.
I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that.
Overall looks like an issue with accessing the system table `sys.environment`, not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started. Any help or thought on where to start?
Thanks!
Sandy
-------- Errors
- DBeaver 4.0.8
On inspection of some of the logs I see things like -
`Error loading object metadata from database`
`SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment' java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'`
- SQuirreL SQL Client 3.7.1
java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'
-------- Driver and DB versions
I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15)
MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc'
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Will give it a go, thanks for fixing things up!
Sandy
On 10/26/2017 6:55 AM, martin van dinther wrote:
FYI: New JDBC driver monetdb-jdbc-2.27.jar has been released which includes fixes for below mentioned errors.
See https://www.monetdb.org/downloads/Java/
It also includes a fix for reading and displaying CLOB data in DBeaver.
Regards,
Martin
On 24-06-17 01:46, Sandy wrote:
Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box.
I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that.
Overall looks like an issue with accessing the system table `sys.environment`, not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started. Any help or thought on where to start?
Thanks!
Sandy
-------- Errors
- DBeaver 4.0.8
On inspection of some of the logs I see things like -
`Error loading object metadata from database`
`SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment' java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'`
- SQuirreL SQL Client 3.7.1
java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'
-------- Driver and DB versions
I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15)
MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc'
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Brian Hood -
martin van dinther -
Sandy