[Building Sakai] MySql binary files to File Server hosting conversion

[Nawaz Azam]

Hello,

 

               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.

http://confluence.sakaiproject.org/display/DOC/Configuring+Content+Hosti
ng

 

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.

 

 

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

http://TheServerURL/access/content/group/bf153352-cd4d-40db-bc72-803875b
359d7/default%201%20Glossary.zip

 

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

 

************************************************************************
*******************************************

 

 

 

I decided to change the path outside of tomcat.

 

   --this time I tried different, outside of tomcat. Made sure the
read/write permissions were there.

 

bodyPath at org.sakaiproject.content.api.ContentHostingService =
/opt/content/

 

bodyVolumes at org.sakaiproject.content.api.ContentHostingService =
vol1,vlo2,vol3

 

convertToFile at org.sakaiproject.content.api.ContentHostingService = true

 

 

It created the folders itself . It again only created 3 files and I get
"WARN: convertToFile: null xml : /group/PortfolioAdmin../.." errors in
Catalina.out file.  Please guide me in the right direction. I really
appreciate you help with this matter.  If you have been through this
process, please share you experience.

 

 

 

Thanks,

Nawaz.

 

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> 

                           

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100308/5648ead1/attachment.html