Linux & Windows Tips, Tutorials, , Ideas

Troubleshooting MySQL Database Connection Issues

Databases are the driving element of a website. Databases tell a website how to function on a dynamic level, meaning that the information can be smart enough to update without the user directly making those changes if need be. Without a proper connection to an SQL database, a website cannot function and you will likely be met with one of the following warnings:

Error establishing a database connection

OR

Read more about Troubleshooting MySQL Database Connection Issues

Share Button

Nginx: 413 Request Entity Too Large Error and Solution

I‘m running nginx as a frond end to php based Apache+mod_fastcgi server. My app lets user upload images upto 2MB in size. When users trying to upload 1.5MB+ size image file using nginx reverse proxy, they are getting the following error on screen:   Nginx 413 Request Entity Too Large How do I fix thisRead more about Nginx: 413 Request Entity Too Large Error and Solution[…]

Share Button

Troubleshooting the “Out of socket memory” error

Troubleshooting the “Out of socket memory” error

If the following error message occasionally gets written to the /var/log/messages file:

[[email protected] ~]# tail -f /var/log/messages
Jan 22 15:05:39 ztm-n08 kernel: [12624150.315458] Out of socket memory

It usually means one of two things:

  1. The server is running out of TCP memory
  2. There are too many orphaned sockets on the system

To see how much memory the kernel is configured to dedicate to TCP run:

[[email protected] ~]# cat /proc/sys/net/ipv4/tcp_mem
3480768 4641024 6961536
Share Button

MySQL – myisamchk: error: myisam_sort_buffer_size is too small

f you’re trying to repair large MyISAM tables in MySQL, you can run into the following restriction, because of the limited size of the default Sort Buffer. [email protected] # myisamchk -r table.MYI – recovering (with sort) MyISAM-table ‘table.MYI’ Data records: 335045 – Fixing index 1 Found block that points outside data file at 1509428340 FoundRead more about MySQL – myisamchk: error: myisam_sort_buffer_size is too small[…]

Share Button

Top 20 a problem of building Apache – Cpanel Server

Hi guys 🙂

Php compilation on server means the building and installation of PHP from its source. You may get a lot of error while compiling the PHP,
here some common PHP compilation errors and their fixes.

Read more about Top 20 a problem of building Apache – Cpanel Server

Share Button