MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

[mv] Interface to SQL



Hello,
	Sorry to brother everyone with this again.  I have just gotten back to
trying to get the demo to work with Postgres.  I have two cats.  One named
"simple" which is an exact clone of the asc "sample" demo base with MiniVend. 
The second is "sample" which is the SQL one.  

	I have remade, tested and installed DBD and DBI.  This time I
deleted the source on DBI after the installation.  I didn't do that the first
time.  I think everythings there.  I have a database in Postgres named
"sample".  This database has a table named "products".  This table is populated
with the data from the products.asc file in the demo.  I believe I have
conformed to the SQL examples in the MiniVend Docs.

	While I think I'm closer but it is still not working.  I know there will
be code in other scripts that must be changed for Postgress to be accessed. 
However I don't believe that would be needed at this point just to connect to
it in the configure script. Here are some code examples:

-----------------------------------
Database	products        products.asc         SQL 
Database	products        DSN	          dbi:Pg:sample:localhost:5432

OR

Database	products	products.asc	SQL
Database	products	DSN		DBI:Pg:sample:localhost:5432

OR

Database	products	products.asc	dbi:Pg:sample:localhost:5432

OR

Database	products	products.asc	DBI:Pg:sample:localhost:5432

All returns this

MiniVend V3.14
Configuring catalog sample...sample config error: DBI connect failed: ERROR: PQconnectdb()
 - Missing '=' after 'sample:localhost:5432' in conninfo

sample: error in configuration. Skipping.
sample: config error. Skipping.
Configuring catalog simple...done.
MiniVend server started in INET and UNIX mode(s) (process id 2900)     
------------------------------------

So I try an equals sign and get this

Database	products	products.asc	SQL
Database	products	DSN	            DBI:Pg:dbname=sample:localhost:5432

OR

Database	products	products.asc	SQL
Database	products	DSN	            dbi:Pg:dbname=sample:localhost:5432

OR

Database	products	products.asc      dbi:Pg:dbname=sample:localhost:5432

All return this:

MiniVend V3.14
Configuring catalog sample...bash$    
-------------------------------------

My setup is:
Postgres 6.5.1
DBI 1.13
DBD 0.92
MinVend 3.14
Perl  5.004..05
RH 5.2
kernel 2.0.36

Any suggestions will be appreciated.
Thanks
Karl


Search for: Match: Format: Sort by: