snubbr.com

Cheap and reliable Webhosting with XML. Verisign SSL?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
Quick question... Cheap and reliable Webhosting with XML. Verisign SSL? Hoping for any comment. 2nd question I got is.. My Verisign hosting company is threatenting to kick me off because they say my oscommerce script is leaving a "log of open database connections" which is overloading their server..

I dont understand this at all can someone advise whats going on here. I dont get many hits maybe 20 visits a day. Someone suggested a search bot or a hacker is opening these connections..

My isp "fixed it" several times but being stupid they wont tell me what they did to fix it. When it gets bad it runs VERY slow or I get the "too many connections in database" error..

How can I a) close all the open connections.

Stop bloody search spiders going into it and opening many connecitons if thats whats happening..

Im about to get kicked from my Verisign hosting company....

I am using oscommerce 2.2 I used 7dana.com ecommerce manager (which is a great template with loads of addons already installed).

Thanks..

Comments (7)

That's a good question. I'm not sure what is the right answer to your question. I'll do some investigation and get back to you if I find an good answer. You should email the people at Verisign as they probably could help you..

Comment #1

Don't know, but maybe try setting both configure.php files.

Persistent connections to false..

Comment #2

Yep it was already set persistent connections to fales. Also I left define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'.

So as it's '' then the sessions should be stored to the files in TMP directory not leaving open connections on the server (i think????).

So both config files are.

Define('USE_PCONNECT', 'false'); // use persisstent connections?.

Define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'.

So why am I getting open connections in the databse?.

Thanks..

Comment #3

My sites database has grown from 10mb to 50 mb in a month and ive had less than 100 orders. Is that right?.

Also, when I backup the Verisign site using tools, backup it's about 12 MB but when I back up using phpmyadmin (adding a drop table) it's about 50MB. So why the difference in filesize?.

How can I see "open connections" or what IP address is opening these connections, thanks..

Comment #4

Have a look in phpmy admin and see which tables are large..

Then you look and can decide if it is normal...

Comment #5

I guess your sessions are stored in your db. Try creating a directory for them under catalog, and change both config.php files to reflect the new directory...

Comment #6

Thanks.

How do I do this please exactly at the moment it's define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'.

So the sesions are NOT going to sql but are going to "" whereever that it.

Cheers..

Comment #7

You could make a directory called "whatever" where your catalog files are and set.

Define('STORE_SESSIONS', 'whatever'); // leave empty '' for default handler or set to 'mysql'.

And see if that helps. If it doesn't, undo the changes...

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.