Password prompts for MySQL adduser
[hcoop/domtool2.git] / src / plugins / mysql.sml
1 (* HCoop Domtool (http://hcoop.sourceforge.net/)
2 * Copyright (c) 2006, Adam Chlipala
3 *
4 * This program is free software; you can redistribute it and/or
5 * modify it under the terms of the GNU General Public License
6 * as published by the Free Software Foundation; either version 2
7 * of the License, or (at your option) any later version.
8 *
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
13 *
14 * You should have received a copy of the GNU General Public License
15 * along with this program; if not, write to the Free Software
16 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17 *)
18
19 (* MySQL user/table management *)
20
21 structure MySQL :> MYSQL = struct
22
23 val validPasswd = CharVector.all (fn ch => Char.isAlphaNum ch
24 orelse ch = #"!"
25 orelse ch = #"."
26 orelse ch = #"-"
27 orelse ch = #"_")
28
29 fun adduser {user, passwd} =
30 case passwd of
31 NONE => SOME "No password given"
32 | SOME passwd =>
33 if validPasswd passwd then
34 if Slave.shell [Config.MySQL.adduser, user, " ", passwd] then
35 NONE
36 else
37 SOME "Error executing CREATE USER script"
38 else
39 SOME "Password contains characters besides letters, digits, and !.-_"
40
41 fun createdb {user, dbname} =
42 if Slave.shell [Config.MySQL.createdb, user, " ", dbname] then
43 NONE
44 else
45 SOME "Error executing CREATE DATABASE script"
46
47 val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass,
48 adduser = adduser,
49 createdb = createdb})
50
51 end