Koozali.org: home of the SME Server

eGroupware upgrade to 1.4

Offline kevinb

  • *
  • 237
  • +0/-0
eGroupware upgrade to 1.4
« on: June 06, 2007, 07:48:08 AM »
Hello everyone,

I just upgraded from eGroupware 1.2 to 1.4. I did this by renaming the /opt/egroupware/html folder to ./html-old and extracting the 1.4 files into the ./html folder. I then copied over the old header.inc.php to the ./html folder. After changing the egw user permissons in mysql everything went fine.

I then copied over the .htaccess file from the old folder (there wasn't one in the new install ... I do not understand why). But now I get a "Access denied" error in the web browser when I try to go to the eGroupware login page. If I remove the .htaccess file all is fine.

Can anyone help me here. There are settings for max file size I would like to change from the default.

Thanks in advance


Kevin

Offline kevinb

  • *
  • 237
  • +0/-0
eGroupware upgrade to 1.4
« Reply #1 on: June 06, 2007, 05:51:53 PM »
Nevermind ... this morning it works! Or maybe it was a blank line at the end or beginning of the .htaccess file that did it

hoopera

Also tried upgrade.
« Reply #2 on: June 08, 2007, 01:29:21 PM »
Hi

I followed what you did, I set the mysql permissions to ALL for the egroupware user and got a page full of table errors that didn't relate to access permissions. what rights did you assign to the egroupware mysql user?

Thanks
Andrew Hooper
http://www.freelance-ns.co.uk

Offline kevinb

  • *
  • 237
  • +0/-0
eGroupware upgrade to 1.4
« Reply #3 on: June 08, 2007, 06:05:46 PM »
Here are my steps:

1.) Install EGW 1.2 from the contirb. Set it up and get it running (you may have to change permissions on /opt/egroupware/html/header.inc.php

2.)
Code: [Select]

mv /opt/egroupware/html/ /opt/egroupware/html_ver-1.2/
mkdir ./egw
cd ./egw

wget http://superb-west.dl.sourceforge.net/sourceforge/egroupware/eGroupWare-1.4.001.tar.gz
wget http://superb-west.dl.sourceforge.net/sourceforge/egroupware/eGroupWare-egw-pear-1.4.001.tar.gz
wget http://umn.dl.sourceforge.net/sourceforge/egroupware/eGroupWare-icalsrv-1.4.001.tar.gz

tar -zxvf eGroupWare-1.4.001.tar.gz
tar -zxvf eGroupWare-egw-pear-1.4.001.tar.gz
tar -zxvf eGroupWare-egw-pear-1.4.001.tar.gz
tar -zxvf eGroupWare-icalsrv-1.4.001.tar.gz

mv ./egroupware /opt/egroupware/html

cp /opt/egroupware/html_ver-1.2/header.inc.php /opt/egroupware/html/header.inc.php


3.) I used phpmyadmin to add the "Alter" right to the egwuser for the egroupware database.
4.) Open a browser and go to "https://<your server>/egroupware/setup"
5.) Login to the "Setup/Config" panel (the top panel)
6.) Go through each step there in order, paying attention to all the text. There will be small text notes telling you that you have to update this or do that, etc. At this point it should be all point and click.

Good luck

Offline berdie

  • *
  • 237
  • +0/-0
eGroupware upgrade to 1.4
« Reply #4 on: June 14, 2007, 11:13:44 PM »
For all people who want to use the new release 1.4 I have made a new rpm which is on it's way to the mirrors. You can download this rpm at
http://mirror.contribs.org/smeserver/contribs/dberteld/egroupware

Rgds.,
Dietmar

Offline lupo

  • **
  • 42
  • +0/-0
eGroupware upgrade to 1.4
« Reply #5 on: June 15, 2007, 03:09:54 PM »
Quote from: "berdie"
For all people who want to use the new release 1.4 I have made a new rpm which is on it's way to the mirrors. You can download this rpm at
http://mirror.contribs.org/smeserver/contribs/dberteld/egroupware

Rgds.,
Dietmar


Hi Dietmar,

sorry for the stupid question:
I have a running eGroupware 1.2. So to perform an update just download the file and then yum localinstall?
Thanks!

Lupo

Offline berdie

  • *
  • 237
  • +0/-0
eGroupware upgrade to 1.4
« Reply #6 on: June 15, 2007, 03:15:15 PM »
No, that's not possible.
If you want to update your version, please use the standard process.

Rgds.,
Dietmar

Offline maykelsoft

  • *
  • 57
  • +0/-0
    • http://www.esi.com.ph
egroupware 1.4 rpm
« Reply #7 on: June 16, 2007, 04:46:14 PM »
Hi,

I have installed egroupware RPM file via yum localinstall package_name.

While adding new admin account I got this error:

Database error: Invalid SQL: DELETE FROM egw_preferences WHERE 1=1
mysql Error: 1146 (Table 'egroupware.egw_preferences' doesn't exist)

File: /opt/egroupware/html/setup/admin_account.php
Line: 108
Function: egw_db::delete

Session halted.


please advise.

regards,
mike

Offline berdie

  • *
  • 237
  • +0/-0
eGroupware upgrade to 1.4
« Reply #8 on: June 17, 2007, 06:51:21 PM »

Offline FraunhoferIFF

  • *
  • 932
  • +0/-0
  • Widerstand ist Zwecklos !
    • http://www.magic-figo.de
eGroupware upgrade to 1.4
« Reply #9 on: June 18, 2007, 08:02:28 AM »
Hallo Dietmar , dein rpm funktioniert , jedoch hab ich einen kleinen Fehler drin,
alle 5 min kommt über den Cron die Meldung :

Code: [Select]
/usr/bin/php -qC /opt/egroupware/html/phpgwapi/cron/asyncservices.php meine.dyndns.org

wo kann ich ihm den die richtige Domäne sagen, der ausgesehene DB eintrag stimmt nicht :(

Danke schon mal

Marcel

Offline fpausp

  • *
  • 728
  • +0/-0
eGroupware upgrade to 1.4
« Reply #10 on: June 18, 2007, 01:34:36 PM »
Hi,

Got some errors on sme 7.1 without updates:


[root@server ~]# rpm -Uvh smeserver-egroupware-1.4-5.noarch.rpm
Preparing...                ########################################### [100%]
   1:smeserver-egroupware   ########################################### [100%]
Sending USR1 signal to mysqld [  OK  ]
Creating database 'egroupware' and user 'egwuser'
Migrating existing database domains
Migrating existing database backups
Migrating existing database yum_installed
Migrating existing database yum_updates
Migrating existing database yum_available
Migrating existing database accounts
Migrating existing database configuration
Migrating existing database mailpatterns
Migrating existing database hosts
Migrating existing database spamassassin
Migrating existing database networks
Migrating existing database yum_repositories
ERROR 1153 (08S01) at line 1160: Got a packet bigger than 'max_allowed_packet' bytes
Decompressing files...
Setting file access rules :
   - Changing owner recursivly...
   - Recursive CHMOD 550 on folders...
   - Recursive CHMOD 440 on files...
   - Customization of CHMOD for a few folders...
Sending USR1 signal to httpd-e-smith [  OK  ]
-------------------------------------------------------------------------------
eGroupware Installation completed, you must finish the installation of eGroupware website.
Please go to https://fpausp.local/egroupware/setup
-------------------------------------------------------------------------------

Reminder :
         - Website open globally
         - https mode enabled with automatic redirection
         - Header-Admin-Login = admin, pw = 'admin'
         - Config-Admin-Login = admin, pw = 'admin'

         Start https://fpausp.local/egroupware/setup
         Login with the Config-Admin (user=admin, pw=admin)
         ToDo's:
         Create Admin-User 'admin' with same password as SME admin
         SME users can login with identical user and password
-------------------------------------------------------------------------------




When i try to create the admin user:


Database error: Invalid SQL: SELECT * FROM egw_preferences WHERE preference_owner=-2 AND preference_app='common'
mysql Error: 1146 (Table 'egroupware.egw_preferences' doesn't exist)

File: /opt/egroupware/html/setup/admin_account.php
Line: 177
Function: egw_db::select / insert_default_prefs()

Session halted.




regards
fpausp
Viribus unitis

Offline cool34000

  • *
  • 339
  • +0/-0
eGroupware upgrade to 1.4
« Reply #11 on: June 19, 2007, 07:58:32 AM »
Hi

Quote
ERROR 1153 (08S01) at line 1160: Got a packet bigger than 'max_allowed_packet' bytes
This error is due to a 30000 lines request when the database is imported... If you have this error, the database will stop importing and a lot of stuffs will be missing, so eGroupWare won't work.

I've send a mail to berdie to explain the problem. Wait for his new release :wink:

Offline berdie

  • *
  • 237
  • +0/-0
eGroupware upgrade to 1.4
« Reply #12 on: June 19, 2007, 02:57:51 PM »
A new version is on it's way to the mirrors. In a few hours it should be here available:  http://mirror.contribs.org/smeserver/contribs/dberteld/egroupware/smeserver-egroupware-1.4-6.noarch.rpm

Rgds.,
Dietmar

Offline fpausp

  • *
  • 728
  • +0/-0
eGroupware upgrade to 1.4
« Reply #13 on: June 20, 2007, 02:33:12 PM »
Hi,

Have it running on two boxes 7.1.3 and 7.2 and work´s great for me, thanks for your work !!!

regards
fpausp
Viribus unitis

Offline FraunhoferIFF

  • *
  • 932
  • +0/-0
  • Widerstand ist Zwecklos !
    • http://www.magic-figo.de
eGroupware upgrade to 1.4
« Reply #14 on: June 20, 2007, 10:33:23 PM »
How can i stop/corrected this Cron :


Code: [Select]
asyncservice.php: Domain 'vfbfigo.dyndns.org' is not configured or renamed, exiting !!!

my Domain is incorrect... How can i change this ?

Marcel