HomeUnityBlogs
 
 
jhiltabidel

How do I disable "pconnect" in order to stop "database connect failed" message ?

My host, inmotionhosting.com suspects pconnect being the problem.  If more than 30 users have this persistent connection to the database, then other connections fail.  That explains why some folks can intermittently connect to my site (including myself!).

Does anyone know how to disable pconnect within Dolphin?  It's not something done on the hosts side.

Thanks,

Joe
bad
1
good
 
 

Comments

Interex
Interex 144 days agocomment permalink
 
Hmm, if it's using mysql_pconnect() it should never open more than 2 connections. using said command would check if there is already a connection to the SQL Database and go that route rather than opening more sockets. Check to make sure you have more than just a few at any given time your site has activity. If this is not the case than your host might actually have issues supplying the database for your site.
 
bad
0
good
 
 
jhiltabidel
jhiltabidel 143 days agocomment permalink
 
Problem resolved. I wish I could attach a screenshot of the powergrep results I found. For those getting the error message "database connect failed" and a maximum connections message ... you have to change 4 references to "pconnect" in the php files to simply "connect". I haven't had a single database error since and users are successfully signing up. Email me if you want to see the screenshot: jhiltabidel@gmail.com ... I don't have time right now to post details... thanks,

joe
 
bad
0
good
 
 
jhiltabidel
jhiltabidel 143 days agocomment permalink
 
I'm pretty sure these are the 4 entries that need to be changed. Can any programmers working on this project verify this as a known issue that needs to be addressed?

admin\modules.php (2 entries for pconnect)
inc\db.inc.php (1 entry for pconnect)
modules\phpbb.aemod (1 entry for pconnect)

In each file, find "pconnect" and remove the p (persistent connection). This has resolved my issue! Woo hoo!
 
bad
0
good
 
View 1 replies to this comment
 
gnesop
gnesop 114 days agocomment permalink
 
Not working to me. Still get database error report
 
bad
0
good
 
 
tvn
tvn 108 days agocomment permalink
 
Thanks, that did the trick for me too!!
 
bad
0
good
 
 
jhiltabidel
jhiltabidel 89 days agocomment permalink
 
I don't think it will have negative impact to modify ALL instances of pconnect -- in fact, powergrep found 11 references for me, too -- but only 4 could I find and modify when I opened the .php files if I recall correctly. I haven't had that error since.
 
bad
0
good
 
 


Post a Comment

Please login to post a comment.

This Post
 
 
jhiltabidel Blog
All Blogs
Found a bug? Have a suggestion? We really value your feedback!
 
© 2008 BoonEx Ltd
ABN 27 127 966 581
 
PET:0.572440862656