fielding wang [http://community.jboss.org/people/fielding34] created the discussion "sign in failed on mysql" To view the discussion, visit: http://community.jboss.org/message/542253#542253 -------------------------------------------------------------- I am using GateIn tomcat 3.0. i start running gatein by default, everything seems fine. After i changed the "*$GATEIN/gatein/conf/configuration.properties*" as below to use Mysql instead of default HSQLDB,  GateIn server can start without any errors. But i cannot login system using any default users. Even if I register a new user successfully, but i still can't login system using that new one. Could someone give me a hand about this? And i also wonder in which situation gatein will populate default users into database (i.e. root, mary, john, demo). Thanks a lot in advance. # JCR gatein.jcr.config.type=local gatein.jcr.datasource.name=jdbcjcr gatein.jcr.datasource.dialect=auto gatein.jcr.datasource.driver=com.mysql.jdbc.Driver gatein.jcr.datasource.url=jdbc:mysql://128.130.11.93:3306/jdbcjcr_${name} gatein.jcr.datasource.username=root gatein.jcr.datasource.password=freebsd gatein.jcr.data.dir=${gatein.data.dir}/jcr gatein.jcr.storage.data.dir=${gatein.jcr.data.dir}/values gatein.jcr.index.data.dir=${gatein.jcr.data.dir}/lucene gatein.jcr.index.changefilterclass=org.exoplatform.services.jcr.impl.core.query.DefaultChangesFilter # IDM gatein.idm.datasource.name=jdbcidm gatein.idm.datasource.driver=com.mysql.jdbc.Driver gatein.idm.datasource.url=jdbc:mysql://128.130.11.93:3306/jdbcidm_${name} gatein.idm.datasource.username=jdbcidm gatein.idm.datasource.password=jdbcidm -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/542253#542253] Start a new discussion in JBoss Portal at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]