Does anyone know if any of the scripts associated with Dolphin, Orca or Ray that causes unclosed connections?
Does anyone know if any of the scripts associated with Dolphin, Orca or Ray that causes unclosed connections? |
yes it uses pconnect or persistent inc/db.inc.php I have video tutorials to help you mrpowless.com |
My host is saying because of "unclosed connections" I am getting the error "too many sql connections".... What should I so here? They said to "fix the script".... yes it uses pconnect or persistent inc/db.inc.php |
open inc/db.inc.php search pconnect and make it connect $this->link = @mysql_pconnect( $this->host . $this->port . $this->sock, $this->user, $this->passwd ); I have video tutorials to help you mrpowless.com |
this may not be your prob, but when I first installed I made a critical error in inputting cron jobs and it started generating that very error too many connections, received an email ever minute about it to...... |
For those not clear what mrp has said: Although make it connect to me means grab it and spank it's behind over and over, but I think the above might have a better overall result. DialMe.com - Your One and Only Source For Boonex Dolphin Tutorials and Resources |
post it and what you did...every lil bit of info on here help this may not be your prob, but when I first installed I made a critical error in inputting cron jobs and it started generating that very error too many connections, received an email ever minute about it to...... I have video tutorials to help you mrpowless.com |
Ok been a while since i did it but believe it was this cron line */10 * * * * /usr/local/bin/php -q /home/chrisleb/public_html/periodic/notifies.php in cpanel it just had boxes to input cron, so what i believe i did was put the * in one box and then a / in other then 10 and so on and this may not be the one, but what i did was changed what should have run every 10min to something that ran ever 1 min and it overloaded mysql, it did email me once every minute once i figured it out i had a 100 emails and no data base connection, the emails tiped me off cause they said too many sql connections.... hope this helps someone else. |
open inc/db.inc.php search pconnect and make it connect $this->link = @mysql_pconnect( $this->host . $this->port . $this->sock, $this->user, $this->passwd ); EXCELLENT! Thanks MRP! And also a thanks to gameutopia for the clarification! (And yes sometimes I think a little corporal punishment would work. LOL) And need we not forget clebarrron for the cron input! Thanks! I am changing the pconnect to connect and will post again if that has remedied the issue. |
Success... this appears to have done away with the error!!!!!!! open inc/db.inc.php search pconnect and make it connect $this->link = @mysql_pconnect( $this->host . $this->port . $this->sock, $this->user, $this->passwd ); EXCELLENT! Thanks MRP! And also a thanks to gameutopia for the clarification! (And yes sometimes I think a little corporal punishment would work. LOL) And need we not forget clebarrron for the cron input! Thanks! I am changing the pconnect to connect and will post again if that has remedied the issue. |