What credentials are you using for the JDBC connection? The default is user/user - this is controlled by the teiid-security-users.properties file, located in /standalone/configuration directory of your server installation.
1 of 1 people found this helpful
Did you start the JBoss AS 7.1 with following command
run.bat -c standalone-teiid.xml
I am using user/user, and I checked in the .properties file and that is what it's set to.
As Ramesh pointed out, you'll need to start JBoss with the standalone-teiid.xml configuration. Are you starting the server from within Designer? If so, you can point it to the standalone-teiid.xml in that setup. Otherwise if starting JBoss from command line you'll need to specify it there.
you guys rock!!!
I've met with this problem too.
The default one in Designer make the lauching patameters 'standalone.xml' instead of 'standalone-teiid.xml'.
The reason for that is, the default is stand-alone profile in JBoss AS/EAP, thus when you install JBDS (JBoss developer tools) it defaults to that profile. Teiid is installed on top of JBoss AS/EAP in a separate profile that is only defined in a separate configuration file "standalone-teiid.xml" by default. Thus you need to start using the above commands to start Teiid specific components.
If you want in the "<jboss-eap>/bin/scripts" directory there is a script called "teiid-standalone-mode-install.cli" that will install Teiid in any profile. So, for that to work start the JBoss AS/EAP just as
then in a separate console window execute
Then from now on you can just start the default JBoss AS/EAP using "standalone.xml" in designer or any other places.
Thx, I'll try it later.
I am using EAP 6.3 with teiid-8.9.1-jboss-dist and found that the the property file application-users.properties was empty.
So i created users with jboss-eap-6.3\bin\add-user.bat which will write the users to the above file.
This will resolve this issue.
Thanks very much!