Messages

I am using AccuWeb Hosting Forex VPS plans for my brokers. Their Forex plans are suitable for Forex trading and you will get nearest server location based on your broker's server.

- Rick

Thank you for the information. I have patched all my systems in the organization to protect them from PrintNightmare Windows Print Spooler Remote Code Execution Vulnerability.

- Rick

[Class 'PDO' not found]

Hi,

I have uploaded website in my cPanel account which is built using PHP Laravel. It is working fine in my local development but it is not working when I uploaded to live website. It is giving following error:

Class 'PDO' not found

How can I fix this error?

Thanks!
Rick

An integer overflow flaw was found in the Linux kernel's create_elf_tables() function. An unprivileged local user with access to SUID (or otherwise privileged) binary could use this flaw to escalate their privileges on the system. Kernel versions 2.6.x, 3.10.x and 4.14.x are believed to be vulnerable.

https://www.qualys.com/2018/09/25/cv...2018-14634.txt
https://access.redhat.com/security/cve/cve-2018-14634

Redhat has pushed a systemtap patch in the above link.

[sc delete <my_service_name>]

I removed one software from my Windows server but when I checked services, I found that during removal it had not removed service. I manually tried to remove the service using the following command:

sc delete <my_service_name>

But I got annoying error as follow:

[SC] DeleteService FAILED 1072:
The specified service has been marked for deletion.

Not sure what's wrong.

- Rick

[My SQL Error 1048 column description cannot be nullIncorrect integer value: " for column 'id' at row 1Field 'description' doesn't have a default value]

I am installing third party CMS (built in PHP and MySQL) but during installation, I got following message:

My SQL Error 1048 column description cannot be null
Incorrect integer value: " for column 'id' at row 1
Field 'description' doesn't have a default value

I have tried 2-3 times to install it without any success. Also this is a fresh installation so I am not sure why it is telling "Field 'description' doesn't have a default value".

Any help would be appreciated!

- Rick

Hi,

I was helping my friend to restore SQL 2008 database via SQL management studio. But when I start SQL management studio, I received the following error:

The type initializer for 'Microsoft.SqlServer.Management.Dmf.PolicyStore' threw an exception. (Microsoft.SqlServer.Dmf)

Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.

Is the above message told there is corruption in installation? and is there any easy way to fix it?

Thanks,
Rick

Hi,

I am new to manage server via SSH. Is it possible to check PHP and MySQL version via SSH for cPanel server? I know we can upload phpifo page to check PHP version but I am curious if we can check it directly via SSH.

Thanks,
Rick

Hi,

I have cPanel VPS. Previous staff member has set some cron jobs via SSH to take backup of the data on another server (a script to transfer backup via rsync). Now we want to change the time for the cron jobs. Previously cron jobs were set via SSH (root user).

Can someone help me to edit cron jobs via SSH so that I can adjust timing?

Thanks,
Rick

Hi,

I am helping one of my friends to install WHMCS on his website but I am receiving the following error during installation:

-------------------------
Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade330.sql
Line 15 – Field 'fromname' doesn't have a default value
Line 16 – Field 'fromname' doesn't have a default value
Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade340.sql
Line 16 – Field 'fromname' doesn't have a default value
Line 17 – Field 'fromname' doesn't have a default value
Line 18 – Field 'fromname' doesn't have a default value
Line 30 – Field 'value' doesn't have a default value
Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade341.sql
Line 6 – Field 'fromname' doesn't have a default value
Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade380.sql
Line 24 – Incorrect integer value: " for column 'id' at row 1
Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade450.sql
Line 4 – Incorrect integer value: " for column 'id' at row 1
Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade500.sql
Line 6 – Field 'attachments' doesn't have a default value
Line 12 – Field 'attachments' doesn't have a default value
Errors Occurred

Please open a ticket with the debug information below for support

File: upgrade520.sql
Line 12 – Field 'attachments' doesn't have a default value
Line 20 – Field 'attachments' doesn't have a default value
-------------------------------------------------

This is a fresh installation. Initial check was passed and server meets  WHMCS requirements but I am not sure how to resolve above error.

Please help!

Thanks,
Rick

Thank you for sharing the command to check PHP and MySQL version via SSH.

Rick

Nowadays most servers are configured to run PHP process under user instead of nobody so tweak settings option doesn't help but cPanel counts the emails which are sent via script so it is better to set appropriate hourly email limit from WHM.

Rick

Thank you for providing such a useful information. This certainly helps to find processes running under specific user.

Rick

Thanks I was able to upgrade WHMCS to latest version.

Thanks. I will look their plans.

Rick

They are continuously doing development and now cPanel/WHM 11.42 version.

Rick

They are continuously doing development and now cPanel/WHM 11.42 version.

Rick

I was able to change the document root. Thank you for the information.

Rick

As mentioned in the article, I set 30 days for eximstat and the database size is now 1/3 from the original. Previously it was 90 days.

Rick

Thanks for the information. I was able to uninstall MySQL completely.

Rick

Hey thanks for the article. It helped me to disable WordPress virtual cron wp-cron.php and I was able to reduce my usage.

Rick

Hi,

As far I know WordPress uses wp-cron.php file for the virtual cron. This file is being accessed each time whenever a page is visited. I have one heavy traffic WordPress blog and this is causing the issue. Is there any way I can disable WordPress virtual cron so that wp-cron.php is not called on each page visit? This will help me to reduce the resource usage.

Thanks,
Rick

Hi,

I have local development server on which I installed MySQL but later I forgot the MySQL root password and I ran uninstaller to remove MySQL. After uninstalling MySQL, I tried to reinstall MySQL server but yet I am unable to login to MySQL server. It seems the when I ran uninstaller, it did not remove MySQL installation completely. Is there any way to completely remove MySQL from Windows server?

Thanks,
Rick

Hi,

My friend has Linux cPanel VPS and recently he ran out of disk space. After investigating, he found large Exmstats database on his VPS. It seems that this database is being used by cPanel but I am not sure if it is safe to delete the records from it. Can someone provide me more information about Exmstats database? And is it possible to restrict the size of this database?

Thanks,
Rick

Hi,

I have Linux cPanel shared hosting account. I have default public_html as a document root but I want to change my default document root using .htaccess. Can somebody please help me to change document root using .htaccess?

Thanks,
Rick

Hi,

I am using WHMCS 5.2.16 and I could see that WHMCS 5.3.5 is now stable. Is there any guideline to upgrade WHMCS 5.2.16 to latest WHMCS 5.3.5 version?

Thanks,

- Rick

Hi,

I am looking for fully managed SSD VPS hosting. I am looking for Windows VPS with SSD (Hyper-V preferable). Is there any good Windows SSD hosting provider?

Thanks,

-Rick

Hello Kailash,

Thank you for the details. This will certainly help you reduce the impact of DDoS attacks.

Thanks!

- Rick

We have had this particular server running for quite some time without any issues until today. We were just informed that we were the target of a DDOS attack and as a result, the datacenter has null routed the IP address in question. This IP address was not only our main IP address, but also the main shared IP for the shared hosting accounts.

If we were to pick another IP address in our pool to act as both the main IP and the new shared IP (Or split them up even), what would be the best way to change this in cPanel? I know we can set the new shared IP in the basic setup area in WHM, but I'm not sure how to tell cPanel to use a different IP as its "main" IP.

Rick