True Light Designs Blog

WHMCS Oauth userinfo.php not working

Wednesday, 21 July 2021 17:07

Tim Ramsey

0 Comments

I was trying to incorporate SSO in Freshdesk with WHMCS, but because WHMCS requires passing a query parameter = access_token instead of using the Authorization header, this is what you need to do to make it work.

1. Reveal Authorization Header in .htaccess

CGIPassAuth on

1	CGIPassAuth on

2. Use your own oauth-intermediary.php where you take the header and send the query parameter that WHMCS is expecting

<?php
//https://www.yousite.com/oauth/userinfo.php
//https://www.yousite.com/oauth-intermediary.php
header('Content-Type: application/json');
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,"https://www.youtsite.com/oauth/userinfo.php?access_token=".str_replace("Bearer ","",getallheaders()["Authorization"]));
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$server_output = curl_exec($ch);
echo $server_output;
curl_close ($ch);

<?php

//https://www.yousite.com/oauth/userinfo.php

//https://www.yousite.com/oauth-intermediary.php

header('Content-Type: application/json');

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,"https://www.youtsite.com/oauth/userinfo.php?access_token=".str_replace("Bearer ","",getallheaders()["Authorization"]));

curl_setopt($ch, CURLOPT_POST, 1);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$server_output = curl_exec($ch);

echo $server_output;

curl_close ($ch);

3. User your new https://www.yousite.com/oauth-intermediary.php as the new userinfo.php URL when requested

Loop Spreadsheet and Update image height/width

Friday, 14 May 2021 19:13

Tim Ramsey

0 Comments

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load(storage_path('file.xlsx'));
        $worksheet = $spreadsheet->getActiveSheet();
        $highestRow = $worksheet->getHighestRow();
        for($row = 1; $row <= $highestRow; ++$row){;
            $value = $worksheet->getCellByColumnAndRow(23, $row)->getValue();
            $doc = new \DOMDocument();
            @$doc->loadHTML('<node>' . $value .'</node>', LIBXML_HTML_NOIMPLIED | LIBXML_HTML_NODEFDTD);
            $images = $doc->getElementsByTagName('img');
            foreach ($images as $image) {
                if(!$image->hasAttribute('height') || $image->hasAttribute('width')){
                    $src = $image->getAttribute('src');
                    list($width, $height, $type, $attr) = @getimagesize($src);
                    if((int) $height > 0) {
                        $image->setAttribute('height', $height);
                    }
                    if((int) $width > 0) {
                        $image->setAttribute('width', $width);
                    }
                }
            }
            $document = utf8_decode($doc->saveHTML($doc->documentElement));
            $worksheet->setCellValueByColumnAndRow(23, $row, str_replace(array('<node>','</node>') , '' , $document));
        }
        $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
        $writer->save(storage_path('file-new.xlsx'));

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load(storage_path('file.xlsx'));

$worksheet = $spreadsheet->getActiveSheet();

$highestRow = $worksheet->getHighestRow();

for($row = 1; $row <= $highestRow; ++$row){;

$value = $worksheet->getCellByColumnAndRow(23, $row)->getValue();

$doc = new \DOMDocument();

@$doc->loadHTML('<node>' . $value .'</node>', LIBXML_HTML_NOIMPLIED | LIBXML_HTML_NODEFDTD);

$images = $doc->getElementsByTagName('img');

foreach ($images as $image) {

if(!$image->hasAttribute('height') || $image->hasAttribute('width')){

$src = $image->getAttribute('src');

list($width, $height, $type, $attr) = @getimagesize($src);

if((int) $height > 0) {

$image->setAttribute('height', $height);

}

if((int) $width > 0) {

$image->setAttribute('width', $width);

}

$document = utf8_decode($doc->saveHTML($doc->documentElement));

$worksheet->setCellValueByColumnAndRow(23, $row, str_replace(array('<node>','</node>') , '' , $document));

}

$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);

$writer->save(storage_path('file-new.xlsx'));

Github permission denied from cPanel

Tuesday, 29 December 2020 16:45

Tim Ramsey

0 Comments

For some reason cPanel private keys are needing to be manually added for it to connect to github properly

ssh-add /home/your_user_name/.ssh/you_private_key_file

1	ssh-add /home/your_user_name/.ssh/you_private_key_file

Also, I ran into an issue where the ssh-agent was not running and needed to be restarted with

ssh-agent bash

1	ssh-agent bash

Magento 2 Remove version signing static files

Monday, 09 November 2020 13:23

Tim Ramsey

0 Comments

INSERT INTO core_config_data (scope, scope_id, path, value) VALUES ('default', 0, 'dev/static/sign', '0');

1	INSERT INTO core_config_data (scope, scope_id, path, value) VALUES ('default', 0, 'dev/static/sign', '0');

Page 1 of 13

WHMCS Oauth userinfo.php not working

Loop Spreadsheet and Update image height/width

Github permission denied from cPanel

Magento 2 Remove version signing static files

Categories

Recent Posts