[isf-wifidog] Newbie Server install questions

[Proulx François]

I am personnaly running WiFidog on a PowerPC G4-based Macintoshes  
running Mac OS X 10.4.3. Although, I have also installed it on  
Mandrake and I'm running it in production (for Île Sans Fil) on  
Debian. AFAIK, I don't use xinetd on any of these systems.

As I'm pretty lazy, I run my PostgreSQL on my LAN with open  
permissions. (excerpt from pg_hba.conf)

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust

This is nowhere near recommend for production since it opens all the  
ports (but it's much much simpler for developpement since you don't  
have to worry about security). In production on Debian we use (this  
is PostgreSQL 7.4.7, but it should be the same) :

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK            
METHOD
# Database administrative login by UNIX sockets
local   all         postgres                                         
ident sameuser

# All other connections by UNIX sockets
local   all         all                                              
ident sameuser

###### Wifidog Database config
host   wifidog     wifidog     127.0.0.1    255.255.255.255          
password
host   wifidog_dev     wifidog     127.0.0.1     
255.255.255.255         password

# reject all other connection attempts
host    all         all         0.0.0.0           0.0.0.0            
reject





On 30-Dec-2005, at 18:14 , Ray Gwinn wrote:

> Creating the user wifidog and the database wifidog succeeds without  
> errors.
>
> I am currently installing updates on my FC4 system which takes  
> several hours.  I cannot
> make the tests you suggests until that completes.  I re-installed  
> FC4 from scratch so I
> could carefully look for an ident server install option, but found  
> none.
>
> Anyhow, if you are running a linux, do you have a file /etc/ 
> xinetd.d/auth? I think the
> information I need may be in that file even if it is not a FC4  
> system.  Can you look for me,
> and if the file "auth" exists, send it to me?
>
> While you are at it, could you send me a copy of your pg_hba.conf  
> as an example for me
> to use?
>
> From looking at the postgreSQL logs, it seems the ident server is  
> needed by postgreSQL
> to validate the user "wifidog".  The logs indicate 3 attempts to  
> connect to the ident server
> on port 113.  The connection to port 113 is refused on all 3  
> attempts.  The next log entry
> says the user "wifidog" cannot be authenticated.
>
> Ray
>
> On 30 Dec 2005 at 16:41, Proulx François wrote:
>
>> I dont' know much Fedora Core... But if you were able to successfully
>> create the database user, check if you can connect with psql
>>
>> psql -U wifidog wifidog
>> that will connect to the wifidog database with wifidog user. if that
>> does not work check you pg_hba.conf file for permissions
>>
>>
>>
>>
>>
>> On 30-Dec-2005, at 16:35 , Ray Gwinn wrote:
>>
>>>> Well ... If you can actually run the index.php (home page) without
>>>> getting errors, you should be fine
>>>
>>> When I access index.php, I get the following error displayed
>>> "Unable to connect to
>>> database on localhost".
>>>
>>> After looking at log files it seems PostgreSQL needs an ident
>>> server listening on port 113
>>> which I do seem to have running. I cannot figure out what/where the
>>> ident server is on
>>> FC4.
>>>
>>> Reading things on the net, it seems the ident server is controlled
>>> by the file
>>> /etc/xinetd.d/auth.  If you have a file "auth" in the /etc/
>>> xinetd.d/ directory, could you post it
>>> in a message here to give me an idea of what to look for?
>>>
>>> Ray
>>>
>
>