Re: [SOGo] How do I know which update script I have to call?

2016-04-30 Thread Steve Ankeny

hmm

You stated originally --

For example: I just
updated and I'm now on 2.3.1. I don't know if I have to call the script
"sql-update-2.2.17_to_2.3.0-mysql.sh".


So, that means you were on v. 2.3.0 and shouldn't need the upgrade script.

The update script upgrades from 2.2.17 to 2.3.0, so IF you were on 
2.3.0, you do not need the script.


However, check "/etc/sogo/sogo.conf" for the lines --


SOGoProfileURL =
"postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile";
OCSFolderInfoURL =
"postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder";


Yours probably read --


SOGoProfileURL =
"mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder";


That would tell you to call the "sql-update-2.2.17_to_2.3.0-mysql.sh" 
script, and as I stated earlier, it does not harm the installation for 
you to call it AGAIN (IF you're unsure or IF something doesn't work 
correctly)


So, no update script is required, but IF you're unsure or IF something 
doesn't work, call the MySQL script.


On 04/30/2016 09:27 AM, Michael Vogel (ica...@dabo.de) wrote:

Am 29.04.16 um 16:21 schrieb Steve Ankeny (stev...@cinergymetro.net):

read pg 58-59 of the documentation

It only tells:

"This section describes what needs to be done when upgrading to the
current version of SOGo from the previous release."

For example: When I'm not totally sure that my previous version was
version 2.3.0 and not 2.2.8 then I don't have a clue if I have to call
the script or not.


If it was working before upgrade, no script is needed.

Is it called automatically during the upgrade or why wouldn't the script
beeing needed in that case?

Michael



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

Re: [SOGo] How do I know which update script I have to call?

2016-04-30 Thread Michael Vogel
Am 29.04.16 um 16:21 schrieb Steve Ankeny (stev...@cinergymetro.net):
> read pg 58-59 of the documentation

It only tells:

"This section describes what needs to be done when upgrading to the
current version of SOGo from the previous release."

For example: When I'm not totally sure that my previous version was
version 2.3.0 and not 2.2.8 then I don't have a clue if I have to call
the script or not.

> If it was working before upgrade, no script is needed.

Is it called automatically during the upgrade or why wouldn't the script
beeing needed in that case?

Michael



signature.asc
Description: OpenPGP digital signature


Re: [SOGo] How do I know which update script I have to call?

2016-04-29 Thread Steve Ankeny

I'm sorry!  I responded a bit too quickly.

IF you're using PostgreSQL, run 'sql-update-2.2.17_to_2.3.0.sh'

IF you're using MySQL, run 'sql-update-2.2.17_to_2.3.0-mysql.sh'

IF you're not sure which one you're running, running BOTH will not hurt 
your installation.


or, simply run something like, 'ps aux | grep mysql' to see if MySQL is 
being used


On 04/29/2016 10:22 AM, Steve Ankeny (stev...@cinergymetro.net) wrote:

better yet, just run them

IF they're needed, they will execute, and IF not, they'll do nothing.

On 04/29/2016 08:22 AM, Michael Vogel (ica...@dabo.de) wrote:

Hi!

Sometimes there seems to be a need to run database update scripts after
SOGo was updated. My problem is that I never know if or which of theses
scripts I had to call.

Mostly I really don't know the old SOGo version. For example: I just
updated and I'm now on 2.3.1. I don't know if I have to call the script
"sql-update-2.2.17_to_2.3.0-mysql.sh".

Is there any script that I haven't found by now that simply does a check
for the current database schema and does all needed changes?

Michael






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


Re: [SOGo] How do I know which update script I have to call?

2016-04-29 Thread Steve Ankeny

read pg 58-59 of the documentation

If it was working before upgrade, no script is needed.

On 04/29/2016 08:22 AM, Michael Vogel (ica...@dabo.de) wrote:

Hi!

Sometimes there seems to be a need to run database update scripts after
SOGo was updated. My problem is that I never know if or which of theses
scripts I had to call.

Mostly I really don't know the old SOGo version. For example: I just
updated and I'm now on 2.3.1. I don't know if I have to call the script
"sql-update-2.2.17_to_2.3.0-mysql.sh".

Is there any script that I haven't found by now that simply does a check
for the current database schema and does all needed changes?

Michael



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


[SOGo] How do I know which update script I have to call?

2016-04-29 Thread Michael Vogel
Hi!

Sometimes there seems to be a need to run database update scripts after
SOGo was updated. My problem is that I never know if or which of theses
scripts I had to call.

Mostly I really don't know the old SOGo version. For example: I just
updated and I'm now on 2.3.1. I don't know if I have to call the script
"sql-update-2.2.17_to_2.3.0-mysql.sh".

Is there any script that I haven't found by now that simply does a check
for the current database schema and does all needed changes?

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