Hi All,
My team noticed that our transport alerts were not coming through properly since the update. I ran the ./validate.php and saw a bunch of errors. I was able to fix most of them with the suggested fix in the validate output but one still remains.
[FAIL] Python3 module issue found:
pip3 install -r /opt/librenms/requirements.txt keeps failing. I even installed python36-PyMySQL and still no luck. The error I get is:
Command “/usr/bin/python3 -u -c “import setuptools, tokenize;file=’/tmp/pip-build-x24yxjhu/psutil/setup.py’;f=getattr(tokenize, ‘open’, open)(file);code=f.read().replace(’\r\n’, ‘\n’);f.close();exec(compile(code, file, ‘exec’))” install --record /tmp/pip-b_bxhees-record/install-record.txt --single-version-externally-managed --compile --user --prefix=” failed with error code 1 in /tmp/pip-build-x24yxjhu/psutil/
Has anyone come across this?
====================================
| Component | Version |
|---|---|
| LibreNMS | 22.2.1-5-g09929bd |
| DB Schema | 2022_02_03_164059_increase_auth_id_length (235) |
| PHP | 7.4.16 |
| Python | 3.6.8 |
| MySQL | 10.5.9-MariaDB |
| RRDTool | 1.4.8 |
| SNMP | 5.7.2 |
====================================
[OK] Composer Version: 2.2.6
[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
[FIX]:
Run the following SQL statements to fix it
SQL Statements:
SET TIME_ZONE=’+00:00’;
ALTER TABLE notifications CHANGE datetime datetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;
^[[FAIL] Python3 module issue found: 'Required packages: [‘PyMySQL!=1.0.0’, ‘python-dotenv’, ‘redis>=3.0’, ‘setuptools’, ‘psutil>=5.6.0’, ‘command_runner>=1.3.0’]
Package not found: The ‘command_runner>=1.3.0’ distribution was not found and is required by the application
’
[FIX]:
pip3 install -r /opt/librenms/requirements.txt
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
rrd/.gitignore
Updating to latest codebase OK
Updating Composer packages OK
Updated from 6ac1382 to 0c08670 OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
Caching Mac OUI data OK