[MDEV-18774] Installing MariaDb 5.5 error Failed to resolve typeattributeset statement at /etc/selinux/targeted/tmp/modules/400/mariadb/cil:1 Created: 2019-02-28  Updated: 2021-09-01

Status: Open
Project: MariaDB Server
Component/s: Packaging, Platform RedHat
Affects Version/s: 5.5.63
Fix Version/s: 5.5

Type: Bug Priority: Major
Reporter: Linas Jusys Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 2
Labels: selinux
Environment:

CentOS Linux release 7.6.1810



 Description   

Here is the process log:

It seems as though mysql has already been installed.
The directory /var/lib/mysql has been found.  For the best results, its recommended that this be deleted.
All database data will be lost if you delete it
 
Do you want to delete it? (y is recommended)? (y,n) : y
Installing MariaDB
warning: /usr/local/directadmin/scripts/packages/MariaDB-5.5.63-centos73-x86_64-server.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-server-5.5.63-1.el7.cento################################# [100%]
190228 19:45:41 [Note] /usr/sbin/mysqld (mysqld 5.5.63-MariaDB) starting as process 15065 ...
190228 19:45:42 [Note] /usr/sbin/mysqld (mysqld 5.5.63-MariaDB) starting as process 15073 ...
 
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
 
'/usr/sbin/mysqladmin' -u root password 'new-password'
'/usr/sbin/mysqladmin' -u root -h vps40.lithost.lt password 'new-password'
 
Alternatively you can run:
'/usr/sbin/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.
 
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
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
 
Failed to resolve typeattributeset statement at /etc/selinux/targeted/tmp/modules/400/mariadb/cil:1
/usr/sbin/semodule:  Failed!
warning: /usr/local/directadmin/scripts/packages/MariaDB-5.5.63-centos73-x86_64-client.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-client-5.5.63-1.el7.cento################################# [100%]
warning: /usr/local/directadmin/scripts/packages/MariaDB-5.5.63-centos73-x86_64-devel.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-devel-5.5.63-1.el7.centos################################# [100%]
warning: /usr/local/directadmin/scripts/packages/MariaDB-5.5.63-centos73-x86_64-shared.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-shared-5.5.63-1.el7.cento################################# [100%]
warning: /usr/local/directadmin/scripts/packages/MariaDB-5.5.63-centos73-x86_64-common.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-common-5.5.63-1.el7.cento################################# [100%]
warning: /usr/local/directadmin/scripts/packages/MariaDB-5.5.63-centos73-x86_64-compat.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-compat-5.5.63-1.el7.cento################################# [100%]
usermod: no changes
Job for mysqld.service failed because a timeout was exceeded. See "systemctl status mysqld.service" and "journalctl -xe" for details.
● mysqld.service - MySQL database server
   Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: failed (Result: timeout) since Kt 2019-02-28 19:50:48 EET; 8ms ago
  Process: 15109 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
 Main PID: 15109 (code=exited, status=0/SUCCESS)
 
Vas 28 19:45:47 vps40.lithost.lt systemd[1]: Starting MySQL database server...
Vas 28 19:45:47 vps40.lithost.lt mysqld_safe[15109]: 190228 19:45:47 mysqld_safe Logging to '/var/lib/mysql/vps40.lithost.lt.err'.
Vas 28 19:45:47 vps40.lithost.lt mysqld_safe[15109]: 190228 19:45:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Vas 28 19:50:47 vps40.lithost.lt systemd[1]: mysqld.service start-post operation timed out. Stopping.
Vas 28 19:50:48 vps40.lithost.lt systemd[1]: Failed to start MySQL database server.
Vas 28 19:50:48 vps40.lithost.lt systemd[1]: Unit mysqld.service entered failed state.
Vas 28 19:50:48 vps40.lithost.lt systemd[1]: mysqld.service failed.
Waiting for mysqld to start....
Setting MySQL Root Password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Setting DirectAdmin user and password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Securing installation...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Additional log from /var/lib/mysql/vps40.lithost.lt.err:

[root@vps40 scripts]# mysql -V
mysql  Ver 15.1 Distrib 5.5.63-MariaDB, for Linux (x86_64) using readline 5.1
[root@vps40 scripts]# cat /var/lib/mysql/vps40.lithost.lt.err
190228 19:45:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190228 19:45:47 [Note] /usr/sbin/mysqld (mysqld 5.5.63-MariaDB) starting as process 15209 ...
190228 19:45:47 InnoDB: The InnoDB memory heap is disabled
190228 19:45:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190228 19:45:47 InnoDB: Compressed tables use zlib 1.2.7
190228 19:45:47 InnoDB: Using Linux native AIO
190228 19:45:47 InnoDB: Initializing buffer pool, size = 128.0M
190228 19:45:47 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
190228 19:45:47  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
190228 19:45:47  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
190228 19:45:47  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
190228 19:45:48  InnoDB: Waiting for the background threads to start
190228 19:45:49 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 0
190228 19:45:49 [Note] Plugin 'FEEDBACK' is disabled.
190228 19:45:49 [Note] Server socket created on IP: '0.0.0.0'.
190228 19:45:49 [Note] Event Scheduler: Loaded 0 events
190228 19:45:49 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.63-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
190228 19:50:47 [Note] /usr/sbin/mysqld: Normal shutdown
190228 19:50:47 [Note] Event Scheduler: Purging the queue. 0 events
190228 19:50:47  InnoDB: Starting shutdown...
190228 19:50:48  InnoDB: Shutdown completed; log sequence number 1597945
190228 19:50:48 [Note] /usr/sbin/mysqld: Shutdown complete
 
190228 19:50:48 mysqld_safe mysqld from pid file /var/lib/mysql/vps40.lithost.lt.pid ended



 Comments   
Comment by justsomeone [ 2021-09-01 ]

i have close issue to that bug but i do not have mysql installed
and with rockylinux 8.4 (redhat based) with mariadb 10.6.4
i installed mariadb using the redhat repo from here
https://downloads.mariadb.org/mariadb/repositories/#distro=RedHat&distro_release=rhel8-amd64--rhel8&mirror=marwan&version=10.6

i get this error message
Running scriptlet: MariaDB-server-10.6.4-1.el8.x86_64 6/6
Failed to resolve typeattributeset statement at /var/lib/selinux/targeted/tmp/modules/400/mariadb/cil:1
/usr/sbin/semodule: Failed!

[/usr/lib/tmpfiles.d/pesign.conf:1] Line references path below legacy directory /var/run/, updating /var/run/pesign → /run/pesign; please update the tmpfiles.d/ drop-in file accordingly.

the cil file is a compressed file that contain only single text file and it's content as follow

(typeattributeset cil_gen_require mysqld_safe_t)
(allow mysqld_safe_t self (capability (setuid setgid)))

and there 2 folder called pesign one at /var/run and another one at /run
the pesign.conf is text file include the following

D /var/run/pesign 0770 pesign pesign -

should i change it to be D /var/pesign 0770 pesign pesign - or what?

Generated at Thu Feb 08 08:46:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.