====== grafana ======



===== Debian Repos =====

<file>
W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://packages.grafana.com/oss/deb stable InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
W: Failed to fetch https://packages.grafana.com/oss/deb/dists/stable/InRelease  The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
</file>

<code bash>
mkdir -p /etc/apt/keyrings/
wget -q -O - https://apt.grafana.com/gpg.key | gpg --dearmor > /etc/apt/keyrings/grafana.gpg
echo "deb [signed-by=/etc/apt/keyrings/grafana.gpg] https://apt.grafana.com stable main" | tee /etc/apt/sources.list.d/grafana.list
</code>

https://grafana.com/blog/2023/01/12/grafana-labs-update-regarding-circleci-security-updates/

===== reset des admin Passwortes =====

auf admin/admin: ''grafana-cli admin reset-admin-password admin''
<file>
INFO [05-22|12:05:09] Starting Grafana                         logger=settings version= commit= branch= compiled=1970-01-01T01:00:00+01:00
INFO [05-22|12:05:09] Config loaded from                       logger=settings file=/usr/share/grafana/conf/defaults.ini
INFO [05-22|12:05:09] Config loaded from                       logger=settings file=/etc/grafana/grafana.ini
INFO [05-22|12:05:09] Config overridden from command line      logger=settings arg="default.paths.data=/var/lib/grafana"
INFO [05-22|12:05:09] Config overridden from command line      logger=settings arg="default.paths.logs=/var/log/grafana"
INFO [05-22|12:05:09] Config overridden from command line      logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
INFO [05-22|12:05:09] Config overridden from command line      logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
INFO [05-22|12:05:09] Path Home                                logger=settings path=/usr/share/grafana
INFO [05-22|12:05:09] Path Data                                logger=settings path=/var/lib/grafana
INFO [05-22|12:05:09] Path Logs                                logger=settings path=/var/log/grafana
INFO [05-22|12:05:09] Path Plugins                             logger=settings path=/var/lib/grafana/plugins
INFO [05-22|12:05:09] Path Provisioning                        logger=settings path=/etc/grafana/provisioning
INFO [05-22|12:05:09] App mode production                      logger=settings
INFO [05-22|12:05:09] Envelope encryption state                logger=secrets enabled=true current provider=secretKey.v1

Admin password changed successfully ✔
</file>

<code bash>
sqlite3 /var/lib/grafana/grafana.db
</code>
</code sql>
.tables
select * from user;
update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin';
</code>

  * https://stackoverflow.com/questions/54039604/what-is-the-default-username-and-password-for-grafana-login-page
  * https://ahelpme.com/software/grafana/reset-lost-admin-password-of-grafana-server-centos-7/