Author: David Raleche

Twitter : https://twitter.com/DavidRaleche
Newsletter : Subscribe here
Store : https://david.raleche.com/shop

Categories
MySql

How to fix – DBeaver Native client is not specified for connection ?

DBeaver Native client not specified for connection
DBeaver Native client not specified for connection

Native client is not specified for connection

Download Mysql or Postgres or (appropriate database ) Server

Do the step of DBEAVER client configuration

Find bib files for mysql – open terminal and execute followin command

which mysql
--> /usr/local/bin/mysql

if using a mac to allocate mysql server bin files location

command + shift + G

Paste the path in there such as 

/usr/local/mysql-5.7.28-macos10.14-x86_64/bin/

Voila you can enjoy most amazing feature of DBeaver !

Categories
BEST PHP CODE EasyPhp PHP

What to do – PHP session slow ?

Solution

Increase memory size

memory_limit = 2048M
Categories
PHP

PHP Xcache to be light fast

yum install php xcache – light fast application

 yum install php54-xcache.x86_64
Categories
AWS

AWS – How to Unmount Volumes ?

Make sure the volume isn’t in use.

sudo lsof +f -- /mnt/use_your_mount_point

Kill processes pid

kill -9 pidNumber

umount

sudo umount --verbose /mnt/use_your_mount_point
Categories
AWS

How to mount duplicate uuid aws volume ?

Error

[128456.266831] XFS (xvdg): Filesystem has duplicate UUID 483f88bd-990a-404d-8408-71218fa83324 - can't mount

Solution

mount -o nouuid /dev/sdb7 /yourfolder
Categories
MySql

Mysql Open remote access

Connect

mysql -u root -p
USE mysql;
SELECT user,host FROM user;

grant privileges

from specific IP

GRANT ALL PRIVILEGES ON *.* TO [email protected]_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;

From everywhere

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

Flush privileges

FLUSH PRIVILEGES;
Categories
Technical

How to collapse swagger tag categories by default ?

Add docExpansion:'true', in the file swagger/index.php

 <script>
    window.onload = function() {
      // Begin Swagger UI call region
      const ui = SwaggerUIBundle({
        //url: "http://davidr3.sbx.4over.com/swagger.json",
        url: "../swagger.json",
        dom_id: '#swagger-ui',
        docExpansion:'true',
        deepLinking: true,
        presets: [
          SwaggerUIBundle.presets.apis,
          SwaggerUIStandalonePreset
        ],
        plugins: [
          SwaggerUIBundle.plugins.DownloadUrl
        ],
        layout: "StandaloneLayout"
      })
      // End Swagger UI call region

      window.ui = ui
    }
  </script>

Categories
News

Losangeles.raleche.com New website listing

losangeles.raleche.com – New website directory about Los Angeles! Stay tuned new directories to be added over time

Go Visit losangeles.raleche.com Now !

Categories
Apache Hacker Web Server

Whitelist EC2 server to send email

Below find url that will allow your ec2 servers to send emails 

https://console.aws.amazon.com/support/contacts?#/rdns-limits
Categories
Apache Hacker Security

Logwatch to monitor your server daily

Install logwatch

yum install logwatch

send logwatch email

logwatch --detail Low --mailto [email protected] --service http --range today

Logwatch configuration file

vim /usr/share/logwatch/default.conf/logwatch.conf