Data base connection problem

southernmoney · Post by **southernmoney** » Tue Sep 22, 2009 3:04 pm

Version of script: V2.1

Hi Klemen,

I have a serious crisis.

Since yesterday the problem started to increase. When we try to log in we get an error message "cannot connect with data base" Then again it logs in after lets say the 5 try. Once in the program the same happens. If we click twice on refresh then suddenly we are active again. It is extremely unstable to the point that we cannot do our work.

I have asked the service provider Axxess that stores our data base and they say all is fine on their side. I have used myadmin and can open the data base. I have checked my settings on hesk and all is still the same.

This is a crisis for us. Can you perhaps help. We are running 3 agents and 1 administrator on Hesk.

The only change I have made was email length. I immediately changed it back for fear of being the problem.

Does Hesk have a capacity limit? We are storing a lot of attachments and data. Is there an entry limit?

Please help.

Regards

jvz

Post by **Klemen** » Tue Sep 22, 2009 6:07 pm

This is 100% a server-side problem. You probably reached maximum MySQL connections limit (it works after a while because some connections are dropped). This is something your host needs to increase (a MySQL connection limit is set both in PHP and MySQL configuration).

southernmoney · Post by **southernmoney** » Tue Sep 22, 2009 6:17 pm

Hi Klemen,

I will follow this up with the service provider first thing in the morning. You can imagine it is a disaster. So I am hoping it is as easy as you say it is.

Hope to give you feedback soon.

Many thanks

jvz

southernmoney · Post by **southernmoney** » Tue Sep 22, 2009 7:22 pm

Hi Klemen,

I have reduced the database by deleting the data of all of a month of our resolved issues. However, the connection problem was not resolved. I also noticed that we have only used a third of out database memory.

When I ran debug on Hesk I got the following message:

"Cannot connect to database. Mysql says: unknown mysql server host 'southernmoney.co.za' (2)"

Your guidance will be appreciated.

jvz

Post by **Klemen** » Tue Sep 22, 2009 7:34 pm

Database connections and database size are different things, deleting existing data will not help if too many connections is really your problem. If it is your host needs to increase maximum MySQL connections limit as said before.

But based on your second post and the error you told me the problem might be you are using a wrong mySQL hostname. Try setting "Database host:" in the settings to localhost (just enter word "localhost" without quotes in the field and save changes) and see if that works (it should on most servers).

southernmoney · Post by **southernmoney** » Tue Sep 22, 2009 8:02 pm

Klemen,

I forgot to add that the database host name is set to southermoney.co.za

I have more than one database with the service provider.

Will it be a problem if I change it to localhost?

Tx

jvz

southernmoney · Post by **southernmoney** » Wed Sep 23, 2009 10:06 am

Hi Klemen,

I inserted "localhost" and touch wood I received no further complains.

What I do not understand is that the previous setting worked all this time without a problem. Can it be. Or was it just a bad day at the office. Smile...

Thank your very much for you kind support.

Regards.

jvz

Post by **Klemen** » Wed Sep 23, 2009 11:49 am

What can I say - either it was "localhost" before and someone changed it recently OR the host "southermoney.co.za" is no longer registered in your MySQL.

southernmoney · Post by **southernmoney** » Fri Sep 25, 2009 7:58 am

Hi Klemen,

Everything is still running fine.

Thanks for your support.

Regards.

jvz

PHPJunkyard support forum

Data base connection problem

Data base connection problem

Database Connection Problem

Database Connection Problem

Database Connection Problem

database connection problem