Koozali.org: home of the SME Server

eGroupware upgrade to 1.4

Offline cool34000

  • *
  • 339
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #60 on: October 22, 2007, 04:51:01 PM »
Hi,


You can find your existing version of eGW by launching the application... You will know if it's 1.4.001 or 1.4.002 in the homepage
Quote
Powered by eGroupWare Version 1.4.002


Else you can check your installed version with this command:
Code: [Select]
# rpm -qa | grep egroupwareAnd use this quick guide:
=> Followings RPMs uses eGW v1.4.002 and are directly updatable:
  • smeserver-egroupware-1.4.002-2
  • smeserver-egroupware-1.4.002-1

=> Followings RPMs uses eGW v1.4.002 and need a fix (uninstall with rpm -e --noscripts before updating)
  • smeserver-egroupware-1.4-10
  • smeserver-egroupware-1.4-9

=> Followings RPMs uses eGW v1.4.001 or v1.4 and need a fix (uninstall with rpm -e --noscripts)
=> As these RPMs use an older version of eGW, you have an extra step which is to upgrade your existing install in Setup/Admin Config (as described in the wiki)
  • smeserver-egroupware-1.4-8
  • smeserver-egroupware-1.4-7
  • smeserver-egroupware-1.4-6
  • smeserver-egroupware-1.4-5
  • smeserver-egroupware-1.4-4


I've tested successfully updates from:
  • v1.4.002-1
  • v1.4-10
  • v1.4-9
  • v1.4-8
  • v1.4-6
I didn't test from other versions, the update process should work the same.


Regards,
Sylvain
« Last Edit: October 22, 2007, 04:53:39 PM by cool34000 »

Offline uniqsys

  • *
  • 133
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #61 on: October 23, 2007, 03:36:02 AM »
Sylvain,

I followed your Wiki instructions except I changed the
Code: [Select]
rpm -Uvh smeserver-egroupware-1.4.002-2.noarch.rpm
to
Code: [Select]
yum localinstall smeserver-egroupware-1.4.002-2.noarch.rpm.  The upgrade from 1.4.002-1 went OK to 1.4.002-2 with no loss of data and the instructions in 'Simple Application Management' were never asked or performed even upon logging in and looking for the Update button.  Everything seems OK.  Is this OK to do?  The prevailing advice  is to use yum localinstall whenever you can so updates can be tracked.  Do you think this is a good idea to do in this case?  I was just testing it as you had tested the direct route.  I might try it both ways to see what happens, but it appears to be OK for now.

Thanks,
Uniqsys
...

Offline cool34000

  • *
  • 339
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #62 on: October 23, 2007, 11:26:48 AM »
Hi,


You can use RPM or YUM to install eGW... It will do exactly the same things!
If there was no upgrade needed, then you were already in 1.4.002 version!!!

Offline cool34000

  • *
  • 339
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #63 on: October 27, 2007, 03:00:48 AM »
Hi,

I've made a new RPM with some improvements and minor bug fixes...
Gallery2 has been added (but you need to finish the install if you want to use it)
SME integration has been improved.

As usual, more informations on the Wiki:
http://wiki.contribs.org/Egroupware
http://wiki.contribs.org/Egroupware#Gallery2_addon

Offline ddougan

  • *
  • 151
  • +0/-0
    • http://www.DouganConsulting.com
Re: eGroupware upgrade to 1.4
« Reply #64 on: November 18, 2007, 01:29:13 AM »
I just tried to install the RPM on my fully-updated 7.2 test box. I had previously installed 1.2.x there, installed from tarball prior to an RPM being available. I mv'd the /opt/egroupware directory to /opt/egroupware.old prior to beginning; I've subsequently renamed the MySQL database, too.

However, I am getting an error in the RPM:

error: %pre(smeserver-egroupware-1.4.002-3.noarch) scriptlet failed, exit status 1
error:   install: %pre scriptlet failed (2), skipping smeserver-egroupware-1.4.002-3

This is whether I run rpm -Uvh or rpm -ivh, whether the original directory is there or not, so it looks like the smeserver-egroupware-1.4.002-3.noarch.rpm has an issue.

Is anyone else seeing this?

Des
Des Dougan

Offline cool34000

  • *
  • 339
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #65 on: November 18, 2007, 10:12:05 AM »
Hi,

As told in the wiki, this RPM can't update v1.2.x
http://wiki.contribs.org/Egroupware#Update.2FUpgrade

Offline ddougan

  • *
  • 151
  • +0/-0
    • http://www.DouganConsulting.com
Re: eGroupware upgrade to 1.4
« Reply #66 on: November 18, 2007, 06:39:20 PM »
Yes, I read that - hence renaming the original installation directory and then the MySQL database. As I noted, I get the error even when using rpm -i.


Des
Des Dougan

Offline cool34000

  • *
  • 339
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #67 on: November 20, 2007, 01:37:54 PM »
Hi,

Don't use rpm -i! -i is used for kernel install if I remember well...
Use rpm -U or better: yum localinstall

[Edit]
PS: If you want a new install of eGroupWare, just ensure that:
1) /opt/egroupware/ DOES'NT EXIST
2) MySQL database egroupware DOES'NT EXIST
3) MySQL user egwuser DOES'NT EXIST
« Last Edit: November 20, 2007, 01:45:00 PM by cool34000 »

Offline ddougan

  • *
  • 151
  • +0/-0
    • http://www.DouganConsulting.com
Re: eGroupware upgrade to 1.4
« Reply #68 on: November 27, 2007, 07:55:36 AM »
"rpm -i" just means "install" - "rpm -U" means "update".

So, on my test box I have:

1. Renamed the old egroupware MySQL database
2. Deleted the MySQL user
3. Renamed the egroupware directory in /opt

When I run yum localinstall, I see this:

# yum localinstall smeserver-egroupware-1.4.002-3.noarch.rpm
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Loading "smeserver" plugin
Loading "fastestmirror" plugin
Setting up Local Package Process
Examining smeserver-egroupware-1.4.002-3.noarch.rpm: smeserver-egroupware - 1.4.002-3.noarch
Marking smeserver-egroupware-1.4.002-3.noarch.rpm to be installed
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package smeserver-egroupware.noarch 0:1.4.002-3 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 smeserver-egroupware    noarch     1.4.002-3        smeserver-egroupware-1.4.002-3.noarch.rpm   27 M

Transaction Summary
=============================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)
Total download size: 27 M
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
smeserver trap pre-install: smeserver-egroupware
Updating eGroupware... Please wait!
Backup folder: /opt/eGW_RPM_BACKUP
Backing up installation files...
tar: egroupware: Cannot stat: No such file or directory
tar: Error exit delayed from previous errors
Backing up MySQL database...
mysqldump: Got error: 1049: Unknown database 'egroupware' when selecting the database
error: %pre(smeserver-egroupware-1.4.002-3.noarch) scriptlet failed, exit status 1
error:   install: %pre scriptlet failed (2), skipping smeserver-egroupware-1.4.002-3
Migrating existing database accounts
Migrating existing database networks
Migrating existing database mailpatterns
Migrating existing database domains
Migrating existing database hosts
Migrating existing database yum_installed
Migrating existing database backups
Migrating existing database configuration
Migrating existing database yum_updates
Migrating existing database spamassassin
Migrating existing database yum_available
Migrating existing database yum_repositories
smeserver trap post-install: smeserver-egroupware

Installed: smeserver-egroupware.noarch 0:1.4.002-3
Complete!
================================================================
No new rpms were installed. No additional commands are required.
================================================================

I re-downloaded the RPM to ensure it wasn't a bad download - the above is what transpired. It really looks as if this RPM is expecting a version to be installed already, and is failing when it can't find an existing database. Has anyone managed to install this version of the RPM on a system with no previous version?

Des
Des Dougan

Offline cool34000

  • *
  • 339
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #69 on: November 27, 2007, 08:32:38 AM »
Hi,

The RPM only backup when the folder /opt/egroupware can be found.
Please remove old install first (templates+files+DB)

Offline ddougan

  • *
  • 151
  • +0/-0
    • http://www.DouganConsulting.com
Re: eGroupware upgrade to 1.4
« Reply #70 on: November 27, 2007, 07:15:37 PM »
As you can see from the directory lists below, I have cleaned out the previous non-RPM version of eGroupWare. I still get the same failure when I run yum localinstall.

[root@blackadder opt]# l
total 25160
drwxr-xr-x   7 root root       4096 Nov 27 10:08 .
drwxr-xr-x  25 root root       4096 Nov 17 13:15 ..
drwxr-xr-x   3 root root       4096 May 21  2007 administration
drwxr-xr-x   4 root root       4096 Oct 18 15:55 ejabberd
drwxr-x---  10 jive jive       4096 Sep 20 16:15 openfire
drwxr-xr-x   4 zope shared     4096 Aug 13  2006 plone2
-rw-r--r--   1 root root   25701907 Oct 26 13:47 smeserver-egroupware-1.4.002-3.noarch.rpm
[root@blackadder opt]# l /var/lib/mysql/
total 20544
drwxr-xr-x   6 mysql mysql     4096 Nov 27 10:03 .
drwxr-xr-x  24 root  root      4096 Oct 15 09:50 ..
drwx------   2 mysql mysql     4096 Nov 17 13:16 horde
-rw-rw----   1 mysql mysql  5242880 Nov 17 15:59 ib_logfile0
-rw-rw----   1 mysql mysql  5242880 Jun  6 23:39 ib_logfile1
-rw-rw----   1 mysql mysql 10485760 Nov 17 15:59 ibdata1
drwx------   2 mysql mysql     4096 Nov 17 13:16 mysql
srwxrwxrwx   1 mysql mysql        0 Nov 17 13:16 mysql.sock
drwx------   2 mysql mysql     4096 Oct 18 16:59 openfiredb
drwx------   2 mysql mysql     4096 Jul 29  2006 test
[root@blackadder opt]# l /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
total 20
drwxr-xr-x  3 root root 4096 Nov 27 09:57 .
drwxr-xr-x  3 root root 4096 Jul  1  2006 ..
-rw-r--r--  1 root root  874 Jul  1  2006 86PhpmyadminmultiAlias
-rw-r--r--  1 root root  299 Oct 18 16:46 99openfire
drwxr-xr-x  2 root root 4096 Nov 27 10:04 VirtualHosts
[root@blackadder opt]# l /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts/
total 8
drwxr-xr-x  2 root root 4096 Nov 27 10:04 .
drwxr-xr-x  3 root root 4096 Nov 27 09:57 ..
Des Dougan

Offline uniqsys

  • *
  • 133
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #71 on: November 27, 2007, 11:54:28 PM »
..... Has anyone managed to install this version of the RPM on a system with no previous version?

Des

Hi Des,

Yes, I have with success.  I started with a test box with AFFA running on it otherwise an out-of-the-box installation.  Sorry I can't help more.
...

Offline thomasch

  • *
  • 232
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #72 on: November 28, 2007, 03:58:23 AM »
As you can see from the directory lists below, I have cleaned out the previous non-RPM version of eGroupWare. I still get the same failure when I run yum localinstall.

[cut]

maybe you have to delete db keys from previous invalid install

Quote
config show egroupware

Quote
config delete egroupware


Offline ddougan

  • *
  • 151
  • +0/-0
    • http://www.DouganConsulting.com
Re: eGroupware upgrade to 1.4
« Reply #73 on: November 28, 2007, 04:05:52 AM »
Thanks for your suggestion; however, there aren't any keys set:

[root@blackadder RPMS]# config show egroupware
[root@blackadder RPMS]#                                 



Des
Des Dougan

Offline Bud

  • *
  • 487
  • +0/-0
Re: eGroupware upgrade to 1.4
« Reply #74 on: November 30, 2007, 06:24:02 AM »
When I go to " https://mysmebox/egroupware " and try to Login I notice on the top of the Login Box: " Your session could not be verified. "

I have crated a admin User Account but as soon as I want to try to Login it says: " Blocked, too many attempts "

Please Help  :-(