juandelacosa: Manage users in MariaDB >= 10.1.1

[ databases, mit, program, web ] [ Propose Tags ]

HTTP server for managing MariaDB users. Designed to work behind Sproxy and assuming users' logins are their email addresses (MariaDB allows up to 80 characters).


[Skip to Readme]

Downloads

Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees

Candidates

Versions [RSS] 0.0.1, 0.1.1, 0.1.2
Change log ChangeLog.md
Dependencies base (>=4.8 && <5), base64-bytestring (>=1.0), bytestring (>=0.10), case-insensitive (>=1.2), docopt (>=0.7), entropy (>=0.3), http-types (>=0.9), mysql (>=0.1), mysql-simple (>=0.2), network (>=2.6), raw-strings-qq (>=1.0), resource-pool (>=0.2), unix (>=2.7), wai (>=3.2), warp (>=3.2) [details]
License MIT
Copyright 2016, Zalora South East Asia Pte. Ltd
Author Igor Pashev <pashev.igor@gmail.com>
Maintainer Igor Pashev <pashev.igor@gmail.com>
Category Databases, Web
Source repo head: git clone https://github.com/zalora/juandelacosa.git
Uploaded by ip1981 at 2016-04-06T11:36:18Z
Distributions NixOS:0.1.2
Reverse Dependencies 1 direct, 0 indirect [details]
Executables juandelacosa
Downloads 1592 total (15 in the last 30 days)
Rating (no votes yet) [estimated by Bayesian average]
Your Rating
  • λ
  • λ
  • λ
Status Docs not available [build log]
Last success reported on 2016-11-27 [all 2 reports]

Readme for juandelacosa-0.0.1

[back to package description]

Juan de la Cosa

HTTP server for managing MariaDB users. Designed to work behind Sproxy and assuming users' logins are their email addresses (MariaDB allows up to 80 characters).

Currently it only let users get new passwords.

Requirements

Juan de la Cosa is written in Haskell with GHC. All required Haskell libraries are listed in juandelacosa.cabal. Use cabal-install to fetch and build all pre-requisites automatically.

Installation

$ git clone https://github.com/zalora/juandelacosa.git
$ cd juandelacosa
$ cabal install

Usage

Type juandelacosa --help to see usage summary:

Usage:
  juandelacosa [options]

Options:
  -f, --file=MYCNF         Read this MySQL client config file
  -g, --group=GROUP        Read this options group in the above file [default: client]

  -s, --socket=SOCK        Listen on this UNIX-socket [default: /tmp/juandelacosa.sock]
  -p, --port=PORT          Instead of UNIX-socket, listen on this TCP port (localhost)

  -h, --help               Show this message

Example:

$ juandelacosa -p 8080
$ curl http://localhost:8080 -H 'From: jack.frost@example.com'
  Tiw7CdJOmYxJBZ7J

The above request will change the password for 'jack.frost@example.com'@'%' and return the new password to user. Once it's behind Sproxy any user can get a new password in a secure way.