AutoSSL script failing on server.

[ViLAYER]

Hello,

I'm newly registered here however i have used cPanel for a very long time.

Got a strange issue which I'm having problems with and wondered if anyone else has had this issue.

Firstly AutoSSL no matter the provider won't create, won't renew and all domains are starting to have their SSL expire.

This is the error I'm getting

/usr/local/cpanel/bin/autossl_check --all                                                                                                     
Use of uninitialized value $DBI::errstr in concatenation (.) or string at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 131.
warn [autossl_check] Cannot connect to database: /var/cpanel/autossl_problems.sqlite:  (Cpanel::Exception::ModuleLoadError/(XID cpaagq) The system failed to load the module “Cpanel::SSL::Auto::Problems::DB::schema_v1” because of an error: Can't locate Cpanel/SSL/Auto/Problems/DB/schema_v1.pm in @INC (you may need to install the Cpanel::SSL::Auto::Problems::DB::schema_v1 module) (@INC contains: /usr/local/cpanel /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib /usr/local/cpanel/3rdparty/perl/530/lib/perl5/5.30.0/x86_64-linux-64int /usr/local/cpanel/3rdparty/perl/530/lib/perl5/5.30.0 /opt/cpanel/perl5/530/site_lib/x86_64-linux-64int /opt/cpanel/perl5/530/site_lib) at (eval 5) line 1.
BEGIN failed--compilation aborted at (eval 5) line 1.

 at /usr/local/cpanel/Cpanel/LoadModule.pm line 77.
        Cpanel::LoadModule::load_perl_module("Cpanel::SSL::Auto::Problems::DB::schema_v1") called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 227
        Cpanel::SQLite::AutoRebuildSchemaBase::_schema_check(Cpanel::SSL::Auto::Problems::DB=HASH(0x1f6e438), HASH(0x125ba98)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildBase.pm line 180
        Cpanel::SQLite::AutoRebuildBase::new_without_rebuild("Cpanel::SSL::Auto::Problems::DB") called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildBase.pm line 115
        Cpanel::SQLite::AutoRebuildBase::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97
        eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88
        Try::Tiny::try(CODE(0x1f6dec8), Try::Tiny::Catch=REF(0x1f6dac0)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildBase.pm line 128
        Cpanel::SQLite::AutoRebuildBase::new("Cpanel::SSL::Auto::Problems::DB") called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildBase.pm line 232
        Cpanel::SQLite::AutoRebuildBase::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97
        eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88
        Try::Tiny::try(CODE(0x1f6d8f8), Try::Tiny::Catch=REF(0x1f6d880)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildBase.pm line 247
        Cpanel::SQLite::AutoRebuildBase::new_with_wait("Cpanel::SSL::Auto::Problems::DB") called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 124
        Cpanel::SQLite::AutoRebuildSchemaBase::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97
        eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88
        Try::Tiny::try(CODE(0x1f649c0), Try::Tiny::Catch=REF(0x1f643a8)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 132
        Cpanel::SQLite::AutoRebuildSchemaBase::_dbconnect("Cpanel::SSL::Auto::Problems::DB", 1, HASH(0x125ddc0)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 91
        Cpanel::SQLite::AutoRebuildSchemaBase::dbconnect("Cpanel::SSL::Auto::Problems::DB") called at /usr/local/cpanel/Cpanel/SSL/Auto/Problems.pm line 74
        Cpanel::SSL::Auto::Problems::new("Cpanel::SSL::Auto::Problems") called at bin/autossl_check.pl line 192
        bin::autossl_check::__ANON__() called at /usr/local/cpanel/Cpanel/PIDFile.pm line 99
        Cpanel::PIDFile::do("Cpanel::PIDFile", "/var/cpanel/autossl_check.pid", CODE(0x1d84f98)) called at bin/autossl_check.pl line 350
        bin::autossl_check::_run_maybe_captured(bin::autossl_check=HASH(0x1d202b8)) called at bin/autossl_check.pl line 116
        bin::autossl_check::__ANON__() called at /usr/local/cpanel/Cpanel/CaptureFH.pm line 50
        Cpanel::CaptureFH::do_with_output_captured_to_path_if_non_tty("/usr/local/cpanel/logs/error_log", CODE(0x1d249e8)) called at bin/autossl_check.pl line 117
        bin::autossl_check::run(bin::autossl_check=HASH(0x1d202b8)) called at bin/autossl_check.pl line 102
)
Odd number of elements in anonymous hash at /usr/local/cpanel/Cpanel/SSL/Auto/Problems.pm line 74.
Can't call method "selectrow_arrayref" on an undefined value at /usr/local/cpanel/Cpanel/SQLite/Compat.pm line 16.

I don't have any logs in cPanel or anything. The only way I was able to get this information was running it from console.

Any ideas?

 

[SamuelM]

Hello @ViLAYER

Thank you for contacting cPanel! And welcome to the forums.

That is an unusual error. I suspect there might be something wrong with the SQLite database noted in the error. Can you please login to your server via SSH and run the following commands?

# stat /var/cpanel/autossl_problems.sqlite

# sqlite3 /var/cpanel/autossl_problems.sqlite "select * from metadata;"

And please reply with the results of those commands.

I suspect that you might find the table to be empty. If that is the case you can update it with the following series of commands:

# mv -v /var/cpanel/autossl_problems.sqlite{,.bak}

# sqlite3 /var/cpanel/autossl_problems.sqlite
sqlite> INSERT INTO "metadata" VALUES('schema_version','1');
sqlite> .quit

We will be eager to know your results. If you find that updating the metadata table does not solve the problem, we will be happy to assist further. Also, you are welcome to submit a ticket using the link in my signature.

Best regards.