provider_config:这个值的配置由provider的设置来确定,如果provider是file,则是data/xxxx路径类型,如果provider是mysql,则是user:password@tcp(127.0.0.1:3306)/database_name,如果provider是postgres,则是user=a password=b host=localhost port=5432 dbname=c sslmode=disable cookie_name:grafana的cookie名称 cookie_s...
# Either "mysql", "postgres" or "sqlite3", it's your choice ;type = ;host = ;name = ;user = # If the password contains # or ; you have to wrap it with trippel quotes. Ex """#password;""" ;password = # Use either URL or the previous fields to configure the database # ...
logger=sqlstore t=2023-08-20T16:33:27.895869Z level=info msg=“Connecting to DB” dbtype=sqlite3 logger=sqlstore t=2023-08-20T16:33:27.8958848Z level=warn msg=“SQLite database file has broader permissions than it should” path=/var/lib/grafana/grafana.db mode=-rw-rw--- expected=-rw...
Includes IP or hostname and port 68 ;host = 127.0.0.1:3306 69 # The name of the Grafana database 70 ;name = grafana 71 ;user = root 72 ;password = 73 74 # For "postgres" only, either "disable", "require" or "verify-full" 75 ;ssl_mode = disable 76 77 # For "sqlite3" onl...
t=2017-08-14T14:56:45+0000 lvl=eror msg="Failed to save state" logger=alerting.resultHandler error="database is locked" Let me know if you need any info from my side It is an SQLite error that can occur on concurrent writes. See#7992and#7013. Not sure exactly why you are getting...
FAILED解决过程:查log。[root@localhost grafana]# tail -f /var/log/grafana/grafana.logt=2017-06-22T11:26:03+0800 lvl=info msg="Executing migration" logger=migrator id="create index UQE_user_email - v2"t=2017-06-22T11:26:03+0800 lvl=info msg="Executing migration" logger=migrator id="...
sqlite: 如果使用sqlite,则只需备份grafana.db文件。它通常位于Unix系统上的/var/lib/grafana/grafana.db中。 如果不确定使用哪个数据库以及将其存储在哪里,请检查grafana配置文件。 如果使用二进制tar/zip将grafana安装到自定义位置,则通常在<grafana_install_dir>/data中。
我已经将Grafana从SQLite数据库迁移到了MySQL (实际上是MariaDB 10.3.22),所以现在数据库位于另一台机器上。很明显,软件现在需要一个数据库帐户,所以我创建了一个单独的帐户: MariaDB [(grafana)]> create user 'grafana'@'%' identified by 'XX'; 然后,我调整了Grafana配置文件以使用新创建的帐户。一切都成...
默认使用sqlite3数据库,可以编辑配置文件/etc/grafana/grafana.ini,修改使用的数据库,可以选择mysql或者postgres,默认数据库文件位置/var/lib/grafana/grafana.db创建grafana数据库 create database grafana character set utf8 collate utf8_general_ci; 编辑grafana配置文件 ...
37+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana/grafana-server.pid pid=7946 t=2021-07-28T14:06:37+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3 t=2021-07-28T14:06:37+0100 lvl=info msg="Creating SQLite database file" logger=sql...