After the composer update showing as problem with backend

Help
26

So any way is there i can fix it without disturbing our environment?

27

Yes, you need to fix whatever issue you are having. Start checking your msyql server logs. Run mysqltuner. Check system logs.

28

here is the result of mysql tuner

General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Set up a Password for user with the following SQL statement ( SET PASSWORD FOR ‘user’@‘SpecificDNSorIp’ = PASSWORD(‘secure_password’); )
Reduce your overall MySQL memory footprint for system stability
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
Beware that open_files_limit (50005) variable
should be greater than table_open_cache ( 400)
Variables to adjust:
*** MySQL’s maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_limit (> 1M, or use smaller result sets)
query_cache_size (> 16M)
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
table_open_cache (> 400)
innodb_buffer_pool_size (>= 2G) if possible.
innodb_buffer_pool_instances (=1)
innodb_log_buffer_size (>= 8M)

Kindly let me know how to resolve this

29

It tells you what the recommendations are and what you need to do.

30

@tleadley, what config file specifically has the cookie parameter?

Thanks

31

config.php

33

HI tleadley ,

i got the same problem

34

config.php ?

35

We having same issue https://prnt.sc/kwq45a

36

$config[‘secure_cookies’] = true; line is not available in config.php .what to do?

37

./validate.php

Component Version
LibreNMS 1.43-107-g4f6e2b4
DB Schema 268
PHP 7.2.9
MySQL 5.5.60-MariaDB
RRDTool 1.4.8
SNMP NET-SNMP 5.7.2

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

[OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[FAIL] Missing PHP extension: mysqlnd
[FIX] Please install mysqlnd
[FAIL] We have found some files that are owned by a different user than librenms, this will stop you updating automatically and / or rrd files being updated causing graphs to fail.
i am getting this any idea?

38

tail -f /opt/librenms/log/librenms.log is
/opt/librenms/poller.php 50 2018-09-20 17:51:03 - 1 devices polled

39

Please see my reply on Problem with backend error

40

ok .thanks

41

I would add the line to the config.php file and instead set it to false.

I doubt this will be your issue without knowing more about your setup so this would be something to try. I did notice some failed Plugin entries, maybe start there!

In my case I have pfsense running haproxy, so a reverse proxy conntributed to my problem. I am using Apache on Ubuntu 16.04. So if you are running a reverse proxy I would look at your proxy configuration in addition to your librenms setup!

More information about your build could go a long way to help isolate the issue. I mean the distro you are using and if you chose Apache or Nginx, using SSL etc

42

im having the exact same problem.
im having the same issue too.

Screenshot_2
Screenshot_21906×772 20.7 KB

the result of ./validate.php
system@librenms:/opt/librenms$ sudo ./validate.php

Component Version
LibreNMS 1.51
DB Schema 2019_02_10_220000_add_dates_to_fdb (132)
PHP 7.2.15-1+ubuntu16.04.1+deb.sury.org+1
MySQL 5.7.24-0ubuntu0.16.04.1
RRDTool 1.5.5
SNMP NET-SNMP 5.7.3
====================================

[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
system@librenms:/opt/librenms$

this happened from the latest update

Screenshot_2
Screenshot_21906×772 20.7 KB

43

Can you run through

  • Re-authenticate with the GUI
  • Check logs/librenms.log
  • Restart MySQL, and check logs
  • Restart Webserver
  • Check your config file for this line --> $config[‘secure_cookies’] = true;
    comment it out or change to false
44

So here’s what i did .
first i’ve mysqlcheck -A --repair all the databases.
then i’ve installed the requirements with : pip3 install -r requirement.txt
which had all the components installed that we’re missing .
seems like the system is ok now. but ill keep a closer look into it.

45

after that , my version was updated manually using ./daily.sh from 1.51 to 1.52 successfully