I did the same test again with the settings (mod_fcgid and php) as
given , then I reset the setting back to the defaults and there was
not change. This leaves the issue with mysql as it's the only resource
that is called by phpwiki.
I have noted that php-cgi spikes upto 90% cpu utilization for the
majority to the run time.
Thanks
G
On Wed, Nov 16, 2011 at 3:26 PM, Jeff Dyke <jeff.dyke@xxxxxxxxx> wrote:
> I guess my question is more about what that page is doing. Connecting
> to a DB, a cache, LDAP and are those failing to return a valid
> connection within the page/server connection timeout time. If you
> turn down all of your timeouts does it occur in much shorter time then
> currently?
>
>
> On Tue, Nov 15, 2011 at 9:09 PM, Gregory Machin <gdm@xxxxxxxxxxxxxx> wrote:
>> Hi Jeff.
>> I have gone through the php.ini and I have set all the values
>> insanely high. I have used phpinfo(); to check that it's reading the
>> correct file and it is.
>>
>> phpinfo output:
>>
>> PHP Version 5.3.3-1ubuntu9.6
>>
>> System Linux nzhmlapp04 2.6.35-30-generic #60-Ubuntu SMP Mon Sep 19
>> 20:42:44 UTC 2011 x86_64
>> Build Date Oct 14 2011 22:31:37
>> Server API CGI/FastCGI
>> Virtual Directory Support disabled
>> Configuration File (php.ini) Path /etc/php5/cgi
>> Loaded Configuration File /home/phpwiki/etc/php5/php.ini
>> Scan this dir for additional .ini files /etc/php5/cgi/conf.d
>> Additional .ini files parsed /etc/php5/cgi/conf.d/mcrypt.ini,
>> /etc/php5/cgi/conf.d/mysql.ini, /etc/php5/cgi/conf.d/mysqli.ini,
>> /etc/php5/cgi/conf.d/pdo.ini, /etc/php5/cgi/conf.d/pdo_mysql.ini,
>> /etc/php5/cgi/conf.d/pdo_sqlite.ini, /etc/php5/cgi/conf.d/sqlite.ini,
>> /etc/php5/cgi/conf.d/sqlite3.ini
>> PHP API 20090626
>> PHP Extension 20090626
>> Zend Extension 220090626
>> Zend Extension Build API220090626,NTS
>> PHP Extension Build API20090626,NTS
>> Debug Build no
>> Thread Safety disabled
>> Zend Memory Manager enabled
>> Zend Multibyte Support disabled
>> IPv6 Support enabled
>> Registered PHP Streams https, ftps, compress.zlib, compress.bzip2,
>> php, file, glob, data, http, ftp, phar, zip
>> Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
>> Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*,
>> string.rot13, string.toupper, string.tolower, string.strip_tags,
>> convert.*, consumed, dechunk, mcrypt.*, mdecrypt.*
>>
>> Suhosin logo This server is protected with the Suhosin Patch 0.9.9.1
>> Copyright (c) 2006-2007 Hardened-PHP Project Copyright (c) 2007-2009
>> SektionEins GmbH
>>
>> Zend logo This program makes use of the Zend Scripting Language Engine:
>> Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
>>
>> PHP Credits
>> Configuration
>> bcmath
>> BCMath support enabled
>>
>> Directive Local Value Master Value
>> bcmath.scale 0 0
>>
>> bz2
>> BZip2 Support Enabled
>> Stream Wrapper support compress.bz2://
>> Stream Filter support bzip2.decompress, bzip2.compress
>> BZip2 Version 1.0.5, 10-Dec-2007
>>
>> calendar
>> Calendar support enabled
>>
>> cgi-fcgi
>> Directive Local Value Master Value
>> cgi.check_shebang_line 1 1
>> cgi.discard_path 0 0
>> cgi.fix_pathinfo 1 1
>> cgi.force_redirect 1 1
>> cgi.nph 0 0
>> cgi.redirect_status_env no value no value
>> cgi.rfc2616_headers 0 0
>> fastcgi.logging 1 1
>>
>> Core
>> PHP Version 5.3.3-1ubuntu9.6
>>
>> Directive Local Value Master Value
>> allow_call_time_pass_reference Off Off
>> allow_url_fopen On On
>> allow_url_include Off Off
>> always_populate_raw_post_data Off Off
>> arg_separator.input & &
>> arg_separator.output & &
>> asp_tags Off Off
>> auto_append_file no value no value
>> auto_globals_jit On On
>> auto_prepend_file no value no value
>> browscap no value no value
>> default_charset no value no value
>> default_mimetype text/html text/html
>> define_syslog_variables Off Off
>> disable_classes no value no value
>> disable_functions no value no value
>> display_errors Off Off
>> display_startup_errors Off Off
>> doc_root no value no value
>> docref_ext no value no value
>> docref_root no value no value
>> enable_dl Off Off
>> error_append_string no value no value
>> error_log /home/phpwiki/logs/php_errors.log /home/phpwiki/logs/php_errors.log
>> error_prepend_string no value no value
>> error_reporting 22527 22527
>> exit_on_timeout Off Off
>> expose_php On On
>> extension_dir /usr/lib/php5/20090626 /usr/lib/php5/20090626
>> file_uploads On On
>> highlight.bg #FFFFFF #FFFFFF
>> highlight.comment #FF8000 #FF8000
>> highlight.default #0000BB #0000BB
>> highlight.html #000000 #000000
>> highlight.keyword #007700 #007700
>> highlight.string #DD0000 #DD0000
>> html_errors On On
>> ignore_repeated_errors Off Off
>> ignore_repeated_source Off Off
>> ignore_user_abort Off Off
>> implicit_flush Off Off
>> include_path .:/usr/share/php:/usr/share/pear .:/usr/share/php:/usr/share/pear
>> log_errors On On
>> log_errors_max_len 1024 1024
>> magic_quotes_gpc Off Off
>> magic_quotes_runtime Off Off
>> magic_quotes_sybase Off Off
>> mail.add_x_header On On
>> mail.force_extra_parameters no value no value
>> mail.log no value no value
>> max_execution_time 601 601
>> max_file_uploads 20 20
>> max_input_nesting_level 64 64
>> max_input_time 600 600
>> memory_limit 128M 128M
>> open_basedir no value no value
>> output_buffering 4096 4096
>> output_handler no value no value
>> post_max_size 32M 32M
>> precision 14 14
>> realpath_cache_size 16K 16K
>> realpath_cache_ttl 120 120
>> register_argc_argv Off Off
>> register_globals Off Off
>> register_long_arrays Off Off
>> report_memleaks On On
>> report_zend_debug On On
>> request_order GP GP
>> safe_mode Off Off
>> safe_mode_exec_dir no value no value
>> safe_mode_gid Off Off
>> safe_mode_include_dir no value no value
>> sendmail_from no value no value
>> sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
>> serialize_precision 100 100
>> short_open_tag On On
>> SMTP localhost localhost
>> smtp_port 25 25
>> sql.safe_mode Off Off
>> track_errors Off Off
>> unserialize_callback_func no value no value
>> upload_max_filesize 32M 32M
>> upload_tmp_dir /home/phpwiki/tmp /home/phpwiki/tmp
>> user_dir no value no value
>> user_ini.cache_ttl 300 300
>> user_ini.filename .user.ini .user.ini
>> variables_order GPCS GPCS
>> xmlrpc_error_number 0 0
>> xmlrpc_errors Off Off
>> y2k_compliance On On
>> zend.enable_gc On On
>>
>> ctype
>> ctype functions enabled
>>
>> date
>> date/time support enabled
>> "Olson" Timezone Database Version 0.system
>> Timezone Database internal
>> Default timezone Pacific/Auckland
>>
>> Directive Local Value Master Value
>> date.default_latitude 31.7667 31.7667
>> date.default_longitude 35.2333 35.2333
>> date.sunrise_zenith 90.583333 90.583333
>> date.sunset_zenith 90.583333 90.583333
>> date.timezone no value no value
>>
>> dba
>> DBA support enabled
>> Supported handlers cdb cdb_make db4 inifile flatfile
>>
>> Directive Local Value Master Value
>> dba.default_handler flatfile flatfile
>>
>> dom
>> DOM/XML enabled
>> DOM/XML API Version 20031129
>> libxml Version 2.7.7
>> HTML Support enabled
>> XPath Support enabled
>> XPointer Support enabled
>> Schema Support enabled
>> RelaxNG Support enabled
>>
>> ereg
>> Regex Library Bundled library enabled
>>
>> exif
>> EXIF Support enabled
>> EXIF Version 1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $
>> Supported EXIF Version 0220
>> Supported filetypes JPEG,TIFF
>>
>> Directive Local Value Master Value
>> exif.decode_jis_intel JIS JIS
>> exif.decode_jis_motorola JIS JIS
>> exif.decode_unicode_intel UCS-2LE UCS-2LE
>> exif.decode_unicode_motorola UCS-2BE UCS-2BE
>> exif.encode_jis no value no value
>> exif.encode_unicode ISO-8859-15 ISO-8859-15
>>
>> fileinfo
>> fileinfo support enabled
>> version 1.0.5-dev
>>
>> filter
>> Input Validation and Filtering enabled
>> Revision $Revision: 298196 $
>>
>> Directive Local Value Master Value
>> filter.default unsafe_raw unsafe_raw
>> filter.default_flags no value no value
>>
>> ftp
>> FTP support enabled
>>
>> gettext
>> GetText Support enabled
>>
>> hash
>> hash support enabled
>> Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512
>> ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3
>> tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru
>> snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3
>> haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4
>> haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5
>> haval224,5 haval256,5
>>
>> iconv
>> iconv support enabled
>> iconv implementation glibc
>> iconv library version 2.12.1
>>
>> Directive Local Value Master Value
>> iconv.input_encoding ISO-8859-1 ISO-8859-1
>> iconv.internal_encoding ISO-8859-1 ISO-8859-1
>> iconv.output_encoding ISO-8859-1 ISO-8859-1
>>
>> json
>> json support enabled
>> json version 1.2.1
>>
>> libxml
>> libXML support active
>> libXML Compiled Version 2.7.7
>> libXML Loaded Version 20707
>> libXML streams enabled
>>
>> mbstring
>> Multibyte Support enabled
>> Multibyte string engine libmbfl
>> HTTP input encoding translation disabled
>>
>> mbstring extension makes use of "streamable kanji code filter and
>> converter", which is distributed under the GNU Lesser General Public
>> License version 2.1.
>>
>> Multibyte (japanese) regex support enabled
>> Multibyte regex (oniguruma) backtrack check On
>> Multibyte regex (oniguruma) version 4.7.1
>>
>> Directive Local Value Master Value
>> mbstring.detect_order no value no value
>> mbstring.encoding_translation Off Off
>> mbstring.func_overload 0 0
>> mbstring.http_input pass pass
>> mbstring.http_output pass pass
>> mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml)
>> mbstring.internal_encoding no value no value
>> mbstring.language neutral neutral
>> mbstring.strict_detection Off Off
>> mbstring.substitute_character no value no value
>>
>> mcrypt
>> mcrypt support enabled
>> mcrypt_filter support enabled
>> Version 2.5.8
>> Api No 20021217
>> Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256
>> loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256
>> serpent xtea blowfish enigma rc2 tripledes
>> Supported modes cbc cfb ctr ecb ncfb nofb ofb stream
>>
>> Directive Local Value Master Value
>> mcrypt.algorithms_dir no value no value
>> mcrypt.modes_dir no value no value
>>
>> mhash
>> MHASH support Enabled
>> MHASH API Version Emulated Support
>>
>> mysql
>> MySQL Support enabled
>> Active Persistent Links 0
>> Active Links 0
>> Client API version 5.1.49
>> MYSQL_MODULE_TYPE external
>> MYSQL_SOCKET /var/run/mysqld/mysqld.sock
>> MYSQL_INCLUDE -I/usr/include/mysql
>> MYSQL_LIBS -L/usr/lib -lmysqlclient_r
>>
>> Directive Local Value Master Value
>> mysql.allow_local_infile On On
>> mysql.allow_persistent On On
>> mysql.connect_timeout 60 60
>> mysql.default_host no value no value
>> mysql.default_password no value no value
>> mysql.default_port no value no value
>> mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
>> mysql.default_user no value no value
>> mysql.max_links Unlimited Unlimited
>> mysql.max_persistent Unlimited Unlimited
>> mysql.trace_mode Off Off
>>
>> mysqli
>> MysqlI Support enabled
>> Client API library version 5.1.49
>> Active Persistent Links 0
>> Inactive Persistent Links 0
>> Active Links 0
>> Client API header version 5.1.49
>> MYSQLI_SOCKET /var/run/mysqld/mysqld.sock
>>
>> Directive Local Value Master Value
>> mysqli.allow_local_infile On On
>> mysqli.allow_persistent On On
>> mysqli.default_host no value no value
>> mysqli.default_port 3306 3306
>> mysqli.default_pw no value no value
>> mysqli.default_socket no value no value
>> mysqli.default_user no value no value
>> mysqli.max_links Unlimited Unlimited
>> mysqli.max_persistent Unlimited Unlimited
>> mysqli.reconnect Off Off
>>
>> openssl
>> OpenSSL support enabled
>> OpenSSL Library Version OpenSSL 0.9.8o 01 Jun 2010
>> OpenSSL Header Version OpenSSL 0.9.8o 01 Jun 2010
>>
>> pcre
>> PCRE (Perl Compatible Regular Expressions) Support enabled
>> PCRE Library Version 8.02 2010-03-19
>>
>> Directive Local Value Master Value
>> pcre.backtrack_limit 100000 100000
>> pcre.recursion_limit 100000 100000
>>
>> PDO
>> PDO support enabled
>> PDO drivers mysql, sqlite, sqlite2
>>
>> pdo_mysql
>> PDO Driver for MySQL enabled
>> Client API version 5.1.49
>>
>> pdo_sqlite
>> PDO Driver for SQLite 3.x enabled
>> SQLite Library 3.7.2
>>
>> Phar
>> Phar: PHP Archive support enabled
>> Phar EXT version 2.0.1
>> Phar API version 1.1.1
>> SVN revision $Revision: 298908 $
>> Phar-based phar archives enabled
>> Tar-based phar archives enabled
>> ZIP-based phar archives enabled
>> gzip compression enabled
>> bzip2 compression enabled
>> OpenSSL support enabled
>>
>> Phar based on pear/PHP_Archive, original concept by Davey Shafik.
>> Phar fully realized by Gregory Beaver and Marcus Boerger.
>> Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
>>
>> Directive Local Value Master Value
>> phar.cache_list no value no value
>> phar.readonly On On
>> phar.require_hash On On
>>
>> posix
>> Revision $Revision: 300764 $
>>
>> Reflection
>> Reflection enabled
>> Version $Revision: 300393 $
>>
>> session
>> Session Support enabled
>> Registered save handlers files user sqlite
>> Registered serializer handlers php php_binary wddx
>>
>> Directive Local Value Master Value
>> session.auto_start Off Off
>> session.bug_compat_42 Off Off
>> session.bug_compat_warn Off Off
>> session.cache_expire 180 180
>> session.cache_limiter nocache nocache
>> session.cookie_domain no value no value
>> session.cookie_httponly Off Off
>> session.cookie_lifetime 0 0
>> session.cookie_path / /
>> session.cookie_secure Off Off
>> session.entropy_file no value no value
>> session.entropy_length 0 0
>> session.gc_divisor 1000 1000
>> session.gc_maxlifetime 1440 1440
>> session.gc_probability 1 1
>> session.hash_bits_per_character 5 5
>> session.hash_function 0 0
>> session.name PHPSESSID PHPSESSID
>> session.referer_check no value no value
>> session.save_handler files files
>> session.save_path /home/phpwiki/tmp /home/phpwiki/tmp
>> session.serialize_handler php php
>> session.use_cookies On On
>> session.use_only_cookies On On
>> session.use_trans_sid 0 0
>>
>> shmop
>> shmop support enabled
>>
>> SimpleXML
>> Simplexml support enabled
>> Revision $Revision: 299424 $
>> Schema support enabled
>>
>> soap
>> Soap Client enabled
>> Soap Server enabled
>>
>> Directive Local Value Master Value
>> soap.wsdl_cache 1 1
>> soap.wsdl_cache_dir /tmp /tmp
>> soap.wsdl_cache_enabled 1 1
>> soap.wsdl_cache_limit 5 5
>> soap.wsdl_cache_ttl 86400 86400
>>
>> sockets
>> Sockets Support enabled
>>
>> SPL
>> SPL support enabled
>> Interfaces Countable, OuterIterator, RecursiveIterator,
>> SeekableIterator, SplObserver, SplSubject
>> Classes AppendIterator, ArrayIterator, ArrayObject,
>> BadFunctionCallException, BadMethodCallException, CachingIterator,
>> DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator,
>> FilterIterator, GlobIterator, InfiniteIterator,
>> InvalidArgumentException, IteratorIterator, LengthException,
>> LimitIterator, LogicException, MultipleIterator, NoRewindIterator,
>> OutOfBoundsException, OutOfRangeException, OverflowException,
>> ParentIterator, RangeException, RecursiveArrayIterator,
>> RecursiveCachingIterator, RecursiveDirectoryIterator,
>> RecursiveFilterIterator, RecursiveIteratorIterator,
>> RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator,
>> RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject,
>> SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage,
>> SplPriorityQueue, SplQueue, SplStack, SplTempFileObject,
>> UnderflowException, UnexpectedValueException
>>
>> SQLite
>> SQLite support enabled
>> PECL Module version 2.0-dev $Id: sqlite.c 298697 2010-04-28 12:10:10Z iliaa $
>> SQLite Library 2.8.17
>> SQLite Encoding UTF-8
>>
>> Directive Local Value Master Value
>> sqlite.assoc_case 0 0
>>
>> sqlite3
>> SQLite3 support enabled
>> SQLite3 module version 0.7-dev
>> SQLite Library 3.7.2
>>
>> Directive Local Value Master Value
>> sqlite3.extension_dir no value no value
>>
>> standard
>> Dynamic Library Support enabled
>> Path to sendmail /usr/sbin/sendmail -t -i
>>
>> Directive Local Value Master Value
>> assert.active 1 1
>> assert.bail 0 0
>> assert.callback no value no value
>> assert.quiet_eval 0 0
>> assert.warning 1 1
>> auto_detect_line_endings 0 0
>> default_socket_timeout 240 240
>> safe_mode_allowed_env_vars PHP_ PHP_
>> safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
>> url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
>> user_agent no value no value
>>
>> sysvmsg
>> sysvmsg support enabled
>> Revision $Revision: 293036 $
>>
>> tokenizer
>> Tokenizer Support enabled
>>
>> wddx
>> WDDX Support enabled
>> WDDX Session Serializer enabled
>>
>> xml
>> XML Support active
>> XML Namespace Support active
>> libxml2 Version 2.7.7
>>
>> xmlreader
>> XMLReader enabled
>>
>> xmlwriter
>> XMLWriter enabled
>>
>> zip
>> Zip enabled
>> Extension Version $Id: php_zip.c 300470 2010-06-15 18:48:33Z pajoye $
>> Zip version 1.9.1
>> Libzip version 0.9.0
>>
>> zlib
>> ZLib Support enabled
>> Stream Wrapper support compress.zlib://
>> Stream Filter support zlib.inflate, zlib.deflate
>> Compiled Version 1.2.1.1
>> Linked Version 1.2.3.4
>>
>> Directive Local Value Master Value
>> zlib.output_compression Off Off
>> zlib.output_compression_level -1 -1
>> zlib.output_handler no value no value
>>
>> Additional Modules
>> Module Name
>> sysvsem
>> sysvshm
>>
>> Environment
>> Variable Value
>> PHPRC /home/phpwiki/fcgi-bin/../etc/php5
>> SCRIPT_FILENAME no value
>> PHP_FCGI_CHILDREN 8
>> PATH /usr/local/bin:/usr/bin:/bin
>> PWD /home/phpwiki/fcgi-bin
>> SHLVL 0
>> PHP_FCGI_MAX_REQUESTS 5000
>>
>> PHP Variables
>> Variable Value
>> _COOKIE["__utma"] 1.1650060653.1315975034.1318825725.1319486824.3
>> _COOKIE["__utmz"] 1.1315975034.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
>> _COOKIE["WRUID"] 266346829.661610187
>> _COOKIE["EndaceWiki_WIKI_ID"] admin
>> _COOKIE["PHPSESSID"] 217d10ubuosjqqfvvfv0gi5385
>> _SERVER["PHPRC"] /home/phpwiki/fcgi-bin/../etc/php5
>> _SERVER["SCRIPT_FILENAME"] /home/phpwiki/public_html/phpinfo.php
>> _SERVER["PHP_FCGI_CHILDREN"] 8
>> _SERVER["PATH"] /bin:/usr/bin
>> _SERVER["PWD"] /home/phpwiki/fcgi-bin
>> _SERVER["SHLVL"] 0
>> _SERVER["PHP_FCGI_MAX_REQUESTS"] 5000
>> _SERVER["FCGI_ROLE"] RESPONDER
>> _SERVER["SCRIPT_URL"] /phpinfo.php
>> _SERVER["SCRIPT_URI"] http://test-phpwiki.example.com/phpinfo.php
>> _SERVER["HTTP_HOST"] test-phpwiki.example.com
>> _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0)
>> Gecko/20100101 Firefox/8.0
>> _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
>> _SERVER["HTTP_ACCEPT_LANGUAGE"] en-us,en;q=0.5
>> _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
>> _SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
>> _SERVER["HTTP_CONNECTION"] close
>> _SERVER["HTTP_COOKIE"] __utma=1.1650060653.1315975034.1318825725.1319486824.3;
>> __utmz=1.1315975034.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none);
>> WRUID=266346829.661610187; EndaceWiki_WIKI_ID=admin;
>> PHPSESSID=217d10ubuosjqqfvvfv0gi5385
>> _SERVER["HTTP_CACHE_CONTROL"] max-age=0
>> _SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.16 (Ubuntu) Server at
>> test-phpwiki.example.com Port 80</address>
>> _SERVER["SERVER_SOFTWARE"] Apache/2.2.16 (Ubuntu)
>> _SERVER["SERVER_NAME"] test-phpwiki.example.com
>> _SERVER["SERVER_ADDR"] 192.168.32.22
>> _SERVER["SERVER_PORT"] 80
>> _SERVER["REMOTE_ADDR"] 192.168.69.237
>> _SERVER["DOCUMENT_ROOT"] /home/phpwiki/public_html
>> _SERVER["SERVER_ADMIN"] [no address given]
>> _SERVER["REMOTE_PORT"] 50876
>> _SERVER["GATEWAY_INTERFACE"] CGI/1.1
>> _SERVER["SERVER_PROTOCOL"] HTTP/1.1
>> _SERVER["REQUEST_METHOD"] GET
>> _SERVER["QUERY_STRING"] no value
>> _SERVER["REQUEST_URI"] /phpinfo.php
>> _SERVER["SCRIPT_NAME"] /phpinfo.php
>> _SERVER["PHP_SELF"] /phpinfo.php
>> _SERVER["REQUEST_TIME"] 1321408932
>>
>>
>>
>> On Wed, Nov 16, 2011 at 2:10 PM, Jeff Dyke <jeff.dyke@xxxxxxxxx> wrote:
>>> 31 seconds is likely not a coincidence that its a default timeout to a
>>> lot of things, core PHP included.
>>>
>>> I know every little about PHPWiki, but suspect its trying to connect
>>> to something and the default timeout it giving up after 30 seconds.
>>> This is an interesting setting:
>>> IPCCommTimeout 31
>>>
>>> what does that control?
>>>
>>> On Tue, Nov 15, 2011 at 7:36 PM, Gregory Machin <gdm@xxxxxxxxxxxxxx> wrote:
>>>> Hi.
>>>> I'm running Apache/2.2.16 (Ubuntu) , libapache2-mod-fcgid
>>>> 1:2.3.5-2ubuntu0.1, php5-cgi 5.3.3-1ubuntu9.6. on Ubuntu 10.10 LTS,
>>>> in a Virtualmin LAMP stack. Each Virtualhost runs suexec, thus the
>>>> need for mod-fcgid so that each site is running under its own user
>>>> account.
>>>>
>>>> I have a clean install of PHPWiki , latest stable version. I'm trying
>>>> to import the data from the old install of PHPWiki (3.2 MB zip), using
>>>> the restore feature, every time I try the restore the process crashes
>>>> with "500 Internal server error" the the following in the logs :
>>>>
>>>> [Wed Nov 16 10:21:14 2011] [warn] [client 192.168.69.237] mod_fcgid:
>>>> read data timeout in 31 seconds, referer:
>>>> http://test-phpwiki.example.com/index.php/PhpWikiAdministration
>>>> [Wed Nov 16 10:21:14 2011] [warn] [client 192.168.69.237]
>>>> (110)Connection timed out: mod_fcgid: ap_pass_brigade failed in
>>>> handle_request function, referer:
>>>> http://test-phpwiki.example.com/index.php/PhpWikiAdministration
>>>>
>>>>
>>>> I have adjusted every setting I can find in php, mod-fcgid, and
>>>> apache. I'v googled for the last day and a half with no clear answer.
>>>>
>>>> Configuration as follows:
>>>>
>>>> root@nzhmlapp04:/home/phpwiki# cat fcgi-bin/php5.fcgi
>>>> #!/bin/bash
>>>> PHPRC=$PWD/../etc/php5
>>>> export PHP_FCGI_MAX_REQUESTS=5000
>>>> export PHP_FCGI_CHILDREN=8
>>>> export PHPRC
>>>> umask 022
>>>> SCRIPT_FILENAME=$PATH_TRANSLATED
>>>> export SCRIPT_FILENAME
>>>> exec /usr/bin/php5-cgi
>>>>
>>>> root@nzhmlapp04:/home/phpwiki# cat /etc/apache2/mods-enabled/fcgid.conf
>>>> <IfModule mod_fcgid.c>
>>>> AddHandler fcgid-script .fcgi
>>>> FcgidConnectTimeout 300
>>>> MaxRequestLen 1000000000
>>>> IdleTimeout 3600
>>>> ProcessLifeTime 7200
>>>> MaxProcessCount 1000
>>>> DefaultMinClassProcessCount 3
>>>> DefaultMaxClassProcessCount 100
>>>> IPCConnectTimeout 60
>>>> IPCCommTimeout 600
>>>> BusyTimeout 300
>>>> </IfModule>
>>>>
>>>> apache2.conf
>>>>
>>>> root@nzhmlapp04:/home/phpwiki# cat /etc/apache2/apache2.conf | grep
>>>> -v "#" | grep [^[:space:]]
>>>> ServerRoot "/etc/apache2"
>>>> LockFile /var/lock/apache2/accept.lock
>>>> PidFile ${APACHE_PID_FILE}
>>>> TimeOut 300
>>>> KeepAlive on
>>>> MaxKeepAliveRequests 100
>>>> KeepAliveTimeout 60
>>>> <IfModule mpm_prefork_module>
>>>> StartServers 5
>>>> MinSpareServers 5
>>>> MaxSpareServers 10
>>>> MaxClients 150
>>>> MaxRequestsPerChild 0
>>>> </IfModule>
>>>> <IfModule mpm_worker_module>
>>>> StartServers 2
>>>> MinSpareThreads 25
>>>> MaxSpareThreads 75
>>>> ThreadLimit 64
>>>> ThreadsPerChild 25
>>>> MaxClients 150
>>>> MaxRequestsPerChild 0
>>>> </IfModule>
>>>> <IfModule mpm_event_module>
>>>> StartServers 2
>>>> MaxClients 150
>>>> MinSpareThreads 25
>>>> MaxSpareThreads 75
>>>> ThreadLimit 64
>>>> ThreadsPerChild 25
>>>> MaxRequestsPerChild 0
>>>> </IfModule>
>>>> User ${APACHE_RUN_USER}
>>>> Group ${APACHE_RUN_GROUP}
>>>> AccessFileName .htaccess
>>>> <Files ~ "^\.ht">
>>>> Order allow,deny
>>>> Deny from all
>>>> Satisfy all
>>>> </Files>
>>>> DefaultType text/plain
>>>> HostnameLookups Off
>>>> ErrorLog /var/log/apache2/error.log
>>>> LogLevel warn
>>>> Include /etc/apache2/mods-enabled/*.load
>>>> Include /etc/apache2/mods-enabled/*.conf
>>>> Include /etc/apache2/httpd.conf
>>>> Include /etc/apache2/ports.conf
>>>> LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\"
>>>> \"%{User-Agent}i\"" vhost_combined
>>>> LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\"
>>>> \"%{User-Agent}i\"" combined
>>>> LogFormat "%h %l %u %t \"%r\" %>s %O" common
>>>> LogFormat "%{Referer}i -> %U" referer
>>>> LogFormat "%{User-agent}i" agent
>>>> CustomLog /var/log/apache2/other_vhosts_access.log vhost_combined
>>>> Include /etc/apache2/conf.d/
>>>> Include /etc/apache2/sites-enabled/
>>>> NameVirtualHost 192.168.32.22:80
>>>>
>>>>
>>>> apache virtualhost
>>>>
>>>> SuexecUserGroup "#1014" "#1014"
>>>> ServerName phpwiki.example.com
>>>> ServerAlias www.phpwiki.example.com
>>>> ServerAlias test-phpwiki.example.com
>>>> ServerAlias webmail.phpwiki.example.com
>>>> ServerAlias admin.phpwiki.example.com
>>>> DocumentRoot /home/phpwiki/public_html
>>>> ErrorLog /var/log/virtualmin/phpwiki.example.com_error_log
>>>> CustomLog /var/log/virtualmin/phpwiki.example.com_access_log combined
>>>> ScriptAlias /cgi-bin/ /home/phpwiki/cgi-bin/
>>>> ScriptAlias /awstats/ /home/phpwiki/cgi-bin/
>>>> DirectoryIndex index.html index.htm index.php index.php4 index.php5
>>>> <Directory /home/phpwiki/public_html>
>>>> Options -Indexes +IncludesNOEXEC +FollowSymLinks +ExecCGI
>>>> allow from all
>>>> AllowOverride All
>>>> AddHandler fcgid-script .php
>>>> AddHandler fcgid-script .php5
>>>> FCGIWrapper /home/phpwiki/fcgi-bin/php5.fcgi .php
>>>> FCGIWrapper /home/phpwiki/fcgi-bin/php5.fcgi .php5
>>>> </Directory>
>>>> <Directory /home/phpwiki/cgi-bin>
>>>> allow from all
>>>> </Directory>
>>>> RewriteEngine on
>>>> RewriteCond %{HTTP_HOST} =webmail.phpwiki.example.com
>>>> RewriteRule ^(.*) https://phpwiki.example.com:20000/ [R]
>>>> RewriteCond %{HTTP_HOST} =admin.phpwiki.example.com
>>>> RewriteRule ^(.*) https://phpwiki.example.com:10000/ [R]
>>>> RemoveHandler .php
>>>> RemoveHandler .php5
>>>> IPCCommTimeout 31
>>>> <Files awstats.pl>
>>>> AuthName "phpwiki.example.com statistics"
>>>> AuthType Basic
>>>> AuthUserFile /home/phpwiki/.awstats-htpasswd
>>>> require valid-user
>>>> </Files>
>>>>
>>>>
>>>> php.ini
>>>>
>>>> [PHP]
>>>> engine = On
>>>> short_open_tag = On
>>>> asp_tags = Off
>>>> precision = 14
>>>> y2k_compliance = On
>>>> output_buffering = 4096
>>>> zlib.output_compression = Off
>>>> implicit_flush = Off
>>>> unserialize_callback_func =
>>>> serialize_precision = 100
>>>> allow_call_time_pass_reference = Off
>>>> safe_mode = Off
>>>> safe_mode_gid = Off
>>>> safe_mode_include_dir =
>>>> safe_mode_exec_dir =
>>>> safe_mode_allowed_env_vars = PHP_
>>>> safe_mode_protected_env_vars = LD_LIBRARY_PATH
>>>> disable_functions =
>>>> disable_classes =
>>>> expose_php = On
>>>> max_execution_time = 600
>>>> max_input_time = 600
>>>> memory_limit = 128M
>>>> error_reporting = E_ALL & ~E_DEPRECATED
>>>> display_errors = Off
>>>> display_startup_errors = Off
>>>> log_errors = On
>>>> log_errors_max_len = 1024
>>>> ignore_repeated_errors = Off
>>>> ignore_repeated_source = Off
>>>> report_memleaks = On
>>>> track_errors = Off
>>>> html_errors = On
>>>> error_log = /home/phpwiki/logs/php_errors.log
>>>> variables_order = "GPCS"
>>>> request_order = "GP"
>>>> register_globals = Off
>>>> register_long_arrays = Off
>>>> register_argc_argv = Off
>>>> auto_globals_jit = On
>>>> post_max_size = 32M
>>>> magic_quotes_gpc = Off
>>>> magic_quotes_runtime = Off
>>>> magic_quotes_sybase = Off
>>>> auto_prepend_file =
>>>> auto_append_file =
>>>> default_mimetype = "text/html"
>>>> doc_root =
>>>> user_dir =
>>>> enable_dl = Off
>>>> file_uploads = On
>>>> upload_tmp_dir = /home/phpwiki/tmp
>>>> upload_max_filesize = 32M
>>>> max_file_uploads = 20
>>>> allow_url_fopen = On
>>>> allow_url_include = Off
>>>> default_socket_timeout = 240
>>>> [Date]
>>>> [filter]
>>>> [iconv]
>>>> [intl]
>>>> [sqlite]
>>>> [sqlite3]
>>>> [Pcre]
>>>> [Pdo]
>>>> [Pdo_mysql]
>>>> pdo_mysql.cache_size = 2000
>>>> pdo_mysql.default_socket=
>>>> [Phar]
>>>> [Syslog]
>>>> define_syslog_variables = Off
>>>> [mail function]
>>>> SMTP = localhost
>>>> smtp_port = 25
>>>> mail.add_x_header = On
>>>> [SQL]
>>>> sql.safe_mode = Off
>>>> [ODBC]
>>>> odbc.allow_persistent = On
>>>> odbc.check_persistent = On
>>>> odbc.max_persistent = -1
>>>> odbc.max_links = -1
>>>> odbc.defaultlrl = 4096
>>>> odbc.defaultbinmode = 1
>>>> [Interbase]
>>>> ibase.allow_persistent = 1
>>>> ibase.max_persistent = -1
>>>> ibase.max_links = -1
>>>> ibase.timestampformat = "%Y-%m-%d %H:%M:%S"
>>>> ibase.dateformat = "%Y-%m-%d"
>>>> ibase.timeformat = "%H:%M:%S"
>>>> [MySQL]
>>>> mysql.allow_local_infile = On
>>>> mysql.allow_persistent = On
>>>> mysql.cache_size = 2000
>>>> mysql.max_persistent = -1
>>>> mysql.max_links = -1
>>>> mysql.default_port =
>>>> mysql.default_socket =
>>>> mysql.default_host =
>>>> mysql.default_user =
>>>> mysql.default_password =
>>>> mysql.connect_timeout = 60
>>>> mysql.trace_mode = Off
>>>> [MySQLi]
>>>> mysqli.max_persistent = -1
>>>> mysqli.allow_persistent = On
>>>> mysqli.max_links = -1
>>>> mysqli.cache_size = 2000
>>>> mysqli.default_port = 3306
>>>> mysqli.default_socket =
>>>> mysqli.default_host =
>>>> mysqli.default_user =
>>>> mysqli.default_pw =
>>>> mysqli.reconnect = Off
>>>> [mysqlnd]
>>>> mysqlnd.collect_statistics = On
>>>> mysqlnd.collect_memory_statistics = Off
>>>> [OCI8]
>>>> [PostgresSQL]
>>>> pgsql.allow_persistent = On
>>>> pgsql.auto_reset_persistent = Off
>>>> pgsql.max_persistent = -1
>>>> pgsql.max_links = -1
>>>> pgsql.ignore_notice = 0
>>>> pgsql.log_notice = 0
>>>> [Sybase-CT]
>>>> sybct.allow_persistent = On
>>>> sybct.max_persistent = -1
>>>> sybct.max_links = -1
>>>> sybct.min_server_severity = 10
>>>> sybct.min_client_severity = 10
>>>> [bcmath]
>>>> bcmath.scale = 0
>>>> [browscap]
>>>> [Session]
>>>> session.save_handler = files
>>>> session.save_path = /home/phpwiki/tmp
>>>> session.use_cookies = 1
>>>> session.use_only_cookies = 1
>>>> session.name = PHPSESSID
>>>> session.auto_start = 0
>>>> session.cookie_lifetime = 0
>>>> session.cookie_path = /
>>>> session.cookie_domain =
>>>> session.cookie_httponly =
>>>> session.serialize_handler = php
>>>> session.gc_probability = 1
>>>> session.gc_divisor = 1000
>>>> session.gc_maxlifetime = 1440
>>>> session.bug_compat_42 = Off
>>>> session.bug_compat_warn = Off
>>>> session.referer_check =
>>>> session.entropy_length = 0
>>>> session.cache_limiter = nocache
>>>> session.cache_expire = 180
>>>> session.use_trans_sid = 0
>>>> session.hash_function = 0
>>>> session.hash_bits_per_character = 5
>>>> url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
>>>> [MSSQL]
>>>> mssql.allow_persistent = On
>>>> mssql.max_persistent = -1
>>>> mssql.max_links = -1
>>>> mssql.min_error_severity = 10
>>>> mssql.min_message_severity = 10
>>>> mssql.compatability_mode = Off
>>>> mssql.secure_connection = Off
>>>> [Assertion]
>>>> [COM]
>>>> [mbstring]
>>>> [gd]
>>>> [exif]
>>>> [Tidy]
>>>> tidy.clean_output = Off
>>>> [soap]
>>>> soap.wsdl_cache_enabled=1
>>>> soap.wsdl_cache_dir="/tmp"
>>>> soap.wsdl_cache_ttl=86400
>>>> soap.wsdl_cache_limit = 5
>>>> [sysvshm]
>>>> [ldap]
>>>> ldap.max_links = -1
>>>> [mcrypt]
>>>> [dba]
>>>>
>>>>
>>>> Any ideas what could be causing this , and how do I resolve it ?
>>>>
>>>>
>>>> Thanks
>>>>
>>>> ---------------------------------------------------------------------
>>>> The official User-To-User support forum of the Apache HTTP Server Project.
>>>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>>>> To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
>>>> " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
>>>> For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
>>>>
>>>>
>>>
>>
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
" from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|