Topic: Horde 5.2 on SME9

[holck]

Thank you very much for your help and suggestions. The server is in production, but running Horde is not critical.

My problems are not only related to the Kronolith tables, they occur all over. I've tried this

Code: [Select]

$ /usr/bin/horde-db-migrate
it showed no errors, no output at all. But if I run the script from PHP, I get:

Code: [Select]

$ php -f /usr/bin/horde-db-migrate
PHP Warning:  require_once(/usr/share/pear/www/horde/lib/Application.php): failed to open stream: No such file or directory in /usr/bin/horde-db-migrate on line 29
PHP Fatal error:  require_once(): Failed opening required '/usr/share/pear/www/horde/lib/Application.php' (include_path='.:/usr/share/pear-addons:/usr/share/pear') in /usr/bin/horde-db-migrate on line 29

So I guess this is part of an answer to my problems... Is /home/httpd/html/horde/lib/Application.php the file to use?

[stephdl]

I can't reproduce your issues, workable here in one shot on sme9 X64

[mrjhb3]

What version of PHP are you using? 

Code: [Select]

php -vIf anything other than the current version included with SME Server, then I'll have a hard time helping.  What contribs do you have installed?  Have you made any other system modifications?  If you execute

Code: [Select]

pear list then

Code: [Select]

pear list -c horde and paste that, then I will compare what you installed vs what all my systems have for horde.  My three test servers, and my production server show the exact same version info.  Lastly, what does your include_path show in php.ini?  Mine shows, include_path                           = ".:/usr/share/pear-addons:/usr/share/pear"


John

[holck]

The php script horde-db-migrate was installed in /usr/bin, and that caused problems for me. This script, as well as a number of other horde-* scripts, comes from the installation of horde-5.2.7-1.el6.noarch . Now I've copied all these scripts to a new directory, /home/httpd/html/horde/bin, and most things seem to run smoothly

If you take a look at the code in horde-db-migrate, it's obvious that this file doesn't belong in /usr/bin :

Code: [Select]

$baseFile = __DIR__ . '/../lib/Application.php';

So I think this is an error in the horde-5.2.7-1.el6.noarch file I downloaded:

Code: [Select]

[holck@karoline bin]$ rpm -q --filesbypkg horde | grep bin
horde                     /home/httpd/html/horde/themes/default/graphics/mime/binary.png
horde                     /usr/bin/horde-active-sessions
horde                     /usr/bin/horde-alarms
horde                     /usr/bin/horde-check-logger
horde                     /usr/bin/horde-clear-cache
horde                     /usr/bin/horde-crond
horde                     /usr/bin/horde-db-migrate
horde                     /usr/bin/horde-import-openxchange-prefs
horde                     /usr/bin/horde-import-squirrelmail-prefs
horde                     /usr/bin/horde-memcache-stats
horde                     /usr/bin/horde-pref-remove
horde                     /usr/bin/horde-queue-run-tasks
horde                     /usr/bin/horde-remove-user-data
horde                     /usr/bin/horde-run-task
horde                     /usr/bin/horde-sessions-gc
horde                     /usr/bin/horde-set-perms
horde                     /usr/bin/horde-sql-shell
horde                     /usr/bin/horde-themes
horde                     /usr/bin/horde-translation


[mrjhb3]

The file DOES belong in user bin.  It's there on all 4 of my systems.  It's been that same way, since the first time I released the packages.  You didn't provide me the output or answer the other questions I asked for, so I have no way of knowing what your issue is/was.


John

[holck]

Sorry, I wanted to help and thought I found a bug. I don't know much about php, but as I read the source code in horde-db-migrate, it tries to find /usr/lib/Application.php which isn't there, and then the program fails. So the problem may be related to the include_path. The file /etc/php.ini on my server shows

Code: [Select]

include_path                           = ".:/usr/share/pear-addons:/usr/share/pear"

Code: [Select]

$ php -v
PHP 5.3.3 (cli) (built: Jul  9 2015 17:39:00)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies


Code: [Select]

$ pear list
Installed packages, channel pear.php.net:
=========================================
Package                   Version  State
Archive_Tar               1.4.0    stable
Auth_SASL                 1.0.6    stable
Auth_SASL2                0.1.0    beta
Cache                     1.5.6    stable
Cache_Lite                1.7.16   stable
Console_Color             1.0.3    stable
Console_Getargs           1.3.5    stable
Console_Getopt            1.3.1    stable
Console_GetoptPlus        1.0.0RC1 beta
Console_Table             1.2.1    stable
Crypt_Blowfish            1.1.0RC2 beta
DB                        1.8.2    stable
Date                      1.5.0a4  alpha
Date_Holidays             0.21.8   alpha
Date_Holidays_Australia   0.2.2    alpha
Date_Holidays_Denmark     0.1.3    alpha
Date_Holidays_Germany     0.1.2    alpha
Date_Holidays_Italy       0.1.1    alpha
Date_Holidays_Netherlands 0.1.4    alpha
Date_Holidays_Norway      0.1.2    alpha
Date_Holidays_Portugal    0.1.1    alpha
Date_Holidays_Russia      0.1.0    alpha
Date_Holidays_Slovenia    0.1.2    alpha
Date_Holidays_Sweden      0.1.3    alpha
Date_Holidays_Turkey      0.1.1    alpha
Date_Holidays_USA         0.1.1    alpha
File                      1.4.1    stable
File_CSV                  1.0.0    stable
File_Find                 1.3.3    stable
File_Fstab                2.0.3    stable
File_Util                 1.0.0    stable
HTTP                      1.4.1    stable
HTTP_Request              1.4.4    stable
HTTP_Request2             2.2.1    stable
HTTP_WebDAV_Server        1.0.0RC8 beta
Image_Text                0.6.1    beta
Log                       1.12.9   stable
MDB2                      2.5.0b5  beta
MDB2_Driver_mysql         1.5.0b4  beta
Mail                      1.2.0    stable
Mail_Mime                 1.9.0    stable
Mail_mimeDecode           1.5.5    stable
Math_BigInteger           1.0.2    stable
Net_DIME                  1.0.2    stable
Net_DNS2                  1.4.1    stable
Net_FTP                   1.4.0    stable
Net_IDNA2                 0.1.1    beta
Net_IMAP                  1.1.3    stable
Net_SMTP                  1.6.3    stable
Net_Sieve                 1.3.4    stable
Net_Socket                1.0.14   stable
Net_URL                   1.0.15   stable
Net_URL2                  2.2.0    stable
Numbers_Words             0.16.2   beta
PEAR                      1.9.5    stable
SOAP                      0.13.0   beta
Services_Weather          1.4.7    stable
Structures_Graph          1.0.4    stable
Text_CAPTCHA              0.4.4    alpha
Text_Figlet               1.0.2    stable
Text_Password             1.1.1    stable
XML_Parser                1.3.4    stable
XML_Parser2               0.1.0    beta
XML_RPC                   1.5.5    stable
XML_RPC2                  1.1.2    stable
XML_SVG                   1.1.0    stable
XML_Serializer            0.20.2   beta
XML_Util                  1.2.3    stable


Code: [Select]

]$ pear list -c horde
Installed packages, channel pear.horde.org:
===========================================
Package                      Version State
Horde_ActiveSync             2.29.0  stable
Horde_Alarm                  2.2.5   stable
Horde_Argv                   2.0.11  stable
Horde_Auth                   2.1.10  stable
Horde_Autoloader             2.1.1   stable
Horde_Browser                2.0.10  stable
Horde_Cache                  2.5.0   stable
Horde_Cli                    2.0.6   stable
Horde_Compress               2.1.3   stable
Horde_Compress_Fast          1.1.0   stable
Horde_Constraint             2.0.2   stable
Horde_Controller             2.0.3   stable
Horde_Core                   2.20.8  stable
Horde_Crypt                  2.6.1   stable
Horde_Crypt_Blowfish         1.1.0   stable
Horde_CssMinify              1.0.2   stable
Horde_Css_Parser             1.0.7   stable
Horde_Data                   2.1.3   stable
Horde_Date                   2.1.1   stable
Horde_Date_Parser            2.0.4   stable
Horde_Dav                    1.1.2   stable
Horde_Db                     2.2.3   stable
Horde_Editor                 2.0.4   stable
Horde_ElasticSearch          1.0.3   stable
Horde_Exception              2.0.6   stable
Horde_Feed                   2.0.3   stable
Horde_Form                   2.0.11  stable
Horde_Group                  2.0.5   stable
Horde_HashTable              1.2.3   stable
Horde_History                2.3.5   stable
Horde_Http                   2.1.5   stable
Horde_Icalendar              2.1.1   stable
Horde_Idna                   1.0.3   stable
Horde_Image                  2.3.2   stable
Horde_Imap_Client            2.29.1  stable
Horde_Injector               2.0.4   stable
Horde_Itip                   2.1.0   stable
Horde_JavascriptMinify       1.1.2   stable
Horde_JavascriptMinify_Jsmin 1.0.1   stable
Horde_Ldap                   2.3.1   stable
Horde_ListHeaders            1.2.2   stable
Horde_Lock                   2.1.1   stable
Horde_Log                    2.1.2   stable
Horde_LoginTasks             2.0.5   stable
Horde_Mail                   2.6.2   stable
Horde_Mail_Autoconfig        1.0.2   stable
Horde_Mapi                   1.0.5   stable
Horde_Mime                   2.9.1   stable
Horde_Mime_Viewer            2.1.1   stable
Horde_Nls                    2.0.5   stable
Horde_Notification           2.0.2   stable
Horde_Oauth                  2.0.3   stable
Horde_Pack                   1.0.5   stable
Horde_Pdf                    2.0.5   stable
Horde_Perms                  2.1.5   stable
Horde_Prefs                  2.7.4   stable
Horde_Queue                  1.1.2   stable
Horde_Rdo                    2.0.4   stable
Horde_Role                   1.0.1   stable
Horde_Routes                 2.0.4   stable
Horde_Rpc                    2.1.5   stable
Horde_Scribe                 2.0.2   stable
Horde_Secret                 2.0.4   stable
Horde_Serialize              2.0.4   stable
Horde_Service_Facebook       2.0.8   stable
Horde_Service_Twitter        2.1.5   stable
Horde_Service_Weather        2.1.6   stable
Horde_SessionHandler         2.2.4   stable
Horde_Share                  2.0.7   stable
Horde_Smtp                   1.9.1   stable
Horde_Socket_Client          2.0.0   stable
Horde_SpellChecker           2.1.2   stable
Horde_Stream                 1.6.2   stable
Horde_Stream_Filter          2.0.3   stable
Horde_Stream_Wrapper         2.1.2   stable
Horde_Stringprep             1.0.2   stable
Horde_Support                2.1.4   stable
Horde_SyncMl                 2.0.5   stable
Horde_Template               2.0.2   stable
Horde_Text_Diff              2.1.1   stable
Horde_Text_Filter            2.3.2   stable
Horde_Text_Filter_Csstidy    2.0.1   stable
Horde_Text_Flowed            2.0.2   stable
Horde_Thrift                 2.0.2   stable
Horde_Timezone               1.0.9   stable
Horde_Token                  2.0.6   stable
Horde_Translation            2.2.0   stable
Horde_Tree                   2.0.4   stable
Horde_Url                    2.2.4   stable
Horde_Util                   2.5.6   stable
Horde_Vfs                    2.3.0   stable
Horde_View                   2.0.5   stable
Horde_Xml_Element            2.0.3   stable
Horde_Xml_Wbxml              2.0.2   stable
content                      2.0.4   stable
horde                        5.2.7   stable
horde_lz4                    1.0.7   stable
imp                          6.2.10  stable
ingo                         3.2.6   stable
kronolith                    4.2.9   stable
mnemo                        4.2.7   stable
nag                          4.2.5   stable
timeobjects                  2.1.0   stable
turba                        4.2.8   stable


[mrjhb3]

From what I can tell, it looks like you have installed some packages from remi's repo.  If you have, then that could be very well why you are having issues.  I don't include horde_lz4, but remi has built an rpm for it.  Remi's PEAR-1.9.5 rpm broke things, so I don't use that either.  I also don't include net_IDNA2, Numbers_Words, Text_Captcha, Text_Passwords.  You will have to verify if you used files from him.   A standard SME server 9 install with all updates works with no issues when adding horde in all tests I have done.


Thank you,


John

[tariqf]

Hi guys sorry I'm confused how to get the admin login and settings as per the screenshot on this thread.

If I login as admin I do not get the "configuration" section on the left pane. On my SME consoile I see this error at the same time - it looks like horde does not think I am an admin?

 HORDE: [horde] Permission denied. [pid 2229 on line 373 of "/usr/share/pear/Horde/Registry.php"]

I also tried editing /home/httpd/html/horde/config/conf.php to set as below but still it does not think I'm ad admin!

$conf['auth']['admins'] = array('admin@mydomain.local', 'admin');

So what do I do to get the admin interface please?

[mrjhb3]

The admin user is automatically added.  To add more:

Code: [Select]

config setprop horde Admins user1,user2

Code: [Select]

expand-template /home/httpd/html/horde/config/conf.php
When you login, you should be able to click on the gear icon, choose Administration, configuration.  If you still don't see it, click on the word horde at the top left, then look at the right and note who you are logged in as. Reply back with that, and show what you have listed in
$conf['auth']['admins'] = array

from /home/httpd/html/horde/config/conf.php

John

[tariqf]

Hi John, that's great I now see the administration menu thanks. I had to add manually my user which was admin@number into the config file.

I also had to increase the php memory limit so I could see the horde config page

[bunkobugsy]

Upgraded without errors, works great, especially the mobile version.
Should be pushed for everyone, old H3 freezes on phones after login.

[miroj]

Hi John,

I have downloaded the latest Horde 5.2 RPMS zip archive dated July 29th. I do have two issues/questions:

1. There is no installation script in the zip file (missing Install-horde52.sh) only RPMS

2. I would like to install on SME 9.1 64 bit version, in the RPMS there are Horde_Form-2.0.13-1.el6.noarch.rpm and Horde_Form-2.0.14-1.el6.noarch.rpm which makes an issue to just execute yum localinstall *.rpm

Any guidance how to proceed?

Thanks,

Miro

[bunkobugsy]

I noticed the missing script too. You need to copy all RPMs from the subdir coresponding to your architecture and then try: yum localinstall *.rpm

[DanB35]

"localinstall" isn't necessary with current versions of yum; "yum install whatever" works just as well.

[mrjhb3]

Sorry about that.  I was uploading some updates, and forgot that file.  I'm re-uploading everything as of this post.


John