Upgrade MySQL from 5.5 to 5.7 on CentOS

I have got a task to migrate a system from a CentOS server and another CentOS server. When I imported the MySQL database to the server, I have got the following error: (SQL Error: 1294 SQL State: HY000) - Invalid ON UPDATE clause for 'column_name' field Oh.... DATETIME can use CURRENT_TIMESTAMP on update starting from [...]

By | April 29th, 2016|IT Knowledge Base|0 Comments

Centos: PHP Fatal error: Class ‘SoapClient’ not found in

You may get an error returned from error log (example from CentOS): PHP Fatal error:  Class 'SoapClient' not found in   Create a php file (e.g. info.php) with the following code in your server : <?php phpinfo();?>   Access to the page (e.g. http://yourdomain.com/info.php) and check whether the soap is installed and enabled Or You [...]

By | January 7th, 2016|IT Knowledge Base|0 Comments

CentOS: apr_sockaddr_info_get() failed for XXXXX

You may get the error when restarting apache. # service httpd restart Stopping httpd: [ OK ] Starting httpd: httpd: apr_sockaddr_info_get() failed for XXXXX httpd: Could not reliably determine the server's fully qualified domain name, using for ServerName It is because of the apache variable ServerName has not been set. In CentOS, you can [...]

By | December 5th, 2015|IT Knowledge Base|0 Comments