Programming Explorer

Using MySQL but noticed that your Python scripts no longer able to retrieve data as usual?

2025-01-20T13:40:00.004+08:00

If the following symptoms apply to you:

You recently migrated from Azure MariaDB to Azure MySQL.
MySQL Workbench is able to return data successfully.
You have not made any changes to your Python scripts, but they are no longer able to retrieve data as they did before the migration.

What you should do?

Please check if you are using mysql-connector as your library. If yes, please uninstall it by using this command:

pip uninstall mysql-connector -y

After that, please run this command to install the correct MySQL library for Python:

pip install mysql-connector-python

Some useful reference articles related to this issue:

Review this article from Microsoft and you will notice that they are using mysql-connector-python as the library: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-python
Project page for mysql-connector-python: https://pypi.org/project/mysql-connector-python/
Project page for mysql-connector, which you can see they mentioned it is deprecated: https://pypi.org/project/mysql-connector/

Hit "Authentication plugin 'caching_sha2_password' is not supported" when you are using mysql-connector with Python?

2024-11-07T22:43:00.001+08:00

Hit "Authentication plugin 'caching_sha2_password' is not supported" when you are using mysql-connector with Python?

Well, the answer is:

a). Uninstall mysql-connector, and

pip uninstall mysql-connector

b). Proceed to install mysql-connector-python

pip install mysql-connector-python

Enjoy scripting!

fatal error C1083: Cannot open include file: 'sqlfront.h': No such file or directory

2024-11-04T21:32:00.000+08:00

If your environment is something like below:

Windows operating system, either 10 or 11
Python 3.13

You are trying to install pymssql, and

You hit this error message: fatal error C1083: Cannot open include file: 'sqlfront.h': No such file or directory

The quick answer for this issue is:

Downgrade your Python to version 3.12. You can easily get it from Microsoft Store.
After that, run this command to install pymssql as usual: pip install pymssql

Note: Please don't waste your time for that freetds thingy.. it won't work. A lot of links shared via stackoverflow forums already being removed or outdated.

How to verify the signature of your *.apk file?

2023-10-29T15:04:00.001+08:00

The easiest way to do it using the keytool command.

Example:

keytool -printcert -jarfile <apk_file>

Could not start Dart VM service HTTP server

2023-10-28T13:04:00.006+08:00

Environment:

Visual Studio Code v1.83.1

Symtomps:

1). When you try to debug your Flutter project, you see this error message at the Terminal "Could not start Dart VM service HTTP server"

2). You will also notice that the Hot Reload, Hot Restart are all gone!

Solution:

a). Please go to <Your_Project_Path>\android\app\src\debug folder, confirm if you have AndroidManifest.xml in that debug folder.

b). Go to <Your_Project_Path>android\app\src\profile folder, copy AndroidManifest.xml and paste it to the debug folder at Step [a].

c). Type 'flutter run' at Terminal and Hot Reload, Hot Restart should work now.

Explanation at Flutter Docs did mention how Dart VM service work with that Hot Reload and Hot Restart features. Refer https://docs.flutter.dev/tools/vs-code#hot-reload-vs-hot-restart

Happy coding!

10 steps to setup your Python Luno trading bots on Microsoft Azure

2022-12-19T23:10:00.004+08:00

10 steps to setup your Python Luno trading bots on Microsoft Azure.

Step 1: Create a Virtual Machine for Ubuntu with size = B1s. You may choose the cheapest region, which is East US 2 - refer https://azureprice.net/. You do not need any graphical user interface for this Ubuntu.

To save cost, you can consider to remove public ip from your Virtual Machine after you completed all 10 steps.
Please do not worry about the connection because the bots will still running.
You just need to associate a new public ip to your Virtual Machine when you need it - refer https://learn.microsoft.com/en-us/azure/virtual-network/ip-services/associate-public-ip-address-vm

Step 2: Now, configure the SSH to only allows the public IP address from your computer.

Step 3: Log into that Virtual Machine to remove Python 2.7 and upgrade it to version 3.10 - refer https://www.itsupportwale.com/blog/how-to-upgrade-to-python-3-10-on-ubuntu-18-04-and-20-04-lts/. Remember to install pip too.

Step 4: Now, install MySQL on your Virtual Machine using sudo command - refer https://linuxize.com/post/how-to-install-mysql-on-ubuntu-18-04/.

Step 5: After that, install MySQL Client, MySQL Connector and Luno Python SDK on Python 3.10 inside your Virtual Machine. You might need setuptools as pre-requisites.

Step 6. Deploy the Python scripts for your bots.

Step 7. Check the configurations file.

Step 8. Build the database for your bots, which will be used to store trading information.

Step 9. Use nohup command to execute your Python bots at background.

Step 10. Use ps aux command to check whether your Step 9 has been done correctly or not.

Thanks.

"Character set 'utf8' unsupported" when you run Python script with MySQL database?

2022-10-25T08:18:00.004+08:00

When you run Python script with MySQL database, system gives you this error message:

Character set 'utf8' unsupported

What Do You Need To Do?

pip uninstall mysql-connector-python

Unable to find resource t64.exe in package pip._vendor.distlib

2022-10-15T21:22:00.001+08:00

Hitting this error message "Unable to find resource t64.exe in package pip._vendor.distlib" when trying to upgrade your PIP to latest version?

Try to run the commands below:

python -m pip uninstall pip setuptools
pip install --upgrade setuptools

Source: https://www.cnblogs.com/poloyy/p/12966270.html

Supplied javaHome is not a valid folder. You supplied:

2022-09-18T21:58:00.006+08:00

You hit this error message on Visual Studio Code (or Android Studio) for your IonicFramework project after you upgraded Java in your computer:

Supplied javaHome is not a valid folder. You supplied: <folder_name_with_path>

What Is The Solution?

a). Make sure Android Studio > Settings > Build, Execution, Deployment > Build Tools > Gradle > Gradle JDK is pointing to the correct JDK version. Save all for changes.

b). For Windows, go to this folder "C:\Users\<your_Windows_user_name>\.gradle", delete all of the files and folders.

c). Go to "<your_project_folder>\android\.gradle" folder, delete all of the files and folders.

d). Run the commands below as usual:

ionic build

npx cap copy
npx cap sync
npx cap open android

How to open an URL in Chrome incognito mode using Python?

2022-03-19T13:56:00.005+08:00

You may refer to the sample codes below from us. We use Windows platform as an example:

import webbrowser

def main():

fUrl: str = 'https://prgexp.blogspot.com/'

chrome_path = 'C:\\Program Files (x86)\\Google\\Chrome\\Application\\chrome.exe'

webbrowser.register('chrome', None, webbrowser.BackgroundBrowser(chrome_path))

webbrowser.get('chrome').args.append('--incognito')

webbrowser.get('chrome').open_new_tab(fUrl)

if __name__ == '__main__':

main()

Do I need public IP for Azure VM?

2022-03-19T12:01:00.004+08:00

If you need to connect to your Azure VM from internet (means your home or your office), then yes, you will need to assign a public IP to your Azure VM.

If you prefer to access your Azure VM from Azure Portal, then you may not need any public IP.

More details at this article from Microsoft: https://docs.microsoft.com/en-us/azure/virtual-network/ip-services/associate-public-ip-address-vm

Tips: You can save money if you do not assign any public IP on your Azure VM.

使用 EVPAD 电视盒但却有很多问题，并且不时会弹出很多广告？

2020-10-29T12:38:00.001+08:00

我从2018年开始使用 EVPAD，最近我发现这个电视盒设备似乎有很多问题，例如视频加载滞后，电视频道有时在中间停止，甚至更糟的是那些广告在短时间内不断出现（而我就被逼重新启动视频）！

如何解决？

a）。在电视盒主屏幕，选择 “设置”，然后选择重置 (reset) 电视盒。不用担心，这很安全。

b）。接下来，等待电视盒重启并自行返回主屏幕。它将要求您使用您的Google帐户登录。请选择登录。

c）。您会发现所有的 app 都已消失。不用担心，请立即返回主屏幕。

d）。在主屏幕上，按 EVPAD 遥控器上的6868。您应该能够看到安装一些默认 app 的选项。

e）。请不要安装EVPAD App Store，因为我怀疑这是广告弹出的根本原因。

f）。安装 Saturn Live 和 Saturn Video 的 app，之后您的电视盒应该会焕然一新了。

注意：这篇文章是在我完成电视盒重置 7天后发布的。目前为止都没有广告弹出，现在视频速度也比之前流畅。

Using EVPAD but it's lagging and many advertisement popup?

2020-10-29T12:27:00.004+08:00

I start using EVPAD since 2018 and recently that TV BOX device seems having a lot of problems, such as, video loading is lag, TV channel sometimes stopped in the middle, even worst is those advertisements keep on appearing within short time (and I have to restart the video)!

How to Fix it?

a). Go to Settings screen, and then proceed to Reset the TV Box. Don't worry, it's safe.

b). Next, wait until the TV BOX restart and back to Home screen by itself. It will ask you to sign in using your Google account. Yes, please sign in.

c). You will notice that all apps are gone. Don't worry, please go back to Home screen now.

d). At Home screen, press 6868 on your EVPAD remote control. You should be able to see the option to install some default apps.

e). Please DO NOT install EVPAD App Store as I suspect that is the root cause of advertisement popping up.

f). Install the Saturn Live and Saturn Video apps, enjoy your TV BOX like a brand new one.

Note: This article is posted after 7 days I've done the reset on my TV BOX, there is no advertisement popping up and the video speed now is smooth.

"The wheel package is not available" when you try to install matplotlib in Python

2020-10-25T16:49:00.001+08:00

Hit into "The wheel package is not available" when you try to install matplotlib in Python?

python -m pip install matplotlib

Think you should try to run the following command first:

pip install wheel

Crystal Report: First page is always blank with sub-report

2020-07-14T19:51:00.002+08:00

Steps to resolve the issue:

a). Right-click and choose "Format Object".

b). In "Format Editor" > "Common" > Un-tick "Keep Object Together". Click "OK" to save the changes.

c). Repeat step [a] and step [b] on all sub-reports.

d). Preview the report now, first page should not be blank anymore.

Request was blocked due to exceeding usage of resource 'Concurrency' in namespace 'VSID'

2020-07-04T12:52:00.002+08:00

When you try to connect to your TFS at visualstudio.com, you received this error message: Request was blocked due to exceeding usage of resource 'Concurrency' in namespace 'VSID'.

Better check status of visualstudio.com at here: https://status.dev.azure.com/

Specified key was too long; max key length is 767 bytes

2020-06-30T23:22:00.005+08:00

Getting this error "Specified key was too long; max key length is 767 bytes" from your MySQL?

Here is the solution:

Simple, just upgrade your MySQL to at least version 5.7.30.

You may download the GA releases from here: https://dev.mysql.com/downloads/mysql/

The 'vfpoledb.1' provider is not registered on the local machine.

2020-06-25T23:07:00.000+08:00

Not able to find the solution for this error message "The 'vfpoledb.1' provider is not registered on the local machine."?

Here is the solution:

Download the msi file from here, https://www.microsoft.com/en-us/download/details.aspx?id=14839, and make sure you install as Everyone. If you choose Only Me, you will hit the same error message.
Build your application, regardless it is a web application or desktop application, in x86 mode.

Happy coding!

Want to know your MySQL database size?

2019-06-23T19:14:00.005+08:00

Well, you can try the script below:

Select
table_schema As "Database Name",
Round(Sum(data_length + index_length) / 1024 / 1024, 2) As "Database Size in MB"
From information_schema.Tables
Where table_schema = 'xxxxx'
Group By table_schema
Order By table_schema;

It takes years to output data via Microsoft SQL Server BCP (Bulk Copy Program utility)?

2019-06-23T19:11:00.003+08:00

If you are using Microsoft SQL Server BCP (Bulk Copy Program) utility, or a.k.a. XPShellCmd, and you found that your scripts take forever to execute.

Solution:

a). Always make sure your Select statement comes with NoLock for each tables.

It takes years to sign in Skype for Business?

2018-05-11T14:28:00.002+08:00

This issue in fact bugs me for months, and it only happens on my personal laptop (a Windows 10). It won't go away even I have cleared the cache for Skype for Business, delete the sign in information, etc.

Until I checked the tracing log file, and it mentioned that there is a loop while accessing my Wi-Fi adapter, I start to narrow down the possible root cause: Network adapter.

And finally I managed to get it fixed, by turning off Internet Protocol Version 6 (IPv6).

Repository has not been enabled to accept revision propchanges; ask the administrator to create a pre-revprop-change hook

2017-07-01T01:00:00.002+08:00

Not able to edit log message in your SVN?

Solution:

a). Go to your repository\hooks folder.

b). Create a file called "pre-revprop-change.bat".

c). Put the following contents into that file, and then save it.

rem Only allow log messages to be changed.
if “%4” == “svn:log” exit 0
echo Property ‘%4’ cannot be changed >&2
exit 1

d). Now, edit the SVN log message again. You should be able to edit the message now.

Yahoo shows off password...

2015-03-17T00:53:00.003+08:00

Yahoo shows off password free logins and new encrypted email technology

Original post is at here.

Unable to CTRL + SHIFT + F in Visual Studio?

2014-11-14T11:59:00.001+08:00

In order to resolve this issue, you may go to Visual Studio > Window > Reset Window Layout.

Twitter says hacking attack may have affected 250K users

2013-02-02T10:21:00.001+08:00

http://www.techradar.com/news/internet/web/twitter-says-hacking-attack-may-have-affected-250k-users-1128940?attr=all&src=rss

Sent via Flipboard : )