lightest free control panel with db & php?

eva2000

HyperFilter_Official said: Oh, didn't knew about this one, thanks for pointing out !

FYI, on CentOS 7 VestaCP the outdated Apache RPM is installed from http://c.vestacp.com/rpms/7/httpd/x86_64/. They are not using CentOS 7 default yum repo provided Apache rpms

yum list installed httpd -q | tr -s ' '
Installed Packages
httpd.x86_64 2.4.6-118.el7.centos @vesta

willie

Maybe you can temporarily launch a bigger hourly-billed server, like a 2GB Scaleway for less than 1 cent an hour. Then put whatever panel you want on it and use it to set up your small servers. Then shut off the big server.

mariafashion

Sorry for this is an old thread, but I can recommend VestaCP. The installer is customisation with options, which you could setup bare essentials only. I recommend NGINX and PHP-FPM only.

For SQL, you should install MariaDB on another VPS and connect to it remotely via your WP.

jvnadr

mariafashion said: Sorry for this is an old thread

This is a new thread.

mariafashion said: but I can recommend VestaCP

if you read a little, you can see OP has already tried it.

mariafashion said: For SQL, you should install MariaDB on another VPS and connect to it remotely via your WP

Why? If he could/wanted to have a second vps for the job, wouldn't he buy a bigger than 256MB vps to do it?

Please, don't spam the forum with useless posts.

fahim5001 said: any other suggestions?

Virtualmin can be run with some tweaks in a 128MB vps, if you chose not to install clamav/spamassassign (although for a full server, 256 should be the minimum for a stable run). In the initial configuration dialog box, it proposes you how to configure mysql according to the available ram, so, automatically configures mysql to run in a minimal state.
This is a tutorial how to gain some resources on a system that is running virtualmin.
https://www.virtualmin.com/documentation/system/low-memory

johnnymatt

@fahim5001 said:
here is a little update!
Tried mostly all the suggestions,

openlitespeed - great for hosting static sites, but after installing db+php on debain 7.3
x86, had around 20mb ram left mostly, and went down to 6mb in some occasions. hard
to find tutorials and config stuff for a beginner like me.

Really ? Did you try to compile ? (i assume not otherwise the ram consumption was very minimal) The golden rule with OpenLitespeed is a minimal install and to add only the devel packages you need before starting to Compile PHP with LSAPI. If you proceeed with this steps correctly (i assume you have kvm, you didnt explain) and you choose only the parameters you need, for example:

--with-mysqli --with-zlib --with-gd --enable-shmop --enable-sockets

you finish this task with a very lightweight system. Ofc you need after that to go inside you panel and to tune "Server Configuration > Tuning", "External App > Environment" (its just the beginning, there are a lot of other steps) but after that you have good chances (if you configure too well MariaDB) to finish with a working minimal LAMP.
A good advice: if you choose OpenLitespeed and you have a low mem vps with a ssd, is to use the module Cache. Its not so impressive to configure as it sound.

mikho

VestaCP.
You can select what to install and it works great.

DNname

+1 VestaCP or you can try Kloxo-MR

fahim5001

@johnnymatt said:

@fahim5001 said:
here is a little update!
Tried mostly all the suggestions,

openlitespeed - great for hosting static sites, but after installing db+php on debain 7.3
x86, had around 20mb ram left mostly, and went down to 6mb in some occasions. hard
to find tutorials and config stuff for a beginner like me.

Really ? Did you try to compile ? (i assume not otherwise the ram consumption was very minimal) The golden rule with OpenLitespeed is a minimal install and to add only the devel packages you need before starting to Compile PHP with LSAPI. If you proceeed with this steps correctly (i assume you have kvm, you didnt explain) and you choose only the parameters you need, for example:

--with-mysqli --with-zlib --with-gd --enable-shmop --enable-sockets

you finish this task with a very lightweight system. Ofc you need after that to go inside you panel and to tune "Server Configuration > Tuning", "External App > Environment" (its just the beginning, there are a lot of other steps) but after that you have good chances (if you configure too well MariaDB) to finish with a working minimal LAMP.
A good advice: if you choose OpenLitespeed and you have a low mem vps with a ssd, is to use the module Cache. Its not so impressive to configure as it sound.

thanks man, can u please point me to some "noob" friendly or "absolute beginner" friendly tutorials for setting up the whole thing? mostly on OLS (open lite speed), i tried youtube and google for tutorials but noting relevant was found by my search

johnnymatt

MySQL
This https://tools.percona.com/wizard was time ago a wizard to generate my.conf (i dont know if is stil valid)
simple guide: MySQL low memory configuration

OpenLitespeed HowTOs

OpenLiteSpeed: How to recompile PHP (LiteSpeed SAPI PHP, Eva2000 )
Open Litespeed: Tuning Server Settings (still valid and well Explained, thanks @eva2000 because its thanks to this that i did first install of OpenLitespeed in 2013 )

OpenLitespeed Cache - Info and Examples
Basic Info about Module Cache
LiteSpeed Web Cache (why Litespeed ? After all OpenLitespeed is the "young brother" of Litespeed )

Honestly i never tried to tune so hard MySQL in VPS with less than 512 MB Ram so i dont know.... For OpenLitespeed, the minimal config i tried was a 512 MB VPS

eva2000

johnnymatt said: OpenLitespeed HowTOs

OpenLiteSpeed: How to recompile PHP (LiteSpeed SAPI PHP, Eva2000 ) Open Litespeed: Tuning Server Settings (still valid and well Explained, thanks @eva2000 because its thanks to this that i did first install of OpenLitespeed in 2013 )

yup still valid tuning tips after 3+ yrs

Razza

eva2000 said: FYI, on CentOS 7 VestaCP the outdated Apache RPM is installed from

You can probably fix that by adding exclude=httpd* mod_ssl to
/etc/yum.repos.d/vesta.repo and doing yum downgrade httpd* mod_ssl not tested it on a live system.

eva2000

@Razza said:

eva2000 said: FYI, on CentOS 7 VestaCP the outdated Apache RPM is installed from

You can probably fix that by adding exclude=httpd* mod_ssl to
/etc/yum.repos.d/vesta.repo and doing yum downgrade httpd* mod_ssl not tested it on a live system.

Indeed you can. Though my point is for alot of noobs they will go with whatever is provided by default. I normally build my own set of apache rpms for latest apache versions https://community.centminmod.com/threads/custom-apache-2-4-rpms-for-centmin-mod-lemp-stack.4471/ and is what I intend to do with centmin mod's apache 2.4 integration in future.

Razza

eva2000 said: Indeed you can. Though my point is for alot of noobs they will go with whatever is provided by default.

That's the major issue with the default install of Vesta on Centos most user are not going to try to fix it or ever know about it, not totally sure why they even need to use a custom rpm for apache.