o serviço mariadb não está iniciando após a inicialização, o CentOS 7

4

Eu defini o serviço para mariadb em: /etc/systemd/system/mariadb.service

[Unit]
Description=start and stop MySQL(MariaDB) Server
After=syslog.target
After=network.target


[Service]
Type=simple
User=Umariadb
Group=Gmariadb
# Restart=always

# PermissionsStartOnly=true
ExecStart=/usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data 
# ExecStop=/usr/bin/vgaoff stop

TimeoutSec=300
PrivateTmp=true


[Install]
WantedBy=multi-user.target

Mais tarde, eu o ativei:

systemctl enable mariadb.service

Agora, após a reinicialização, o serviço não está sendo iniciado .

Depois, preciso desativar o serviço novamente.

Ao tentar executar manualmente novamente, funciona perfeitamente ...

sudo /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data 

O meu script para serviço está bem definido?

Eu gostaria de saber qual é o problema. Como resolver isso?

EDITAR:

$ sudo /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data
[sudo] password for joseluisbz: 
170308 19:54:07 mysqld_safe Logging to '/usr/local/ServerWeb/mariadb/data/server.err'.

Dentro do arquivo

170308 19:54:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/ServerWeb/mariadb/data
2017-03-08 19:54:07 140588539000704 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld (mysqld 10.1.20-MariaDB) starting as process 4411 ...
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Using Linux native AIO
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Using SSE crc32 instructions
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Completed initialization of buffer pool
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Waiting for purge to start
2017-03-08 19:54:07 140588539000704 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622938
2017-03-08 19:54:07 140588539000704 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-08 19:54:07 140587999135488 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-08 19:54:07 140588539000704 [Note] Server socket created on IP: '::'.
2017-03-08 19:54:08 140588539000704 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: ready for connections.
Version: '10.1.20-MariaDB'  socket: '/tmp/mysql.sock'  port: 3306  MariaDB Server

Testando a disponibilidade ...

[joseluisbz@Vxbox-Lnx ~]$ mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.20-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

Desligue o Linux ...

2017-03-08 19:59:29 140588538443520 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: Normal shutdown

2017-03-08 19:59:29 140588538443520 [Note] Event Scheduler: Purging the queue. 0 events
2017-03-08 19:59:29 140587982350080 [Note] InnoDB: FTS optimize thread exiting.
2017-03-08 19:59:29 140588538443520 [Note] InnoDB: Starting shutdown...
2017-03-08 19:59:31 140588538443520 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-03-08 19:59:32 140588538443520 [Note] InnoDB: Shutdown completed; log sequence number 1622948
2017-03-08 19:59:32 140588538443520 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: Shutdown complete

170308 19:59:32 mysqld_safe mysqld from pid file /usr/local/ServerWeb/mariadb/data/Vxbox-Lnx.pid ended

Agora com o serviço ...

$ sudo systemctl enable mariadb.service
[sudo] password for joseluisbz: 
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /etc/systemd/system/mariadb.service.
[joseluisbz@Vxbox-Lnx ~]$ 

Verificando ...

[joseluisbz@Vxbox-Lnx ~]$ sudo service mariadb start
[sudo] password for joseluisbz: 
Redirecting to /bin/systemctl start  mariadb.service
[joseluisbz@Vxbox-Lnx ~]$ mysql -u root -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[joseluisbz@Vxbox-Lnx ~]$ 

STATUS

$ sudo systemctl status mariadb.service
[sudo] password for joseluisbz: 
● mariadb.service - start and stop MySQL(MariaDB) Server
  Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Active: failed (Result: exit-code) since Wed 2017-03-08 20:09:47 COT; 5min ago
  Process: 4556 ExecStart=/usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data (code=exited, status=1/FAILURE)
Main PID: 4556 (code=exited, status=1/FAILURE)

Mar 08 20:09:47 Vxbox-Lnx systemd[1]: Started start and stop MySQL(MariaDB) Server.
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: Starting start and stop MySQL(MariaDB) Server...
Mar 08 20:09:47 Vxbox-Lnx mysqld_safe[4556]: 170308 20:09:47 mysqld_safe Logging to '/usr/local/ServerWeb/mariadb/data/server.err'.
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: Unit mariadb.service entered failed state.
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: mariadb.service failed.
[joseluisbz@Vxbox-Lnx ~]$

Outra verificação

$ sudo systemctl --failed
[sudo] password for joseluisbz: 
  UNIT            LOAD   ACTIVE SUB    DESCRIPTION
● kdump.service   loaded failed failed Crash recovery kernel arming
● mariadb.service loaded failed failed start and stop MySQL(MariaDB) Server

LOAD   = Reflects whether the unit definition was properly loaded.
ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
SUB    = The low-level unit activation state, values depend on unit type.                                                                                                        

2 loaded units listed. Pass --all to see loaded but inactive units, too.                                                                                                         
To show all installed unit files use 'systemctl list-unit-files'.                                                                                                                
[joseluisbz@Vxbox-Lnx ~]$ 
    
por chepe lucho 09.03.2017 / 01:19

3 respostas

2

Não use mysqld_safe .

Você tem todos os tipos de problemas, até construir um candidato para um lugar no systemd House of Horror executando um Supervisor do Daemon do Pobre Homem (escrito mal em shell script) sob o gerenciamento de serviços. Você poderia trabalhar e ajustar as coisas para que elas funcionassem melhor, lidando com incompatibilidades de protocolo de prontidão e com conflitos em que você acabou definindo as coisas de duas formas diferentes em dois lugares diferentes, mas isso seria realmente inútil. Em vez disso, aprenda com o mundo daemontools, que queria mysqld_safe ido desde a virada do século.

Todos esses anos depois, você também pode se livrar dele no mundo do systemd. O mundo MariaDB tem a distinção, em contraste com o Oracle e o mundo MySQL, de realmente fornecer um bom documento sobre como rodar o MariaDB da maneira que os usuários daemontools / runit / s6 queriam todos esses anos, sem mysqld_safe e usando o conjunto de ferramentas de gerenciamento de serviços para gerenciamento de serviços.

O MariaDB é fornecido com uma unidade de serviço mariadb.service para o systemd e uma ferramenta mariadb-service-convert que migra as configurações de my.cnf para as configurações da unidade de serviço do systemd. Ele ainda vem com um modelo de unidade de serviço [email protected] , que permite executar vários servidores como serviços distintos. Use isso.

Leitura adicional

por 10.03.2017 / 00:24
0

Meu processo de instalação foi (antes de perguntar)

sudo tar zxvf /media/sf_Users/josebernal/Downloads/Php\ Tomcat\ Httpd\ MySQL/mariadb-10.1.20-linux-x86_64.tar.gz -C /usr/local/
sudo ln -s /usr/local/mariadb-10.1.20-linux-x86_64 /usr/local/ServerWeb/mariadb

sudo groupadd -r Gmariadb
sudo useradd -g Gmariadb -c "MariaDB User" -s /sbin/nologin -r Umariadb

sudo chown -R Umariadb:Gmariadb /usr/local/ServerWeb/mariadb/
sudo cp /usr/local/ServerWeb/mariadb/support-files/my-small.cnf /etc/my.cnf
... EDIT the config mariadb (mysql) file named my.cnf

sudo /usr/local/ServerWeb/mariadb/scripts/mysql_install_db --user=mysql --basedir=/usr/local/ServerWeb/mariadb --datadir=/usr/local/ServerWeb/mariadb/data --log-error=/usr/local/ServerWeb/mariadb/data/server.err &
....
... The next steps..

Mesmo antes de relatar (perguntei) o problema, verifiquei a Propriedade ...

[joseluisbz@Vxbox-Lnx ~]$ ls -al /usr/local/ServerWeb/mariadb/
total 224
drwxrwxr-x  13 Umariadb Gmariadb  4096 Dec 14 23:27 .
drwxr-xr-x. 18 root     root      4096 Jan  5 12:00 ..
drwxrwxr-x   2 Umariadb Gmariadb  4096 Nov 18 15:03 bin
-rw-r--r--   1 Umariadb Gmariadb 17987 Dec 14 14:25 COPYING
-rw-r--r--   1 Umariadb Gmariadb 26545 Dec 14 14:25 COPYING.LESSER
-rw-r--r--   1 Umariadb Gmariadb 86259 Dec 14 14:25 COPYING.thirdparty                                                                                                           
-rw-r--r--   1 Umariadb Gmariadb  2122 Dec 14 14:25 CREDITS                                                                                                                      
drwxrwxr-x   4 mysql    Gmariadb  4096 Mar  8 20:25 data                                                                                                                         
drwxrwxr-x   2 Umariadb Gmariadb    30 Dec 14 23:26 DESTINATION                                                                                                                  
-rw-r--r--   1 Umariadb Gmariadb  8245 Dec 14 14:25 EXCEPTIONS-CLIENT                                                                                                            
drwxrwxr-x   3 Umariadb Gmariadb    18 Dec 14 23:26 include                                                                                                                      
-rw-r--r--   1 Umariadb Gmariadb  8694 Dec 14 14:25 INSTALL-BINARY                                                                                                               
drwxrwxr-x   4 Umariadb Gmariadb  4096 Nov 18 15:03 lib                                                                                                                          
drwxrwxr-x   4 Umariadb Gmariadb    28 Dec 14 23:27 man                                                                                                                          
drwxrwxr-x  11 Umariadb Gmariadb  4096 Dec 14 23:26 mysql-test                                                                                                                   
-rw-r--r--   1 Umariadb Gmariadb  2105 Dec 14 14:25 README                                                                                                                       
-rw-r--r--   1 Umariadb Gmariadb 19510 Dec 14 14:25 README-wsrep                                                                                                                 
drwxrwxr-x   2 Umariadb Gmariadb    29 Dec 14 23:27 scripts                                                                                                                      
drwxrwxr-x  29 Umariadb Gmariadb  4096 Dec 14 23:26 share
drwxrwxr-x   4 Umariadb Gmariadb  4096 Dec 14 23:27 sql-bench
drwxrwxr-x   3 Umariadb Gmariadb  4096 Jan  4 22:32 support-files

Eu anotei na pasta data, a propriedade pertence a (mysql: mysql) após a instalação, mas eu pensei que era esse problema de script de serviço (mariadb.service) ...

[joseluisbz@Vxbox-Lnx ~]$ ls -al /usr/local/ServerWeb/mariadb/data/
total 110624
drwxrwxr-x  4 mysql    Gmariadb     4096 Mar  8 20:25 .
drwxrwxr-x 13 Umariadb Gmariadb     4096 Dec 14 23:27 ..
-rw-rw----  1 mysql    mysql       16384 Mar  8 19:59 aria_log.00000001
-rw-rw----  1 mysql    mysql          52 Mar  8 19:59 aria_log_control
-rw-rw----  1 mysql    mysql    12582912 Mar  8 19:59 ibdata1
-rw-rw----  1 mysql    mysql    50331648 Mar  8 19:59 ib_logfile0
-rw-rw----  1 mysql    mysql    50331648 Jan  4 22:01 ib_logfile1
-rw-rw----  1 mysql    mysql           0 Jan  4 22:05 multi-master.info
drwx------  2 mysql    root         4096 Jan  4 22:01 mysql
drwx------  2 mysql    mysql          19 Jan  4 22:01 performance_schema
-rw-rw----  1 mysql    mysql           0 Mar  8 20:04 server.err
[joseluisbz@Vxbox-Lnx ~]$ 

@Kalavan confirmou minha suspeita de propriedade, então eu precisei alterar a propriedade após o processo de instalação ...

sudo chown -R Umariadb:Gmariadb /usr/local/ServerWeb/mariadb/

Eu reinicio meu CentOS 7 e o serviço estava funcionando !!!

Eu verifiquei o arquivo de log /usr/local/ServerWeb/mariadb/data/server.err ..

170308 20:36:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/ServerWeb/mariadb/data
2017-03-08 20:36:23 140485189175168 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld (mysqld 10.1.20-MariaDB) starting as process 2360 ...
2017-03-08 20:36:24 140485189175168 [Warning] One can only use the --user switch if running as root

2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Using Linux native AIO
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Using SSE crc32 instructions
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Completed initialization of buffer pool
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Waiting for purge to start
2017-03-08 20:36:24 140485189175168 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622948
2017-03-08 20:36:25 140485189175168 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-08 20:36:25 140484651484928 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-08 20:36:25 140485189175168 [Note] Server socket created on IP: '::'.
2017-03-08 20:36:25 140485189175168 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: ready for connections.
Version: '10.1.20-MariaDB'  socket: '/tmp/mysql.sock'  port: 3306  MariaDB Server

Verificando o PID

[joseluisbz@Vxbox-Lnx ~]$ ps -aux | grep mariadb
mysql     1652  0.0  0.1 113264  1656 ?        Ss   11:42   0:00 /bin/sh /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data
mysql     2458  0.2  5.6 591028 87172 ?        Sl   11:42   0:00 /usr/local/ServerWeb/mariadb/bin/mysqld --basedir=/usr/local/ServerWeb/mariadb --datadir=/usr/local/ServerWeb/mariadb/data --plugin-dir=/usr/local/ServerWeb/mariadb/lib/plugin --log-error=/usr/local/ServerWeb/mariadb/data/server.err --pid-file=Vxbox-Lnx.pid --socket=/tmp/mysql.sock --port=3306
joselui+  4489  0.0  0.0 112652   964 pts/0    R+   11:44   0:00 grep --color=auto mariadb
[joseluisbz@Vxbox-Lnx ~]$ 

Efetivamente, o mariadb está funcionando !!!

Eu verifiquei o status

$ sudo systemctl status mariadb.service
[sudo] password for joseluisbz: 
● mariadb.service - start and stop MySQL(MariaDB) Server
  Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Active: active (running) since Fri 2017-03-10 11:42:07 COT; 17min ago
Main PID: 1652 (mysqld_safe)
  CGroup: /system.slice/mariadb.service
      ├─1652 /bin/sh /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data...
      └─2458 /usr/local/ServerWeb/mariadb/bin/mysqld --basedir=/usr/local/ServerWeb/mariadb --datadir=/usr/local/ServerWeb/mariadb/data --plugin-dir=/usr/local/Ser...

Mar 10 11:42:07 Vxbox-Lnx systemd[1]: Started start and stop MySQL(MariaDB) Server.
Mar 10 11:42:07 Vxbox-Lnx systemd[1]: Starting start and stop MySQL(MariaDB) Server...
Mar 10 11:42:09 Vxbox-Lnx mysqld_safe[1652]: 170310 11:42:09 mysqld_safe Logging to '/usr/local/ServerWeb/mariadb/data/server.err'.
[joseluisbz@Vxbox-Lnx ~]$ 

Mas não consigo me conectar !!

$ sudo mysql -u root -p
[sudo] password for joseluisbz: 
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[joseluisbz@Vxbox-Lnx ~]$ 

Eu verifico a existência do arquivo mysql.sock (mas não existe) ...

# ls -al /tmp/
total 24
drwxrwxrwt. 22 root       root       4096 Mar 10 12:28 .
dr-xr-xr-x. 19 root       root       4096 Feb 18 21:21 ..
drwx------   2 joseluisbz joseluisbz   52 Mar 10 11:42 akonadi-joseluisbz.Fim4n9
drwx------   2 joseluisbz joseluisbz   50 Mar 10 09:20 .com.google.Chrome.I956Ja
drwx------   2 joseluisbz joseluisbz   50 Mar 10 07:38 .com.google.Chrome.ibPaUS
drwx------   2 joseluisbz joseluisbz   50 Mar  9 07:31 .com.google.Chrome.oIW6st
drwx------   2 joseluisbz joseluisbz   50 Mar  8 19:22 .com.google.Chrome.pGYMUt
drwx------.  2 joseluisbz joseluisbz   19 Mar 10 11:42 .esd-1000
drwxrwxrwt.  2 root       root          6 Oct 10 20:09 .font-unix
prw-------   1 root       root          0 Mar 10 11:42 hogsuspend
drwxrwxrwt.  2 root       root       4096 Mar 10 11:42 .ICE-unix
drwx------.  2 joseluisbz joseluisbz   50 Mar 10 12:25 kde-joseluisbz
drwx------   2 root       root         23 Mar 10 11:44 kde-root
drwx------   2 root       root       4096 Mar 10 11:44 ksocket-root
drwx------   2 joseluisbz joseluisbz   23 Mar 10 11:42 ssh-aOJwbK0vltXX
drwx------   3 root       root         16 Mar 10 11:42 systemd-private-65b25dd58edd4711ad864dc007925904-colord.service-EVVMql
drwx------   3 root       root         16 Mar 10 11:42 systemd-private-65b25dd58edd4711ad864dc007925904-cups.service-jOD1sm
drwx------   3 root       root         16 Mar 10 11:42 systemd-private-65b25dd58edd4711ad864dc007925904-mariadb.service-eioofZ
drwx------   3 root       root         16 Mar  9 15:11 systemd-private-65b25dd58edd4711ad864dc007925904-rtkit-daemon.service-E5cH4Y
drwxrwxrwt.  2 root       root          6 Oct 10 20:09 .Test-unix
drwx------.  2 joseluisbz joseluisbz    6 Oct 10 20:42 tracker-extract-files.1000
-r--r--r--   1 root       root         11 Mar 10 11:42 .X0-lock
drwxrwxrwt.  2 root       root         24 Mar 10 11:42 .X11-unix
-rw-------   1 root       root         54 Mar 10 08:35 xauth.XXXXTFUQeQ
drwxrwxrwt.  2 root       root          6 Oct 10 20:09 .XIM-unix
[root@Vxbox-Lnx joseluisbz]# 

Então eu mudei o arquivo de configuração /etc/my.cnf alterando o local do soquete, e com certeza a pasta de propriedade (para o respectivo usuário: grupo) de sua localização ...

[client]
...
socket      = /usr/local/ServerWeb/mariadb/tmp/mysql.sock
...

[mysqld]
...
socket      = /usr/local/ServerWeb/mariadb/tmp/mysql.sock
...

E criei a pasta tmp para socket e assegure a propriedade novamente!

sudo mkdir -pv /usr/local/ServerWeb/mariadb/tmp
sudo chown -R Umariadb:Gmariadb /usr/local/ServerWeb/mariadb/

MAIS TARDE disso muda e reinicia o CentOS 7

Verificando o arquivo de log /usr/local/ServerWeb/mariadb/data/server.err ..

170311 17:31:50 mysqld_safe Starting mysqld daemon with databases from /usr/local/ServerWeb/mariadb/data
2017-03-11 17:31:50 139805859948416 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld (mysqld 10.1.20-MariaDB) starting as process 2187 ...
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Using Linux native AIO
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Using SSE crc32 instructions
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Completed initialization of buffer pool
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Waiting for purge to start
2017-03-11 17:31:51 139805859948416 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1623144
2017-03-11 17:31:51 139805379786496 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-11 17:31:51 139805859948416 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-11 17:31:51 139805859948416 [Note] Server socket created on IP: '::'.
2017-03-11 17:31:52 139805859948416 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: ready for connections.
Version: '10.1.20-MariaDB'  socket: '/usr/local/ServerWeb/mariadb/tmp/mysql.sock'  port: 3306  MariaDB Server

Iniciando o cliente ...

[joseluisbz@Vxbox-Lnx ~]$ mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.20-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

Funciona perfeitamente ...

Resumo da solução

  • A ordem da propriedade alterada para Umariadb: Gmariadb Somente após a instalação.
  • Alterando o local do Socket em que user: group pode gravar ...

NOTA : O arquivo original /etc/systemd/system/mariadb.service não tem problema!

    
por 11.03.2017 / 23:52
-1

Isso funcionou para mim:

mv /var/lib/mysql/* /opt/
    
por 02.02.2019 / 12:19