mysql connection to portal

[rhunter]

I'm getting the following error:

-- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
bjectName: jboss.jca:service=DataSourceBinding,name=PortalDS
State: NOTYETINSTALLED
Depends On Me:
portal:service=CMS
portal:service=Hibernate

Both services show as state:configured.

I'm using the default jboss 4.0.2 install and mysql 5.0 on win xp pro.
It's preventing the portal from deploying. Where do I start looking to fix this?

Thanks in advance.
Robert

[scottdawson]

Please show the contents of your portal datasource file.

Scott Dawson
Unisys

[rhunter]

Here it is.

<?xml version="1.0" encoding="UTF-8"?>

<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>username</user-name>
userpassword
</local-tx-datasource>


Thanks,
Robert

[scottdawson]

Put the password inside a password element:
userpassword

That may fix it.

Regards,
Scott Dawson
Unisys

[scottdawson]

Never mind. As soon as I posted my reply, I see that the password element gets hidden by the forum, so you probably already have it. (Look at your post and you'll see what I mean. Anyway, your ds file looks just like mine.

[rhunter]

After I restarted the AS server a few times the portal deployed. I'm not sure why. But it doesn't run the setup.txt script correctly to set the admin password. The error is below. Any idea's?

Thanks,
Robert

12:08:54,242 INFO [NamingHelper] JNDI InitialContext properties:{}
12:08:54,242 INFO [DatasourceConnectionProvider] Using datasource: java:PortalD
S
12:09:01,112 INFO [SchemaExport] schema export complete
12:09:01,112 INFO [SessionFactoryBinder] Creating database content
12:09:01,303 WARN [JDBCExceptionReporter] SQL Error: 1406, SQLState: 22001
12:09:01,303 ERROR [JDBCExceptionReporter] Data too long for column 'jbp_viewrea
lemail' at row 1
12:09:01,303 ERROR [SessionFactoryBinder] Error in the bsh script
Sourced file: inline evaluation of: ``// This bsh script setup the default conte
nt of the portal. // It is called whe . . . '' : Method Invocation session.save
: at Line: 41 : in file: inline evaluation of: ``// This bsh script setup the d
efault content of the portal. // It is called whe . . . '' : session .save ( ad
min )

Target exception: org.hibernate.exception.GenericJDBCException: could not insert
: [org.jboss.portal.core.impl.user.UserImpl]

at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)