Topic: Horde 5.2 on SME9

[mrjhb3]

Hi John

It looks like I may have some missing mysql tables.
When I click on the Calendar, Address Book, Tasks or Notes it generates an error about not finding the table.
When I have a look at the listed Horde tables some are missing hence the errors from the browser interface.
Is there a way to repair/restore the tables? Something with the table migration may not have gone right at some point.

Thank for your help

Yes, that is what I figured, which is why I was having you run the horde-db-migrate script.  It updates/migrates the tables.  What php version are you running?
On my system:
                          php -v
PHP 5.3.3 (cli) (built: Aug 11 2016 20:33:53)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies


If you happen to be running anything else, I'm not going to be able to help much.

Try running the migrate script again, but in another session tail -f /var/log/messages and see what it's showing.  Also, what do you get when you run pear list -c horde.

[edb]

Hi John,

I ran the command again and here is the output of the log

Code: [Select]

[root@~]# tail -f /var/log/messages
Oct  6 22:01:32 defcon1 HORDE: [mnemo] SQL QUERY FAILED: Table 'horde.mnemo_shar
es' doesn't exist   #011SHOW FIELDS FROM `mnemo_shares` [pid 2401 on line 316 of
 "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Oct  6 22:01:32 defcon1 HORDE: [mnemo] QUERY FAILED: Table 'horde.mnemo_shares'
doesn't exist  SHOW FIELDS FROM `mnemo_shares` [pid 2401 on line 317 of "/usr/sh
are/pear/Horde/Db/Adapter/Mysqli.php"]



Code: [Select]

[root@~]# php -v
PHP 5.3.3 (cli) (built: Aug 11 2016 20:33:53)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
    with Zend Guard Loader v3.3, Copyright (c) 1998-2010, by Zend Technologies


Code: [Select]

Installed packages, channel pear.horde.org:
===========================================
Package                      Version State
Horde_ActiveSync             2.35.0  stable
Horde_Alarm                  2.2.8   stable
Horde_Argv                   2.0.12  stable
Horde_Auth                   2.2.0   stable
Horde_Autoloader             2.1.2   stable
Horde_Browser                2.0.12  stable
Horde_Cache                  2.5.4   stable
Horde_Cli                    2.0.7   stable
Horde_Compress               2.1.5   stable
Horde_Compress_Fast          1.1.1   stable
Horde_Constraint             2.0.3   stable
Horde_Controller             2.0.4   stable
Horde_Core                   2.26.1  stable
Horde_Crypt                  2.7.3   stable
Horde_Crypt_Blowfish         1.1.2   stable
Horde_CssMinify              1.0.2   stable
Horde_Css_Parser             1.0.11  stable
Horde_Data                   2.1.4   stable
Horde_Date                   2.3.1   stable
Horde_Date_Parser            2.0.6   stable
Horde_Dav                    1.1.3   stable
Horde_Db                     2.3.3   stable
Horde_Editor                 2.0.4   stable
Horde_ElasticSearch          1.0.3   stable
Horde_Exception              2.0.8   stable
Horde_Form                   2.0.15  stable
Horde_Group                  2.1.1   stable
Horde_HashTable              1.2.6   stable
Horde_History                2.3.6   stable
Horde_Http                   2.1.7   stable
Horde_Icalendar              2.1.4   stable
Horde_Idna                   1.0.4   stable
Horde_Image                  2.3.6   stable
Horde_Imap_Client            2.29.9  stable
Horde_Injector               2.0.5   stable
Horde_Itip                   2.1.2   stable
Horde_JavascriptMinify       1.1.3   stable
Horde_JavascriptMinify_Jsmin 1.0.2   stable
Horde_Ldap                   2.3.2   stable
Horde_ListHeaders            1.2.4   stable
Horde_Lock                   2.1.4   stable
Horde_Log                    2.2.0   stable
Horde_LoginTasks             2.0.7   stable
Horde_Mail                   2.6.3   stable
Horde_Mail_Autoconfig        1.0.3   stable
Horde_Mapi                   1.0.8   stable
Horde_Mime                   2.10.1  stable
Horde_Mime_Viewer            2.2.1   stable
Horde_Nls                    2.2.0   stable
Horde_Notification           2.0.4   stable
Horde_Oauth                  2.0.3   stable
Horde_Pack                   1.0.6   stable
Horde_Pdf                    2.0.7   stable
Horde_Perms                  2.1.7   stable
Horde_Prefs                  2.8.0   stable
Horde_Queue                  1.1.4   stable
Horde_Rdo                    2.1.0   stable
Horde_Role                   1.0.1   stable
Horde_Routes                 2.0.5   stable
Horde_Rpc                    2.1.7   stable
Horde_Scribe                 2.0.2   stable
Horde_Secret                 2.0.6   stable
Horde_Serialize              2.0.5   stable
Horde_Service_Facebook       2.0.9   stable
Horde_Service_Twitter        2.1.5   stable
Horde_Service_Weather        2.4.0   stable
Horde_SessionHandler         2.2.8   stable
Horde_Share                  2.1.1   stable
Horde_Smtp                   1.9.3   stable
Horde_Socket_Client          2.1.1   stable
Horde_SpellChecker           2.1.3   stable
Horde_Stream                 1.6.3   stable
Horde_Stream_Filter          2.0.4   stable
Horde_Stream_Wrapper         2.1.3   stable
Horde_Stringprep             1.0.3   stable
Horde_Support                2.1.5   stable
Horde_SyncMl                 2.0.7   stable
Horde_Template               2.0.3   stable
Horde_Text_Diff              2.1.2   stable
Horde_Text_Filter            2.3.5   stable
Horde_Text_Filter_Csstidy    2.0.1   stable
Horde_Text_Flowed            2.0.3   stable
Horde_Thrift                 2.0.2   stable
Horde_Timezone               1.0.11  stable
Horde_Token                  2.0.9   stable
Horde_Translation            2.2.1   stable
Horde_Tree                   2.0.4   stable
Horde_Url                    2.2.5   stable
Horde_Util                   2.5.8   stable
Horde_Vfs                    2.3.3   stable
Horde_View                   2.0.6   stable
Horde_Xml_Element            2.0.4   stable
Horde_Xml_Wbxml              2.0.3   stable
content                      2.0.5   stable
horde                        5.2.12  stable
imp                          6.2.16  stable
ingo                         3.2.12  stable
kronolith                    4.2.18  stable
mnemo                        4.2.11  stable
nag                          4.2.11  stable
timeobjects                  2.1.2   stable
turba                        4.2.16  stable


[edb]

John how would I do a complete removal or reverse of the install script.
Since it was a yum localinstall of *.rpm how would I uninstall all of them or is that possible.
What would the command be to do that?
I may not have done it completely the last time as I manually selected all of the newly installed horde rpms and removed them then ran the install script again but I don't think I removed everything that was installed which may be why I have the issue.
Likely there is no easy way to do this ...

It seems that kronolith, mnemo, nag and turba seem to have the problem with the mysql tables.
Maybe these components didn't install properly or at all therefore the tables were not created.
Does simply running the script install all of those components or does one have to do additional steps?

[edb]

Hi John,

I gave up on that particular install and fired up another VM of SME Server 9.1 with all updates installed then installed via the script.
Install went through with signal-event post-upgrade; signal-event reboot.
I noticed at the point where the migration was to happen a few items in red but it went past to quick for me to get a good look at what may have failed.
Upon reboot I logged into Webmail again and I again have the same results as before.

This is what I could capture as output from running the script: Will send separately as it is too big to attach

Also attached at bottom of file the output of tail -f /var/log/messages after the reboot.

[toothandnail]

I've been looking for a replacement for SoGo on a number of SME 9.1 servers, saw this thread and decided to try it. Download and install all went without any visible problems, and after a restart I can access the new Horde login page. However, when I enter my username and password, it waits fora second or two and then cycles back to the login prompt.

Looking at the logs, I've got this:

Code: [Select]

Nov  2 19:31:12 goldie HORDE: [horde] Login success for paul@co.uk to horde (2.102.163.33) [pid 2775 on line 164 of "/home/httpd/html/horde/login.php"]
Nov  2 19:31:12 goldie HORDE: [imp] Login success for paul (Horde user paul@co.uk) (2.102.163.33) to {imap://localhost/} [pid 2775 on line 157 of "/home/httpd/html/horde/imp/lib/Auth.php"]
When I deliberately mistyped my password, I got this:

Code: [Select]

Nov  2 19:31:37 goldie HORDE: [imp] [login] Authentication failed. [pid 2780 on line 730 of "/home/httpd/html/horde/imp/lib/Imap.php"]
Nov  2 19:31:37 goldie HORDE: [horde] FAILED LOGIN for paul to horde (2.102.163.33) [pid 2780 on line 199 of "/home/httpd/html/horde/login.php"]
This is a remote login attempt, using https://domain/webmail to access the page. I notice in the log that the domain name is truncated, but did see some mention of that in some of the earlier posts.

It seems to be accepting my correct password, just not loading Horde for me.

Any ideas? I'd really like to try this one - never very happy with the older version of Horde.

Paul.

[mrjhb3]

Try doing the same from this post, https://forums.contribs.org/index.php/topic,50969.msg271247.html#msg271247.  I haven't had time to look into how to possibly permanently fix this yet.

John

[toothandnail]

Try doing the same from this post, https://forums.contribs.org/index.php/topic,50969.msg271247.html#msg271247.  I haven't had time to look into how to possibly permanently fix this yet.

John

Thanks John. That fixed the truncated domain name problem, but I still can't login:

Code: [Select]

ov  2 23:45:33 goldie HORDE: [horde] Login success for paul@xxxx.co.uk to horde (2.102.163.33) [pid 2691 on line 164 of "/home/httpd/html/horde/login.php"]
Nov  2 23:45:33 goldie HORDE: [imp] Login success for paul (Horde user paul@xxxxx.co.uk) (2.102.163.33) to {imap://localhost/} [pid 2691 on line 157 of "/home/httpd/html/horde/imp/lib/Auth.php"]
Nov  2 23:45:34 goldie HORDE: Guest user is not authorized for Mail (Host: host-2-102-163-33.as13285.net). [pid 2691 on line 324 of "/usr/share/pear/Horde/Registry.php"]
The SME server I'm using is a production server, but its been around for a long time - it has been migrated through every version since 2007, and does have a couple of odd problems, though I've never had problems logging into the standard Horde. I checked that I could do so before I went through the 5.2 install.

Any other ideas?

Paul

[toothandnail]

Just a small follow-up on this. My earlier attempts were all from remote. I'm now on site and I've been able to log in without any problems from within the local network. Looks good once I got there...

I've also been able to send mail successfully from within the local network. Now all I need to know is what is preventing me logging in when I'm not in the local network.

Paul.

[bunkobugsy]

I've had some problems myself right after upgrade, had to clear cache/cookies.
Kept seeing in the logs users failing to log in, but after running CCleaner it worked.
No ideea what was the cause of this, maybe some cookies from Horde3 were conflicting.

[toothandnail]

I've had some problems myself right after upgrade, had to clear cache/cookies.
Kept seeing in the logs users failing to log in, but after running CCleaner it worked.
No ideea what was the cause of this, maybe some cookies from Horde3 were conflicting.

Thanks. Seems something like that may have been causing my login problems. When I tried logging in from the local network this morning, I used Chromium rather than Seamonkey. I'm now back home and I can log in with either Chromium or Seamonkey. So whatever it was seems to have been cleared by my using a different browser for login.

Paul.

[calisun]

Hi John,
today I have upgraded to Horde 5.2
Install went well.
I did have issue logging in at first, but after clearing my cookies and restarting the browser, I logged in fine.

Now I have another issue, when I go to my calendar, all the events I had inputted before are gone.
As per your suggestion in earlier post, I did run:

Code: [Select]

php /usr/bin/horde-db-migrate
But afterwards, calendar is still empty.
When I first start calendar, I see following message pup-up for few seconds on top of calendar:



-UPDATE-
When I go to Log Files I see this:

Code: [Select]

HORDE: [kronolith] SQL QUERY FAILED: Unknown column 'event_timezone' in 'field list'   #011SELECT event_id, event_uid, event_description, event_location, #011  event_private, event_status, event_attendees, event_title, #011  event_recurcount, event_url, event_timezone, event_recurtype, #011  event_recurenddate, event_recurinterval, event_recurdays, event_start, #011  event_end, event_allday, event_alarm, event_alarm_methods, #011  event_modified, event_exceptions, event_creator_id, event_resources, #011  event_baseid, event_exceptionoriginaldate FROM kronolith_events WHERE #011  calendar_id = 'xxxxx@xxxxxx' AND ((event_end >= '2017-01-29 #011  08:00:00' AND event_start <= '2017-03-05 07:59:59') OR #011  (event_recurenddate >= '2017-01-29 08:00:00' AND event_start <= #011  '2017-03-05 07:59:59' AND event_recurtype <> 0)) [pid 16839 on line 316 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]

I have several of these notices.

Also one strange notice:

Code: [Select]

HORDE: Guest user is not authorized for Horde (Host: c-##-##-##-##.xx.comcast.net). [pid 16683 on line 324 of "/usr/share/pear/Horde/Registry.php"]
but that is my IP address and I am logged in, so why it is saying "Guest"?

Also, my address book is empty.

[mrjhb3]

Did you have any custom templates that you used with the older version of horde?  What is the output of the php /usr/bin/horde-db-migrate command?

[bunkobugsy]

@calisun

Close your browsers, clear your cache and cookies (run CCleaner). See above...

[calisun]

@calisun

Close your browsers, clear your cache and cookies (run CCleaner). See above...

bunkobugsy, your suggestion only works on fixing log in issues (which I had and which I fixed by clearing cache)
This is a database issue.

John, what is the command to Uninstall Horde 5.2 ? I did this update on my production server and I need it back up ASAP.
I will continue testing on my test server, but I need production server working.

[mrjhb3]

To my knowledge, the database tables can't be reverted.  For the restore process, this is pure speculation.  You'll have to uninstall all of the horde rpm's, then install whatever version you were using before, then restore the horde db to a time before you did your upgrade, then signal-event post-upgrade ; signal-event reboot, and hope it comes back.  I've never personally done this.

Might be better to try and fix what happened when you upgraded.  I would run the migrate command again and post the output of it, might want to tail -f /var/log/messages as well in case there is anything different being shown.  If you have a lot of data, then it's possible the 2 times this is run by default, isn't enough for your installation.  I haven't experienced this, but I believe a few people did on the horde list and that was the suggestion given.

John