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
