9 Replies Latest reply on Oct 6, 2006 10:27 AM by Praveen Cheruvu

    Cannot see Management and CMS portlet

    Praveen Cheruvu Newbie

      Hi,

      I am using JBoss AS 4.0.4 +JBossPortal 2.2 bundle. I did install correctly. but i have following issues

      1. Cannot see Managment tab and Management Portlet
      2. Cannot see CMS tabCMS admin protlet.
      3. When i click on user portlet, it takes me to login screen, but when i try to login as admin/admin as user name and passid , it says invalid login.
      Do i need to create these logins ?

      when i say http://localhost:8080/portal/portal/default, i see just 2 tabs one is test and one is default.
      I checked the default-object.xml. It does not have any thing for CMS and mangement tabs.

      have i missed something here ? If i need to get CMS admin and Mangement portlet, how to get it now (i.e it should have come default install)? Please throw some light
      The default-object.xml is as follows

      <?xml version="1.0" encoding="UTF-8"?>
      <deployments>
       <deployment>
       <parent-ref>default</parent-ref>
       <if-exists>keep</if-exists>
       <page>
       <page-name>Test</page-name>
       <listener>test_listener</listener>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>TestPortletWindow</window-name>
       <instance-ref>TestPortletInstance</instance-ref>
       <region>center</region>
       <height>1</height>
       </window>
       <window>
       <window-name>CMSPortletWindow</window-name>
       <instance-ref>CMSPortletInstance</instance-ref>
       <region>center</region>
       <height>2</height>
       </window>
       <window>
       <window-name>PreferencesPortletWindow</window-name>
       <instance-ref>PreferencesPortletInstance</instance-ref>
       <region>center</region>
       <height>3</height>
       </window>
       <window>
       <window-name>UserPortletWindow</window-name>
       <instance-ref>UserPortletInstance</instance-ref>
       <region>left</region>
       <height>0</height>
       </window>
       <window>
       <window-name>CatalogPortletWindow</window-name>
       <instance-ref>CatalogPortletInstance</instance-ref>
       <region>left</region>
       <height>1</height>
       </window>
       <page>
       <page-name>event test</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>CatalogPortletWindow</window-name>
       <instance-ref>CatalogPortletInstance</instance-ref>
       <region>left</region>
       <height>0</height>
       </window>
       <window>
       <window-name>PortletAWindow</window-name>
       <instance-ref>PortletAInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       <window>
       <window-name>PortletBWindow</window-name>
       <instance-ref>PortletBInstance</instance-ref>
       <region>center</region>
       <height>1</height>
       </window>
       </page>
       <page>
       <page-name>secure test</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>SecuredTestPortletWindow</window-name>
       <instance-ref>SecuredTestPortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       </page>
       <page>
       <page-name>exception test</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>ExceptionPortletWindow</window-name>
       <instance-ref>ExceptionPortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       </page>
       <page>
       <page-name>cache test</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>CachedCounterPortletWindow</window-name>
       <instance-ref>CachedCounterPortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       <window>
       <window-name>CounterPortletWindow</window-name>
       <instance-ref>CounterPortletInstance</instance-ref>
       <region>center</region>
       <height>1</height>
       </window>
       </page>
       <page>
       <page-name>session test</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>PortletSessionPortletWindow</window-name>
       <instance-ref>PortletSessionPortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       </page>
       <page>
       <page-name>missing portlet</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>MissingPortletWindow</window-name>
       <instance-ref>MissingPortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       </page>
       <page>
       <page-name>missing instance</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>MissingInstanceWindow</window-name>
       <instance-ref>MissingInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       </page>
       <page>
       <page-name>charset test</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>CatalogPortletWindow</window-name>
       <instance-ref>CatalogPortletInstance</instance-ref>
       <region>left</region>
       <height>0</height>
       </window>
       <window>
       <window-name>CharsetPortletWindow</window-name>
       <instance-ref>CharsetPortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       </page>
       <page>
       <page-name>theme test</page-name>
       <properties>
       <!-- set a different (from the portal) property (properties) for this page -->
       <!--
       <property>
       <name>org.jboss.portal.property.layout</name>
       <value>some other layout from /WEB-INF/portal-layouts.xml</value>
       </property>
       <property>
       <name>org.jboss.portal.property.strategy</name>
       <value>some other strategy from /WEB-INF/layout/portal-strategies.xml</value>
       </property>
       <property>
       <name>org.jboss.portal.property.renderSet</name>
       <value>some other render set from /WEB-INF/layouts/portal-renderSet.xml</value>
       </property>
       <property>
       <name>org.jboss.portal.property.theme</name>
       <value>some other theme from /WEB-INF/portal-themes.xml</value>
       </property>
       -->
       </properties>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>CatalogPortletWindow</window-name>
       <instance-ref>CatalogPortletInstance</instance-ref>
       <region>left</region>
       <height>0</height>
       </window>
       <window>
       <window-name>ThemeSelectorWindow</window-name>
       <instance-ref>ThemeSelectorInstance</instance-ref>
       <region>left</region>
       <height>1</height>
       </window>
       <window>
       <window-name>ContentRewriteWindow</window-name>
       <instance-ref>ContentRewriteInstance</instance-ref>
       <region>left</region>
       <height>2</height>
       </window>
       <window>
       <window-name>HeaderContentWindow</window-name>
       <instance-ref>HeaderContentInstance</instance-ref>
       <region>left</region>
       <height>3</height>
       </window>
       <window>
       <window-name>HintPortletWindow</window-name>
       <instance-ref>HintPortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       <properties>
       <!-- turn the decoration off for this portlet (i.e. no title and mode/state links) -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>WsrpSelectorTestWindow</window-name>
       <instance-ref>WsrpSelectorTestPortletInstance</instance-ref>
       <region>center</region>
       <height>1</height>
       </window>
       </page>
       <page>
       <page-name>theme selector</page-name>
       <window>
       <window-name>NavigationPortletWindow</window-name>
       <instance-ref>NavigationPortletInstance</instance-ref>
       <region>navigation</region>
       <height>0</height>
       <!-- keep portal and page properties for this window -->
       <properties>
       <!-- use the window renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.windowRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the decoration renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.decorationRendererId</name>
       <value>emptyRenderer</value>
       </property>
       <!-- use the portlet renderer from the emptyRenderer renderSet -->
       <property>
       <name>theme.portletRendererId</name>
       <value>emptyRenderer</value>
       </property>
       </properties>
       </window>
       <window>
       <window-name>CatalogPortletWindow</window-name>
       <instance-ref>CatalogPortletInstance</instance-ref>
       <region>left</region>
       <height>0</height>
       </window>
       <window>
       <window-name>ThemePortletWindow</window-name>
       <instance-ref>ThemePortletInstance</instance-ref>
       <region>center</region>
       <height>0</height>
       </window>
       </page>
       </page>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>TestPortletInstance</instance-name>
       <component-ref>samples.TestPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>CounterPortletInstance</instance-name>
       <component-ref>samples.CounterPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>CachedCounterPortletInstance</instance-name>
       <component-ref>samples.CachedCounterPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>PortletSessionPortletInstance</instance-name>
       <component-ref>samples.PortletSessionPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>CharsetPortletInstance</instance-name>
       <component-ref>samples.CharsetPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>ExceptionPortletInstance</instance-name>
       <component-ref>samples.ExceptionPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>MissingPortletInstance</instance-name>
       <component-ref>samples.MissingPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>PreferencesPortletInstance</instance-name>
       <component-ref>samples.PreferencesPortlet</component-ref>
       <preferences>
       <preference>
       <name>one</name>
       <value>1.5</value>
       </preference>
       <preference>
       <name>two</name>
       <value>2.5</value>
       <value>3.5</value>
       <value></value>
       <value>4.5</value>
       <read-only>true</read-only>
       </preference>
       <preference>
       <name>three</name>
       <value>3.5</value>
       <read-only>true</read-only>
       </preference>
       </preferences>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>PortletAInstance</instance-name>
       <component-ref>samples.PortletA</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>PortletBInstance</instance-name>
       <component-ref>samples.PortletB</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>HeaderContentInstance</instance-name>
       <component-ref>samples.HeaderContentPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>ContentRewriteInstance</instance-name>
       <component-ref>samples.ContentRewritePortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>SecuredTestPortletInstance</instance-name>
       <component-ref>samples.SecuredTestPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>HintPortletInstance</instance-name>
       <component-ref>samples.HintPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>WsrpSelectorTestPortletInstance</instance-name>
       <component-ref>samples.WsrpSelectorTestPortlet</component-ref>
       </instance>
       </deployment>
       <deployment>
       <if-exists>keep</if-exists>
       <instance>
       <instance-name>CMSPortletInstance</instance-name>
       <component-ref>portal.CMSPortlet</component-ref>
       </instance>
       </deployment>
      </deployments>
      
      


        • 1. Re: Cannot see Management and CMS portlet
          Thomas Heute Master

          You should see them if you could connect as the admin user.

          Check that it exists in the database. It should have been pushed to your database during the first startup.

          If you don't see it in the database you can try to drop and recreate your database. To drop it, simply delete the folder server/default/data/portal

          Then check the log at startup

          • 2. Re: Cannot see Management and CMS portlet
            Praveen Cheruvu Newbie

            Thanks for the reply. I deleted the protal folder in data directory and idid the start-up again (by running run.bat). but no help.

            I am using mysql databases. Tables are created, but all the tables are empty.( i.e jbp_users, jbp_roles, jbp_cms_cmsentry).

            I checked the log and found nothing suspicious excpet
            [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors where hibernate related sql statement are logged.

            Can you please throw some light.

            thanks

            • 3. Re: Cannot see Management and CMS portlet
              Roy Russo Master

              Using mysql5? http://wiki.jboss.org/wiki/Wiki.jsp?page=AvoidMySQL5DataTruncationErrors

              "portalgeek" wrote:
              Can you please throw some light.


              If I could throw light, they would call me a Sun-God.

              • 4. Re: Cannot see Management and CMS portlet
                Praveen Cheruvu Newbie

                Yes, using mySql 5.0.24a. I have the checked the wiqi url you have provided.

                Removed the "STRICT_TRANS_TABLES", connection-url already had jdbcCompliantTruncation=false

                Then re-ran the run.bat. no help.

                Still the tables are empty. I cannot login as admin/admin (username/password) into portal and cannot see the cms and management tabs.

                Please help.

                thank you

                • 5. Re: Cannot see Management and CMS portlet
                  gumreal Newbie

                  please change the field type to tinyint(1), and try again:)
                  Hibernate maps the java Boolean data to bit(1) in MySQL, which should uses tinyint(1) as the type.
                  There are 4 fields need to change:
                  alter table jbp_instance modify modifiable tinyint(1) not null;
                  alter table jbp_portlet_state_entry modify read_only tinyint(1) not null;
                  alter table jbp_users modify jbp_viewrealemail tinyint(1);
                  alter talbe jbp_users modify jbp_enabled tinyint(1);

                  • 6. Re: Cannot see Management and CMS portlet
                    Praveen Cheruvu Newbie

                    Thank you for the response. I have changed the fields in jbp_users, but i do not have jbp_portal_state_entry in my database ( i do not why ?). Even in the jbp_instance table i do not have field 'modifiable'. Below are the tables present in my database and decripition of jbp_instance table.

                    The problem still presists

                    Please help.

                    mysql> show tables;
                    +-------------------------+
                    | Tables_in_jbossportal |
                    +-------------------------+
                    | jbp_cms_cmsentry |
                    | jbp_cms_repositoryentry |
                    | jbp_cms_version_binval |
                    | jbp_cms_version_node |
                    | jbp_cms_version_prop |
                    | jbp_cms_version_refs |
                    | jbp_cms_versionentry |
                    | jbp_cms_wsp_binval |
                    | jbp_cms_wsp_node |
                    | jbp_cms_wsp_prop |
                    | jbp_cms_wsp_refs |
                    | jbp_context |
                    | jbp_instance |
                    | jbp_instance_pref |
                    | jbp_instance_pref_value |
                    | jbp_object_node |
                    | jbp_page |
                    | jbp_portal |
                    | jbp_portal_mode |
                    | jbp_portal_object |
                    | jbp_portal_object_props |
                    | jbp_portal_window_state |
                    | jbp_role_membership |
                    | jbp_roles |
                    | jbp_security_constraint |
                    | jbp_security_policy |
                    | jbp_user_pref |
                    | jbp_user_pref_set |
                    | jbp_user_pref_value |
                    | jbp_user_prefs_group |
                    | jbp_user_prop |
                    | jbp_users |
                    | jbp_window |
                    +-------------------------+
                    33 rows in set (0.09 sec)
                    
                    mysql> describe jbp_instance;
                    +---------------+--------------+------+-----+---------+----------------+
                    | Field | Type | Null | Key | Default | Extra |
                    +---------------+--------------+------+-----+---------+----------------+
                    | PK | bigint(20) | NO | PRI | NULL | auto_increment |
                    | ID | varchar(255) | NO | UNI | | |
                    | COMPONENT_REF | varchar(255) | YES | | NULL | |
                    +---------------+--------------+------+-----+---------+----------------+
                    3 rows in set (0.02 sec)
                    


                    thanks

                    • 7. Re: Cannot see Management and CMS portlet
                      Praveen Cheruvu Newbie

                      gumreal,

                      BTW, I am using JBoss AS 4.0.4 GA+ JBossPortal 2.2 bundle.

                      thanks

                      • 8. Re: Cannot see Management and CMS portlet
                        gumreal Newbie

                        I am using JBoss AS 4.0.4 GA + JBossPortal 2.4 GA.
                        Maybe there are some differences between JBossPortal2.2 and JBossPortal2.4.
                        When I used JBossAS4.0.4+JBossPortal2.4 bundle, and use the default HSQL as DBMS, there was no problem.
                        When I changed the DBMS to MySQL, many exceptions occered.
                        First, I changed 4 fields as you have seen, then, I insert some data(user/role) in db, finally, no exceptions occered.

                        
                        INSERT INTO JBP_ROLES VALUES(1,'Admin','Administrators');
                        INSERT INTO JBP_ROLES VALUES(2,'User','Users');
                        INSERT INTO JBP_USERS VALUES(1,'admin',NULL,NULL,'21232f297a57a5a743894a0e4a801fc3','admin@portal.com',NULL,'2006-09-24',TRUE,TRUE);
                        INSERT INTO JBP_USERS VALUES(2,'user',NULL,NULL,'ee11cbb19052e40b07aac0ca060c23ee','user@portal.com',NULL,'2006-09-24',TRUE,TRUE);
                        INSERT INTO JBP_ROLE_MEMBERSHIP VALUES(1,1);
                        INSERT INTO JBP_ROLE_MEMBERSHIP VALUES(2,2);
                        



                        • 9. Re: Cannot see Management and CMS portlet
                          Praveen Cheruvu Newbie

                          gumreal,

                          Thanks a bunch. Atleast now i can see the tabs (i.e CMS manager and Management). I guess the roles and users information was missing.

                          Thanks again.