From owner-freebsd-questions@FreeBSD.ORG Tue Jul 17 05:52:02 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id ED5CA16A40B for ; Tue, 17 Jul 2007 05:52:01 +0000 (UTC) (envelope-from xrayv19@yahoo.com) Received: from web58115.mail.re3.yahoo.com (web58115.mail.re3.yahoo.com [68.142.236.138]) by mx1.freebsd.org (Postfix) with SMTP id B4D3713C4AA for ; Tue, 17 Jul 2007 05:52:01 +0000 (UTC) (envelope-from xrayv19@yahoo.com) Received: (qmail 15095 invoked by uid 60001); 17 Jul 2007 05:52:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=vKlNWr8LtKtTucYegKKgba8U5htGcLVKKBd723RJJAuD0Losvijcr5QyGwQDHgDFgcxd8gi+JG9ZGilSZbA0VzARc4wnH9vWDdTwp0vplXCaVyUePuX51lzpOaAN136gx37IquYlY77nxs5hb5FylBptSHA6CKG0ybZnzLiCjW8=; X-YMail-OSG: TmQ.TqQVM1nanxb6xmqhAG5KWpYVaPf98C3FutvmXnPQCugrWmRjcfW7Y5OaKUDvtyiVav9rjgu2WPMhkM27fQ6bZg-- Received: from [131.191.24.2] by web58115.mail.re3.yahoo.com via HTTP; Mon, 16 Jul 2007 22:52:00 PDT Date: Mon, 16 Jul 2007 22:52:00 -0700 (PDT) From: L Goodwin To: Joseph Mays , freebsd-questions@freebsd.org In-Reply-To: <005601c7c7d2$7f091630$b12118d8@engineering01> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <819565.13574.qm@web58115.mail.re3.yahoo.com> Cc: Subject: Re: PHP5/MySQL Problem X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 17 Jul 2007 05:52:02 -0000 Please ignore if this problem has already been solved. --- Joseph Mays wrote: > Been dealing with a very frustrating couple of days, > and have hit a wall. I > had a working gallery2 installation, then upgraded > mysqli, and all hell > broke loose. > > When I try to open a page (in this case gallery2) > that connects to the > database. It always says "Too many open links". The > thing is, it even says > that if mysqld is not running. > > I'm running under freebsd 6.1. > > You can examine my server setup at > http://geekfleet.tai-gear.com/server-info > > You can examine the php setup at > http://geekfleet.tai-gear.com/phpinfo.php > > The problem I'm having now is that php5 won't > connect to the mysql server. > It's not a gallery thing, I've confirmed that I have > the exact same problem > with a simple script to just connect to the mysql > server and read the > database. And, in fact, the exact same error occurs > if mysqld is not running > at all. Apache shows -- > > [Mon Jul 16 02:07:10 2007] [error] [client > 66.249.66.10] PHP Warning: > mysql_connect() [ href='function.mysql-connect'>function.mysql-connect]: > Too many > open links (0) in > /usr/local/www/apache22/data/gallery2/lib/adodb/drivers/adodb-mysql.in > c.php on line 366 Note that it says 0 open links is too many. Note also that the file error was reported in is "adodb-mysql.inc.php". I haven't used ado to connect to MySQL but perhaps it does not get the limit from the mysql.max_persistent setting in the MySQL section of php.ini. Check line 366 in adodb-mysql.inc.php and look for a call to "get_ini(" and see what variable it is specifying (or perhaps it's a hardcoded value?). > > > Here is the info in php.ini -- > > [MySQL] > ; Allow or prevent persistent links. > mysql.allow_persistent = Off > > ; Maximum number of persistent links. -1 means no > limit. > mysql.max_persistent = -1 > > ; Maximum number of links (persistent + > non-persistent). -1 means no > limit. > mysql.max_links = -1 > > ; Default port number for mysql_connect(). If > unset, mysql_connect() > will use > ; the $MYSQL_TCP_PORT or the mysql-tcp entry in > /etc/services or the > ; compile-time value defined MYSQL_PORT (in that > order). Win32 will > only look > ; at MYSQL_PORT. > mysql.default_port = > > ; Default socket name for local MySQL connects. If > empty, uses the > built-in > ; MySQL defaults. > mysql.default_socket = > > ; Default host for mysql_connect() (doesn't apply in > safe mode). > mysql.default_host = > > ; Default user for mysql_connect() (doesn't apply in > safe mode). > mysql.default_user = > > ; Default password for mysql_connect() (doesn't > apply in safe mode). > ; Note that this is generally a *bad* idea to store > passwords in this > file. > ; *Any* user with PHP access can run 'echo > get_cfg_var("mysql.default_password") > ; and reveal this password! And of course, any > users with read access > to this > ; file will be able to reveal the password as well. > mysql.default_password = > > ; Maximum time (in secondes) for connect timeout. -1 > means no limit > mysql.connect_timeout = 60 > > ; Trace mode. When trace_mode is active (=On), > warnings for > table/index scans an > d > ; SQL-Errors will be displayed. > mysql.trace_mode = Off > > [MySQLi] > > ; Maximum number of links. -1 means no limit. > mysqli.max_links = -1 > > ; Default port number for mysqli_connect(). If > unset, > mysqli_connect() will use > ; the $MYSQL_TCP_PORT or the mysql-tcp entry in > /etc/services or the > ; compile-time value defined MYSQL_PORT (in that > order). Win32 will > only look > ; at MYSQL_PORT. > mysqli.default_port = 3306 > > ; Default socket name for local MySQL connects. If > empty, uses the > built-in > ; MySQL defaults. > mysqli.default_socket = > > ; Default host for mysql_connect() (doesn't apply in > safe mode). > mysqli.default_host = > > ; Default user for mysql_connect() (doesn't apply in > safe mode). > mysqli.default_user = > > > ; Default password for mysqli_connect() (doesn't > apply in safe mode). > ; Note that this is generally a *bad* idea to store > passwords in this > file. > ; *Any* user with PHP access can run 'echo > get_cfg_var("mysqli.default_pw") > ; and reveal this password! And of course, any > users with read access > to this > ; file will be able to reveal the password as well. > mysqli.default_pw = > > ; Allow or prevent reconnect > mysqli.reconnect = Off > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > ____________________________________________________________________________________ Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. http://sims.yahoo.com/