| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/webmin/postgresql/ |
Upload File : |
$use_global_login = 1; # Always login as master user, not the mysql
# login of the current Webmin user
do 'postgresql-lib.pl';
# useradmin_create_user(&details)
# Create a new postgesql user if syncing is enabled
sub useradmin_create_user
{
if ($config{'sync_create'}) {
local $version = &get_postgresql_version();
local $sql = "create user \"$_[0]->{'user'}\"";
if ($_[0]->{'passmode'} == 3) {
$sql .= " with password '$_[0]->{'plainpass'}'";
}
$sql .= " nocreatedb";
if (&get_postgresql_version() < 9.5) {
$sql .= " nocreateuser";
}
&execute_sql_logged($config{'basedb'}, $sql);
}
}
# useradmin_delete_user(&details)
# Delete a mysql user
sub useradmin_delete_user
{
if ($config{'sync_delete'}) {
my ($pg_table, $pg_cols) = &get_pg_shadow_table();
local $s = &execute_sql($config{'basedb'},
"select $pg_cols from $pg_table where usename = '$_[0]->{'user'}'");
return if (!@{$s->{'data'}});
&execute_sql_logged($config{'basedb'}, "drop user \"$_[0]->{'user'}\"");
}
}
# useradmin_modify_user(&details)
# Update a mysql user
sub useradmin_modify_user
{
if ($config{'sync_modify'}) {
my ($pg_table, $pg_cols) = &get_pg_shadow_table();
local $s = &execute_sql($config{'basedb'},
"select $pg_cols from $pg_table where usename = '$_[0]->{'olduser'}'");
return if (!@{$s->{'data'}});
local $version = &get_postgresql_version();
if ($_[0]->{'user'} ne $_[0]->{'olduser'}) {
# Need to delete and re-create to rename :(
local @user = @{$s->{'data'}->[0]};
&execute_sql_logged($config{'basedb'},
"drop user \"$_[0]->{'olduser'}\"");
local $sql = "create user \"$_[0]->{'user'}\"";
if ($_[0]->{'passmode'} == 3) {
$sql .= " with password '$_[0]->{'plainpass'}'";
}
elsif ($_[0]->{'passmode'} == 4) {
$sql .= " with password '$user[6]'";
}
&execute_sql_logged($config{'basedb'}, $sql);
}
elsif ($_[0]->{'passmode'} != 4) {
# Just change password
local $sql = "alter user \"$_[0]->{'user'}\"";
if ($_[0]->{'passmode'} == 3) {
$sql .= " with password '$_[0]->{'plainpass'}'";
}
&execute_sql_logged($config{'basedb'}, $sql);
}
}
}
1;