pyrocms / pyrocms

Pyro is an experienced and powerful Laravel PHP CMS.
https://www.pyrocms.com/
Other
3.18k stars 934 forks source link

Nginx installations #1587

Closed z2z closed 11 years ago

z2z commented 12 years ago

/installer/index.php/installer/step_1

A Database Error Occurred

Error Number: 1146

Table 'pyrocms.default_ci_sessions' doesn't exist

SELECT * FROM (`default_ci_sessions`) WHERE `session_id` = 'f578d02fe14e613c025ae184556c8819' AND `ip_address` = '127.0.0.1' AND `user_agent` = 'Mozilla/5.0 (Windows NT 5.1; rv:13.0) Gecko/20100101 Firefox/13.0.1' LIMIT 1

Filename: C:\Winginx\home\pyrocms.local\public_html\system\codeigniter\database\DB_driver.php

Line Number: 344
philsturgeon commented 12 years ago

Do you have any more information to offer? Are you installing 2.1, 2.2-dev, what?

z2z commented 12 years ago

v2.1.2 http://github.com/pyrocms/pyrocms/zipball/v2.1.2

Sorry for late reply

philsturgeon commented 12 years ago

So this is a clean installation, with an empty (or non-existant database), the installer is present and you're running this all for the first time?

It seems more to me like:

It's been installed before, the database.php is there, but going to the installer is trying to give a 404 but cant find the database. Any of that sound possible?

z2z commented 12 years ago

Yeah, this was clean installation. After it failed, tried few things like creating default ci session table and adding db details in database.php

philsturgeon commented 12 years ago

You won't be able to fake an installation, there are too many steps.

What setup are you on? Got a phpinfo() ?

Phil Sturgeon

On Thursday, 19 July 2012 at 16:37, z2z wrote:

Yeah, this was clean installation. After it failed, tried few things like creating default ci session table and adding db details in database.php


Reply to this email directly or view it on GitHub: https://github.com/pyrocms/pyrocms/issues/1587#issuecomment-7101786

z2z commented 12 years ago

PHP Logo
PHP Version 5.3.14

System  Windows NT NQR 5.1 build 2600 (Windows XP Professional Service Pack 3) i586
Build Date  Jun 13 2012 18:19:14
Compiler    MSVC9 (Visual C++ 2008)
Architecture    x86
Configure Command   cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--disable-zts" "--disable-isapi" "--disable-nsapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=C:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=C:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8-11g=C:\php-sdk\oracle\instantclient11\sdk,shared" "--with-enchant=shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet" "--with-mcrypt=static" "--disable-static-analyze"
Server API  CGI/FastCGI
Virtual Directory Support   disabled
Configuration File (php.ini) Path   C:\WINDOWS
Loaded Configuration File   C:\Winginx\php5\php.ini
Scan this dir for additional .ini files     (none)
Additional .ini files parsed    (none)
PHP API     20090626
PHP Extension   20090626
Zend Extension  220090626
Zend Extension Build    API220090626,NTS,VC9
PHP Extension Build     API20090626,NTS,VC9
Debug Build     no
Thread Safety   disabled
Zend Memory Manager     enabled
Zend Multibyte Support  disabled
IPv6 Support    enabled
Registered PHP Streams  php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar
Registered Stream Socket Transports     tcp, udp, ssl, sslv3, sslv2, tls
Registered Stream Filters   convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.*

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2012 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.bzip2://
Stream Filter support   bzip2.decompress, bzip2.compress
BZip2 Version   1.0.6, 6-Sept-2010

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.impersonate 0   0
fastcgi.logging 1   1

com_dotnet
COM support enabled
DCOM support    disabled
.Net support    enabled

Directive   Local Value Master Value
com.allow_dcom  0   0
com.autoregister_casesensitive  1   1
com.autoregister_typelib    0   0
com.autoregister_verbose    0   0
com.code_page   no value    no value
com.typelib_file    no value    no value

Core
PHP Version     5.3.14

Directive   Local Value Master Value
allow_call_time_pass_reference  On  On
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  On  On
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   On  On
error_append_string no value    no value
error_log   error.log   error.log
error_prepend_string    no value    no value
error_reporting 30711   30711
exit_on_timeout Off Off
expose_php  On  On
extension_dir   ext ext
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 Off Off
ignore_repeated_errors  Off Off
ignore_repeated_source  Off Off
ignore_user_abort   Off Off
implicit_flush  Off Off
include_path    .;/nginx/php5/PEAR  .;/nginx/php5/PEAR
log_errors  Off Off
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   Off Off
mail.force_extra_parameters no value    no value
mail.log    no value    no value
max_execution_time  120 120
max_file_uploads    20  20
max_input_nesting_level 64  64
max_input_time  60  60
max_input_vars  1000    1000
memory_limit    128M    128M
open_basedir    no value    no value
output_buffering    no value    no value
output_handler  no value    no value
post_max_size   50M 50M
precision   12  12
realpath_cache_size 16K 16K
realpath_cache_ttl  120 120
register_argc_argv  On  On
register_globals    Off Off
register_long_arrays    Off Off
report_memleaks On  On
report_zend_debug   On  On
request_order   no value    no value
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   me@localhost.com    me@localhost.com
sendmail_path   sendmail --dir=temp/mail    sendmail --dir=temp/mail
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 40M 40M
upload_tmp_dir  temp/php/upload temp/php/upload
user_dir    no value    no value
user_ini.cache_ttl  300 300
user_ini.filename   .user.ini   .user.ini
variables_order EGPCS   EGPCS
windows.show_crt_warning    Off Off
xmlrpc_error_number 0   0
xmlrpc_errors   Off Off
y2k_compliance  On  On
zend.enable_gc  On  On

ctype
ctype functions     enabled

curl
cURL support    enabled
cURL Information    7.24.0
Age     3
Features
AsynchDNS   Yes
Debug   No
GSS-Negotiate   Yes
IDN     No
IPv6    Yes
Largefile   Yes
NTLM    Yes
SPNEGO  No
SSL     Yes
SSPI    Yes
krb4    No
libz    Yes
CharConv    No
Protocols   dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp
Host    i386-pc-win32
SSL Version     OpenSSL/0.9.8u
ZLib Version    1.2.5
libSSH Version  libssh2/1.3.0

date
date/time support   enabled
"Olson" Timezone Database Version   2012.3
Timezone Database   internal
Default timezone    Asia/Calcutta

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   Asia/Calcutta   Asia/Calcutta

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$
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

filter
Input Validation and Filtering  enabled
Revision    $Id: 2b8c730d7dfaa8485d07cd792f0c82852ffe4113 $

Directive   Local Value Master Value
filter.default  unsafe_raw  unsafe_raw
filter.default_flags    no value    no value

ftp
FTP support     enabled

gd
GD Support  enabled
GD Version  bundled (2.0.34 compatible)
FreeType Support    enabled
FreeType Linkage    with freetype
FreeType Version    2.4.3
GIF Read Support    enabled
GIF Create Support  enabled
JPEG Support    enabled
libJPEG Version     6b
PNG Support     enabled
libPNG Version  1.2.46
WBMP Support    enabled
XBM Support     enabled

Directive   Local Value Master Value
gd.jpeg_ignore_warning  0   0

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    "libiconv"
iconv library version   1.11

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) 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 cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour
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

memcache
memcache support    enabled
Active persistent connections   0
Version     2.2.6
Revision    $Revision: 296899 $

Directive   Local Value Master Value
memcache.allow_failover 1   1
memcache.chunk_size 8192    8192
memcache.default_port   11211   11211
memcache.default_timeout_ms 1000    1000
memcache.hash_function  crc32   crc32
memcache.hash_strategy  standard    standard
memcache.max_failover_attempts  20  20

mhash
MHASH support   Enabled
MHASH API Version   Emulated Support

mongo
MongoDB Support enabled
Version     1.2.10

Directive   Local Value Master Value
mongo.allow_empty_keys  0   0
mongo.allow_persistent  1   1
mongo.auto_reconnect    1   1
mongo.chunk_size    262144  262144
mongo.cmd   $   $
mongo.default_host  localhost   localhost
mongo.default_port  27017   27017
mongo.is_master_interval    60  60
mongo.long_as_object    0   0
mongo.native_long   0   0
mongo.no_id 0   0
mongo.ping_interval 5   5
mongo.utf8  1   1

mysql
MySQL Support   enabled
Active Persistent Links     0
Active Links    0
Client API version  mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $

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    no value    no value
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  mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $
Active Persistent Links     0
Inactive Persistent Links   0
Active Links    0

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

mysqlnd
mysqlnd enabled
Version     mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $
Compression     supported
SSL     supported
Command buffer size     4096
Read buffer size    32768
Read timeout    31536000
Collecting statistics   Yes
Collecting memory statistics    No
Tracing     n/a

Client statistics   
bytes_sent  0
bytes_received  0
packets_sent    0
packets_received    0
protocol_overhead_in    0
protocol_overhead_out   0
bytes_received_ok_packet    0
bytes_received_eof_packet   0
bytes_received_rset_header_packet   0
bytes_received_rset_field_meta_packet   0
bytes_received_rset_row_packet  0
bytes_received_prepare_response_packet  0
bytes_received_change_user_packet   0
packets_sent_command    0
packets_received_ok     0
packets_received_eof    0
packets_received_rset_header    0
packets_received_rset_field_meta    0
packets_received_rset_row   0
packets_received_prepare_response   0
packets_received_change_user    0
result_set_queries  0
non_result_set_queries  0
no_index_used   0
bad_index_used  0
slow_queries    0
buffered_sets   0
unbuffered_sets     0
ps_buffered_sets    0
ps_unbuffered_sets  0
flushed_normal_sets     0
flushed_ps_sets     0
ps_prepared_never_executed  0
ps_prepared_once_executed   0
rows_fetched_from_server_normal     0
rows_fetched_from_server_ps     0
rows_buffered_from_client_normal    0
rows_buffered_from_client_ps    0
rows_fetched_from_client_normal_buffered    0
rows_fetched_from_client_normal_unbuffered  0
rows_fetched_from_client_ps_buffered    0
rows_fetched_from_client_ps_unbuffered  0
rows_fetched_from_client_ps_cursor  0
rows_affected_normal    0
rows_affected_ps    0
rows_skipped_normal     0
rows_skipped_ps     0
copy_on_write_saved     0
copy_on_write_performed     0
command_buffer_too_small    0
connect_success     0
connect_failure     0
connection_reused   0
reconnect   0
pconnect_success    0
active_connections  0
active_persistent_connections   0
explicit_close  0
implicit_close  0
disconnect_close    0
in_middle_of_command_close  0
explicit_free_result    0
implicit_free_result    0
explicit_stmt_close     0
implicit_stmt_close     0
mem_emalloc_count   0
mem_emalloc_amount  0
mem_ecalloc_count   0
mem_ecalloc_amount  0
mem_erealloc_count  0
mem_erealloc_amount     0
mem_efree_count     0
mem_efree_amount    0
mem_malloc_count    0
mem_malloc_amount   0
mem_calloc_count    0
mem_calloc_amount   0
mem_realloc_count   0
mem_realloc_amount  0
mem_free_count  0
mem_free_amount     0
mem_estrndup_count  0
mem_strndup_count   0
mem_estndup_count   0
mem_strdup_count    0
proto_text_fetched_null     0
proto_text_fetched_bit  0
proto_text_fetched_tinyint  0
proto_text_fetched_short    0
proto_text_fetched_int24    0
proto_text_fetched_int  0
proto_text_fetched_bigint   0
proto_text_fetched_decimal  0
proto_text_fetched_float    0
proto_text_fetched_double   0
proto_text_fetched_date     0
proto_text_fetched_year     0
proto_text_fetched_time     0
proto_text_fetched_datetime     0
proto_text_fetched_timestamp    0
proto_text_fetched_string   0
proto_text_fetched_blob     0
proto_text_fetched_enum     0
proto_text_fetched_set  0
proto_text_fetched_geometry     0
proto_text_fetched_other    0
proto_binary_fetched_null   0
proto_binary_fetched_bit    0
proto_binary_fetched_tinyint    0
proto_binary_fetched_short  0
proto_binary_fetched_int24  0
proto_binary_fetched_int    0
proto_binary_fetched_bigint     0
proto_binary_fetched_decimal    0
proto_binary_fetched_float  0
proto_binary_fetched_double     0
proto_binary_fetched_date   0
proto_binary_fetched_year   0
proto_binary_fetched_time   0
proto_binary_fetched_datetime   0
proto_binary_fetched_timestamp  0
proto_binary_fetched_string     0
proto_binary_fetched_blob   0
proto_binary_fetched_enum   0
proto_binary_fetched_set    0
proto_binary_fetched_geometry   0
proto_binary_fetched_other  0
init_command_executed_count     0
init_command_failed_count   0
com_quit    0
com_init_db     0
com_query   0
com_field_list  0
com_create_db   0
com_drop_db     0
com_refresh     0
com_shutdown    0
com_statistics  0
com_process_info    0
com_connect     0
com_process_kill    0
com_debug   0
com_ping    0
com_time    0
com_delayed_insert  0
com_change_user     0
com_binlog_dump     0
com_table_dump  0
com_connect_out     0
com_register_slave  0
com_stmt_prepare    0
com_stmt_execute    0
com_stmt_send_long_data     0
com_stmt_close  0
com_stmt_reset  0
com_stmt_set_option     0
com_stmt_fetch  0
com_deamon  0
bytes_received_real_data_normal     0
bytes_received_real_data_ps     0

odbc
ODBC Support    enabled
Active Persistent Links     0
Active Links    0
ODBC library    Win32

Directive   Local Value Master Value
odbc.allow_persistent   On  On
odbc.check_persistent   On  On
odbc.default_cursortype Static cursor   Static cursor
odbc.default_db no value    no value
odbc.default_pw no value    no value
odbc.default_user   no value    no value
odbc.defaultbinmode return as is    return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links  Unlimited   Unlimited
odbc.max_persistent Unlimited   Unlimited

openssl
OpenSSL support     enabled
OpenSSL Library Version     OpenSSL 0.9.8u 12 Mar 2012
OpenSSL Header Version  OpenSSL 0.9.8u 12 Mar 2012

pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled
PCRE Library Version    8.12 2011-01-15

Directive   Local Value Master Value
pcre.backtrack_limit    1000000 1000000
pcre.recursion_limit    100000  100000

PDO
PDO support enabled
PDO drivers     mysql, sqlite, sqlite2

pdo_mysql
PDO Driver for MySQL    enabled
Client API version  mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $

pdo_sqlite
PDO Driver for SQLite 3.x   enabled
SQLite Library  3.7.7.1

Phar
Phar: PHP Archive support   enabled
Phar EXT version    2.0.1
Phar API version    1.1.1
SVN revision    $Id: d8eaad1a2452af8d7f8ea9e3944e43add43e1890 $
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

rar
Rar support enabled
Rar EXT version     2.0.0-RC1
Revision    $Revision: 292614 $
UnRAR version   3.91 patch1 2010-1-18

Reflection
Reflection  enabled
Version     $Id: 522fef1e5100f848a5e2059d98b3a880a3143e9a $

session
Session Support     enabled
Registered save handlers    files user memcache sqlite
Registered serializer handlers  php php_binary wddx

Directive   Local Value Master Value
session.auto_start  Off Off
session.bug_compat_42   On  On
session.bug_compat_warn On  On
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  100 100
session.gc_maxlifetime  1440    1440
session.gc_probability  1   1
session.hash_bits_per_character 4   4
session.hash_function   0   0
session.name    PHPSESSID   PHPSESSID
session.referer_check   no value    no value
session.save_handler    files   files
session.save_path   no value    no value
session.serialize_handler   php php
session.use_cookies On  On
session.use_only_cookies    On  On
session.use_trans_sid   0   0

SimpleXML
Simplexml support   enabled
Revision    $Id: a379111021e24ef020a2eefd8ca830cb1ab5b280 $
Schema support  enabled

soap
Soap Client     enabled
Soap Server     enabled

Directive   Local Value Master Value
soap.wsdl_cache 1   1
soap.wsdl_cache_dir temp/php/wsdl   temp/php/wsdl
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 Library  2.8.17
SQLite Encoding     iso8859

Directive   Local Value Master Value
sqlite.assoc_case   0   0

sqlite3
SQLite3 support enabled
SQLite3 module version  0.7-dev
SQLite Library  3.7.7.1

Directive   Local Value Master Value
sqlite3.extension_dir   no value    no value

standard
Dynamic Library Support     enabled
Path to sendmail    sendmail --dir=temp/mail

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  60  60
from    no value    no value
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=,fieldset=    a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent  no value    no value

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

xmlrpc
core library version    xmlrpc-epi v. 0.51
php extension version   0.51
author  Dan Libby
homepage    http://xmlrpc-epi.sourceforge.net
open sourced by     Epinions.com

xmlwriter
XMLWriter   enabled

xsl
XSL     enabled
libxslt Version     1.1.23
libxslt compiled against libxml Version     2.6.32
EXSLT   enabled
libexslt Version    0.8.13

zip
Zip     enabled
Extension Version   $Id$
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.5
Linked Version  1.2.5

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

Environment
Variable    Value
Path    C:\Winginx/
PHP_FCGI_CHILDREN   5
PHP_FCGI_MAX_REQUESTS   0
SystemDrive     C:
SystemRoot  C:\WINDOWS
TEMP    C:\Winginx/temp/php
TMP     C:\Winginx/temp/php
windir  C:\WINDOWS

PHP Variables
Variable    Value
_REQUEST["pyrocms_installer"]   a:5:{s:10:"session_id";s:32:"2a5f154f50607a3c6c0baf40ce7bcd0e";s:10:"ip_address";s:9:"127.0.0.1";s:10:"user_agent";s:67:"Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1";s:13:"last_activity";i:1342712543;s:9:"user_data";s:0:"";}7d84bb4a41249f888b4072e99a340139
_COOKIE["pyrocms_installer"]    a:5:{s:10:"session_id";s:32:"2a5f154f50607a3c6c0baf40ce7bcd0e";s:10:"ip_address";s:9:"127.0.0.1";s:10:"user_agent";s:67:"Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1";s:13:"last_activity";i:1342712543;s:9:"user_data";s:0:"";}7d84bb4a41249f888b4072e99a340139
_SERVER["Path"] C:\Winginx/
_SERVER["PHP_FCGI_CHILDREN"]    5
_SERVER["PHP_FCGI_MAX_REQUESTS"]    0
_SERVER["SystemDrive"]  C:
_SERVER["SystemRoot"]   C:\WINDOWS
_SERVER["TEMP"] C:\Winginx/temp/php
_SERVER["TMP"]  C:\Winginx/temp/php
_SERVER["windir"]   C:\WINDOWS
_SERVER["FCGI_ROLE"]    RESPONDER
_SERVER["SCRIPT_FILENAME"]  C:\Winginx/home/pyrocms.local/public_html/phpinfo.php
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_METHOD"]   GET
_SERVER["CONTENT_TYPE"] no value
_SERVER["CONTENT_LENGTH"]   no value
_SERVER["SCRIPT_NAME"]  /phpinfo.php
_SERVER["REQUEST_URI"]  /phpinfo.php
_SERVER["DOCUMENT_URI"] /phpinfo.php
_SERVER["DOCUMENT_ROOT"]    C:\Winginx/home/pyrocms.local/public_html
_SERVER["SERVER_PROTOCOL"]  HTTP/1.1
_SERVER["GATEWAY_INTERFACE"]    CGI/1.1
_SERVER["SERVER_SOFTWARE"]  nginx/1.2.2
_SERVER["REMOTE_ADDR"]  127.0.0.1
_SERVER["REMOTE_PORT"]  3229
_SERVER["SERVER_ADDR"]  127.0.0.1
_SERVER["SERVER_PORT"]  81
_SERVER["SERVER_NAME"]  pyrocms.local
_SERVER["REDIRECT_STATUS"]  200
_SERVER["HTTP_HOST"]    pyrocms.local:81
_SERVER["HTTP_USER_AGENT"]  Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1
_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_DNT"] 1
_SERVER["HTTP_CONNECTION"]  keep-alive
_SERVER["HTTP_COOKIE"]  pyrocms_installer=a%3A5%3A%7Bs%3A10%3A%22session_id%22%3Bs%3A32%3A%222a5f154f50607a3c6c0baf40ce7bcd0e%22%3Bs%3A10%3A%22ip_address%22%3Bs%3A9%3A%22127.0.0.1%22%3Bs%3A10%3A%22user_agent%22%3Bs%3A67%3A%22Mozilla%2F5.0+%28Windows+NT+5.1%3B+rv%3A14.0%29+Gecko%2F20100101+Firefox%2F14.0.1%22%3Bs%3A13%3A%22last_activity%22%3Bi%3A1342712543%3Bs%3A9%3A%22user_data%22%3Bs%3A0%3A%22%22%3B%7D7d84bb4a41249f888b4072e99a340139
_SERVER["PHP_SELF"] /phpinfo.php
_SERVER["REQUEST_TIME"] 1342712646
_SERVER["argv"] 

Array
(
)

_SERVER["argc"] 0
_ENV["Path"]    C:\Winginx/
_ENV["PHP_FCGI_CHILDREN"]   5
_ENV["PHP_FCGI_MAX_REQUESTS"]   0
_ENV["SystemDrive"] C:
_ENV["SystemRoot"]  C:\WINDOWS
_ENV["TEMP"]    C:\Winginx/temp/php
_ENV["TMP"] C:\Winginx/temp/php
_ENV["windir"]  C:\WINDOWS
_ENV["FCGI_ROLE"]   RESPONDER
_ENV["SCRIPT_FILENAME"] C:\Winginx/home/pyrocms.local/public_html/phpinfo.php
_ENV["QUERY_STRING"]    no value
_ENV["REQUEST_METHOD"]  GET
_ENV["CONTENT_TYPE"]    no value
_ENV["CONTENT_LENGTH"]  no value
_ENV["SCRIPT_NAME"] /phpinfo.php
_ENV["REQUEST_URI"] /phpinfo.php
_ENV["DOCUMENT_URI"]    /phpinfo.php
_ENV["DOCUMENT_ROOT"]   C:\Winginx/home/pyrocms.local/public_html
_ENV["SERVER_PROTOCOL"] HTTP/1.1
_ENV["GATEWAY_INTERFACE"]   CGI/1.1
_ENV["SERVER_SOFTWARE"] nginx/1.2.2
_ENV["REMOTE_ADDR"] 127.0.0.1
_ENV["REMOTE_PORT"] 3229
_ENV["SERVER_ADDR"] 127.0.0.1
_ENV["SERVER_PORT"] 81
_ENV["SERVER_NAME"] pyrocms.local
_ENV["REDIRECT_STATUS"] 200
_ENV["HTTP_HOST"]   pyrocms.local:81
_ENV["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1
_ENV["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_ENV["HTTP_ACCEPT_LANGUAGE"]    en-us,en;q=0.5
_ENV["HTTP_ACCEPT_ENCODING"]    gzip, deflate
_ENV["HTTP_DNT"]    1
_ENV["HTTP_CONNECTION"] keep-alive
_ENV["HTTP_COOKIE"] pyrocms_installer=a%3A5%3A%7Bs%3A10%3A%22session_id%22%3Bs%3A32%3A%222a5f154f50607a3c6c0baf40ce7bcd0e%22%3Bs%3A10%3A%22ip_address%22%3Bs%3A9%3A%22127.0.0.1%22%3Bs%3A10%3A%22user_agent%22%3Bs%3A67%3A%22Mozilla%2F5.0+%28Windows+NT+5.1%3B+rv%3A14.0%29+Gecko%2F20100101+Firefox%2F14.0.1%22%3Bs%3A13%3A%22last_activity%22%3Bi%3A1342712543%3Bs%3A9%3A%22user_data%22%3Bs%3A0%3A%22%22%3B%7D7d84bb4a41249f888b4072e99a340139
_ENV["PHP_SELF"]    /phpinfo.php
_ENV["REQUEST_TIME"]    1342712646
_ENV["argv"]    

Array
(
)

_ENV["argc"]    0

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.
z2z commented 12 years ago

Tried again first got ..

PyroCMS is missing system/cms/config/database.php and cannot find the installer folder. Does your server have permission to access these files?

when renamed database.php.bak to database.php and added db details

A Database Error Occurred

Error Number: 1146

Table 'pyrocms.default_ci_sessions' doesn't exist

INSERT INTO `default_ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('defdaa563b8969b8e1819f94ea264bd8', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1', 1342693272, '')

Filename: C:\Winginx\home\pyrocms.local\public_html\system\codeigniter\database\DB_driver.php

Line Number: 344

DB confirmed working with sqlyog on port 3307.

$db[PYRO_DEVELOPMENT] = array(
    'hostname'      =>  'localhost',
    'username'      =>  'root',
    'password'      =>  '',
    'database'      =>  'pyrocms',
    'dbdriver'      =>  'mysql',
    'dbprefix'      =>  '',
    'active_r'      =>  TRUE,
    'pconnect'      =>  FALSE,
    'db_debug'      =>  TRUE,
    'cache_on'      =>  FALSE,
    'char_set'      =>  'utf8',
    'dbcollat'      =>  'utf8_unicode_ci',
    'port'          =>  3307,
philsturgeon commented 12 years ago

Yeah if you put a database.php in place then it will assume you've completed the installation and try to load the site, which obviously doesn't have any content.

Absolutely delete everything and try again. If you come up with an error then THAT is the problem, this is just a problem caused by tinkering. :)

Phil Sturgeon

On Thursday, 19 July 2012 at 16:54, z2z wrote:

Tried again first got ..

PyroCMS is missing system/cms/config/database.php and cannot find the installer folder. Does your server have permission to access these files?

when renamed database.php.bak to database.php and added db details

A Database Error Occurred

Error Number: 1146

Table 'pyrocms.default_ci_sessions' doesn't exist

INSERT INTO `default_ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('defdaa563b8969b8e1819f94ea264bd8', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1', 1342693272, '')

Filename: C:\Winginx\home\pyrocms.local\public_html\system\codeigniter\database\DB_driver.php

Line Number: 344

DB confirmed working with sqlyog on port 3307.

$db[PYRO_DEVELOPMENT] = array(
'hostname' => 'localhost',
'username' => 'root',
'password' => '',
'database' => 'pyrocms',
'dbdriver' => 'mysql',
'dbprefix' => '',
'active_r' => TRUE,
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'char_set' => 'utf8',
'dbcollat' => 'utf8_unicode_ci',
'port' => 3307,

Reply to this email directly or view it on GitHub: https://github.com/pyrocms/pyrocms/issues/1587#issuecomment-7102253

z2z commented 12 years ago

Actually, have already tried from scratch. Check earlier comment. https://github.com/pyrocms/pyrocms/issues/1587#issuecomment-7102253

philsturgeon commented 12 years ago

Right but the current issue is on that can only really happen with tinkering, so I'm suggest a clean slate.

Otherwise, you might need to give me FTP so I can try to find what the heck is going on.

Emailing from my iPhone 4S like a BOSS!

On 20 Jul 2012, at 06:29, z2zreply@reply.github.com wrote:

Actually, have already tried that. Check earlier comment.


Reply to this email directly or view it on GitHub: https://github.com/pyrocms/pyrocms/issues/1587#issuecomment-7122675

ShaunaGordon commented 11 years ago

@philsturgeon I know this is kind of old and has been closed, but it comes up pretty high on Google when searching for the "missing database.php" error, so I figured this was as good a place as any to post this information.

This error seems to be an issue with running PyroCMS on Nginx. For some reason, a standard PHP with rewrite setup doesn't work. In my experience, http://example.com redirects properly to http://example.com/installer when database.php doesn't exist, but when trying to go to Step 1, something gets lost in translation and it can't read the installer controller, resulting in the above 404 error.

Thankfully, the guys over in the Nginx community have been nice enough to post configuration information for PyroCMS, and are very thorough about it.

Most of what they have posted is pretty typical of a PHP+rewrite setup, but the key section is this:

location /installer {
    try_files $uri $uri/ /installer/index.php;
}

It also says to include the following edit to both /installer/config/config.php and /system/cms/config/config.php:

$config['index_page'] = "";
$config['uri_protocol'] = "REQUEST_URI";

In my experience, this edit doesn't matter when it comes to functionality (just takes "index.php" out of the URL), but that may depend on the specifics of a given setup, so if just adding the above location block doesn't work, combining it with the config changes might.

Additionally, a default Nginx/php-fpm install might run into a 502 Bad Gateway error or WSOD when going on to Step 2. In that case, adding

fastcgi_buffer_size 128k;
fastcgi_buffers 4 256k;

somewhere in the Nginx config, around the other fastcgi_params, fixes that issue and allows the install to complete successfully.

peterbowey commented 11 years ago

@philsturgeon I concur. There are still some 'show stopper' issues remaining using Nginx and a fresh install of PyroCMS V2.2 (Free or Professional). The common 'install' problem is "missing database.php" error!

To date, the sanest guide is to use the configuration at http://wiki.nginx.org/Pyrocms

However, I suspect the above link may not be the most code and security efficient method for the use of PyroCMS; at least for those acclimatized to using Drupal, along Aegir and BOA - all with some very advanced Nginx configs.

jerel commented 11 years ago

I'm reopening this so we can hopefully review Nginx installation thoroughly yet before 2.2 final. I know there's a lot of people running on Nginx but it sounds like we may be able to improve the experience

ShaunaGordon commented 11 years ago

@peterbowey - What do you find inefficient code and security-wise about the Nginx config? It's a pretty standard configuration, and most of that's actually default in most installs of Nginx. The only real change between the config and a standard PHP with rewrite config is the location block that I talked about earlier.

@jerel - I suspect that this is largely just a documentation matter. Feel free to use what I've posted as the basis for a guide to setting up PyroCMS on Nginx. As I recall, that little issue was the only real sticking point, at least that I ran into, on a stock Nginx install.

philsturgeon commented 11 years ago

This is a documentation thing, if people go to /installer it works fine and with the update Wiki it looks like we're all good.