Quirky Behavior of Jackrabbit CMS?

[david.hoffman]

I have no doubt that this is most likely a configuration issue on my part.

I am using jboss-portal-2.6-CR2-bundled configured to work with MySQL 5.0

If I create content through the CMS console, I see that content and can access it through a CMSPortletInstance.

However, if I shutdown the portal and restart it, my content goes away. Can someone comment on this or point me in a direction regarding possible misconfigurations on my part?

[theute]

The content goes away from the CMS ? You can't see it in the CMS admin portlet anymore ?

I just tried to make sure, no issue (wih MySQL 5)

[david.hoffman]

Thats correct. It is as if I never had created any content at all when I restart the portal.

I can forward all my configs if you think that you could help me figure it out.

[theute]

Did you check the console for any error when creating the content ?

This seems very odd to me.

Is that out of the box ? Everything else is working fine like adding portal pages ?

[david.hoffman]

Well the good news is, it is actually writing it into the MySQL Database, the bad news is that even though my user is in the portal role "Admin" I am unable to view the content in the CMSAdmin Portlet.

I know it is in the database because I can see it in a diff of SQL dumps. I see my content in the jbp_cms_version_binval table of the MySQL database.

I am continuing to look for something that may describe why I cannot see this content even though I am in the Admin role. Should you be able to point me to some specific place to look, that would be of great help.

Thanks again in advance.

[david.hoffman]

I did forget to respond to your question. This is a stock jboss-portal-2.6-CR2-bundled with necessary modifications to make it use MySQL as the datasource.

There are no errors/stacktraces thrown when creating content.

It has no problem creating and maintaining persistence of pages and subpages. The only problem at this point seems to be around CMS.

[david.hoffman]

All of the jbp_cms* tables contain data with the exception of:

jbp_cms_cmsentry
jbp_cms_perm_user
jbp_cms_wsp_refs

The above mentioned tables are completely empty even though all fo teh content I have created thus far exists in the other tables.

[soshah]

David-

Do you get a "Access Denied" message in the CMSAdmin tool or just an empty listing of your content.

Basically, what does your CMSAdmin Tool look like?

Thanks

[david.hoffman]

After a restart, the only content I am seeing is the content that is created out of the box when you start up the portal for the first time...

[soshah]

David-

This seems like a database related issue. Although it has been tested for mysql5. I personally develop on mysql5 and hsqldb, so its not that mysql5 is not supported.

Try this:

1/ Try running your portal with hsqldb. To do this swap out your portal datasource to use the hsqldb one and make sure before restarting portal, you delete {your_server_config}/data,{your_server_config}/log,{your_server_config}/tmp,{your_server_config}/work
for clean install

2/Upgrade your mysql5 JDBC driver and see if that makes any difference

Thanks

[david.hoffman]

I have already proven that all is well with the HSQLDB implementation (i.e. it functions as one would expect it to) unfortunately the use of HSQLDB is not an option in my environment.

I am using the latest production release JDBC driver for MySQL5.

I have no doubt this is a configuration issue I may have missed. Can someone point me toward specific configuration files that I can provide which may shed some light on the matter.

To recap:

I am able to see new content in the CMSAdmin portlet, and in instances that are configured to point to it, so long as I don't restart. Once I restart all new data appears to be gone (from a UI perspective). I have confirmed that the content does in fact exist inside the database (after a restart), however the CMSAdmin porlet does not display it. Additionally any instance configured to display the content is showing a message:

404 - Page Not Found
Oops! We can't really find the resource you're looking for.

I am running "jboss-portal-2.6-CR2-bundled" against a mySQL5 database. The portal is working fine, all functions as expected with the exception of the CMS Functionality

[czhao07]

I am also using MySQL 5.0 and have similiar issues. I don't have the problem consistently. Once a while, some of the files or file versions are missing after the server restart.

I am using MySQL 5.0.37 and MySQL Connector/J 5.0.5. What versions do you guys use in development?

[david.hoffman]

I am using mysql-connector-java-5.0.4-bin.jar and MySQL 5.0.22-community-nt

[soshah]

the mysql database driver I am using for development is:

mysql-connector-java-3.1.4-beta-bin.jar

and mysql database version is: 5.0.27

Thanks

[czhao07]

I finally fixed my problem. In my case, I was trying to to use CMS to store the documents programmatically, and within the same transaction, I also use AuthorizationProvider to set the fine grained permissions on the documents.

But obviously CMS and AuthorizationProvider don't work well together within the same transaction. Because after I changed my code to call them in separate transactions, it all worked.