Switching JBossPortal to MySQL from hypersonic.

[andrewboyd]

Hi All,
I had JBossPortal up and running with the default hypersonic db. I wanted to use MySQL. So I moved the hypersonic dir out of the server sub-dirs. I created a MySql db with the command:

CREATE DATABASE IF NOT EXISTS jbossportal

Now when I try to use it I'm getting the following error:
SQLException: Access denied for user 'portalUser'@'%' to database 'jbossportal'

I know that this is probably a MySql issue but I was hoping that someone here might have run into the same thing before.

Any suggestions?

Thanks,

Andrew

[rutfield]

From within MySQL (logged in with admin privileges), you should

GRANT ALL ON jbossportal.* TO 'portalUser'@'%' IDENTIFIED BY 'portualUser_password';

(where the last parameter is the password for portalUser)
and then

GRANT ALL ON jbossportal.* TO 'portalUser'@'localhost' IDENTIFIED BY 'portualUser_password';

Finally, you need to

Flush privileges;

before you exit MySQL for them to take affect.

I hope that helps.
CR

[andrewboyd]

Thanks for the quick reply CR. Your suggestion is getting me closer.

Now I keep getting the following:

10:11:00,437 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 01004
10:11:00,437 ERROR [JDBCExceptionReporter] Data truncation: Data too long for column 'MODIFIABLE' at row 1
10:11:00,453 ERROR [PortletAppDeployment] Error when creating instances
org.hibernate.exception.GenericJDBCException: could not insert: [org.jboss.portal.core.impl.model.instance.InstanceImpl]

Any ideas?

Thanks,
Andrew

[rali.genova]

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

[andrewboyd]

Perfect! Thanks rali.