| 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
# newdb.cgi
# Create a new database with one optional table
require './postgresql-lib.pl';
&ReadParse();
$access{'create'} || &error($text{'newdb_ecannot'});
&error_setup($text{'newdb_err'});
# Make sure maximum databases limit has not been exceeded
@alldbs = &list_databases();
@titles = grep { &can_edit_db($_) } @alldbs;
if ($access{'create'} == 2 && @titles >= $access{'max'}) {
&error($text{'newdb_ecannot2'});
}
$in{'db'} =~ /^[A-z0-9\.\-]+$/ || &error($text{'newdb_edb'});
$cmd = "create database $in{'db'}";
if (!$in{'path_def'}) {
$in{'path'} =~ /\S/ || &error($text{'newdb_epath'});
$cmd .= " with location = '$in{'path'}'";
}
if (!$in{'user_def'}) {
$cmd .= " with owner=\"$in{'user'}\"";
}
if (!$in{'encoding_def'} && &get_postgresql_version() >= 8) {
$in{'encoding'} =~ /\S/ || &error($text{'newdb_eencoding'});
$cmd .= " encoding = '$in{'encoding'}'";
}
if ($in{'template'}) {
$cmd .= " template = $in{'template'}";
}
&execute_sql_logged($config{'basedb'}, $cmd);
&webmin_log("create", "db", $in{'db'});
if ($access{'dbs'} ne '*') {
$access{'dbs'} .= " " if ($access{'dbs'});
$access{'dbs'} .= $in{'db'};
&save_module_acl(\%access);
}
&redirect("");