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

[Michael P. Soulier]

Denbert wrote:

> Hmm,
>
> Doesn’t work here

You didn't follow my instructions. Do this _exactly_.

/sbin/e-smith/config setprop horde DbPassword

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

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

Mike

[Denbert]

Michael P. Soulier wrote:

> Denbert wrote:
>
> > Hmm,
> >
> > Doesn’t work here
>
> You didn't follow my instructions. Do this _exactly_.
>
>
Hi Michael,

Yes I did it exactly that way, as I made a copy and paste.

Off course with my own password:

/sbin/e-smith/config setprop horde DbPassword mypass

Anyway, I solved it another “harder” way

I deleted the horde database with phpmyadmin and then made a reboot with the SME 6.0 final CD in my CD-ROM drive, and made a upgrade, witch was VERY fast

Then a new reboot and all the errors disappeared.

Everything runs great again.

Kisses and hugs from a happy boy

/ Denbert

[Joe]

I followed Denbert's suggestion and deleted the database horde and re-upgrade now i'm getting this error...

[root@ps2 imp321]# /etc/init.d/mysql.init
Loading 40mysql_create_indexes.sql into mysql ERROR 1061 at line 3: Duplicate key name 'category_category_name_idx'
                                                           [ FAILED ]
Loading 50turba_upgrade_1.1_to_1.2 into mysql turba db must exist at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 29.
                                                           [ FAILED ]


HELP!!!

[Denbert]

>I followed Denbert's suggestion and deleted the database horde and
>re-upgrade now i'm getting this error...

Hi Joe,

Phew, looks bad.

As I’m not skilled enough to help you, I will describe why I did as I did.

I’d tried all the solutions in this thread, and in
http://forums.contribs.org/index.php?topic=9228.msg35072#msg35072

So I decided to make use of my backup and roll back to my 5.6u6 – But as a last desperate try, I’d deleted the horde database in mysql and after words, the upgrade with the lucky outcome.

I don’t know if it has anything to do wit the commands that I did BEFORE the last desperate delete of the horde database. Maybe you should try all the suggested commands and then delete of horde database and upgrade.

Cheers

/ Denbert

[Argenlos]

Thank for the solution!


Merci beauçoup!

Argenlos - France

[Morten Kjaergaard]

I had 2 or 3 red marks when booting the server after the opgrade like the log in the first mail in this topic.
After studying all the mails here I deleted the horde db with MC and run the upgrade from cd again.
Then there were no red marks when booting and the webmail worked.
But it seemes to be problems with my VPN-access, something with the authenticate of the remote system.
I will look in to that now
any suggetions?

happy x-mas from Denmark
morten

[Michael Soulier]

For anyone still experiencing this problem, please show me the contents of the /etc/e-smith/sql/init directory.

Also, the following...

/sbin/e-smith/config show horde

mysql horde -u horde -phorde

Thanks,
Mike

[Steven Curren]

I still have the problem, haven't tried any fixes yet. Following obtained logged in as root on SME6.0 (fresh installation, not upgrade).

>For anyone still experiencing this problem, please show me the contents of the /etc/e->smith/sql/init directory

lrwxrwxrwx    1 root     root           52 Dec 29 16:55 50turba_upgrade_1.1_to_1.2 -> /etc/e-smith/events/actions/turba_upgrade_1.1_to_1.2

>/sbin/e-smith/config show horde
    horde=service
    DbPassword=kO\Q[HMjE
    access=SSL
    imp=installed
    status=enabled

>mysql horde -u horde -phorde
ERROR 1045: Access denied for user: 'horde@localhost' (Using password: YES)

Would like to know how to fix this problem. I remember a thread a while ago warning against changing db password. Is it ok to do this in this case?

Regards,
Steve C

[David Davis]

Did anyone ever find a soution to this problem.  I have tried the suggestions here and am still getting the error.

[David Davis]

Mike,

Here is the contents of my /etc/e-smith/sql/init directory:

[root@saber1 init]# ./50turba_upgrade_1.1_to_1.2

Here are the results of /sbin/e-smith/config show horde:

[root@saber1 init]# /sbin/e-smith/config show horde
horde=service
    DbPassword=31e43e9079b4ad01
    access=SSL
    imp=installed
    status=enabled

And here are the results of mysql horde -u horde -phorde:

[root@saber1 init]# mysql horde -u horde -phorde
ERROR 1045: Access denied for user: 'horde@localhost' (Using password: YES)

I have tried everything and am really stuck.  If you can help me out, I'd be really grateful!

Best Regards,
David

[David Davis]

Well, now it is working.  I don't know why, but I guess as long as it works, I don't really care.  Thanks again for all the suggestions.  One of them must have worked.

[Michael P. Soulier]

David Davis wrote:

> Here is the contents of my /etc/e-smith/sql/init directory:
>
> [root@saber1 init]# ./50turba_upgrade_1.1_to_1.2
>
> Here are the results of /sbin/e-smith/config show horde:
>
> [root@saber1 init]# /sbin/e-smith/config show horde
> horde=service
>     DbPassword=31e43e9079b4ad01
>     access=SSL
>     imp=installed
>     status=enabled
>
> And here are the results of mysql horde -u horde -phorde:
>
> [root@saber1 init]# mysql horde -u horde -phorde
> ERROR 1045: Access denied for user: 'horde@localhost' (Using
> password: YES)

If the above password has been set properly, you should be able to get to the horde db via the following.

mysql horde -u horde -p31e43e9079b4ad01

If not, use the root account in mysql to change the horde password to the password specified.

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

Remove any symlinks in /etc/e-smith/sql/init, and expand the following templates:

/home/httpd/html/horde/config/horde.php
/home/httpd/html/horde/turba/config/conf.php

If your password has anything but alphanumeric characters in it, replace it in the configuration db, before you do the above.

Simply put, the horde@localhost password must match the configuration db, and then both horde and turba need to know to use it.

Mike

[MickSpice]

I found this tread after an upgrade from 5.6 to 6.0 and I also suffer from the 'No Webmail' problem.

The info that has been asked for before is :-

> Author: Michael Soulier
> Date:   12-23-03 14:22

> For anyone still experiencing this problem, please show me the contents of the /etc/e-smith/sql/init directory.

gallery-dl index.html update2 upgrade.log upgrade.log.syslog

> Also, the following...

> /sbin/e-smith/config show horde

horde=service
   DbPassword=^OhNjPa^Z
   access=SSL
   imp=installed
   status=enabled

> mysql horde -u horde -phorde

Reading table information for completion of table and column names
You can turn off this feature to get quicker startup with -A

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

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

So it appears that the DbPassword contains non alph-numeric characters, BUT the horde user uses 'horde' as password sucessfully.

If I were to change the horde user password would the scripts also need changing ?

How do I fix this little problem...

[%sig%]

[Michael P. Soulier]

MickSpice wrote:

> I found this tread after an upgrade from 5.6 to 6.0 and I
> also suffer from the 'No Webmail' problem.
>
> How do I fix this little problem...

You did not read the entire thread. I posted the solution a while ago, quite late in that thread.

Mike

[synaptic]

Same errors Same log output.
Only commands below were needed to fix problem.

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

Haven't done this one yet. Pobably a good idea. But it works anyway
/sbin/e-smith/signal-event reboot

[raem]

Dear All
Well, I have just done an upgrade from sme v5.6 to sme v6.0 and had the same problem (identical error) as the original poster.
I followed the thread and tried all the suggested fixes without success, until the very last posted sugesstion by "synaptic".
After running the commands
/sbin/e-smith/config setprop horde DbPassword horde
/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

I can now log on to webmail without any problem.

Thanks & Regards
Ray

[wyron]

I made a fresh 6.0 install saturday morning, and restored from tape.
Since then, I've tried everything in the book, including all suggestions in this thread, but to no avail.
Now I'm the only user, who cannot access webmail (or even imap from a Knoppix 3.3) at all, but  the other two accounts  on my server have lost their mailstore, and can only log into an empty account.
What am I not seeing here ???????

Greetings (and thanx for your gallant work)

wyron
(who isn't wyron@ideast.dk just now)

[wyron]

Well, I know better now, thanx to Jesper Swerts-Knudsen (the father of a couple of howto's (sme.swerts-knudsen.dk)).
If you are reading this, you probably didn't get your particular problem solved even after following all hints above.
Well then, read on . . .
My users were climbing the walls (when they weren't busy beating me up), but luckily the solution was simple, once I got the hang of the underlying problem.
Here follows . .
After you have done the setprop thing, you might want to check ownership on the folders and files for each user.
In my case all the existing mailfiles were all right, only the mailfolders had changed ownership and were now belonging to root and admin respectively.
Bumber, right ?
Simply chown the lot, and enjoy your webmail (and perhaps another pint, in the spirit of Linus).

[PC]

Sorry..no go here
db 108 error lives on!

/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

Mike

[PC]

This works great...follow this one...it works!

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

Use it exactly as shown! Cheers

Same errors Same log output.
Only commands below were needed to fix problem.

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

Haven't done this one yet. Pobably a good idea. But it works anyway
/sbin/e-smith/signal-event reboot

[Tony Gallpen]

Thanks Guys
worked a treat for me as well

Clean install of Ver6.0 final Ok
did a reinstall and on second run it failed

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


All fixed
Cheers
Tony

[Anonymous]

Looks like you didn't follow what he said from what I can gather from the output you have listed. I did this:

/sbin/e-smith/config setprop horde DbPassword <password> (without the <  > )

then I did this:

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

Worked perfect! Thanks man!