-
1. Re: Quirky Behavior of Jackrabbit CMS?
theute May 11, 2007 2:34 PM (in response to david.hoffman)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) -
2. Re: Quirky Behavior of Jackrabbit CMS?
david.hoffman May 14, 2007 9:15 AM (in response to 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. -
3. Re: Quirky Behavior of Jackrabbit CMS?
theute May 14, 2007 9:59 AM (in response to david.hoffman)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 ? -
4. Re: Quirky Behavior of Jackrabbit CMS?
david.hoffman May 16, 2007 4:08 PM (in response to 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. -
5. Re: Quirky Behavior of Jackrabbit CMS?
david.hoffman May 16, 2007 4:15 PM (in response to 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. -
6. Re: Quirky Behavior of Jackrabbit CMS?
david.hoffman May 16, 2007 4:23 PM (in response to 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. -
7. Re: Quirky Behavior of Jackrabbit CMS?
soshah May 16, 2007 5:53 PM (in response to david.hoffman)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 -
8. Re: Quirky Behavior of Jackrabbit CMS?
david.hoffman May 17, 2007 9:13 AM (in response to 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...
-
9. Re: Quirky Behavior of Jackrabbit CMS?
soshah May 17, 2007 9:26 AM (in response to david.hoffman)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 -
10. Re: Quirky Behavior of Jackrabbit CMS?
david.hoffman May 17, 2007 10:06 AM (in response to 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 -
11. Re: Quirky Behavior of Jackrabbit CMS?
czhao07 May 17, 2007 12:47 PM (in response to david.hoffman)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? -
12. Re: Quirky Behavior of Jackrabbit CMS?
david.hoffman May 17, 2007 1:01 PM (in response to david.hoffman)I am using mysql-connector-java-5.0.4-bin.jar and MySQL 5.0.22-community-nt
-
13. Re: Quirky Behavior of Jackrabbit CMS?
soshah May 17, 2007 2:17 PM (in response to david.hoffman)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 -
14. Re: Quirky Behavior of Jackrabbit CMS?
czhao07 May 18, 2007 7:29 PM (in response to david.hoffman)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.