新装的LNMP1.3故障,mysql 启动失败求支持
LNMP1.3装了4次,同样的故障。故障环境:ESXI 下配置LINUX虚拟机 4核处理器,4GB内存,20GB空间,selinux关闭,Centos 6.664位新安装的系统,打开数据库就报错,报错如下============================phpMyAdmin install completed=======================
iptables: Saving firewall rules to /etc/sysconfig/iptables:
Add Startup and Starting LNMP...
Add nginx service at system startup...
Starting nginx... nginx: invalid number of arguments in "root" directive in /usr/local/nginx/conf/nginx.conf:66
failed
Add mysql service at system startup...
Starting MySQL. ERROR! The server quit without updating PID file (/bogon.pid).
Add php-fpm service at system startup...
Starting php-fpmdone
============================== Check install ==============================然后,我把 /etc/my.cnf 里面datadir指定了环境,然后service mysql start,依旧报错,# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/bogon.pid).data目录下面bogon.err信息如下:160823 17:00:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
160823 17:00:13 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 18749 ...
160823 17:00:13 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
160823 17:00:13 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160823 17:00:13 syntax error in innodb_log_group_home_dir, or a wrong number of mirrored log groups
160823 17:00:13 Plugin 'InnoDB' init function returned error.
160823 17:00:13 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160823 17:00:13 Unknown/unsupported storage engine: InnoDB
160823 17:00:13 Aborting
160823 17:00:13 /usr/local/mysql/bin/mysqld: Shutdown complete
160823 17:00:13 mysqld_safe mysqld from pid file /usr/local/mysql/data/bogon.pid ended在网上找了很多修改方案,都不行,还有一个问题就是mysqladmin 和mysqldump这两个好像LN的链接都没有做, 安装日志见附件。
[ 本帖最后由 zhuzhu0628 于 2016-8-23 17:27 编辑 ] Print lnmp.conf infomation...
Download Mirror:
Nginx Additional Modules:
PHP Additional Modules:
Database Directory:
Default Website Directory:
lnmp.conf 文件可能被清空或被删除
运行卸载脚本卸载
然后删除目录及包重新下载安装
回复 2# 的帖子
我看了一下,我下载的是完整的包,然后conf文件夹下的lnmp 有这个文件,文件里面也有配置,但是,这个lnmp是无扩展名的,不是lnmp.conf 我这个完整包,是在lnmp.org下载的美国的完整包,LNMP 1.3完整版:http://soft.vpser.net/lnmp/lnmp1.3-full.tar.gz(478MB) 美国
我想,官方能不能检查一下,官方的包里面,是不是这个文件也有问题,因为我昨天在别的群里看别人安装,也同样遇到这样的问题的。 lnmp.conf不在conf目录下和conf同级目录
安装包发布前都是几十个发行版的几十遍的测试和用户的beta测试
回复 4# 的帖子
lnmp.conf内的代码如下,下载下来,没有动过的。Download_Mirror='http://soft.vpser.net'
Nginx_Modules_Options=''
PHP_Modules_Options=''
##MySQL/MariaDB database directory##
MySQL_Data_Dir='/usr/local/mysql/var'
MariaDB_Data_Dir='/usr/local/mariadb/var'
##Default website home directory##
Default_Website_Dir='/home/wwwroot/default'
回复 5# 的帖子
按日志里面没有输出肯定是有问题,按2# 说明重新弄回复 6# 的帖子
重新安装,问题还是一样的,完整安装包,美国,问题还是一样的,纯净的新安装系统,另外一个,下载版安装,问题更多。不知道是什么问题。回复 7# 的帖子
lnmp安装包目录下ls -lh 看一下
回复 8# 的帖子
附件图片,难道是权限 不对的吗?# ls -lh
total 80K
-rwxr-xr-x. 1 root root 3.8K Oct 152015 addons.sh
-rw-r--r--. 1 root root 7.8K May 27 17:41 ChangeLog
drwxr-xr-x. 3 root root 4.0K Sep 142015 conf
drwxr-xr-x. 2 root root 4.0K Jun 13 11:29 include
drwxr-xr-x. 2 root root 4.0K Jul92015 init.d
-rwxr-xr-x. 1 root root 4.8K Mar 17 21:30 install.sh
-rw-r--r--. 1 root root209 Apr7 15:07 License
-rw-r--r--. 1 root root287 Dec 312015 lnmp.conf
-rwxr-xr-x. 1 root root 6.1K Dec42015 php5.2.17.sh
-rwxr-xr-x. 1 root root 3.7K Mar 17 17:18 pureftpd.sh
-rw-r--r--. 1 root root 5.3K May 27 17:45 readme
drwxr-xr-x. 4 root root 4.0K Aug 25 12:21 src
drwxr-xr-x. 2 root root 4.0K Jul92015 tools
-rwxr-xr-x. 1 root root 4.5K Feb 162016 uninstall.sh
-rwxr-xr-x. 1 root root 2.8K Mar 10 15:45 upgrade.sh
#
回复 9# 的帖子
就现有信息看没法说 出现 syntax error in innodb_log_group_home_dir, or a wrong number of mirrored log groups 之后修改my.cnf 关于 Innodb 两个路径选项如下:
port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql/var
......
default_storage_engine = InnoDB
innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data
然后记得修改 /usr/local/mysql/data 的权限:
chown -R mysql:mysql /usr/local/mysql/data
chmod -R 755 /usr/local/mysql/data
否则出现:
1612160:06:43InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /usr/local/mysql/data/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
# ll
total 224
drwxr-xr-x2 rootmysql 4096 Dec 15 21:16 bin
-rw-r--r--1 rootmysql17987 Jan 152016 COPYING
drwxr-xr-x3 mysql mysql 4096 Dec 15 21:16 data
drwxr-xr-x2 rootmysql 4096 Dec 15 21:16 docs
drwxr-xr-x3 rootmysql 4096 Dec 15 21:16 include
-rw-r--r--1 rootmysql 151708 Jan 152016 INSTALL-BINARY
drwxr-xr-x3 rootmysql 4096 Dec 15 21:16 lib
drwxr-xr-x4 rootmysql 4096 Dec 15 21:16 man
drwxr-xr-x 10 rootmysql 4096 Dec 15 21:16 mysql-test
-rw-r--r--1 rootmysql 2496 Jan 152016 README
drwxr-xr-x2 rootmysql 4096 Dec 15 21:16 scripts
drwxr-xr-x 27 rootmysql 4096 Dec 15 21:16 share
drwxr-xr-x4 rootmysql 4096 Dec 15 21:16 sql-bench
drwxr-xr-x2 rootmysql 4096 Dec 15 21:16 support-files
drwxr-xr-x5 mysql mysql 4096 Dec 16 00:06 var
# service mysql start
Starting MySQL.......
回复 11# 的帖子
没事瞎改目录,默认是var 目录哪来的data目录有问题发帖,别挖坟,你这又不是同一个问题
回复 12# 的帖子
“LNMP1.3装了4次,同样的故障。”没见楼主说吗,同样的问题在 Amazon EC2上出现,安装了两次,也是mysql 起不来。网上找资料找不到,你给的最后答案就是“就现有信息看没法说”?自己摸索着解决了还不能在这里发表下见解?隔了四个月就是挖坟?我就不能在这里说了然后让别人看见了能自己解决下?你说没有data 目录你们就不能自己确认下?你说设置了默认目录,我就不能改改?我就设置了data 目录,最后还成功启动了怎么说?你们的lnmp.conf:
Download_Mirror='http://soft.vpser.net'
Nginx_Modules_Options=''
PHP_Modules_Options=''
##MySQL/MariaDB database directory##
MySQL_Data_Dir='/usr/local/mysql/var'
MariaDB_Data_Dir='/usr/local/mariadb/var'
##Default website home directory##
Default_Website_Dir='/home/wwwroot/default'
里面有Innodb 的默认路径吗?
nginx.conf的root 为什么没有设置成 /home/wwwroot/default 而是空的?
问题出现了可能跟具体环境有关,但既然在不同环境下出现了,也不能全是用户的问题吧?就不能好好给点建议?反倒是我来发表意见的被你怼了一顿 回复收藏
页:
[1]