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

[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