[librenms@librenms ~]$ ./validate.php
In AppServiceProvider.php line 43:
Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()
PHP Fatal error: Uncaught ErrorException: Undefined index: openssl_ver in /opt/librenms/validate.php:167
Stack trace:
#0 /opt/librenms/validate.php(167): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8, 'Undefined index...', '/opt/librenms/v...', 167, Array)
#1 /opt/librenms/validate.php(84): print_header(Array)
#2 [internal function]: {closure}()
#3 {main}
thrown in /opt/librenms/validate.php on line 167
Output of ./daily.sh
[librenms@librenms ~]$ ./daily.sh
In AppServiceProvider.php line 43:
Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()
Updating SQL-Schema OK
Cleaning up DB OK
In AppServiceProvider.php line 43:
Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()
Not sure what has happened. Was working fine last night then woke up to the service failed. Could this have been an issue with an update? Any hints on how to fix this. Unable to login to web interface or do anything. It tells me to check librenms.log which has the following.
Previous HEAD position was 0ac05fd... Bump version to 1.69
HEAD is now at 84c08f4... Bump version to 1.70.0
Returned: 0
Unsupported PHP version, switched to php72 branch.
error: pathspec 'php72' did not match any file(s) known to git.
Returned: 1
Updating Composer packages
> LibreNMS\ComposerHelper::preInstall
Installing dependencies from lock file
Verifying lock file contents can be installed on current platform.
Your lock file does not contain a compatible set of packages. Please run composer update.
Problem 1
- Root composer.json requires php ^7.3 but your php version (7.2.27) does not satisfy that requirement.
Problem 2
- doctrine/dbal is locked to version 2.12.0 and an update of this package was not requested.
- doctrine/dbal 2.12.0 requires php ^7.3 || ^8 -> your php version (7.2.27) does not satisfy that requirement.
Problem 3
- laravel/framework is locked to version v8.11.2 and an update of this package was not requested.
- laravel/framework v8.11.2 requires php ^7.3 -> your php version (7.2.27) does not satisfy that requirement.
Problem 4
- laravel/ui is locked to version v3.0.0 and an update of this package was not requested.
- laravel/ui v3.0.0 requires php ^7.3 -> your php version (7.2.27) does not satisfy that requirement.
Problem 5
- laravel/framework v8.11.2 requires php ^7.3 -> your php version (7.2.27) does not satisfy that requirement.
- wpb/string-blade-compiler 6.0.2 requires laravel/framework ^6.0|^7.0|^8.0 -> satisfiable by laravel/framework[v8.11.2].
- wpb/string-blade-compiler is locked to version 6.0.2 and an update of this package was not requested.
Returned: 2
Unsupported PHP version, switched to php72 branch.
error: pathspec 'php72' did not match any file(s) known to git.
Returned: 1
Updated from 1.69 to 1.70.0
Returned: 0
Updating SQL-Schema
In AppServiceProvider.php line 43:
Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()
Returned: 0
Updating submodules
Returned: 0
Cleaning up DB
In AppServiceProvider.php line 43:
Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()
Gonna take a snapshot then update to 7.4 php and then run daily again and see what happens.
[OK] Composer Version: 2.0.7
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Time between this server and the mysql database is off
Mysql time 2020-12-02 10:49:28
PHP time 2020-12-02 18:49:28
[FAIL] Database: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE notifications CHANGE datetimedatetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_atcreated_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;
[FAIL] You have no timezone set for php.
[FIX]: http://php.net/manual/en/datetime.configuration.php#ini.date.timezone
[WARN] Global lnms shortcut not installed. lnms command must be run with full path
[FIX]:
sudo ln -s /opt/librenms/lnms /usr/local/bin/lnms
[WARN] Bash completion not installed. lnms command tab completion unavailable.
[FIX]:
sudo cp /opt/librenms/misc/lnms-completion.bash /etc/bash_completion.d/
[WARN] Log rotation not enabled, could cause disk space issues
[FIX]:
sudo cp /opt/librenms/misc/librenms.logrotate /etc/logrotate.d/librenms
[OK] Composer Version: 2.0.7
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE notifications CHANGE datetimedatetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_atcreated_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;
[librenms@librenms ~]$
[librenms@librenms ~]$
[librenms@librenms ~]$ ./daily.sh
Fetching new release information OK
Updating to latest release OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
Now I’m just stuck with that 502 bad gateway error from nginx.
That is definitely the issue. Just unsure of how to fix it.
2020/12/02 12:14:47 [crit] 18618#0: *1 connect() to unix:/var/run/php-fpm/php7.4-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: 1, server: librenms.example.com, request: “GET / HTTP/1.1”, upstream: "fastcgi://unix:/var/run/php-fpm/php7.4-fpm.soc$
I modified librenms.conf to php7.4-fpm.sock and restarted nginx but no dice.
I had restart php-fpm.service and execute the ./validate.php is failed (Do not run validate.php as root), and see the /var/log/nginx/error.log has the “unix:/run/php-fpm-librenms.sock failed error”, have anyone to help me to resolve it? thx.