Changes between Version 7 and Version 8 of doc/auth-server/commonErrors

Show
Ignore:
Timestamp:
10/22/06 02:00:16 (13 years ago)
Author:
gregs@…
Comment:

Added pg_sql security "fix"

Legend:

Unmodified
Added
Removed
Modified
  • doc/auth-server/commonErrors

    v7 v8  
    9292Modify your Apache Server configuration file (httpd.conf) and replace "AddDefaultCharset on" whith "AddDefaultCharset utf-8". 
    9393 
     94----- 
     95 
     96== '''Errors running the install.php script. (This follows the "Database access configuration" page)''' == 
     97 
     98With error logging turned off, you'll get a blank page... and the install script simply "hangs." 
     99(The next steps help confirm that this is the "right" solution.) 
     100 
     101If you turn on error logging by: 
     102{{{ 
     103here's how to turn on php error message display so you can debug problem. 
     104 
     105In php.ini (in FC5 most likely located at /etc/php.ini) enable the 
     106 
     107error_reporting = E_ALL  
     108display_errors = On 
     109 
     110This will display any error encounter in you browser window.  
     111}}} 
     112 
     113Anyway, the error return you get (when you re-run the "install.php" and get to the "hang" screen) will be something like this 
     114{{{ 
     115Postgresql database connection : 
     116Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user 
     117"wifidog" in /var/www/html/wifidog/install.php on line 1062 
     118}}} 
     119 
     120The problem is related to PostgreSQL security. One ideally ought to study up on the security system employed by PGSQL, but this will also fix the problem. Be aware that it might create security issues on different systems depending on your database configuration and such. (Again, learning about the security model will help make sure your box stays secure!) 
     121 
     122Edit the pg_hba.conf file (On different distro's there may be several versions of this file in different locations. Make sure you edit the correct one!) 
     123 
     124{{{ 
     125#TYPE     DATABASE          USER            IP-ADDRESS             SUBNET MASK               METHOD 
     126host      wifidog           wifidog         192.168.0.11           255.255.255.0             md5 
     127}}} 
     128 
     129Where the IP address matches the IP address of the machine connecting to the PGSQL server. (127.0.0.1 works if the PGSQL server is on the same box as the web-server that's running WiFiDOG.) 
     130 
     131Restart the PostgreSQL server to load the new settings. (I use /etc/init.d/postgresql restart - though that's probably not the best way - it does work however.)