Automated ISPConfig Installation with older MariaDB and without Antivirus and Spamfilter

Discussion in 'Installation/Configuration' started by Rex, Apr 7, 2022.

  1. Rex

    Rex Member

    Dear all
    How can I install ISPConfig with MariaDB 10.5.15 and without Antivirus and Spamfilter. I want to use this method because I will install ISPConfig on low RAM server and one of my web app have problem with stable version of mariadb 10.6.7. It freezes when query some tables and use 100% CPU on mariadb process. It works well with MariaDB one version below (10.5.15).

    I prefer automate installation on following link: https://www.howtoforge.com/ispconfig-autoinstall-debian-ubuntu/
     
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    1. How low is your ram that installing and running Antivirus and Spamfilter will cause you problems? ISPConfig server normally can work fine with 2GB ram.
    2. Why is that web app of yours requires lower version of mariadb? It doesn't make sense to me but I think you may try mysql instead of mariadb but I am not so sure whether the web app of yours will work with it though. Or separate that web app to another server.

    Anyway, for your request, I guess you can simply run the ISPConfig Auto Installer, uninstall the software that you do not want, install software that you want, then run ISPConfig force update, BUT I am not sure ISPConfig will work if no AV is installed.
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    On low RAM system, make a big swap, so database does get to out-of-memory situation. Maybe your web app would work even with newer mariadb with enough memory space?
    If I were you, rather that downgrading mariadb I would find out why the web app fails and fix the problem.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    No antivirus and no Spamfilter means also no mail system, so you will get a system that can not be used as a mail server. The option to install it using the auto installer is to add the --no-mail option. But as others mentioned, you should better find out what the issue is by checking MariaDB logs and MariaDB limits and solving the issue. Especially as MariaDB offers various options to configure newer versions in a way that they behave like older versions to stay compatible.
     
  5. Rex

    Rex Member

    really not possible to run mail server without spamfilter? Can I at least exclude ClamAV (--no-clamav)?
    For MariaDB problem, I will start a new discussion specifically on the problem after I find out how to exclude AntiVirus from the ISPConfig auto installation. It simply use 100% CPU on mariadb process when the App retrive data from some tables so I have to kill the process each time it happen. Normally, it should take only 1 second to complete (MariaDB 10.5.15 or lower)
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You have not said how much RAM and swap that host has.
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    The spam filter is an integral part of the system and is also required for dkim signing. So running a mail system without it makes not much sense. Regarding ClamAV, you might be able to remove it after the installation.
     
  8. Rex

    Rex Member

    So I have to use auto install script then remove ClamAV afterwards because there is no option to exclude ClamAV in the first place and spam filter is required for mail to work, right? ClamAV is memory hungry process. Without it, all others process should use around 400MB. They should run well on 1GB RAM. Is there any proper ClamAV removal procedure after ISPConfig auto installation?
     
  9. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Yes, and of course test it (I haven't tried setting up a mail system without clamav, you might well need to configure amavis/rspamd to not use it as well).
    Out of the box, yes; you could of course further customize your setup to not use it either, and as @till mentioned that will result in no dkim signing of your email, so much poorer delivery rates.
    Good luck. :) It might be possible, I've not tried tuning a system for that little resources (mysql speed is largely correlated to memory use, but maybe your websites don't require mysql).
    I don't know of anything offhand, so either search the forums and web for ideas or what I would probably do is just remove the package, see what breaks, and fix the config to work again (and document your changes, which you will likely also need to put in conf-custom templates so they survive future ispconfig updates).
     
  10. Rex

    Rex Member

    I used auto install script to install ISPConfig then run "apt autoremove clamav-freshclam" and free up a lot of memory. I have everything installed except ClamAV and RAM usage is only around 500MB. I will test further to see if something break. I noticed that MariaDB version is 10.3.34. Why does auto install script pull such an old version? Why not v10.5.15 or v10.6.7?
     
  11. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    It is probably the default version supplied by your OS.
     
  12. Rex

    Rex Member

    No, default MariaDB version for Ubuntu 20.04 is 10.6.7
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    The auto-installer installs the default version of MariaDB like @Jesse Norell mentioned, the installed packages are 'mariadb-client' and 'mariadb-server'.
     
  14. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Perhaps your package sources are incorrect or outdated, resulting in an older version.
     
  15. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    How do you know that? Are you referring to mariadb site or Ubuntu 20.04 package?
     
  16. Rex

    Rex Member

    I want to use Mariadb 10.5.15 so I added repository of this version to apt source and started ISPConfig auto install script and I got error message "UPDATE mysql.user SET Password=PASSWORD('diejdJidfjudkfdjkfkKhjdkjfkd') WHERE User='root'; failed". I think in version 10.5. There is no mysql.user anymore. Instead, it's replaced with mysql.global_priv. Can I get around this error?
     

Share This Page