juandelacosa: Manage users in MariaDB >= 10.1.1
This is a package candidate release! Here you can preview how this package release will appear once published to the main package index (which can be accomplished via the 'maintain' link below). Please note that once a package has been published to the main package index it cannot be undone! Please consult the package uploading documentation for more information.
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]
Properties
| Versions | 0.0.1, 0.1.1, 0.1.2, 0.1.2 |
|---|---|
| Change log | ChangeLog.md |
| Dependencies | base (>=4.8 && <50), base64-bytestring (>=1.0), bytestring (>=0.10), data-default-class, entropy (>=0.3), fast-logger, http-types (>=0.9), mtl (>=2.2), mysql (>=0.1), mysql-simple (>=0.2), network (>=2.6), optparse-applicative (>=0.13.0.0), resource-pool (>=0.2), scotty (>=0.10), text (>=1.2), unix (>=2.7), wai (>=3.2), wai-extra (>=3.0), wai-middleware-static (>=0.8), 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/ip1981/juandelacosa.git |
| Uploaded | by ip1981 at 2021-03-17T08:37:59Z |
Downloads
- juandelacosa-0.1.2.tar.gz [browse] (Cabal source package)
- Package description (as included in the package)
Maintainer's Corner
Package maintainers
For package maintainers and hackage trustees
Readme for juandelacosa-0.1.2
[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/ip1981/juandelacosa.git
$ cd juandelacosa
$ cabal install
Usage
Type juandelacosa --help to see usage summary:
Usage: juandelacosa [-f|--file FILE] [-g|--group STRING] [-d|--datadir DIR]
[(-p|--port INT) | (-s|--socket PATH)]
Available options:
-f,--file FILE Read this MySQL client config file
-g,--group STRING Read this options group in the above file
(default: "client")
-d,--datadir DIR Data directory including static files
(default: "/home/pashev/.cabal/share/x86_64-linux-ghc-8.8.4/juandelacosa-0.1.2")
-p,--port INT listen on this TCP port (localhost only)
-s,--socket PATH Listen on this UNIX-socket
(default: "/tmp/juandelacosa.sock")
-h,--help Show this help text
Database Privileges
CREATE USER IF NOT EXISTS 'juandelacosa'@'localhost' IDENTIFIED VIA unix_socket;
REVOKE ALL, GRANT OPTION FROM 'juandelacosa'@'localhost';
GRANT UPDATE ON `mysql`.* TO 'juandelacosa'@'localhost';
GRANT SELECT ON `mysql`.`user` TO 'juandelacosa'@'localhost';
Screenshots
