malamsson

MySQL to MariaDB

2026-09-17T09:39:35.093+02:00

Here is a good description how to migrate to MariaDb

Example of how to dump data from MySQL port=3307:

mysqldump --user=root --password=SECRET --port=3307 --databases automaze --single-transaction --routines --events --triggers --hex-blob > c:\junk\migration_dump.sql

Import to MariaDb:

mariadb -u root -p < c:\junk\migration_dump.sql

2026-09-01T20:29:09.776+02:00

MySQL, Views, Procedures and Functions.

Having problem exporting Schemas to other computers due to DEFINER = 'OldCreator'@'%'

If the Schema have a default user change DEFINER = 'DefaultUser'@'%' will make it easier to export the Schema to another user or database.

Also change SQL Security from Definer to Invoker.

Example: function CountJumperOnPiggyType

DELIMITER ;;
CREATE DEFINER=`DefaultUser`@`%` FUNCTION `CountJumperOnPiggyType`(
`INPpt_ix` INT
) RETURNS int
READS SQL DATA
SQL SECURITY INVOKER
BEGIN
RETURN (SELECT ix, p_name FROM generic_piggy_jumper WHERE pt_ix=INPpt_ix)
;
END ;;
DELIMITER ;

Editing Views, Procedures and Function work best with HeidiSQL

2026-05-06T10:21:00.003+02:00

Apache2 crashes on Ubuntu Linux 22.04.5 after Zabbix was updated to 7.0.26

During a upgrade of my Ubuntu server there was a new package for Zabbix 7.0.26 (maybe also apache2, unknown by me).

Apache2 stops working so did Zabbix.

Apache2 complains about Apache 'ProxyTimeout 300' found in /etc/apache2/conf-enabled/zabbix.conf

On my system following Apache2 modules wasn't running

proxy, proxy_http, proxy_fcgi

So try to enabled them first by running in bash.

sudo a2enmod proxy

sudo a2enmod proxy_http

sudo a2enmod proxy_fcgi

Then restart Apache2 using:

sudo systemctl restart apache2

Now check if Apache and Zabbix is up and running.

I also modified the /etc/apache2/conf-enabled/zabbix.conf, maybe not needed. I add the new data in zabbix.conf:

# Define the alias so /zabbix points to the correct folder

Alias /zabbix /usr/share/zabbix

Options FollowSymLinks

AllowOverride None

Require all granted

php_value max_execution_time 300

php_value memory_limit 128M

php_value post_max_size 16M

php_value upload_max_filesize 2M

php_value max_input_time 300

php_value max_input_vars 10000

# Replace the timezone below with your actual timezone

php_value date.timezone UTC

</IfModule>

</Directory>

Require all denied

</Directory>

Require all denied

</Directory>

Require all denied

</Directory>

Require all denied

</Directory>

# The line that was causing your original error

ProxyTimeout 300

If you updated zabbix.conf then restart apache2 again

sudo systemctl restart apache2

2026-04-02T15:02:00.000+02:00

Revert ClickOnce applications.

Sometimes things don't goes as planned doing a new ClickOnce Release.

To revert back to the next newest on the web server do as follow:

There will be a 'Application Files' folder at the root, open the next newest and copy

<YourApp>.application file THEN go back to root folder and overwrite the <YourApp>.application located there.

Now you can remove the version folder under 'Application Files' for the bad version.

Open the index.html (could be namned something else) file in the root folder, look for version and correct it to what you selected from 'application files'.

Done, next fix your broken application :)

2026-02-23T14:12:00.003+02:00

app.config

To hide tokens passwords etc

In your vb.net project open app.config

Add following lines

</appSettings>

Next create a secret.config file in same folder as app.config.

Add the file to the project and set properties 'Copy if newer'

Add following to it to secret.config:

</appSettings>

Now in your code:

dim dbUser as string=ConfigurationManager.AppSettings("dbUsER")

Next exclude secret.config to be uploaded to your repository.

gitIgnore

2025-10-28T19:49:00.004+02:00

Samba share stopped working on Windows11 😒😖

Some fantastic update ruined my life.

Fix:

Run powershell as admin, run following commandos

Set-SmbClientConfiguration -RequireSecuritySignature $false

Set-SmbClientConfiguration -EnableInsecureGuestLogons $true

Found at : fix samba

2025-03-26T10:54:00.003+02:00

IIS Backup and Restore

Good link

2025-03-14T14:32:00.004+02:00

Ubuntu Server DNS problem.

After a PC restart if computer got a new IP-address from DHCP it takes for ever for it to show up in DNS.

Doing a nslookup mycomputername from the ubuntu server it

showed that it wasn't using the DHCP DNS server but used its own.

DNS was from 127.0.0.53.

I ran

sudo apt install resolvconf

After that nslookup shows the correct DNS server :)

ClickOnce application, how to restore for user if they click the Skip button.

2025-02-14T14:11:00.007+02:00

in Command prompt run:

rundll32 dfshim CleanOnlineAppCache

2025-02-10T10:32:00.001+02:00

VirtualBox problem.

If VirtualBox fails to start Virtual OS, try following:

Close VirtualBox
Open cmd.exe as administrator
run following: bcdedit /set hypervisorlaunchtype off

It made my day at least 😀😄😄😄😄

2024-12-03T13:50:00.002+02:00

MySQL 8.0.39 Grant problem.

A user with all privileges wasn't able to update a Procedure, got error below.

ERROR 1227: Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation.

We fixed it by running

GRANT SYSTEM_USER ON *.* TO 'userWithProblem';

Still connected as user 'userWithProblem'

2024-09-15T10:14:00.001+02:00

DELL bios update problem.

Fixed by removing

“Microsoft System Management BIOS Driver”
“Microsoft Windows Management Interface for ACPI” (there will be several)

found in Device Manager -> System Devices

see source Dell Bios problem

2024-03-06T15:13:00.001+02:00

ShiftLeft vs multiply in .Net

Converting 2 bytes to a UINT16

Which is fastest? multiply or shiftLeft

Dim a As Byte = 3

Dim b As Byte = 7

Dim c As UInt16

For i = 0 To 100000

'c = a + b * 256

c = a + (CInt(b) << 8)

Multiply wins, 10 % faster.

NB!

ShiftLeft << isn't calculated first so you need the () around

Shift left a byte, need to convert it to a uINT16 first.

c=1795

if you calc it

c=b<<8 +3 = 56

c=a+ b<<8 = 10

c=cint(b)<<8+3 = 14336

c=a+cint(b)<<8 = 2560

c=a+(cint(b) <<8) =1795

So I will stay away from ShiftLeft/Right !

Filezilla Server versus ClickOnce applications problem.

2024-02-21T14:59:00.006+02:00

Filezilla Server versus ClickOnce applications problem.

Suddenly I wasn't able to deploy .Net applications using ClickOnce.

I got a FileZilla Server as the publisher Folder Locations. One day it stopped working, complaining on Passive Mode didn't work.

I figure out the problem was at the server side.

On Filezilla the minimum allowed TLS version was set to v1.2 ???

I'm not sure if this was the default setting or if VS2017 had done some changes regarding minimum TLS level.

But after changing it to minimum v1.3, ClickOnce deployment start working :)

To find the Minimum TLS level settings in FileZilla:

Open 'Administration Interface for FileZilla'
Click Menu 'Server'
Click 'Configure..'
Select 'FTP and FTP over TLS (FTPS)' under 'Protocol Settings'
On the 'Connection Security' tab, set 'Minimum allowed TLS version' to v1.3
Click OK
We are done, at least I was 😁

Removing ZWSP 'Zero Width Space' using VB.Net

2024-01-18T19:25:00.002+02:00

Sometimes user will copy in a string from a web sites.

It can contain a Zero Width Space character that will not be seen and will make your life a mess.

Pasting the string into Notepad++

and enable show all characters you will see

The ZWSP character is UniCode Char &H200B

Dim CleanStr as string

CleanStr=messyStr.Replace(ChrW(&H200B), "")

This will remove any ZWSP's

MySQL DateTime from .Net

2024-01-18T19:07:00.002+02:00

I learn the hard way that different Windows Region settings will screw up your life.

If user has a DateTime region setting not what you have as a devoloper you have to convert DateTime in your .Net program to send DateTime in MySQL format while doing UPDATE or INSERT INTO.

dim myDate as Date

myDate=now

Sending this to MySQL use following format string

INSERT INTO myTable bla bla

Values ( myDate.ToString("yyyy-MM-dd HH:mm:ss")

2023-09-20T20:03:00.003+02:00

How to remove hiberfile.sys on PC not using Sleep/hibernate.

Open a console as admin

run: powercfg /hibernate off

Done!

2023-09-13T09:37:00.002+02:00

Renew Apache TLS certificate

sudo openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/ssl/private/apache-selfsigned.key -out /etc/ssl/certs/apache-selfsigned.crt

From https://www.digitalocean.com/community/tutorials/how-to-create-a-self-signed-ssl-certificate-for-apache-in-ubuntu-22-04#step-2-creating-the-tls-certificate

LInux fails to start, saved by fsck -f /dev/sda2

2022-02-18T16:53:00.004+02:00

My virtualbox Ubuntu server failed after a update of Virtualbox 😟😳

There was some messages about failed /dev/sda2 and that you should run fsck manual.

I tried this but nothing really happened.

Googled for fsck and found you should run: fsck -f /dev/sda2

It worked and I'm happy again.

Link that saved my day

2021-01-28T17:22:00.002+02:00

Office 365 pain.

.Net development got a hit, my usual code to access Excel stopped working when my job switched over to Office365. It compiles okay by when opening a excel doc your hit with

Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the Query Interface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Clear as mud, to complicate life a bit more, some of my application run Excel okay.

Fix, sort of:

I been compiling the non working apps using CPU x86 to be sure they run on Win 32-bit PCs.

Win 32-bit isn't used anymore so I compiled it with setting 'Any CPU' and now I'm happy again.

local to UTC time or vice versa

2020-01-28T11:46:00.000+02:00

You want to convert a local time to UTC time to be stored in a database running Vb.net

' Your local time
Debug.Print("Time local:" + Now.ToString("yyyy-MM-dd HH:mm:ss"))

Dim currentTime As DateTime = DateTime.UtcNow 'UTC Time
Debug.Print("Time UTC:" + currentTime.ToString("yyyy-MM-dd HH:mm:ss"))

' Convert UTC to local time
Debug.Print("UTC to Local time:" + currentTime.ToLocalTime.ToString("yyyy-MM-dd HH:mm:ss"))

OutLook and GetSharedDefaultFolder problem

2019-09-25T13:37:00.000+02:00

Reading shared calenders like 'TestRig 1', 'TestRig 2', 'TestRig 3' using .GetSharedDefaultFolder() worked as a charm until
'TestRig 11' and 'Test Rig 12' where added 😢.

'TestRig11 and 12 you can find but not TestRig1 anymore, using 'TestRig 1' is almost same as 'TestRig 11' only the last char is new.

The Fix: 'TestRig 1' is a view name, so changing to the real mail address instead testrig1@mytestcenter.com and the problem was solved 😀

The Code:
-----------------------------------------------------------------------------------
Sub ReadCalendarFromOutlook(calName As String)
Dim application As New Microsoft.Office.Interop.Outlook.Application

Dim myNamespace As Outlook.NameSpace
Dim myRecipient As Outlook.Recipient
CalDay1.Scroll2Time(Now)
CalDay1.SetupTimeLine()
CalDay1.ClearAllEvents()
lblCalInfo.Visible = False

If calName = "" Then
lblCalInfo.Visible = True
lblCalInfo.Text = "No Calendar available"
Exit Sub
End If
Try
myNamespace = application.GetNamespace("MAPI")

myRecipient = myNamespace.CreateRecipient(calName)

Catch ex As Exception
MsgBox("It looks like you are missing OutLook on the computer :(")
Exit Sub
End Try

Try
Dim folder As Outlook.Folder = DirectCast(application.Session.GetSharedDefaultFolder(myRecipient, Outlook.OlDefaultFolders.olFolderCalendar), Outlook.Folder)
Dim todayAppointments As New List(Of Outlook.AppointmentItem)()

' ------------- Get Appointment for Date selected --------------------------------
Dim query = From p In folder.Items.Cast(Of Outlook.AppointmentItem)() Where p.Start.[Date] = DateTimePicker1.Value.[Date]

' ------------- Get ReCurrent Appointment for Date selected --------------------------------
Dim q1 As Outlook._AppointmentItem
Dim query2 = From p In folder.Items.Cast(Of Outlook.AppointmentItem)()

For Each q1 In query2

If q1.IsRecurring Then
Dim aRecurrent As Outlook.RecurrencePattern = q1.GetRecurrencePattern
Dim dx As DateTime
' dx = New DateTime(DateTimePicker1.Value.Year, DateTimePicker1.Value.Month, DateTimePicker1.Value.Day, q1.Start.Hour, q1.Start.Minute, 0)
dx = DateTimePicker1.Value.[Date] + q1.Start.[TimeOfDay]
Dim ap As Outlook.AppointmentItem = Nothing
Try
' .GetOccurence() seems a bit strange, it returns ap=Nothing if a Appoinment is found ??? ELSE it returns a ComException
ap = aRecurrent.GetOccurrence(dx)
' ap = nothing, so we found an appointment
CalDay1.AddEvent(DateTimePicker1.Value.[Date] + q1.Start.[TimeOfDay], DateTimePicker1.Value.[Date] + q1.End.[TimeOfDay], q1.Subject + vbCrLf + q1.Location)
Catch ex1 As System.Runtime.InteropServices.COMException
' We end up here if appointment wasn't found for selected day
Debug.Print(ex1.Message)
Catch ex As Exception
Debug.Print(ex.Message)
End Try

Else
If q1.Start.[Date] = DateTimePicker1.Value.[Date] Then
CalDay1.AddEvent(q1.Start, q1.End, q1.Subject + vbCrLf + q1.Location)
End If
End If
q1 = Nothing
Next

Catch ex As Exception
Debug.Print("Error: " + ex.Message)

' NB: If you got error msg "Outlook does not recognize one or more names"
' Then use CalName="TestRig1@testcenter.com instead of "TestRig 1"
' When we added TestRig11 and 12, using "TestRig 1" stopped working.

lblCalInfo.Visible = True
lblCalInfo.Text = "Failed to read Calendar" + vbCrLf + calName
End Try

End Sub

Weird .Net error Collection was modified; enumeration operation may not execute.

2019-08-29T22:39:00.000+02:00

I got this error when closing a form, and it isn't pointing to a certain line of code it just happens.
The code has been running without problem for more than 5 year. But then I had to change from Win7 VS2013 to Win10 VS2017, BAM! I got this error.

System.InvalidOperationException
HResult=0x80131509
Message=Collection was modified; enumeration operation may not execute.
Source=mscorlib
StackTrace:
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at System.Collections.Generic.List`1.Enumerator.MoveNextRare()
at System.Collections.Generic.List`1.Enumerator.MoveNext()
at Microsoft.VisualBasic.PowerPacks.ShapeCollection.Dispose(Boolean disposing)
at Microsoft.VisualBasic.PowerPacks.ShapeContainer.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at System.Windows.Forms.Control.Dispose(Boolean disposing)
at System.Windows.Forms.ContainerControl.Dispose(Boolean disposing)
at MN_Bargraph.MN_BarGraph.Dispose(Boolean disposing) in C:\MN_Bargraph\UserControl1.Designer.vb:line 13

It said something about .Designer.vb line 13
So I comment out the line as shown below

Protected Overrides Sub Dispose(ByVal disposing As Boolean)
Try
If disposing AndAlso components IsNot Nothing Then
components.Dispose()
End If
Finally
'MyBase.Dispose(disposing)
End Try
End Sub

Now no errors, why this works or what the designer.vb code does, don't ask me.

I'm happy and clueless, good enough for me for now 😂

Share folder C$ failes with 'access denied'

2019-01-09T14:23:00.000+02:00

Sometimes you fail to access other computers C: drive using \\computername\c$

Add or update the following on the computer you want have access to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
create or modify 32-bit DWORD: LocalAccountTokenFilterPolicy
set the value to: 1

Info was found here

Driver problems

2018-11-17T14:59:00.005+02:00

You trying to install a bit older driver on Windows 10 and you get following message:

"this operation requires an interactive window station"

Newer Windows 10 releases seems to add some extra protection layer when installing drivers😞

Luckily someone else got the problem and found a solution:

Some poor bastard as me

The Solution: Take OwerShip of c:\Windows\System32\Drivers and \DriverStore folders.

HowTo you find here:
https://www.howtogeek.com/howto/windows-vista/add-take-ownership-to-explorer-right-click-menu-in-vista/