GoDaddy Server Issue

[webguy_ddm]

Hi OSCommerece friends,

 

I have been dealing with an issue witih GoDaddy for over 2 weeks now with no resolutions. The reason I am posting here, is because I need to read if anyone is having the same issues as I am.

 

these are the Server Details

 

Item

Detail Hosting Package Deluxe

Server Name  

cPanel Version 11.48.1 (build 2) Theme gl_paper_lantern

Apache Version 2.4.12

PHP Version 5.4.37

MySQL Version 5.5.32-cll-lve

Architecture x86_64 Operating System linux

Dedicated IP Address  

Path to Sendmail  

Path to Perl  

Perl Version 5.10.1 Kernel Version 2.6.32-531.29.2.lve1.3.11.1.el6.x86_64

 

I also keep seeing this SERVER OVERLOAD ERROR 

 

Server Load 66.83 (24 cpus)

 

What does that mean?

 

I also upgrade to LEVEL 2 - with a Physical Memory of 1024.

 

I don't want to do it but I may need to move away and go to Blue Host

 

 

Need advice

[ken0306]

it could be cause by your website script. have you custom any script for your website? most of time it cause by search function. If you have problem shows that you overload the server, it will mostly like happen with other company as well. I will suggest you trying to upgrade your shopping cart, or go get a VPN. 

ken

[Jack_mcs]

@@webguy_ddm It means your site has reached the limit of your server. This is almost always caused by data skimmers on the site. But there's no way to tell without looking at the access log. If you ask your host, they will most likely advice you to upgrade to a VPS or Dedicated server and that may work but only because it masks the problem, assuming your site is not so normally busy that it needs it.

[webguy_ddm]

@@ken0306 and @@Jack_mcs,

 

I have been reading up on Gzip. I enabled it without out any luck. On the Admin area, GZip says Enabled with 9 compression.

 

I did the test from getnetwork.com and got these results.

 

Web page compressed? No

Compression type? none

Size, Markup (bytes) 722,336

Size, Compressed (bytes) 722,336

Compression % 0.0

 

How do i enable the Gzip?

 

Is the code on the header_top.php missing?

[webguy_ddm]

Also checked my Google Analytic and I get about 30 - 50 visits per day.

[Jack_mcs]

@@webguy_ddm The option you enabled for gzip will condense some things but is not what the test you ran checks. You need to add caching code to your .htaccess file (can be found on this forum). Also, you shouldn't set that option to 9. The higher the number, the more compression is done and it takes longer to compress more tightly. So you end losing speed as a result. I recommend 3 or 4, or 5 if the server can handle it.

 

You analytics report confirms what I said. That does not cover data skimmers and if you looked at the access log, you will almost certainly see many hits there from such places.

[webguy_ddm]

@@webguy_ddm The option you enabled for gzip will condense some things but is not what the test you ran checks. You need to add caching code to your .htaccess file (can be found on this forum). Also, you shouldn't set that option to 9. The higher the number, the more compression is done and it takes longer to compress more tightly. So you end losing speed as a result. I recommend 3 or 4, or 5 if the server can handle it.

 

You analytics report confirms what I said. That does not cover data skimmers and if you looked at the access log, you will almost certainly see many hits there from such places.

 

@@Jack_mcs

 

I looked at my host Cpanel and saw that it has an OPTIMIZE section, it list (DEFAULT) (COMPRESS ALL) and (COMPRESS THE SPECIFIC MIME TYPES)

I set it to COMPRESS ALL

 

Also, I went into my Gzip and set it to 5, my USE CACHE is set to (TRUE)

 

under SESSIONS i have the following settings.

FORCE COOKIE USE: FALSE

CHECK SSL SESSION ID: FALSE

CHECK USER AGENT: FALSE

CHECK IP ADDRESS: FALSE

PREVENT SPIDER SESSIONS: TRUE

RECREATE SESSIONS: FALSE

 

are these setting done right?

 

Also, I looked in my system and I don't see an .htaccess , (what I do see is .htaccess.preinstall) file. 

[webguy_ddm]

I want to make a correction to where I ran the test,, its from this link  http://gidnetwork.com/tools/gzip-test.php

 

GID NETWORK

[Jack_mcs]

@@webguy_ddm I've dealt with sites on godaddy before and that optimize option caused failures. Maybe your site will be different.

 

But I don't think you are understanding what I am saying. Let's say you have a 1,000 hits an hour on the site so it goes down. You make the changes you've made and now the site can handle 1,100 hits an hour (I'm just making these numbers up). As soon as more data skimmers hit your site and make it 1,200 hits, it will go down again. In other words, you've but a Band-Aid on the problem where it needed stiches. :) Read through my View Counter thread and it may help to see the problem.

[webguy_ddm]

@@webguy_ddm I've dealt with sites on godaddy before and that optimize option caused failures. Maybe your site will be different.

 

But I don't think you are understanding what I am saying. Let's say you have a 1,000 hits an hour on the site so it goes down. You make the changes you've made and now the site can handle 1,100 hits an hour (I'm just making these numbers up). As soon as more data skimmers hit your site and make it 1,200 hits, it will go down again. In other words, you've but a Band-Aid on the problem where it needed stiches. :) Read through my View Counter thread and it may help to see the problem.

I understand Jack.  :thumbsup:

 

I think the plugs in for FB I am using is causing these errors. also the template I am using may have something to do with it. 

 

Last, can you get me a link on how to get my .htacces installed? 

 

Thanks boss

[Jack_mcs]

I'm sorry but I don't understand what you mean by ".htacces installed." If you are saying you don't have such a file and want one, it is just a txt file so just create a file using any editor and rename it to .htaccess, no extension.

[webguy_ddm]

let me explain. Their is an htaccess file in the admin folder and includes folder.

 

I also see one on the Root. but was labeled htaccess.test  , I am assuming that it needs to be .htaccess for it to be active.

 

but what I need to know is if the .htaccess needs scripts?

[webguy_ddm]

Got my Error Logs @@Jack_mcs , @@ken0306

 

 

[26-Mar-2015 04:55:14 UTC] PHP Warning:  mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /includes/functions/database.php on line 19

 

[26-Mar-2015 01:55:09 UTC] PHP Warning:  error_log(/var/log/www/tep/page_parse_time.log): failed to open stream: No such file or directory in /includes/application_bottom.php on line 20

[Blue Penguin]

webguy_ddm:

 

>>(/var/log/www/tep/page_parse_time.log

 

If you are using 2.3.4 oscommerce, I believe this is set in the osc admin -> Configuration -> logging -> log Destination

 

/var/log/…  is most likely off limits from your account if it cannot create a file there.  Try using something like /home/<my-account-name>/logs/page_parse_time.log. Also make sure you have created a folder in your account for /logs/.

 

>>PHP Warning:  mysql_connect(): Can't connect to local MySQL server

If this is godaddy, did you install oscommerce via installatron?

 

 

Is your shop working right now? To the point where you can add products to it etc? 

 

For .htaccess in godaddy you can set user access via cPanel -> (files category) Directory Privacy. In product support there is more on .htaccess under Help > Web Hosting > Languages and Scripts > .htaccess which might help you further.

 

-BP

[webguy_ddm]

 

webguy_ddm:

 

>>(/var/log/www/tep/page_parse_time.log

 

If you are using 2.3.4 oscommerce, I believe this is set in the osc admin -> Configuration -> logging -> log Destination

 

/var/log/…  is most likely off limits from your account if it cannot create a file there.  Try using something like /home/<my-account-name>/logs/page_parse_time.log. Also make sure you have created a folder in your account for /logs/.

 

>>PHP Warning:  mysql_connect(): Can't connect to local MySQL server

If this is godaddy, did you install oscommerce via installatron?

 

 

Is your shop working right now? To the point where you can add products to it etc? 

 

For .htaccess in godaddy you can set user access via cPanel -> (files category) Directory Privacy. In product support there is more on .htaccess under Help > Web Hosting > Languages and Scripts > .htaccess which might help you further.

 

-BP

 

OK Let me check

 

Installed Version: osCommerce Online Merchant v2.3.3

[webguy_ddm]

YES this was installed using GoDaddy's INSTALLATRON. 

[Jack_mcs]

let me explain. Their is an htaccess file in the admin folder and includes folder.

 

I also see one on the Root. but was labeled htaccess.test  , I am assuming that it needs to be .htaccess for it to be active.

 

but what I need to know is if the .htaccess needs scripts?

There can be many .htaccess files in the shop and admin but they are mostly different so you can't use one from somewhere else for the one in the root directory. You don't need one in the root directory at all unless you need to apply some command there.