Ns8-lamp needs testers

App
, ,
21

yes it is a good question, I think mysql is not configurable by the user, we could think on it

however for your case the default size is 64MB, but it is not mariadb :stuck_out_tongue:

image
image1182×226 29.1 KB

it seems you can set it by the command line until the server restart

runagent -m lamp1 podman exec -ti lamp-app bash
mysql
MariaDB [(none)]> show variables like 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16777216 |
+--------------------+----------+
1 row in set (0.001 sec)
MariaDB [(none)]> SET GLOBAL max_allowed_packet=1073741824;
1 Like
22

the idea could be to make editable these files

root@lamp:/# ls /etc/mysql/conf.d/
mysql.cnf  mysqldump.cnf
root@lamp:/# cat  /etc/mysql/conf.d/mysql.cnf 
[mysql]
root@lamp:/# cat  /etc/mysql/conf.d/mysqldump.cnf 
[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

let me think on it

3 Likes
23 
root@lamp:/# tar
tar: You must specify one of the '-Acdtrux', '--delete' or '--test-label' options
Try 'tar --help' or 'tar --usage' for more information.

tar is included : thoughts ?

24

mysql custom configuration is now possible, please read the readme

3 Likes
25

I believe the mechanism of being able to have customizable and survivable settings outside containers is of huge value! I opt for this to be availabe with all app in a ‘NS way’ that also respects all backup methods!

Not only does it provides customizable setting, it also reduces the need (and risc) to access containers themselves. Gives me a nostalgic feeling re good old on “db configuration set
”

2 Likes
26

Big hugs and kisses to @stephdl

1 Like
27

it exists but in a different way, modify the file /home/module1/.config/state/environment and restart the service

password must be in a different place, probably a password.env

28

Hello Steph, is it possible to build this into the lamp module Vvveb

As a sort of a plugin for getting websites up and runnign very quickly

Vvveb/docker-compose-apache.yaml at master · givanz/Vvveb (github.com)

29

Can this not be installed “on top off” the ns8-LAMP stack?

30

why do you not want to use directly the container instead ?

ns8-lamp can be forked and used to any project that does not have a container or for project started manually years ago.

During the container creation I wget phpmyadmin sources, it could be any of other php project

31

I would love to see such an NS8 app. It may be a nice alternative for the bloated Wordpress app!

1 Like
32

because a single webserver needs to have the ability of hosting more than website, unless i am wrong

33

do not know, it depends of your usage

you are a developer → nethserver-kickstart-mariadb
you are a sysadmin → ns8-lamp

34

How to disable and enable phpmyadmin access pls? After installing and testing an webapp, I would like to disable phpmyadmin access completely, as if it does not exist, 404 error., obviously to tighten security.

And sometimes it needs to be enable to do some work.

Preferably a ‘switch’ like setting/command outside of the container, maybe in settings of the lamp1 instance?

TIA

35

yep I was thinking on it myself, it could be a good improvement

1 Like
36

done in 1.0.5, check the advanced settings, enabled by default

37

Upgraded from 1.0.4 to 1.0.5, but no option in advanced settings. Also, I never touched the mysql password and left it as default Nethesis,1234. Now I can not change that. How can I?

At the same time, would it be an idea to also have an option to enable (disabled by default) phpinfo page by means of a symbolic link on/off? Off by default for security ofcourse.

image
image1312×1276 47.6 KB

This is 1.0.5

EDIT:

Ah, creeating a new instance with 1.0.5 does show the option properly:

image
image1356×1392 62.7 KB

1 Like
38

I cannot reproduce

Capture d’écran du 2024-09-12 21-39-30
Capture d’écran du 2024-09-12 21-39-301282×889 51.7 KB

Capture d’écran du 2024-09-12 21-39-20
Capture d’écran du 2024-09-12 21-39-201282×889 39.9 KB

Capture d’écran du 2024-09-12 21-38-53

39

Maybe we do not bother, for an upgrade from 1.0.4 to 1.0.5 will never happen again. After all, this is all tests.

40

I stated remove it from the App folder, I think it is enough, normally it should not survive because it is an ephemeral website

image
image877×286 7.78 KB

as stated you need to use phpmyadmin to set another password once set, but I did not have written it explicitly.

Maybe I could do an action to mysql to amend the password, but I am not a big fan