X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/eb0b3bfa4cd74ee9e425c54868a30d8859e694cd..ac116980ac78b74dbc1e0ae7ff2d329d7e581ba5:/lib/cmd.php diff --git a/lib/cmd.php b/lib/cmd.php index dc1af325..b72c1bb4 100644 --- a/lib/cmd.php +++ b/lib/cmd.php @@ -1,5 +1,7 @@ getMessage(), $oSql->userinfo); + foreach ($GLOBALS['aWarnings'] as $sMsg) { + echo ' * ',$sMsg."\n"; + } +} + + +function runSQLScript($sScript, $bfatal = true, $bVerbose = false, $bIgnoreErrors = false) +{ + // Convert database DSN to psql parameters + $aDSNInfo = \Nominatim\DB::parseDSN(CONST_Database_DSN); + if (!isset($aDSNInfo['port']) || !$aDSNInfo['port']) $aDSNInfo['port'] = 5432; + + $oCmd = new \Nominatim\Shell('psql'); + $oCmd->addParams('--port', $aDSNInfo['port']); + $oCmd->addParams('--dbname', $aDSNInfo['database']); + if (isset($aDSNInfo['hostspec']) && $aDSNInfo['hostspec']) { + $oCmd->addParams('--host', $aDSNInfo['hostspec']); + } + if (isset($aDSNInfo['username']) && $aDSNInfo['username']) { + $oCmd->addParams('--username', $aDSNInfo['username']); + } + if (isset($aDSNInfo['password'])) { + $oCmd->addEnvPair('PGPASSWORD', $aDSNInfo['password']); } + if (!$bVerbose) { + $oCmd->addParams('--quiet'); + } + if ($bfatal && !$bIgnoreErrors) { + $oCmd->addParams('-v', 'ON_ERROR_STOP=1'); + } + + $aDescriptors = array( + 0 => array('pipe', 'r'), + 1 => STDOUT, + 2 => STDERR + ); + $ahPipes = null; + $hProcess = @proc_open($oCmd->escapedCmd(), $aDescriptors, $ahPipes, null, $oCmd->aEnv); + if (!is_resource($hProcess)) { + fail('unable to start pgsql'); + } + + if (!$bVerbose) { + fwrite($ahPipes[0], 'set client_min_messages to WARNING;'); + } + + while (strlen($sScript)) { + $iWritten = fwrite($ahPipes[0], $sScript); + if ($iWritten <= 0) break; + $sScript = substr($sScript, $iWritten); + } + fclose($ahPipes[0]); + $iReturn = proc_close($hProcess); + if ($bfatal && $iReturn > 0) { + fail("pgsql returned with error code ($iReturn)"); + } +} + +function setupHTTPProxy() +{ + if (!CONST_HTTP_Proxy) { + return; + } + + $sProxy = 'tcp://'.CONST_HTTP_Proxy_Host.':'.CONST_HTTP_Proxy_Port; + $aHeaders = array(); + + if (CONST_HTTP_Proxy_Login != null + && CONST_HTTP_Proxy_Login != '' + && CONST_HTTP_Proxy_Password != null + && CONST_HTTP_Proxy_Password != '' + ) { + $sAuth = base64_encode(CONST_HTTP_Proxy_Login.':'.CONST_HTTP_Proxy_Password); + $aHeaders = array('Proxy-Authorization: Basic '.$sAuth); + } + + $aProxyHeader = array( + 'proxy' => $sProxy, + 'request_fulluri' => true, + 'header' => $aHeaders + ); - return $oSql; + $aContext = array('http' => $aProxyHeader, 'https' => $aProxyHeader); + stream_context_set_default($aContext); }