Composer problem

[mourillostak]

hello,
I have a problem with my Librenms running on Ubuntu 15.10.

When a run validate.php I have this :
[FAIL] No composer available, please install composer
[FIX] https://getcomposer.org/

I have installed composer but with no luck !

Thanks for your help.
regards.

[tslytsly]

I had the same problem.

I followed this advice:

Http://<librenms>/validate & ./validate.php inconsistent

Hrmm… Then Idk. Doing an apt-get remove composer fixed the validate for me. Here is a chatlog from Laf and I. laf - Yesterday at 1:12 PM That's a really old composer version, remove it and let validate install a new version vinesman - Yesterday at 1:15 PM Using apt-get? Or using the instructions from composer. FYI using ubuntu 16.04(edited) laf - Yesterday at 1:17 PM just run ./validate.php when you've removed the old version, it will sort it out vinesman - Yesterday at 1:18 PM ./validate ran s…

After apt removing the package running ./validate.php again installed it for me, no more error.

[mourillostak]

Thanks !
The composer message have been gone after removing composer package.

I have now new problems with validate.php :
root@SRV:/opt/librenms# ./validate.php

Component	Version
LibreNMS	1.37-17-g5af51fa
DB Schema	238
PHP	5.6.11-1ubuntu3.2
MySQL	5.6.30-0ubuntu0.15.10.1
RRDTool	1.5.4
SNMP	NET-SNMP 5.7.3

====================================

[OK] Composer Version: 1.6.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] You have not set sql_mode=’’ in your mysql config.
[FIX] Set sql-mode=’’ in your mysql config file in the [mysqld] section.
[FAIL] Database: incorrect column (users/updated_at)
[FAIL] Database: missing column (users/remember_token)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE users CHANGE updated_at updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE users ADD remember_token varchar(100) NULL AFTER updated_at;
root@SRV:/opt/librenms#

[Kevin_Krumm]

@mourillostak

[FAIL] You have not set sql_mode=’’ in your mysql config.

[FIX] Set sql-mode=’’ in your mysql config file in the [mysqld] section.

[FAIL] Database: incorrect column (users/updated_at)

[FAIL] Database: missing column (users/remember_token)

[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (Report database schema issues here - LibreNMS Community):

[FIX] Run the following SQL statements to fix.

SQL Statements:

ALTER TABLE users CHANGE updated_at updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE users ADD remember_token varchar(100) NULL AFTER updated_at;

root@SRV:/opt/librenms#

@mourillostak you need to fix all that follow the commands its telling you.

[ManOfLard]

@mourillostak Unrelated - but definitely not helping your cause - your server is beyond end of support - an upgrade to an LTS build (16.04) would be a positive move too.