Script Python para gestionar los usuarios de Grafana

Script Python para gestionar los usuarios de Grafana.

Grafana es un excelente monitor de servidores Linux, en este articulo presento un script que te ayudara a gestionar los usuarios del afamado monitor.

Al ser un simple script vamos a verlo sin perder más tiempo, únicamente debes tener en cuenta que se requiere que tengas instalado Python 3 (revisa este articulo sobre como instalar Python 3).

Script Python que gestiona los usuarios de Grafana

Abre tu editor favorito, copia y pega lo siguiente.

#!/usr/bin/env python3
# Created by Sergio G.B.
# https://www.sololinux.es
# -*- coding: utf-8 -*-

import requests
import time
import argparse
import json


class Bgcolors:
    def __init__(self):
        self.get = {
            'HEADER': '\033[95m',
            'OKBLUE': '\033[94m',
            'OKGREEN': '\033[92m',
            'WARNING': '\033[93m',
            'FAIL': '\033[91m',
            'ENDC': '\033[0m',
            'BOLD': '\033[1m',
            'UNDERLINE': '\033[4m'
        }


def search_grafana_user(gurl, g_user, g_password, email):
    g_protocol = gurl.split(':')[0]
    g_url = gurl.split('//')[1]

    get_data_req = requests.get(
        g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users?perpage=10&page=1')
    pars_json = json.loads(get_data_req.text)
    for user in pars_json:
        if user['email'] == email:
            account_id = user['id']
        else:
            account_id = -1

    return account_id


def get_grafana_users(gurl, g_user, g_password):
    users_array = []

    g_protocol = gurl.split(':')[0]
    g_url = gurl.split('//')[1]

    get_data_req = requests.get(g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users')
    pars_json = json.loads(get_data_req.text)
    for user in pars_json:
        users_array.append(user['email'])
        # print (user)

    return users_array


def add_grafana_user(gurl, g_user, g_password, created_email, created_password):
    g_protocol = gurl.split(':')[0]
    g_url = gurl.split('//')[1]

    grafana_users = get_grafana_users(gurl, g_user, g_password)
    for user in grafana_users:
        if user == created_email:
            print(Bgcolors().get['FAIL'] + 'User already exist: ', user, '\nUse another name!' + Bgcolors().get['ENDC'])
            exit(0)
    data = {"name": created_email,
            "email": created_email,
            "login": created_email,
            "password": created_password,
            }

    get_data_req = requests.post(g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users',
                                 data)
    pars_json = json.loads(get_data_req.text)
    print(pars_json)
    print('URL: ' + gurl, '\nemail: ' + created_email, '\npassword: ' + created_password)

    return add_grafana_user


def update_grafana_users(gurl, g_user, g_password, email):
    g_protocol = gurl.split(':')[0]
    g_url = gurl.split('//')[1]

    state_of_admin = str.lower('True')
    data_put = {"Accept": "application/json",
                "Content-Type": "application/json",
                "isGrafanaAdmin": state_of_admin,
                }

    account_id = search_grafana_user(gurl, g_user, g_password, email)
    if account_id != -1:
        get_data_req = requests.put(
            g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users/%s/permissions' % account_id,
            data=data_put)
        pars_json = json.loads(get_data_req.text)
        print(pars_json)

        get_data_req = requests.get(
            g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users?perpage=10&page=1')
        pars_json = json.loads(get_data_req.text)
        for user in pars_json:
            if user['email'] == email:
                print(user)
    else:
        print('Unfortunately, I cant find [%s] email in grafana to update role!' % email)
        print('Please, use current EMAIL!')
        exit(0)

    return update_grafana_users


def update_grafana_user_password(gurl, g_user, g_password, email):
    g_protocol = gurl.split(':')[0]
    g_url = gurl.split('//')[1]

    data_put = {"password": "password"}
    account_id = search_grafana_user(gurl, g_user, g_password, email)
    if account_id != -1:
        get_data_req = requests.put(
            g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users/%s/password' % account_id,
            data=data_put)
        pars_json = json.loads(get_data_req.text)
        print(pars_json)

    else:
        print('Unfortunately, I cant find [%s] email in grafana to update PW!' % email)
        print('Please, use current EMAIL!')
        exit(0)

    return update_grafana_users


def delete_grafana_users(gurl, g_user, g_password, email):
    g_protocol = gurl.split(':')[0]
    g_url = gurl.split('//')[1]

    account_id = search_grafana_user(gurl, g_user, g_password, email)
    get_data_req = requests.delete(
        g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users/%s' % account_id)
    pars_json = json.loads(get_data_req.text)
    print(pars_json)

    get_data_req = requests.get(g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users')
    pars_json = json.loads(get_data_req.text)
    for user in pars_json:
        print(user)

    return update_grafana_users


def main():
    start__time = time.time()
    parser = argparse.ArgumentParser(prog='python3 script_name.py -h',
                                     usage='python3 script_name.py {ARGS}',
                                     add_help=True,
                                     prefix_chars='--/',
                                     epilog='''created by Sergio G.B.''')
    parser.add_argument('--version', action='version', version='v0.9.5')
    parser.add_argument('--gtoken', '--token', dest='gtoken', help='Token of grafana server', default=None)
    parser.add_argument('--gurl', '--url', dest='gurl', help='URL from grafana', default=None)
    parser.add_argument('--glogin', dest='glogin', help='A login to grafana', default=None)
    parser.add_argument('--gpassword', dest='gpassword', help='A password of grafana user', default=None)
    parser.add_argument('--email', dest='email', help='A email to create a new user in grafana', default=None)
    parser.add_argument('--password', dest='password', help='A password of grafana user which need to create',
                        default=None)

    group = parser.add_mutually_exclusive_group(required=False)
    group.add_argument('--show', dest='show', help='Show grafana users', action='store_true')
    group.add_argument('--s', dest='show', help='Show grafana users', action='store_true')

    group2 = parser.add_mutually_exclusive_group(required=False)
    group2.add_argument('--add', dest='add', help='Add grafana user', action='store_true')
    group2.add_argument('--a', dest='add', help='Add grafana user', action='store_true')

    group3 = parser.add_mutually_exclusive_group(required=False)
    group3.add_argument('--update', dest='update', help='Update grafana user', action='store_true')
    group3.add_argument('--u', dest='update', help='Update grafana user', action='store_true')

    group4 = parser.add_mutually_exclusive_group(required=False)
    group4.add_argument('--cpassword', dest='changepassword', help='Change grafana user PW', action='store_true')
    group4.add_argument('--changepw', dest='changepassword', help='Change grafana user PW', action='store_true')

    group5 = parser.add_mutually_exclusive_group(required=False)
    group5.add_argument('--delete', dest='delete', help='Delete grafana user', action='store_true')
    group5.add_argument('--d', dest='delete', help='Delete grafana user', action='store_true')

    results = parser.parse_args()
    grafana_url = results.gurl
    grafana_login = results.glogin
    grafana_password = results.gpassword
    user_email = results.email
    user_password = results.password

    if results.add:
        if (grafana_url is not None) and (user_email is not None) and (user_password is not None):
            add_grafana_user(grafana_url, grafana_login, grafana_password, user_email, user_password)
        else:
            print('Please add [--gurl] or [--email] or [--password]')
            print('For help, use: script_name.py -h')
            exit(0)

    elif results.update:
        if user_email is not None:
            update_grafana_users(grafana_url, grafana_login, grafana_password, user_email)
        else:
            print('Please add [--gurl] or [--email]')
            print('For help, use: script_name.py -h')
            exit(0)

    elif results.changepassword:
        if user_email is not None:
            update_grafana_user_password(grafana_url, grafana_login, grafana_password, user_email)
        else:
            print('Please add [--gurl] or [--email]')
            print('For help, use: script_name.py -h')
            exit(0)
    elif results.delete:
        if user_email is not None:
            delete_grafana_users(grafana_url, grafana_login, grafana_password, user_email)
        else:
            print('Please add [--gurl] or [--email]')
            print('For help, use: script_name.py -h')
            exit(0)
    elif results.show:
        if (grafana_url is not None) and (grafana_login is not None) and (grafana_password is not None):
            # print(get_grafana_users(grafana_url, grafana_login, grafana_password))
            users = get_grafana_users(grafana_url, grafana_login, grafana_password)
            for user in users:
                print(user)
        else:
            print('Please add [--gurl] or [--email] or [--password]')
            print('For help, use: script_name.py -h')
            exit(0)
    else:
        print('For help, use: script_name.py -h')
        exit(0)

    end__time = round(time.time() - start__time, 2)
    print("--- %s seconds ---" % end__time)

    print(
        Bgcolors().get['OKGREEN'], "============================================================",
        Bgcolors().get['ENDC'])
    print(
        Bgcolors().get['OKGREEN'], "==========================FINISHED==========================",
        Bgcolors().get['ENDC'])
    print(
        Bgcolors().get['OKGREEN'], "============================================================",
        Bgcolors().get['ENDC'])


if __name__ == '__main__':
    main()

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

#!/usr/bin/env python3

# Created by Sergio G.B.

# https://www.sololinux.es

# -*- coding: utf-8 -*-

import requests

import time

import argparse

import json

class Bgcolors:

def __init__(self):

self.get = {

'HEADER': '\033[95m',

'OKBLUE': '\033[94m',

'OKGREEN': '\033[92m',

'WARNING': '\033[93m',

'FAIL': '\033[91m',

'ENDC': '\033[0m',

'BOLD': '\033[1m',

'UNDERLINE': '\033[4m'

}

def search_grafana_user(gurl, g_user, g_password, email):

g_protocol = gurl.split(':')[0]

g_url = gurl.split('//')[1]

get_data_req = requests.get(

g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users?perpage=10&page=1')

pars_json = json.loads(get_data_req.text)

for user in pars_json:

if user['email'] == email:

account_id = user['id']

else:

account_id = -1

return account_id

def get_grafana_users(gurl, g_user, g_password):

users_array = []

g_protocol = gurl.split(':')[0]

g_url = gurl.split('//')[1]

get_data_req = requests.get(g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users')

pars_json = json.loads(get_data_req.text)

for user in pars_json:

users_array.append(user['email'])

# print (user)

return users_array

def add_grafana_user(gurl, g_user, g_password, created_email, created_password):

g_protocol = gurl.split(':')[0]

g_url = gurl.split('//')[1]

grafana_users = get_grafana_users(gurl, g_user, g_password)

for user in grafana_users:

if user == created_email:

print(Bgcolors().get['FAIL'] + 'User already exist: ', user, '\nUse another name!' + Bgcolors().get['ENDC'])

exit(0)

data = {"name": created_email,

"email": created_email,

"login": created_email,

"password": created_password,

}

get_data_req = requests.post(g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users',

data)

pars_json = json.loads(get_data_req.text)

print(pars_json)

print('URL: ' + gurl, '\nemail: ' + created_email, '\npassword: ' + created_password)

return add_grafana_user

def update_grafana_users(gurl, g_user, g_password, email):

g_protocol = gurl.split(':')[0]

g_url = gurl.split('//')[1]

state_of_admin = str.lower('True')

data_put = {"Accept": "application/json",

"Content-Type": "application/json",

"isGrafanaAdmin": state_of_admin,

}

account_id = search_grafana_user(gurl, g_user, g_password, email)

if account_id != -1:

get_data_req = requests.put(

g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users/%s/permissions' % account_id,

data=data_put)

pars_json = json.loads(get_data_req.text)

print(pars_json)

get_data_req = requests.get(

g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users?perpage=10&page=1')

pars_json = json.loads(get_data_req.text)

for user in pars_json:

if user['email'] == email:

print(user)

else:

print('Unfortunately, I cant find [%s] email in grafana to update role!' % email)

print('Please, use current EMAIL!')

exit(0)

return update_grafana_users

def update_grafana_user_password(gurl, g_user, g_password, email):

g_protocol = gurl.split(':')[0]

g_url = gurl.split('//')[1]

data_put = {"password": "password"}

account_id = search_grafana_user(gurl, g_user, g_password, email)

if account_id != -1:

get_data_req = requests.put(

g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users/%s/password' % account_id,

data=data_put)

pars_json = json.loads(get_data_req.text)

print(pars_json)

else:

print('Unfortunately, I cant find [%s] email in grafana to update PW!' % email)

print('Please, use current EMAIL!')

exit(0)

return update_grafana_users

def delete_grafana_users(gurl, g_user, g_password, email):

g_protocol = gurl.split(':')[0]

g_url = gurl.split('//')[1]

account_id = search_grafana_user(gurl, g_user, g_password, email)

get_data_req = requests.delete(

g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/admin/users/%s' % account_id)

pars_json = json.loads(get_data_req.text)

print(pars_json)

get_data_req = requests.get(g_protocol + '://' + g_user + ':' + g_password + '@' + g_url + '/api/users')

pars_json = json.loads(get_data_req.text)

for user in pars_json:

print(user)

return update_grafana_users

def main():

start__time = time.time()

parser = argparse.ArgumentParser(prog='python3 script_name.py -h',

usage='python3 script_name.py {ARGS}',

add_help=True,

prefix_chars='--/',

epilog='''created by Sergio G.B.''')

parser.add_argument('--version', action='version', version='v0.9.5')

parser.add_argument('--gtoken', '--token', dest='gtoken', help='Token of grafana server', default=None)

parser.add_argument('--gurl', '--url', dest='gurl', help='URL from grafana', default=None)

parser.add_argument('--glogin', dest='glogin', help='A login to grafana', default=None)

parser.add_argument('--gpassword', dest='gpassword', help='A password of grafana user', default=None)

parser.add_argument('--email', dest='email', help='A email to create a new user in grafana', default=None)

parser.add_argument('--password', dest='password', help='A password of grafana user which need to create',

default=None)

group = parser.add_mutually_exclusive_group(required=False)

group.add_argument('--show', dest='show', help='Show grafana users', action='store_true')

group.add_argument('--s', dest='show', help='Show grafana users', action='store_true')

group2 = parser.add_mutually_exclusive_group(required=False)

group2.add_argument('--add', dest='add', help='Add grafana user', action='store_true')

group2.add_argument('--a', dest='add', help='Add grafana user', action='store_true')

group3 = parser.add_mutually_exclusive_group(required=False)

group3.add_argument('--update', dest='update', help='Update grafana user', action='store_true')

group3.add_argument('--u', dest='update', help='Update grafana user', action='store_true')

group4 = parser.add_mutually_exclusive_group(required=False)

group4.add_argument('--cpassword', dest='changepassword', help='Change grafana user PW', action='store_true')

group4.add_argument('--changepw', dest='changepassword', help='Change grafana user PW', action='store_true')

group5 = parser.add_mutually_exclusive_group(required=False)

group5.add_argument('--delete', dest='delete', help='Delete grafana user', action='store_true')

group5.add_argument('--d', dest='delete', help='Delete grafana user', action='store_true')

results = parser.parse_args()

grafana_url = results.gurl

grafana_login = results.glogin

grafana_password = results.gpassword

user_email = results.email

user_password = results.password

if results.add:

if (grafana_url is not None) and (user_email is not None) and (user_password is not None):

add_grafana_user(grafana_url, grafana_login, grafana_password, user_email, user_password)

else:

print('Please add [--gurl] or [--email] or [--password]')

print('For help, use: script_name.py -h')

exit(0)

elif results.update:

if user_email is not None:

update_grafana_users(grafana_url, grafana_login, grafana_password, user_email)

else:

print('Please add [--gurl] or [--email]')

print('For help, use: script_name.py -h')

exit(0)

elif results.changepassword:

if user_email is not None:

update_grafana_user_password(grafana_url, grafana_login, grafana_password, user_email)

else:

print('Please add [--gurl] or [--email]')

print('For help, use: script_name.py -h')

exit(0)

elif results.delete:

if user_email is not None:

delete_grafana_users(grafana_url, grafana_login, grafana_password, user_email)

else:

print('Please add [--gurl] or [--email]')

print('For help, use: script_name.py -h')

exit(0)

elif results.show:

if (grafana_url is not None) and (grafana_login is not None) and (grafana_password is not None):

# print(get_grafana_users(grafana_url, grafana_login, grafana_password))

users = get_grafana_users(grafana_url, grafana_login, grafana_password)

for user in users:

print(user)

else:

print('Please add [--gurl] or [--email] or [--password]')

print('For help, use: script_name.py -h')

exit(0)

else:

print('For help, use: script_name.py -h')

exit(0)

end__time = round(time.time() - start__time, 2)

print("--- %s seconds ---" % end__time)

print(

Bgcolors().get['OKGREEN'], "============================================================",

Bgcolors().get['ENDC'])

print(

Bgcolors().get['OKGREEN'], "==========================FINISHED==========================",

Bgcolors().get['ENDC'])

print(

Bgcolors().get['OKGREEN'], "============================================================",

Bgcolors().get['ENDC'])

if __name__ == '__main__':

main()

Guarda el archivo como «gestion-users-graf.py» y cierras el editor.

Puedes ejecutar el script y comenzar a gestionar los usuarios. Alternativamente puedes usar las opciones siguientes…

—show — Muestra los usuarios de Grafana.
—add — Agrega un usuario.
—cpassword — Cambiar la contraseña.
— delete — Eliminar usuario de Grafana.

Revisa todas las opciones con…

gestion-users-graf.py -h

1	gestion-users-graf.py -h

ejemplo de salida…

usage: python3 script_name.py {ARGS}

optional arguments:
-h, –help show this help message and exit
–version show program’s version number and exit
–gtoken GTOKEN, –token GTOKEN
Token of grafana server
–gurl GURL, –url GURL
URL from grafana
–glogin GLOGIN A login to grafana
–gpassword GPASSWORD
A password of grafana user
–email EMAIL A email to create a new user in grafana
–password PASSWORD A password of grafana user which need to create
–show Show grafana users
–s Show grafana users
–add Add grafana user
–a Add grafana user
–update Update grafana user
–u Update grafana user
–cpassword Change grafana user PW
–changepw Change grafana user PW
–delete Delete grafana user
–d Delete grafana user

Script Python para gestionar los usuarios de Grafana

Script Python que gestiona los usuarios de Grafana

Agregar comentario

Cancelar respuesta