7 Replies Latest reply on Jan 9, 2006 5:07 PM by Fritz Feuerbacher

    problems with jportal installation

    nadia gallo Newbie

      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

        • 1. Re: problems with jportal installation
          scottlholmes Newbie

          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.

          • 2. Re: problems with jportal installation
            Florian Gogon Newbie

            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 :)

            • 3. Re: problems with jportal installation
              Roy Russo Master

              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

              • 4. Re: problems with jportal installation
                nadia gallo Newbie

                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

                • 5. Re: problems with jportal installation
                  Fritz Feuerbacher Newbie

                  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

                  • 6. Re: problems with jportal installation
                    Roy Russo Master

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

                    • 7. Re: problems with jportal installation
                      Fritz Feuerbacher Newbie

                      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.