search

snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
10.81k stars 3.13k forks source link

Admin Unauthenticated #8650

Closed LecrisUT closed 3 years ago

LecrisUT commented 3 years ago

Please confirm you have done the following before posting your bug report:

Describe the bug Root admin user is not authenticated, and cannot see any data, e.g. in Group Management

To Reproduce Steps to reproduce the behavior:

  1. Clean installation on Centos
  2. Tried with all webservers: apache, nginx, caddy
  3. Create the database, and any initial configuration
  4. Try to access any data e.g. Group Management

Expected behavior To be authenticated

Screenshots Screen Shot 2020-10-30 at 10 57 05

Server (please complete the following information):

Desktop (please complete the following information):

Smartphone (please complete the following information):

Error Messages StackTrace

Unauthenticated.
/var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php#81

Additional context Please let me know how to extract further debug information

LecrisUT commented 3 years ago

Solved it unconventionally. After reinstalling dependencies with sudo, the authentication goes through. Probably there is a php path issue.

PengKuang commented 3 years ago

Hi do you mean the composer dependenccies? seems I encountered the same issue. But I got the warning saying that composer shouldn't be run as root. I reinstalled the dependency but didn't resolve the issue.

LecrisUT commented 3 years ago

Yes I've installed the composer dependencies using sudo, despite the warning. I'm not familiar with php and composer, for example where does it install the binaries when run as a particular user, how to print $PATH or debug missing binaries. Those steps would be useful in debugging this issue.

Other things that I've done is installing mcrypt, but I've since uninstalled it and it still works.

PengKuang commented 3 years ago

Did you reinstall composer globally or just regularly? I'll try to reinstall it as root to see if it can resolve the issue.

LecrisUT commented 3 years ago

Hmm good point. Sorry, but that part I cannot recall. Based on how I usually set stuff up I expect that it was installed globally, and probably using sudo to do that.

PengKuang commented 3 years ago

I reinstalled composer both globally and locally, it doesn't resolve the issue for me. Did you all reinstall other dependencies such php, php extensions, etc.?

LecrisUT commented 3 years ago

Sorry, my history has been overwritten with debugging another webapp, so I cannot double-check. From what I know I did, and maybe you should check are:

For completeness here are my other setups:

#.env file everything else is default
APP_ENV=production
APP_DEBUG=true
APP_KEY=base64:[redacted]
APP_URL=snipe-it.[redacted]
APP_TIMEZONE='Asia/Tokyo'
APP_LOCALE=en
MAX_RESULTS=500

DB_CONNECTION=mysql
DB_HOST=localhost
DB_DATABASE=snipe_db
DB_USERNAME=snipe_user
DB_PASSWORD=[redacted]
DB_PREFIX=null
DB_DUMP_PATH='/usr/bin'
DB_CHARSET=utf8mb4
DB_COLLATION=utf8mb4_unicode_ci

How I created the database:

mysq -uroot -p
> create user snipe_user;
> create database snipe_db;
> grant all on snipe_db.* to 'snipe_user'@'localhost' identified by '[redacted]';
> flush privileges;

You could add CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci to be safe.

My caddyfile is also vary basic:

snipe-it snipe-it.[redacted] {
   root * /var/www/snipe/public
   encode gzip zstd
   file_server
   php_fastcgi unix//run/php-fpm/caddy.sock
}

And I am on the master branch of the snipe-it repository. Not sure what other things I have configured, but if you ask me for more info maybe we can find it.

LecrisUT commented 3 years ago

One thing to note is that as soon as the configuration that worked was achieved, the Laravel Debugbar switched from dark-theme to light-theme. And yes, the api credentials were set when I accessed Group management

PengKuang commented 3 years ago

Thanks for the detailed info! I'll try to replicate and see if there is any luck.

Here is the description of my environment and issue: https://github.com/snipe/snipe-it/issues/8697

What I did differently is that I replaced the app key and /storage/private_uploads & public/uploads files (generated in this new installation) using the old ones in our old build

And my database resides in a separate server, my .env file looks as below:

8650 REQUIRED: BASIC APP SETTINGS
--------------------------------------------
APP_ENV=production
APP_DEBUG=true
APP_KEY=base64:xxxxx
--APP_KEY=base64:xxxxx (I have commented the new app key but using the old app key instead)
APP_URL=http://xxx.xxxx.xxxx.xx
APP_TIMEZONE='Asia/Shanghai'
APP_LOCALE=en
MAX_RESULTS=500

 --------------------------------------------
REQUIRED: UPLOADED FILE STORAGE SETTINGS
--------------------------------------------
PRIVATE_FILESYSTEM_DISK=local
PUBLIC_FILESYSTEM_DISK=local_public

 --------------------------------------------
REQUIRED: DATABASE SETTINGS
--------------------------------------------
DB_CONNECTION=mysql
DB_HOST=XX.XX.XX.XX (ip address of the database server)
DB_DATABASE=snipeit_database
DB_USERNAME=snipeit_database
DB_PASSWORD=password
DB_PREFIX=null
DB_DUMP_PATH='/usr/bin'
DB_CHARSET=utf8mb4
DB_COLLATION=utf8mb4_unicode_ci
LecrisUT commented 3 years ago

I'm not sure whether you can just regenerate a new APP_KEY and the credential of the users, but it doesn't hurt trying. If you have been upgrading from an older installation could this be relevant?

PengKuang commented 3 years ago

I'm not sure if that caused the issue. But my dnf packages looks as below:

oniguruma5php.x86_64 6.9.6-1.el8.remi @remi-safe php.x86_64 7.2.34-1.el8.remi @remi-modular php-bcmath.x86_64 7.2.34-1.el8.remi @remi-modular php-cli.x86_64 7.2.34-1.el8.remi @remi-modular php-common.x86_64 7.2.34-1.el8.remi @remi-modular php-devel.x86_64 7.2.34-1.el8.remi @remi-modular php-fedora-autoloader.noarch 1.0.1-2.el8.remi @remi-modular php-fpm.x86_64 7.2.34-1.el8.remi @remi-modular php-json.x86_64 7.2.34-1.el8.remi @remi-modular php-ldap.x86_64 7.2.34-1.el8.remi @remi-modular php-mbstring.x86_64 7.2.34-1.el8.remi @remi-modular php-mysqlnd.x86_64 7.2.34-1.el8.remi @remi-modular php-opcache.x86_64 7.2.34-1.el8.remi @remi-modular php-pdo.x86_64 7.2.34-1.el8.remi @remi-modular php-pear.noarch 1:1.10.12-2.el8.remi @remi-modular php-pecl-mysql.x86_64 1.0.0-0.20.20180226.647c933.el8.remi.7.2 @remi-modular php-pecl-zip.x86_64 1.19.1-1.el8.remi.7.2 @remi-modular php-process.x86_64 7.2.34-1.el8.remi @remi-modular php-sodium.x86_64 7.2.34-1.el8.remi @remi-modular php-xml.x86_64 7.2.34-1.el8.remi @rem

snipe commented 3 years ago

What about openSSL, curl, zip, fileinfo and tokenizer?

Screen Shot 2020-11-09 at 6 45 37 PM

https://snipe-it.readme.io/docs/requirements

Snipe-IT Documentation
Requirements
The requirements for Snipe-IT are fairly standard for a modern web server, and most servers will have most or all of these components already installed. If for some reason you don't have them installed, they are relatively easy to add.
LecrisUT commented 3 years ago

It is just a version difference, but I don't think it is the culprit here. Based on my intuition, the main php extensions that should involve the authentication are tokenizer and openssl, which are included in php-common. You can check it with php -m, here is mine:

[PHP Modules]
apcu
bcmath
bz2
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
imagick
intl
json
ldap
libxml
mbstring
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

Edit: @PengKuang Please confirm in CentOS php 7.2

snipe commented 3 years ago

In some web servers though, you have to actually enable those as extensions/modules in your web server. Having PHP compiled with them isn't always enough.

LecrisUT commented 3 years ago

How can we check that?

Also is env[PATH] = /usr/local/bin:/usr/bin:/bin in the php-fpm socket relevant to composer? How should it be set for non-sudo installations?

PengKuang commented 3 years ago

so when I switched back to the new app key and oauth_public & private.keys, I wouldn't be able to login anymore.

One thing I didn't mention is that, the old server is https, and on the new server I haven't yet installed any certificate yet. I'm not sure if this makes any difference when comes to authentication?

image

This is my php extensions:

[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
imagick
json
ldap
libxml
mbstring
mysql
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
sodium
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache
LecrisUT commented 3 years ago

The question is if the Admin account is authorized. Create a new account with the newly generated key and try out. If it all works out you should be able to regenerate the credentials. I cannot remember where I've seen the guide for remaking the credentials, but someone should link it in this thread soon. All other authenthications like LDAP and OAUTH should also be reconfigured if you have new credentials.

LecrisUT commented 3 years ago

Unrelated, but is the OAuth option in the settings to setup snipe-it as the OAuth server or to setup OAuth authentication on the snipe-it server? And how do we setup OAuth authentication to link to KeyCloak for example?

PengKuang commented 3 years ago

In some web servers though, you have to actually enable those as extensions/modules in your web server. Having PHP compiled with them isn't always enough.

speaking of this, my php.ini file looks pretty strange, I didn't find a place to enable the extensions

[peng@ITAssets snipe-it]$ whereis php
php: /usr/bin/php /usr/lib64/php /etc/php.d /etc/php.ini /usr/include/php /usr/share/php /usr/share/man/man1/php.1.gz
[peng@Assets snipe-it]$ sudo vi /etc/php.d

[peng@ITAssets snipe-it]$ ls /etc/php.d
10-opcache.ini   20-gettext.ini   20-simplexml.ini  30-mysqli.ini
20-bcmath.ini    20-gmp.ini       20-sockets.ini    30-pdo_mysql.ini
20-bz2.ini       20-iconv.ini     20-sodium.ini     30-pdo_sqlite.ini
20-calendar.ini  20-json.ini      20-sqlite3.ini    30-wddx.ini
20-ctype.ini     20-ldap.ini      20-sysvmsg.ini    30-xmlreader.ini
20-curl.ini      20-mbstring.ini  20-sysvsem.ini    40-zip.ini
20-dom.ini       20-mysqlnd.ini   20-sysvshm.ini    50-mysql.ini
20-exif.ini      20-pdo.ini       20-tokenizer.ini  opcache-default.blacklist
20-fileinfo.ini  20-phar.ini      20-xml.ini
20-ftp.ini       20-posix.ini     20-xmlwriter.ini
20-gd.ini        20-shmop.ini     20-xsl.ini

my php.ini

[PHP]

;;;;;;;;;;;;;;;;;;;
; About php.ini   ;
;;;;;;;;;;;;;;;;;;;
; PHP's initialization file, generally called php.ini, is responsible for
; configuring many of the aspects of PHP's behavior.

; PHP attempts to find and load this configuration from a number of locations.
; The following is a summary of its search order:
; 1. SAPI module specific location.
; 2. The PHPRC environment variable. (As of PHP 5.2.0)
; 3. A number of predefined registry keys on Windows (As of PHP 5.2.0)
; 4. Current working directory (except CLI)
; 5. The web server's directory (for SAPI modules), or directory of PHP
; (otherwise in Windows)
; 6. The directory from the --with-config-file-path compile time option, or the
; Windows directory (C:\windows or C:\winnt)
; See the PHP docs for more specific information.
; http://php.net/configuration.file

; The syntax of the file is extremely simple.  Whitespace and lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.

; Directives following the section heading [PATH=/www/mysite] only
; apply to PHP files in the /www/mysite directory.  Directives
; following the section heading [HOST=www.example.com] only apply to
; PHP files served from www.example.com.  Directives set in these
; special sections cannot be overridden by user-defined INI files or
; at runtime. Currently, [PATH=] and [HOST=] sections only work under
; CGI/FastCGI.
; http://php.net/ini.sections

; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
; Directives are variables used to configure PHP or PHP extensions.
; There is no name validation.  If PHP can't find an expected
; directive because it is not set or is mistyped, a default value will be used.

; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
; (e.g. E_ALL & ~E_NOTICE), a quoted string ("bar"), or a reference to a
; previously set variable or directive (e.g. ${foo})

; Expressions in the INI file are limited to bitwise operators and parentheses:
; |  bitwise OR
; ^  bitwise XOR
; &  bitwise AND
; ~  bitwise NOT
; !  boolean NOT

; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.

; An empty string can be denoted by simply not writing anything after the equal
; sign, or by using the None keyword:

;  foo =         ; sets foo to an empty string
;  foo = None    ; sets foo to an empty string
;  foo = "None"  ; sets foo to the string 'None'

; If you use constants in your value, and these constants belong to a
; dynamically loaded extension (either a PHP extension or a Zend extension),
; you may only use these constants *after* the line that loads the extension.

;;;;;;;;;;;;;;;;;;;
; About this file ;
;;;;;;;;;;;;;;;;;;;
; PHP comes packaged with two INI files. One that is recommended to be used
; in production environments and one that is recommended to be used in
; development environments.

; php.ini-production contains settings which hold security, performance and
; best practices at its core. But please be aware, these settings may break
; compatibility with older or less security conscience applications. We
; recommending using the production ini in production and testing environments.

; php.ini-development is very similar to its production variant, except it is
; much more verbose when it comes to errors. We recommend using the
; development version only in development environments, as errors shown to
; application users can inadvertently leak otherwise secure information.

; This is php.ini-production INI file.

;;;;;;;;;;;;;;;;;;;
; Quick Reference ;
;;;;;;;;;;;;;;;;;;;
; The following are all the settings which are different in either the production
; or development versions of the INIs with respect to PHP's default behavior.
; Please see the actual settings later in the document for more details as to why
; we recommend these changes in PHP's behavior.

; display_errors
;   Default Value: On
;   Development Value: On
;   Production Value: Off

; display_startup_errors
;   Default Value: Off
;   Development Value: On
;   Production Value: Off

; error_reporting
;   Default Value: E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
;   Development Value: E_ALL
;   Production Value: E_ALL & ~E_DEPRECATED & ~E_STRICT

; html_errors
;   Default Value: On
;   Development Value: On
;   Production value: On

; log_errors
;   Default Value: Off
;   Development Value: On
;   Production Value: On

; max_input_time
;   Default Value: -1 (Unlimited)
;   Development Value: 60 (60 seconds)
;   Production Value: 60 (60 seconds)

; output_buffering
;   Default Value: Off
;   Development Value: 4096
;   Production Value: 4096

; register_argc_argv
;   Default Value: On
;   Development Value: Off
;   Production Value: Off

; register_argc_argv
;   Default Value: On
;   Development Value: Off
;   Production Value: Off

; request_order
;   Default Value: None
;   Development Value: "GP"
;   Production Value: "GP"

; session.gc_divisor
;   Default Value: 100
;   Development Value: 1000
;   Production Value: 1000

; session.sid_bits_per_character
;   Default Value: 4
;   Development Value: 5
;   Production Value: 5

; short_open_tag
;   Default Value: On
;   Development Value: Off
;   Production Value: Off

; track_errors
;   Default Value: Off
;   Development Value: On
;   Production Value: Off

; variables_order
;   Default Value: "EGPCS"
;   Development Value: "GPCS"
;   Production Value: "GPCS"

;;;;;;;;;;;;;;;;;;;;
; php.ini Options  ;
;;;;;;;;;;;;;;;;;;;;
; Name for user-defined php.ini (.htaccess) files. Default is ".user.ini"
;user_ini.filename = ".user.ini"

; To disable this feature set this option to empty value
;user_ini.filename =

; TTL for user-defined php.ini files (time-to-live) in seconds. Default is 300 seconds (5 minutes)
;user_ini.cache_ttl = 300

;;;;;;;;;;;;;;;;;;;;
; Language Options ;
;;;;;;;;;;;;;;;;;;;;

; Enable the PHP scripting language engine under Apache.
; http://php.net/engine
engine = On

; This directive determines whether or not PHP will recognize code between
; <? and ?> tags as PHP source which should be processed as such. It is
; generally recommended that <?php and ?> should be used and that this feature
; should be disabled, as enabling it may result in issues when generating XML
; documents, however this remains supported for backward compatibility reasons.
; Note that this directive does not control the <?= shorthand tag, which can be
; used regardless of this directive.
; Default Value: On
; Development Value: Off
; Production Value: Off
; http://php.net/short-open-tag
short_open_tag = Off

; The number of significant digits displayed in floating point numbers.
; http://php.net/precision
precision = 14

; Output buffering is a mechanism for controlling how much output data
; (excluding headers and cookies) PHP should keep internally before pushing that
; data to the client. If your application's output exceeds this setting, PHP
; will send that data in chunks of roughly the size you specify.
; Turning on this setting and managing its maximum buffer size can yield some
; interesting side-effects depending on your application and web server.
; You may be able to send headers and cookies after you've already sent output
; through print or echo. You also may see performance benefits if your server is
; emitting less packets due to buffered output versus PHP streaming the output
; as it gets it. On production servers, 4096 bytes is a good setting for performance
; reasons.
; Note: Output buffering can also be controlled via Output Buffering Control
;   functions.
; Possible Values:
;   On = Enabled and buffer is unlimited. (Use with caution)
;   Off = Disabled
;   Integer = Enables the buffer and sets its maximum size in bytes.
; Note: This directive is hardcoded to Off for the CLI SAPI
; Default Value: Off
; Development Value: 4096
; Production Value: 4096
; http://php.net/output-buffering
output_buffering = 4096

; You can redirect all of the output of your scripts to a function.  For
; example, if you set output_handler to "mb_output_handler", character
; encoding will be transparently converted to the specified encoding.
; Setting any output handler automatically turns on output buffering.
; Note: People who wrote portable scripts should not depend on this ini
;   directive. Instead, explicitly set the output handler using ob_start().
;   Using this ini directive may cause problems unless you know what script
;   is doing.
; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"
;   and you cannot use both "ob_gzhandler" and "zlib.output_compression".
; Note: output_handler must be empty if this is set 'On' !!!!
;   Instead you must use zlib.output_handler.
; http://php.net/output-handler
;output_handler =

; URL rewriter function rewrites URL on the fly by using
; output buffer. You can set target tags by this configuration.
; "form" tag is special tag. It will add hidden input tag to pass values.
; Refer to session.trans_sid_tags for usage.
; Default Value: "form="
; Development Value: "form="
; Production Value: "form="
;url_rewriter.tags

; URL rewriter will not rewrites absolute URL nor form by default. To enable
; absolute URL rewrite, allowed hosts must be defined at RUNTIME.
; Refer to session.trans_sid_hosts for more details.
; Default Value: ""
; Development Value: ""
; Production Value: ""
;url_rewriter.hosts

; Transparent output compression using the zlib library
; Valid values for this option are 'off', 'on', or a specific buffer size
; to be used for compression (default is 4KB)
; Note: Resulting chunk size may vary due to nature of compression. PHP
;   outputs chunks that are few hundreds bytes each as a result of
;   compression. If you prefer a larger chunk size for better
;   performance, enable output_buffering in addition.
; Note: You need to use zlib.output_handler instead of the standard
;   output_handler, or otherwise the output will be corrupted.
; http://php.net/zlib.output-compression
zlib.output_compression = Off

; http://php.net/zlib.output-compression-level
;zlib.output_compression_level = -1

; You cannot specify additional output handlers if zlib.output_compression
; is activated here. This setting does the same as output_handler but in
; a different order.
; http://php.net/zlib.output-handler
;zlib.output_handler =

; Implicit flush tells PHP to tell the output layer to flush itself
; automatically after every output block.  This is equivalent to calling the
; PHP function flush() after each and every call to print() or echo() and each
; and every HTML block.  Turning this option on has serious performance
; implications and is generally recommended for debugging purposes only.
; http://php.net/implicit-flush
; Note: This directive is hardcoded to On for the CLI SAPI
implicit_flush = Off

; The unserialize callback function will be called (with the undefined class'
; name as parameter), if the unserializer finds an undefined class
; which should be instantiated. A warning appears if the specified function is
; not defined, or if the function doesn't include/implement the missing class.
; So only set this entry, if you really want to implement such a
; callback-function.
unserialize_callback_func =

; When floats & doubles are serialized, store serialize_precision significant
; digits after the floating point. The default value ensures that when floats
; are decoded with unserialize, the data will remain the same.
; The value is also used for json_encode when encoding double values.
; If -1 is used, then dtoa mode 0 is used which automatically select the best
; precision.
serialize_precision = -1

; open_basedir, if set, limits all file operations to the defined directory
; and below.  This directive makes most sense if used in a per-directory
; or per-virtualhost web server configuration file.
; Note: disables the realpath cache
; http://php.net/open-basedir
;open_basedir =

; This directive allows you to disable certain functions for security reasons.
; It receives a comma-delimited list of function names.
; http://php.net/disable-functions
disable_functions =

; This directive allows you to disable certain classes for security reasons.
; It receives a comma-delimited list of class names.
; http://php.net/disable-classes
disable_classes =

; Colors for Syntax Highlighting mode.  Anything that's acceptable in
; <span style="color: ???????"> would work.
; http://php.net/syntax-highlighting
;highlight.string  = #DD0000
;highlight.comment = #FF9900
;highlight.keyword = #007700
;highlight.default = #0000BB
;highlight.html    = #000000

; If enabled, the request will be allowed to complete even if the user aborts
; the request. Consider enabling it if executing long requests, which may end up
; being interrupted by the user or a browser timing out. PHP's default behavior
; is to disable this feature.
; http://php.net/ignore-user-abort
;ignore_user_abort = On

; Determines the size of the realpath cache to be used by PHP. This value should
; be increased on systems where PHP opens many files to reflect the quantity of
; the file operations performed.
; Note: if open_basedir is set, the cache is disabled
; http://php.net/realpath-cache-size
;realpath_cache_size = 4096k

; Duration of time, in seconds for which to cache realpath information for a given
; file or directory. For systems with rarely changing files, consider increasing this
; value.
; http://php.net/realpath-cache-ttl
;realpath_cache_ttl = 120

; Enables or disables the circular reference collector.
; http://php.net/zend.enable-gc
zend.enable_gc = On

; If enabled, scripts may be written in encodings that are incompatible with
; the scanner.  CP936, Big5, CP949 and Shift_JIS are the examples of such
; encodings.  To use this feature, mbstring extension must be enabled.
; Default: Off
;zend.multibyte = Off

; Allows to set the default encoding for the scripts.  This value will be used
; unless "declare(encoding=...)" directive appears at the top of the script.
; Only affects if zend.multibyte is set.
; Default: ""
;zend.script_encoding =

;;;;;;;;;;;;;;;;;
; Miscellaneous ;
;;;;;;;;;;;;;;;;;

; Decides whether PHP may expose the fact that it is installed on the server
; (e.g. by adding its signature to the Web server header).  It is no security
; threat in any way, but it makes it possible to determine whether you use PHP
; on your server or not.
; http://php.net/expose-php
expose_php = On

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time = 30

; Maximum amount of time each script may spend parsing request data. It's a good
; idea to limit this time on productions servers in order to eliminate unexpectedly
; long running scripts.
; Note: This directive is hardcoded to -1 for the CLI SAPI
; Default Value: -1 (Unlimited)
; Development Value: 60 (60 seconds)
; Production Value: 60 (60 seconds)
; http://php.net/max-input-time
max_input_time = 60

; Maximum input variable nesting level
; http://php.net/max-input-nesting-level
;max_input_nesting_level = 64

; How many GET/POST/COOKIE input variables may be accepted
; max_input_vars = 1000

; Maximum amount of memory a script may consume (128MB)
; http://php.net/memory-limit
memory_limit = 128M

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; This directive informs PHP of which errors, warnings and notices you would like
; it to take action for. The recommended way of setting values for this
; directive is through the use of the error level constants and bitwise
; operators. The error level constants are below here for convenience as well as
; some common settings and their meanings.
; By default, PHP is set to take action on all errors, notices and warnings EXCEPT
; those related to E_NOTICE and E_STRICT, which together cover best practices and
; recommended coding standards in PHP. For performance reasons, this is the
; recommend error reporting setting. Your production server shouldn't be wasting
; resources complaining about best practices and coding standards. That's what
; development servers and development settings are for.
; Note: The php.ini-development file has this setting as E_ALL. This
; means it pretty much reports everything which is exactly what you want during
; development and early testing.
;
; Error Level Constants:
; E_ALL             - All errors and warnings (includes E_STRICT as of PHP 5.4.0)
; E_ERROR           - fatal run-time errors
; E_RECOVERABLE_ERROR  - almost fatal run-time errors
; E_WARNING         - run-time warnings (non-fatal errors)
; E_PARSE           - compile-time parse errors
; E_NOTICE          - run-time notices (these are warnings which often result
;                     from a bug in your code, but it's possible that it was
;                     intentional (e.g., using an uninitialized variable and
;                     relying on the fact it is automatically initialized to an
;                     empty string)
; E_STRICT          - run-time notices, enable to have PHP suggest changes
;                     to your code which will ensure the best interoperability
;                     and forward compatibility of your code
; E_CORE_ERROR      - fatal errors that occur during PHP's initial startup
; E_CORE_WARNING    - warnings (non-fatal errors) that occur during PHP's
;                     initial startup
; E_COMPILE_ERROR   - fatal compile-time errors
; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
; E_USER_ERROR      - user-generated error message
; E_USER_WARNING    - user-generated warning message
; E_USER_NOTICE     - user-generated notice message
; E_DEPRECATED      - warn about code that will not work in future versions
;                     of PHP
; E_USER_DEPRECATED - user-generated deprecation warnings
;
; Common Values:
;   E_ALL (Show all errors, warnings and notices including coding standards.)
;   E_ALL & ~E_NOTICE  (Show all errors, except for notices)
;   E_ALL & ~E_NOTICE & ~E_STRICT  (Show all errors, except for notices and coding standards warnings.)
;   E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR  (Show only errors)
; Default Value: E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
; Development Value: E_ALL
; Production Value: E_ALL & ~E_DEPRECATED & ~E_STRICT
; http://php.net/error-reporting
error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT

; This directive controls whether or not and where PHP will output errors,
; notices and warnings too. Error output is very useful during development, but
; it could be very dangerous in production environments. Depending on the code
; which is triggering the error, sensitive information could potentially leak
; out of your application such as database usernames and passwords or worse.
; For production environments, we recommend logging errors rather than
; sending them to STDOUT.
; Possible Values:
;   Off = Do not display any errors
;   stderr = Display errors to STDERR (affects only CGI/CLI binaries!)
;   On or stdout = Display errors to STDOUT
; Default Value: On
; Development Value: On
; Production Value: Off
; http://php.net/display-errors
display_errors = Off

; The display of errors which occur during PHP's startup sequence are handled
; separately from display_errors. PHP's default behavior is to suppress those
; errors from clients. Turning the display of startup errors on can be useful in
; debugging configuration problems. We strongly recommend you
; set this to 'off' for production servers.
; Default Value: Off
; Development Value: On
; Production Value: Off
; http://php.net/display-startup-errors
display_startup_errors = Off

; Besides displaying errors, PHP can also log errors to locations such as a
; server-specific log, STDERR, or a location specified by the error_log
; directive found below. While errors should not be displayed on productions
; servers they should still be monitored and logging is a great way to do that.
; Default Value: Off
; Development Value: On
; Production Value: On
; http://php.net/log-errors
log_errors = On

; Set maximum length of log_errors. In error_log information about the source is
; added. The default is 1024 and 0 allows to not apply any maximum length at all.
; http://php.net/log-errors-max-len
log_errors_max_len = 1024

; Do not log repeated messages. Repeated errors must occur in same file on same
; line unless ignore_repeated_source is set true.
; http://php.net/ignore-repeated-errors
ignore_repeated_errors = Off

; Ignore source of message when ignoring repeated messages. When this setting
; is On you will not log errors with repeated messages from different files or
; source lines.
; http://php.net/ignore-repeated-source
ignore_repeated_source = Off

; If this parameter is set to Off, then memory leaks will not be shown (on
; stdout or in the log). This has only effect in a debug compile, and if
; error reporting includes E_WARNING in the allowed list
; http://php.net/report-memleaks
report_memleaks = On

; This setting is on by default.
;report_zend_debug = 0

; Store the last error/warning message in $php_errormsg (boolean). Setting this value
; to On can assist in debugging and is appropriate for development servers. It should
; however be disabled on production servers.
; This directive is DEPRECATED.
; Default Value: Off
; Development Value: Off
; Production Value: Off
; http://php.net/track-errors
;track_errors = Off

; Turn off normal error reporting and emit XML-RPC error XML
; http://php.net/xmlrpc-errors
;xmlrpc_errors = 0

; An XML-RPC faultCode
;xmlrpc_error_number = 0

; When PHP displays or logs an error, it has the capability of formatting the
; error message as HTML for easier reading. This directive controls whether
; the error message is formatted as HTML or not.
; Note: This directive is hardcoded to Off for the CLI SAPI
; Default Value: On
; Development Value: On
; Production value: On
; http://php.net/html-errors
html_errors = On

; If html_errors is set to On *and* docref_root is not empty, then PHP
; produces clickable error messages that direct to a page describing the error
; or function causing the error in detail.
; You can download a copy of the PHP manual from http://php.net/docs
; and change docref_root to the base URL of your local copy including the
; leading '/'. You must also specify the file extension being used including
; the dot. PHP's default behavior is to leave these settings empty, in which
; case no links to documentation are generated.
; Note: Never use this feature for production boxes.
; http://php.net/docref-root
; Examples
;docref_root = "/phpmanual/"

; http://php.net/docref-ext
;docref_ext = .html

; String to output before an error message. PHP's default behavior is to leave
; this setting blank.
; http://php.net/error-prepend-string
; Example:
;error_prepend_string = "<span style='color: #ff0000'>"

; String to output after an error message. PHP's default behavior is to leave
; this setting blank.
; http://php.net/error-append-string
; Example:
;error_append_string = "</span>"

; Log errors to specified file. PHP's default behavior is to leave this value
; empty.
; http://php.net/error-log
; Example:
;error_log = php_errors.log
; Log errors to syslog (Event Log on Windows).
;error_log = syslog

;windows.show_crt_warning
; Default value: 0
; Development value: 0
; Production value: 0

;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;

; The separator used in PHP generated URLs to separate arguments.
; PHP's default setting is "&".
; http://php.net/arg-separator.output
; Example:
;arg_separator.output = "&amp;"

; List of separator(s) used by PHP to parse input URLs into variables.
; PHP's default setting is "&".
; NOTE: Every character in this directive is considered as separator!
; http://php.net/arg-separator.input
; Example:
;arg_separator.input = ";&"

; This directive determines which super global arrays are registered when PHP
; starts up. G,P,C,E & S are abbreviations for the following respective super
; globals: GET, POST, COOKIE, ENV and SERVER. There is a performance penalty
; paid for the registration of these arrays and because ENV is not as commonly
; used as the others, ENV is not recommended on productions servers. You
; can still get access to the environment variables through getenv() should you
; need to.
; Default Value: "EGPCS"
; Development Value: "GPCS"
; Production Value: "GPCS";
; http://php.net/variables-order
variables_order = "GPCS"

; This directive determines which super global data (G,P & C) should be
; registered into the super global array REQUEST. If so, it also determines
; the order in which that data is registered. The values for this directive
; are specified in the same manner as the variables_order directive,
; EXCEPT one. Leaving this value empty will cause PHP to use the value set
; in the variables_order directive. It does not mean it will leave the super
; globals array REQUEST empty.
; Default Value: None
; Development Value: "GP"
; Production Value: "GP"
; http://php.net/request-order
request_order = "GP"

; This directive determines whether PHP registers $argv & $argc each time it
; runs. $argv contains an array of all the arguments passed to PHP when a script
; is invoked. $argc contains an integer representing the number of arguments
; that were passed when the script was invoked. These arrays are extremely
; useful when running scripts from the command line. When this directive is
; enabled, registering these variables consumes CPU cycles and memory each time
; a script is executed. For performance reasons, this feature should be disabled
; on production servers.
; Note: This directive is hardcoded to On for the CLI SAPI
; Default Value: On
; Development Value: Off
; Production Value: Off
; http://php.net/register-argc-argv
register_argc_argv = Off

; When enabled, the ENV, REQUEST and SERVER variables are created when they're
; first used (Just In Time) instead of when the script starts. If these
; variables are not used within a script, having this directive on will result
; in a performance gain. The PHP directive register_argc_argv must be disabled
; for this directive to have any affect.
; http://php.net/auto-globals-jit
auto_globals_jit = On

; Whether PHP will read the POST data.
; This option is enabled by default.
; Most likely, you won't want to disable this option globally. It causes $_POST
; and $_FILES to always be empty; the only way you will be able to read the
; POST data will be through the php://input stream wrapper. This can be useful
; to proxy requests or to process the POST data in a memory efficient fashion.
; http://php.net/enable-post-data-reading
;enable_post_data_reading = Off

; Maximum size of POST data that PHP will accept.
; Its value may be 0 to disable the limit. It is ignored if POST data reading
; is disabled through enable_post_data_reading.
; http://php.net/post-max-size
post_max_size = 8M

; Automatically add files before PHP document.
; http://php.net/auto-prepend-file
auto_prepend_file =

; Automatically add files after PHP document.
; http://php.net/auto-append-file
auto_append_file =

; By default, PHP will output a media type using the Content-Type header. To
; disable this, simply set it to be empty.
;
; PHP's built-in default media type is set to text/html.
; http://php.net/default-mimetype
default_mimetype = "text/html"

; PHP's default character set is set to UTF-8.
; http://php.net/default-charset
default_charset = "UTF-8"

; PHP internal character encoding is set to empty.
; If empty, default_charset is used.
; http://php.net/internal-encoding
;internal_encoding =

; PHP input character encoding is set to empty.
; If empty, default_charset is used.
; http://php.net/input-encoding
;input_encoding =

; PHP output character encoding is set to empty.
; If empty, default_charset is used.
; See also output_buffer.
; http://php.net/output-encoding
;output_encoding =

;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;

; UNIX: "/path1:/path2"
;include_path = ".:/php/includes"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"
;
; PHP's default setting for include_path is ".;/path/to/php/pear"
; http://php.net/include-path

; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues.  The alternate is to use the
; cgi.force_redirect configuration below
; http://php.net/doc-root
doc_root =

; The directory under which PHP opens the script using /~username used only
; if nonempty.
; http://php.net/user-dir
user_dir =

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
; extension_dir = "./"
; On windows:
; extension_dir = "ext"

; Directory where the temporary files should be placed.
; Defaults to the system default (see sys_get_temp_dir)
; sys_temp_dir = "/tmp"

; Whether or not to enable the dl() function.  The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
; http://php.net/enable-dl
enable_dl = Off

; cgi.force_redirect is necessary to provide security running PHP as a CGI under
; most web servers.  Left undefined, PHP turns this on by default.  You can
; turn it off here AT YOUR OWN RISK
; **You CAN safely turn this off for IIS, in fact, you MUST.**
; http://php.net/cgi.force-redirect
;cgi.force_redirect = 1

; if cgi.nph is enabled it will force cgi to always sent Status: 200 with
; every request. PHP's default behavior is to disable this feature.
;cgi.nph = 1

; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape
; (iPlanet) web servers, you MAY need to set an environment variable name that PHP
; will look for to know it is OK to continue execution.  Setting this variable MAY
; cause security issues, KNOW WHAT YOU ARE DOING FIRST.
; http://php.net/cgi.redirect-status-env
;cgi.redirect_status_env =

; cgi.fix_pathinfo provides *real* PATH_INFO/PATH_TRANSLATED support for CGI.  PHP's
; previous behaviour was to set PATH_TRANSLATED to SCRIPT_FILENAME, and to not grok
; what PATH_INFO is.  For more information on PATH_INFO, see the cgi specs.  Setting
; this to 1 will cause PHP CGI to fix its paths to conform to the spec.  A setting
; of zero causes PHP to behave as before.  Default is 1.  You should fix your scripts
; to use SCRIPT_FILENAME rather than PATH_TRANSLATED.
; http://php.net/cgi.fix-pathinfo
;cgi.fix_pathinfo=1

; if cgi.discard_path is enabled, the PHP CGI binary can safely be placed outside
; of the web tree and people will not be able to circumvent .htaccess security.
; http://php.net/cgi.dicard-path
;cgi.discard_path=1

; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate
; security tokens of the calling client.  This allows IIS to define the
; security context that the request runs under.  mod_fastcgi under Apache
; does not currently support this feature (03/17/2002)
; Set to 1 if running under IIS.  Default is zero.
; http://php.net/fastcgi.impersonate
;fastcgi.impersonate = 1

; Disable logging through FastCGI connection. PHP's default behavior is to enable
; this feature.
;fastcgi.logging = 0

; cgi.rfc2616_headers configuration option tells PHP what type of headers to
; use when sending HTTP response code. If set to 0, PHP sends Status: header that
; is supported by Apache. When this option is set to 1, PHP will send
; RFC2616 compliant header.
; Default is zero.
; http://php.net/cgi.rfc2616-headers
;cgi.rfc2616_headers = 0
; cgi.check_shebang_line controls whether CGI PHP checks for line starting with #!
; (shebang) at the top of the running script. This line might be needed if the
; script support running both as stand-alone script and via PHP CGI<. PHP in CGI
; mode skips this line and ignores its content if this directive is turned on.
; http://php.net/cgi.check-shebang-line
;cgi.check_shebang_line=1

;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
; http://php.net/file-uploads
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
; http://php.net/upload-tmp-dir
;upload_tmp_dir =

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 2M

; Maximum number of files that can be uploaded via a single request
max_file_uploads = 20

;;;;;;;;;;;;;;;;;;
; Fopen wrappers ;
;;;;;;;;;;;;;;;;;;

; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
; http://php.net/allow-url-fopen
allow_url_fopen = On

; Whether to allow include/require to open URLs (like http:// or ftp://) as files.
; http://php.net/allow-url-include
allow_url_include = Off

; Define the anonymous ftp password (your email address). PHP's default setting
; for this is empty.
; http://php.net/from
;from="john@doe.com"

; Define the User-Agent string. PHP's default setting for this is empty.
; http://php.net/user-agent
;user_agent="PHP"

; Default timeout for socket based streams (seconds)
; http://php.net/default-socket-timeout
default_socket_timeout = 60

; If your scripts have to deal with files from Macintosh systems,
; or you are running on a Mac and need to deal with files from
; unix or win32 systems, setting this flag will cause PHP to
; automatically detect the EOL character in those files so that
; fgets() and file() will work regardless of the source of the file.
; http://php.net/auto-detect-line-endings
;auto_detect_line_endings = Off

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

; If you wish to have an extension loaded automatically, use the following
; syntax:
;
;   extension=modulename
;
; For example:
;
;   extension=mysqli
;
; When the extension library to load is not located in the default extension
; directory, You may specify an absolute path to the library file:
;
;   extension=/path/to/extension/mysqli.so
;
; Note : The syntax used in previous PHP versions ('extension=<ext>.so' and
; 'extension='php_<ext>.dll') is supported for legacy reasons and may be
; deprecated in a future PHP major version. So, when it is possible, please
; move to the new ('extension=<ext>) syntax.

;;;;
; Note: packaged extension modules are now loaded via the .ini files
; found in the directory /etc/php.d; these are loaded by default.
;;;;

;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;

[CLI Server]
; Whether the CLI web server uses ANSI color coding in its terminal output.
cli_server.color = On

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
;date.timezone =

; http://php.net/date.default-latitude
;date.default_latitude = 31.7667

; http://php.net/date.default-longitude
;date.default_longitude = 35.2333

; http://php.net/date.sunrise-zenith
;date.sunrise_zenith = 90.583333

; http://php.net/date.sunset-zenith
;date.sunset_zenith = 90.583333

[filter]
; http://php.net/filter.default
;filter.default = unsafe_raw

; http://php.net/filter.default-flags
;filter.default_flags =

[iconv]
; Use of this INI entry is deprecated, use global input_encoding instead.
; If empty, default_charset or input_encoding or iconv.input_encoding is used.
; The precedence is: default_charset < intput_encoding < iconv.input_encoding
;iconv.input_encoding =

; Use of this INI entry is deprecated, use global internal_encoding instead.
; If empty, default_charset or internal_encoding or iconv.internal_encoding is used.
; The precedence is: default_charset < internal_encoding < iconv.internal_encoding
;iconv.internal_encoding =

; Use of this INI entry is deprecated, use global output_encoding instead.
; If empty, default_charset or output_encoding or iconv.output_encoding is used.
; The precedence is: default_charset < output_encoding < iconv.output_encoding
; To use an output encoding conversion, iconv's output handler must be set
; otherwise output encoding conversion cannot be performed.
;iconv.output_encoding =

[imap]
; rsh/ssh logins are disabled by default. Use this INI entry if you want to
; enable them. Note that the IMAP library does not filter mailbox names before
; passing them to rsh/ssh command, thus passing untrusted data to this function
; with rsh/ssh enabled is insecure.
;imap.enable_insecure_rsh=0

[intl]
;intl.default_locale =
; This directive allows you to produce PHP errors when some error
; happens within intl functions. The value is the level of the error produced.
; Default is 0, which does not produce any errors.
;intl.error_level = E_WARNING
;intl.use_exceptions = 0

[sqlite3]
; Directory pointing to SQLite3 extensions
; http://php.net/sqlite3.extension-dir
;sqlite3.extension_dir =

; SQLite defensive mode flag (only available from SQLite 3.26+)
; When the defensive flag is enabled, language features that allow ordinary
; SQL to deliberately corrupt the database file are disabled. This forbids
; writing directly to the schema, shadow tables (eg. FTS data tables), or
; the sqlite_dbpage virtual table.
; https://www.sqlite.org/c3ref/c_dbconfig_defensive.html
; (for older SQLite versions, this flag has no use)
;sqlite3.defensive = 1

[Pcre]
;PCRE library backtracking limit.
; http://php.net/pcre.backtrack-limit
;pcre.backtrack_limit=100000

;PCRE library recursion limit.
;Please note that if you set this value to a high number you may consume all
;the available process stack and eventually crash PHP (due to reaching the
;stack size limit imposed by the Operating System).
; http://php.net/pcre.recursion-limit
;pcre.recursion_limit=100000

;Enables or disables JIT compilation of patterns. This requires the PCRE
;library to be compiled with JIT support.
pcre.jit=0

[Pdo]
; Whether to pool ODBC connections. Can be one of "strict", "relaxed" or "off"
; http://php.net/pdo-odbc.connection-pooling
;pdo_odbc.connection_pooling=strict

;pdo_odbc.db2_instance_name

[Pdo_mysql]
; If mysqlnd is used: Number of cache slots for the internal result set cache
; http://php.net/pdo_mysql.cache_size
pdo_mysql.cache_size = 2000

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
; http://php.net/pdo_mysql.default-socket
pdo_mysql.default_socket=

[Phar]
; http://php.net/phar.readonly
;phar.readonly = On

; http://php.net/phar.require-hash
;phar.require_hash = On

;phar.cache_list =

[mail function]
; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").
; http://php.net/sendmail-path
sendmail_path = /usr/sbin/sendmail -t -i

; Force the addition of the specified parameters to be passed as extra parameters
; to the sendmail binary. These parameters will always replace the value of
; the 5th parameter to mail().
;mail.force_extra_parameters =

; Add X-PHP-Originating-Script: that will include uid of the script followed by the filename
mail.add_x_header = Off

; The path to a log file that will log all mail() calls. Log entries include
; the full path of the script, line number, To address and headers.
;mail.log =
; Log mail to syslog (Event Log on Windows).
;mail.log = syslog

[ODBC]
; http://php.net/odbc.default-db
;odbc.default_db    =  Not yet implemented

; http://php.net/odbc.default-user
;odbc.default_user  =  Not yet implemented

; http://php.net/odbc.default-pw
;odbc.default_pw    =  Not yet implemented

; Controls the ODBC cursor model.
; Default: SQL_CURSOR_STATIC (default).
;odbc.default_cursortype

; Allow or prevent persistent links.
; http://php.net/odbc.allow-persistent
odbc.allow_persistent = On
; Check that a connection is still valid before reuse.
; http://php.net/odbc.check-persistent
odbc.check_persistent = On

; Maximum number of persistent links.  -1 means no limit.
; http://php.net/odbc.max-persistent
odbc.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
; http://php.net/odbc.max-links
odbc.max_links = -1

; Handling of LONG fields.  Returns number of bytes to variables.  0 means
; passthru.
; http://php.net/odbc.defaultlrl
odbc.defaultlrl = 4096

; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.
; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
; of odbc.defaultlrl and odbc.defaultbinmode
; http://php.net/odbc.defaultbinmode
odbc.defaultbinmode = 1

;birdstep.max_links = -1

[Interbase]
; Allow or prevent persistent links.
ibase.allow_persistent = 1

; Maximum number of persistent links.  -1 means no limit.
ibase.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
ibase.max_links = -1

; Default database name for ibase_connect().
;ibase.default_db =

; Default username for ibase_connect().
;ibase.default_user =

; Default password for ibase_connect().
;ibase.default_password =

; Default charset for ibase_connect().
;ibase.default_charset =

; Default timestamp format.
ibase.timestampformat = "%Y-%m-%d %H:%M:%S"

; Default date format.
ibase.dateformat = "%Y-%m-%d"

; Default time format.
ibase.timeformat = "%H:%M:%S"

[MySQLi]

; Maximum number of persistent links.  -1 means no limit.
; http://php.net/mysqli.max-persistent
mysqli.max_persistent = -1

; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
; http://php.net/mysqli.allow_local_infile
;mysqli.allow_local_infile = On

; Allow or prevent persistent links.
; http://php.net/mysqli.allow-persistent
mysqli.allow_persistent = On

; Maximum number of links.  -1 means no limit.
; http://php.net/mysqli.max-links
mysqli.max_links = -1

; If mysqlnd is used: Number of cache slots for the internal result set cache
; http://php.net/mysqli.cache_size
mysqli.cache_size = 2000

; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
; http://php.net/mysqli.default-port
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
; http://php.net/mysqli.default-socket
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysqli.default-host
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysqli.default-user
mysqli.default_user =

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
; http://php.net/mysqli.default-pw
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off

[mysqlnd]
; Enable / Disable collection of general statistics by mysqlnd which can be
; used to tune and monitor MySQL operations.
; http://php.net/mysqlnd.collect_statistics
mysqlnd.collect_statistics = On

; Enable / Disable collection of memory usage statistics by mysqlnd which can be
; used to tune and monitor MySQL operations.
; http://php.net/mysqlnd.collect_memory_statistics
mysqlnd.collect_memory_statistics = Off

; Records communication from all extensions using mysqlnd to the specified log
; file.
; http://php.net/mysqlnd.debug
;mysqlnd.debug =

; Defines which queries will be logged.
; http://php.net/mysqlnd.log_mask
;mysqlnd.log_mask = 0
; Default size of the mysqlnd memory pool, which is used by result sets.
; http://php.net/mysqlnd.mempool_default_size
;mysqlnd.mempool_default_size = 16000

; Size of a pre-allocated buffer used when sending commands to MySQL in bytes.
; http://php.net/mysqlnd.net_cmd_buffer_size
;mysqlnd.net_cmd_buffer_size = 2048

; Size of a pre-allocated buffer used for reading data sent by the server in
; bytes.
; http://php.net/mysqlnd.net_read_buffer_size
;mysqlnd.net_read_buffer_size = 32768

; Timeout for network requests in seconds.
; http://php.net/mysqlnd.net_read_timeout
;mysqlnd.net_read_timeout = 31536000

; SHA-256 Authentication Plugin related. File with the MySQL server public RSA
; key.
; http://php.net/mysqlnd.sha256_server_public_key
;mysqlnd.sha256_server_public_key =

[PostgreSQL]
; Allow or prevent persistent links.
; http://php.net/pgsql.allow-persistent
pgsql.allow_persistent = On

; Detect broken persistent links always with pg_pconnect().
; Auto reset feature requires a little overheads.
; http://php.net/pgsql.auto-reset-persistent
pgsql.auto_reset_persistent = Off

; Maximum number of persistent links.  -1 means no limit.
; http://php.net/pgsql.max-persistent
pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
; http://php.net/pgsql.max-links
pgsql.max_links = -1

; Ignore PostgreSQL backends Notice message or not.
; Notice message logging require a little overheads.
; http://php.net/pgsql.ignore-notice
pgsql.ignore_notice = 0

; Log PostgreSQL backends Notice message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
; http://php.net/pgsql.log-notice
pgsql.log_notice = 0

[bcmath]
; Number of decimal digits for all bcmath functions.
; http://php.net/bcmath.scale
bcmath.scale = 0

[browscap]
; http://php.net/browscap
;browscap = extra/browscap.ini

[Session]
; Handler used to store/retrieve data.
; http://php.net/session.save-handler
session.save_handler = files

; Argument passed to save_handler.  In the case of files, this is the path
; where data files are stored. Note: Windows users have to change this
; variable in order to use PHP's session functions.
;
; The path can be defined as:
;
;     session.save_path = "N;/path"
;
; where N is an integer.  Instead of storing all the session files in
; /path, what this will do is use subdirectories N-levels deep, and
; store the session data in those directories.  This is useful if
; your OS has problems with many files in one directory, and is
; a more efficient layout for servers that handle many sessions.
;
; NOTE 1: PHP will not create this directory structure automatically.
;         You can use the script in the ext/session dir for that purpose.
; NOTE 2: See the section on garbage collection below if you choose to
;         use subdirectories for session storage
;
; The file storage module creates files using mode 600 by default.
; You can change that by using
;
;     session.save_path = "N;MODE;/path"
;
; where MODE is the octal representation of the mode. Note that this
; does not overwrite the process's umask.
; http://php.net/session.save-path

; RPM note : session directory must be owned by process owner
; for mod_php, see /etc/httpd/conf.d/php.conf
; for php-fpm, see /etc/php-fpm.d/*conf
;session.save_path = "/tmp"

; Whether to use strict session mode.
; Strict session mode does not accept uninitialized session ID and regenerate
; session ID if browser sends uninitialized session ID. Strict mode protects
; applications from session fixation via session adoption vulnerability. It is
; disabled by default for maximum compatibility, but enabling it is encouraged.
; https://wiki.php.net/rfc/strict_sessions
session.use_strict_mode = 0

; Whether to use cookies.
; http://php.net/session.use-cookies
session.use_cookies = 1

; http://php.net/session.cookie-secure
;session.cookie_secure =

; This option forces PHP to fetch and use a cookie for storing and maintaining
; the session id. We encourage this operation as it's very helpful in combating
; session hijacking when not specifying and managing your own session id. It is
; not the be-all and end-all of session hijacking defense, but it's a good start.
; http://php.net/session.use-only-cookies
session.use_only_cookies = 1

; Name of the session (used as cookie name).
; http://php.net/session.name
session.name = PHPSESSID

; Initialize session on request startup.
; http://php.net/session.auto-start
session.auto_start = 0

; Lifetime in seconds of cookie or, if 0, until browser is restarted.
; http://php.net/session.cookie-lifetime
session.cookie_lifetime = 0

; The path for which the cookie is valid.
; http://php.net/session.cookie-path
session.cookie_path = /

; The domain for which the cookie is valid.
; http://php.net/session.cookie-domain
session.cookie_domain =

; Whether or not to add the httpOnly flag to the cookie, which makes it inaccessible to browser scripting languages such as JavaScript.
; http://php.net/session.cookie-httponly
session.cookie_httponly =

; Handler used to serialize data.  php is the standard serializer of PHP.
; http://php.net/session.serialize-handler
session.serialize_handler = php

; Defines the probability that the 'garbage collection' process is started
; on every session initialization. The probability is calculated by using
; gc_probability/gc_divisor. Where session.gc_probability is the numerator
; and gc_divisor is the denominator in the equation. Setting this value to 1
; when the session.gc_divisor value is 100 will give you approximately a 1% chance
; the gc will run on any give request.
; Default Value: 1
; Development Value: 1
; Production Value: 1
; http://php.net/session.gc-probability
session.gc_probability = 1

; Defines the probability that the 'garbage collection' process is started on every
; session initialization. The probability is calculated by using the following equation:
; gc_probability/gc_divisor. Where session.gc_probability is the numerator and
; session.gc_divisor is the denominator in the equation. Setting this value to 1
; when the session.gc_divisor value is 100 will give you approximately a 1% chance
; the gc will run on any give request. Increasing this value to 1000 will give you
; a 0.1% chance the gc will run on any give request. For high volume production servers,
; this is a more efficient approach.
; Default Value: 100
; Development Value: 1000
; Production Value: 1000
; http://php.net/session.gc-divisor
session.gc_divisor = 1000

; After this number of seconds, stored data will be seen as 'garbage' and
; cleaned up by the garbage collection process.
; http://php.net/session.gc-maxlifetime
session.gc_maxlifetime = 1440

; NOTE: If you are using the subdirectory option for storing session files
;       (see session.save_path above), then garbage collection does *not*
;       happen automatically.  You will need to do your own garbage
;       collection through a shell script, cron entry, or some other method.
;       For example, the following script would is the equivalent of
;       setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):
;          find /path/to/sessions -cmin +24 -type f | xargs rm

; Check HTTP Referer to invalidate externally stored URLs containing ids.
; HTTP_REFERER has to contain this substring for the session to be
; considered as valid.
; http://php.net/session.referer-check
session.referer_check =

; Set to {nocache,private,public,} to determine HTTP caching aspects
; or leave this empty to avoid sending anti-caching headers.
; http://php.net/session.cache-limiter
session.cache_limiter = nocache

; Document expires after n minutes.
; http://php.net/session.cache-expire
session.cache_expire = 180

; trans sid support is disabled by default.
; Use of trans sid may risk your users' security.
; Use this option with caution.
; - User may send URL contains active session ID
;   to other person via. email/irc/etc.
; - URL that contains active session ID may be stored
;   in publicly accessible computer.
; - User may access your site with the same session ID
;   always using URL stored in browser's history or bookmarks.
; http://php.net/session.use-trans-sid
session.use_trans_sid = 0

; Set session ID character length. This value could be between 22 to 256.
; Shorter length than default is supported only for compatibility reason.
; Users should use 32 or more chars.
; http://php.net/session.sid-length
; Default Value: 32
; Development Value: 26
; Production Value: 26
session.sid_length = 26

; The URL rewriter will look for URLs in a defined set of HTML tags.
; <form> is special; if you include them here, the rewriter will
; add a hidden <input> field with the info which is otherwise appended
; to URLs. <form> tag's action attribute URL will not be modified
; unless it is specified.
; Note that all valid entries require a "=", even if no value follows.
; Default Value: "a=href,area=href,frame=src,form="
; Development Value: "a=href,area=href,frame=src,form="
; Production Value: "a=href,area=href,frame=src,form="
; http://php.net/url-rewriter.tags
session.trans_sid_tags = "a=href,area=href,frame=src,form="

; URL rewriter does not rewrite absolute URLs by default.
; To enable rewrites for absolute pathes, target hosts must be specified
; at RUNTIME. i.e. use ini_set()
; <form> tags is special. PHP will check action attribute's URL regardless
; of session.trans_sid_tags setting.
; If no host is defined, HTTP_HOST will be used for allowed host.
; Example value: php.net,www.php.net,wiki.php.net
; Use "," for multiple hosts. No spaces are allowed.
; Default Value: ""
; Development Value: ""
; Production Value: ""
;session.trans_sid_hosts=""

; Define how many bits are stored in each character when converting
; the binary hash data to something readable.
; Possible values:
;   4  (4 bits: 0-9, a-f)
;   5  (5 bits: 0-9, a-v)
;   6  (6 bits: 0-9, a-z, A-Z, "-", ",")
; Default Value: 4
; Development Value: 5
; Production Value: 5
; http://php.net/session.hash-bits-per-character
session.sid_bits_per_character = 5

; Enable upload progress tracking in $_SESSION
; Default Value: On
; Development Value: On
; Production Value: On
; http://php.net/session.upload-progress.enabled
;session.upload_progress.enabled = On

; Cleanup the progress information as soon as all POST data has been read
; (i.e. upload completed).
; Default Value: On
; Development Value: On
; Production Value: On
; http://php.net/session.upload-progress.cleanup
;session.upload_progress.cleanup = On

; A prefix used for the upload progress key in $_SESSION
; Default Value: "upload_progress_"
; Development Value: "upload_progress_"
; Production Value: "upload_progress_"
; http://php.net/session.upload-progress.prefix
;session.upload_progress.prefix = "upload_progress_"

; The index name (concatenated with the prefix) in $_SESSION
; containing the upload progress information
; Default Value: "PHP_SESSION_UPLOAD_PROGRESS"
; Development Value: "PHP_SESSION_UPLOAD_PROGRESS"
; Production Value: "PHP_SESSION_UPLOAD_PROGRESS"
; http://php.net/session.upload-progress.name
;session.upload_progress.name = "PHP_SESSION_UPLOAD_PROGRESS"

; How frequently the upload progress should be updated.
; Given either in percentages (per-file), or in bytes
; Default Value: "1%"
; Development Value: "1%"
; Production Value: "1%"
; http://php.net/session.upload-progress.freq
;session.upload_progress.freq =  "1%"

; The minimum delay between updates, in seconds
; Default Value: 1
; Development Value: 1
; Production Value: 1
; http://php.net/session.upload-progress.min-freq
;session.upload_progress.min_freq = "1"

; Only write session data when session data is changed. Enabled by default.
; http://php.net/session.lazy-write
;session.lazy_write = On

[Assertion]
; Switch whether to compile assertions at all (to have no overhead at run-time)
; -1: Do not compile at all
;  0: Jump over assertion at run-time
;  1: Execute assertions
; Changing from or to a negative value is only possible in php.ini! (For turning assertions on and off at run-time, see assert.active, when zend.assertions = 1)
; Default Value: 1
; Development Value: 1
; Production Value: -1
; http://php.net/zend.assertions
zend.assertions = -1

; Assert(expr); active by default.
; http://php.net/assert.active
;assert.active = On

; Throw an AssertationException on failed assertions
; http://php.net/assert.exception
;assert.exception = On

; Issue a PHP warning for each failed assertion. (Overridden by assert.exception if active)
; http://php.net/assert.warning
;assert.warning = On

; Don't bail out by default.
; http://php.net/assert.bail
;assert.bail = Off

; User-function to be called if an assertion fails.
; http://php.net/assert.callback
;assert.callback = 0

; Eval the expression with current error_reporting().  Set to true if you want
; error_reporting(0) around the eval().
; http://php.net/assert.quiet-eval
;assert.quiet_eval = 0

[mbstring]
; language for internal character representation.
; This affects mb_send_mail() and mbstring.detect_order.
; http://php.net/mbstring.language
;mbstring.language = Japanese

; Use of this INI entry is deprecated, use global internal_encoding instead.
; internal/script encoding.
; Some encoding cannot work as internal encoding. (e.g. SJIS, BIG5, ISO-2022-*)
; If empty, default_charset or internal_encoding or iconv.internal_encoding is used.
; The precedence is: default_charset < internal_encoding < iconv.internal_encoding
;mbstring.internal_encoding =

; Use of this INI entry is deprecated, use global input_encoding instead.
; http input encoding.
; mbstring.encoding_traslation = On is needed to use this setting.
; If empty, default_charset or input_encoding or mbstring.input is used.
; The precedence is: default_charset < intput_encoding < mbsting.http_input
; http://php.net/mbstring.http-input
;mbstring.http_input =
; Use of this INI entry is deprecated, use global output_encoding instead.
; http output encoding.
; mb_output_handler must be registered as output buffer to function.
; If empty, default_charset or output_encoding or mbstring.http_output is used.
; The precedence is: default_charset < output_encoding < mbstring.http_output
; To use an output encoding conversion, mbstring's output handler must be set
; otherwise output encoding conversion cannot be performed.
; http://php.net/mbstring.http-output
;mbstring.http_output =

; enable automatic encoding translation according to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
;       portable libs/applications.
; http://php.net/mbstring.encoding-translation
;mbstring.encoding_translation = Off

; automatic encoding detection order.
; "auto" detect order is changed according to mbstring.language
; http://php.net/mbstring.detect-order
;mbstring.detect_order = auto

; substitute_character used when character cannot be converted
; one from another
; http://php.net/mbstring.substitute-character
;mbstring.substitute_character = none

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
; http://php.net/mbstring.func-overload
;mbstring.func_overload = 0

; enable strict encoding detection.
; Default: Off
;mbstring.strict_detection = On

; This directive specifies the regex pattern of content types for which mb_output_handler()
; is activated.
; Default: mbstring.http_output_conv_mimetype=^(text/|application/xhtml\+xml)
;mbstring.http_output_conv_mimetype=

[gd]
; Tell the jpeg decode to ignore warnings and try to create
; a gd image. The warning will then be displayed as notices
; disabled by default
; http://php.net/gd.jpeg-ignore-warning
;gd.jpeg_ignore_warning = 1

[exif]
; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.
; With mbstring support this will automatically be converted into the encoding
; given by corresponding encode setting. When empty mbstring.internal_encoding
; is used. For the decode settings you can distinguish between motorola and
; intel byte order. A decode setting cannot be empty.
; http://php.net/exif.encode-unicode
;exif.encode_unicode = ISO-8859-15

; http://php.net/exif.decode-unicode-motorola
;exif.decode_unicode_motorola = UCS-2BE

; http://php.net/exif.decode-unicode-intel
;exif.decode_unicode_intel    = UCS-2LE

; http://php.net/exif.encode-jis
;exif.encode_jis =

; http://php.net/exif.decode-jis-motorola
;exif.decode_jis_motorola = JIS

; http://php.net/exif.decode-jis-intel
;exif.decode_jis_intel    = JIS

[Tidy]
; The path to a default tidy configuration file to use when using tidy
; http://php.net/tidy.default-config
;tidy.default_config = /usr/local/lib/php/default.tcfg

; Should tidy clean and repair output automatically?
; WARNING: Do not use this option if you are generating non-html content
; such as dynamic images
; http://php.net/tidy.clean-output
tidy.clean_output = Off

[soap]
; Enables or disables WSDL caching feature.
; http://php.net/soap.wsdl-cache-enabled
soap.wsdl_cache_enabled=1

; Sets the directory name where SOAP extension will put cache files.
; http://php.net/soap.wsdl-cache-dir

; RPM note : cache directory must be owned by process owner
; for mod_php, see /etc/httpd/conf.d/php.conf
; for php-fpm, see /etc/php-fpm.d/*conf
soap.wsdl_cache_dir="/tmp"

; (time to live) Sets the number of second while cached file will be used
; instead of original one.
; http://php.net/soap.wsdl-cache-ttl
soap.wsdl_cache_ttl=86400

; Sets the size of the cache limit. (Max. number of WSDL files to cache)
soap.wsdl_cache_limit = 5

[sysvshm]
; A default size of the shared memory segment
;sysvshm.init_mem = 10000

[ldap]
; Sets the maximum number of open links or -1 for unlimited.
ldap.max_links = -1

[dba]
;dba.default_handler=

[curl]
; A default value for the CURLOPT_CAINFO option. This is required to be an
; absolute path.
;curl.cainfo =

[openssl]
; The location of a Certificate Authority (CA) file on the local filesystem
; to use when verifying the identity of SSL/TLS peers. Most users should
; not specify a value for this directive as PHP will attempt to use the
; OS-managed cert stores in its absence. If specified, this value may still
; be overridden on a per-stream basis via the "cafile" SSL stream context
; option.
;openssl.cafile=

; If openssl.cafile is not specified or if the CA file is not found, the
; directory pointed to by openssl.capath is searched for a suitable
; certificate. This value must be a correctly hashed certificate directory.
; Most users should not specify a value for this directive as PHP will
; attempt to use the OS-managed cert stores in its absence. If specified,
; this value may still be overridden on a per-stream basis via the "capath"
; SSL stream context option.
;openssl.capath=

; Local Variables:
; tab-width: 4
;extension=imagick.so
extension=gd
; End:
snipe commented 3 years ago

@LecrisUT

Unrelated, but is the OAuth option in the settings to setup snipe-it as the OAuth server or to setup OAuth authentication on the snipe-it server? And how do we setup OAuth authentication to link to KeyCloak for example?

Right now, the OAuth client setup doesn't really work. You'd be better off setting up a SAML integration, if KeyCloak offers it

PengKuang commented 3 years ago

Right now, the OAuth client setup doesn't really work. You'd be better off setting up a SAML integration, if KeyCloak offers it

I don't understand what you're saying, it's out of the scope of my knowledge...but in our organization, we use windows AD. And the old server had no problem with it. All login and records worked fine. I just copied the .env setting of the old server.

LecrisUT commented 3 years ago

@PengKuang I don't see anything wrong with that, mine is the same. @snipe Could you include a tutorial for setting up SAML? KeyCloak does offer it, but as a newbie to it there are a lot of settings that is not intuitive how/which to set. Edit: sorry for the confusing tangent.

snipe commented 3 years ago

@PengKuang

I don't understand what you're saying, it's out of the scope of my knowledge

That comment was meant for @LecrisUT - apologies for adding to the confusion.

@LecrisUT

Could you include a tutorial for setting up SAML?

I'm not familiar with KeyCloak, so I'm not sure how to walk you through that exactly, but we do have docs on SAML here: https://snipe-it.readme.io/docs/saml

Snipe-IT Documentation
SAML
Configuration guidelines for SAML Single-Sign On (SSO) support
PengKuang commented 3 years ago

I'm not sure whether you can just regenerate a new APP_KEY and the credential of the users, but it doesn't hurt trying. If you have been upgrading from an older installation could this be relevant?

Ohh, just saw the link. It seems getting more and more complicated...the problem is my case is more like a migration rather than a upgrade. I only wanted the old data. And my install is a fresh one on a complete new server.

I wonder if a complete reinstallation would offset the effort for resolving this unauthenticated issue...

btw, the old snipe-it we were using is 4.x

LecrisUT commented 3 years ago

@PengKuang Please use a gist to share large text files like the php.ini. I believe on a CentOS repository installation, all of the modules are enabled by default, check the config files in /etc/php.d. For example here is from /etc/php.d/10-opcache.ini:

; Enable Zend OPcache extension module
zend_extension=opcache
; Determines if Zend OPCache is enabled
opcache.enable=1
; Determines if Zend OPCache is enabled for the CLI version of PHP
opcache.enable_cli=1

@snipe Thank you for looking into this issue. This issue should be fairly reproduceable on a clean CentOS 8 installation, even on a VM following the instructions given in the documentation, although it's quite troublesome to setup. Probably setting up a CI would catch this issue.

Since you've mentioned that you could not replicate on your environments, I will try to recall the steps I initially done to setup the initial snipe-it where this problem occurred are:

Things that I've done since:

snipe commented 3 years ago

Never run composer as sudo :( We mention it several times in the docs, and composer itself tells you not to do it.

Please see my additional comments here: https://github.com/snipe/snipe-it/issues/8458#issuecomment-724443005

snipe commented 3 years ago

If you've got debug mode turned on, you should be able to go to /admin/phpinfo and see what all extensions the web server thinks you've got installed (versus cli)

PengKuang commented 3 years ago

This is what in my cache folder:

[peng@ITAssets snipe-it]$ ls bootstrap/cache
config.php  packages.php  services.php

I don't think I used php-fpm btw, or caddy. I don't know what they do.

LecrisUT commented 3 years ago

Yes, I've only ran composer as sudo for debugging purposes, to make sure there is no PATH issue or something similar. I have checked your comments in #8458 which is why I've mentioned that I might have run php upgrade as well. As for the extensions, all of the rest are included in php-common. I've checked it back then with php -m.

You should include the point about /admin/phpinfo in the documentation. It would have been useful when I first encountered this problem.

PS: Currently my snipe-it installation works, but I don't know what black-magic I've done in getting it to work.

LecrisUT commented 3 years ago

@PengKuang you are using php-fpm, it is included in the dnf list --installed you've provided. The httpd (CentOS name for Apache server) automatically loads it. If you don't also have Nginx or other webservers, in principle you don't need to worry about it, just make sure it is running.

As for caddy it is a web server like Apache, but much much easier to setup. I recommend @snipe to include a Caddyfile like mine in the documentation for future installations. .htaccess need to be redone for it, but out of the bat, it includes the most used rewrites so that the Caddyfile I provided is plenty sufficient (even for setting up ssl).

PengKuang commented 3 years ago

this what I got when ran the recommended clean-up commands:

[peng@ITassets snipe-it]$ sudo systemctl restart httpd
[peng@ITassets snipe-it]$ sudo vi .env
[sudo] password for peng:
[peng@ITassets snipe-it]$ ls /etc/httpd
conf  conf.d  conf.modules.d  logs  modules  run  sites-available  sites-enabled  state
[peng@ITassets snipe-it]$ ls /etc/httpd/sites-available
snipeit.conf
[peng@ITassets snipe-it]$ sudo /etc/httpd/sites-available/snipeit.conf
sudo: /etc/httpd/sites-available/snipeit.conf: command not found
[peng@ITassets snipe-it]$ sudo vi /etc/httpd/sites-available/snipeit.conf
[peng@ITassets snipe-it]$ apachectl configtest
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using xx.xx.xx.xx. Set the 'ServerName' directive globally to suppress this message
Syntax OK
[peng@ITassets snipe-it]$ ls /etc/httpd/conf
httpd.conf  magic
[peng@ITassets snipe-it]$ sudo vi /etc/httpd/conf/httpd.conf
[peng@ITassets snipe-it]$ apachectl configtest
Syntax OK
[peng@ITassets snipe-it]$ sudo sytemctl restart httpd
sudo: sytemctl: command not found
[peng@ITassets snipe-it]$ sudo systemctl restart httpd
[peng@ITassets snipe-it]$ composer dump-autoload
Generating optimized autoload files
com> Illuminate\Foundation\ComposerScripts::postAutoloadDump
Generated optimized autoload files containing 7294 classes
[peng@ITassets snipe-it]$ composer clear-compiled

  [Symfony\Component\Console\Exception\CommandNotFoundException]
  Command "clear-compiled" is not defined.

[peng@ITassets snipe-it]$ php artisan config:clear
Configuration cache cleared!
[peng@ITassets snipe-it]$ php artisan view:clear
Compiled views cleared!
[peng@ITassets snipe-it]$ php artisan cache:clear
Failed to clear cache. Make sure you have the appropriate permissions.
[peng@ITassets snipe-it]$ sudo php artisan cache:clear
[sudo] password for peng:
Application cache cleared!
[peng@ITassets snipe-it]$ sudo php artisan route:clear
Route cache cleared!
[peng@ITassets snipe-it]$ php artisan migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Nothing to migrate.
[peng@ITassets snipe-it]$ php artisan passport:client --personal

 What should we name the personal access client? [Snipe-IT Personal Access Client]:
 >

Personal access client created successfully.
Client ID: 3
Client secret: sffjfdsfsdfjdsljl
[peng@ITassets snipe-it]$
PengKuang commented 3 years ago

If you've got debug mode turned on, you should be able to go to /admin/phpinfo and see what all extensions the web server thinks you've got installed (versus cli)

How can I do this? I don see there is option for me to navigate to this folder.

snipe commented 3 years ago

@LecrisUT

PS: Currently my snipe-it installation works, but I don't know what black-magic I've done in getting it to work.

My guess would be running the upgrade.php did it.

I recommend @snipe to include a Caddyfile like mine in the documentation for future installations.

I don't know Caddy at all, so that's not really possible at this point.

.htaccess need to be redone for it, but out of the bat, it includes the most used rewrites so that the Caddyfile I provided is plenty sufficient

That would break things though, since the .htaccess is included with source and is currently designed to work out of the box. Any changes to that could break things for other people when they update their installations.

@PengKuang

this what I got when ran the recommended clean-up commands:

php artisan cache:clear Failed to clear cache. Make sure you have the appropriate permissions.

It looks like something funny is happening there... Can you make sure the storage directory and ALL subdirectories is writable by whatever the web server runs as, and also make sure that the the your cli user can also write to that directory?

How can I do this? I don see there is option for me to navigate to this folder.

You can go to Admin > Settings and click on PHP, or just type that part into your browser.

LecrisUT commented 3 years ago

You should change the ownership of snipe-it to the webserver user and run the php commands as sudo -u $webserver_user. For CentOS and Apache it is apache.

/admin/phpinfo would refer to navigating the snipe-it url: e.g. https://snipe-it/admin/phpinfo.

LecrisUT commented 3 years ago

@snipe The reason I recommend Caddy is that it is super easy to setup on both the developer and client side, and why I recommend to look into it. That file is the only configuration needed to get the webserver working. I am migrating as much as possible to it.

.htaccess need to be redone for it, but out of the bat, it includes the most used rewrites so that the Caddyfile I provided is plenty sufficient

That would break things though, since the .htaccess is included with source and is currently designed to work out of the box. Any changes to that could break things for other people when they update their installations.

Sorry I meant including the rewrites in .htaccess to the Caddyfile. But in this case it is not necessary, since all of the configurations are standard ones that Caddy sets up automatically.

PengKuang commented 3 years ago

I don't think the permissions are incorrect. I've check this multiple times. I ran the command above using my personal account at the organization, that's why I didn't have appropriate permission and needed to run them as sudo. But the snipe-it directory is in 755, storage & public/uploads are in 775; and their owner is snipit (which belongs to apache group) and the group is apache.

[peng.xxx@xxx.xxx.xxx@ITAssets html]$ ls -al snipe-it
total 3288
drwxr-xr-x. 17 snipeit apache    4096 Nov 10 13:52 .
drwxr-xr-x.  3 apache  apache      22 Sep 15 23:46 ..
-rwxr-xr-x.  1 snipeit apache   52219 Nov  8 15:33 .all-contributorsrc
drwxr-xr-x.  3 snipeit apache      21 Nov  8 15:33 ansible
drwxr-xr-x. 18 snipeit apache     267 Nov  8 15:33 app
-rwxr-xr-x.  1 snipeit apache    1646 Nov  8 15:33 artisan
drwxr-xr-x.  3 snipeit apache      54 Nov  8 15:33 bootstrap
-rwxr-xr-x.  1 snipeit apache    9210 Nov  8 15:33 c3.php
-rwxr-xr-x.  1 snipeit apache     373 Nov  8 15:33 codeception.yml
-rwxr-xr-x.  1 snipeit apache    3228 Nov  8 15:33 CODE_OF_CONDUCT.md
-rwxr-xr-x.  1 snipeit apache    3124 Nov  8 15:33 composer.json
-rwxr-xr-x.  1 snipeit apache  402728 Nov  8 18:47 composer.lock
-rwxr-xr-x.  1 snipeit apache 2192976 Nov 10 09:01 composer.phar
drwxr-xr-x.  2 snipeit apache    4096 Nov  8 15:33 config
-rwxr-xr-x.  1 snipeit apache       0 Nov  8 15:33 _config.yml
-rwxr-xr-x.  1 snipeit apache     317 Nov  8 15:33 CONTRIBUTING.md
-rwxr-xr-x.  1 snipeit apache      90 Nov  8 15:33 crowdin.yml
drwxr-xr-x.  5 snipeit apache      72 Nov  8 15:33 database
drwxr-xr-x.  2 snipeit apache     247 Nov  8 15:33 docker
-rwxr-xr-x.  1 snipeit apache    3836 Nov  8 15:33 Dockerfile
-rwxr-xr-x.  1 snipeit apache    2371 Nov  8 15:33 Dockerfile.alpine
-rwxr-xr-x.  1 snipeit apache     156 Nov  8 15:33 .dockerignore
-rwxr-xr-x.  1 snipeit apache    4082 Nov 10 13:52 .env
-rwxr-xr-x.  1 snipeit apache    3889 Nov  8 15:33 .env.example
-rwxr-xr-x.  1 snipeit apache    1889 Nov  8 15:33 .env.testing
-rwxr-xr-x.  1 snipeit apache    1819 Nov  8 15:33 .env.testing-ci
-rwxr-xr-x.  1 snipeit apache     536 Nov  8 15:33 .env.tests
-rwxr-xr-x.  1 snipeit apache     491 Nov  8 15:33 .env.unit-tests
drwxr-xr-x.  8 snipeit apache     163 Nov  8 15:33 .git
-rwxr-xr-x.  1 snipeit apache      53 Nov  8 15:33 .gitattributes
drwxr-xr-x.  3 snipeit apache     230 Nov  8 15:33 .github
-rwxr-xr-x.  1 snipeit apache    1173 Nov  8 15:33 .gitignore
-rwxr-xr-x.  1 snipeit apache     251 Nov  8 15:33 .htaccess
-rwxr-xr-x.  1 snipeit apache     956 Nov  8 15:33 index.html
-rwxr-xr-x.  1 snipeit apache     371 Nov  8 15:33 install.sh
-rwxr-xr-x.  1 snipeit apache   34519 Nov  8 15:33 LICENSE
-rwxr-xr-x.  1 snipeit apache       9 Nov  8 15:33 .nvmrc
-rwxr-xr-x.  1 snipeit apache    2102 Nov  8 15:33 package.json
-rwxr-xr-x.  1 snipeit apache  437100 Nov  8 15:33 package-lock.json
-rwxr-xr-x.  1 snipeit apache    2376 Nov  8 15:33 phpmd.xml
-rwxr-xr-x.  1 snipeit apache    1097 Nov  8 15:33 phpunit.xml
drwxr-xr-x.  6 snipeit apache     185 Nov  8 15:33 public
-rwxr-xr-x.  1 snipeit apache   56336 Nov  8 15:33 README.md
drwxr-xr-x.  6 snipeit apache      59 Nov  8 15:33 resources
drwxr-xr-x.  3 snipeit apache      66 Nov  8 15:33 routes
drwxr-xr-x.  2 snipeit apache     189 Nov  8 15:33 sample_csvs
-rwxr-xr-x.  1 snipeit apache     567 Nov  8 15:33 server.php
-rwxr-xr-x.  1 snipeit apache   23851 Nov  8 15:33 snipeit.sh
drwxrwxr-x.  9 snipeit apache     164 Nov 10 12:58 storage
drwxr-xr-x. 10 snipeit apache     283 Nov  8 15:33 tests
-rwxr-xr-x.  1 snipeit apache    2792 Nov  8 15:33 .travis.yml
-rwxr-xr-x.  1 snipeit apache    7241 Nov  8 15:33 upgrade.php
-rwxr-xr-x.  1 snipeit apache    4202 Nov  8 15:33 Vagrantfile
drwxr-xr-x. 74 snipeit apache    4096 Nov  8 18:48 vendor
-rwxr-xr-x.  1 snipeit apache    7326 Nov  8 15:33 webpack.mix.js
[peng.xxx@xxx.xxx.xx@ITAssets html]$ cat /etc/group
root:x:0:
bin:x:1:
daemon:x:2:
sys:x:3:
adm:x:4:
tty:x:5:
disk:x:6:
lp:x:7:
mem:x:8:
kmem:x:9:
wheel:x:10:
cdrom:x:11:
mail:x:12:
man:x:15:
dialout:x:18:
floppy:x:19:
games:x:20:
tape:x:33:
video:x:39:
ftp:x:50:
lock:x:54:
audio:x:63:
users:x:100:
nobody:x:65534:
dbus:x:81:
utmp:x:22:
utempter:x:35:
input:x:999:
kvm:x:36:
render:x:998:
systemd-journal:x:190:
systemd-coredump:x:997:
systemd-resolve:x:193:
tss:x:59:
polkitd:x:996:
unbound:x:995:
ssh_keys:x:994:
sssd:x:993:
sshd:x:74:
printadmin:x:992:
rngd:x:991:
apache:x:48:snipeit,peng.xxx@xxx.xxx.xxx
nginx:x:990:
[peng.xxx@xxxx.xx.xx@ITAssets html]$ cat /etc/passwd
root:x:0:0:root:/root:/bin/bash
bin:x:1:1:bin:/bin:/sbin/nologin
daemon:x:2:2:daemon:/sbin:/sbin/nologin
adm:x:3:4:adm:/var/adm:/sbin/nologin
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin
sync:x:5:0:sync:/sbin:/bin/sync
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown
halt:x:7:0:halt:/sbin:/sbin/halt
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin
operator:x:11:0:operator:/root:/sbin/nologin
games:x:12:100:games:/usr/games:/sbin/nologin
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin
nobody:x:65534:65534:Kernel Overflow User:/:/sbin/nologin
dbus:x:81:81:System message bus:/:/sbin/nologin
systemd-coredump:x:999:997:systemd Core Dumper:/:/sbin/nologin
systemd-resolve:x:193:193:systemd Resolver:/:/sbin/nologin
tss:x:59:59:Account used by the trousers package to sandbox the tcsd daemon:/dev/null:/sbin/nologin
polkitd:x:998:996:User for polkitd:/:/sbin/nologin
unbound:x:997:995:Unbound DNS resolver:/etc/unbound:/sbin/nologin
sssd:x:996:993:User for sssd:/:/sbin/nologin
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin
rngd:x:995:991:Random Number Generator Daemon:/var/lib/rngd:/sbin/nologin
apache:x:48:48:Apache:/usr/share/httpd:/sbin/nologin
nginx:x:994:990:Nginx web server:/var/lib/nginx:/sbin/nologin
snipeit:x:1000:48::/home/snipeit:/bin/bash
[peng.xxx@xxx.xxx.xx@ITAssets html]$
LecrisUT commented 3 years ago

But you have to run the php commands as that user in your case sudo -u snipeit php .... As you can see your user or apache do not have write permission so you have to do it as snipeit

snipe commented 3 years ago

I don't think the permissions are incorrect.

Is the user you're running the cli cache:clear command part of the apache group? If not, you'll need to sudo -u snipeit ... as @LecrisUT mentioned. The user you're logged in as via cli isn't the same as the one your web server runs as, so while your server can modify files in your storage directory (assume the permissions on the subdirectories are correct), your user cannot.

PengKuang commented 3 years ago

This what inside my /etc/php.d/50-mysql.ini file

; Enable MySQL extension module
extension = mysql.so

; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
; http://php.net/mysql.allow_local_infile
;mysql.allow_local_infile = On

; Allow or prevent persistent links.
; http://php.net/mysql.allow-persistent
;mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
; http://php.net/mysql.max-persistent
;mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
; http://php.net/mysql.max-links
;mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
; http://php.net/mysql.default-port
;mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
; http://php.net/mysql.default-socket
;mysql.default_socket = '/var/lib/mysql/mysql.sock'

; Default host for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysql.default-host
;mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysql.default-user
;mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
"50-mysql.ini" 55L, 2041C
PengKuang commented 3 years ago

I don't think the permissions are incorrect.

Is the user you're running the cli cache:clear command part of the apache group? If not, you'll need to sudo -u snipeit ... as @LecrisUT mentioned. The user you're logged in as via cli isn't the same as the one your web server runs as, so while your server can modify files in your storage directory (assume the permissions on the subdirectories are correct), your user cannot.

I think so, I add myself to the apache group, but probably that is not my primary group, since my primary group is it-staff.

What does sudo -u snipeit do? I can change the owner of the snipe-it directory from snipeit to apache

snipe commented 3 years ago

What does sudo -u snipeit do?

It runs the command-line command as a particular user, in this case snipeit.

LecrisUT commented 3 years ago

I am using MariaDB so I don't have the same MySQL config files, but it should be irrelevant for this issue. Can you also double check and share a screenshot of the current /admin/phpinfo. It is better to focus on the actual source of the problem.

PengKuang commented 3 years ago

What does sudo -u snipeit do?

It runs the command-line command as a particular user, in this case snipeit.

ohh, it does the same as su - snipit? So I can run this command to switch myself to snipeit, and re-run the php clean-up commands again. Is that what you recommended to attempt the solution?

PengKuang commented 3 years ago

It remained the same, still no records showing and unauthenticated error:

It seems that the cache directory is not writeable by either user except root. So do I need to change it?

[peng@ITAssets php.d]$ cd /var/www/html/snipe-it
[peng.@ITAssets snipe-it]$ su - snipeit
Password:
Last login: Tue Nov 10 09:00:52 CST 2020 on pts/0
[snipeit@ITAssets ~]$ cd /var/www/html/snipe-it
[snipeit@ITAssets snipe-it]$ composer dump-autoload
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
Generated optimized autoload files containing 7294 classes
[snipeit@ITAssets snipe-it]$ composer clear-compiled

  [Symfony\Component\Console\Exception\CommandNotFoundException]
  Command "clear-compiled" is not defined.

[snipeit@ITAssets snipe-it]$ php artisan config:clear
Configuration cache cleared!
[snipeit@ITAssets snipe-it]$ php artisan view:clear
Compiled views cleared!
[snipeit@ITAssets snipe-it]$ php artisan cache:clear
Failed to clear cache. Make sure you have the appropriate permissions.
[snipeit@ITAssets snipe-it]$ php artisan route:clear
Route cache cleared!
[snipeit@ITAssets snipe-it]$ php artisan migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Nothing to migrate.
[snipeit@ITAssets snipe-it]$ php artisan passport:client --personal

 What should we name the personal access client? [Snipe-IT Personal Access Client]:
 > snipeit

Personal access client created successfully.
Client ID: 4
Client secret: xxxxxxxxxx
[snipeit@ITAssets snipe-it]$ su - peng.xxx@xxxx.xxx.xxxx
Password:
Last login: Tue Nov 10 09:59:56 CST 2020 on pts/0
[peng@ITAssets ~]$ sudo systemctl restart httpd
[sudo] password for peng.xxxxx@xxx.xxx.xx:
[peng@ITAssets ~]$ sudo systemctl status httpd
LecrisUT commented 3 years ago

Run sudo chown -R snipe:apache ./ to make sure all the subdirectories and files have appropriate ownership?

PengKuang commented 3 years ago

Hi, so this is what I got after changing the owner & group of all files within the project root directory to snipeit:apache, then run the batch commands for clean-up as well as the upgrade.php script:


[peng@ITassets snipe-it]$ su - snipeit
Password:
Last login: Tue Nov 10 15:00:44 CST 2020 on pts/0
[snipeit@ITassets ~]$ composer dump-autoload
Composer could not find a composer.json file in /home/snipeit
To initialize a project, please create a composer.json file as described in the https://getcomposer.org/ "Getting Started" section
[snipeit@ITassets ~]$ cd /var/www/html/snipe-it
[snipeit@ITassets snipe-it]$ composer dump-autoload
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
Generated optimized autoload files containing 7294 classes
[snipeit@ITassets snipe-it]$ composer clear-compiled

  [Symfony\Component\Console\Exception\CommandNotFoundException]
  Command "clear-compiled" is not defined.

[snipeit@ITassets snipe-it]$ php artisan config:clear
Configuration cache cleared!
[snipeit@ITassets snipe-it]$ php artisan view:clear
Compiled views cleared!
[snipeit@ITassets snipe-it]$ php artisan cache:clear
Application cache cleared!
[snipeit@ITassets snipe-it]$ php artisan route:clear
Route cache cleared!
[snipeit@ITassets snipe-it]$ php artisan migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Nothing to migrate.
[snipeit@ITassets snipe-it]$ php artisan passport:client --personal

 What should we name the personal access client? [Snipe-IT Personal Access Client]:
 > snipeit02

Personal access client created successfully.
Client ID: 5
Client secret: xxxxxxxxxxxxxxxxxx
[snipeit@ITassets snipe-it]$ su - peng
Password:
Last login: Tue Nov 10 16:07:54 CST 2020 from 10.162.0.33 on pts/1
[peng@ITassets ~]$ sudo systemctl restart httpd
[sudo] password for peng:
[peng@ITassets ~]$ su - snipeit
Password:
Last login: Tue Nov 10 16:10:33 CST 2020 on pts/1
[snipeit@ITassets ~]$ cd /var/www/html/snipe-it
[snipeit@ITassets snipe-it]$ php upgrade.php
Welcome to the Snipe-IT upgrader.

Please note that this script will not download the latest Snipe-IT
files for you unless you have git installed.
It simply runs the standard composer and artisan
commands needed to finalize the upgrade after.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!! If you have any encrypted custom fields, BE SURE TO run the recrypter if upgrading from v3 to v4.
!! See the Snipe-IT documentation for help:
!! https://snipe-it.readme.io/docs/upgrading-to-v4
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
--------------------------------------------------------
STEP 1: Checking PHP requirements:
--------------------------------------------------------

Current PHP version: 7.2.34

PHP version: 7.2.34 is at least 7.1.3 - continuing...

--------------------------------------------------------
STEP 2: Backing up database:
--------------------------------------------------------

-- Starting backup...
Dumping database snipeit_db...
Backup failed because The dump process failed with exitcode 127 : Command not found : sh: /usr/bin/mysqldump: No such file or directory
.
#0 /var/www/html/snipe-it/vendor/spatie/db-dumper/src/DbDumper.php(263): Spatie\DbDumper\Exceptions\DumpFailed::processDidNotEndSuccessfully(Object(Symfony\Component\Process\Process))
#1 /var/www/html/snipe-it/vendor/spatie/db-dumper/src/Databases/MySql.php(203): Spatie\DbDumper\DbDumper->checkIfDumpWasSuccessFul(Object(Symfony\Component\Process\Process), '/var/www/html/s...')
#2 /var/www/html/snipe-it/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(252): Spatie\DbDumper\Databases\MySql->dumpToFile('/var/www/html/s...')
#3 [internal function]: Spatie\Backup\Tasks\Backup\BackupJob->Spatie\Backup\Tasks\Backup\{closure}(Object(Spatie\DbDumper\Databases\MySql), 'mysql')
#4 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Support/Collection.php(638): array_map(Object(Closure), Array, Array)
#5 /var/www/html/snipe-it/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(255): Illuminate\Support\Collection->map(Object(Closure))
#6 /var/www/html/snipe-it/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(169): Spatie\Backup\Tasks\Backup\BackupJob->dumpDatabases()
#7 /var/www/html/snipe-it/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(145): Spatie\Backup\Tasks\Backup\BackupJob->createBackupManifest()
#8 /var/www/html/snipe-it/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(56): Spatie\Backup\Tasks\Backup\BackupJob->run()
#9 [internal function]: Spatie\Backup\Commands\BackupCommand->handle()
#10 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#11 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#12 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#13 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#14 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#15 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)
#16 /var/www/html/snipe-it/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))
#17 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))
#18 /var/www/html/snipe-it/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(16): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))
#19 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(56): Spatie\Backup\Commands\BaseCommand->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))
#20 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(28): Illuminate\Console\Command->runCommand('backup:run', Array, Object(Illuminate\Console\OutputStyle))
#21 /var/www/html/snipe-it/app/Console/Commands/SystemBackup.php(42): Illuminate\Console\Command->call('backup:run')
#22 [internal function]: App\Console\Commands\SystemBackup->handle()
#23 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#24 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#25 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#26 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#27 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#28 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)
#29 /var/www/html/snipe-it/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#30 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#31 /var/www/html/snipe-it/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32 /var/www/html/snipe-it/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\SystemBackup), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#33 /var/www/html/snipe-it/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#34 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#35 /var/www/html/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#36 /var/www/html/snipe-it/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#37 {main}
Backup failed because: The dump process failed with exitcode 127 : Command not found : sh: /usr/bin/mysqldump: No such file or directory
.

--------------------------------------------------------
STEP 3: Putting application into maintenance mode:
--------------------------------------------------------

-- Application is now in maintenance mode.

--------------------------------------------------------
STEP 4: Pulling latest from Git (master branch):
--------------------------------------------------------

Git is installed.
remote: Enumerating objects: 1681, done.
remote: Counting objects: 100% (1681/1681), done.
remote: Compressing objects: 100% (1152/1152), done.
remote: Total 1681 (delta 565), reused 1642 (delta 528), pack-reused 0
Receiving objects: 100% (1681/1681), 835.01 KiB | 2.31 MiB/s, done.
Resolving deltas: 100% (565/565), completed with 142 local objects.
From https://github.com/snipe/snipe-it
   6618e88a9..9e319e91d  master     -> origin/master
   6618e88a9..895a544d4  develop    -> origin/develop
 * [new tag]             v5.0.5     -> v5.0.5
 * [new tag]             v5.0.6     -> v5.0.6
Already on 'master'

*** Please tell me who you are.

Run

  git config --global user.email "you@example.com"
  git config --global user.name "Your Name"

to set your account's default identity.
Omit --global to set the identity only in this repository.

fatal: unable to auto-detect email address (got 'snipeit@ITassets.(none)')
Cannot save the current index state
error: Your local changes to the following files would be overwritten by merge:
        .env.example
        .github/ISSUE_TEMPLATE/Bug_report.md
        app/Console/Commands/LdapSync.php
        app/Providers/AuthServiceProvider.php
        app/Services/LdapAd.php
        config/passport.php
        config/version.php
        crowdin.yml
        public/js/build/app.js
        public/js/dist/all.js
        public/mix-manifest.json
        resources/assets/js/components/passport/PersonalAccessTokens.vue
        resources/lang/af/admin/accessories/general.php
        resources/lang/af/admin/accessories/message.php
        resources/lang/af/admin/asset_maintenances/general.php
        resources/lang/af/admin/categories/general.php
        resources/lang/af/admin/companies/general.php
        resources/lang/af/admin/components/general.php
        resources/lang/af/admin/consumables/general.php
        resources/lang/af/admin/hardware/table.php
        resources/lang/af/admin/licenses/message.php
        resources/lang/af/admin/settings/general.php
        resources/lang/af/admin/users/general.php
        resources/lang/af/admin/users/message.php
        resources/lang/af/auth/general.php
        resources/lang/af/auth/message.php
        resources/lang/af/button.php
        resources/lang/af/general.php
        resources/lang/af/mail.php
        resources/lang/ar/admin/accessories/general.php
        resources/lang/ar/admin/accessories/message.php
        resources/lang/ar/admin/asset_maintenances/general.php
        resources/lang/ar/admin/categories/general.php
        resources/lang/ar/admin/companies/general.php
        resources/lang/ar/admin/components/general.php
        resources/lang/ar/admin/consumables/general.php
        resources/lang/ar/admin/hardware/table.php
        resources/lang/ar/admin/licenses/message.php
        resources/lang/ar/admin/settings/general.php
        resources/lang/ar/admin/users/general.php
        resources/lang/ar/admin/users/message.php
        resources/lang/ar/auth/general.php
        resources/lang/ar/auth/message.php
        resources/lang/ar/button.php
        resources/lang/ar/general.php
        resources/lang/ar/mail.php

…..

Aborting
-- -- -- M      .all-contributorsrc
M       .dockerignore
M       .env.example
M       .env.testing
M       .env.testing-ci
M       .env.tests
M       .env.unit-tests
M       .github/CODEOWNERS
M       .github/FUNDING.yml
M       .github/ISSUE_TEMPLATE.md
M       .github/ISSUE_TEMPLATE/Bug_report.md
M       .github/ISSUE_TEMPLATE/Feature_request.md
M       .github/autolabeler.yml
M       .github/config.yml
M       .github/pull_request_template.md
M       .github/stale.yml
M       .github/travis-memory.ini
M       .github/weekly-digest.yml
M       .htaccess
M       .nvmrc
M       .travis.yml
M       CODE_OF_CONDUCT.md
M       CONTRIBUTING.md
M       Dockerfile
M       Dockerfile.alpine
M       README.md
M       Vagrantfile
M       _config.yml
M       ansible/freebsd/vagrant_playbook.yml
M       app/Console/Commands/CheckinLicensesFromAllUsers.php
M       app/Console/Commands/CheckoutLicenseToAllUsers.php
M       app/Console/Commands/CreateAdmin.php
M       app/Console/Commands/DisableLDAP.php
M       app/Console/Commands/FixDoubleEscape.php
M       app/Console/Commands/ImportLocations.php
M       app/Console/Commands/LdapSync.php
M       app/Console/Commands/MergeUsersByUsername.php
M       app/Console/Commands/MoveUploadsToNewDisk.php
M       app/Console/Commands/ObjectImportCommand.php
M       app/Console/Commands/PaveIt.php

….

Your branch is behind 'origin/master' by 38 commits, and can be fast-forwarded.
  (use "git pull" to update your local branch)
-- Updating 6618e88a9..9e319e91d
--------------------------------------------------------
Step 5: Cleaning up old cached files:
--------------------------------------------------------

-- No bootstrap/cache/compiled.php, so nothing to delete.
-- Deleting bootstrap/cache/services.php. It it no longer used.
-- No bootstrap/cache/config.php, so nothing to delete.
-- Configuration cache cleared!
-- Failed to clear cache. Make sure you have the appropriate permissions.
-- Route cache cleared!
-- Compiled views cleared!

--------------------------------------------------------
Step 6: Updating composer dependencies:
(This may take a moment.)
--------------------------------------------------------

-- Local composer.phar detected, so we'll use that.

-- Updating local composer.phar

You are already using composer version 2.0.6 (stable channel).

> Illuminate\Foundation\ComposerScripts::postAutoloadDump
Installing dependencies from lock file
Verifying lock file contents can be installed on current platform.
Package operations: 0 installs, 0 updates, 35 removals
  - Removing theseer/tokenizer (1.2.0)
  - Removing symfony/yaml (v4.4.16)
  - Removing symfony/dom-crawler (v4.4.16)
  - Removing symfony/browser-kit (v4.4.16)
  - Removing softcreatr/jsonpath (0.7.2)
  - Removing sebastian/version (2.0.1)
  - Removing sebastian/type (1.1.3)
  - Removing sebastian/resource-operations (2.0.1)
  - Removing sebastian/object-reflector (1.1.1)
  - Removing sebastian/object-enumerator (3.0.3)
  - Removing sebastian/global-state (3.0.0)
  - Removing sebastian/environment (4.2.3)
  - Removing sebastian/code-unit-reverse-lookup (1.0.1)
  - Removing phpunit/phpunit (8.5.8)
  - Removing phpunit/php-token-stream (3.1.1)
  - Removing phpunit/php-timer (2.1.2)
  - Removing phpunit/php-text-template (1.2.1)
  - Removing phpunit/php-file-iterator (2.0.2)
  - Removing phpunit/php-code-coverage (7.0.10)
  - Removing php-webdriver/webdriver (1.8.3)
  - Removing phar-io/version (2.0.1)
  - Removing phar-io/manifest (1.0.3)
  - Removing myclabs/deep-copy (1.10.1)
  - Removing justinrainbow/json-schema (5.2.10)
  - Removing fzaninotto/faker (v1.9.1)
  - Removing codeception/stub (3.7.0)
  - Removing codeception/phpunit-wrapper (8.1.3)
  - Removing codeception/module-webdriver (1.1.3)
  - Removing codeception/module-rest (1.2.7)
  - Removing codeception/module-laravel5 (1.1.1)
  - Removing codeception/module-asserts (1.3.1)
  - Removing codeception/lib-innerbrowser (1.3.4)
  - Removing codeception/lib-asserts (1.13.2)
  - Removing codeception/codeception (4.1.11)
  - Removing behat/gherkin (v4.6.2)
    0 [>---------------------------]    0 [>---------------------------]Package doctrine/reflection is abandoned, you should avoid using it. Use roave/better-reflection instead.
Package fzaninotto/faker is abandoned, you should avoid using it. No replacement was suggested.
Package phpunit/php-token-stream is abandoned, you should avoid using it. No replacement was suggested.
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
50 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
Generating optimized autoload files
Generated optimized autoload files containing 7294 classes

--------------------------------------------------------
Step 7: Migrating database:
--------------------------------------------------------

-- Nothing to migrate.

--------------------------------------------------------
Step 8: Checking for OAuth keys:
--------------------------------------------------------

- OAuth keys detected. Skipping passport install.

--------------------------------------------------------
Step 9: Caching routes and config:
--------------------------------------------------------

-- Configuration cache cleared!
Configuration cached successfully!
-- Route cache cleared!
Routes cached successfully!

--------------------------------------------------------
Step 10: Taking application out of maintenance mode:
--------------------------------------------------------

-- Application is now live.

--------------------------------------------------------
FINISHED! Clear your browser cookies and re-login to use :
your upgraded Snipe-IT.

Still no luck but saw many errors when running the upgrade.php file. Should I fix them? Noticeably, I don't have mysql database installed in this web server.

snipe commented 3 years ago

And if you run a git stash before running php upgrade.php, what do you see?

snipe commented 3 years ago

@uberbrady - can you take a peek at this - I'm in the middle of something right now :(

snipe commented 3 years ago

There are a few confusing things here....

fatal: unable to auto-detect email address (got 'snipeit@ITassets.(none)') Cannot save the current index state

Try setting:

git config --global user.email "snipeit@ITassets.(none)"
git config --global user.name "Your Name"

using real values.

error: Your local changes to the following files would be overwritten by merge:

This one I don't understand. Unless you have made changes to these files, you shouldn't be seeing that. Though that might be caused by the previous issue with the saving current index state.

snipe commented 3 years ago

Also please take a look at this comment, which may help: https://github.com/snipe/snipe-it/issues/8440#issuecomment-693354374