problems after secondary install (mysql ispconfig user+dbispconfig)

Discussion in 'Installation/Configuration' started by dinsdale, Nov 11, 2010.

  1. dinsdale

    dinsdale New Member

    I reinstalled ispconfig a second time after uninstalling a botched first install by running the uninstall script. I think I used dbispconfig1 as db name in the first install but dbispconfig in the second install. It appears that the uninstall procedure did not delete the previous config files in /etc/postfix as I seem to have all files backed up in the directory /etc/postfix/

    header_checks           nested_header_checks            postfix-files          postfix-script    post-install   sasl               smtpd.cert
    mime_header_checks              smtpd.key
    While I was able to log on to the ispconfig webinterface after the second install I was not able to send email. After checking the credentials in the /etc/postfix/mysql-* files (without the ~) they still pointed to the db dbispconfig1 (from previous install) and a password which didin't work when trying to connect to the mysqldb dbispconfig.

    I then changed the password of the mysql user ispconfig to what was in the .cf files and matched the db name in the .cf files to dbispconfig. I was now able to send email :) - but instead I lost the connection to my ispconfig interface :mad:. I found the db pwd can be changed easily in /usr/local/ispconfig/interface/lib/

    What do you think happened? Is this maybe a bug in the uninstaller or my own fault. I maybe have to add that I have a 3 server setup:
    1 dedicated webserver , 1 dedicated mail server and a backup server which is supposed to mirror the two for redundancy (not implemented yet) but this was all on the webserver.
  2. dinsdale

    dinsdale New Member

    My ftp users did loose access aswell after I changed the password - so I changed the pwd (same as in /etc/postfix/* for pure-ftpd in:

  3. dinsdale

    dinsdale New Member

    I just realized that I am not able anymore to add sites either. I can add them in ispconfig but there are no directories created in /var/www/clients/ or symlinks in /var/www/
    The information inside ispconfig looks correct however the system doesn't seem to have the permissions or can access the system user to create the directories.

    It appears to me my changing of the password had a domino effect on an array of functionalities.

    Can you please help me to finish the list of which files I have to manually adjust after changing the mysql pwd for the ispconfig user:

    change mysql password in:

  4. dinsdale

    dinsdale New Member

    While I haven't resolved my problem after changing the pwd for the ispconfig user in mysql I think at least I can explain what happend.

    1) I installed ispconfig with the mailserver option in a multiserver setup
    2) I uninstalled ispconfig using the uninstall script. This script in fact deletes little more than the database. Most of the system configuration remains on the system.
    3) I reinstalled ispconfig a second time, this time without the mail server option. Since the old postfix configuration still remained my websites were not able to send emails since postfix could not connect to the mysql db.
    4) I now changed the pwd for the ispconfig user in mysql which is a bad idea. This pwd is hardcoded in several places and I still haven't found all of them.

    So the bottom line - be careful when you use the uninstall script. In my case I think a complete reinstall would have been less trouble.

    Maybe it would make sense to also include a message to the uninstall script to also check separately delete manually the mailserver/ftp etc configuration.

    Please do not forget to delete the ispconfig user in the mysql.user table

    Any system configuration by ispconfig apart from the web directories will remain on the server. Please check the following directories manually for configuration files:



    Last edited: Nov 16, 2010

Share This Page