-
1. Re: Regarding teiid instance
rareddy Aug 12, 2011 10:43 AM (in response to akhilkg1987)Akhil,
You need all the steps 1,2,3,4. What I see from above is for JDBC you have used "mms://localhost:31000". The "mms" protocol is for secure connection, and by default JDBC is connection is not established over secure connection. So, try "mm://localhost:31000"
JBoss AS Server with Teiid needs to be running while you try to make connection. Also on the wizard there is "test" button make sure it returns success!
Ramesh.. -
-
3. Re: Regarding teiid instance
akhilkg1987 Aug 16, 2011 5:49 AM (in response to akhilkg1987)Hi ramesh,
Thanks a lot for your reply.
I have successfully created a working instance.There was some problem with the JBOSS I guess.It worked after I reinstalled it and then tried.
But I still see only 1 set of url,username and password.Any idea what might be the issue?
The instance connected to the server properly,but when I am trying to preview any data from the tables I get the following excetion
14:47:32,946 WARN [ADMIN_API] Processing exception 'The specified session ID "n
ull" is invalid. It cannot be found in the userbase.' for session null. Excepti
on type org.teiid.adminapi.AdminProcessingException thrown from org.teiid.servic
es.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:310). Enable more d
etailed logging to see the entire stacktrace.
14:47:35,164 WARN [SECURITY] Processing exception 'The username "admin" and/or
password and/or payload token could not be authenticated by any membership domai
n.' for session null. Exception type org.teiid.client.security.LogonException t
hrown from org.teiid.transport.LogonImpl.logon(LogonImpl.java:89). Enable more d
etailed logging to see the entire stacktrace.
Please help.
-
4. Re: Regarding teiid instance
rareddy Aug 16, 2011 6:53 AM (in response to akhilkg1987)Akhil,
Looks like vey old version of Designer. What version are you using? I recommend you download the latest version (7.4) version.
http://www.jboss.org/teiiddesigner/downloads
Ramesh..
-
5. Re: Regarding teiid instance
akhilkg1987 Aug 16, 2011 7:10 AM (in response to rareddy)Hi Ramesh,
Thanks once again.The teiid version that I am using is 7.1 and JBOSS 5.01
Also please tell me do we need to set the username and password in some files like jbossproperties or securities etc?
-
6. Re: Regarding teiid instance
rareddy Aug 16, 2011 7:21 AM (in response to akhilkg1987)Akhil,
The both versions are quite old. Use Designer 7.4, JBoss AS 5.1.0 (NOT 5.0.1) with Teiid 7.4
You can define the user name and password for JDBC in
<jboss-as>/server/default/conf/prop/teiid-security-users.properties, however the default user with password is "user/user"
You can define the "admin" user in
<jboss-as>/server/default/conf/prop/jmx-console-users.properties, however the default user with password is "admin/admin"
Ramesh..
-
7. Re: Regarding teiid instance
akhilkg1987 Aug 16, 2011 7:34 AM (in response to rareddy)Thanks a lot Ramesh.
Am installing Teiid 7.4 and then would install JBOSS too.
I hope it would solve a lot of problems for me.:)