Re: Trouble with mysql_pconnect unable to connect to database?

never mind got it "localhost:/pathto/mysql.sock" duh? :) Thanks a million, I'm up and running. ----- Original Message ----- From: "Rasmus Lerdorf" <rasmus@lerdorf.ca> To: "Jim Hankins" <jhankins@hankinsbay.com> Cc: <php-general@lists.php.net> Sent: Saturday, March 23, 2002 10:50 PM Subject: Re: [PHP] Trouble with mysql_pconnect unable to connect to database? > Figure out where your mysql.sock file is and provide the path right in > your mysql_connect() call. "mysqladmin version" tells you the path. > > -Rasmus > > On Sat, 23 Mar 2002, Jim Hankins wrote: > > > I'm doing a simple database connection using the follow syntax: > > > > <html> > > <head> > > <title>Book-O-Rama Search Results</title> > > </head> > > <body> > > <h1>Book-O-Rama Search Results</h1> > > <? > > if (!$searchtype || !$searchterm) > > { > > echo "You have not entered search details. Please go back and try > > again."; > > exit; > > } > > > > $searchtype = addslashes($searchtype); > > $searchterm = addslashes($searchterm); > > > > @ $db = mysql_pconnect("localhost", "bookorama", > > "bookorama123"); > > > > if (!$db) > > { > > echo "Error: Could not connect to database. Please try again later."; > > exit; > > } > > > > When I go to the search page and hit submit (after removing the @ to see an > > error on the mysql_pconnect line) > > I get Warning: Can't connect to local MySQL server through socket > > '/tmp/mysql.sock' (2) in /home/jhankins/public_html/mydirectory/results.php > > on line 17 > > > > I can telnet to the host and with the same username and password access the > > database tables etc. What gives? I'm using > > 4.0.6 of PHP and apache under Redhat Linux 7.2. Mysql is working fine from > > command line and remote via odbc? > > > > Also tryed mysql_connect with same problem. > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > >