web: lamp - ubuntu2310

一、基础说明

　　1、lamp说明: L = linux, A = apache2, M = mariadb(mysql), P = php

二、安装包安装

　　1、安装命令： [wit@ubuntu:null]$ sudo apt install mariadb-server apache2 php php-fpm php-mysqlnd

三、apache2 配置：

　　1、查看状态： [wit@ubuntu:null]$ sudo systemctl status apache2.service

　　2、开启服务： [wit@ubuntu:null]$ sudo systemctl start apache2.service

　　3、【apache2.service】开机自启动设置： [wit@ubuntu:null]$ sudo systemctl enable apache2.service

四、mariadb 配置：

　　1、查看状态： [wit@ubuntu:null]$ sudo systemctl status mariadb.service

　　2、开启服务： [wit@ubuntu:null]$ sudo systemctl start mariadb.service

　　3、【mariadb.service】开机自启动设置： [wit@ubuntu:null]$ sudo systemctl enable mariadb.service

　　4、登录mariadb： [wit@ubuntu:null]$ sudo mysql -uroot -p

　　5、创建账户： MariaDB [(none)]> create user 'YOUR_NAME'@'%' identified by 'YOUR_PASSWD';

　　6、账户授权： MariaDB [(none)]> grant all privileges on *.* to 'YOUR_NAME'@'%';

　　7、mariadb配置（重启服务修改配置生效： sudo systemctl restart mariadb.service ）：　　

　　　　7.1 文件位置： /etc/mysql/mariadb.conf.d/50-server.cnf (bind-address = 127.0.0.1 => bind-address = 0.0.0.0)

　　　　7.2、修改内容： 50-server.cnf 25~30行： “bind-address = 127.0.0.1” 改为 “bind-address = 0.0.0.0”

　　　　7.4、重启服务，更改配置生效： [wit@ubuntu:null]$ sudo systemctl restart mariadb.service

　　　　7.3、实际操作：

  1 [wit@ubuntu:mariadb.conf.d]$ pwd
  2 /etc/mysql/mariadb.conf.d
  3 [wit@ubuntu:mariadb.conf.d]$ 
  4 [wit@ubuntu:mariadb.conf.d]$ ls
  5 50-client.cnf         50-mysqld_safe.cnf  60-galera.cnf       provider_lz4.cnf   provider_lzo.cnf
  6 50-mysql-clients.cnf  50-server.cnf       provider_bzip2.cnf  provider_lzma.cnf  provider_snappy.cnf
  7 [wit@ubuntu:mariadb.conf.d]$ 
  8 [wit@ubuntu:mariadb.conf.d]$ sodu vim  50-server.cnf 
  9 50-server.cnf  25~30行：  “bind-address  = 127.0.0.1”  改为  “bind-address = 0.0.0.0”
 10 [wit@ubuntu:mariadb.conf.d]$ cat  50-server.cnf 
 11 #
 12 # These groups are read by MariaDB server.
 13 # Use it for options that only the server (but not clients) should see
 14 
 15 # this is read by the standalone daemon and embedded servers
 16 [server]
 17 
 18 # this is only for the mysqld standalone daemon
 19 [mysqld]
 20 
 21 #
 22 # * Basic Settings
 23 #
 24 
 25 #user                    = mysql
 26 pid-file                = /run/mysqld/mysqld.pid
 27 basedir                 = /usr
 28 #datadir                 = /var/lib/mysql
 29 #tmpdir                  = /tmp
 30 
 31 # Broken reverse DNS slows down connections considerably and name resolve is
 32 # safe to skip if there are no "host by domain name" access grants
 33 #skip-name-resolve
 34 
 35 # Instead of skip-networking the default is now to listen only on
 36 # localhost which is more compatible and is not less secure.
 37 
 38 #bind-address            = 127.0.0.1
 39 bind-address            = 0.0.0.0
 40 
 41 
 42 
 43 
 44 #
 45 # * Fine Tuning
 46 #
 47 
 48 #key_buffer_size        = 128M
 49 #max_allowed_packet     = 1G
 50 #thread_stack           = 192K
 51 #thread_cache_size      = 8
 52 # This replaces the startup script and checks MyISAM tables if needed
 53 # the first time they are touched
 54 #myisam_recover_options = BACKUP
 55 #max_connections        = 100
 56 #table_cache            = 64
 57 
 58 #
 59 # * Logging and Replication
 60 #
 61 
 62 # Note: The configured log file or its directory need to be created
 63 # and be writable by the mysql user, e.g.:
 64 # $ sudo mkdir -m 2750 /var/log/mysql
 65 # $ sudo chown mysql /var/log/mysql
 66 
 67 # Both location gets rotated by the cronjob.
 68 # Be aware that this log type is a performance killer.
 69 # Recommend only changing this at runtime for short testing periods if needed!
 70 #general_log_file       = /var/log/mysql/mysql.log
 71 #general_log            = 1
 72 
 73 # When running under systemd, error logging goes via stdout/stderr to journald
 74 # and when running legacy init error logging goes to syslog due to
 75 # /etc/mysql/conf.d/mariadb.conf.d/50-mysqld_safe.cnf
 76 # Enable this if you want to have error logging into a separate file
 77 #log_error = /var/log/mysql/error.log
 78 # Enable the slow query log to see queries with especially long duration
 79 #log_slow_query_file    = /var/log/mysql/mariadb-slow.log
 80 #log_slow_query_time    = 10
 81 #log_slow_verbosity     = query_plan,explain
 82 #log-queries-not-using-indexes
 83 #log_slow_min_examined_row_limit = 1000
 84 
 85 # The following can be used as easy to replay backup logs or for replication.
 86 # note: if you are setting up a replication slave, see README.Debian about
 87 #       other settings you may need to change.
 88 #server-id              = 1
 89 #log_bin                = /var/log/mysql/mysql-bin.log
 90 expire_logs_days        = 10
 91 #max_binlog_size        = 100M
 92 
 93 #
 94 # * SSL/TLS
 95 #
 96 
 97 # For documentation, please read
 98 # https://mariadb.com/kb/en/securing-connections-for-client-and-server/
 99 #ssl-ca = /etc/mysql/cacert.pem
100 #ssl-cert = /etc/mysql/server-cert.pem
101 #ssl-key = /etc/mysql/server-key.pem
102 #require-secure-transport = on
103 
104 #
105 # * Character sets
106 #
107 
108 # MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
109 # utf8 4-byte character set. See also client.cnf
110 character-set-server  = utf8mb4
111 collation-server      = utf8mb4_general_ci
112 
113 #
114 # * InnoDB
115 #
116 
117 # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
118 # Read the manual for more InnoDB related options. There are many!
119 # Most important is to give InnoDB 80 % of the system RAM for buffer use:
120 # https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_size
121 #innodb_buffer_pool_size = 8G
122 
123 # this is only for embedded server
124 [embedded]
125 
126 # This group is only read by MariaDB servers, not by MySQL.
127 # If you use the same .cnf file for MySQL and MariaDB,
128 # you can put MariaDB-only options here
129 [mariadb]
130 
131 # This group is only read by MariaDB-10.11 servers.
132 # If you use the same .cnf file for MariaDB of different versions,
133 # use this group for options that older servers don't understand
134 [mariadb-10.11]
135 [wit@ubuntu:mariadb.conf.d]$ 
136 [wit@ubuntu:mariadb.conf.d]$

五、php-fpm 配置（此处有问题）：

　　1、说明：在软件环境（ubuntu2310 + php8.2）中，命令【sudo systemctl status php-fpm.service】提示找不到“php-fpm.service”。

　　2、重启操作系统以后，进行查看的结果如下：

 1 [wit@ubuntu:null]$ php -v
 2 PHP 8.2.10-2ubuntu1 (cli) (built: Sep 5 2023 14:37:47) (NTS)
 3 Copyright (c) The PHP Group
 4 Zend Engine v4.2.10, Copyright (c) Zend Technologies
 5 with Zend OPcache v8.2.10-2ubuntu1, Copyright (c), by Zend Technologies
 6 [wit@ubuntu:null]$
 7 [wit@ubuntu:null]$ ps -ef | grep php-fpm
 8 root 957 1 0 00:21 ? 00:00:00 php-fpm: master process (/etc/php/8.2/fpm/php-fpm.conf)
 9 www-data 1055 957 0 00:21 ? 00:00:00 php-fpm: pool www
10 www-data 1056 957 0 00:21 ? 00:00:00 php-fpm: pool www
11 wit 2077 1839 0 00:37 pts/0 00:00:00 grep --color=auto php-fpm
12 [wit@ubuntu:null]$

六、selinux 配置：

　　1、selinux 配置位置： ubuntu23.10.01 没有【selinux】机制。

七、firewalld 配置（ubuntu2310 默认没有安装firewalld）：

　　1、【firewalld】安装： [wit@ubuntu:null]$ sudo apt install firewalld

　　2、【firewalld】开启服务： [wit@ubuntu:null]$ sudo systemctl start firewalld.service

　　3、【firewalld】开机自启动设置： [wit@ubuntu:null]$ sudo systemctl enable firewalld.service

　　4、查看firewall默认的【 zone 】： public

1 [wit@ubuntu:null]$ sudo firewall-cmd --get-default-zone
2 public

　　5、apache2 开放端口【80/433】： [wit@ubuntu:null]$ sudo firewall-cmd --add-port=80/tcp --permanent

　　6、mariadb 开放端口【3306】： [wit@ubuntu:null]$ sudo firewall-cmd --add-port=3306/tcp --permanent

　　7、重启服务，更改配置生效： [wit@ubuntu:null]$ sudo firewall-cmd --reload

　　8、查看已经开放的端口： [wit@ubuntu:null]$ sudo firewall-cmd --list-ports

1 [wit@ubuntu:null]$ sudo firewall-cmd --list-ports
2 80/tcp 3306/tcp
3 [wit@ubuntu:null]$

八、参考资料

　　1、部署LAMP环境（Ubuntu） https://help.aliyun.com/zh/ecs/use-cases/build-a-lamp-stack-on-ubuntu-instances?spm=a2c4g.11186623.0.i2

posted on 2023-11-29 01:08 lnlidawei 阅读(10) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

lnlidawei

公告