Dev {Tricks}

You are here: Home / Archives for Server and Hosting / Web Control Panel / DirectAdmin

by

Error connecting to MySQL: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

  • Error connecting to MySQL: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

Try restarting server first.

check for mysql Error

mysql -u root

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

Follow here

https://help.directadmin.com/item.php?id=332

To find all socket files on your system run:

sudo find / -type s

Add or edit mysql socket /etc/my.cnf. In my case, it is

socket=/var/lib/mysql/mysql.sock

Where is mysql

whereis mysql.sock

 

 

 

 

by

Create SSH Keys with PuTTY on Windows

Download and install PuTTY on your computer.

After installing putty, run PuTTYgen from start menu

You may customize Parameter at the bottom. But generally default values are appropriate.

Now click on Generate and move the mouse on blank area to complete key generation.

Save private key in save place. Noted that you may or may not use Key passphrase.

Close PuTTYgen tools.

Connect to server with Private Key

Open PuTTY

Put hostname or IP in session.

Go to Connection > SSH > Auth and browse private key.

Now you will be prompted Login as

 

by

Email Protocols – POP3, IMAP and SMTP and mail settings

  • POP3: Post Office Protocol version 3 (POP3)
  • IMAP: Internet Message Access Protocol (IMAP)
  • SMTP: Simple Mail Transfer Protocol (SMTP)

Incoming mail server (POP3 or IMAP):

mail.domain.com

Server hostname can also be used as mail server. For example, server.bdhostit.com

IMAP Settings:

  • IMAP port: 143 (IMAP non-encrypted port)
  • IMAP port: 993 (IMAP encrypted port support SSL)

Server requires encrypted connection (SSL). (Apple Mail users should tick “Use SSL”)

POP3 Settings:

  • POP3 port: 110 (POP3 non-encrypted port)
  • POP3 port: 995 (POP3 encrypted port support SSL)

Server requires encrypted connection (SSL). (Apple Mail users should tick “Use SSL”)

Username: EMAIL ADDRESS
Password: EMAIL PASSWORD

Outgoing mail server (SMTP):

mail.domain.com

Server hostname can also be used as mail server. For example, server.bdhostit.com

SMTP Settings

  • SMTP Port = 25 (SMTP non-encrypted port)
  • SMTP Port = 465 (SMTP encrypted port support SSL)
  • SMTP Port = 587 (SMTP encrypted port support SSL)

Username: EMAIL ADDRESS
Password: EMAIL PASSWORD

 

 

 

 

 

by Leave a Comment

AddHandler, AddType, SetHandler in htaccess | Change PHP version for directory or folder

cPanel-generated handler

# php -- BEGIN cPanel-generated handler, do not edit
# Set the “ea-php72” package as the default “PHP” programming language.
AddHandler application/x-httpd-ea-php72 .php .php7 .phtml
# php -- END cPanel-generated handler, do not edit

 

<IfModule mime_module>
AddHandler application/x-httpd-ea-php56___lsphp .php .php5 .phtml
</IfModule>

<IfModule mime_module>
AddType application/x-httpd-ea-php56___lsphp .php .php7 .phtml .htm .html
</IfModule>

<FilesMatch “\.(php4|php5|php3|php2|php|phtml)$”>
SetHandler application/x-lsphp56
</FilesMatch>

<IfModule mod_rewrite.c>
AddHandler application/x-httpd-php56 .php
</IfModule>

AddHandler application/x-httpd-php56 .php .php5 .php4 .php3

<FilesMatch ".(?:html|php)$">
SetHandler application/x-lsphp56
</FilesMatch>

 

 

by Leave a Comment

error=1&text=Your IP is blacklisted

error=1&text=Your IP is blacklisted
http://help.directadmin.com/item.php?id=306

To remove yourself from the blacklist, edit:

vi /usr/local/directadmin/data/admin/ip_blacklist

You may comment your IP (#) Or you may delete the IP from the list.

If you want you can whitelist your IP. To do this, open whitelist file

vi /usr/local/directadmin/data/admin/ip_whitelist

Add IPs one per line and save it. The IPs will never be blacklisted.

:wq

You can also update admin setting for security at Admin Level -> Admin Settings -> Security Settings