Koozali.org: home of the SME Server

Can't access webmail after upgrading...

WEBlance

Can't access webmail after upgrading...
« on: September 25, 2006, 03:27:17 PM »
Iv'e just upgraded to SME 7 from 6.01 and now I can't access the webmail. All I get is this error message:

A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

What can I do to fix this problem?

/Carl

Offline bosco555

  • *****
  • 152
  • +0/-0
Can't access webmail after upgrading...
« Reply #1 on: September 26, 2006, 02:39:40 PM »
Hi there,

sorry, i might be on the wrong track, but, are you trying with https??

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Can't access webmail after upgrading...
« Reply #2 on: September 26, 2006, 02:57:14 PM »
http should redirect to https

Did you have any contribs installed on the SME6 machine ?
Regards,
William

IF I give advise.. It's only if it was me....

Offline bosco555

  • *****
  • 152
  • +0/-0
Can't access webmail after upgrading...
« Reply #3 on: September 26, 2006, 03:00:16 PM »
Hi William,

I have noticed that on some systems it does and on some others is refuses to redirect to https...

best regards

gb

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Can't access webmail after upgrading...
« Reply #4 on: September 26, 2006, 03:07:03 PM »
Quote from: "bosco555"
Hi William,

I have noticed that on some systems it does and on some others is refuses to redirect to https...

best regards

gb


Interesting.

Out of the box I would say SME 7 should redirect.

I just pulled my webmail apart just a little to see how it works..
http://forums.contribs.org/index.php?topic=32920.msg145173#msg145173
only to be told someone else had done it already.  :D  :oops:
Regards,
William

IF I give advise.. It's only if it was me....

WEBlance

Can't access webmail after upgrading...
« Reply #5 on: September 26, 2006, 03:08:14 PM »
Quote from: "william_syd"
http should redirect to https

Did you have any contribs installed on the SME6 machine ?


I have dungog.net's "Chroot FTP users", "FTP management", "EZMLM" that doesn't work anymore after the upgrade and "System Monitor".

The HTTP redirect to HTTPS works fine!

Offline bosco555

  • *****
  • 152
  • +0/-0
Can't access webmail after upgrading...
« Reply #6 on: September 26, 2006, 03:14:30 PM »
Hehe, it's OK.

It is peculiar, the behavior...I have 6/7 SME servers around and only a few behave consistently (in the same manner), an issue I discovered is with whitelisting (globally), some servers will act upon it and don't let in any or hardly any spam, and with others is just like there is no whitelist at all, but this is another story altogether...digressing here...

regards again

Gianni

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Can't access webmail after upgrading...
« Reply #7 on: September 26, 2006, 03:16:53 PM »
Quote from: "WEBlance"
Quote from: "william_syd"
http should redirect to https

Did you have any contribs installed on the SME6 machine ?


I have dungog.net's "Chroot FTP users", "FTP management", "EZMLM" that doesn't work anymore after the upgrade and "System Monitor".

The HTTP redirect to HTTPS works fine!


MySQL may of failed to start.

Type mysql at root login.

What do you get ?
Regards,
William

IF I give advise.. It's only if it was me....

Offline bosco555

  • *****
  • 152
  • +0/-0
Can't access webmail after upgrading...
« Reply #8 on: September 26, 2006, 03:19:39 PM »
William, here it is:

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

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

mysql>

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Can't access webmail after upgrading...
« Reply #9 on: September 26, 2006, 03:22:06 PM »
To whom am I speaking.... lol

I'm sure yours is working bosco555.

I'm not to sure about WEBlance.
Regards,
William

IF I give advise.. It's only if it was me....

Offline bosco555

  • *****
  • 152
  • +0/-0
Can't access webmail after upgrading...
« Reply #10 on: September 26, 2006, 03:24:04 PM »
sorry got confuzzled

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Can't access webmail after upgrading...
« Reply #11 on: September 26, 2006, 03:28:09 PM »
If WEBlance has an error like
Code: [Select]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

he maybe wants to try
Code: [Select]
service mysqld start

I'm off to bed.
Regards,
William

IF I give advise.. It's only if it was me....

WEBlance

Can't access webmail after upgrading...
« Reply #12 on: September 26, 2006, 03:33:24 PM »
I get this error message:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

WEBlance

Can't access webmail after upgrading...
« Reply #13 on: September 26, 2006, 03:35:07 PM »
And when I use

mysql -p

and enter my password - the mysql works fine!

Offline bosco555

  • *****
  • 152
  • +0/-0
Can't access webmail after upgrading...
« Reply #14 on: September 26, 2006, 03:41:36 PM »

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Can't access webmail after upgrading...
« Reply #15 on: September 26, 2006, 03:46:37 PM »
Yes.. your MySQL root user password appears to have been altered.


Typing mysql should work without you entering a password.
Regards,
William

IF I give advise.. It's only if it was me....

cristi3k

Hi
« Reply #16 on: October 13, 2006, 10:54:29 AM »
If U didn`t resolved the problem here is a solutiont that worked for me:

cd /var/lib
chown mysql.root mysql
chmod 755 mysql


Hope this will help.
For more information I am available.

WEBlance

Can't access webmail after upgrading...
« Reply #17 on: October 14, 2006, 09:23:39 AM »
Quote from: "bosco555"
WEBlance,

try this:

http://forums.contribs.org/index.php?topic=33695.0

hope it helps

gb


Tried this - and it fixed the mysql password issue . . . but not the webmail problem :(

WEBlance

Re: Hi
« Reply #18 on: October 14, 2006, 09:24:12 AM »
Quote from: "cristi3k"
If U didn`t resolved the problem here is a solutiont that worked for me:

cd /var/lib
chown mysql.root mysql
chmod 755 mysql


Hope this will help.
For more information I am available.


Sorry - doesn't make any difference...

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Can't access webmail after upgrading...
« Reply #19 on: October 14, 2006, 09:40:00 AM »
Regards,
William

IF I give advise.. It's only if it was me....

WEBlance

Can't access webmail after upgrading...
« Reply #20 on: October 16, 2006, 12:03:58 PM »
Quote from: "william_syd"
http://forums.contribs.org/index.php?topic=33596.msg146262#msg146262

Horde password preoblem maybe ?


Sorry - no password problem...