Re: Waiting for localhost
| From: | Ethan Rosenberg | Date: | Thu, 02 Apr 2015 17:48:06 +0000 |
| Subject: | Re: Waiting for localhost | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-49000@lists.php.net to get a copy of this message | ||
On 04/02/2015 06:17 AM, Richard wrote:
<snip>
Richard - Thanks. service Apache2 restartHere 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
This is what was returned on a restart of Apache. Modified the configuration file..... Added this as last line in /etc/apache2/apache2.conf[....] 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
Now on a restart... root@meow:/var/www# service apache2 restartServerName localhost
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{[ ok ] Restarting web server: apache2
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