On 03/30/2015 03:26 AM, Marcos Almeida Azevedo wrote:
On Mon, Mar 30, 2015 at 11:51 AM, Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx <mailto:erosenberg@xxxxxxxxxxxxxxxxxxxx>> wrote: Dear List - When I call another page in PHP, Apache can take 5 to 10 minutes to open the page. Example: <script type="text/javascript"> <!-- window.location.assign("http:/__/localhost/HandleWeight.php <http://localhost/HandleWeight.php>"); //-->\ </script> can take 5 - 10 min. Would it be possible that the PHP script is the one slow? Could you measure the execution time of the script? > root@meow:/var/www# /usr/sbin/apache2 -V > Config variable ${APACHE_LOCK_DIR} is not defined > --> Mutex file:${APACHE_LOCK_DIR} default > > Config variable ${APACHE_PID_FILE} is not defined > --> # PidFile: The file in which the server should record its > process > # identification number when it starts. > # This needs to be set in /etc/apache2/envvars > # > PidFile ${APACHE_PID_FILE} > /etc/apache2/envvars > --> export APACHE_PID_FILE=/var/run/__apache2/apache2$SUFFIX.pid > > > Config variable ${APACHE_RUN_USER} is not defined > Config variable ${APACHE_RUN_GROUP} is not defined > --> # These need to be set in /etc/apache2/envvars > User ${APACHE_RUN_USER} > Group ${APACHE_RUN_GROUP} > /etc/apache2/envvars > --> export APACHE_RUN_USER=www-data > export APACHE_RUN_GROUP=www-data > > > Config variable ${APACHE_LOG_DIR} is not defined >> this error > message appears 5 times?? > --> ErrorLog ${APACHE_LOG_DIR}/error.log > > > AH00526: Syntax error on line 74 of /etc/apache2/apache2.conf > --> I tried to strip out the comments, and came up with less than > 74 lines. > > > Invalid Mutex directory in argument file:${APACHE_LOCK_DIR} > --> See above. > root@meow:/home/ethan/BluBev# ps -A |grep apache2 11972 ? 00:00:30 apache2 22196 ? 00:00:00 apache2 22197 ? 00:00:00 apache2 22198 ? 00:00:00 apache2 22199 ? 00:00:00 apache2 22200 ? 00:00:00 apache2 Totally confused. TIA Ethan
--- Marcos - Thanks.Would it be possible that the PHP script is the one slow? Could you measure the execution time of the script?
Great idea. How?? TIA Ethan Some more info.... Changed the host in the connect $cxn = mysqli_connect($host,$user,$password); $host="127.0.1.1"; Now get an error...Warning: mysqli_connect(): (HY000/2003): Can't connect to MySQL server on '127.0.1.1' (111) in /var/www/HandleWeight.php on line 56
Connect Error (2003) Can't connect to MySQL server on '127.0.1.1' (111) Also ... root@meow:/home/ethan/BluBev# netstat -ln | grep mysql unix 2 [ ACC ] STREAM LISTENING 10347 /var/run/mysqld/mysqld.sock I hope this clears the waters and does not muddy them more. Again TIA Ethan --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx