[horde] Successful install, cannot login (Fatal error) Suspect outdated database schemas - How to upgrade from CLI?

[Louis-Philippe Allard]

Hey there,

moments after I posted my request on the maillist, I found this script on a
Cpanel forum... I tried it but it didnt work.  Apparently, all of my DB
schemas were already up tp date...

[root at centos-productive log]# /usr/bin/horde-db-migrate
[  INFO  ] Migrating DB up.
[  INFO  ] Current imp schema version: 3
[  INFO  ] Ending imp schema version: 3
[  INFO  ] Current ingo schema version: 6
[  INFO  ] Ending ingo schema version: 6
[  INFO  ] Current kronolith schema version: 22
[  INFO  ] Ending kronolith schema version: 22
[  INFO  ] Current turba schema version: 11
[  INFO  ] Ending turba schema version: 11
[  INFO  ] Current nag schema version: 13
[  INFO  ] Ending nag schema version: 13
[  INFO  ] Current mnemo schema version: 7
[  INFO  ] Ending mnemo schema version: 7
[  INFO  ] Current trean schema version: 5
[  INFO  ] Ending trean schema version: 5
[  INFO  ] Current gollem schema version: 3
[  INFO  ] Ending gollem schema version: 3
[  INFO  ] Current content schema version: 2
[  INFO  ] Ending content schema version: 2
[  INFO  ] Current Horde_ActiveSync schema version: 21
[  INFO  ] Ending Horde_ActiveSync schema version: 21
[  INFO  ] Current Horde_Alarm schema version: 2
[  INFO  ] Ending Horde_Alarm schema version: 2
[  INFO  ] Current Horde_Auth schema version: 1
[  INFO  ] Ending Horde_Auth schema version: 1
[  INFO  ] Current Horde_Cache schema version: 2
[  INFO  ] Ending Horde_Cache schema version: 2
[  INFO  ] Current Horde_Core schema version: 1
[  INFO  ] Ending Horde_Core schema version: 1
[  INFO  ] Current Horde_Dav schema version: 2
[  INFO  ] Ending Horde_Dav schema version: 2
[  INFO  ] Current Horde_Group schema version: 3
[  INFO  ] Ending Horde_Group schema version: 3
[  INFO  ] Current Horde_History schema version: 6
[  INFO  ] Ending Horde_History schema version: 6
[  INFO  ] Current Horde_Imap_Client schema version: 2
[  INFO  ] Ending Horde_Imap_Client schema version: 2
[  INFO  ] Current Horde_Lock schema version: 3
[  INFO  ] Ending Horde_Lock schema version: 3
[  INFO  ] Current Horde_Perms schema version: 2
[  INFO  ] Ending Horde_Perms schema version: 2
[  INFO  ] Current Horde_Prefs schema version: 3
[  INFO  ] Ending Horde_Prefs schema version: 3
[  INFO  ] Current Horde_Queue schema version: 1
[  INFO  ] Ending Horde_Queue schema version: 1
[  INFO  ] Current Horde_SessionHandler schema version: 2
[  INFO  ] Ending Horde_SessionHandler schema version: 2
[  INFO  ] Current Horde_SyncMl schema version: 1
[  INFO  ] Ending Horde_SyncMl schema version: 1
[  INFO  ] Current Horde_Token schema version: 1
[  INFO  ] Ending Horde_Token schema version: 1
[  INFO  ] Current Horde_Vfs schema version: 4
[  INFO  ] Ending Horde_Vfs schema version: 4


Obviuously I have another problem!  What could it be??


On Sun, Aug 31, 2014 at 8:02 PM, Luis Felipe Marzagao <
lfbm.andamentos at gmail.com> wrote:

>
> On 31-08-2014 18:41, Louis-Philippe Allard wrote:
>
>> Hello
>>
>> So I just rebuilt a CentOS 6.5 virtual server and installed Horde
>> following
>> the instructions available on the horde/Install webpage.
>>
>> All went well.  Then I configured the general settings in
>> horde/config/confi.php and imp/config/backends.php to use Gmail as the
>> login backend.
>>
>> I can access Horde's login page but I cannot login.  Whatever credentials
>> I
>> try, I immediately get a white page saying
>>
>> A fatal error has occurredQUERY FAILED: Unknown column 'object_uid' in
>> 'where clause' DELETE FROM horde_histories WHERE object_uid IN
>> ('lp.allard.1 at gmail.com@logins.failed')Details have been logged for the
>> administrator.
>>
>>
>> Reading this message I suspect my horde database is out of date and needs
>> updating.  As a matter of fact, the last time I used horde was about 4
>> months ago (cant remember the exact horde release I was running back then
>> but definitekly not the current one.
>>
>>
>> Its worth mentioning that I am reusing an existing DB (mysqli) from my
>> previous install.
>>
>>
>> How do I update the DB schemas from the command line?  SInce I cannot
>> login
>> as admin, I cannot upgrade the DB schemas from the horde interface..
>>
>
> Try 'horde-db-migrate' command.
>
>
>> Any insight is appreciated!
>>
>>
>> Thanks!
>>
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>