Dev {Tricks}

You are here: Home / Home

by

How to create new Administrator user in OJS?

Find what the user group ID of Administrator group is by running:

SELECT user_group_id FROM user_groups WHERE context_id=0 AND role_id=1;

It’ll probably give a 1 back as a result. Then, you can grant that to user:

INSERT INTO user_user_groups (user_id, user_group_id) VALUES (278, 1);

where 278 is the user ID, and 1 is the user_group_id.

 

Reset admin password

UPDATE users SET password=SHA1(CONCAT(username,'w6Jdib4nNCZ')) WHERE username='admin';

 

 

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