Changes

From SME Server
Jump to navigationJump to search
384 bytes removed ,  10:54, 29 September 2008
Store_attachment
Line 11: Line 11:     
  yum localinstall libvmime*.rpm libical*.rpm zarafa-6*.rpm zarafa-webaccess-6*.rpm
 
  yum localinstall libvmime*.rpm libical*.rpm zarafa-6*.rpm zarafa-webaccess-6*.rpm
  −
===Create the Database===
  −
  −
mysqladmin create zarafa
  −
mysql -e "grant all privileges on zarafa.* to zarafa@localhost identified by 'yourpassword'"
  −
mysql -e "flush privileges"
      
===Zarafa config files===
 
===Zarafa config files===
Line 27: Line 21:  
   user_plugin        = unix
 
   user_plugin        = unix
 
   user_plugin_config = /etc/zarafa/unix.cfg
 
   user_plugin_config = /etc/zarafa/unix.cfg
 +
 +
  attachment_storage      = files
 +
  attachment_path        = /home/e-smith/files/zarafa
 +
 +
+ mkdir /home/e-smith/files/zarafa
    
  nano /etc/zarafa/unix.cfg
 
  nano /etc/zarafa/unix.cfg
Line 88: Line 87:     
  /etc/e-smith/events/actions/qmail-update-user
 
  /etc/e-smith/events/actions/qmail-update-user
 +
 +
===Create the Database===
 +
mysqladmin create zarafa
 +
mysql -e "grant all privileges on zarafa.* to zarafa@localhost identified by 'yourpassword'"
 +
mysql -e "flush privileges"
    
===Other tasks===
 
===Other tasks===
Line 152: Line 156:     
====Store_attachment_outside_of_the_database====
 
====Store_attachment_outside_of_the_database====
http://zarafa.com/wiki/index.php/Store_attachment_outside_of_the_database
+
Early wiki instructions stored attachments in mysql, if you just edit the config file zarafa may fail to start and you get this error  
 
  −
mkdir /home/e-smith/files/zarafa
  −
 
  −
nano /etc/zarafa/server.cfg
  −
  attachment_storage      = files
  −
  attachment_path        = /home/e-smith/files/zarafa
  −
 
  −
But zarifa fails to start with log error
  −
Mon 29 Sep 2008 12:28:29 AM EST: Connection to database 'zarafa' succeeded
  −
Mon 29 Sep 2008 12:28:29 AM EST: zarafa-licensed not running, commercial features will not be available
   
  Mon 29 Sep 2008 12:28:29 AM EST: Attachments are stored with option 'database', but 'files' is selected.
 
  Mon 29 Sep 2008 12:28:29 AM EST: Attachments are stored with option 'database', but 'files' is selected.
Mon 29 Sep 2008 12:28:29 AM EST: Server shutdown complete.
     −
this moves attachments, still have error
+
One way to fix is by dropping the database (this deletes your mail), and recreating the database with the server.cfg setting set to files.
perl /usr/share/zarafa/db-convert-attachments-to-files zarafa zarafamysqlpwd zarafa /home/e-smith/files/zarafa delete
  −
  Finding all attachments...
  −
  Processing 9 attachments
  −
  Done.
  −
  Deleting attachments from database...
  −
  Done.
      
====.qmail fragment====
 
====.qmail fragment====

Navigation menu