UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support close database connections issue..

Hi

See below
Is there a way to set UBB code as mentioned, do we have options in admin panel that effect when connections closes?




Issue: Database/MYSQL
Problem Description:
7/22/2013 7:46:01 AM - Online Customer:
Hi, our database seems to get blocked and we don't have that much traffic. could you please help.... Script: - Line: Unable to connect to the database! - Host 'lnh-xxxxj.xxxx.xxxx.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Solution History On Ticket:
7/22/2013 8:16:03 AM - Darren T.:
Dear Morgan ,
Thank you for choosing Web.com technical support.
I am not able to replicate your issue. There are a limited ammount of connections (780) allowed to a database and the error message means that these connections have been exceeded. Please ensure that your code closes any connections to the database once no longer required

If above question don't help maybe below will but i don't know how to execute these commands etc, Any ideas..?


http://answers.web.com/article.asp?article=3915&p=2


How to use a custom php.ini file

Because we’ve implemented php as a CGI, you can’t change php runtime settings via the php_value and php_flag directives in an .htaccess file. To change php runtime settings, you can either use ini_set in your code, or write a wrapper cgi which specifies the configuration file.

To use a custom php.ini file:

Enter the following commands to copy the system’s default php.ini into your home directory:
cp /etc/php.ini ~/

Enter the following command to create a cgi wrapper named php.cgi in your cgi-bin directory containing the following lines:
#!/bin/sh
exec /var/www/cgi-bin/php -c ~/php.ini

Enter the following command to set the executable bit on your wrapper:
chmod +x php.cgi

Add an .htaccess file to the directory in which you want to use the settings. The .htaccess file should contain the following lines:
AddHandler application/my-php .php
Action application/my-php /cgi-bin/php.cgi

Change any settings you need in the php.ini file in your home dire
ctory and use phpinfo to ensure that they’re set.

The only section affecting the db's connection is "Persistent Connections" which you shouldn't be using unless you're on a dedicated machine; this setting is in the CP at:
CP -> Master Settings -> DB, Paths & URLs -> "Use Persistent Connections?"

OK but its strange, they say

Please ensure that your code closes any connections to the database once no longer required

so what does Persistent Connections do? what kind of harm could it do if i use it?

I will reopen the ticket and ask the host.

we'll see what they will answer, my ubb error log file is between 1,5-2 MB everyday which is a lot of bad connections.

Easy, don't enable it, I included that tidbit there to ensure you weren't... Persistent connections will always ensure there are open connections to the database...

OK then i will not unless host say its ok!?

Then my options are to look for another host or another plan cause our members are fed up with all these error pages.
Or if anyone has any idea..
Could it not work then with the other option?
http://answers.web.com/article.asp?article=3915&p=2

Cheers

I, and several of my clients, use hosting and VPS services with Interserver and several members here use Express Hosting as well.

My suggestion three months ago was to migrate to another host,Due to the exact same issue.
As Gizmo has stated as well as I have, you could try express hosting. I know you were waiting on a reply from them at the time.

Or the other hosts Gizmo suggested.
They both offer better options than what you have now.

Host said no to persistant connections on a shared server,.
So i'm on a shared linux account now and see that
there is so much to chose from.
I wonder how to chose the right VPS platform/size/capacity..
maybe this question is off UBB topic but since my present mysql is close to 1 GB
I don't see how much database space any of the two mentioned above offer.
Off to the beach..

PS Express hosting never answered..

I can tell you for express.
They don't limit the size nor number of database you use.
They give you x number of storage space and bandwidth per plan and you use it how you wish.
For example the cheapest shared plan is 9.99 us dollars per month.
10GB storage
100GB bandwidth
Use it as you wish.
email accounts will take space
web pages will take space

if say you have two databases using 1GB each you still have 8gb for your other stuff.
or have 100 databases as long as you have storage space that is also okay.

You will need to talk to him about vps plans. As well as dedicated servers.

For a vps plan you may want to consider a managed plan at first so you can get some help from the host running things.

You get dedicated resources with a VPS, and Interserver has a 1 slice VPS is $6 and you get 512mb shared memory, 25gb storage on an OpenVZ with no control panel (you could install Webmin/Virtualmin yourself or rent a CPanel install from them for $10/mo

They have shared hosting options as well as additional slices for VPS' (a slice is a share of the resources on a VPS, the more slices the more resources; you can tinker on their VPS page). Myself I have a 4 slice VPS for them which is hosting several sites (and I use a CDN on top of that).

So getting VPS means there is a limit of space that I can use for either database + website storage = total amount within the limit.

when using shared plans they specify each item and limit for each items.

I see on shared plans they say for example there are hundreds of one click installs that comes with the plans, does it with VPS too?

Gizmo
On Interserver's site there are several "OS" to chose from wonder which one to chose?

I see from my web.com statistics that the traffic normally is about 75GB per month from Manually traffice and about the same from spiders so that would be minimum 150GB required per month.

Nah I have been looking on both options express/Interserver It's late here and i'm not thinking strait, will be gone next day, just feel i need to learn more.

well the suggested shared plans don't limit you to a specific number or size of mysql or email account,etc.
They just limit you on the storage space and bandwidth needed.
Now a VPS or dedicated server. Is differet where they actually just provide a server to you and you are required to make all the server settings within the boundaries of the physical limits of the server. Meaning the cpu size,ram plus drive size.
Now with them comes options of managed or un managed usually.
Meaning that managed the host will assist in the setup and running of the server for a fee that is why a managed server is more cost.
A un managed server means they provide a server and it is totally up to you to install software and make all the settings like you are used to on a shared account.

Thanks ruben for the info
Obviasly is the limit of 780 connections a problem now and the reason why i look elsewhere, and of course the size of DB backups size. Right now I cannot upload backup files as they are above the limit.

I run on CentOS, it's a debranded Red Had Enterprise Linux.

And yes, space is space with most places, they don't really care how you use it.

The problem one might find with a VPS is that they need to run updates by themselves; a basic crash rundown of how to use SSH and running the command "yum -y upgrade" generally does the task for most people though.

Gizmo,

I hijacked a thread on interserver forum
http://forum.interserver.net/forum/threads/do-you-guys-use-vps.2214/
what do you think of The admins reply regarding connections on Interserver VPS

What do you think about below from web.com support, could there be something wrong that is not closing connections?

I think he's pointing towards the possibility of you just using a vps for hosting MySQL and still hosting the site wherever you want; I'd just host everything on a VPS and call it good.

I've never run into connection limits on a VPS before; if anything would go wrong memory wise there's always another slice one could buy for the VPS...

OK I'm just buying 2 slices without Cpanel and go from there.. at this point i'm not migrating but will check as i'm curious.

Gizmo I never got a verifying email so maybe the purchase did not come thru,

I run a show variables check in myphpadmin database and look what came up

Under Show variables i found


MyPHPadmin says also

Well, if that's from the VPS the beauty is that you can change the variables...

Nope its from my present host..

Well without looking it up.
There are two settings for that.
max_user_connections
and Max_connections
I think that one is just what your host says is the limit.
So it sounds like they may have lied to you.
if they were unlimited they would be set to 0.
Or as they stated 780 on at least one of them.

Well here we go, I ordered VPS by interserver and at first i want to
use the old website but the new VPS for database

Database is restored at new VPS but i have connection problems
During the day I was able to open one (1) forum page and the admin cp once too
Despite from that only a message with no connection to mysql.

What I have don is to change following in the config.in.php

server ip
username
database name
password

Thats it, I wonder do I need to change anything else?
as I say I am keeping the britbike.com domain at the old place until I see I get
connection.

Oh yes, I'm entitle now to set persistant connections as mysql.allow_persistent is turned on.

Now where do i set this when I can't open ubb control panel.

If anyone has the strength then I'm interested in some help to secure this migration.

Thanks

If you are attempting to use two different servers meaning database on one host server and script files in another host server.
I don't believe it will work.
But anyway
You need to figure out the first line which usually is:
'DATABASE_SERVER' => 'localhost',

If you had cpanel you could use:
Remote Database Access Hosts

Hi Ruben,
In config.inc.php it was before an ipaddress which i changed to new database ipadress.
'DATABASE_SERVER' => 'IP_address',
I do have a cpanel
Remote Database Access Hosts
I had 209.xxxx.%
but just now i set to %

Blimey it was the max_error that failed or worked as it was set to "10" and now"99999"
so now can use the board, have not open yet but am posting tests as admin.
check out if you like
http://www.britbike.com/forums/ubbthreads.php?
Thanks

I hope you do know that just using % allows any site in?
They still need user and password but?

have removed the % now and replaced it with an Ip address.
Thanks for your input Ruben.
Cheers

I still wouldn't turn on persistent connections; it's just not worth it and doesn't quite do what one would think (at least efficiently).

Feedback.

three days now on VPS and not a single error in the log.. well two tiny errors yesterday 398 bytes compared to 3MB ea day before.

People say its fast even as the website is in Georgia and database is in NJ.