-
1. Re: mysql connection to portal
scottdawson Oct 4, 2005 9:35 PM (in response to rhunter)Please show the contents of your portal datasource file.
Scott Dawson
Unisys -
2. Re: mysql connection to portal
rhunter Oct 5, 2005 8:33 AM (in response to 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 -
3. Re: mysql connection to portal
scottdawson Oct 5, 2005 1:58 PM (in response to rhunter)Put the password inside a password element:
userpassword
That may fix it.
Regards,
Scott Dawson
Unisys -
4. Re: mysql connection to portal
scottdawson Oct 5, 2005 2:00 PM (in response to rhunter)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.
-
5. Re: mysql connection to portal
rhunter Oct 5, 2005 3:40 PM (in response to 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)