Hello
OCS Inventory server gave this error
ERROR: MySql connection problem 2002 ,No such file or directory
I checked the mysql status on the server, It gives an error like this
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; bad; vendor preset: enabled)
Active: failed (Result: exit-code) since Tue 2020-08-25 18:31:23 EEST; 14s ago
Process: 14288 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
Once the problem is resolved, restart the service.
mysql.service: Control process exited, code=exited status=1
mysql.service: Failed with result 'exit-code'.
Failed to start MySQL Community Server.
mysql.service: Service hold-off time over, scheduling restart.
mysql.service: Scheduled restart job, restart counter is at 5.
Stopped MySQL Community Server.
mysql.service: Start request repeated too quickly.
mysql.service: Failed with result 'exit-code'.
Failed to start MySQL Community Server.
*******************************************************************************************
/var/log/mysql/error.log
Using mutexes to ref count buffer pool pages
[Note] InnoDB: The InnoDB memory heap is disabled
[Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
[Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
[Note] InnoDB: Compressed tables use zlib 1.2.11
[Note] InnoDB: Using Linux native AIO
[Note] InnoDB: Using SSE crc32 instructions
[Note] InnoDB: Initializing buffer pool, size = 128.0M
[Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: Highest supported file format is Barracuda.
[Note] InnoDB: 128 rollback segment(s) are active.
[Note] InnoDB: Waiting for purge to start
[Note] InnoDB: Percona XtraDB (
http://www.percona.com) 5.6.46-86.2 started; log sequence number 33344576
[Note] Plugin 'FEEDBACK' is disabled.
[Note] InnoDB: Dumping buffer pool(s) not yet started
[Note] Recovering after a crash using tc.log
[ERROR] Can't init tc log
[ERROR] Aborting
How can solve this problem in OCS inventory server
