Re: [net/librenms]: pkg/README inconsistencies

On 2021/06/07 11:04, Olivier Cherrier wrote:
> Hello,
>
> While deploying net/librenms, I noticed the pkg/README seems to be broken
> regarding the database creation. On my side, I got:
>
> Option 1: CLI
> -------------
> cd /var/www/librenms
> $EDITOR config.php # set database username/password etc.
> doas -u _librenms ./build-base.php
> doas: ./build-base.php: command not found
..
> So I loaded /var/www/librenms/database/schema/mysql-schema.dump into the
> database. It seems ok but I have to add this SQL command to have a working DB:

Let's use ./includes/sql-schema/update.php for this instead.

> "ALTER DATABASE librenms CHARACTER SET utf8 COLLATE utf8_unicode_ci;"
> (from https://community.librenms.org/t/post-db-collation-characterset-update-fixes/696)

..and update the create, rather than adding an ALTER DATABASE.

> Another side note, I had specify the full path to those binaries to pass
> the "./validate.php" check:
> $ grep local /var/www/librenms/config.php
> $config['fping'] = '/usr/local/sbin/fping';
> $config['rrdtool'] = '/usr/local/bin/rrdtool';
> $config['snmpgetnext'] = '/usr/local/bin/snmpgetnext';

sigh, this is because of a difference between whereis and GNU whereis:

linux$ whereis -b ping
ping: /usr/bin/ping

whereas

$ whereis ping
/sbin/ping

update committed.