Save initial config fails with message, "Sorry! Unknow error!" (that's the exact message/spelling)

[nicholfd]

YouPHPTube version - latest from GitHub, 4.8
Kernel 4.9.76-gentoo-r1 #2 SMP
PHP 5.6.33-pl0-gentoo
apache-2.4.27-r1:2::gentoo
mariadb-10.1.29:0/18::gentoo
Site home directory: /var/www/localhost/YouPHPTube
Verified database server is reachable & database user has full permissions to the database server
All files & directories are owned by apache:apache
Site is using SSL with a valid certificate
All items are green on the left side
Workstation I'm browsing from is running macOS 10.13.2
Tried Chrome Version 62.0.3202.94
Tried Safari 11.0.3
The YouPHPTube system is running another production web site with the same LAMP stack.

The configuration/install screen loads ok (https://xxx.xxx.xxx.xxx/youphptube/install/index.php). I complete the fields. They look good. I click "Submit". A progress bar appears at the top for less than one second. A pop-up dialog says "Sorry! Unknow error!"

Are there any logs or information written anywhere? I looked around and could find no new/changed files in /var.

Thanks in advance!

[DanielnetoDotCom]

If it is during the installation try to look apache error log

[nicholfd]

No errors in any of the apache logs (error.log, ssl_request_log, ssl_access_log or access_log).
No errors in the MariaDB logs.

[DanielnetoDotCom]

there is a database created?
I cant help much with out a log info

[nicholfd]

There is NO activity in the logs, other than the expected SSL log entries:
ssl_request_log
[15/Mar/2018:21:34:44 -0400] 10.130.0.4 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /youphptube HTTP/1.1" 301
[15/Mar/2018:21:34:44 -0400] 10.130.0.4 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /youphptube/ HTTP/1.1" -
[15/Mar/2018:21:34:44 -0400] 10.130.0.4 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /youphptube/install/index.php HTTP/1.1" 12341
[15/Mar/2018:21:35:08 -0400] 10.130.0.4 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "POST /youphptube/install/checkConfiguration.php HTTP/1.1" -

ssl_access_log
10.130.0.4 - - [15/Mar/2018:21:34:44 -0400] "GET /youphptube HTTP/1.1" 301 301
10.130.0.4 - - [15/Mar/2018:21:34:44 -0400] "GET /youphptube/ HTTP/1.1" 302 -
10.130.0.4 - - [15/Mar/2018:21:34:44 -0400] "GET /youphptube/install/index.php HTTP/1.1" 200 12341
10.130.0.4 - - [15/Mar/2018:21:35:08 -0400] "POST /youphptube/install/checkConfiguration.php HTTP/1.1" 500 -

No database is created.

[DanielnetoDotCom]

Is possible for you do debug the code to know in what the ajax request returning?

check this: https://github.com/DanielnetoDotCom/YouPHPTube/wiki/Check-Ajax-answer

[nicholfd]

In Chrome & Firefox (just tried Firefox with this), the only entry under XHR is the POST, status code:
500 Internal Server Error

Request headers
Accept: /
Accept-Encoding: gzip, default, br
Accept-Language: en-US,en;q=0.5
Connection: keep-alive
Content-Length: 350
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
Host: www.xxx-xxxxxx.com
Referer: https://www.xxx-xxxxxx.com/youphptube/install/index.php
User-Agent: Mozilla/5.0 (Macintosh; Intel …) Gecko/20100101 Firefox/58.0
X-Requested-With: XMLHttpRequest

Response headers:
Access-Control-Allow-Origin: *
Connection: close
Content-Length: 0
Content-Type: application/json
Date: .... (not relevant)
Server: Apache
X-Powered-By: PHP/5.6.33.-l0-gentoo

[nicholfd]

Apache was compiled with the following options:

[ Legend : U - final flag setting for installation]
[        : I - package is installed with flag     ]
[ Colors : set, unset                             ]
 * Found these USE flags for www-servers/apache-2.4.27-r1:
 U I
 - - apache2_modules_access_compat       : Group authorizations based on host (name or IP address). Available as a compatibility module with previous versions.
 + + apache2_modules_actions             : Provides for executing CGI scripts based on media type or request method
 + + apache2_modules_alias               : Provides for mapping different parts of the host filesystem in the document tree and for URL redirection
 - - apache2_modules_asis                : Sends files that contain their own HTTP headers
 + + apache2_modules_auth_basic          : Basic authentication
 - - apache2_modules_auth_digest         : User authentication using MD5 Digest Authentication
 + + apache2_modules_authn_alias         : Provides the ability to create extended authentication providers based on actual providers
 + + apache2_modules_authn_anon          : Allows "anonymous" user access to authenticated areas
 + + apache2_modules_authn_core          : Provides core authentication capabilities common to all authentication providers (functionality provided by authn_alias in previous versions).
 - - apache2_modules_authn_dbd           : User authentication using an SQL database
 + + apache2_modules_authn_dbm           : User authentication using DBM files
 + + apache2_modules_authn_file          : User authentication using text files
 + + apache2_modules_authz_core          : Provides core authorization capabilities to various authorization/authorization modules, such as authn_file and authz_user.
 - - apache2_modules_authz_dbd           : Provides authorization capabilities via SQL database so that authenticated users can be allowed or denied access to portions of the web site by group membership.
 + + apache2_modules_authz_dbm           : Group authorization using DBM files
 + + apache2_modules_authz_groupfile     : Group authorization using plaintext files
 + + apache2_modules_authz_host          : Group authorizations based on host (name or IP address)
 + + apache2_modules_authz_owner         : Authorization based on file ownership
 + + apache2_modules_authz_user          : User Authorization
 + + apache2_modules_autoindex           : Generates directory indexes, automatically, similar to the Unix ls command
 + + apache2_modules_cache               : Content cache keyed to URIs
 - - apache2_modules_cache_disk          : Disk based storage module for the HTTP caching filter (similar to mem_cache in previous versions).
 - - apache2_modules_cache_socache       : Shared object cache (socache) based storage module for the HTTP caching filter.
 - - apache2_modules_cern_meta           : CERN httpd metafile semantics
 + + apache2_modules_cgi                 : Enable CGI module (used by non-multithreaded MPMs, for eg. prefork)
 + + apache2_modules_cgid                : Enable CGI module (used by multithreaded MPMs, for eg. worker)
 - - apache2_modules_charset_lite        : Specify character set translation or recoding
 + + apache2_modules_dav                 : Distributed Authoring and Versioning (WebDAV) functionality
 + + apache2_modules_dav_fs              : filesystem provider for mod_dav
 + + apache2_modules_dav_lock            : generic locking module for mod_dav
 - - apache2_modules_dbd                 : Manages SQL database connections
 + + apache2_modules_deflate             : Compress content before it is delivered to the client
 + + apache2_modules_dir                 : Provides for "trailing slash" redirects and serving directory index files
 - - apache2_modules_dumpio              : Dumps all I/O to error log as desired
 + + apache2_modules_env                 : Modifies the environment which is passed to CGI scripts and SSI pages
 + + apache2_modules_expires             : Generation of Expires and Cache-Control HTTP headers according to user-specified criteria
 + + apache2_modules_ext_filter          : Pass the response body through an external program before delivery to the client
 + + apache2_modules_file_cache          : Caches a static list of files in memory
 + + apache2_modules_filter              : Context-sensitive smart filter configuration module
 + + apache2_modules_headers             : Customization of HTTP request and response headers
 - - apache2_modules_http2               : Enable http2/alpn module
 - - apache2_modules_ident               : RFC 1413 ident lookups
 - - apache2_modules_imagemap            : Server-side imagemap processing
 + + apache2_modules_include             : Server-parsed html documents (Server Side Includes)
 + + apache2_modules_info                : Provides a comprehensive overview of the server configuration
 - - apache2_modules_lbmethod_bybusyness : Pending request counting load balancer scheduler algorithm for proxy_balancer.
 - - apache2_modules_lbmethod_byrequests : Request counting load balancer scheduler algorithm for proxy_balancer.
 - - apache2_modules_lbmethod_bytraffic  : Weighted traffic counting load balancer scheduler algorithm for proxy_balancer.
 - - apache2_modules_lbmethod_heartbeat  : Heartbeat traffic counting load balancer scheduler algorithm for proxy_balancer.
 + + apache2_modules_log_config          : Logging of the requests made to the server
 - - apache2_modules_log_forensic        : Forensic Logging of the requests made to the server
 + + apache2_modules_logio               : Logging of input and output bytes per request
 - - apache2_modules_macro               : Macros for the Apache config file.
 + + apache2_modules_mime                : Associates the requested filename's extensions with the file's behavior (handlers and filters) and content (mime-type, language, character set and encoding)
 + + apache2_modules_mime_magic          : Determines the MIME type of a file by looking at a few bytes of its contents
 + + apache2_modules_negotiation         : Provides for content negotiation
 - - apache2_modules_proxy               : HTTP/1.1 proxy/gateway server
 - - apache2_modules_proxy_ajp           : AJP support module for mod_proxy
 - - apache2_modules_proxy_balancer      : mod_proxy extension for load balancing
 - - apache2_modules_proxy_connect       : mod_proxy extension for CONNECT request handling
 - - apache2_modules_proxy_fcgi          : FCGI support module for mod_proxy.
 - - apache2_modules_proxy_ftp           : FTP support module for mod_proxy
 - - apache2_modules_proxy_html          : Module to rewrite links in html pages behind a reverse proxy
 - - apache2_modules_proxy_http          : HTTP support module for mod_proxy
 - - apache2_modules_proxy_scgi          : SCGI gateway module for mod_proxy
 - - apache2_modules_proxy_wstunnel      : Provides support for the tunnelling of web socket connections to a backend websockets server.
 - - apache2_modules_ratelimit           : Ratelimit module for transfer rate management
 - - apache2_modules_remoteip            : Remotip module for logging
 - - apache2_modules_reqtimeout          : Set timeout and minimum data rate for receiving requests
 + + apache2_modules_rewrite             : Provides a rule-based rewriting engine to rewrite requested URLs on the fly
 + + apache2_modules_setenvif            : Allows the setting of environment variables based on characteristics of the request
 - - apache2_modules_slotmem_shm         : Slot-based shared memory provider.
 + + apache2_modules_socache_shmcb       : A shared object cache provider using a high-performance cyclic buffer inside a shared memory segment.
 + + apache2_modules_speling             : Attempts to correct mistaken URLs that users might have entered by ignoring capitalization and by allowing up to one misspelling
 + + apache2_modules_status              : Provides information on server activity and performance
 - - apache2_modules_substitute          : Perform search and replace operations on response bodies
 + + apache2_modules_unique_id           : Provides an environment variable with a unique identifier for each request
 + + apache2_modules_unixd               : Basic (required) security for Unix-family platforms.
 + + apache2_modules_userdir             : User-specific directories
 + + apache2_modules_usertrack           : Clickstream logging of user activity on a site
 - - apache2_modules_version             : Version dependent configuration
 + + apache2_modules_vhost_alias         : Provides for dynamically configured mass virtual hosting
 - - apache2_modules_xml2enc             : Enable xml2 encoding module
 - - apache2_mpms_event                  : An experimental variant of the standard worker MPM
 - - apache2_mpms_prefork                : Implements a non-threaded, pre-forking web server
 - - apache2_mpms_worker                 : Multi-Processing Module implementing a hybrid multi-threaded multi-process web server
 - - debug                               : Enable extra debug codepaths, like asserts and extra output. If you want to get meaningful backtraces see
                                           https://wiki.gentoo.org/wiki/Project:Quality_Assurance/Backtraces
 - - doc                                 : Add extra documentation (API, Javadoc, etc). It is recommended to enable per package instead of globally
 + + ldap                                : Add LDAP support (Lightweight Directory Access Protocol)
 - - libressl                            : Use dev-libs/libressl instead of dev-libs/openssl as SSL/TLS provider (ineffective with USE=-ssl), packages should not depend on this USE flag
 + + ssl                                 : Add support for SSL/TLS connections (Secure Socket Layer / Transport Layer Security)
 - - static                              : Link in apache2 modules statically rather then plugins
 - - suexec                              : Install suexec with apache
 - - threads                             : Add threads support for various packages. Usually pthreads

[nicholfd]

PHP was compiled with the following options:

[ Legend : U - final flag setting for installation]
[        : I - package is installed with flag     ]
[ Colors : set, unset                             ]
 * Found these USE flags for dev-lang/php-5.6.33:
 U I
 + + acl                 : Add support for Access Control Lists
 + + apache2             : Add Apache2 support
 + + bcmath              : Add support for libbcmath
 + + berkdb              : Add support for sys-libs/db (Berkeley DB for MySQL)
 + + bzip2               : Use the bzlib compression library
 - - calendar            : Add support for calendars (not using mcal!)
 - - cdb                 : Add support for the CDB database engine from the author of qmail
 - - cgi                 : Add CGI script support
 - - cjk                 : Add support for Multi-byte character languages (Chinese, Japanese, Korean)
 + + cli                 : Enable CLI SAPI
 - - coverage            : Include gcov symbols for test coverage and lcov reports. Only useful for extension developers, and requires GCC. 
 + + crypt               : Add support for encryption -- using mcrypt or gpg where applicable
 + + ctype               : Enable ctype functions
 + + curl                : Add support for client-side URL transfer library
 - - debug               : Enable extra debug codepaths, like asserts and extra output. If you want to get meaningful backtraces see https://wiki.gentoo.org/wiki/Project:Quality_Assurance/Backtraces
 - - embed               : Enable embed SAPI 
 - - enchant             : Add supports Enchant spelling library. 
 - - exif                : Add support for reading EXIF headers from JPEG and TIFF images
 + + fileinfo            : Add fileinfo extension support
 + + filter              : Add filter extension support
 - - flatfile            : Add dbm support for flat files
 - - fpm                 : Enable the FastCGI Process Manager SAPI
 - - ftp                 : Add FTP (File Transfer Protocol) support
 - - gd                  : Adds support for gd (bundled with PHP)
 + + gdbm                : Add support for sys-libs/gdbm (GNU database libraries)
 - - gmp                 : Add support for dev-libs/gmp (GNU MP library)
 + + hash                : Enable the hash extension
 + + iconv               : Enable support for the iconv character set conversion library
 + + imap                : Add support for IMAP (Internet Mail Application Protocol)
 - - inifile             : Add dbm support for .ini files
 - - intl                : Enables the intl extension for extended internalization support 
 - - iodbc               : Add support for iODBC library
 + + ipv6                : Add support for IP version 6
 + + json                : Enable JSON support
 - - kerberos            : Add kerberos support
 + + ldap                : Add LDAP support (Lightweight Directory Access Protocol)
 - - ldap-sasl           : Add SASL support for the PHP LDAP extension
 - - libedit             : Use the libedit library (replacement for readline)
 - - libmysqlclient      : Use libmyslclient driver for mysql, mysqli, PDO_Mysql (not recommended) 
 - - libressl            : Use dev-libs/libressl instead of dev-libs/openssl as SSL/TLS provider (ineffective with USE=-ssl), packages should not depend on this USE flag
 - - mhash               : Add support for the mhash library
 - - mssql               : Add support for Microsoft SQL Server database
 - - mysql               : Add mySQL Database support
 - - mysqli              : Add support for the improved mySQL libraries
 + + nls                 : Add Native Language Support (using gettext - GNU locale utilities)
 - - oci8-instant-client : Use dev-db/oracle-instantclient-basic as Oracle provider instead of requiring a full Oracle server install
 - - odbc                : Add ODBC Support (Open DataBase Connectivity)
 + + opcache             : Enables built-in opcode cache, replacing pecl-apc et al. 
 - - pcntl               : Add support for process creation functions
 - - pdo                 : Enable the bundled PDO extensions
 + + phar                : Enables the phar extension to provide phar archive support 
 + + posix               : Add support for POSIX-compatible functions
 - - postgres            : Add support for the postgresql database
 - - qdbm                : Add support for the qdbm (Quick Database Manager) library
 + + readline            : Enable support for libreadline, a GNU line-editing library that almost everyone wants
 - - recode              : Enable support for the GNU recode library
 + + session             : Add persistent session support
 - - sharedmem           : Add support for shared memory use
 + + simplexml           : Support for SimpleXML
 - - snmp                : Add support for the Simple Network Management Protocol if available
 + + soap                : Add support for SOAP (Simple Object Access Protocol)
 - - sockets             : Add support for tcp/ip sockets
 - - spell               : Add dictionary support
 + + sqlite              : Add support for sqlite - embedded sql database
 + + ssl                 : Add support for SSL/TLS connections (Secure Socket Layer / Transport Layer Security)
 - - sybase-ct           : Add support for Sybase-CT
 - - systemd             : Enable use of systemd-specific libraries and features like socket activation or session tracking
 - - sysvipc             : Support for System V-compatible inter-process communication
 - - threads             : Add threads support for various packages. Usually pthreads
 - - tidy                : Add support for HTML Tidy
 + + tokenizer           : Add support for the PHP file parser
 - - truetype            : Add support for FreeType and/or FreeType2 fonts
 + + unicode             : Add support for Unicode
 - - vpx                 : Enable webp support for GD in php-5.x
 - - wddx                : Add support for Web Distributed Data eXchange
 + + xml                 : Add support for XML files
 - - xmlreader           : Enable XMLReader support
 + + xmlrpc              : Support for xml-rpc library
 - - xmlwriter           : Enable XMLWriter support
 - - xpm                 : Add support for XPM graphics format
 - - xslt                : Enable the XSL extension
 - - zip                 : Enable ZIP file support
 + + zlib                : Add support for zlib (de)compression```

[DanielnetoDotCom]

If you got error 500 must be an log information otherwise is impossible to fix

[nicholfd]

Full Appache access log, with a fresh attempt/session:

##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/js/seetalert/sweetalert.min.js HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/bootstrap/css/bootstrap.min.css HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/bootstrap/bootstrapSelectPicker/css/bootstrap-select.min.css HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/js/seetalert/sweetalert.css HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/js/script.js HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/bootstrap/bootstrapSelectPicker/js/bootstrap-select.min.js HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/js/jquery-3.2.0.min.js HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/bootstrap/fonts/glyphicons-halflings-regular.woff2 HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/view/img/logo.png HTTP/1.1" 304 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/ HTTP/1.1" 302 -
##.##.###.# - - [18/Mar/2018:11:05:17 -0400] "GET /youphptube/install/index.php HTTP/1.1" 200 12348
##.##.###.# - - [18/Mar/2018:11:06:10 -0400] "POST /youphptube/install/checkConfiguration.php HTTP/1.1" 500 -

[DanielnetoDotCom]

This looks like access log.
also if it is error log, it does not help much

[nicholfd]

I said that it is the access log. The return code 500 is the last line in the log posted above.

There are no entries in the error log for that time frame.

Is it possible something in my PHP or Apache version are missing some feature/option (see above compiled in options)?

Thanks.

[DanielnetoDotCom]

you suppose to have an error log. check your apache configuration to enable it

[nicholfd]

I do have an error log. There are no errors in the time of my testing. Here are the error log entries around the time of the test (18/Mar/2018:11:06:10). I restarted Apache at 11:16.

ls -l error_log
-rw-r--r-- 1 root root 1328 Mar 18 11:16 error_log

cat error_log
[Sun Mar 18 03:10:01.561723 2018] [ssl:warn] [pid 1249] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 18 03:10:02.019209 2018] [mpm_prefork:notice] [pid 1249] AH00163: Apache/2.4.27 (Unix) OpenSSL/1.0.2n PHP/5.6.33-pl0-gentoo configured -- resuming normal operations
[Sun Mar 18 03:10:02.019254 2018] [core:notice] [pid 1249] AH00094: Command line: '/usr/sbin/apache2 -D INFO -D SSL -D SSL_DEFAULT_VHOST -D LANGUAGE -D PHP -d /usr/lib64/apache2 -f /etc/apache2/httpd.conf'
[Sun Mar 18 11:16:20.135175 2018] [mpm_prefork:notice] [pid 1249] AH00169: caught SIGTERM, shutting down
[Sun Mar 18 11:16:21.345966 2018] [ssl:warn] [pid 22837] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 18 11:16:22.065654 2018] [ssl:warn] [pid 22839] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 18 11:16:23.026921 2018] [mpm_prefork:notice] [pid 22839] AH00163: Apache/2.4.27 (Unix) OpenSSL/1.0.2n PHP/5.6.33-pl0-gentoo configured -- resuming normal operations
[Sun Mar 18 11:16:23.027011 2018] [core:notice] [pid 22839] AH00094: Command line: '/usr/sbin/apache2 -D INFO -D SSL -D SSL_DEFAULT_VHOST -D LANGUAGE -D PHP -d /usr/lib64/apache2 -f /etc/apache2/httpd.conf'

[DanielnetoDotCom]

@nicholfd this error does not help much. sorry

[nasmacs]

Unable to complete installation too.
It seems the button only show this message without any action.

tested with the database already created or not.. same result.

[DanielnetoDotCom]

@nasmacs check your apache error log

[hersche]

@nasmacs please update and try again

[nicholfd]

The update did not help me.

However - I think I have the solution!

On some PHP/Apache/Linux implementations, using localhost to connect the MySQL is not the same as using 127.0.0.1 - 127.0.0.1 works, when localhost may not. This is true, even if "localhost" works from the command line.

I installed on a clean, latest, Ubuntu Server LTS. All worked. I backed up the website directory & SQL database. I copied it to my Gentoo installation described above. It still failed. However, I had logs in the videos directory. Troubleshooting told me it had trouble connecting to the SQL server. While trying to install PHPMyAdmin, I had trouble connecting to the SQL server. Researching found a suggestion to change "localhost" to "127.0.0.1". I did, and this resolved the issue!

Thanks,
Frank

[hersche]

very cool! :D

that is true, it confused me also some times.. (127.0.0.1 instead of localhost with other software)

ok then, update was anyway unbreak some stuff, so was not bad the issue brought me to have a look there :)

if you want, you can close the issue then.

[cbranje]

I'm experiencing this issue as well . . .

[cbranje]

The fix was the make sure the default php modules were installed when I switch the 5.6

[DanielnetoDotCom]

@cbranje is it fixed for you?

[cbranje]

Yes fixed for me! The fix was to make sure the default PHP modules were installed when I switched to version 5.6

[DanielnetoDotCom]

Great :) thanks