problems with jportal installation

[g_nadia]

hi.

I'm using jboss-portal-2.0-jboss-4.0.2, windows xp pro and mysql 4.1.7.
I followed the steps shown on "jboss portal 2.0 final user guide.

it seem to be something wrong, because after the startup of jboss, the database schema has been created whit tables, but tables didn't contain any data. So, for examples, I have no data into "jbp_users" table e no users to connect to the jportal.

Any suggestion?

Thanks a lot,
Nadia

[scottlholmes]

I needed to read the following several times to figure out what was up with my configuration:

http://docs.jboss.com/jbportal/v2.0Final/user-guide/en/html/installation.html

I'm not sure if I needed to do this or not but I did seem to get ahead a little:

Edit jboss-portal.sar/conf/hibernate/hibernate.cfg.xml AND portal-forums.sar/conf/hibernate/hibernate.cfg.xml

<!-- Force the dialect instead of using autodetection -->
org.hibernate.dialect.MySQLDialect

Also, towards the bottom of the installation guide are instructions for destroying and then re-creating the schema and then loading the content. Going through these steps did the trick, I think.

I still get quite alot of errors everywhere but everything seems to sortta work.

[gontouf]

You can try this, it works for me with an Oracle9i database and last versions of JBoss AS and JBoss portal (not the bundled pack)...i'm not an expert so i'm not sure it's the best solution but now i have a great install of the portal with no errors.

I have modified these files:

- standardjaws.xml:


java:/OracleDS
<type-mapping>Oracle8</type-mapping>


- standardjboss-cmp-jdbc.xml:

<jbosscmp-jdbc>

java:/OracleDS
<datasource-mapping>Oracle8</datasource-mapping>

</jbosscmp-jdbc>

- oracle-ds.xml:
you can find an example in jboss-portal-home\docs\examples\jca and you just need to put your connection parameter.

- portal-oracle-ds.xml:
you can find an example in jboss-portal-home\docs\portal\setup and you just need to put your connection parameter.

- login-config.xml:

<application-policy name = "OracleDbRealm">

<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">xxx</module-option>
<module-option name = "userName">xxx</module-option>
<module-option name = "password">yyy</module-option>
<module-option name ="managedConnectionFactoryName">
jboss.jca:service=LocalTxCM,name=OracleDS
</module-option>
</login-module>

</application-policy>
...
<!-- Security domains for testing new jca framework -->
<application-policy name = "OracleDbRealm">

<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">xxx</module-option>
<module-option name = "userName">xxx</module-option>
<module-option name = "password">yyy</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=OracleDS</module-option>
</login-module>

</application-policy>

- oracle-jdbc-state-service.xml:
( i have renamed the hsqldb file and modify the value DefaultDS in OracleDS)
<depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=OracleDS

- oracle-jdbc3-service.xml
you can find an example in jboss-portal-home/docs/examples/jms

- ejb-deployer.xml:
<depends optional-attribute-name="DataSource">jboss.jca:service=DataSourceBinding,name=OracleDS


After that, you need to delete hsqldb.jar, and these files:
hsqldb-ds.xml, portal-hsqldb-ds.xml, and hsql-jdbc-service.xml


i think it's the same for you with MySQL parameter...
i wish it'll help... and tell me if it works for you too :)

[roy.russo]

Try recreating the tables and recreating the content as scott describes: http://docs.jboss.com/jbportal/v2.0Final/user-guide/en/html/installation.html#d0e657

[g_nadia]

thanks to all to have helped me.
I recreated the tables and the content whit hibernate mbean ... a couple of times ... and now all is ok :-).

Nadia

[fritzwf]

You may want to update the JBoss Portal 2.2 User Guide pdf document. The things referenced in the message above that are in the html version are not in the pdf document. I would have saved a lot of time if I knew this.

Thanks

[roy.russo]

This thread is relevant to 2.0. Did this solve an Oracle deployment for you in 2.2?

[fritzwf]

It turns out that only the online docs have section 2.5.3. The docs that are distributed with JBoss Portal source project don't have this section.