How to REALLY destroy stored data

I have written already about SDelete and bootable DiskWipe, but what if you have to rely on the result?
In that case you have only once option - physical destruction!

First you have to disassemble your hard drive disk and extract each single platter.

As next step use blow torch (blowlamp) till surface of disk will be red, look at the photo.

After that all your data are really demolished.

CAUTION! That is truly very dangerous! Fire hazard! 

bulk convert to u-law or a-law audio format

The telephone system requires often audio prompts in u-law or a-law format.
To convert all your wav files you can execute following command in the directory with wav files,
it will convert file and save it with the same file name and new extension

# for a in *.wav; do sox "$a" -t raw -r 8000 -c 1 -e u-law ${a/.wav/.ulaw} ; done

or 

# for a in *.wav; do sox "$a" -t raw -r 8000 -c 1 -e a-law ${a/.wav/.alaw} ; done

Enjoy!

Connecting to Ubuntu using UltraVNC

first enable Desktop Sharing on Ubuntu 16.04 host

and protect it with password.

Ubuntu is running Vino VNC Server and UltraVNC does not support Vino encryption. You have to execute without restart and sudo(!) the followinf command

$ gsettings set org.gnome.Vino require-encryption false

Enjoy!

PS: I did not test the settings with TightVNC or RealVNC, but expecting also  to be working solution

Aspose.Cells change style of cell

It was possible in previous versions of Aspose Cells to apply changes directly to cell.
Starting from version 7.0 you have to call first GetStyle() method and then call SetStyle(s) method.

You can use simple extension method to mimic old behavior.

public static class AsposeCellsExt
    {
        public static void ChangeStyle(this Cell cell, Action<Style> applyChangesTo)
        {
            Style s = cell.GetStyle();
            applyChangesTo(s);
            cell.SetStyle(s);
        }
    }

and now to fill A1 cell with green background you can execute just single line

cells[0, 0].ChangeStyle(s => { s.ForegroundColor = GREEN; s.Pattern = Aspose.Cells.BackgroundType.Solid; });

Enjoy!

[SOLVED]: mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost'

I would like to execute mysqldump using .mylogin.cnf file and --login-path option to make it more secure as it can be with plain text password. It appears the error
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: NO) when trying connect.
It was really strange because I have never created any ODBC user.


The solution: you have to export MYSQL_TEST_LOGIN_FILE variable and point to correct CNF file, e.g.
SET MYSQL_TEST_LOGIN_FILE=C:\secret\.mylogin.cnf
 - or -
export MYSQL_TEST_LOGIN_FILE=/var/mysql/.mylogin.cnf

Don't forget to restrict access permission to the file!

Enjoy!

OTRS: add new statistics takes too long

Does it take an enternity to create new statistics in OTRS?
Check an option CustomerIDAsMultiSelect in SysConfig and set it to No,
You can't select mutiple customers anymore, try to revert the option back and edit existing report.

Enjoy!

[SOLVED] ERROR 1290 (HY000) The MySQL server is running with the --secure-file-priv

if appears the error
ERROR 1290 (HY000) The MySQL server is running with the --secure-file-priv

you have to check
1.  execute show variables and find secure_file_priv variable value (e.g. c:/uploads/)
2. use full path in SELECT .. INTO OUTFILE  or LOAD DATA statements (e.g. 'c:/uploads/some_file.cvs')
3. grant file priviledge to the user (e.g. GRANT FILE ON *.* TO 'someuser'@'localhost';)


You can always change the path in my.ini file, search for secure_file_priv 


Enjoy!