| 1 | use strict; | ||
| 2 | use 5.010; | ||
| 3 | |||
| 4 | package FusqlFS::Backend::MySQL::Users; | ||
| 5 | use FusqlFS::Version; | ||
| 6 | our $VERSION = $FusqlFS::Version::VERSION; | ||
| 7 | use parent 'FusqlFS::Artifact'; | ||
| 8 | |||
| 9 | our @USER_PRIVILEGES = ( | ||
| 10 | 'Select' , | ||
| 11 | 'Insert' , | ||
| 12 | 'Update' , | ||
| 13 | 'Delete' , | ||
| 14 | 'Create' , | ||
| 15 | 'Drop' , | ||
| 16 | 'Reload' , | ||
| 17 | 'Shutdown' , | ||
| 18 | 'Process' , | ||
| 19 | 'File' , | ||
| 20 | 'Grant' , | ||
| 21 | 'References' , | ||
| 22 | 'Index' , | ||
| 23 | 'Alter' , | ||
| 24 | 'Show db' , | ||
| 25 | 'Super' , | ||
| 26 | 'Create tmp table' , | ||
| 27 | 'Lock tables' , | ||
| 28 | 'Execute' , | ||
| 29 | 'Repl slave' , | ||
| 30 | 'Repl client' , | ||
| 31 | 'Create view' , | ||
| 32 | 'Show view' , | ||
| 33 | 'Create routine' , | ||
| 34 | 'Alter routine' , | ||
| 35 | 'Create user' , | ||
| 36 | 'Event' , | ||
| 37 | 'Trigger' , | ||
| 38 | 'Create tablespace' , | ||
| 39 | ); | ||
| 40 | our @TABLE_PRIVILEGES = ( | ||
| 41 | 'Select' , | ||
| 42 | 'Insert' , | ||
| 43 | 'Update' , | ||
| 44 | 'Delete' , | ||
| 45 | 'Create' , | ||
| 46 | 'Drop' , | ||
| 47 | 'Grant' , | ||
| 48 | 'References' , | ||
| 49 | 'Index' , | ||
| 50 | 'Alter' , | ||
| 51 | 'Create view' , | ||
| 52 | 'Show view' , | ||
| 53 | 'Trigger' , | ||
| 54 | ); | ||
| 55 | our @COLUMN_PRIVILEGES = ( | ||
| 56 | 'Select' , | ||
| 57 | 'Insert' , | ||
| 58 | 'Update' , | ||
| 59 | 'References' , | ||
| 60 | ); | ||
| 61 | our @ROUTINE_PRIVILEGES = ( | ||
| 62 | 'Execute' , | ||
| 63 | 'Alter routine' , | ||
| 64 | 'Grant' , | ||
| 65 | ); | ||
| 66 | |||
| 67 | sub init | ||
| 68 | { | ||
| 69 | my $self = shift; | ||
| 70 | $self->{list_expr} = $self->expr("SELECT CONCAT(User, '\@', Host) FROM mysql.user"); | ||
| 71 | $self->{get_expr} = $self->expr("SELECT * FROM mysql.user WHERE User = ? AND Host = ?"); | ||
| 72 | $self->{create_expr} = q{CREATE USER '%(User)$s'@'%(Host)$s'}; | ||
| 73 | $self->{drop_expr} = q{DROP USER '%(User)$s'@'%(Host)$s'}; | ||
| 74 | $self->{rename_expr} = q{RENAME USER '%(User)$s'@'%(Host)$s' TO '%(NewUser)$s'@'%(NewHost)$s'}; | ||
| 75 | } | ||
| 76 | |||
| 77 | sub list | ||
| 78 | { | ||
| 79 | my $self = shift; | ||
| 80 | return $self->all_col($self->{list_expr})||[]; | ||
| 81 | } | ||
| 82 | |||
| 83 | sub get | ||
| 84 | { | ||
| 85 | my $self = shift; | ||
| 86 | my ($user, $host) = split(/@/, shift, 2); | ||
| 87 | return unless $user || $host; | ||
| 88 | |||
| 89 | my $data = $self->one_row($self->{get_expr}, $user, $host); | ||
| 90 | return unless $data; | ||
| 91 | |||
| 92 | my @privileges = (); | ||
| 93 | my %result = (); | ||
| 94 | while (my ($name, $value) = each %$data) { | ||
| 95 | if ($name =~ /_priv$/) { | ||
| 96 | $name =~ s/_priv$//; | ||
| 97 | $name =~ s/_/ /g; | ||
| 98 | push @privileges, $name if $value == 'Y'; | ||
| 99 | } else { | ||
| 100 | $result{$name} = $value; | ||
| 101 | } | ||
| 102 | } | ||
| 103 | $result{privileges} = \@privileges; | ||
| 104 | |||
| 105 | return $self->dump(\%result); | ||
| 106 | } | ||
| 107 | |||
| 108 | sub create | ||
| 109 | { | ||
| 110 | my $self = shift; | ||
| 111 | my ($user, $host) = split(/@/, shift, 2); | ||
| 112 | return unless $user || $host; | ||
| 113 | |||
| 114 | $self->do($self->{create_expr}, {User => $user, Host => $host}); | ||
| 115 | } | ||
| 116 | |||
| 117 | sub drop | ||
| 118 | { | ||
| 119 | my $self = shift; | ||
| 120 | my ($user, $host) = split(/@/, shift, 2); | ||
| 121 | return unless $user || $host; | ||
| 122 | |||
| 123 | $self->do($self->{drop_expr}, {User => $user, Host => $host}); | ||
| 124 | } | ||
| 125 | |||
| 126 | sub rename | ||
| 127 | { | ||
| 128 | my $self = shift; | ||
| 129 | my ($user, $host) = split(/@/, shift, 2); | ||
| 130 | my ($newuser, $newhost) = split(/@/, shift, 2); | ||
| 131 | |||
| 132 | $self->do($self->{rename_expr}, {User => $user, Host => $host, NewUser => $newuser, NewHost => $newhost}); | ||
| 133 | } | ||
| 134 | |||
| 135 | sub store | ||
| 136 | { | ||
| 137 | my $self = shift; | ||
| 138 | my ($user, $host) = split(/@/, shift, 2); | ||
| 139 | return unless $user || $host; | ||
| 140 | |||
| 141 | my $priv_re = join('|', @USER_PRIVILEGES); | ||
| 142 | $priv_re = qr/^$priv_re$/i; | ||
| 143 | |||
| 144 | my $data = $self->validate(shift, { | ||
| 145 | max_connections => qr/^\d+$/, | ||
| 146 | max_questions => qr/^\d+$/, | ||
| 147 | max_updates => qr/^\d+$/, | ||
| 148 | max_user_connections => qr/^\d+$/, | ||
| 149 | priviledges => ['ARRAY', sub{ [ grep { $_ =~ $priv_re } @$_ ] }], | ||
| 150 | }) or return; | ||
| 151 | |||
| 152 | $data->{User} = $user; | ||
| 153 | $data->{Host} = $host; | ||
| 154 | $data->{privileges} = join ',', @{$data->{privileges}}; | ||
| 155 | |||
| 156 | $self->do(q{REVOKE ALL ON *.* FROM '%(User)$s'@'%(Host)$s'}, {User => $user, Host => $host}); | ||
| 157 | $self->do(q{GRANT %(privileges)$s ON *.* TO '%(User)$s'@'%(Host)$s' WITH MAX_QUERIES_PER_HOUR %(max_questions)$d MAX_UPDATES_PER_HOUR %(max_updates)$d MAX_CONNECTIONS_PER_HOUR %(max_connections)$d MAX_USER_CONNECTIONS %(max_user_connections)$d}, $data); | ||
| 158 | } | ||
| 159 | |||
| 160 | __END__ |