This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 195404 - Create Database when performed by user who does not have privileges throws exception
Summary: Create Database when performed by user who does not have privileges throws ex...
Status: RESOLVED DUPLICATE of bug 162530
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 7.0
Hardware: PC Linux
: P3 normal with 1 vote (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-13 01:32 UTC by schkovich
Modified: 2011-03-30 13:12 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
message.log (34.25 KB, text/x-log)
2011-02-13 01:34 UTC, schkovich
Details

Note You need to log in before you can comment on or make changes to this bug.
Description schkovich 2011-02-13 01:32:41 UTC
Product Version: NetBeans IDE 7.0 Beta 2 (Build 201102111519)
Java: 1.6.0_22; Java HotSpot(TM) 64-Bit Server VM 17.1-b03
System: Linux version 2.6.35-25-generic running on amd64; UTF-8; en_US (nb)

Ubuntu 10.10

Databases Integration Test Specification
http://qa.netbeans.org/modules/webapps/promo-h/DBIntegration.html

work_mysql_010

Create standard DB with user, who hasn't admin privilegies

1. Rightclick "Databases" node and choose "Register MySQL Server".
2. Specify valid basic properties for MySQL server, but with user, who hasn't admin privilegies, and click "OK".
3. Rightclick MySQL server node and choose "Create Database...".
4. Choose database "sample" and click OK.

Expected: Message that user aren't granted should appear.
Actuall: At step 3. exception is thrown


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'schkovich'@'localhost' for table 'user'

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'schkovich'@'localhost' for table 'user'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.Util.getInstance(Util.java:384)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
	at org.netbeans.modules.db.mysql.impl.MySQLDatabaseServer$8.execute(MySQLDatabaseServer.java:750)
	at org.netbeans.modules.db.mysql.impl.MySQLDatabaseServer$DatabaseCommand.run(MySQLDatabaseServer.java:1057)
	at org.netbeans.modules.db.mysql.impl.ConnectionProcessor.run(ConnectionProcessor.java:149)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1424)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1968)
Caused: java.lang.RuntimeException: Unexpected exception
	at org.netbeans.modules.db.mysql.util.Utils.launderThrowable(Utils.java:79)
	at org.netbeans.modules.db.mysql.impl.MySQLDatabaseServer.getUsers(MySQLDatabaseServer.java:773)
	at org.netbeans.modules.db.mysql.ui.CreateDatabasePanel$UsersComboModel.<init>(CreateDatabasePanel.java:634)
	at org.netbeans.modules.db.mysql.ui.CreateDatabasePanel.<init>(CreateDatabasePanel.java:429)
	at org.netbeans.modules.db.mysql.actions.CreateDatabaseAction.performAction(CreateDatabaseAction.java:114)
	at org.openide.util.actions.NodeAction$DelegateAction$1.run(NodeAction.java:586)
	at org.openide.util.actions.ActionInvoker$1.run(ActionInvoker.java:95)
	at org.openide.util.actions.ActionInvoker.doPerformAction(ActionInvoker.java:116)
	at org.openide.util.actions.ActionInvoker.invokeAction(ActionInvoker.java:99)
	at org.openide.util.actions.NodeAction$DelegateAction.actionPerformed(NodeAction.java:583)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1223)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1264)
	at java.awt.Component.processMouseEvent(Component.java:6267)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6032)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4630)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4460)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4460)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
	at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:148)
[catch] at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Comment 1 schkovich 2011-02-13 01:34:32 UTC
Created attachment 105946 [details]
message.log
Comment 2 Jiri Rechtacek 2011-03-30 13:12:32 UTC
Already fixed in recent daily builds.

*** This bug has been marked as a duplicate of bug 162530 ***