Private

Server IP : 195.201.23.43 / Your IP : 3.141.244.88
Web Server : Apache
System : Linux webserver2.vercom.be 5.4.0-192-generic #212-Ubuntu SMP Fri Jul 5 09:47:39 UTC 2024 x86_64
User : kdecoratie ( 1041)
PHP Version : 7.1.33-63+ubuntu20.04.1+deb.sury.org+1
Disable Function : 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,
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON
Directory : /usr/share/usermin/postgresql/

Upload File :

[ HOME SHELL ]

Current File : /usr/share/usermin/postgresql//useradmin_update.pl

$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;

Private