beddo

Well-Known Member
Jan 19, 2007
159
1
168
England
cPanel Access Level
DataCenter Provider
Horde isn't working on our server (FreeBSD 6.2) (it used to so not sure when it went awry). You get the language prompt and continually kicked back to it. Turning on a debug log in horde gives loads of sql errors too.

mysql.sock exists and there are no other known problems with mysql..can anyone enlighten me to the problem? I found a post that mentioned installing libfam, the closest I could find was /usr/ports/devel/fam and that made no difference.

# ls -al /tmp/mysql.sock
srwxrwxrwx 1 mysql wheel 0 May 1 18:16 /tmp/mysql.sock

# ./fullhordereset

New horde password: *******

[: mysqld is alive: unexpected operator
[: localhost: unexpected operator
[: 3.1.3: unexpected operator
Archiving current Horde data to /var/cpanel/horde/horde.backup.sql.1178039817
Cleaning old Horde data archives
Skipping /var/cpanel/horde/horde.backup.sql.1178039817 (archived)
Skipping /var/cpanel/horde/horde.backup.sql.1178039773 (archived)
Skipping /var/cpanel/horde/horde.backup.sql.1178039233 (archived)
Skipping /var/cpanel/horde/horde.backup.sql.1178037845 (archived)
/var/cpanel/horde/horde.backup.sql.1178036947
[: 0: unexpected operator
Database "horde" dropped
Creating Horde database
ERROR 2013 (HY000) at line 61: Lost connection to MySQL server during query
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[: unexpected operator
Updating Pear modules ...Done
Restoring Horde data
Resyncing Horde database items
DBD::mysql::st execute failed: Table 'horde.horde_vfs' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
DBD::mysql::st execute failed: Table 'horde.kronolith_events' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
DBD::mysql::st execute failed: Table 'horde.kronolith_storage' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
DBD::mysql::st execute failed: Table 'horde.mnemo_memos' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
DBD::mysql::st execute failed: Table 'horde.nag_tasks' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
DBD::mysql::st execute failed: Table 'horde.turba_objects' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
Done. Horde updated to 3.1.3

Your horde password is above. Horde has been reset
 

rjf1505

Member
Apr 16, 2005
8
0
151
Hi,

I have had the same problems with HORDE.

My solution was to go to the horde database via WHM.
I sometimes needed to repair the session table and once i needed to empyt this table when repair was not possible anymore.

This solved my problems

Regards,
Robert-Jan
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
libfam or gamin are only necessary for RPM based OSs.

drop/create the horde_sesssion table or simply delete everything from it.

If it was created as an InnoDB type table, and then later you added skip-innodb to /etc/my.cnf, you can get this issue.
 

beddo

Well-Known Member
Jan 19, 2007
159
1
168
England
cPanel Access Level
DataCenter Provider
I disabled horde a while back seen as I couldn't get it working and forgot about this thread.

It is still broken with the same errors
If I manually drop the horde database it gets recreated with horde_users as the only table.

The line mentioned doesn't exist in any of the my.cnf files on the server.

Its like the first query when creating the database is erroring out and the script doesn't understand this so it cannot do anything else once the connection to the database drops.
 

IPSecureNetwork

Well-Known Member
May 28, 2005
97
0
156
i have the same problem in
WHM 11.2.0 cPanel 11.6.0-R15076
FREEBSD 6.2-RELEASE-p3 i386 - WHM X v3.1.0
horde just back to the login screen when the customers try to join .

full horde reset doesnt works.

:\
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
OK, just did a test install on FreeBSD 6.1 The only issue that prevented Horde from working properly was courier wasn't running. Once it was started, Horded worked fine.

Another server, FreeBSD 6.2, also has no issue running Horde. Would one of you mind opening a support ticket so we can determine what is happening?

Thanks
 

beddo

Well-Known Member
Jan 19, 2007
159
1
168
England
cPanel Access Level
DataCenter Provider
I can't open a ticket as I don't have direct support. My hosting provider won't do anything either as I have an unmanaged server. The problem has arisen during upgrades as our server was originally running 10.something not 11. It was after that upgrade that horde stopped working.

Is there by any chance an sql somewhere that can be used to recreate the horde db table manually?
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
/usr/local/cpanel/base/horde/scripts/sql/create.mysql.sql will create the tables for you. You'll need to pipe it into the mysql process:

Code:
# mysql < /usr/local/cpanel/base/horde/scripts/sql/create.mysql.sql
I'm sorry to hear about the lack of support for your server. There are a number of people and companies that offer support and can likely help you with this; search the forum.

What do the login attempts look like in /var/log/maillog ?
 

beddo

Well-Known Member
Jan 19, 2007
159
1
168
England
cPanel Access Level
DataCenter Provider
Loading the SQL file manually has solved the problem thanks! I'll leave fullhordereset alone in future seen as it just seems to be that which can't talk to the database properly.

Cheers for helping me get Horde back. Squirrelmail is great but isn't quite as shiney for end users :)
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
Loading the SQL file manually has solved the problem thanks! I'll leave fullhordereset alone in future seen as it just seems to be that which can't talk to the database properly.

Cheers for helping me get Horde back. Squirrelmail is great but isn't quite as shiney for end users :)
Sorry it took so long, but I am glad it's working again.
 
Thread starter Similar threads Forum Replies Date
A Email 0
speckados Email 3