Installation on raspbian buster fails (database on another host)

Discussion in 'Installation/Configuration' started by Bonzo, May 5, 2021.

  1. Bonzo

    Bonzo New Member

    I have a problem installing ispconfig on a raspberry pi 4. I want to use ispconfig only for quick creation of virtual hosts (dev environment, maybe overkill but I want jump in on ispconfig development too). So i did omit all the stuff I don't need like quota, ftp, firewall, stats, fail2ban, mailman, bind and other stuff I may have forgot to mention now. Only thing I've installed is mysql client, apace with php and pure postfix.
    Other stuff I've configured according to the perfect server for debian how to.
    For performance reason, I've installed the database server on my desktop computer.
    php cli version is 7.4
    After I start the installation I get an error installing the database

    ERROR: Unable to grant databse permissions to user: ispconfig Error:
    ispconfig_install.log tells me this

    Wed 05 May 2021 02:56:18 AM CEST - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 334: read in ispconfig3.sql
    Database import is successful. I checked the database after the error and I've tried manual import.
    Any idea where this error comes from and why? Does the (master)database has to be on the same host ?
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    What kind of virtual host do you mean? Website?
    ISPConfig host always has it's own database, and normally on that same host. You mention master database, is this a multiserver setup or single server?
  3. Bonzo

    Bonzo New Member

    Yes, website virtual host. It's a single server setup and I meant the main database. But even if it was a multiserver setup, I can't complete the first step installing the database, expert or standard, it fails on the database creation task. I know that every instance of ispconfig has it's own database, it seems it has to be on the same host though. For testing purposes I will install a mysql on the same host (raspberry) and come back to this thread. Thanks so far
  4. Bonzo

    Bonzo New Member

    I've installed the mysql server on the same host as ispconfig and it works that way. That's bad for what I was planning to go for but it seems the main(master, default) database for ispconfig has to be on the same host. In that case we could we don't really need asking for the setting for MYSQL Server hostname because it has to be localhost.
  5. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    You can use a separate host but in 99% of the use cases this is not a good idea, as discussed recently here:

Share This Page