You are viewing the PKP Support Forum | PKP Home Wiki

DB error

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

DB error

Postby gunkel » Fri Mar 16, 2007 10:35 am

Users of our online journal (zizekstudies.org) are receiving the following error from time to time:

DB error: Too many connections

I'm not quite sure how to address or fix this. Any advice?

Thanks much,
Posts: 10
Joined: Thu Jan 18, 2007 12:43 pm

Postby asmecher » Fri Mar 16, 2007 10:51 am

Hi David,

The best solution would probably be to turn up the number of connections allowed by your MySQL server in its my.cnf configuration file. If you can't do that, you might also try disabling the persistent connection support in OJS's config.inc.php (the "persistent" setting), although this will result in a slight decrease in performance.

Alec Smecher
Open Journal Systems Team
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

further problems

Postby gunkel » Sat Mar 17, 2007 5:55 am

Thanks for the quick reply. Since I am unable to change the number of connectsions allowed by my MySQL server, I tried the second item (disabling the persistent connection support in config.inc.php).

But now I get the following error:

DB Error: Access denied for user: 'ojs@localhost' (Using password: YES)

I tried to go back to the original config.inc.php and I still get the error. So Something is really screwed now.

Posts: 10
Joined: Thu Jan 18, 2007 12:43 pm

follow up

Postby gunkel » Sat Mar 17, 2007 7:00 am

Okay...I've figured out the previous problem. I had made the changes to my local "config.inc.php" file and uploaded it to the server. Unfortunately, it did not have all the configuration data that was entered and stored during set up on the server. And because I did an upload using the same name, I lost the original version that was working on the server (I should know better).

So I have gone in and manually added the right information for the database connection and the location of uploaded files. Everything seems to be working right now, with one exception: I can no longer login. I assume that this is because my login ID and password were also part of the initial set-up and are affected by this new file.

What is the best way to address this? Should I simply go through the ojs installion all over again? Or is there a way to fix this login problem directly in the files. I've looked through "config.inc.php" and it does not look as if the login data is stored in this file.

Any assistance will be greatly appreciated,
Posts: 10
Joined: Thu Jan 18, 2007 12:43 pm


Postby gunkel » Sat Mar 17, 2007 7:51 am

Okay...just ignore me. I found the trouble. It was with the encryption setting. The default was md5. All I needed to do was change it to sha1.

Sorry for the hastle. As I tell my own students, you learn much more by figuring out the problem yourself. And this has really been a good learning experience for me.

Thanks for all your help,
Posts: 10
Joined: Thu Jan 18, 2007 12:43 pm

Re: DB error: DB Error: Too many connections

Postby cadewumi » Sun Mar 08, 2015 3:55 am

Hello Alec,

I have not been able to access http://journals.sfu.ca/africanem/index.php/ajtcam for the past 4 hours. This has made our work impossible. Could you please help resolve it The Journal is hosted by sfu
Posts: 16
Joined: Fri Sep 23, 2005 1:06 am
Location: Ile-Ife, Nigeria

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 1 guest