Ubuntu with client public key authentication

This guide assumes that you are trying to connect to a corporate network. First of all you need to define what IPrange the OpenVPN server will be running on. Network Option 1.) There are a few options, such as the OpenVPN sitting exclusively on the internal network, with the port and protocol that the server is used on being forwarded to this via the router and/or firewall. Network Option 2.) The OpenVPN server could sit on both th........

nfs tuning maximum amount of connections

By default at least on Centos 7 nfs only allows 8 connections and starts 8 nfsd daemons. To fix this edit this file:/etc/sysconfig/nfs Edit the line "RPCNFSDCOUNT" (uncomment it so it looks like this: RPCNFSDCOUNT=30 In the example above we are setting 30 nfsd daemons to run (or in other words 30 connections are possible this way).........

MySQL change for Antelope format to Barracuda error solution

Your database uses Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please switch to the Barracuda file format. See the documentation MySQL full unicode support for details. In /etc/my.cnf under [mysqld] 180827 21:43:14 InnoDB: 5.5.59 started; log sequence number 1589339 180827 21:43:14 [ERROR] /usr/libexec/mysqld: unknown variable 'db_file_format=Ba........

ERROR 2006 (HY000) at line 567: MySQL server has gone away

mysqldump or mysql query of a larger file/table ERROR 2006 (HY000) at line 567: MySQL server has gone away Add this to /etc/my.cnf max_allowed_packet=64M service mysqld restart........

cPanel error Access denied for user 'root'@'localhost' when adding remote MySQL IP address solution

Error while connecting to MYSQL: (XID 4ea7s9) Access denied for user 'root'@'localhost' (using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 181 Solution This error occurs because the /root/.my.cnf has the wrong/outdated password for MySQL root user. Simply edit /root/.my.cnf with the correct user. This normally happens if you update outside of cPanel.........

Lost connection to MySQL server during query [2013]

This happened while trying to delete several thousand users from phpBB and basically corrupted the innoDB tables. InnoDB: Page lsn 3 881164362, low 4 bytes of lsn at page end 881164362 InnoDB: Page number (if stored to page already) 86920, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be an index page where index id is 700 InnoDB: (index "tid_post_time" of table "phpBBdb2005"."phpbb3_p........

CPanel mysql root password location how to find

It is located in /root/.my.cnf This is truly a horrible idea and a security flaw and on top of that MySQL port 3306 is wide open by default with CPanel.........

MySQL my.cnf Server How To Secure/Bind to Localhost and Prevent Outside Connections Solutions

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 bind-address=127.0.0.1 The key is "bind-address", set that to 127.0.0.1 and no one from outside the server can connect.........

mysql enable slow query logging/Query Cache Solution - find/track cause of slow mysqld/high IO/CPU usage

If you have a webserver and find you have high IO/lagginess MySQL is one of the first things to check. It turns out MySQL was my problem and it was creating a high load on my server, especially for IO. How to Enable MySQL Slow Query Logging To Find Slow Performance/Queries vi /etc/my.cnf Add this anywhere under [mysqld] #slow queries log-slow-queries = /var/log/mysql/mysqlslowqueries.log long_query_time = 1........

MySQL NEVER delete ib_logfile0 or ibdata1 or you'll lose data

don't delete /var/lib/mysql/ib_logfile0 or ibdata1 or mysql won't restart I didn't realize they were internal and not part of replication like the relay files! /usr/libexec/mysqld: ready for connections. Version: '4.1.22-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 110127 16:31:00 [Note] /usr/libexec/mysqld: Normal shutdown 110127 16:31:00 InnoDB: Starting shutdown...........