Ok. Undo the changes in mapbender.conf<br>Here it is:<br><br><?php<br># $Id: mapbender.conf-dist 2603 2008-07-08 12:57:06Z christoph $<br># http://www.mapbender.org/index.php/Mapbender.conf<br># Copyright (C) 2002 CCGIS <br> <br># --------------------------------------------<br># type of mapbender database<br># --------------------------------------------<br><br><br>#define("SYS_DBTYPE", "mysql");<br>define("SYS_DBTYPE", "pgsql");<br><br># --------------------------------------------<br># database information<br># --------------------------------------------<br><br>if(SYS_DBTYPE=="mysql")<br>{<br> define("DBSERVER", "<HOST>");<br> define("PORT", "3306");<br> define("DB", "<database>");<br> define("OWNER", "<owner>");<br> define("PW", "<password>");<br> <br> # --------------------------------------------<br> # database with geos functions<br> # --------------------------------------------<br><br> define("GEOS_DBSERVER", "<HOST>");<br> define("GEOS_PORT", "5432");<br> define("GEOS_DB", "<database with geos functions>");<br> define("GEOS_OWNER", "<owner>");<br> define("GEOS_PW", "<password>");<br> <br>}<br>else {<br> define("DBSERVER", "127.0.0.1");<br> define("PORT", "5432");<br> define("DB", "mapbender");<br> define("OWNER", "postgres");<br> define("PW", "postgres");<br><br> define("MD5","true");<br><br> include_once("/var/www/mapbender_2.5/http/php/database-pgsql.php");<br>}<br><br># --------------------------------------------<br># prepared statements (PHP > 5.1.x, PostgreSQL > 7.4)<br># --------------------------------------------<br>define("PREPAREDSTATEMENTS",true);<br><br># --------------------------------------------<br># encoding - default characterset UTF-8 / ISO-8859-1<br># --------------------------------------------<br>define("CHARSET","UTF-8");<br><br># --------------------------------------------<br># error_reporting<br># --------------------------------------------<br><br>//ini_set('error_reporting', 'E_ALL & ~ E_NOTICE');<br><br># --------------------------------------------<br># directory for temporary files<br># --------------------------------------------<br><br>define("TMPDIR", "../tmp");<br><br># --------------------------------------------<br># URL to login<br># --------------------------------------------<br><br>define("LOGIN", "http://141.65.7.61/mapbender_2.5/http/frames/login.php");<br>define("MAXLOGIN", 3);<br>$login = LOGIN;<br><br># --------------------------------------------<br># URL to owsproxy<br># (no terminating slash)<br># --------------------------------------------<br><br>define("OWSPROXY", "http://<ip or name>/owsproxy");<br><br># --------------------------------------------<br># type of server-connection<br># curl, socket, http<br># --------------------------------------------<br><br>#define("CONNECTION", "curl");<br>define("CONNECTION", "http");<br>#define("CONNECTION", "socket");<br><br>define("CONNECTION_PROXY", "127.0.0.1");<br>define("CONNECTION_PORT", "<port>");<br>define("CONNECTION_USER", "<user>");<br>define("CONNECTION_PASSWORD", "<password>");<br><br># --------------------------------------------<br># security: path to modules<br># --------------------------------------------<br><br>define("CHECK", false);<br><br># --------------------------------------------<br># enable/disable portal<br># --------------------------------------------<br><br>define("PORTAL", false);<br><br># --------------------------------------------<br># mail settings for internal mapbender mails <br># smtp mailing<br># for further settings check 'class_administration.php'<br># please check phpmailer for more information<br># --------------------------------------------<br><br>define("USE_PHP_MAILING", "false");<br>define("MAILHOST", "<host>");<br>define("MAILUSERNAME", "<user>");<br>define("MAILPASSWORD", "<password>");<br>define("MAILADMIN", "<mailaddress of the mailadmin>");<br>define("MAILADMINNAME", "<mailadminname>");<br><br>$mailHost = MAILHOST;<br>$mailUsername = MAILUSERNAME;<br>$mailPassword = MAILPASSWORD;<br> <br># --------------------------------------------<br># wms monitoring<br># --------------------------------------------<br><br>define("AUTO_UPDATE", "0");<br>define("TIME_LIMIT", "300");<br>define("PHP_PATH", "/usr/local/bin/");<br><br># --------------------------------------------<br># Mapbender error logging<br># --------------------------------------------<br><br>define("LOG_LEVEL", "error"); //"off","error","warning","notice" or "all"<br>define("LOG_JS", "on"); // "on", "alert", "console" or "off"<br><br># --------------------------------------------<br># Internationalization<br># --------------------------------------------<br><br>define("USE_I18N", false); // requires gettext for PHP. <br> // If "false", LANGUAGE is set to english<br>define("LANGUAGE", "en"); // only available if USE_I18N is "true". <br> // "en", "de", "bg", "gr", "nl", "it", es"<br><br>###HACK for GLOBALS<br>$DBSERVER=DBSERVER;<br> $DB=DB;<br> $OWNER=OWNER;<br> $PW=PW;<br> <br> $GEOS_DBSERVER=GEOS_DBSERVER;<br> $GEOS_DB=GEOS_DB;<br> $GEOS_PORT =GEOS_PORT;<br> $GEOS_OWNER=GEOS_OWNER;<br> $GEOS_PW=GEOS_PW;<br>?><br><br>And here the ERROR message from log-file:<br>2009.01.08, 16:52:45,ERROR: Error while executing prepared statement in /var/www/mapbender_2.5/http/frames/login.php: Sql: SELECT mb_user_login_count FROM mb_user WHERE mb_user_name = $1, Error: FEHLER: keine Berechtigung für Relation mb_user (...no authorization)<br><br>Greetings,<br>Christian<br><br>----- Ursprüngliche Nachricht -----<br>Von: Thomas Baschetti <Thomas.Baschetti@gmx.de><br>Datum: Donnerstag, 8. Januar 2009, 16:49<br>Betreff: [Mapbender-users] Unable to login (function.pg-connect)<br>An: Mapbender User List <mapbender_users@lists.osgeo.org><br><br>> Hi,<br>> <br>> > die entsprechenden Einträge in der mapbender.conf habe ich gemacht,<br>> > allerdings hatte sich dort wohl ein Denkfehler eingeschlichen. <br>> Hatte unter host<br>> > = 127.0.0.1 angegeben, da ja alle Anwendungen und Datenbanken <br>> auf dem<br>> > selben Server laufen. <br>> <br>> 127.0.0.1 should work.<br>> <br>> > Nun habe ich das mal in die korrekte IP-Adresse geändert.<br>> <br>> which gives the problem below.<br>> <br>> > Warning: pg_connect() [function.pg-connect]: Unable to <br>> connect to<br>> > PostgreSQL server: FATAL: fehlende oder fehlerhafter <br>> pg_hba.conf-Datei <br>> <br>> yes, because your connect now comes from the "correct" Ip-<br>> Adress,but your pg_hba.conf only allows 127...<br>> nothing won like this ;-)<br>> <br>> Please post your mapbender.conf.<br>> What did mapbender_setup.php say?<br>> <br>> Ciao<br>> Thomas<br>> <br>> -- <br>> Thomas Baschetti<br>> -- <br><br><br>