Re: Waiting for localhost

Bro. Pick a SQL. mysql_ or mysqli_. Best, Karl Sent from losPhone > On Apr 2, 2015, at 12:48 PM, Ethan Rosenberg <erosenberg@hygeiabiomedical.com> wrote: > >> On 04/02/2015 06:17 AM, Richard wrote: > > <snip> >>> Here are some hints.... >>> >>> service apache2 restart >>> [....] Restarting web server: apache2AH00558: apache2: Could not >>> reliably determine the server's fully qualified domain name, using >>> 127.0.1.1. Set the 'ServerName' directive globally to suppress >>> this message >>> . ok >>> >>> >>> using 127.0.1.1 OUCH >>> >>> Added this as last line in /etc/apache2/apache2.conf >>> >>> ServerName localhost >>> >>> root@meow:/var/www# service apache2 restart >>> [ ok ] Restarting web server: apache2 >>> >>> OK ...good >>> >>> But ... I am still getting the same performance - TestConnect [the >>> code above] gives the same result, and HandleWeight hangs!!! >> >> As I pointed out on the apache list, 127.0.1.1 != localhost. It's >> not clear where all you've stapled that incorrect value in at this >> point, but that will account for why apache gave you that error. >> >> In the php code, you are not handling the output from >> mysqli_fetch_array correctly. Read the documentation, there are many >> examples -- including q/a responses that almost exactly match your >> code. >> >> You have shown no debugging effort on "HandleWeight", so we have no >> way of providing any insights on it. >> >> You additionally need to provide the version/release level >> information for your installed versions of: >> >> - OS >> - apache >> - mysql >> - php > > Richard - > > Thanks. > > service Apache2 restart > >> [....] Restarting web server: apache2AH00558: apache2: Could not > >> reliably determine the server's fully qualified domain name, using > >> 127.0.1.1. Set the 'ServerName' directive globally to suppress > >> this message > > This is what was returned on a restart of Apache. > > Modified the configuration file..... > > Added this as last line in /etc/apache2/apache2.conf > >> > >> ServerName localhost > > Now on a restart... > > root@meow:/var/www# service apache2 restart > >> [ ok ] Restarting web server: apache2 > > Fixed the mysqli_fetch_array. > > OS Debian Jessie > Apache/2.4.9 (Debian) > MySQL Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.3 > PHP 5.6.0RC2 (cli) > > Debug > > Here is the connection block w/ debug. > > $hostname="localhost"; > $database="Store"; > $username="ethan"; > $password="xxxxx"; > > > $link = mysqli_connect($hostname, $username, $password); > if (!$link) { > die('Connection failed: ' . mysqli_error()); > } > else{ > echo "Connection to MySQL server " .$hostname . " successful! > " . PHP_EOL; > } > > $db_selected = mysql_select_db( $link,$database); > if (!$db_selected) { > die ('Can\'t select database: ' . mysql_error()); > } > else { > echo 'Database ' . $database . ' successfully selected!'; > } > > Never connects. Hangs > > > TIA > > Ethan > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >