Topic: SME 6.0beta3 upgrade to Final 6.0 - No Webmail??

[Denbert]

Hi there,

After an upgrade from 6.0beta3 to final 6.0 the server responds with this answer after trying to login on webmail:

 “A fatal error has occurred:

DB Error: connect failed

[line 108 of /home/httpd/html/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.”  

[Log]
Dec 13 14:52:05 server mysql: ERROR 1007 at line 43: Can't create database 'horde'. Database exists
Dec 13 14:52:05 server mysql.init: Loading 30mysql.create.horde.sql into mysql failed
Dec 13 14:52:06 server 50turba_upgrade_1.1_to_1.2: DBI->connect(horde) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
Dec 13 14:52:06 server mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed
Dec 13 15:07:37 server mysql: ERROR 1007 at line 43: Can't create database 'horde'. Database exists
Dec 13 15:07:37 server mysql.init: Loading 30mysql.create.horde.sql into mysql failed
Dec 13 15:07:38 server 50turba_upgrade_1.1_to_1.2: DBI->connect(horde) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
Dec 13 15:07:38 server mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed
[Log]

This problem has also been posted on general forums: http://forums.contribs.org/index.php?topic=9228.msg35068#msg35068

Cheers

Denbert

[%sig%]

[Boris]

see
http://forums.contribs.org/index.php?topic=9228.msg35073#msg35073

[Michael P. Soulier]

Denbert wrote:

> Hi there,
>
> After an upgrade from 6.0beta3 to final 6.0 the server
> responds with this answer after trying to login on webmail:

This does not happen on a fresh install, so it sounds like an upgrade problem. Try the following:

/sbin/e-smith/config delprop horde DbPassword
/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

Mike

[Boris]

It DID happend for me on the fresh install.
Should horde password be empty by design?

[Randy]

tryed this fix it did not work.

rody

[Greg]

Hi,

Works fine again here. Thank you..

Greg

[Michael P. Soulier]

Boris wrote:

> It DID happend for me on the fresh install.
> Should horde password be empty by design?

I don't know what to tell you. Works for me.

Cheers,
Mike

[Aleck Johnson]

Didn't work for me, either -- but thanks for the suggestion!

[Michael P. Soulier]

Denbert wrote:

> Hi there,
>
> After an upgrade from 6.0beta3 to final 6.0 the server
> responds with this answer after trying to login on webmail:
>
>  “A fatal error has occurred:
>
> DB Error: connect failed
>
> [line 108 of /home/httpd/html/horde/lib/Prefs/sql.php]
>
> Details have been logged for the administrator.”  

Hmm. Try this for me. A modification of my original workaround...

/etc/e-smith/events/actions/conf-horde-startup
/etc/e-smith/events/actions/conf-turba-startup
/etc/init.d/mysql.init
/etc/init.d/mysql restart

If that doesn't work, try adding

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

Mike

[Aleck Johnson]

In attempting these new instructions, I got the following error message when running /etc/initi.d/mysql.init:

50turba_upgrade_1.1_to_1.2 into mysql DBI->connect(horde) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43

After restarting mysql (using /etc/init.d/mysql.init and then /etc/init.d/mysqld restart), still no dice.  Same after rebooting the server.

My install is coming from a completely fresh install, rather than an upgrade.

[Randy]

[root@arcticfury-server root]# /etc/e-smith/events/actions/conf-horde-startup
[root@arcticfury-server root]# /etc/e-smith/events/actions/conf-turba-startup
[root@arcticfury-server root]# /etc/init.d/mysql.init
Loading 20horde.mysql_update_privs.sql into mysql [   OK   ]
Loading 20mysql_migrate_horde.sql into mysql [   OK   ]
Loading 21horde.mysql_set_password.sql into mysql [   OK   ]
Loading 30mysql.create.horde.sql into mysql ERROR 1007 at line 43: Can't create database 'horde'. Database exists
[ FAILED ]
Loading 30mysql_create_tables.sql into mysql [   OK   ]
Loading 50turba_upgrade_1.1_to_1.2 into mysql DBI->connect(horde) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
[ FAILED ]
Loading 60migrate-imp-to-turba into mysql [   OK   ]
[root@arcticfury-server root]# /etc/init.d/mysql restart
bash: /etc/init.d/mysql: No such file or directory


this is what i got after following the above directions.
thanks for trying.
fyi my system is an upgrade from 6.0b3 to 6.0

thanks again
randy

[Lee]

The turba_upgrade_1.1_to_1.2 script tries to use mysql user horde and password horde on localhost.  

You could try going into the mysql client (mysql) and manually reseting the horde password, i.e.:

# mysql mysql
mysql> UPDATE user SET Password=PASSWORD('horde') WHERE User='horde';

Then
/etc/e-smith/events/actions/conf-horde-startup
/etc/e-smith/events/actions/conf-turba-startup
/etc/init.d/mysql.init
/etc/init.d/mysql restart

L.

[%sig%]

[Michael Soulier]

I think I found the problem. I still have some digging to do for a full explanation, but try this.

/sbin/e-smith/config setprop horde DbPassword <password>

Where <password> is something strictly alphabetic, no characters like ^, or [, for example.

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

And try again.

This has worked for me now when I've been able to reproduce it.

Mike

[Aleck Johnson]

This worked for me, too -- thanks a million Mike!

[Denbert]

Hmm,

Doesn’t work here


[root@server init.d]# /sbin/e-smith/config setprop horde DbPassword password
[root@server init.d]# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.56

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> UPDATE horde SET Password=password

[root@server init.d]# /etc/e-smith/events/actions/conf-horde-startup
[root@server init.d]# /etc/e-smith/events/actions/conf-turba-startup
[root@server init.d]# /etc/init.d/mysql.init
Loading 20horde.mysql_update_privs.sql into mysql          [   OK   ]
Loading 20mysql_migrate_horde.sql into mysql               [   OK   ]
Loading 21horde.mysql_set_password.sql into mysql          [   OK   ]
Loading 30mysql.create.horde.sql into mysql ERROR 1007 at line 43: Can't create database 'horde'. Database exists
                                                           [ FAILED ]
Loading 30mysql_create_tables.sql into mysql               [   OK   ]
Loading 50turba_upgrade_1.1_to_1.2 into mysql DBI->connect(horde) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
                                                           [ FAILED ]
Loading 60migrate-imp-to-turba into mysql                  [   OK   ]
[root@server init.d]#

What am I doing wrong?

/ Denbert