Re: [mv] Interface to SQL

["Tamás Kõhegyi" <tkohegyi@gw.cdk.bme.hu>]

Hi Karl,

Use this:
Database products        products.asc         SQL
Database products        DSN           dbi:Pg:dbname=sample

I hope this works.
You also have to create 'sample' database in the postrgesql.

Regards,
Tamas



----- Original Message -----
From: Swisher, Karl <kswisher@iolinc.net>
To: <minivend-users@minivend.com>
Sent: Thursday, October 21, 1999 22:39
Subject: [mv] Interface to SQL


> ******    message to minivend-users from kswisher@iolinc.net (Swisher,
Karl)     ******
>
> 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
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>