Jump to content

agarzon

Level 2 Member
  • Content count

    39
  • Joined

  • Last visited

  • Days Won

    1

agarzon last won the day on March 5

agarzon had the most liked content!

Community Reputation

8 Neutral

About agarzon

  • Rank
    Level 2 Member
  1. agarzon

    SSL Monitoring does not work.

    Update: I just updated to 7.7.1 and all issues (so far) are fixed. However, we are still forced to show that ugly and useless icon and we still don't have any control or power to just say: I don't want/need that SSL status in my system
  2. agarzon

    SSL Monitoring does not work.

    I did not heard from WHCMS in a while and has been weeks since the bug was reported.
  3. agarzon

    SSL Monitoring does not work.

    I believe (as software engineer I am). WHCMS should make this new SSL monitoring feature fully optional and allowing easy enable/disable settings in the configuration panel or in the configuration.php file in the simplest case. And that is because adding invasive new features must be done with quirurgical precision and always having in mind: maybe some customers does not want what we think they want. No mentioning that evidently the feature was not fully tested before released as stable. Recommending customer to edit files in your theme is not a smart move, since the new SSL monitoring bug is not only estetical problem, there are some backend processes involved... and also because mostly of your customers are not coders and expect a "working product". Next time guys you think in adding a new invasive feature, please consider giving us (your customers) the power to enable/disable as will any idea that maybe WHMCS think is good, but ends being a bad idea. I've been with WHMCS since almost 8 years ago.
  4. agarzon

    SSL Monitoring does not work.

    And another bug to the list: 😂 SslSync cron task is going through ALL hosting and domains including anything terminated decades ago, also all marked as fraud, cancelled, closed, etc... my tblsslstatus table is going already for 3000 records and still counting. (probably will hit 25000 records and if that is the case the cron task will take 10 hours tom complete (everyday????).
  5. agarzon

    SSL Monitoring does not work.

    and BTW, even when (again) this is not documented, I figured out the filter for cron is: cron.php do --SslSync
  6. agarzon

    SSL Monitoring does not work.

    I start to believe the problem is not the cron task, the SSL monitor can perform a check even without the CRON and save the result in the table tblsslstatus as a "live action". The problem is not even the collation (I've move everything to utf8_unicode_ci according recommended here: https://docs.whmcs.com/System_Health_Status)... which btw the Database Collations check is not part of Health report but documentation says it does ¿? Anyways, the problem is the SSL monitor is not reading the SSL information properly.
  7. agarzon

    SSL Monitoring does not work.

    I don't see any SSL sync listed here: https://docs.whmcs.com/Crons It is possible to filter the cron task to only SSL sync? just like cron.php do --UpdateServerUsage ? I don't want to force ALL task each time until I figured out whats the problem with mix of collation
  8. agarzon

    SSL Monitoring does not work.

    Even when this is not documented at ALL. I suspected maybe there is a cron task related with the new SSL monitor. So I went to check and executed (https://help.whmcs.com/m/64751/l/683269) cron.php all -F -vvv And I saw that indeed there SSL monitor and cron are related. But it failed. WHMCS Automation Task Utility: all ================================== Daily Cron Automation Mode Queuing Tasks ------------- Force run any tasks: ignore "in progress" and "is due" Task queues ready Executing Application Queue --------------------------- 0/27 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% < 1 sec/< 1 sec 22.0 MiB Currency Exchange Rates 1/27 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░] 3% < 1 sec/< 1 sec 22.0 MiB Product Pricing Updates 2/27 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░] 7% < 1 sec/< 1 sec 22.0 MiB Invoices 3/27 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░] 11% < 1 sec/< 1 sec 24.0 MiB Late Fees 4/27 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░] 14% 1 sec/7 secs 24.0 MiB Credit Card Charges 5/27 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░] 18% 1 sec/5 secs 24.0 MiB Invoice & Overdue Reminders 6/27 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░] 22% 4 secs/18 secs 40.0 MiB Domain Renewal Notices 7/27 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░] 25% 4 secs/15 secs 40.0 MiB Cancellation Requests 8/27 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░] 29% 4 secs/14 secs 40.0 MiB Overdue Suspensions 9/27 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░] 33% 5 secs/15 secs 40.0 MiB Overdue Terminations 10/27 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░] 37% 5 secs/14 secs 40.0 MiB Fixed Term Terminations 11/27 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░] 40% 5 secs/12 secs 40.0 MiB Inactive Tickets 12/27 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░] 44% 5 secs/11 secs 42.0 MiB Delayed Affiliate Commissions 13/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░] 48% 6 secs/12 secs 42.0 MiB Affiliate Reports 14/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░] 51% 6 secs/12 secs 42.0 MiB Email Marketer Rules 15/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░] 55% 6 secs/11 secs 42.0 MiB Credit Card Expiry Notices 16/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░] 59% 7 secs/12 secs 42.0 MiB SSL Sync [ERROR] PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' in /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php:335 Stack trace: #0 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(335): PDOStatement->execute(Array) #1 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select `userid`...', Array) #2 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select `userid`...', Array, Object(Closure)) #3 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select `userid`...', Array, Object(Closure)) #4 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select `userid`...', Array, true) #5 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect() #6 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1813): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/www.venehosting.com/vendor/illuminate/database/Eloquent/Builder.php(442): Illuminate\Database\Query\Builder->pluck('userid', 'domain') #8 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): Illuminate\Database\Eloquent\Builder->pluck('userid', 'domain') #9 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): WHMCS\Cron\Task\SslStatusSync->getNewDomains() #10 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Cron\Task\SslStatusSync->__invoke() #11 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Scheduling\Task\AbstractTask->execute() #12 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Scheduling\Task\AbstractTask->run() #13 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Cron\Console\Command\AbstractCronCommand->executeCollection(Object(WHMCS\Scheduling\Task\Collection)) #14 /var/www/www.venehosting.com/vendor/symfony/console/Command/Command.php(259): WHMCS\Cron\Console\Command\AbstractCronCommand->execute(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(844): Symfony\Component\Console\Command\Command->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRunCommand(Object(WHMCS\Cron\Console\Command\AllCommand), Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(123): Symfony\Component\Console\Application->doRun(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/www.venehosting.com/crons/cron.php(0): Symfony\Component\Console\Application->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' (SQL: select `userid`, `domain` from `tblhosting` where `domain` != and domain NOT IN (SELECT domain_name FROM tblsslstatus)) in /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php:713 Stack trace: #0 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select `userid`...', Array, Object(Closure)) #1 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select `userid`...', Array, Object(Closure)) #2 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select `userid`...', Array, true) #3 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1813): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/www.venehosting.com/vendor/illuminate/database/Eloquent/Builder.php(442): Illuminate\Database\Query\Builder->pluck('userid', 'domain') #6 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): Illuminate\Database\Eloquent\Builder->pluck('userid', 'domain') #7 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): WHMCS\Cron\Task\SslStatusSync->getNewDomains() #8 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Cron\Task\SslStatusSync->__invoke() #9 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Scheduling\Task\AbstractTask->execute() #10 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Scheduling\Task\AbstractTask->run() #11 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Cron\Console\Command\AbstractCronCommand->executeCollection(Object(WHMCS\Scheduling\Task\Collection)) #12 /var/www/www.venehosting.com/vendor/symfony/console/Command/Command.php(259): WHMCS\Cron\Console\Command\AbstractCronCommand->execute(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(844): Symfony\Component\Console\Command\Command->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRunCommand(Object(WHMCS\Cron\Console\Command\AllCommand), Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(123): Symfony\Component\Console\Application->doRun(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/www.venehosting.com/crons/cron.php(0): Symfony\Component\Console\Application->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} 17/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░] 62% 7 secs/11 secs 42.0 MiB Server Usage Stats 18/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░] 66% 20 secs/30 secs 46.0 MiB Overage Billing Charges 19/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░] 70% 21 secs/30 secs 46.0 MiB Client Status Update 20/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░] 74% 21 secs/28 secs 46.0 MiB Domain Expiry 21/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░] 77% 21 secs/27 secs 46.0 MiB Ticket Escalation Rules 22/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░] 81% 22 secs/27 secs 46.0 MiB Data Retention Pruning 23/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░] 85% 22 secs/26 secs 46.0 MiB WHMCS Updates 24/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░] 88% 25 secs/28 secs 54.0 MiB Run Jobs Queue 25/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░] 92% 25 secs/27 secs 54.0 MiB Domain Transfer Status Synchronisation 26/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░] 96% 26 secs/27 secs 56.0 MiB Domain Expiry Synchronisation 27/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 38 secs/38 secs 56.0 MiB Sending Daily Cron Digest email Executing System Queue ---------------------- 4/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% < 1 sec/< 1 sec 58.0 MiB [WARNING] 1 tasks failed to complete But my upgrade to 7.7.0 was successful with no errors according the installer.log [2019-01-29 15:46:35][WHMCS Installer] DEBUG: Installer bootstrapped [] [2019-01-29 15:46:37][WHMCS Installer] DEBUG: Installer bootstrapped [] [2019-01-29 15:46:37][WHMCS Installer] INFO: Previous install detected [] [2019-01-29 15:46:37][WHMCS Installer] DEBUG: An upgrade from 7.6.2-release.1 to 7.7.0-release.1 will be attempted. [] [2019-01-29 15:46:42][WHMCS Installer] DEBUG: Installer bootstrapped [] [2019-01-29 15:46:42][WHMCS Installer] INFO: Applying incremental updates to existing installation [] [2019-01-29 15:46:42][WHMCS Installer] INFO: Applying Updates for 7.7.0-alpha.1 [] [2019-01-29 15:46:49][WHMCS Installer] INFO: Performing Update Action: addPrimaryKeysToTables [] [2019-01-29 15:46:59][WHMCS Installer] INFO: Performing Update Action: migrateEUVatAddon [] [2019-01-29 15:46:59][WHMCS Installer] INFO: Performing Update Action: createInvoiceDataTable [] [2019-01-29 15:47:00][WHMCS Installer] INFO: Performing Update Action: correctSpamExpertsEmailTemplate [] [2019-01-29 15:47:00][WHMCS Installer] INFO: Performing Update Action: migrateStorageConfigurations [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: updateRecaptchaOptions [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: createSslStatusTable [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: createTransactionHistoryTable [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Applying Updates for 7.7.0-beta.1 [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: updateSpamExpertsWelcomeEmail [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: createCodeGuardWelcomeEmail [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Applying Updates for 7.7.0-rc.1 [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Performing Update Action: removeUnusedLegacyModules [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Applying Updates for 7.7.0-release.1 [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Performing Update Action: registerSslStatusSyncCronTask [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Upgrade process completed. [] Who knows what else is broken... I guess I will be better to change the template and hide that icon, I don't want my customers to get confused.
  9. All my hosted domains are SSL protected by letsencrypt automatically. However looks like they don't according the new SSL monitor (7.7.0) Already checked the https://help.whmcs.com/m/85428/l/1035090-troubleshooting-red-ssl-monitoring-padlock-icons and doesn't help. Running CURL from the same server my WHCMS is installed always success with no errors at all. Tested different domains, this one is just one of hundred of samples: curl -v https://aldeavalleencantado.com * Rebuilt URL to: https://aldeavalleencantado.com/ * Trying 173.208.145.134... * TCP_NODELAY set * Connected to aldeavalleencantado.com (173.208.145.134) port 443 (#0) * Initializing NSS with certpath: sql:/etc/pki/nssdb * CAfile: none CApath: none * loaded libnssckbi.so * ALPN, server accepted to use h2 * SSL connection using TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 * Server certificate: * subject: CN=aldeavalleencantado.com * start date: Dec 17 15:34:50 2018 GMT * expire date: Mar 17 15:34:50 2019 GMT * common name: aldeavalleencantado.com * issuer: CN=Let's Encrypt Authority X3,O=Let's Encrypt,C=US * Using HTTP2, server supports multi-use * Connection state changed (HTTP/2 confirmed) * Copying HTTP/2 data in stream buffer to connection buffer after upgrade: len=0 * Using Stream ID: 1 (easy handle 0x23abdf0) > GET / HTTP/2 > Host: aldeavalleencantado.com > User-Agent: curl/7.57.0 > Accept: */* > * Connection state changed (MAX_CONCURRENT_STREAMS updated)! < HTTP/2 200 < server: nginx < date: Tue, 29 Jan 2019 17:12:47 GMT < content-type: text/html < content-length: 5531 < last-modified: Mon, 17 Dec 2018 16:34:04 GMT < vary: Accept-Encoding < etag: "5c17cffc-159b" < x-powered-by: PleskLin < accept-ranges: bytes < ......
  10. agarzon

    Notifications customization

    Good idea... I'm taking it. 😀 For anyone else willing to go straight to it: The file is in templates/{yourtheme}/header.tpl Search this line: <span class="label label-info">{lang key='notificationsnew'}</span> And replace it with: <span class="label label-info">{count($clientAlerts)}</span>
  11. Did you notice that WHCMS deleted the admin/todolist.php file in the latest 7.5.1 ? Is not my code. You can see it your-self, just download the 7.5.1 full and you will see the file is not there anymore. I can detect those mistakes because I track all the changes between versions with my own git repository. Not so hard actually. git log --diff-filter=D --summary Nice job devs.
  12. I created a folder in /home/whmcs-tmp with 777 and owner same as webserver (www-data) And still getting the same error: Warning You will not be able to perform an update until a path is set. PHP 5.6 as FPM with NGINX.
  13. agarzon

    WHMCS 6 email verification

    Agreed. Email verification builtin on WHMCS is 100% useless, I thought will help me to prevent fake accounts creations and hard bounces (I use Amazon SES), but is just a decorative feature.
  14. Create Products/Services using enomssl trigger a JS error: jquerylq.js:11 Uncaught ReferenceError: jQuery is not defined 5.3.12 General Release (5.3.12-release.1) No custom admin theme (v4)
  15. agarzon

    Missing Domain Transfer Complete Email Template?

    I had the same issue. As Marco said, creating a template called "Domain Transfer Completed", is a fix. But this still being a bug in WHCMS since this should come by default in any installation.
×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated