ldlbf 发表于 2015-6-1 16:24:15

mariadb升级有个问题。

安装的 php5.6.9 和 mariadb10.0.17 安装完了之后,是完全正常的。在此之前安装的php5.5.25和mariadb5.5.42也是可以正常使用,后来因为 mariadb5.5.42升级43升不了,就换了5.6.9和10.0.17,现在升级 mariadb 10.0.17 到 10.0.19 最后出错。


升级日志我暂时还无法上传上来,我截的最后报错的最后一部分,安装前面全部都是正常的。安装完成了 mysql启动提示要新设置密码,可是在升级之前就已经设置过一次密码了呀。这里还是按照原来的密码再输入一次,然后就提示找不到mariadb目录,进到 /usr/local/ 目录下面发现两个mariadb的目录:一个 oldmariadb20150601152638 和一个 mariadb20150601 这两个目录.

刚刚查了 upgrade_mariadb.sh 的161行,mv /usr/local/mariadb /usr/local/mariadb$(date +"%Y%m%d")这一行将mariadb改了名字,下面的164行语句执行当然找不到 mariadb的目录啦,麻烦军哥改改。

groupadd: group 'mariadb' already exists
useradd: user 'mariadb' already exists
Installing MariaDB/MySQL system tables in '/usr/local/mariadb/var' ...
150601 15:59:52 /usr/local/mariadb/bin/mysqld (mysqld 10.0.19-MariaDB-log) starting as process 14206 ...
OK
Filling help tables...
150601 15:59:55 /usr/local/mariadb/bin/mysqld (mysqld 10.0.19-MariaDB-log) starting as process 14235 ...
OK


To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system


PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:


'/usr/local/mariadb/bin/mysqladmin' -u root password 'new-password'
'/usr/local/mariadb/bin/mysqladmin' -u root -h host password 'new-password'


Alternatively you can run:
'/usr/local/mariadb/bin/mysql_secure_installation'


which will also give you the option of removing the test
databases and anonymous user created by default.This is
strongly recommended for production servers.


See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.


You can start the MariaDB daemon with:
cd '/usr/local/mariadb' ; /usr/local/mariadb/bin/mysqld_safe --datadir='/usr/local/mariadb/var'


You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/local/mariadb/mysql-test' ; perl mysql-test-run.pl


Please report any problems at http://mariadb.org/jira


The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/


Starting MySQL.                                          [确定]
New password:
Confirm new password:
Enter password:
import backup databases...
include/upgrade_mariadb.sh: line 164: /usr/local/mariadb/bin/mysql: 没有那个文件或目录
MariaDB databases import failed,Please import databases manually!
Repair databases...
include/upgrade_mariadb.sh: line 168: /usr/local/mariadb/bin/mysql_upgrade: 没有那个文件或目录
Stopping MariaDB...
/etc/init.d/mariadb: line 213: my_print_defaults: command not found
MySQL server PID file could not be found!                  [失败]
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|            http://lnmp.org            |
+-------------------------------------------+
Starting LNMP...
Starting nginx...done
/etc/init.d/mariadb: line 213: my_print_defaults: command not found
/etc/init.d/mariadb: line 304: cd: /usr/local/mariadb: 没有那个文件或目录
Starting MySQLCouldn't find MySQL server (/usr/local/mariad[失败]mysqld_safe)
Starting php-fpmdone
======== upgrade MariaDB failed ======
upgrade MariaDB log: /root/upgrade_mariadb.log
You upload upgrade_mariadb.log to LNMP Forum for help.
+Done                  mysqld_safe --user=mysql --skip-grant-tables --skip-networking(wd: /etc)
(wd now: ~/lnmp1.2-full)

[ 本帖最后由 ldlbf 于 2015-6-1 17:22 编辑 ]

ldlbf 发表于 2015-6-2 07:53:52

军哥,日志传上来了。昨天晚上又测试了一下,直接安装php 5.6.9 + mariadb 10.0.19 的这个组合完全没问题,可以运行,跑起来也正常。现在把昨天下午升级 mariadb10.0.17 升 10.0.19 的日志上传上来了。系统是 centos 6.5 64位的。日志最下面好像没有体现出要输2次新密码的地方,但实际操作的时候有这个。



licess 发表于 2015-6-2 09:43:41

昨天晚上已经修复了
页: [1]
查看完整版本: mariadb升级有个问题。