old test setup can't login at web console anymore...
m.ardito Sep 12, 2014 9:00 AMHi all, been a while...
I'm going to revamp my teiid tests, since now I could really try to go in production, hopefully.
on my win7x64 pc in the past I tried several setups, with many teiid versions, and now I would like to
* use last old test install again, and/or
* start from scratch with a ccompletely new install, and newest versions
but with the old install I have this issue:
- the server starts, and I can query with squirrelsql, a MSSQL test model I still have, loading, with user/user permissions... so it is working.
- on cli, server starts with good output, I think (will append this below)
- but I can't log in to web console anymore... or forgot how
firefox (24esr) on localhost:9990 asks for user/password, and
- I have two of those different test credentials saved in the browser, with different passwords (users: "admin", "teiid")
- but both do not work... anymore...?
- I could have installed also admin console (cli) if this helps but I'm not sure, how to check?
- those login could also belong to other tests, but... frankly, I have no chance to reconstruct which, and they could be gone, it was nearly 1 year ago, and I kept no docs, since they were really simple tests to verify my backend DBs (I know I should have anyway)
none of the standard (or I guess so) credentials work, and I'm stuck there, is there any way to reset those users passwords or else?
I admit that I left behind user roles/permissions configuration topics, at the time, since it was all new to me, and I explored VDB models, drivers, and so on...
otherwise I could try with a brand new AS + teiid, but I need a new step-by-step "getting started" guide, because my main memory (brain) is apparently faulty...
thanks, Marco
===============================================================================
JBoss Bootstrap Environment
JBOSS_HOME: D:\sviluppo\teiid\jboss-eap-6.1
JAVA: C:\Program Files (x86)\Java\jre7\bin\java
JAVA_OPTS: -client -Dprogram.name=standalone.bat -Dorg.teiid.backslashDefaultMatchEscape=true
===============================================================================
14:35:43,946 INFO [org.jboss.modules] (main) JBoss Modules version 1.2.0.CR1
14:35:44,372 INFO [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA
14:35:44,436 INFO [org.jboss.as] (MSC service thread 1-2) JBAS015899: JBoss Teiid + Teiid 8.4 (AS 7.2.0.Alpha1-redhat-4) starting
14:35:46,099 INFO [org.xnio] (MSC service thread 1-4) XNIO Version 3.0.7.GA
14:35:46,104 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
14:35:46,123 INFO [org.xnio.nio] (MSC service thread 1-4) XNIO NIO Implementation Version 3.0.7.GA
14:35:46,131 INFO [org.jboss.remoting] (MSC service thread 1-4) JBoss Remoting version 3.2.14.GA
14:35:46,288 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 30) JBAS010280: Activating Infinispan subsystem.
14:35:46,326 INFO [org.jboss.as.connector.logging] (MSC service thread 1-1) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.15.Final)
14:35:46,384 INFO [org.jboss.as.security] (ServerService Thread Pool -- 43) JBAS013171: Activating Security Subsystem
14:35:46,388 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem
14:35:46,465 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
14:35:46,467 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 36) JBAS012605: Activated the following JSF Implementations: [main, 1.2]
14:35:46,525 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension
14:35:46,569 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)
14:35:46,589 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)
14:35:46,653 INFO [org.jboss.as.security] (MSC service thread 1-4) JBAS013170: Current PicketBox version=4.0.15.Final
14:35:46,965 INFO [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting Naming Service
14:35:47,148 INFO [org.jboss.as.mail.extension] (MSC service thread 1-4) JBAS015400: Bound mail session [java:jboss/mail/Default]
14:35:47,206 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003001: Coyote HTTP/1.1 initializing on : http-/0.0.0.0:8080
14:35:47,210 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003000: Coyote HTTP/1.1 starting on: http-/0.0.0.0:8080
14:35:47,535 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/google/main/./
14:35:47,550 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./
14:35:47,596 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/infinispan/main/./
14:35:47,607 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/file/main/./
14:35:47,608 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/ldap/main/./
14:35:47,639 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/google/main/./
14:35:47,639 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/infinispan/main/./
14:35:47,645 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/google/main/./
14:35:47,648 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/file/main/./
14:35:47,649 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/infinispan/main/./
14:35:47,652 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/ldap/main/./
14:35:47,653 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/file/main/./
14:35:47,654 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/ldap/main/./
14:35:47,691 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]14:35:47,709 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 44) TEIID50011 Security enabled for transport "odata" with security-domain set to teiid-s
ecurity14:35:47,715 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 44) TEIID50011 Security enabled for transport "jdbc" with security-domain set to teiid-security
14:35:47,716 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 44) TEIID50011 Security enabled for transport "odbc" with security-domain set to teiid-security
14:35:47,799 INFO [org.jboss.ws.common.management] (MSC service thread 1-4) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.1.3.Final
14:35:47,810 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./
14:35:47,828 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./
14:35:47,841 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./
14:35:47,852 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./
14:35:47,858 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/mongodb/main/./
14:35:47,863 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./
14:35:47,874 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/mongodb/main/./
14:35:47,897 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/mongodb/main/./
14:35:47,933 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "jdbc-simple" added.
14:35:47,943 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "jdbc-ansi" added.
14:35:47,965 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "access" added.
14:35:48,017 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "db2" added.
14:35:48,012 INFO [org.infinispan.factories.GlobalComponentRegistry] (ServerService Thread Pool -- 50) ISPN000128: Infinispan version: Infinispan 'Delirium' 5.2.1.Final
14:35:48,054 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "derby" added.
14:35:48,083 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "h2" added.
14:35:48,101 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "hsql" added.
14:35:48,121 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "informix" added.
14:35:48,158 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "metamatrix" added.
14:35:48,202 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "mysql" added.
14:35:48,408 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "mysql5" added.
14:35:48,450 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "oracle" added.
14:35:48,483 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "postgresql" added.
14:35:48,536 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "sqlserver" added.
14:35:48,580 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "sybase" added.
14:35:48,616 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "teiid" added.
14:35:48,658 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 51) ISPN000031: MBeans were successfully registered to the platformMBean server.
14:35:48,657 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 52) ISPN000031: MBeans were successfully registered to the platformMBean server.
14:35:48,667 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 52) JBAS010281: Started preparedplan cache from teiid container
14:35:48,659 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 50) ISPN000031: MBeans were successfully registered to the platformMBean server.
14:35:48,666 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 51) JBAS010281: Started resultset-repl cache from teiid container
14:35:48,677 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 50) JBAS010281: Started resultset cache from teiid container
14:35:48,689 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "teradata" added.
14:35:48,718 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "modeshape" added.
14:35:48,734 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ingres" added.
14:35:48,749 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ingres93" added.
14:35:48,771 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "intersystems-cache" added.
14:35:48,796 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "netezza" added.
14:35:48,811 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "file" added.
14:35:48,858 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ldap" added.
14:35:48,867 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "loopback" added.
14:35:48,876 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "olap" added.
14:35:48,913 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ws" added.
14:35:48,922 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "salesforce" added.
14:35:48,968 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "hive" added.
14:35:48,992 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "jpa2" added.
14:35:48,998 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "infinispan-cache" added.
14:35:49,002 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "map-cache" added.
14:35:49,084 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "odata" added.
14:35:49,118 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "mongodb" added.
14:35:49,218 INFO [org.jboss.as.remoting] (MSC service thread 1-2) JBAS017100: Listening on 127.0.0.1:9999
14:35:49,221 INFO [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Listening on 0.0.0.0:4447
14:35:49,232 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "mysql-connector-java-5.1.22-bin.jar" (runtime-name: "mysql-connector-java-5.1.22-bin.jar")
14:35:49,224 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mssql-vdb.xml" (runtime-name: "mssql-vdb.xml")
14:35:49,261 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "teiid-odata-8.4.0.Final.war" (runtime-name: "teiid-odata-8.4.0.Final.war")
14:35:49,264 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mssql-ds.xml" (runtime-name: "mssql-ds.xml")
14:35:49,276 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-2) JBAS015012: Started FileSystemDeploymentService for directory D:\sviluppo\teiid\jboss-eap-6.1\standalone\deployments
14:35:49,278 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "jtds-1.3.0.jar" (runtime-name: "jtds-1.3.0.jar")
14:35:49,285 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mysql-ds.xml" (runtime-name: "mysql-ds.xml")
14:35:49,551 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teiid Engine 8.4.0.Final Started = Fri Sep 12 14:35:49 CEST 2014
14:35:49,979 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/embedded
14:35:50,095 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/odata
14:35:50,162 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50012 Teiid JDBC - Name = jdbc, Host = 0.0.0.0, Port = 31000, SSL = OFF, security-domains = [teiid-security]
14:35:50,162 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50037 Teiid ODBC - Name = odbc, Host = 0.0.0.0, Port = 35432, SSL = OFF, security-domains = [teiid-security]
14:35:50,286 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
14:35:50,431 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010404: Deploying non-JDBC-compliant driver class net.sourceforge.jtds.jdbc.Driver (version 1.3)
14:35:50,573 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Bound data source [java:/testmysql]
14:35:50,574 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:/magoDS]
14:35:51,174 INFO [org.jboss.web] (ServerService Thread Pool -- 51) JBAS018210: Register web context: /odata
14:35:51,316 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB TestMSsql.1 model "TestMSsql" metadata is currently being loaded. Start Time: 12/09/14 14.35
14:35:51,919 INFO [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 51) HV000001: Hibernate Validator 4.3.1.Final
14:35:52,113 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 51) Deploying javax.ws.rs.core.Application: class org.teiid.odata.TeiidODataApplication
14:35:52,437 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mysql-ds.xml" (runtime-name : "mysql-ds.xml")
14:35:52,439 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mysql-connector-java-5.1.22-bin.jar" (runtime-name : "mysql-connector-java-5.1.22-bin.jar")
14:35:52,440 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mssql-vdb.xml" (runtime-name : "mssql-vdb.xml")
14:35:52,443 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mssql-ds.xml" (runtime-name : "mssql-ds.xml")
14:35:52,447 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "jtds-1.3.0.jar" (runtime-name : "jtds-1.3.0.jar")
14:35:52,455 INFO [org.jboss.as.server] (ServerService Thread Pool -- 44) JBAS018559: Deployed "teiid-odata-8.4.0.Final.war" (runtime-name : "teiid-odata-8.4.0.Final.war")
14:35:52,548 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management
14:35:52,549 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
14:35:52,550 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss Teiid + Teiid 8.4 (AS 7.2.0.Alpha1-redhat-4) started in 9346ms - Started 392 of 47
6 services (83 services are passive or on-demand)