| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,mail,shell_exec,system,proc_open,popen,ini_alter,dl,proc_close,curl_exec,curl_multi_exec,readfile,parse_ini_file,escapeshellarg,escapeshellcmd,show_source,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,mail,php_uname,phpinfo MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/webmin/postgresql/ |
Upload File : |
#!/usr/bin/perl
# save_user.cgi
# Create, update or delete a postgres user
require './postgresql-lib.pl';
&ReadParse();
$access{'users'} || &error($text{'user_ecannot'});
&error_setup($text{'user_err'});
if ($in{'delete'}) {
# just delete the user
$main::disable_postgresql_escaping = 1;
&execute_sql_logged($config{'basedb'}, "drop user \"$in{'user'}\"");
&webmin_log("delete", "user", $in{'user'});
}
else {
# parse inputs
$version = &get_postgresql_version();
if ($in{'ppass_def'} == 0) {
$in{'ppass'} =~ /^\S+$/ || &error($text{'user_epass'});
$sql .= $version >= 7 ? " with password '$in{'ppass'}'"
: " with password $in{'ppass'}";
}
elsif ($in{'pass_def'} == 1) {
$sql .= " with password ''";
}
if ($in{'db'}) {
$sql .= " createdb";
}
else {
$sql .= " nocreatedb";
}
if (&get_postgresql_version() < 9.5) {
if ($in{'other'}) {
$sql .= " createuser";
}
else {
$sql .= " nocreateuser";
}
}
if (!$in{'until_def'}) {
$sql .= " valid until '$in{'until'}'";
}
if ($in{'new'}) {
$in{'pname'} =~ /^\S+$/ || &error($text{'user_ename'});
&execute_sql_logged($config{'basedb'},
"create user \"$in{'pname'}\" $sql");
&webmin_log("create", "user", $in{'pname'});
}
else {
&execute_sql_logged($config{'basedb'},
"alter user \"$in{'user'}\" $sql");
if (&get_postgresql_version() >= 7.4 &&
$in{'pname'} ne $in{'user'}) {
# Rename too
&execute_sql_logged($config{'basedb'},
"alter user \"$in{'user'}\" ".
"rename to \"$in{'pname'}\"");
}
&webmin_log("modify", "user", $in{'user'});
}
}
&redirect("list_users.cgi");