Es ist etwas umständlicher und gefährlicher da etwas zu ändern.
- ich muss mit den Trennen in den Augen lachen, Sorry! Habe an einem großen OpenSource-Projekt gearbeitet, der auf PgSQL aufbaut. Zugriffsrechte bei PgSQL ist ein Sonderthema.
su - postgres
createuser -d -P deinuserpsql -U deinuser (oder postgres)
ALTER USER postgres WITH PASSWORD 'deinpostgrePasswort';# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all postgres 127.0.0.1/32 md5
local all deinuser password
host all deinuser 127.0.0.1/32 password/etc/init.d/postgresql-8.3 restart<?php
$db_handle = pg_connect("host=localhost user=admin dbname=test1");
if ($db_handle) {
echo 'Connection attempt succeeded.';
} else {
echo 'Connection attempt failed.';
}
/*print '<br>Version: '; var_dump(pg_version());
print '<br>tty: '; var_dump(pg_tty());
print '<br>port: '; var_dump(pg_port());
print '<br>parameter-status: '; var_dump(pg_parameter_status('is_superuser'));
print '<br>options: '; var_dump(pg_options());
print'<br>'; var_dump(pg_meta_data($db_handle, "blog_article"));
*/
//$sql = "SELECT * FROM information_schema.tables order by 2,3";
//$sql = "SELECT * FROM information_schema.schemata";
//$sql = "SELECT * FROM pg_database"; // liste aller datenbanken
//$sql = "SELECT * FROM pg_tables order by 1,2";
//$sql = "SELECT * FROM information_schema.columns where table_name = 'blog_article'";
//$sql = "SELECT pg_size_pretty(pg_total_relation_size('blog_article'))";
//$sql = "select * from pg_class, pg_index where pg_class.oid = pg_index.indexrelid" ;
$sql = "select * FROM information_schema.table_constraints where table_name = 'tab3'";
//$sql = "select * from information_schema.key_column_usage order by 6,7";
/*
$sql = "select i.column_name, i.udt_name, i.is_nullable as Field "
. "from information_schema.columns i "
. "left join (select u.column_name as column, u.table_name as tname, constraint_type from information_schema.constraint_column_usage u, information_schema.table_constraints c where "
. "u.constraint_name = c.constraint_name and c.constraint_type <> 'FOREIGN KEY') z "
. "on i.column_name = z.column and i.table_name = z.tname "
. "where i.table_name = 'photo_comment'";
*/
$result = pg_query($sql);
$line1=true;
echo "<table>\n";
while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
if ($line1){
echo "\t<tr>\n";
foreach ($line as $col_name => $col_value) {
echo "\t\t<td>$col_name</td>\n";
}
echo "\t</tr>\n";
$line1=false;
}
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";
pg_close($db_handle);
?>
# Type User CIDR-ADDRESS METHOD
local all all trust
host all all 127.0.0.1/32 trusthost all all 0.0.0.0/0 trustEs wurde versucht, mit einem ungültigen Server-Parameter eine Verbindung herzustellen.
Möglicherweise versucht jemand, in Ihr System einzubrechen.Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, admin and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Apache/2.2.22 (Unix) Server at 192.168.178.20 Port 80
Wenn du das Forum hilfreich findest oder uns unterstützen möchtest, dann gib uns doch einfach einen Kaffee aus.
Als Dankeschön schalten wir deinen Account werbefrei.
