Koozali.org: home of the SME Server

Upgrade to 6.0b3 horde upgrade errors, no access to email

John Lewis

Upgrade to 6.0b3 horde upgrade errors, no access to email
« on: October 30, 2003, 08:27:07 AM »
I just upgraded my 5.6u4 box to 6.0b3 so that I could participate with testing and helpting Mitel make this a better product...

I'm getting the following in my /var/log/boot.log:
Oct 30 00:01:26 gluon mysql.init: Loading 20horde.mysql_update_privs.sql into mysql succeeded
Oct 30 00:01:26 gluon mysql: ERROR 1007 at line 43: Can't create database 'horde'. Database exists
Oct 30 00:01:26 gluon mysql.init: Loading 30mysql.create.horde.sql into mysql failed
Oct 30 00:01:26 gluon mysql.init: Loading 30mysql_create_tables.sql into mysql succeeded
Oct 30 00:01:27 gluon 50turba_upgrade_1.1_to_1.2: DBD::mysql::st execute failed: alter command denied to user: 'horde@localhost' for table 'turba_objects' at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 64.
Oct 30 00:01:27 gluon 50turba_upgrade_1.1_to_1.2: DBD::mysql::st execute failed: alter command denied to user: 'horde@localhost' for table 'turba_objects' at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 64.
Oct 30 00:01:27 gluon mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed
Oct 30 00:01:27 gluon mysql.init: Loading 60migrate-imp-to-turba into mysql succeeded
When i try to log into webmail, i get the following with any account in  var/log/messages:
Oct 30 00:10:44 gluon HORDE[2288]: [imp] FAILED LOGIN 192.168.1.240 to localhost:143[imap/notls] as admin [on line 282 of "/home/httpd/html/horde/imp/lib/IMP.php"]
Oct 30 00:10:44 gluon HORDE[2288]: PHP Notice:  (null)(): LOGIN failed (errflg=1) in Unknown on line 0
Oct 30 00:10:44 gluon HORDE[2288]: PHP Notice:  (null)(): Too many login failures (errflg=2) in Unknown on line 0
Oct 30 00:10:44 gluon HORDE[2288]: PHP Notice:  (null)(): Unexpected untagged message: LOGGING (errflg=1) in Unknown on line 0

This is my first major problem after the upgrade, and is a show stopper, since I can't connect to my email...  My IMAP outlook client can't connect either.

Any suggestions?

Michael Soulier

Re: Upgrade to 6.0b3 horde upgrade errors, no access to emai
« Reply #1 on: October 31, 2003, 03:50:56 AM »
John Lewis wrote:
>
> I just upgraded my 5.6u4 box to 6.0b3 so that I could
> participate with testing and helpting Mitel make this a
> better product...

Excellent. Thank you.

> Any suggestions?

Yes. Report the bug to smebugs@mitel.com. As always.

Regards,
Mike

John Lewis

Re: Upgrade to 6.0b3 horde upgrade errors, no access to emai
« Reply #2 on: November 03, 2003, 07:53:00 PM »
I gave up trying to get email authentication to work, and did a clean 6.0b3 install by doing the following:

use "backup to desktop" to backup user stuff etc on broken system
clean install 6.0b3
restore from desktop... didn't work, browser kept timing out, so I scp'd the smeserver.tgz to the new server, and untarred it from the / directory, then did a post update and reboot.

This appears to have worked, though it did not restore anything in the /opt directory, nor any!!!! of the sql databases.

AFAIAK, this sux that the regular backup does not maintain myql database info., nor stuff in /opt  which is where my custom installs are..

Sigh.

Time to look at Shad's arkeia stuff