SOLVED Purge /usr/local/cpanel/bin/autossl_check_cpstore_queue

[bloatedstoat]

Hello,

I recently used the WHM method of renewing an SSL certificate.

The order went through and I received an email with the cert within it.

The certificate did not install after waiting for it to auto-install so I eventually installed it manually which was easy enough. It suggests this can be done in the email with the certificate.

Thing is, every 5 minutes I am receiving an email with:-

warn [process_ssl_pending_queue] User file '/var/cpanel/users/username' is empty or non-existent......

I read on the forum that after 86400 seconds the script eventually gives up. But that's 480 emails later!

Is there a way to either purge /local/cpanel/bin/autossl_check_cpstore_queue or at the very least silence it?

Thank you.

P.S I have a support ticket opened for this but if a solution is found I can close it before it is attended to and not waste anyone's time.

 

[bloatedstoat]

This can be marked as solved.

Ausif Lateef at cpanel support resolved this issue with:

mv -v /home/username/.cpanel/ssl/pending_queue.json /home/username/.cpanel/ssl/pending_queue.json-old

If anyone else experiences the same thing the above line will sort it out (substitute username for the account name btw)

 

[cPanelMichael]

Hello,

I'm glad to see the issue is now solved. Thank you for updating us with the outcome.

 

[Kent Brockman]

Hello guys, what would be the updated path in cPanel v100? I have the same issue but I cannot find the file.

 

[bellwood]

Hello guys, what would be the updated path in cPanel v100? I have the same issue but I cannot find the file.

On my servers, AutoSSL is using a sqlite file at:

/var/cpanel/autossl_queue_cpanel.sqlite

If you want to purge out pending requests for a particular user:

[~] cd /var/cpanel
sqlite3 autossl_queue_cpanel.sqlite
sqlite> delete from requests where username='$username';
sqlite> .quit

...substituting $username as needed.

Of course you can also just mv that file to autossl_queue_cpanel.sqlite.old if you want to blow the whole queue away.

HTH