dates1967 / simpleinvoices

Automatically exported from code.google.com/p/simpleinvoices
GNU General Public License v3.0
0 stars 0 forks source link

max_user_connections active connections #197

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
//What steps will reproduce the problem?
1. Please go to http://www.master.flysim.eu
2. User - info@master.flysim.eu
3. Pass - google1
4. See Error message

Installation went fine and was able to load up Simple Invoice login screen, as 
soon as I logged in I got the error message shown below. 

===========================================
 Simple Invoices database connection problem
 ===========================================

 Could not connect to the Simple Invoices database

 For information on how to fix this pease refer to the following database error: 
 --> SQLSTATE[42000] [1203] User masterfl_invo120 already has more than 'max_user_connections' active connections

 If this is an Access denied error please enter the correct database connection details config/config.ini 

Note: If you are installing Simple Invoices please follow the below steps: 
1. Create a blank MySQL database 
2. Enter the correct database connection details in the config/config.ini file 
3. Refresh this page 

 ===========================================

I contacted my web host and they send back this message:
max_user_connections active connections' or similar error message, it means 
your script is not optimized and makes too many connections to the database (or 
your website is very active, has many users online at the same time).

You may want to run mysql_reconnect command before each query in this case. 
Also add command mysql_close()at the end of your script to close all open 
connections.

I can guarantee its not "too many users" online on my site (not public). 
However with no expertise in php I have failed miserably to edit and just keep 
getting worse error messages. Could your team help me? I would much appreciate 
any help. (I'm using fresh install so I can just paste in your code no hassle)

//What is the expected output? What do you see instead?
I expected to login, but just got error instead

//What version of the product are you using? On what operating system?
- PHP version: 5.2.16
- MySQL version: 5.0.92
- Browser: Any
- Operating System: Linux (Server OS)

//Please provide any additional information below.
UNUSED TESTING WEBSITE, NO NEED TO WORRY ABOUT DAMAGES

CPanel
WEB  - http://master.flysim.eu:2082
USER - masterfl
Pass - google1

Simple Invoices
User - info@master.flysim.eu
Pass - google1

Original issue reported on code.google.com by raymondw...@gmail.com on 31 Oct 2011 at 7:50

GoogleCodeExporter commented 9 years ago
Hi Ray,
I've taken a quick look at your setup and cannot see anything that is blatantly 
obvious as causing the problem.
We are aware that there are some performance optimisations that need to be made 
with the SQL queries and this is on the roadmap but I have no date for when 
this will be implemented.

Are you on shared hosting or a dedicated server/VPS?

Matt

Original comment by MattAntW...@gmail.com on 1 Jan 2012 at 9:23

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
I am using a shared hosting server.

I know shared hosting has many more restrictions but I can install all the 
popular software such as Joomla, Wordpress, SMF and about 150 autoscript apps 
absolutely fine.

I own and manage .flysim.eu main domain and it doesn't seem to make a 
difference in sub-domain that’s why I used that for testing you do.

Thank you for looking into it Matt,

Ray

Original comment by raymondw...@gmail.com on 2 Jan 2012 at 12:24

GoogleCodeExporter commented 9 years ago
This problem still alive & should be prioritized. It shut my primary SQL server 
down (a beast of a box):
- PHP version:  5.2.9
- MySQL version:  5.1.33 
- Browser: Any
- Operating System: BSD
- DB reconnect may be in query loop? Only one DB connect required on page load, 
subsequent requests to the same handle will be auto attempted by most 
frameworks. I have not looked at the code. Prob will not. Project is going in  
beautiful directions. 

Original comment by r...@rnetwork.us on 9 Jul 2012 at 10:35

GoogleCodeExporter commented 9 years ago
I receive the same error while trying to deploy SimpleInvoices on Azure 
Websites.

Original comment by jit...@gmail.com on 1 Dec 2012 at 6:17

GoogleCodeExporter commented 9 years ago
Hi Matt,

I too am facing the same issue. Any resolution?

My server configuration is as below:
Apache version  2.2.23
PHP version     5.2.17
MySQL version   5.1.65-rel14.0
Architecture    x86_64
Operating system    linux

I tried searching the forums but did not find any solution. Help would be 
appreciated.

Thanks in advance.

Original comment by gkhan...@gmail.com on 10 May 2013 at 11:16

GoogleCodeExporter commented 9 years ago
I'm also constantly getting this error, and there appears to be no resolution I 
can find apart from changing the max_user_connections value to 0, which 
unfortunately I can't do as I'm also on shared hosting. 

I believe the issue is not your scripts, but just a very restrictive host.

Original comment by christop...@gmail.com on 8 Aug 2014 at 8:21

GoogleCodeExporter commented 9 years ago
And by the way, you wouldn't be using either 000webhost or hosting24 would you? 
I recognise that exact message being given to me more than once.

NOTE: MySQL functions are deprecated and since his host is obviously clueless, 
you should use PDO or MySQL instead.

Original comment by christop...@gmail.com on 8 Aug 2014 at 8:22