[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