Can't login after update to 3.0.4

[dbvadmin]

Hi there.

Started an update in the hosting control panel with Do ISPConfig-Update...
After that the WebInterface was no longer reachable.

Searched around a little bit and found that the update created an empty config.inc.php.

copied back the config.inc.php from backup and run the ispconfig_update.sh from commandline.

After all steps run successfully no login is possible. Logging in to mysql with root is ok, logging in with ispconfig withe the password from config.inc.php returns: ERROR 1045 (28000): Access denied for user 'ispconfig'@'localhost' (using password: YES)

Logging in tho other services like IMAP or ftp is no longer working.

Defined WebSites are running, other Databases are reachable...

Fount nothing really helpful in any logs...

My anyone can give me hints to search the Problem...

Thnx and best regards.

dbvadmin

[falko]

From which version did you update? Which distribution do you use? How exactly did you run the update? From which directory? Did you do this as root?

[dbvadmin]

Hi thx for reply.

Forgot those things....

From which version did you update? Which distribution do you use? How exactly did you run the update? From which directory? Did you do this as root?

Update from 3.0.3 on a debian 6 squeeze logged in as root.

Startet the update from /opt/ispconfgi_install/install using the command php -q update.php

Already tried to reset the admin-pw, but nothing changed.

Think it's somewhere a problem accessing databases... but found nothing in logs. May you give me a hint, where to look after db-access-problems ?

Thx for helping

dbvadmin

[stone1555]

I'm new at this but check this file:

/usr/local/ispconfig/server/lib/mysql_clientdb.conf

and make sure your info is correct there.

[dbvadmin]

Originally Posted by stone1555

I'm new at this but check this file:

/usr/local/ispconfig/server/lib/mysql_clientdb.conf

and make sure your info is correct there.

Thx for your advice, but it's the correct value from the actual mysql-root account.

Is there any chance to set debug values to any config file to get more information about what's going wrong ?

dbvadmin

[dbvadmin]

I've now activated the general.log option in my.cnf to check out what db-connections are wrong.

Will update this thread when I found something.

dbvadmin

[dbvadmin]

partly successful...

FOund wrong db-password in interface/config.inc.php

Now I can log in to the Interface, but at the Moment no ftp or Mail-Login possible...

Where are the passwords for those services stored ?

dbvadmin

[stone1555]

Try starting the services manually and see what you get. When you try to ftp or connect to webmail, whats the error your getting? All the ftp and mail passords / logins should be stored in mysql table. you may also want to login to phpmyadmin as root and double check your data exists.

[dbvadmin]

Originally Posted by stone1555

Try starting the services manually and see what you get. When you try to ftp or connect to webmail, whats the error your getting? All the ftp and mail passords / logins should be stored in mysql table. you may also want to login to phpmyadmin as root and double check your data exists.

GEtting further and further....

It seems the configs of the services had the wrong passwort. e.g. /etc/courier/authmysqlrc

Set the correct pw and restarted courier-authdaemon and can access squirrel.

Will check all other services, but will give a summary at the end

Best regards.

dbvadmin

[dbvadmin]

OK, got it all running...

Copied the complete etc-dir to a local drive and searched for the wrong passwort. Replaced it in every file, where it's been found and rebootet the machine.

Now everything is well running again.

Thx for any hint

Best regards,

dbvadmin