Wrong certificate error when I open any domain via HTTPS.
Look into /etc/httpd/conf.d/ssl.conf for the line like:
VirtualHost _default_:443
If it exists you have to delete/comment this default SSL virtual host starting from the
“VirtualHost _default_:443″ line and ending with “/VirtualHost”.
Then stop and start (not restart!) Apache server.
/etc/init.d/httpd stop && /etc/init.d/httpd start
Reference : http://parallels.com
Tags: certificate, error, https, Wrong
Flushing DNS Cache on your system.
When your computer visits a website for the first time, it stores the website’s DNS information in a local cache.
The instructions unique to particular operating systems are below.
From the command line on a windows operating system type:
From a Linux operating system.
Nscd is a daemon that provides a cache for the most common name service requests
From MAC on the terminal window
Directory Service (DNS) cache - Gather information, statistics, initiate queries, flush the cache. dscacheutil replaces most of the functionality of thelookupd tool provided prior to OS X Leopard.
Tags: Cache, DNS, Flushing, System
How to Disable IPv6 in Apache Server
If there is no reason to run Apache with IPv6 then disabling it is wasy. We need to make quick changes to the Listen directive.
By default, Apache will listen on all IPs, both IPv6 and IPv4. (Assuming your system has IPv6 support). This is controlled by the Listen directive:
Turn off IPv6 in Apache
To turn off IPv6 in Apache, just change the Listen directive to:
This will limit Apache to listening only to IPv4 connections. We can repeat this for port 443 if you want to stop Apache from listening for HTTPS on IPv6.
Tags: Apache, Disable, IPv6, server
Finding help content for MySQL databases administration.
Run ‘help contents’ for a list of all accessible topics
mysql>
help contents
You asked for help about help category: “Contents” For more information, type ‘help [item]‘, where [item] is one of the following categories:
Account Management
Administration
Compound Statements
Data Definition
Data Manipulation
Data Types
Functions
Functions and Modifiers for Use with GROUP BY
Geographic Features
Language Structure
Table Maintenance
Transactions
User-Defined Functions
Utility
To go to the individual catefories run the following example command.
mysql>
help Account Management
You asked for help about help category: “Account Management” For more information, type ‘help [item]‘, where [item] is one of the following topics:
CREATE USER
DROP USER
GRANT
RENAME USER
REVOKE
SET PASSWORD
Tags: administration, content, databases, help, mySQL
Creating and editing users in MySQL from shell prompt.
First we need to login into MySQL server as root.
Will be prompted for your MySQL root password (note this is not the same as the server root password).
mysql> create user ‘buddy@localhost’ identified by ‘new-password’;
Query OK, 0 rows affected (0.12 sec)
Next we need to flush the privileges which reloads the ‘user’ table in MySQL - do this each time you add or edit users.
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
To give the user buddy select permission on all the databases, this allows the user to read, but not edit and delete.
mysql> grant select on *.* to ‘buddy’@'localhost’;
Query OK, 0 rows affected (0.00 sec)
The GRANT statement enables system administrators to create MySQL user accounts and to grant rights to accounts. To use GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are granting. The REVOKE statement is related and enables administrators to remove account privileges.
Tags: Creating, editing, mySQL, prompt, shell, users
