gnue
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]