Topic: webmail login page does not load in browser

[Mophilly]

Posting here first in case of PBCAK.

We set up SME9 on a new server in gateway/server mode; currently running SME 9.2. It has been working well for months. In that time we did not test to see if webmail was working as the server needed only to send advice via email, not act as an email server.

This week we began moving users off an older SME8 server and we are testing to see if email is working on the new SME9 system. When I attempt to load webmail in the browser I get a blank page.
    http://myserver.mydomain.com/webmail/

In the http log I can see the request for the page. No other entries. In http error log I found this:

Code: [Select]

PHP Warning:  require_once(/home/httpd/html/horde/imp/lib/../../lib/core.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in /home/httpd/html/horde/imp/lib/base.php on line 32
PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required '/home/httpd/html/horde/imp/lib/../../lib/core.php' (include_path='/usr/share/pear-addons:/usr/share/pear') in /home/httpd/html/horde/imp/lib/base.php on line 32
Continuing to search for clues.

suggestions and pointers warmly accepted.

[mmccarn]

When I setup 9.2 I webmail was disabled by default.

My notes say that I enabled it in server-manager -> E-mail -> Change e-mail access settings -> Webmail settings

[Mophilly]

Thank you. I checked and our server is set to allow webmail via HTTPS.

[Jean-Philippe Pialasse]

How did you restore from sme 8. To sme9?

Is it core horde or horde 5 has been installed?

Is there any template custom?


rpm -qa horde
/sbin/e-smith/auditools/templates

[Mophilly]

Here is more info in answer of Jean-Philippe's questions.

We built the SME9 from the iso image. We moved users, groups, pseudonyms and passwords from SME8 to SME9 using LATools. We can see the accounts, passwords are working (we checked a small number). groups and pseudonyms are present.

Horde 5 has not been installed. I don't believe we have added any custom templates, although odoo, owncloud and postgres have been installed.

>> rpm -qa horde

Code: [Select]

# rpm -qa horde
# rpm -q horde
package horde is not installed
>>/sbin/e-smith/auditools/templates

Code: [Select]

# /sbin/e-smith/audittools/templates
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/99allow_url_fopen: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/20LoadModule80PHP: OWNED_BY_RPM, OVERRIDE
/etc/e-smith/templates-custom/var/lib/pgsql/data/postgresql.conf: MANUALLY_ADDED, OVERRIDE
/etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf: MANUALLY_ADDED, OVERRIDE
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/template-begin: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/02ServerName: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/template-end: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/30WebmailAliases: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/40ApacheIconAlias: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/20IbayContent: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/04StrictTransportSecurity: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/25SSLDirectives: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/27ManagerProxyPass: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/00Setup: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/03ServerAlias: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/40ServerResources: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/26RewriteTraceAndTrack: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/VirtualHosts/04StrictTransportSecurity: MANUALLY_ADDED
/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf: MANUALLY_ADDED
/etc/e-smith/templates/var/lib/pgsql/data/pg_hba.conf: MANUALLY_ADDED

[gsimpson]

So, Mark and I were not communicating, in fact, I thought he was enjoying his day off. It turns out that as soon as he did that particular command, the server was coming down after I did a "yum install horde". This is now installed and working.

It was a comedy of timing is all.

I spotted some interesting thing in the logs and as soon as Mark and I look a them, we will post our findings here.

[Mophilly]

well, that was quite a surprise! And, with horde re-installed, the original topic of this thread is satisfied. Nonetheless, there are a couple of questions outstanding.

First, did all that SME needs get installed by running "yum install horde"? Since horde was deleted in error, I wonder else might be missing... is there a way to update SME9 without performing a backup/re-install/restore?

We, that is Greg and I, are now running an rsync script now to keep the two servers up to date until we are ready to modify the zone record MX values.

Code: [Select]

#!/bin/sh
RSYNC=/usr/bin/rsync
SSH=/usr/bin/ssh
KEY=/root/cron/new-server-rsync-key
RUSER=root
RHOST=10.10.10.1
RPATH=/home/e-smith/files/users/
LPATH=/home/e-smith/files/users/
$RSYNC -az -e "$SSH -i $KEY" $RUSER@$RHOST:$RPATH $LPATH

The second question is this: are the rsync parameters set correctly for moving the files and "status of mail" in horde.
We are noticing differences between the webmail on the old server and that on the new server. For example, the mail marked as read. On the new server all is unread, while on the old server only a very few mails are unread.

[ReetP]

Have a look at unison for sync

You can choose to sync user/group permissions and a plethora of other options

http://www.cis.upenn.edu/~bcpierce/unison/download.html

[Mophilly]

Thank you, ReetP, for the suggestion.

I read through the site and it looks pretty good. My question is does it detect and preserve any indications necessary so that the mail clients connecting to the new server reflect the unread/read status, etc., seen on the old server?

[Jean-Philippe Pialasse]

You might have some issue as long as you will have two accessible versions. 
The read status is encoded in the filename. So you might end up with double emails because of the rsync if it has been read on one and then sync again, unless you use the delete flag for rsync.... however you will have then issues if you try then to modify on the  new and rsync fron the old, it will erase modification.

Unison or freefilesync might help as they will allow bilateral sync, but conflicts might still occurs at moment and will need manual resolution...

In other words, solve rather sooner the two servers situation to one only.


See 
https://wiki2.dovecot.org/MailboxFormat/Maildir

[Mophilly]

Thank you for the info. I will review the dovecot link.

The current plan is update the MX record this weekend, and end the rsync as soon as possible.

[ReetP]

Unison can be set as a "1 way sync only" if you are effectively just running a continual backup.

[Mophilly]

The switch over went pretty well. We learned a bit, but it appears the end user mail is working fine. Tomorrow, Monday, will be the proof when the business offices open.

Next up: reestablish security and anti-spam measures, e.g. fail2Ban, enabling blacklist and dmarc

Thanks for all of the suggestions. They really helped us a lot.