Analyze suspicious files and URLs to detect types of malware, automatically share them with the security community.

• https://www.virustotal.com/gui/

When we talk about “drives” labeled C:, D:, and so forth, we’re actually talking about partitions, sections of the physical drive. Every hard drive in use has at least one partition. You can shrink that partition and create new ones out of the extra space. You’ll find this useful if you want to install more than one operating system, or if you want to truly separate programs and data.

But first, you need to take some precautions.

Read more...

Cookies are usually delectable delights, but web cookies can sometimes be less than delightful. These little files hide in your computer so that your browser and websites can track your browsing sessions and save certain useful information, such as account names and passwords, for later retrieval. Although cookies may seem harmless overall, they can threaten your privacy if an attacker tries to use them maliciously.

Because of that threat, most modern browsers make cookie storage easy to understand and control. They also make it simple to remove individual website cookies, or even to delete cookies from your computer entirely. Here’s how you can perform the latter task in some of the most popular browsers.

Read more...

The symptoms are as follows: you select a VPN connection in the system tray and click “Connect”. The “connecting” status goes on indefinitely without ever establishing a successful connection. The connection attempt is silently closed, and after you reopen the system tray you’re again offered the “Connect” option.

How to make it works:

• Click on Windows icon

.

• Type VPN then click on VPN Settings
  

• Then select the VPN and click Connect
  

• Open group policy object editor. (See How to Open group policy object editor )
• Expand Computer Configuration node
• Expand Administrative templates node
• Expand Network
• Select offline files. Now in the right side pane you can see different policy settings related to offline files usage.
• Double click on the first setting i.e ‘Allow or disallow use of the offline files feature’.
• Select the check button ‘enabled’
• Click on ‘Apply’ and then click on ‘OK’
• Close Group policy object editor. (Note that client machines need a reboot to make the changes effective)

read more...

For Windows 10, Windows 8.1, Windows 8, Windows Server 2012 R2 or Windows Server 2012

To resolve this problem, use the inbox Deployment Image Servicing and Management (DISM) tool. Then, install the Windows update or service pack again.

%WINDIR%\WindowsUpdate.log

change the c:\pstools\psexec with the folder where PSTools is

c:\pstools\psexec \\remote_machine_name -u username -p password cmd

netsh advfirewall firewall set rule group=”remote desktop” new enable=Yes

change the c:\pstools\psexec with the folder where PSTools is

c:\pstools\psexec \\remote_machine_name -u username -p password cmd

net share XXX=C:\Users\username\AppData\Local

the share will be c:\XXX and point to ...Local

net share XXX /DELETE (space between XXX and /)

Run as Admin in CMD Prompt the hereunder line.
Under the <drive> put the path where the sxs folder is.
The sxs folder is extracted from Windows package and Source folder
Dism /online /enable-feature /featurename:NetFx3 /All /Source:<drive>:\path to folder\sxs /LimitAccess

Link

Open CMD as Admin and type the 2 commands.
The 84.0.522.63 may be different on each pc, but just go to the last version found in the Application folder.

C:\Program Files (x86)\Microsoft\Edge\Application\84.0.522.63\Installer
setup.exe --uninstall --system-level --verbose-logging --force-uninstall

Search for "Internet Explorer Compatibility" in the Edge settings panel. Then setting the "Open Sites in Edge" setting to "Never."

Link

Disable the VMD controller in the BIOS

Clear the EDGE browsing history (cache...) then reset the browser.

Run as Admin in CMD Prompt the hereunder line.
Under the <drive> put the path where the sxs folder is.
The sxs folder is extracted from Windows package and Source folder
Dism /online /enable-feature /featurename:NetFx3 /All /Source:<drive>:\path to folder\sxs /LimitAccess

Link

forfiles /P "c:\data\PRODDB\dir" /M *.DMP /D +0 /C "cmd /c copy @path d:\test"

Link

Microsoft Safety Scanner is a scan tool designed to find and remove malware from Windows computers. Simply download it and run a scan to find malware and try to reverse changes made by identified threats.

• Download Microsoft Safety Scanner (32-bit)

• Download Microsoft Safety Scanner (64-bit)

Run as Admin in CMD Prompt the hereunder line.
Under the <drive> put the path where the sxs folder is.
The sxs folder is extracted from Windows package and Source folder
Dism /online /enable-feature /featurename:NetFx3 /All /Source:<drive>:\path to folder\sxs /LimitAccess

Link

forfiles /P "c:\data\PRODDB\dir" /M *.DMP /D +0 /C "cmd /c copy @path d:\test"

Link

• http://www.eclipse.org/birt/

WinSCP is a popular SFTP client and FTP client for Microsoft Windows! Copy file between a local computer and remote servers using FTP, FTPS, SCP, SFTP, WebDAV or S3 file transfer protocols.

• https://winscp.net/eng/index.php

forfiles /P "c:\data\PRODDB\dir" /M *.DMP /D +0 /C "cmd /c copy @path d:\test"

Link

Try these fixes:
The methods below have helped other users solve the problem. You may not have to try them all; just work your way down the list until you find the one that works for you.

• Check the setting of System Event Notification Service on your computer
• Reset your Winsock Catalog
• Update your video card driver
• Uninstall the KB2952664 update

Read more...

MySQL REPLACE() replaces all the occurrences of a substring within a string.

_______________________________________

SELECT * FROM schema.table;
UPDATE schema.table set column= replace(column, 'aaa', 'AAA') WHERE column='aaa';

_______________________________________

schema = is the chema db (e.g. company)

table = is the name of the table (e.g. users)

column = is the column name of the table (e.g. description)

aaa = is the string which will be replaced in the column

AAA = is the string who replace the "aaa"

reference: https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

1a) Connect to mysql (via localhost)

mysql -uroot -p

2. Create user

   CREATE USER 'user'@'%' IDENTIFIED BY 'password';

3. Grant permissions

   GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;

4. Flush privileges

   FLUSH PRIVILEGES;

Although /etc/mysql/mysql.conf.d has these lines: comment it

#bind-address = 127.0.0.1

Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server - Stack Overflow

Sometime, just need to updrade Workbench if you use it to access MYSQL.

mysqladmin -uroot -p flush-hosts

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;

mysql -u root -p

Step 1

Go to C:\Users\%USERPROFILE%\AppData\Roaming\MySQL\Workbench\ssh and empty known_hosts file

Step 2

In Workbench, go to Edit - Preferences - SSH and under the field “Path to SSH known hosts file" select the file from the above path

C:\Users\%USERPROFILE%\AppData\Roaming\MySQL\Workbench\ssh

Use this command to fix it

ALTER TABLE zl_report_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Link

or

cp -r path/dirname to/path

rm -r path/dirname

sudo do-release-upgrade

sudo lsblk -o NAME,FSTYPE,SIZE,MOUNTPOINT,LABEL

df -h

https://askubuntu.com/questions/182446/how-do-i-view-all-available-hdds-partitions

sudo chown -R www-data:www-datagrp /var/www/html

sudo service cron start

sudo service cron stop

sudo service cron restart

sudo passwd username

userdel username

You need to edit /etc/ssh/sshd_config, and comment out the following line:

PermitRootLogin without-password
StrictModes yes

Just below it, add the following line:

PermitRootLogin yes
PasswordAuthentication yes

Then restart SSH:

service ssh reload

https://askubuntu.com/questions/469143/how-to-enable-ssh-root-access-on-ubuntu-14-04

sudo -i
passwd

or

sudo passwd

Try with this command:

sudo a2enmod cgi

sudo lshw -C network

https://www.digicert.com/kb/csr-ssl-installation/ubuntu-server-with-apache2-openssl.htm

sudo apt-get install software-properties-common
sudo add-apt-repository ppa:ondrej/php

or

sudo add-apt-repository ppa:tomvlk/php-archive

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install -y php7.3

then

sudo a2dismod php7.0
sudo a2enmod php7.3
php -v

chown -h username:groupname foldername

root@linux:~$ sudo vi /etc/netplan/00-installer-config.yaml
or
root@linux:~$ sudo nano /etc/netplan/00-installer-config.yaml

network:
ethernets:
enp0s3:
addresses: [192.168.1.10/24]
gateway4: 192.168.1.1
nameservers:
addresses: [8.8.8.8, 8.8.8.0]
version: 2

sudo apt update
sudo apt upgrade

sudo apt install apache2

//enable Apache2 service

sudo systemctl enable apache2.service

sudo ufw allow 80/tcp
sudo ufw allow 443/tcp

sudo ufw status

sudo chown www-data:www-data /var/www/html/ -R

sudo apt install php7.4 libapache2-mod-php7.4 php7.4-mysql php-common php7.4-cli php7.4-common php7.4-json php7.4-opcache php7.4-readline

sudo apt install mysql-server

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-20-04

sudo apt update
sudo apt upgrade

sudo apt install apache2

sudo ufw app list

Available applications:
 Apache
 Apache Full
 Apache Secure
 OpenSSH

sudo ufw status

Status: active
To Action From
-- ------ ----
OpenSSH ALLOW Anywhere 
Apache ALLOW Anywhere 
OpenSSH (v6) ALLOW Anywhere (v6) 
Apache (v6) ALLOW Anywhere (v6)

sudo apt install mysql-server

sudo apt install php libapache2-mod-php php-mysql

sudo chown -R $USER:$USER /var/www/your_domain
sudo nano /etc/apache2/sites-available/your_domain.conf

<VirtualHost *:80>
 ServerName your_domain
 ServerAlias www.your_domain
 ServerAdmin webmaster@localhost
 DocumentRoot /var/www/your_domain
 ErrorLog ${APACHE_LOG_DIR}/error.log
 CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

sudo chown www-data:www-data /var/www/html/ -R

network:
  ethernets:
    eth0:
      addresses: [192.168.1.100/24]
      gateway4: 192.168.1.1
      nameservers:
        addresses: [8.8.8.8, 8.8.8.0]
  version: 2

root@linux:~# route -n

sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl

or

sudo apt install phpmyadmin

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-20-04

$ sudo chown -h mj:mj test1
$ ls -l test*
-rw-r--r-- 1 mj mj 0 Jul 27 08:47 test
lrwxrwxrwx 1 mj mj 4 Jul 27 08:47 test1 -> test

Read more...

sudo umount /folder/

sudo mount -t cifs -o username=xxx //server/share/ /mnt/folder/share

sudo adduser www-data www-data

in config - database = change 'strict' to 'false'

https://github.com/Laravel-Backpack/CRUD/issues/218

close the apostrophe after Name

e.g. 'Employee Name', ['class' =>

create column in DB table <deleted_at> and activate SoftDelete in Model or comment/delete withTrashed in App Name

run php artisan key:generate (APP_KEY = ....) in .env file is empty (doesn't have key assigned)

change PHP version from an older one to newer.

Change App\Providers\EventServiceProvider:

The DATE should have hour, minute, second (the same format as in Controller or Provider file)

run php artisan make:auth

add to the conf.app (the form classes found on the internet) and run the composer update

composer require "laravelcollective/html"

https://stackoverflow.com/questions/28753767/laravel-5-class-form-not-found

add to the Controller the file Settings

no route is created

Change in StorexxxRequest return "false" to "true" on authorize function

check in the index file the name of the value (name="APPLICATION_ID")

go to vendor/laravel/framework/src/Illuminate/Foundation/Auth/AuthenticatesUsers.php and change on public function username() the email with the value from login page form (ex: username)

add these lines in apache2\sites-enable\default.conf (or what is the defaul)

<Directory /var/www/html/framework/public/>

Options Indexes FollowSymLinks

AllowOverride

All Require all granted

</Directory>

https://laravel.io/forum/09-15-2015-removing-indexphp-from-url-laravel-5116

go to directory "laravel/bootstrap/cache" and delete config.php file.

add in index (blade) under @section('javascript') section this line: window._token = '{{ csrf_token() }}'; before window.route_mass_crud_entries_destroy = '{{ route('xxx.mass_destroy') }}';

https://stackoverflow.com/questions/55178647/the-post-method-is-not-supported-for-this-route-supported-methods-get-head-l

sudo apt-get install zip unzip php-zip then run this sudo phpenmod zip and then sudo service apache2 restart

https://stackoverflow.com/questions/41274829/php-error-the-zip-extension-and-unzip-command-are-both-missing-skipping

in StoreXXXRequest - public function authorize() - make it true

delete config/excel.php and re-publish it.

run php artisan vendor:publish --provider=Maatwebsite\Excel\ExcelServiceProvider

https://stackoverflow.com/questions/31760829/composer-update-error-with-laravel-5-phpexcel-shared-font-not-found

On Windows 10; Goto C:\ProgramData\ComposerSetup\bin and Edit: composer.bat - php -d memory_limit=-1 "%~dp0composer.phar" %*

https://stackoverflow.com/questions/49212475/composer-require-runs-out-of-memory-php-fatal-error-allowed-memory-size-of-161

install https://github.com/laravel/helpers

add the following to your App\Providers\RouteServiceProvider.php - public const HOME = '/home';

Run this

composer require laravelcollective/html

In Laravel 5+
{{ \Illuminate\Support\Str::limit($description, 50, '...') }}
or
{{ \Illuminate\Support\Str::limit($description, 50) }}

$start=Carbon::parse($a->date);
$end=Carbon::parse($c->dt);
$days=$start->diffInDays($end);

chown -R www-data:www-data /var/www/html/laravel

sudo nano /etc/apache2/apache2.conf

Find the following code inside the editor:

<Directory /var/www/> 
 Options Indexes FollowSymLinks
 AllowOverride None
 Require all granted
</Directory> 

Change to:

<Directory /var/www/> 
 Options Indexes FollowSymLinks
 AllowOverride All
 Require all granted
</Directory

apache - laravel the requested url was not found on this server - Stack Overflow

sudo nano /etc/apache2/sites-available/000-default.conf

<Directory /var/www/html/public/>
 Options Indexes FollowSymLinks
 AllowOverride All
 Require all granted
</Directory>

sudo a2enmod rewrite

apache - laravel the requested url was not found on this server - Stack Overflow

Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 8.1.0".

run this command and see what is missing

composer check-platform-reqs

if is missing then run sudo apt-get install php-xml

xml is an example but can be replace by other missing dependencie

Read more...

Mail::send($view, $data, function($message) use ($email, $name) {
 $m->to($email, $name);
 $m->from('youremail@example.com', 'Your Name'); 
 $m->subject('Hi there');
})

Read more...

\DB::statement("SET SQL_MODE=''");//this is the trick use it just before your query

or

In config\database.php --> "mysql" array

Set 'strict' => false to disable all.

Link

Method 1: Start Outlook in safe mode following steps mentioned below and verify whether issue re-occurs.

* Hold Windows key + R.
* Copy and paste, or type the following command in the Open box, and then press Enter
Outlook /safe
Note: There is a space between Outlook and '/'.

If Outlook works as expected in safe mode, disable the add-ins by following steps mentioned below and check if it works as expected.

a) Click on File menu, click Options, Add-ins,Go button besides Manage: Com-in Add.
b) Check if there are add-ins listed, clear the checkbox.
c) Close the Office program and restart it.
d) Enable each add-in one at a time, restart the Outlook, and repeat the above procedure. If the issue reappears again, it will help you to determine which add-in is causing this issue.

Outlook 2016 Hangs on "Starting ..." - Microsoft Community

Stop Cron.sh and Daemon.pl

• cd /opt/otrs/bin
  sudo -c "./Cron.sh stop" -s /bin/bash otrs
  sudo -c "./otrs.Daemon stop" -s /bin/bash otrs

Then edit the module

CODE: SELECT ALL

sudo nano /opt/otrs/Kernel/System/Console/Command/Maint/Email/MailQueue.pm

Searched for the string Message sending already in progress! Skipping and just before the "if (%PID)... "line preceding it and add the code to force delete the PID (Process ID).

...
my %PID = $PIDObject->PIDGet(
 Name => 'MaintMailQueueSending',
 );
 ## This is new...
 my $ForceDeletePIDOnce = $PIDObject->PIDDelete(
 Name => 'MaintMailQueueSending',
 Force => 1,
 );
 # ... up to here
 if (%PID) {
 die "Message sending already in progress! Skipping...\n";
 }
 ...

su -c "./otrs.Console.pl Maint::Email::MailQueue --send --verbose" -s /bin/bash otrs

shell>cd /opt/otrs/

su -c "bin/otrs.Daemon.pl stop" -s /bin/bash otrs

su -c "bin/otrs.Daemon.pl start" -s /bin/bash otrs

/opt/otrs/bin/Cron.sh stop

/opt/otrs/bin/Cron.sh start

shell> cd /opt/otrs/

shell> su -c "bin/otrs.Console.pl Maint::Email::MailQueue --list" -s /bin/bash otrs

shell> su -c "bin/otrs.Console.pl Maint::Email::MailQueue --send" -s /bin/bash otrs

Comment the line RewriteEngine On in 000-default.conf

<VirtualHost *:80>
# The ServerName directive sets the request scheme, hostname and port that
# the server uses to identify itself. This is used when creating
# redirection URLs. In the context of virtual hosts, the ServerName
# specifies what hostname must appear in the request's Host: header to
# match this virtual host. For the default virtual host (this file) this
# value is not decisive as it is used as a last resort host regardless.
# However, you must set it for any further virtual host explicitly.
#ServerName www.example.com

ServerAdmin webmaster@localhost
DocumentRoot /var/www/html

# Available loglevels: trace8, ..., trace1, debug, info, notice, warn,
# error, crit, alert, emerg.
# It is also possible to configure the loglevel for particular
# modules, e.g.
#LogLevel info ssl:warn

ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined

# For most configuration files from conf-available/, which are
# enabled or disabled at a global level, it is possible to
# include a line for only one particular virtual host. For example the
# following line enables the CGI configuration for this host only
# after it has been globally disabled with "a2disconf".
#Include conf-available/serve-cgi-bin.conf

#RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [NE,R]

</VirtualHost>

# vim: syntax=apache ts=4 sw=4 sts=4 sr noet