Re: [SOGo] how to verify currently running database version
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
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
Re: [SOGo] how to verify currently running database version
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
[SOGo] how to verify currently running database version
Hi All, Just wondering how I can tell what database version sogo is using. Thanks M -- users@sogo.nu https://inverse.ca/sogo/lists