Just found this about rpc bind
https://access.redhat.com/solutions/2798411
About sqlgrey
in maillog
Jan 21 21:42:56 sansspam sqlgrey: Couldn't unlink "/var/run/sqlgrey.pid" [Permission denied]
Jan 21 21:45:30 sansspam sqlgrey: Process Backgrounded
Jan 21 21:49:41 sansspam sqlgrey: dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Jan 21 21:49:41 sansspam sqlgrey: dbaccess: error: couldn't get now() from DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Jan 21 21:49:41 sansspam sqlgrey: dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Jan 21 21:49:41 sansspam sqlgrey: dbaccess: error: couldn't access config table: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
[root@sansspam mysql]# systemctl status sqlgrey
● sqlgrey.service - SQLgrey Postfix Grey-listing Policy service
Loaded: loaded (/usr/lib/systemd/system/sqlgrey.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2019-01-21 22:26:08 CET; 6min ago
Process: 5304 ExecStart=/usr/sbin/sqlgrey -d (code=exited, status=0/SUCCESS)
Main PID: 5680 (sqlgrey)
CGroup: /system.slice/sqlgrey.service
└─5680 /usr/bin/perl -w /usr/sbin/sqlgrey -d
Jan 21 22:26:08 sansspam.private.lan sqlgrey[5680]: Process Backgrounded
Jan 21 22:26:08 sansspam.private.lan sqlgrey[5680]: 2019/01/21-22:26:08 sqlgrey (type Net::Server::Multiplex) starting! pid(5680)
Jan 21 22:26:08 sansspam.private.lan sqlgrey[5680]: Binding to TCP port 2501 on host 127.0.0.1 with IPv4
Jan 21 22:26:08 sansspam.private.lan sqlgrey[5680]: Setting gid to "989 989"
Jan 21 22:26:08 sansspam.private.lan sqlgrey[5680]: Setting uid to "992"
Jan 21 22:26:08 sansspam.private.lan systemd[1]: Started SQLgrey Postfix Grey-listing Policy service.
Jan 21 22:26:09 sansspam.private.lan sqlgrey[5680]: dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No suc...directory")
Jan 21 22:26:09 sansspam.private.lan sqlgrey[5680]: dbaccess: error: couldn't get now() from DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.so...directory")
Jan 21 22:26:09 sansspam.private.lan sqlgrey[5680]: dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No suc...directory")
Jan 21 22:26:09 sansspam.private.lan sqlgrey[5680]: dbaccess: error: couldn't access config table: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql....directory")
Hint: Some lines were ellipsized, use -l to show in full.
Check mysqlserver
I noticed the mysql settings
twice in mariadb-server.cnf. I do not remember adding parameters manual, can you check this in your build?
mariadb-server.cnf
Notice the space on position 1
# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.1]
innodb-defragment = 1
innodb_buffer_pool_instances = 1
innodb_buffer_pool_size = 1G
innodb_file_per_table = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 125M
join_buffer_size = 512K
key_cache_segments = 4
max_allowed_packet = 16M
max_heap_table_size = 32M
query_cache_size = 0M
query_cache_type = OFF
read_buffer_size = 2M
read_rnd_buffer_size = 1M
skip-external-locking
skip-host-cache
sort_buffer_size = 4M
thread_cache_size = 16
tmp_table_size = 32M
bind-address = 127.0.0.1
innodb-defragment = 1
innodb_buffer_pool_instances = 1
innodb_buffer_pool_size = 1G
innodb_file_per_table = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 125M
join_buffer_size = 512K
key_cache_segments = 4
max_allowed_packet = 16M
max_heap_table_size = 32M
query_cache_size = 0M
query_cache_type = OFF
read_buffer_size = 2M
read_rnd_buffer_size = 1M
skip-external-locking
skip-host-cache
sort_buffer_size = 4M
thread_cache_size = 16
tmp_table_size = 32M
I just Shawn's post about the issue, but still it usefull info, I think
I will be back,tomorrow.
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams