Category Archives: Programming

How to write to Google Sheet with API in PHP

Wednesday, 16 March 2022 15:28

Tim Ramsey

0 Comments

Get a service account key from https://console.cloud.google.com/apis/credentials (You can here also restrict what this keys is allowed todo)
1. When creating, make sure you click the Furnish a new private key
2. Select JSON when it asks you how to download the key.
The service account key you have just generated includes a client_email.
1. Go to you google spreadsheet and allow this client_email to have write access on this document

$sheet_name = "Sheet1";
$google_client = new \Google_Client();
$google_client->setApplicationName('Google Sheets Updater');
$google_client->setScopes([\Google_Service_Sheets::SPREADSHEETS]);
$google_client->setAuthConfig(storage_path('jsondownload.json'));
$service = new \Google_Service_Sheets($google_client);
$spreadsheet_id = 'your_sheet_id';
$range = $sheet_name.'!A:C';
$params = [
   'valueInputOption' => "USER_ENTERED"
];
$value_array = ["1","2","3","4","5","6"];
$body = new \Google_Service_Sheets_ValueRange([
   'values' => [$value_array]
]);
$service->spreadsheets_values->append($spreadsheet_id, $range, $body, $params);

$sheet_name = "Sheet1";

$google_client = new \Google_Client();

$google_client->setApplicationName('Google Sheets Updater');

$google_client->setScopes([\Google_Service_Sheets::SPREADSHEETS]);

$google_client->setAuthConfig(storage_path('jsondownload.json'));

$service = new \Google_Service_Sheets($google_client);

$spreadsheet_id = 'your_sheet_id';

$range = $sheet_name.'!A:C';

$params = [

'valueInputOption' => "USER_ENTERED"

];

$value_array = ["1","2","3","4","5","6"];

$body = new \Google_Service_Sheets_ValueRange([

'values' => [$value_array]

]);

$service->spreadsheets_values->append($spreadsheet_id, $range, $body, $params);

https://stackoverflow.com/questions/44045183/access-google-spreadsheet-api-without-auth-token

How to Migrate FreePBX server to a new server

Saturday, 22 January 2022 22:42

Tim Ramsey

0 Comments

-Install FreePBX on New Server
-Run a full backup on current server
-Deactivate the license on the current server – https://portal.sangoma.com/deployments
-Activate new server via SSH – fwconsole sysadmin activate deployementID
-Run a restore on the new server using the backup file from step above
-Change External Address from Settings > SIP Settings to new IP Address
-Update Firewall settings with new IP Address

Update Unifi Controller on Linux

Wednesday, 12 January 2022 21:11

Tim Ramsey

0 Comments

If you have a controller on a Linux box, use the following commands to update the system and install the new update

sudo apt-get update
sudo apt-get upgrade -y
sudo apt-get dist-upgrade -y
#https://www.ui.com/download/unifi/
#SOFTWARE
#UniFi Network Application 6.5.55 for Debian/Ubuntu Linux and UniFi Cloud Key
wget https://dl.ui.com/unifi/6.5.55/unifi_sysvinit_all.deb
sudo dpkg -i unifi_sysvinit_all.deb
sudo reboot

sudo apt-get update

sudo apt-get upgrade -y

sudo apt-get dist-upgrade -y

#https://www.ui.com/download/unifi/

#SOFTWARE

#UniFi Network Application 6.5.55 for Debian/Ubuntu Linux and UniFi Cloud Key

wget https://dl.ui.com/unifi/6.5.55/unifi_sysvinit_all.deb

sudo dpkg -i unifi_sysvinit_all.deb

sudo reboot

Code Signing Desktop App

Tuesday, 04 January 2022 14:22

Tim Ramsey

0 Comments

Open a Powershell prompt.
Create a new self-signed certificate for Code signing using “New-SelfSignedCertificate -DnsName “yourdomain.com” -Subject “CN=The Name of Your App” -Type CodeSigningCert -CertStoreLocation cert:\CurrentUser\My“. This will create a certificate in the Personal\Certificates folder of the Certificate Manager. You can view this by running “certmgr.msc” from a Run box.
Export the certificate’s public key to an external file for import into the trusted publishers folder of Certificate Manager using “Export-Certificate -Cert (Get-ChildItem Cert:\CurrentUser\My -CodeSigningCert)[0] -FilePath “My Code Signing Cert.cer”. Note the “[0]” brackets after the Get-ChildItem call. This implies that the certificate that you want to export is the first child item found. If you have multiple code signing certificates in your Personal storage you may need to modify this parameter. You can always double-click on the CER file that is exported to see if you’ve gotten the correct certificate.
Import the certificate file that you just exported to the trusted publishers storage using “Import-Certificate -FilePath ‘.\My Code Signing Cert.cer’ -Cert cert:\CurrentUser\Root“. This will trust the certificate on your development workstation.
Finally, sign the executable file using “Set-AuthenticodeSignature .\MyApp.exe -Certificate (Get-ChildItem cert:\CurrentUser\My -CodeSigningCert)[0]”. The same caveat regarding the “[0}” array index applies here. This is the command that I could not locate. I kept using SignTool to sign the executable but it never worked. I’m not sure if it was the trusted publisher problem, or this step. This command specifies Authenticode so I think this may have had the most impact.

After that you should have the executable show up with a certificate when authenticating with Quickbooks.

https://help.developer.intuit.com/s/question/0D54R00007GdUpJ/how-to-use-signtool-to-certify-my-quickbooks-application

Note: I got most of the information that I used from this StackOverflow Q&A, particularly the answer from @chaami:

https://stackoverflow.com/questions/84847/how-do-i-create-a-self-signed-certificate-for-code-signing-on-windows

New-SelfSignedCertificate -DnsName "truelightdesigns.com" -Subject "CN=QuickBooks Importer" -Type CodeSigningCert -CertStoreLocation cert:\CurrentUser\My -NotAfter (Get-Date).AddMonths(600)

1	New-SelfSignedCertificate -DnsName "truelightdesigns.com" -Subject "CN=QuickBooks Importer" -Type CodeSigningCert -CertStoreLocation cert:\CurrentUser\My -NotAfter (Get-Date).AddMonths(600)

Export-Certificate -Cert (Get-ChildItem Cert:\CurrentUser\My -CodeSigningCert)[0] -FilePath "QuickBooks Importer.cer"

1	Export-Certificate -Cert (Get-ChildItem Cert:\CurrentUser\My -CodeSigningCert)[0] -FilePath "QuickBooks Importer.cer"

Github publickey denied

Thursday, 30 December 2021 21:04

Tim Ramsey

0 Comments

If you ever get a publickey denied error while trying to setup a github repo on a hosting account follow these steps.

Create a new Public/Private SSH on server
Copy public key and add a “deploy key” on github
Add your privatekey to the git config

git -c core.sshCommand="ssh -i ~/.ssh/<your_key>" clone git@github.com:<user>/<repo>.git

git config core.sshCommand 'ssh -i ~/.ssh/<your_key>'

#test if key is working
ssh -T -ai ~/.ssh/g<your_key> git@github.com

git -c core.sshCommand="ssh -i ~/.ssh/<your_key>" clone git@github.com:<user>/<repo>.git

git config core.sshCommand 'ssh -i ~/.ssh/<your_key>'

#test if key is working

ssh -T -ai ~/.ssh/g<your_key> git@github.com

Page 1 of 11

Category Archives: Programming

How to write to Google Sheet with API in PHP

How to Migrate FreePBX server to a new server

Update Unifi Controller on Linux

Code Signing Desktop App

Github publickey denied

Categories

Recent Posts