Re: [SOGo] Migrate to combined database schema

[Martin LEUSCH]

Thanks, it's working fine now.

Martin Leusch
Service Technique IMEREOS
sce.t...@imereos.fr

Le 17/06/2016 17:37, Ludovic Marcotte (lmarco...@inverse.ca) a écrit :


On 2016-06-17 11:31 AM, Martin LEUSCH (sce.t...@imereos.fr) wrote:

///OCSCacheURL = 
"mysql://openchange:///xxx/@127.0.0.1:3306/openchange/sogo_cache_folder";//

/


That one doesn't exist - it should be OCSCacheFolderURL.
--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu), PacketFence 
(http://packetfence.org) and Fingerbank (http://fingerbank.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migrate to combined database schema

[Ludovic Marcotte]

On 2016-06-17 11:31 AM, Martin LEUSCH (sce.t...@imereos.fr) wrote:

///OCSCacheURL = 
"mysql://openchange:///xxx/@127.0.0.1:3306/openchange/sogo_cache_folder";//

/


That one doesn't exist - it should be OCSCacheFolderURL.

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu), PacketFence 
(http://packetfence.org) and Fingerbank (http://fingerbank.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Migrate to combined database schema

[Martin LEUSCH]

Hi,

I used the script sql-update-3.0.0-to-combined-mysql.sh to migrate to 
the new database schema.

Since, the calendars and addresses book are unusable. I've errors like this:

   /Jun 17 16:35:42 sogod [8891]:
   [ERROR]<0x7f1f925bd890[SOGoAppointmentFolder]:4832-57455A00-1-356FEC40>
   (-[SOGoAppointmentFolder
   
fetchFields:from:to:title:comp//onent:additionalFilters:includeProtectedInformation:]):
   missing folder for fetch!
   /

Now I have these databases settings in sogo.conf:

   /SOGoProfileURL =
   "mysql://openchange:xxx@localhost/openchange/sogo_user_profile";//
   //OCSFolderInfoURL =
   "mysql://openchange:///xxx/@localhost/openchange/sogo_folder_info";//
   //OCSCacheURL =
   
"mysql://openchange:///xxx/@127.0.0.1:3306/openchange/sogo_cache_folder";//
   //OCSStoreURL =
   "mysql://openchange:///xxx/@127.0.0.1:3306/openchange/sogo_store";//
   //OCSAclURL =
   "mysql://openchange:///xxx/@127.0.0.1:3306/openchange/sogo_acl";//
   //OCSSessionsFolderURL =
   
"mysql://openchange:///xxx/@localhost/openchange/sogo_sessions_folder";
   /

I followed steps describe here 
 in this 
mailing list. I had to make some adjustments, the script can't parse my 
sogo.conf file (may be because I have some special chars in my mysql 
password).


Which database URL I supposed to have in sogo.conf and which tables I 
supposed to have in my database?


The server is in testing for now so I don't care about user data but it 
will be in production soon.


--
Martin Leusch
sce.t...@imereos.fr

--
users@sogo.nu
https://inverse.ca/sogo/lists