[Deploying Sakai] MySql binary to File Server Conversion

Nawaz Azam nazam at ccsnh.edu
Fri Mar 5 07:29:29 PST 2010

Hello Steve,
  Thank for the reply.
sakai.home = /opt/tomcat/sakai/
it did create the directories there and content folder as well by itself. 
   for the 404 error this is one of  the url
Just for now as a test I have given permissions to everyone to write to the directory /opt and all the contents inside it. Please note if I save any new resources those are showing up there now and work fine. The problem is with old blob data that is in Content_resource_body_binary table. I looked through the catalina.out file and found the following. It seems to be looking for the xml files while may be it should look for blobs to convert to files.
INFO: Migration of data to the Binary format will be performed by this node  (2010-03-04 08:40:59,683 main_org.sakaiproject.content.impl.DbContentService)
Conversion of the ContentHostingService database tables is complete.
Using new filesize column
 (2010-03-04 08:40:59,748 main_org.sakaiproject.content.impl.DbContentService)
INFO: init(): site quota: 1048576 body path: /opt/tomcat/sakai//content volumes: /files,  (2010-03-04 08:40:59,861 main_org.sakaiproject.content.impl.BaseContentService)
INFO: convertToFile (2010-03-04 08:40:59,996 main_org.sakaiproject.content.impl.DbContentService)
WARN: convertToFile: null xml : /group/PortfolioAdmin/system/twoColumn.xml (2010-03-04 08:41:00,066 main_org.sakaiproject.content.impl.DbContentService)
WARN: convertToFile: null xml : /group/PortfolioAdmin/system/freeFormRenderer.xml (2010-03-04 08:41:00,066 main_org.sakaiproject.content.impl.DbContentService)


From: Steve Swinsburg [mailto:steve.swinsburg at gmail.com]
Sent: Thu 3/4/2010 4:49 PM
To: Nawaz Azam
Cc: production at collab.sakaiproject.org
Subject: Re: [Deploying Sakai] MySql binary to File Server Conversion

What is the value of your sakai.home variable?

It's possible you need a slash between it and the directory so that the files are written out correctly, although it did create the directories...
e.g. bodyPath at org.sakaiproject.content.api.ContentHostingService = ${sakai.home}/content

Are the permissions set correctly so that the Tomcat user can write there?

Also, what is the URL of the files that give a 404 (you can omit the server name).


On 05/03/2010, at 1:19 AM, Nawaz Azam wrote:

	Hello Everyone,
	               We have an instance of Sakai 2.5.3 on Centos(5.4) and MySql version 5.0.45 on another Centos(5.4). The database is getting larger( 1.5 GB) so for  and I found out that it would be better to store content into the file server rather than blobs in the database.  There is plenty(400 GB)  of space on file server.  I followed the directions on the following page.
	these are the steps I took.
	bodyPath at org.sakaiproject.content.api.ContentHostingService = ${sakai.home}content
	bodyVolumes at org.sakaiproject.content.api.ContentHostingService = /files
	convertToFile at org.sakaiproject.content.api.ContentHostingService = true
	The webapp works fine. When you go to the resources of anyone of the many course sites the file names show up but your get error 404 when you click on it. I checked the file folder and it was only 128K. Which I was expecting  to be atleast 300MB or more. I am attaching some file server screen shots may be help to see what is wrong.
	I greatly appreciate your help with this matter.
	Nawaz Azam
	Technical Support Specialist
	Manchester Community College
	1066 Front Street, Manchester, NH 03102
	Work. (603) 668-6706 ext. 313
	Cell.    (603) 396-1356

	nazam at ccsnh.edu <mailto:nazam at ccsnh.edu> 

	Opportunities. For Now ... For Life
	www.manchestercommunitycollege.edu <http://www.manchestercommunitycollege.edu/> 
	production mailing list
	production at collab.sakaiproject.org
	TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100305/87198219/attachment-0001.html 

More information about the production mailing list