365 Hosting support | Server Management Provider

365hostingsupport ultimate source of Server Security, cPanel server management and monitoring. Since 2012 we are offering top class technical support services at lowest prices. We offer 100% Satisfaction with 7 Days Money Back Guarantee.

365 Hosting support |  Server Management Provider - 365hostingsupport ultimate source of Server Security, cPanel server management and monitoring. Since 2012 we are offering top class technical support services at lowest prices. We offer 100% Satisfaction with 7 Days Money Back Guarantee.

Disable strict mode on MySQL / MariaDB

Disable strict mode on mysql / MariaDB

How do I disable MySQL strict mode on the server?

MySQL strict mode

MySQL strict mode

Error : 

 

“My SQL Error 1048 column description cannot be null”
“mysql error : Incorrect integer value “

These error normally comes when you trying to get some transaction on the database server. This can be fix in multiple ways in some case you will need to have root/admin level of access on database or  phpmyadmin access. Below are more detail steps to fix it in mysql.

Open the “/etc/my.ini” file on database server and look for something like…
# Set the SQL mode to strict
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

Replace with:

sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

You may able to do it in another method by login into the phpMyAdmin, if you have cpanel you can login into the cpanel > Database section you will find option “phpMyAdmin”. You may be able to run an SQL query within your phpMyAdmin as shown below.

SET @@global.sql_mode= ”;

 

How do I disable Strict mode on MariaDB database server?

 

This example shows how to get a readable list of enabled SQL_MODE flags:

SELECT REPLACE(@@SQL_MODE, ',', '\n');
+-------------------------------------------------------------------------+
| REPLACE(@@SQL_MODE, ',', '\n')                                          |
+-------------------------------------------------------------------------+
| STRICT_TRANS_TABLES
NO_ZERO_IN_DATE
NO_ZERO_DATE
NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------+

Adding a new flag:

SET @@SQL_MODE = CONCAT(@@SQL_MODE, ',NO_ENGINE_SUBSTITUTION');

If the specified flag is already ON, the above example has no effect but does not produce an error.

How to unset a flag:

SET @@SQL_MODE = REPLACE(@@SQL_MODE, 'NO_ENGINE_SUBSTITUTION', '');

How to check if a flag is set:

SELECT @@SQL_MODE LIKE '%NO_ZERO_DATE%';
+----------------------------------+
| @@SQL_MODE LIKE '%NO_ZERO_DATE%' |
+----------------------------------+
|                                1 |
+----------------------------------+

 

 

Remember one thing this is base on the studies we implement for our customers if this fix does not apply on your issue you can contact us to permanently solve your issue at   http://365hostingSupport.com

 

 

 

 

Outsource Hosting Support

365HostingSupport bound to provides quality #outsourced web hosting support,  #Server Management and #emergency services to hosting companies worldwide. We understand the level of expertise and the quality you expect when you outsource your business and trust us.  We are there for you 24/7, even when your not. Our team will pro-actively communicate with your datacenter / Customers/ Management provider to get the issue solve , to help get your server back online and make it stable should any issues arise.

Our mission at 365 hosting Support is to provide high quality Linux and Windows Server Management, network infrastructure management, and server and network support services at affordable rates to all our clients.Whether you are running a competitive web hosting business or providing servers, We offer a wide range of technical support services that work in favor of your business. Services like Server Management, Server Monitoring, Server Security and even Server Optimizations are all designed to ensure your business operates smoothly without any problems.

Why 365 Hosting Support ?

Managing 100+ servers
Certified System Admins
True 24X7 Support
Quality with Affordable price
Server Security
Unlimited Ticket Support

Our plans differs in below Services :

– Linux/http://365hostingsupport.com/blog/
– Linux/Windows Server Security
– Cpanel Server Management

– Plesk Server Management
– Emergency Services
– Outsource Support
– Helpdesk Management

http://365hostingsupport.com/

Indian Hosting Support

Indian hosting support

Its really important thing to provide the quality support along with the hosting services and sometimes its really gets challenging to handle such huge pressure of Server Management, support tickets and technical chats, so its indirectly harming your business and customers. 365hostingsupport is now understanding such problems of hosting providers and has started to provide the affordable outsource hosting support.

Our plans differs in below Services :

– Server Management
– Server Security
– Server Management
– Emergency Services
– Outsource Support
– Helpdesk Management

Our mission at 365 hosting Support is to provide high quality Linux and Windows server management, network infrastructure management, and server and network support services at affordable rates to all our clients.Whether you are running a competitive web hosting business or providing servers, We offer a wide range of technical support services that work in favour of your business. Services like Server Management, Server Monitoring, Server Security and even Server Optimizations are all designed to ensure your business operates smoothly without any problems.

365hostingsupport’s is already dealing with the multiple clients and having smart team of Engineer’s who are committed to help you 24*7*365.

http://365hostingsupport.com/

Cagefs Management

CageFS is a kernel level security which enable the separate environment for user level and protect from been hacked on different level such as symbolic link, openbase dir etc.

More on CageFS is a classified file system and a set of tools to contain each user in its own ‘cage’. Each customer will have its own fully functional CageFS, with all the system files, tools, etc.

Why You need CageFS ?

– Per user, virtualized file system
– User can see only their own files / safe system files
– Virtualized /etc, including passwd file
– No config files with all the users
– Only one user in /home
– No presence of other users.
– Virtualized /proc – user can see only their own processes
– Virtualized /dev file system

We have the domain experts which will install and setup the cloudlinux + cageFS security on your server without interrupting your applications and server settings.

This task includes

– kernel Installation / upgrade
– Kernel Patch
– Configure YUM to auto update
– Update the Application
– Customize the security setting
– Apply cage changes on server wide
– Test the working of services and applications
– Set Alert systems
– Set the System environment to help and avoid back-doors.
– Secure unwanted services and binaries

If you already running the CageFS , please note that the default setting may not protect you with the internet threads. It need to be optimize and secure as per the requirement. We all do it for you. Contact us for Support or emergency support at sales@365hostingsupport.com.

http://365hostingsupport.com

Assign a dedicated IP to a Sub-domain OR Add-on/Park domain?

We can assign dedicated ip to main domain very easily but for addon domain/subdomain/parkdomain we can not. We have to perform following steps for it.

By default, cPanel allows one IP per account, however, in case you wish to assign multiple IPs to an account, say for a sub-domain, you can do so by editing a few files. Follow the below steps:

1) The main configuration file of a domain is stored under the /var/cpanel/userdata/<username>/ directory, so edit the subdomain related file under it

# vi /var/cpanel/userdata/<username>/subdomain.domain.tld

Change the value of “IP” to a dedicated IP and save the file. The add-on and Park domains have their related subdomain files in the same directory.

2) Once the above changes are made, you need to rebuild the Apache configuration for the changes to take affect in the respective VirtualHost entry

# /scripts/rebuildhttpconf

3) To mark the dedicated IP as “used”, edit the file /etc/domainips and enter the sub-domain entry

<dedicated ip>: subdomain.domain.tld

Save the file and rebuild the IP pool

# /scripts/rebuildippool

4) Now, edit the DNS zone file of the main domain (i.e. the domain under which the subdomain is created)

# vi /var/named/domain.tld.db

and set the A record of the sub-domain to point to the new IP. Save the file and restart the ‘named’ service

# service named restart

That’s it.

Note: Rebuilding the IP pool will still list the IP as free under the WHM -> IP Function -> ‘Show IP Address Usage’, however WHM wont allow you to assign that IP to another domain.

Easyapache error : relocation error

home/cpeasyapache/src/php-5.3.15/sapi/cli/php: c: /home/cpeasyapache/src/php-5.3.15/sapi/cli/php: symbol deflateInit2_, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference
make: *** [ext/phar/phar.phar] Error 127
!! ‘make -j2’ failed with exit code ‘512’ !!

Solution:

1. rm -f /usr/lib64/mysql/libmysqlclient.so.16
ln -s /usr/lib64/libmysqlclient.so.16.0.0 /usr/lib64/mysql/libmysqlclient.so.16

2.rpm -e mysql-libs
/scripts/mysqlup –force

EasyApache Error

httpd: Syntax error on line 40 of /usr/local/apache/conf/httpd.conf.1342783979: Syntax error on line 9 of /usr/local/apache/conf/php.conf: Cannot load /usr/local/apache/modules/mod_suphp.so into server: /usr/lib/libstdc++.so.6: undefined symbol: _ZNSt12strstreamfuf8_M_setupEPcS0_i, version GLIBCXX_3.4

Solution:
– – – – – – – – – – – – – – – – – – – – – – – – –
root@cpanel [~]# yum whatprovides /usr/lib/libstdc++.so.6

libstdc++-4.1.2-52.el5_8.1.i386 : GNU Standard C++ Library
Repo        : installed
Matched from:
Other       : Provides-match: /usr/lib/libstdc++.so.6
– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

Then reinstalled this package with the following command:

– – – – – – – – – – – – – – – – – – – – – – – – –
yum reinstall libstdc++
– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

I suspect that the file /usr/lib/libstdc++.so.6 was corrupted or outdated for some reason and reinstalling the package fixed it.

DOS: How to check it?

Now a days DDOS attack became the usual in the server. You can follow the below checklist to Stop at certain extent.

Steps:

1.How to find DOS attack on the server

[root@root]# pidof httpd

If you find more than 5 rows of PID from above command result, you can suspect there is DOS attack in the server.

2. Run the below script to confirm the DOS attack and block the IPs continuously.

[root@root]# netstat -plan|grep :80|awk {‘print $5’}|cut -d: -f 1|sort|uniq -c|sort -nk 1

OR

[root@root]# netstat -an | grep SYN|sort|uniq|awk ‘{print $5}’|sed ‘s/\:/ /g’|awk ‘{print “csf -d “$1}’

you can find high hit from different IPs. Once You confirm DOS attack in the server ,

4. Now we have to check the “MaxClient” and Timeout value in Apache configuration.

MaxClients 150
Timeout 300

Timeout 300 is the default value. We can reduce bit lower into avoid DOS attack at certain extend

5. Now we have to find , on which are the domain, DOS attack is happening.

[root@root]# cd /usr/local/apache/domlogs/
[root@root]# ls -ltr |tail -50

(it will list the TOP 50 domains which are in high access.

6.Now, Run the following command to know the IPs which is hitting the particular domain..

[root@root]# tail -f domainname | awk {‘print $1’}

7. If the hit is coming from same IP, we can block only those IP. if hit is from different ranges of IP, we have to suspend or disable that account or can block the range of IPs.

8.Instead we can remove the DNS/pdns DB entry for the domain.

[root@root]# mv /var/named/domainname.com.db /var/named/domainname.com.db.bak[root@root]# touch /var/named/domainname.com.db

9. Also remove ZONE entry from PDNS.

10. In WHM : Apache status you can see the domain which is receiving more hits or request. As per that take an action.

11. If attack is not in control then make changes in csf.conf as follows

1. vi /etc/csf/csf.conf

find : CT_LIMIT and set it to 150

2. FIND: SYNFLOOD, SYNFLOOD_RATE and SYNFLOOD_BURST

Set the values as follows:

SYNFLOOD = “1”
SYNFLOOD_RATE = “10/s”
SYNFLOOD_BURST = “15”

Definition: SYN flood: A SYN flood is a type of DoS attack. A SYN packet notifies a server of a new connection. The server then allocates some memory in order to handle the incoming connection, sends back an acknowledgement, then waits for the client to complete the connection and start sending data. By spoofing large numbers of SYN requests, an attacker can fill up memory on the server, which will sit their waiting for more data that never will arrive. Once memory has filled up, the server will be unable to accept connections from legitimate clients.

3. Also enable PORTFLOOD as follows.

PORTFLOOD = “80;tcp;300;5”

3. save and exit

4. Restart csf.

 

How to restore data using Cpremote

How to restore data using Cpremote

1. To resotre a full account use following command:

/scripts/cpremoterestore –user=domainuser –from=Saturday –type=full

Here,
–user=domainuser : domainuser is a Cpanel user.
–from=Saturday : Backup day
–type=full : Full account restore.

full -full account restore , you may need to termiante the account

2. To restore mail use following command:

/scripts/cpremoterestore –user=domainuser –from=Saturday –type=mail

Here is,
–user=domainuser : domainuser is a Cpanel user.
–from=Saturday : Backup day
–type=mail : to restore mail

3. To restore www that is public_html use following command:

/scripts/cpremoterestore –user=domainuser –from=Saturday –type=www

Here is,
–user=domainuser : domainuser is a Cpanel user.
–from=Saturday : Backup day
–type=www : To restore publi_html

4. To restore DB use following command:

/scripts/cpremoterestore –user=aadyam –from=Saturday  –type=db –db=aadyam_wp1

Here is,
–user=domainuser : domainuser is a Cpanel user.
–from=Saturday : Backup day
–type=db –db=aadyam_wp1 : DB name which you want to restore.

5. To restore folder from remote backup server using cpremote script.

/scripts/cpremoterestore –user=aadyam –from=Saturday –type=part –part=public_html/test

Here is,
–user=domainuser : domainuser is a Cpanel user.
–from=Saturday : Backup day
–part=public_html/test : To restore test directory

6. To restore file from remote backup server using cpremote script.

/scripts/cpremoterestore –user=aadyam –from=Saturday –type=part –part=public_html/images/why_us1.jpg

Here is,
–user=domainuser : domainuser is a Cpanel user.
–from=Saturday : Backup day
–part=public_html/images/why_us1.jpg : To restore why_us1.jpg file.