By chunkymonkey4u2 on

I have been having problems with urls and my max_user_connections lately. Firstly, all my urls for my content were reset to their original spots with ".aspx". I can't edit them back, and I have no idea what happened.

Now I keep getting these max_user_connection errors every so often. I have no idea what is causing this or how to fix it. I was hoping it would go away after a few weeks, but it's only gotten worse. Can someone please help me?

This is what the max_user_connections error looks like:
Warning: mysql_connect(): User drcimagi_drupal has already more than 'max_user_connections' active connections in /home/pooliti/public_html/includes/database.mysql.inc on line 31
User drcimagi_drupal has already more than 'max_user_connections' active connections

Someone please help, I have no idea what to do.

Thanks,
Jeff

Comments

chunkymonkey4u2’s picture

chunkymonkey4u2 commented

Looks like I'm going to have to figure this out myself. ._.;

nevets’s picture

nevets commented

Make a file in your sites home directory (same place where index.php is found) called phpinfo.php. Place the following in the file

<?php
	phpinfo();
?>

Now point your browser to http://www.yoursite.com/phpinfo.php

Look down for the section on mysql and the values of mysql.connect_timeout, mysql.max_links and mysql.max_persistent (if mysql.allow_persistent is ON). So what are the three values?
If either of the later is not unlimited and the number is small this will cause you problems. If mysql.connect_time is -1 (no timeout) is likely to aggrevate any problems.

chunkymonkey4u2’s picture

chunkymonkey4u2 commented

I was being flooded by a bot, and it kept exceeding my max_user_connections. I've now banned that ip but my current problem is the aliases. No matter what I change them to, they always revert back to their original spots(with the .aspx). Any ideas what's wrong?

nevets’s picture

nevets commented

Are you saying that you had a URL alias ending in .aspx, changed it to something else and it is changing back?

Do you have a URL that demostrates this?

Do you have just your drupal files installed for the web site or do you have old files also. It sounds like a windows box and a ASP.NET site was there in the past and you may have some configuration files still around.

chunkymonkey4u2’s picture

chunkymonkey4u2 commented

Are you saying that you had a URL alias ending in .aspx, changed it to something else and it is changing back?

Yes, this is my problem.

Do you have a URL that demostrates this?

http://rcimaginations.net/page/3/movies.aspx

This url use to be: http://rcimaginations.net/movies
but it won't change back.

Do you have just your drupal files installed for the web site or do you have old files also. It sounds like a windows box and a ASP.NET site was there in the past and you may have some configuration files still around.

I have no idea what you mean. :P

nevets’s picture

nevets commented

To try and help you more it would help to have admin access to the site. Do you have the path auto module installed or just the path module? If you have the path auto module what do you have set up for the default path alias?

chunkymonkey4u2’s picture

chunkymonkey4u2 commented

The default path pattern for nodes is: [type]/[nid]/[title].aspx

nevets’s picture

nevets commented

From what you have written, it sounds like you checked bulked update when you set the pattern.

Why you can not edit the path is another question, I have a 6.3 setup and can change the path just fine.

At this point, if you visist administer -> settings -> pathauto are any checkboxes checked and which radio buttons set?

chunkymonkey4u2’s picture

chunkymonkey4u2 commented

Checked:
Verbose
Create feed aliases
Create index aliases
Update Action Radio:
Create a new alias, replacing the old one

nevets’s picture

nevets commented

For the setting of 'Update action' set it to
'Do nothing, leaving the old alias intact'. I am pretty sure the current value is what is causing the hand edits to have no impact.

chunkymonkey4u2’s picture

chunkymonkey4u2 commented

Thanks for your help. I will reply when anymore problems occur.

prasoon gupta’s picture

prasoon gupta commented

Since more than a year.. I never recieved any problem like this but today has gone offline ..

"Site off-line

The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.

The mysql error was: User computl9_drpl1 already has more than 'max_user_connections' active connections."

You asked to check PHP INFO :

the values are
mysql.connect_timeout 60
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited

I have shared hosting on Bluehost. What can I do ?

nevets’s picture

nevets commented

I would contact your hosting provider.

chunkymonkey4u2’s picture

chunkymonkey4u2 commented

>.>