JBoss Portal 2.4.1 User Portlet not working with MySQL 5.0

[dleerob]

I have setup JBoss Portal 2.4.1 to run on JBoss Application Server 4.05, using MySQL 5.0. I have made the relevant changes for the known MySQL 5.0 data truncation issue.
There are no errors when starting up the server, and everything seems fine, however, when loggin in as admin / admin, the user portlet doesn't seem to work. It still has the link "Standard Login" and "create one". Even when clicking on these, the user portlet simply opens up and remains on that page. I did read in another thread somewhere that someone has the same issue in JBoss Portal 2.2, but no resolution has yet been found on that thread.

I have now re-set up the portal using MySQL 4.1.13 instead, and the user portlet works perfectly.

Has anyone else had this issue with MySQL 5.0, and do they know what the problem is? I'm a bit worried about using MySQL 5.0 if there are going to be funny issues like this one. In the documentation it does say that MySQL 5.0 is not officially supported. Does anyone know when it will be officially supported? And should I rather use MySQL4 for now?

Thanks in advance.

[peterj]

Did you see http://wiki.jboss.org/wiki/Wiki.jsp?page=AvoidMySQL5DataTruncationErrors?

[dleerob]

Yes I did take into account the MySQL 5 data truncation issue, thanks. Still have the problem.

[peterj]

I noticed in another post that you are using LDAP authentication, and you were asking about populating the roles. I wonder if that has any bearing on this problem; from what I recall looking at the User Portlet source several months ago, what it displays depends on the user's role (I wouldn't bet on this though, as I said it was many months ago and I have a hard enough time remembering what it was I did last week!)