MySQL to MariaDB

 Here is a good description how to migrate to MariaDb

MySQL 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

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

 

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

<Directory "/usr/share/zabbix">

    Options FollowSymLinks

    AllowOverride None

    Require all granted

    <IfModule mod_php.c>

        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>

<Directory "/usr/share/zabbix/conf">

    Require all denied

</Directory>

<Directory "/usr/share/zabbix/app">

    Require all denied

</Directory>

<Directory "/usr/share/zabbix/include">

    Require all denied

</Directory>

<Directory "/usr/share/zabbix/local">

    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

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.

Next

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 :)

 app.config

To hide tokens passwords etc

In your vb.net project open app.config

Add following lines

  <appSettings file="secret.config">

    <add key="AppName" value="MyApp" />

</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>

    <add key="dbUser" value="DbUserNameHere" />

<add key="dbPwd" value="TopSecret" />

</appSettings>

Now in your code:

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

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

gitIgnore

 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

IIS Backup and Restore

Good link