Topic: Update

[allrounder29]

Hi,
Update the to the available updates this morning I have eGroupware inatalled and since update have no emails, can log in successfully,
running version 8.0 beta 
any ideas

cheers

[Stefano]

yes.. first of all you should take a look in the logs (/var/log/messages in first instance, then /var/log/httpd/*)

I suspect a problem with egroupware and php5.3.3

[allrounder29]

i got the following error message

An error happened: <center><b>Fatal Error:</b> It appears that you have not created the database tables for eGroupWare.  Click <a href="/opt/egroupware/html/phpgwapi/cron/asyncservices.php">here</a> to run setup.</center>
#0 /opt/egroupware/html/phpgwapi/inc/class.egw.inc.php(64): egw->setup(Array, true)
#1 /opt/egroupware/html/phpgwapi/inc/functions.inc.php(125): egw->__construct(Array)
#2 /opt/egroupware/html/phpgwapi/cron/asyncservices.php(61): include('/opt/egroupware...')
#3 {main}

[cactus]

What is the output off the following command:

Code: [Select]

mysql -e "SHOW DATABASES;"

[andy_wismer]

Hi Everyone

On a productive server running now SME8b7 - installed with SME8b6 and sucessfully updated to SME8b7 I have the same problems with eGroupWare:

- Login Fine
- Mail (Just blank page)
- Calendar (Works from Web, but Sunbird can't change any entries, seems to be an auth issue too...)

This server is productive for 25 Users, running since April 2011 on fairly decent hardware. So far NO problems besides the above one with eGroupWare - kudos to the SME team for a great product!

To be honest, this server was actually a SME6, updated to SME7 beta, updated to SME7 then cleaned out of all contribs. Therafter saved to Workstation with built-in backup, then restored to a pristine SME7 (To make sure no contribs et al) and finally updated with CD to SME8b6. Online updates moved us up to SME8b7.
The hardware has migrated accordingly, starting with SCSI disks and now on SATA with SME8 providing RAID-1 redundancy... No performance issues, even though the client is running almost everything except for VOIP on that server: mail, web, file-server, print and plotter sharing, proxy, windows PDC for 25 users...

As requested by cactus:

mysql -e "SHOW DATABASES;"
+--------------------+
| Database           |
+--------------------+
| information_schema |
| egroupware         |
| horde              |
| mysql              |
+--------------------+

Any ideas, anyone?

Thanks

Andy Wismer

[Frank VB]

On a productive server running now SME8b7 - installed with SME8b6 and sucessfully updated to SME8b7 I have the same problems with eGroupWare:

- Login Fine
- Mail (Just blank page)

A quick response on this: I've run into exactly the same problem yesterday on a test server (SME8b7 with eGroupware 1.4). I've been looking into the problem and found this: as soon as you try to open the webmail component in egroupware, the httpd log file logs an error message concerning a "child pid XXXX exit signal Segmentation fault (11)" (I don't have my notes at hand atm, so I'm writing this partially down from memory).

After turning on error messages in php.ini, I saw error messages concerning open_basedir and a required php file which couldn't be opened/accessed.

Code: [Select]

Dec  6 16:07:02 servertje httpd: PHP Warning:  require_once() [<a href='function.require-once'>function.require-once</a>]: open_basedir restriction in effect. File(/usr/share/pear/PEAR.php) is not within the allowed path(s): (/opt/egroupware:/tmp) in /opt/egroupware/html/egw-pear/Net/Socket.php on line 22
Dec  6 16:07:02 servertje httpd: PHP Warning:  require_once(/usr/share/pear/PEAR.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: Operation not permitted in /opt/egroupware/html/egw-pear/Net/Socket.php on line 22
Dec  6 16:07:02 servertje httpd: PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'PEAR.php' (include_path='/opt/egroupware/html/egw-pear:.:/usr/share/pear') in /opt/egroupware/html/egw-pear/Net/Socket.php on line 22

So what I did was: add the /usr/share/pear directory to the open_basedir parameter in the <directory /opt/egroupware/html> fragment in the httpd.conf. The original parameter reads:

Code: [Select]

php_value open_basedir /opt/egroupware:/tmp
The adjusted parameter reads:

Code: [Select]

php_value open_basedir /opt/egroupware:/tmp:/usr/share/pear
Then after restarting the httpd-e-smith service, I could access the webmail component in egroupware without a problem. This is a temporary (and probably not so safe) workaround and it will probably not survive a signal-event post-upgrade (didn't test this yet).
 
The egroupware website mentions somewhere in the release notes (http://community.egroupware.org/wiki?wikipage=releasenotes1.8) that there are known problems with egroupware running on php 5.3.x and they say they can't do anything about it. According to them it's a problem with PHP 5.3.x.

[andy_wismer]

Hi

Just to report that I've adapted the template file for eGroupWare
(/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/98egroupware)

and changed the following values:
from
   php_value open_basedir /opt/egroupware:/tmp
to
   php_value open_basedir /opt/egroupware:/tmp:/usr/share/pear
and everything works as expected, even the Sunbird calendar...

Note: This WILL survive a signal-event post-upgrade

Good analysis, Frank VB!!!

Thanks eveyone

This is the contents of my /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/98egroupware file:
(Yes, I've switched of the Horde Webmail and redirected the /webmail alias to eGroupWare...)

#--------------------------------------------------------------
# eGroupWare
#--------------------------------------------------------------
Alias /egroupware /opt/egroupware/html
Alias /egroupware/ /opt/egroupware/html
Alias /groupware /opt/egroupware/html
Alias /groupware/ /opt/egroupware/html
Alias /egw /opt/egroupware/html
Alias /egw/ /opt/egroupware/html
Alias /webmail /opt/egroupware/html
Alias /webmail/ /opt/egroupware/html

<Directory /opt/egroupware/html/>
{
    my $egwsec = $egroupware{'HTTPS'} || "off";
    if ($egwsec eq "off")
    {
  $OUT .= "  # SSLRequireSSL on";   
    } else {
  $OUT .= "  SSLRequireSSL on";
    }
}
  AddType application/x-httpd-php .php .php3 .phtml
  AddType text/xml .xml
  Options FollowSymLinks ExecCGI
  AllowOverride None
  Order allow,deny
{
    my $egw = $egroupware{'PublicAccess'} || "local";
    if ($egw eq "local")
    {
  $OUT .= "  allow from $localAccess";   
    } else {
  $OUT .= "  allow from all";
    }
}
  DirectoryIndex index.html index.php
  AddHandler cgi-script .cgi
  AddDefaultCharset Off
  php_flag file_uploads on
  php_flag log_errors on
  php_flag magic_quotes_gpc off
  php_flag magic_quotes_runtime off
  php_flag register_globals off
  php_flag short_open_tag on
  php_flag track_vars on
  php_flag display_errors off
  php_value error_reporting 'E_ALL & ~E_NOTICE'
  php_value max_execution_time 90
  php_value mbstring.func_overload 7
  php_value memory_limit 32M
  php_value session.gc_maxlifetime 1440
  php_value session.save_path /opt/egroupware/tmp
  php_value include_path .:/usr/share/pear
  php_value open_basedir /opt/egroupware:/tmp:/usr/share/pear
  php_value upload_max_filesize 20M
  <Files ~ "\.inc\.php$">
    Order allow,deny
    Deny from all
  </Files>
</Directory>

#<Directory /opt/egroupware/html/fudforum/>
#  AllowOverride Limit Options
#</Directory>

<Directory /opt/egroupware/html/phpsysinfo/>
  php_value open_basedir /
</Directory>

<Location /egroupware/icalsrv.php>
  Script PUT /opt/egroupware/html/icalsrv.php
  AddHandler ical/ics .ics
  Action ical/ics /opt/egroupware/html/icalsrv.php
  Order allow,deny
{
    my $egw = $egroupware{'PublicAccess'} || "local";
    if ($egw eq "local")
    {
  $OUT .= "  allow from $localAccess";   
    } else {
  $OUT .= "  allow from all";
    }
}
</Location>

<Location /egroupware/rpc.php>
  php_value mbstring.func_overload 0
  Order allow,deny
{
    my $egw = $egroupware{'PublicAccess'} || "local";
    if ($egw eq "local")
    {
  $OUT .= "  allow from $localAccess";   
    } else {
  $OUT .= "  allow from all";
    }
}
</Location>
#--------------------------------------------------------------

END OF TEMPLATE FILE

[Frank VB]

Andy, I'm happy the solution also works for you! Thank you for looking up the relevant templates-custom fragment. I didn't have the time yet to investigate this further.

Anyone applying this "patch" should test all components of eGroupware thoroughly to make sure no further issues arise following the SME8beta7 update. Maybe this problem/solution should also be entered in the bug tracker.

[allrounder29]

Hi
there is database for egroupware when doing a "show databases"

[cactus]

Hi
there is database for egroupware when doing a "show databases"

Yes, so there should be something else not correct. Did you check the configuration file(s)? Most likely they should be in your tree as well.

[allrounder29]

Yes, so there should be something else not correct. Did you check the configuration file(s)? Most likely they should be in your tree as well.

Checking required PHP version 5.1+ (recommended 5.2+): 5.3.3 ==> True
Passed Checking php.ini: safe_mode = Off: ini_get('safe_mode')='' = Off
Passed Checking php.ini: magic_quotes_runtime = Off: ini_get('magic_quotes_runtime')='0' = Off
Passed Checking php.ini: register_globals = Off: ini_get('register_globals')='0' = Off
Passed Checking php.ini: display_errors = Off: ini_get('display_errors')='0' = Off
Passed Checking php.ini: memory_limit >= 24M: ini_get('memory_limit')='24M'
Passed Checking php.ini: max_execution_time >= 30: ini_get('max_execution_time')='90'
Passed Checking php.ini: file_uploads = On: ini_get('file_uploads')='1' = On
Error Checking php.ini: upload_max_filesize >= 8M: ini_get('upload_max_filesize')='6M'
upload_max_filesize is set to 6M, you will NOT be able to upload or attach files bigger then that!
*** Please make the following change in your php.ini (/etc): upload_max_filesize = 8M
*** AND reload your webserver, so the above changes take effect !!!
Passed Checking php.ini: post_max_size >= 8M: ini_get('post_max_size')='20M'
Passed Checking php.ini: include_path contain .: ini_get('include_path')='.:/usr/share/pear'
Warning Checking php.ini: mbstring.func_overload = 7: ini_get('mbstring.func_overload')='0'
The mbstring.func_overload = 7 is needed to fully support unicode (utf-8) or other multibyte-charsets.
*** Please make the following change in your php.ini (/etc): mbstring.func_overload = 7
*** AND reload your webserver, so the above changes take effect !!!
Passed Checking php.ini: magic_quotes_gpc = Off: ini_get('magic_quotes_gpc')='0' = Off
Passed Checking extension session is loaded or loadable: True
Passed Checking extension pdo is loaded or loadable: True
Passed Checking extension mysql is loaded or loadable: True
Passed Checking extension pdo_mysql is loaded or loadable: True
Warning Checking extension pgsql is loaded or loadable: False
The pgsql extension is needed, if you plan to use a pgSQL database.
Warning Checking extension pdo_pgsql is loaded or loadable: False
The pdo_pgsql extension is needed, if you plan to use a pgSQL database.
Warning Checking extension odbc is loaded or loadable: False
The odbc extension is needed, if you plan to use a MaxDB, MsSQL or Oracle database.
Warning Checking extension pdo_odbc is loaded or loadable: False
The pdo_odbc extension is needed, if you plan to use a MaxDB, MsSQL or Oracle database.
Warning Checking extension oci8 is loaded or loadable: False
The oci extension is needed, if you plan to use a Oracle database.
Warning Checking extension pdo_oci is loaded or loadable: False
The pdo_oci extension is needed, if you plan to use a Oracle database.
Passed Checking extension mbstring is loaded or loadable: True
Passed Checking extension ldap is loaded or loadable: True
Passed Checking extension ctype is loaded or loadable: True
Passed Checking extension imap is loaded or loadable: True
Passed Checking extension dom is loaded or loadable: True
Warning Checking PEAR is installed: False
PEAR is needed by: Calendar (iCal import+export), FeLaMiMail, EMailAdmin, felamimail, news_admin, SyncML. PEAR (pear.php.net) is a PHP repository and is usually in a package called php-pear.
Passed Checking PEAR::HTTP_WebDAV_Server is installed: 999.egw-pear
Passed Checking PEAR::Net_Socket is installed: 999.egw-pear
Warning Checking PEAR::Auth_SASL is installed: False
PEAR::Auth_SASL is needed by: EMailAdmin, felamimail. PEAR (pear.php.net) is a PHP repository and is usually in a package called php-pear.
Passed Checking PEAR::Net_IMAP is installed: 999.egw-pear
Passed Checking PEAR::Net_Sieve is installed: 999.egw-pear
Warning Checking PEAR::XML_Feed_Parser is installed: False
PEAR::XML_Feed_Parser is needed by: news_admin. PEAR (pear.php.net) is a PHP repository and is usually in a package called php-pear.
Passed Checking PEAR::Log is installed: 999.egw-pear
Passed Checking for GD support...: True
Passed Checking file-permissions of /opt/egroupware/html for not world writable: nn/nn drwxr-xr-x
This might take a while, please wait ...
Passed Checking file-permissions of /opt/egroupware/header.inc.php for not world readable: nn/nn -rw-r-----
Passed Checking if php.ini setting session.save_path='/opt/egroupware/tmp' is writable by the webserver: nn/nn drwxrwx---