Re: [SOGo] how to verify currently running database version

2012-10-02 Thread Christian Mack
On 2012-10-01 15:16, mayak-cq wrote:
 On Mon, 2012-10-01 at 15:11 +0200, Christian Mack wrote:
 Hello mayak
 On 2012-09-29 14:34, mayak-cq wrote:
  
  Just wondering how I can tell what database version sogo is using.
  

 Which DBMS do you use?
 MySQL, Postgresql or Oracle?

 You can check your access parameters as user sogo with:
 defaults read sogod OCSSessionsFolderURL
 defaults read sogod SOGoProfileURL
 defaults read sogod OCSFolderInfoURL

 And if you use a DBMS as authorization source with:
 defaults read sogod SOGoUserSources

 hi christian,
 
 sorry -- i should have been more specific --
 
 i'm running mysql, but i have upgraded and downgraded so many times,
 that i'm not sure if i have the right database structure to match my
 sogo version.
 

In order to be absolutely sure just make a full backup with sogo-tool.
Then stop sogod.
Drop all SOGo tables in MySQL.
Then start sogod and restore your backup.

When you start sogod, it will create all tables for this given version
of SOGo.

Beware:
This does _not_ include your authorization database!


Kind regards,
Christian Mack

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universit├Ąt Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] how to verify currently running database version

2012-10-01 Thread Christian Mack
Hello mayak
On 2012-09-29 14:34, mayak-cq wrote:
 
 Just wondering how I can tell what database version sogo is using.
 

Which DBMS do you use?
MySQL, Postgresql or Oracle?

You can check your access parameters as user sogo with:
defaults read sogod OCSSessionsFolderURL
defaults read sogod SOGoProfileURL
defaults read sogod OCSFolderInfoURL

And if you use a DBMS as authorization source with:
defaults read sogod SOGoUserSources


Kind regards,
Christian Mack

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universit├Ąt Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] how to verify currently running database version

2012-10-01 Thread mayak-cq
On Mon, 2012-10-01 at 15:11 +0200, Christian Mack wrote:

 Hello mayak
 On 2012-09-29 14:34, mayak-cq wrote:
  
  Just wondering how I can tell what database version sogo is using.
  
 
 Which DBMS do you use?
 MySQL, Postgresql or Oracle?
 
 You can check your access parameters as user sogo with:
 defaults read sogod OCSSessionsFolderURL
 defaults read sogod SOGoProfileURL
 defaults read sogod OCSFolderInfoURL
 
 And if you use a DBMS as authorization source with:
 defaults read sogod SOGoUserSources
 

hi christian,

sorry -- i should have been more specific --

i'm running mysql, but i have upgraded and downgraded so many times,
that i'm not sure if i have the right database structure to match my
sogo version.

thanks

m

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

[SOGo] how to verify currently running database version

2012-09-29 Thread mayak-cq
Hi All,

Just wondering how I can tell what database version sogo is using.

Thanks

M

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