Is it possible to grant a privilege to a user such that they can execute all stored procs on the server (or even within a single db on that server). Looking at the grant syntax docs (5.5), it says that I have to grant execute on procedure <dbname>.<procname> to ....
for each and every stored proc. Is there a way to do this less clusily by manipulating the mysql db itself?
dotplus's questions
I have an nginx set up in a very boring fashion as a reverse proxy to an appserver. But sometimes my upstream gets the environment variable SERVER_PORT, sometimes it does not. Anyone suggest why it's not consistent or how I might troubleshoot it?
upstream starman {
server unix:/var/run/starman.sock;
}
server {
<snip>
location / {
proxy_pass http://starman;
proxy_set_header SERVER_PORT $server_port;
}
I have a question about virtual resources in puppet. If I have:
class foo::virtual
{
define foo () {
custom_resource { $name:
<attributes>,
}
}
@foo { '1st_foo':
<attributes>,
}
}
I can realize(Foo::Virtual::Foo['1st_foo'])
in a node declaration.
However, I would like to extract the specification of each virtual foo into a separate location, somewhere apart from the specification of class foo::virtual and define foo().
By way of analogy, I have a class called common::data that provides default values for various variables:
class common::data {
$barList = [ 'a','b','z']
}
Is there some way I can declare @foo { '2nd_foo': }
from within common::data? And then refer to that in a node declaration?