Portal Installation - "Your Account is disabled"

[avagarwal]

Hi,

I am installing jboss-portal-2.6.5.SP1 (jboss-4.2.2.GA, MySQL 5.0). The portal page displays fine, and the portlets like weather etc open up perfectly. However when I try to login using user/user or admin/admin I receive the message "Your Account is disabled". What am I missing?

Thanks

Anurag

[peterj]

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?

[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&amp;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

[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