- Summary
- Files
- Reviews
- Support
- Wiki
- Mailing Lists
- News
Menu ▾ ▴
From: <ln...@qq...> - 2017-07-28 01:07:42 |
| Hello Louis, I have restored /var/lib/mysql folder and executive command,errors show as below: [root@localhost conf]# systemctl status packetfence-mariadb ● packetfence-mariadb.service - PacketFence MariaDB instance Loaded: loaded (/usr/lib/systemd/system/packetfence-mariadb.service; enabled; vendor preset: disabled) Active: active (running) since Thu 2017-07-27 10:23:13 CST; 22h ago Process: 1145 ExecStartPre=/usr/local/pf/bin/pfcmd generatemariadbconfig (code=exited, status=0/SUCCESS) Main PID: 2352 (pf-mariadb) CGroup: /packetfence.slice/packetfence-base.slice/packetfence-mariadb.service ├─2352 pf-mariadb ├─2384 /bin/sh /usr/bin/mysqld_safe --defaults-file=/usr/local/pf/var/conf/mariadb.conf └─2534 /usr/sbin/mysqld --defaults-file=/usr/local/pf/var/conf/mariadb.conf --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/... Jul 27 10:23:09 localhost.localdomain pfcmd[1145]: [1501122189.56294] Failed to connect to config service for namespace config::Pf, retrying Jul 27 10:23:09 localhost.localdomain pfcmd[1145]: [1501122189.6636] Failed to connect to config service for namespace config::Pf, retrying Jul 27 10:23:09 localhost.localdomain packetfence[1145]: ERROR pfcmd.pl(1145): [1501122189.6636] Failed to connect to config service for namespace config::Pf, retrying (pfcon...rom_socket) Jul 27 10:23:09 localhost.localdomain packetfence[1145]: ERROR pfcmd.pl(1145): [1501122189.7642] Failed to connect to config service for namespace config::Pf, retrying (pfcon...rom_socket) Jul 27 10:23:09 localhost.localdomain pfcmd[1145]: [1501122189.7642] Failed to connect to config service for namespace config::Pf, retrying Jul 27 10:23:13 localhost.localdomain pfcmd[1145]: Connected to config service successfully for namespace config::Pf Jul 27 10:23:13 localhost.localdomain systemd[1]: Started PacketFence MariaDB instance. Jul 27 10:23:13 localhost.localdomain pf-mariadb[2352]: Starting MySQL with command: mysqld_safe --defaults-file=/usr/local/pf/var/conf/mariadb.conf Jul 27 10:23:14 localhost.localdomain pf-mariadb[2352]: 170727 10:23:14 mysqld_safe Logging to '/var/lib/mysql/localhost.localdomain.err'. Jul 27 10:23:14 localhost.localdomain pf-mariadb[2352]: 170727 10:23:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Hint: Some lines were ellipsized, use -l to show in full. [root@localhost conf]# journalctl -xe Jul 28 08:58:17 localhost.localdomain packetfence[656]: FATAL -e(656): unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "C (pf::db::db_connect) Jul 28 08:58:18 localhost.localdomain packetfence[656]: FATAL -e(656): unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "C (pf::db::db_connect) Jul 28 08:58:19 localhost.localdomain packetfence[656]: FATAL -e(656): unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "C (pf::db::db_connect) ------------------ 原始邮件 ------------------ 发件人: "packetfence-users";<packe...@li...>; 发送时间: 2017年7月27日(星期四) 晚上9:10 收件人: "packetfence-users"<packe...@li...>; 抄送: "Louis Munro"<lm...@in...>; 主题: Re: [PacketFence-users] How to config database address On Jul 26, 2017, at 20:51, 沧海云帆 <ln...@qq...> wrote: Hello Louis, I have change /var/lib/mysql to /var/lib/mysql-bak,when I run systemctl status mariadb and journalctl -xe, it show as below: [root@localhost pf]# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [root@localhost pf]# systemctl status mariadb ● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2017-07-27 08:52:58 CST; 3s ago Process: 20457 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 20445 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 20443 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 20457 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" That's because the actual service is "packetfence-mariadb". Try #systemctl status packetfence-mariadb and then perhaps # systemctl start packetfence-mariadb -- Louis Munro lm...@in... :: www.inverse.ca +1.514.447.4918 x125 :: +1 (866) 353-6153 x125 Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) |
View entire thread