Score:0

cacti container mysql service unable to start

cn flag

I tried to run this cacti container but MySQL failed to start, any idea, I have tried all sorts of answers from the site.

https://hub.docker.com/r/quantumobject/docker-cacti


[cacti@rhelvm3 ~]$ podman rm 82564cf157fe
82564cf157fec818d6212cf0dfcf2e669f3f993010895903702d778c4872be87
[cacti@rhelvm3 ~]$ podman ps -a
CONTAINER ID  IMAGE                                        COMMAND        CREATED     STATUS         PORTS                 NAMES
4fdea5925e5b  docker.io/quantumobject/docker-cacti:latest  /sbin/my_init  2 days ago  Up 2 days ago  0.0.0.0:8080->80/tcp  laughing_lederberg
[cacti@rhelvm3 ~]$ podman exec -it 4fdea5925e5b /bin/bash
root@4fdea5925e5b:/# service mysql status
 * MariaDB is stopped.
root@4fdea5925e5b:/# service mysql start
 * Starting MariaDB database server mysqld                                                                                       [fail] 
root@4fdea5925e5b:/# cat /etc/my
my_init.d/ mysql/
root@4fdea5925e5b:/# cat /etc/mysql/
conf.d/          debian.cnf       mariadb.conf.d/  my.cnf-bkup
debian-start     mariadb.cnf      my.cnf           my.cnf.fallback
root@4fdea5925e5b:/# cat /etc/mysql/my.cnf

[mysqld]
socket=/var/lib/mysql/mysql.sock

max_heap_table_size = 1073741824
max_allowed_packet = 16777216
tmp_table_size = 500M
join_buffer_size = 1000M
innodb_file_format=Barracuda
innodb_large_prefix=1
innodb_io_capacity=5000
innodb_buffer_pool_instances=62
innodb_buffer_pool_size = 7811M
innodb_additional_mem_pool_size = 80M
innodb_doublewrite = ON
innodb_flush_log_at_timeout = 10
innodb_read_io_threads = 32
innodb_write_io_threads = 16
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4

default-time-zone = America/New_York

[client]

socket=/var/lib/mysql/mysql.sock
root@4fdea5925e5b:/# ls -als /var/lib/mysql/mysql.sock
0 -rwxrwxrwx. 1 mysql mysql 0 Oct  3 22:59 /var/lib/mysql/mysql.sock
root@4fdea5925e5b:/# tail /var/log/mysql/error.log
2021-01-31 17:33:37 139652315438208 [Note] InnoDB: Using Linux native AIO
2021-01-31 17:33:37 139652315438208 [Note] InnoDB: Using SSE crc32 instructions
2021-01-31 17:33:37 139652315438208 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-01-31 17:33:37 139652315438208 [Note] InnoDB: Completed initialization of buffer pool
2021-01-31 17:33:37 139652315438208 [Note] InnoDB: Highest supported file format is Barracuda.
2021-01-31 17:33:37 139652315438208 [Note] InnoDB: 128 rollback segment(s) are active.
2021-01-31 17:33:37 139652315438208 [Note] InnoDB: Waiting for purge to start
2021-01-31 17:33:37 139652315438208 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.49-89.0 started; log sequence number 1616713
2021-01-31 17:33:37 139652315438208 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-31 17:33:37 139651662735104 [Note] InnoDB: Dumping buffer pool(s) not yet started
root@4fdea5925e5b:/# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
root@4fdea5925e5b:/# 

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.