| Search: |
You are not logged in.
Ads (what is this?) |
Announcement
|
Ads (what is this?) |
Download it
90 bugs were fixed including sqlbuilder, routine management, metadata wizards, mapper, job designer editor, Java components, job import/export and ELT components.
See details in Bugtracker generated ChangeLog
Offline
i had a problem with talend infobright connector
Exception in component tInfobrightOutput
java.sql.SQLException: Access denied for user ‘time’@‘10.219.28.%’ (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2430)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2359)
at com.mysql.jdbc.Statement.execute(Statement.java:719)
at com.infobright.io.InfobrightNamedPipeLoader$ExecutionThread.run(InfobrightNamedPipeLoader.java:207)
its not problem with privileges. while running the script table is created in Target database and unable to insert data then throws the above exception.
for this i am placing target table as mysql [in same infobright databse] insted of tInfobrightOutput[infobright loader] the script is executed successfully.
Any one please provide a solution for this.
Thanks,
Raja
Offline
Hi Raja,
1) The user needs the FILE privilege to use the Infobright connector.
GRANT FILE ON *.* to 'user'@'localhost';
2) The connector currently (as of version 3.2) only can run on the local host where Infobright is running. We do not support loading remotely from another machine, but we plan to support this in a future release.
Geoffrey
Offline
