-
1. Your account is disabled
peterj Jun 17, 2008 1:29 PM (in response to avagarwal)Look in the database at the table jbp_users. There should be two entries: "user" and "admin". Look at the column jbp_enabled - it should be set to a binary '1'. (You might have to use the Query Browser, when I used the mysql utility for the select, the values in the jbp_enabled showed up as smiley faces.)
Also, could you post your *-ds.xml file? -
2. Re: Your account is disabled
avagarwal Jun 18, 2008 9:37 AM (in response to avagarwal)Hi Peter,
Both "user" and "admin" are created. jbp_enabled is set to 1. My *-ds.xml file is as follows
<local-tx-datasource>
<jndi-name>PortalDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/portal?useServerPrepStmts=false&jdbcCompliantTruncation=false</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>portal</user-name>
portal
</local-tx-datasource>
Still facing the same issue.
Thanks
Anurag -
3. Re: Your account is disabled
avagarwal Jun 22, 2008 8:54 PM (in response to avagarwal)Hi,
Issue resolved. I was using "mysql-connector-java-3.0.17-ga-bin.jar" instead of "mysql-connector-java-5.1.6-bin.jar" which was causing the issue's. Surprisingly however the using the former (3.0.17) the database is created and you can even create new user's in the same. Not sure weather this is a bug.
Thanks
Anurag