I can't start memsql with Permission denied exception

Help
1

Hi, When I installed memsql, I can’t start it on the memsql server, the exception is like below:

[root@sasz151 tracelogs]# systemctl status memsql
● memsql.service - MemSQL
Loaded: loaded (/opt/memsql-server-7.3.3-df463e2f33/memsql.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Sat 2022-05-14 01:55:54 CST; 2 days ago
Process: 22789 ExecStart=/usr/bin/memsqlctl start-node --yes --all (code=exited, status=1/FAILURE)
Main PID: 22789 (code=exited, status=1/FAILURE)

May 14 01:55:54 sasz151 memsqlctl[22789]: 35 2022-05-14 01:55:52.590 INFO: Log opened
May 14 01:55:54 sasz151 memsqlctl[22789]: 01742261 2022-05-14 01:55:54.332 ERROR: SSL load certificate file failed with Permission denied (13)
May 14 01:55:54 sasz151 memsqlctl[22789]: 01742289 2022-05-14 01:55:54.332 ERROR: SSL load certificate file failed with SSL_CTX_use_certificate_file:system lib (0)
May 14 01:55:54 sasz151 memsqlctl[22789]: [182B blob data]
May 14 01:55:54 sasz151 memsqlctl[22789]: 01742313 2022-05-14 01:55:54.332 ERROR: Failed to start MemSQL
May 14 01:55:54 sasz151 memsqlctl[22789]: 01742323 2022-05-14 01:55:54.332 ERROR: ./memsqld: exiting
May 14 01:55:54 sasz151 memsqlctl[22789]: : Failed to connect to MemSQL: process exited: exit status 1
May 14 01:55:54 sasz151 systemd[1]: memsql.service: Main process exited, code=exited, status=1/FAILURE
May 14 01:55:54 sasz151 systemd[1]: memsql.service: Failed with result ‘exit-code’.
May 14 01:55:54 sasz151 systemd[1]: Failed to start MemSQL.

And following is the tracelog:

48 2022-05-14 01:52:38.489 INFO: Log opened
01741217 2022-05-14 01:52:40.230 INFO: Initializing OpenSSL
01741956 2022-05-14 01:52:40.231 ERROR: SSL load certificate file failed with Permission denied (13)
01741991 2022-05-14 01:52:40.231 ERROR: SSL load certificate file failed with SSL_CTX_use_certificate_file:system lib (0)
+1742003 2022-05-14 01:52:40.231 ERROR: SSL setup failed using file: ߽*ѕ2Ũ©w?𡌁Ѝ½ʎسþÐ澬¡Ջ.¨¤)𿗇C°^7Y󹔂z®aX©l¦f:ћ['΁½񎮕уgᱼ´򢜸T.6ú£
01742016 2022-05-14 01:52:40.231 ERROR: Failed to start MemSQL
01742026 2022-05-14 01:52:40.231 ERROR: ./memsqld: exiting

Could you please help me?
It already blocks us for some time.

Thanks,
Ken

1 Like
2

Hello miansheng.wu! Welcome to our community forums. :wave:

Are you on a managed or self-hosted service and what version are you running?