Login Problem with Horde Groupware Mail 1.2.4

[Toralf Kirsten]

Hi all,

I recently downloaded the Horde Groupware Webmail Version 1.2.4 (as of
Sept. 2009) and installed the software on a Linux box using the eisfair
OS (a very small Linux OS without X). PHP, Apache web server, and a
MySQL DBMS are already running on this machine; my content management
system works very fine with support of these software. The Horde
installation process runs through without any error. To configure the
Horde system and database I used the setup.php script as described in
the installation instructions. Furthermore, I created a virtual host in
the Apache web server for the Horde Groupware system and linked the
Apache htdocs dir to the Horde directory. The test.php page says YES for
most of the entries, some entries are marked with NO and warnings, which
I list below:
- PHP GeoIP support
- magick Library
- LZF Compression Support
- memcached Support (memcache)
- MIME Magic Support (fileinfo)
- PostgreSQL Support
- memory_limit value: 64M (Here there is just a warning saying that at
least 64M is recommended for this property)

I can access the home page (including the login, password, language, and
mode select boxes) of the installed Horde system. However, whenever I
try to login with an OS user which is also a mail user, the Horde system
prints the following message on the screen:
----
*Warning*: require_once() [function.require-once
<http://webmail.my-web-page.org/imp/function.require-once>]: Couldn't
resolve host name in
*/data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
*Warning*: require_once(Horde/Group.php) [function.require-once
<http://webmail.my-web-page.org/imp/function.require-once>]: failed to
open stream: operation failed in
*/data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
*Fatal error*: require_once() [function.require
<http://webmail.my-web-page.org/imp/function.require>]: Failed opening
required 'Horde/Group.php'
(include_path='/data/opt/horde-webmail-1.2.4/lib:/data/opt/horde-webmail-1.2.4/lib/../pear/php')
in */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
----
However, I have not modified this file so far. Since the shown error
sounds that there is an possibly an database access problem I checked
this. Using the MySQL user which is set in the Horde configuration I can
access the local MySQL DBMS (server is set to localhost, port=3306) and
the Horde database as well. The Horde database contains some tables that
have been generated in the Horde installation process.

In the horde.log I can see the following message
----
Oct 11 15:00:08 HORDE [error] [] Guest user is not authorised for
Address Book. [pid 16411 on line 1706 of
"/data/opt/horde-webmail-1.2.4/lib/Horde.php"]
Oct 11 15:00:08 HORDE [error] [] Guest user is not authorised for
Address Book. [pid 16411 on line 791 of
"/data/opt/horde-webmail-1.2.4/lib/Horde/Prefs.php"]
Oct 11 15:00:08 HORDE [error] [imp] Guest user is not authorised for
Address Book. [pid 16411 on line 1706 of
"/data/opt/horde-webmail-1.2.4/lib/Horde.php"]
Oct 11 15:00:08 HORDE [error] [imp] Guest user is not authorised for
Address Book. [pid 16411 on line 791 of
"/data/opt/horde-webmail-1.2.4/lib/Horde/Prefs.php"]
----

However, I neither used the user Guest to login nor in the Horde
configuration (e.g., main or administration user). The user is also not
a valid user within the OS and the mail server.

Does anybody knows whats going wrong here?
I'm thankful for any advise.

All the best, Toralf
--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe@...

[Luis Felipe Marzagao/Andamentos]

Em 11-10-2009 10:55, Toralf Kirsten escreveu:

> Hi all,
>
> I recently downloaded the Horde Groupware Webmail Version 1.2.4 (as of
> Sept. 2009) and installed the software on a Linux box using the
> eisfair OS (a very small Linux OS without X). PHP, Apache web server,
> and a MySQL DBMS are already running on this machine; my content
> management system works very fine with support of these software. The
> Horde installation process runs through without any error. To
> configure the Horde system and database I used the setup.php script as
> described in the installation instructions. Furthermore, I created a
> virtual host in the Apache web server for the Horde Groupware system
> and linked the Apache htdocs dir to the Horde directory. The test.php
> page says YES for most of the entries, some entries are marked with NO
> and warnings, which I list below:
> - PHP GeoIP support
> - magick Library
> - LZF Compression Support
> - memcached Support (memcache)
> - MIME Magic Support (fileinfo)
> - PostgreSQL Support
> - memory_limit value: 64M (Here there is just a warning saying that at
> least 64M is recommended for this property)

I don't think these warnings are related to the problem. They are
harmless and more related to performance.

>
> I can access the home page (including the login, password, language,
> and mode select boxes) of the installed Horde system. However,
> whenever I try to login with an OS user which is also a mail user, the
> Horde system prints the following message on the screen:
> ----
> *Warning*: require_once() [function.require-once
> <http://webmail.my-web-page.org/imp/function.require-once>]: Couldn't
> resolve host name in
> */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
> *Warning*: require_once(Horde/Group.php) [function.require-once
> <http://webmail.my-web-page.org/imp/function.require-once>]: failed to
> open stream: operation failed in
> */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
> *Fatal error*: require_once() [function.require
> <http://webmail.my-web-page.org/imp/function.require>]: Failed opening
> required 'Horde/Group.php'
> (include_path='/data/opt/horde-webmail-1.2.4/lib:/data/opt/horde-webmail-1.2.4/lib/../pear/php')
> in */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
> ----
> However, I have not modified this file so far. Since the shown error
> sounds that there is an possibly an database access problem I checked
> this. Using the MySQL user which is set in the Horde configuration I
> can access the local MySQL DBMS (server is set to localhost,
> port=3306) and the Horde database as well. The Horde database contains
> some tables that have been generated in the Horde installation process.
>
> In the horde.log I can see the following message
> ----
> Oct 11 15:00:08 HORDE [error] [] Guest user is not authorised for
> Address Book. [pid 16411 on line 1706 of
> "/data/opt/horde-webmail-1.2.4/lib/Horde.php"]
> Oct 11 15:00:08 HORDE [error] [] Guest user is not authorised for
> Address Book. [pid 16411 on line 791 of
> "/data/opt/horde-webmail-1.2.4/lib/Horde/Prefs.php"]
> Oct 11 15:00:08 HORDE [error] [imp] Guest user is not authorised for
> Address Book. [pid 16411 on line 1706 of
> "/data/opt/horde-webmail-1.2.4/lib/Horde.php"]
> Oct 11 15:00:08 HORDE [error] [imp] Guest user is not authorised for
> Address Book. [pid 16411 on line 791 of
> "/data/opt/horde-webmail-1.2.4/lib/Horde/Prefs.php"]
> ----
>
> However, I neither used the user Guest to login nor in the Horde
> configuration (e.g., main or administration user). The user is also
> not a valid user within the OS and the mail server.
>

What backend have you defined as authentication?

> Does anybody knows whats going wrong here?
> I'm thankful for any advise.
>
> All the best, Toralf

Did you take a look at this how to? It's not for your OS, but maybe
something there helps:

http://wiki.horde.org/CentOS5InstallationNotes


--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe@...

[Jan Schneider]

Zitat von Toralf Kirsten <tkirsten@...>:

> I can access the home page (including the login, password, language,  
> and mode select boxes) of the installed Horde system. However,  
> whenever I try to login with an OS user which is also a mail user,  
> the Horde system prints the following message on the screen:
> ----
> *Warning*: require_once() [function.require-once  
> <http://webmail.my-web-page.org/imp/function.require-once>]:  
> Couldn't resolve host name in  
> */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*

There is no host name involved in this line.

> *Warning*: require_once(Horde/Group.php) [function.require-once  
> <http://webmail.my-web-page.org/imp/function.require-once>]: failed  
> to open stream: operation failed in  
> */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*

And no stream operation either. What kind of PHP comes with this OS?  
Sounds kind of broken.

> *Fatal error*: require_once() [function.require  
> <http://webmail.my-web-page.org/imp/function.require>]: Failed  
> opening required 'Horde/Group.php'  
> (include_path='/data/opt/horde-webmail-1.2.4/lib:/data/opt/horde-webmail-1.2.4/lib/../pear/php') in */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line  
> *683*

That's the only error message that makes any sense. Check the file  
lib/Horde/Group.php. Maybe the file permissions are wrong?

Jan.

--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/

--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe@...

[Toralf Kirsten]

Hi Luis and Jan,

thanks for your advices.

I use a local IMAP server as backend. I checked the accessibility using
sub-scrits of test.php.
Horde Applications: Imp: H3 (4.3.5) --> PHP Mail Server Support Test
with the following properties
server: localhost
user: <myuser>
password: <mypasswd>
server type: imap

After submitting this information I receive the following messages:

Attempting to automatically determine the correct connection parameters
for your server:
    * Trying protocol imap/notls, Port 143:
          SUCCESS - INBOX has 5 messages (0 new 0 recent)
    * Trying protocol imap/ssl, Port 993:
          ERROR - The server returned the following error message:
          TLS/SSL failure for localhost: SSL negotiation failed
    * Trying protocol imap/ssl/novalidate-cert, Port 993:
          ERROR - The server returned the following error message:
          TLS/SSL failure for localhost: SSL negotiation failed
    * Trying protocol imap/tls/novalidate-cert, Port 143:
          ERROR - The server returned the following error message:
          Unable to negotiate TLS with this server

The following configurations were successful and may be used in your
imp/config/servers.php file:
    Configuration 1
        'server' => 'localhost'
        'protocol' => 'imap/notls'
        'port' => '143'

The following IMAP server information was discovered from the remote server:
    Namespace Information
        NAMESPACE: ""
        DELIMITER: /
        TYPE: personal

        NAMESPACE: "#mhinbox"
        DELIMITER:
        TYPE: personal

        NAMESPACE: "#mh/"
        DELIMITER: /
        TYPE: personal

        NAMESPACE: "~"
        DELIMITER: /
        TYPE: other

        NAMESPACE: "#shared/"
        DELIMITER: /
        TYPE: shared

        NAMESPACE: "#ftp/"
        DELIMITER: /
        TYPE: shared

        NAMESPACE: "#news."
        DELIMITER: .
        TYPE: shared

        NAMESPACE: "#public/"
        DELIMITER: /
        TYPE: shared
...
    IMAP Charset Search Support:
        Server supports searching with the UTF-8 character set.


According to the PHP support I refer to the results of the test.php that
lists the following
PHP Version
    * PHP Version: 5.2.10
    * PHP Major Version: 5.2
    * PHP Minor Version: 10
    * PHP Version Classification: release
    * You are running a supported version of PHP.

I also changed the file permission of lib/Horde/Group.php ( just to
test: 777) as proposed by Jan; but there is no change in the result.

I will check your web site recommendation in the evening.

Thanks, Toralf


Luis Felipe Marzagao wrote:

> Em 11-10-2009 10:55, Toralf Kirsten escreveu:
>> Hi all,
>>
>> I recently downloaded the Horde Groupware Webmail Version 1.2.4 (as
>> of Sept. 2009) and installed the software on a Linux box using the
>> eisfair OS (a very small Linux OS without X). PHP, Apache web server,
>> and a MySQL DBMS are already running on this machine; my content
>> management system works very fine with support of these software. The
>> Horde installation process runs through without any error. To
>> configure the Horde system and database I used the setup.php script
>> as described in the installation instructions. Furthermore, I created
>> a virtual host in the Apache web server for the Horde Groupware
>> system and linked the Apache htdocs dir to the Horde directory. The
>> test.php page says YES for most of the entries, some entries are
>> marked with NO and warnings, which I list below:
>> - PHP GeoIP support
>> - magick Library
>> - LZF Compression Support
>> - memcached Support (memcache)
>> - MIME Magic Support (fileinfo)
>> - PostgreSQL Support
>> - memory_limit value: 64M (Here there is just a warning saying that
>> at least 64M is recommended for this property)
>
> I don't think these warnings are related to the problem. They are
> harmless and more related to performance.
>
>>
>> I can access the home page (including the login, password, language,
>> and mode select boxes) of the installed Horde system. However,
>> whenever I try to login with an OS user which is also a mail user,
>> the Horde system prints the following message on the screen:
>> ----
>> *Warning*: require_once() [function.require-once
>> <http://webmail.my-web-page.org/imp/function.require-once>]: Couldn't
>> resolve host name in
>> */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
>> *Warning*: require_once(Horde/Group.php) [function.require-once
>> <http://webmail.my-web-page.org/imp/function.require-once>]: failed
>> to open stream: operation failed in
>> */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
>> *Fatal error*: require_once() [function.require
>> <http://webmail.my-web-page.org/imp/function.require>]: Failed
>> opening required 'Horde/Group.php'
>> (include_path='/data/opt/horde-webmail-1.2.4/lib:/data/opt/horde-webmail-1.2.4/lib/../pear/php')
>> in */data/opt/horde-webmail-1.2.4/lib/Horde/Share/sql.php* on line *683*
>> ----
>> However, I have not modified this file so far. Since the shown error
>> sounds that there is an possibly an database access problem I checked
>> this. Using the MySQL user which is set in the Horde configuration I
>> can access the local MySQL DBMS (server is set to localhost,
>> port=3306) and the Horde database as well. The Horde database
>> contains some tables that have been generated in the Horde
>> installation process.
>>
>> In the horde.log I can see the following message
>> ----
>> Oct 11 15:00:08 HORDE [error] [] Guest user is not authorised for
>> Address Book. [pid 16411 on line 1706 of
>> "/data/opt/horde-webmail-1.2.4/lib/Horde.php"]
>> Oct 11 15:00:08 HORDE [error] [] Guest user is not authorised for
>> Address Book. [pid 16411 on line 791 of
>> "/data/opt/horde-webmail-1.2.4/lib/Horde/Prefs.php"]
>> Oct 11 15:00:08 HORDE [error] [imp] Guest user is not authorised for
>> Address Book. [pid 16411 on line 1706 of
>> "/data/opt/horde-webmail-1.2.4/lib/Horde.php"]
>> Oct 11 15:00:08 HORDE [error] [imp] Guest user is not authorised for
>> Address Book. [pid 16411 on line 791 of
>> "/data/opt/horde-webmail-1.2.4/lib/Horde/Prefs.php"]
>> ----
>>
>> However, I neither used the user Guest to login nor in the Horde
>> configuration (e.g., main or administration user). The user is also
>> not a valid user within the OS and the mail server.
>>
>
> What backend have you defined as authentication?
>
>> Does anybody knows whats going wrong here?
>> I'm thankful for any advise.
>>
>> All the best, Toralf
>
> Did you take a look at this how to? It's not for your OS, but maybe
> something there helps:
>
> http://wiki.horde.org/CentOS5InstallationNotes
>
>

--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe@...