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.d...@gmail.com> 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 <g...@linuxpro.co.za> 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.d...@gmail.com> 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 <g...@linuxpro.co.za> 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-unsubscr...@httpd.apache.org >>>> " from the digest: users-digest-unsubscr...@httpd.apache.org >>>> For additional commands, e-mail: users-h...@httpd.apache.org >>>> >>>> >>> >> > --------------------------------------------------------------------- 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-unsubscr...@httpd.apache.org " from the digest: users-digest-unsubscr...@httpd.apache.org For additional commands, e-mail: users-h...@httpd.apache.org
