[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Problems with the inventory sample
From: |
Alesandro Bottoni |
Subject: |
Problems with the inventory sample |
Date: |
Fri, 20 Sep 2002 20:21:49 +0200 |
User-agent: |
KMail/1.4.1 |
I'm trying to run the "inventory " sample on my RH7.3 (with wxWindows 2.3.2,
wxPython 2.3.2, PostgreSQL 7.X and so on...).
I modified the connection.conf to reflect my local configuration:
[excerpt from the connections.conf file]
[inventory]
comment = GNUe Sample Inventory Database
aliases = inventory
provider = postgresql
host = localhost
dbname = inventory
And I changed my inv_maintenance.gfd (and any other) file accordingly:
[excerpt from inv_maintenance.gfd]
.......
<datasource table="inventory" name="inventory" database="inventory"/>
<datasource table="unit_description" name="available_units"
database="inventory"
prequery=""/>
.......
<database provider="postgresql" dbname="inventory" host="localhost"
name="inventory"
comment=""/>
My PosgreSQL is configured as follows:
--------------------------
inventory=# \d
List of relations
Name | Type | Owner
-------------------------+----------+-----------
company | table | developer
inventory | table | developer
seq_company_id | sequence | developer
seq_unit_description_id | sequence | developer
unit_description | table | developer
(5 rows)
----------------------
inventory=# \dp
Access privileges for database "inventory"
Table | Access privileges
-------------------------+-----------------------------------------------------------
company | {=,developer=arwdRxt,"group inventory=arwd"}
inventory | {=,alex=arwdRxt,developer=arwdRxt,"group
inventory=arwd"}
seq_company_id |
seq_unit_description_id |
unit_description | {=r,developer=arwdRxt,"group inventory=arwd"}
(5 rows)
inventory=#
-----------------------------
I tried any possible login but I'm still getting this error message:
-------------------------------
Error: Unable to log in after 4 attempts.
Error: could not connect to server: Connection refused.
Is the server running on host localhost and accepting
TCP/IP connections on port 5432?
-----------------------------------
Of course, PostgreSQL IS working and listening...(see the shell output
included above)
How can I spot what is not working? Is there any way to see if the PyPreSQL
driver is working? What else can be? Any suggestion?
Thanks in advance.
----------------------
Alessandro bottoni
- Problems with the inventory sample,
Alesandro Bottoni <=