mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on the MySQL Forums. Someone solved their issue by resetting (or re-issuing) their password which implies there was an issue with pre 4.1.1 passwords...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 key to use JoelLipman.com data Note: You should delete/uninstall this app or clear its data before giving your device to someone else as it can login to your online account automatically. Sharing: • Do not share security or personal details. • By...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 a script which accesses a Google Drive using a Service Account (unattended). Why? This is a big cop-out as I simply took someone else's functions and upgraded them to use the mentioned token based authentication. I find myself going through the motion...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 something like 1557400230165 Method #1: 5 Randomly Selected Letters Using a snippet from the community forums on how someone shuffled a pack of cards, I came up with a function that will take a list of letters, shuffle the list, and return the first 5...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 in its app. HTML and CSS are mostly allowed but JavaScript automatically gets removed from any of your code. How? As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Assign an integration field value with an integration valuehttps://joellipman.com/articles/crm/zoho/zoho-creator-assign-an-integration-field-value-with-an-integration-value.html

27 July 2021 This is a quick article to help anyone encountering this gotcha: I have an integration field, if someone changes it, I want to save the value to the record immediately. Why? If you try to update an integration field via deluge with another integration...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Generate List of TimeZoneshttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with a list...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 account manager against the customer and if that isn't populated then the first estimate, sales order, invoice created by someone in relation to that customer; else take the sales person against the record: SELECT DISTINCT c."Customer ID" AS "Customer...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 their domain registrar's website and need to be assisted, perhaps via a remote session, on setting these up. If they have someone or a company which manages their domain, then they can give the following instructions to these instead. ZohoCRM: Get...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 tag present with different colour already.","status":"error"} -> Error was due to someone already giving tags with the same name -> Solution is to remove the color_code key as well... m_Tag.remove("color_code"); */ Considering that neither the color...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Ubuntu as a media serverhttps://joellipman.com/articles/linux/ubuntu-as-a-media-server.html

19 September 2009 1. If someone wants to use Ubuntu as a home media pc connected to a tv, there is the problem of overscan; consumer tv's crop off the border around the image. How does Ubuntu intend to officially solve this? Right now LinuxMCE has it's own method for...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Search and Replace in a MySQL Databasehttps://joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Invalid arguments passed in router.php on line 325https://joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 I'd put this error in here and how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

UNC Paths in Sharepoint 2007 linkshttps://joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 if other users haven't mapped the same drive letter to the path? Then they won't be able to use the link. Why? As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply...

• Type: Article
• Author: Joel Lipman
• Category: SharePoint
• Language: *

Zoho Deluge - Hide Reset Button on Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge-hide-reset-button-on-form.html

15 November 2018 form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a "reset" button is so 1990. I have a confirmation page and don't want the button to show so... How? Well edit the HTML......

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *