Hi, 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 Code: ERROR: Unable to grant databse permissions to user: ispconfig Error: ispconfig_install.log tells me this Code: 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 ?
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?
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
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.
You can use a separate host but in 99% of the use cases this is not a good idea, as discussed recently here: https://www.howtoforge.com/community/threads/apache-default-page-on-installation.86880/#post-421940